Martin Bell UK SQL Server MVP

PAL and SQLDiag with SQL Server 2012

MartinBell — Thu, 24 May 2012 22:56:00 GMT

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

MartinBell — Sun, 20 May 2012 18:38:00 GMT

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

MartinBell — Mon, 07 May 2012 16:48:00 GMT

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

MartinBell — Wed, 15 Feb 2012 20:42:00 GMT

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

MartinBell — Sun, 05 Feb 2012 11:48:00 GMT

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...(read more)

Vital Statistics

MartinBell — Sat, 21 Jan 2012 22:06:00 GMT

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

MartinBell — Thu, 08 Dec 2011 19:23:00 GMT

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

MartinBell — Wed, 07 Dec 2011 16:14:00 GMT

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

Calling DTUtil recursively from Powershell

MartinBell — Thu, 01 Dec 2011 22:47:00 GMT

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

MartinBell — Mon, 31 Oct 2011 22:12:00 GMT

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