Martin Bell UK SQL Server MVP

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)

Exciting times for the UK SQL Server community

2011-09-10T10:37:00Z

An exciting and busy few weeks for the UK SQL Server community are coming up at the end of this month. ...(read more)

My BIG problem with SQL Server Denali!

2011-08-27T12:48:11Z

In the last couple of weeks I’ve done 3 talks on new features for developers in SQL Server Denali and hit the same problem each time; which is, I have run out of time. The reason for this is that there are so many interesting new feature coming out in the next version of SQL Server, it is so difficult to decide what you’re going to miss out! This will probably mean in future I will have to do more specific sessions and it will take a lot of discipline not to go off on a tangent and talk about the...(read more)

Volume Freespace

2011-07-25T21:08:00Z

In my last blog post I talked about a problem where the incorrect permissions on a mount point directory causes a spurious error message regarding space on the root drive. Whilst investigating the problem I needed to find out the space available on the mounted drive. Unlike normal directories the information isn’t immediately obtainable when you look at the properties of the mount point directory when you use windows explorer. With mount points you have to take a further step to view the properties...(read more)

Mount point permission issues

2011-07-06T20:56:00Z

I came across this problem with mount points, unfortunately the error message is very misleading....(read more)