Martin Bell UK SQL Server MVP

PAL and SQLDiag with SQL Server 2012

2012-05-24T22:56:00Z

After a new release you may expect a delay in updating codeplex projects to the latest SQL Server version. Here are some tips on using PAL and SDCT until a version that officially supports SQL Server 2012 is available....(read more)

Changing Server Side Trace Scripts

2012-05-20T18:38:00Z

All though Server Side Traces are being depricated they will still be around for some time. This nuggets of code may help make them easier to use....(read more)

Changing SQL Server Port with Powershell

2012-05-07T16:48:00Z

Powershell will be even more important when managing SQL Server on Windows Server Core so it's time to build up your toolbox of scripts....(read more)

sp_refreshview

2012-02-15T20:42:00Z

When dealing with SQL Server errors “When you have eliminated the obvious, whatever remains, however improbable, must be the truth?” ...(read more)

Chris Date in Edinburgh

2012-02-05T11:48:00Z

Chris date is returning to the UK on June 7th and 8th. Details of the course titled "Normal Forms and All That Jazz: A Database Professional's Guide to the Theory of Database Design" can be found at http://www.justsql.co.uk/chris_date/cjd_edin_may_2012.htm This will appeal to everyone from Architects, DBAs and Developers and is based on his latest book due to be published soon. Having attended one of Chris’ courses in the past, I know what a great teacher he is. To register email: rde...(read more)

Vital Statistics

2012-01-21T22:06:00Z

I was asked if there was any DMVs that could tell you if a statistic needed to be updated.....(read more)

Powershell Snapins with SQL 2012

2011-12-08T19:23:00Z

When you make the convert your powershell scripts to run on SQL Server 2012 it won't be able to simple task of loading the SqlServerCmdletSnapin110 and SqlServerProviderSnapin110 snapins...(read more)

SQLBits X–Registrations are open

2011-12-07T16:14:00Z

SQLBits X Registration are open....(read more)

Calling DTUtil recursively from Powershell

2011-12-01T22:47:00Z

Using DTUtil to load SSIS packages is very easy if all the files are in one directory or go to one destination. If they aren't using Powershell will be useful....(read more)

Using Powershell to remove strings in files

2011-10-31T22:12:00Z

One problem with building databases using batch files is the sys,sys_dependencies messages....(read more)