Martin Bell UK SQL Server MVP - All Comments

re: Vital Statistics

NeilHambly — Fri, 27 Jan 2012 22:48:54 GMT

Martin - funnily I did a few recent blog posts on Stat's cardinality and the useful

DBCC SHOW_STATISTIC with STAT_HEADER JOIN DENSITY_VECTOR

my automated collection script for this can be found @

sqlblogcasts.com/.../neilhambly

sqlserver by alligin - Pearltrees

sqlserver by alligin - Pearltrees — Sun, 08 Jan 2012 12:47:42 GMT

Pingback from sqlserver by alligin - Pearltrees

Cambiar el COLLATION de una base de datos y todas las columnas

Blog de Jose Mariano Alvarez — Fri, 11 Nov 2011 05:10:37 GMT

Cambiar el COLLATION de una base de datos y todas las columnas

re: Changing database collations with Powershell

JMAlvarez — Fri, 11 Nov 2011 04:26:08 GMT

Excellent script. I've used it twice and it worked perfect.

There is an small error in the script that is repeated in all functions that generate the TSQL scripts. It only occurs when connecting to the database using a username and password for SQL Server authentication .

On the line where says

$Scripter=New-Object ("Microsoft.SqlServer.Management.Smo.Scripter") ($srv.Name) ;

Should read.

$Scripter=New-Object ("Microsoft.SqlServer.Management.Smo.Scripter") ($srv)

The "Smo.Scripter" object constructor parameter is an object of type "Smo.Server" and if not valid it try to use Windows credentials.

Please, apologize my english.

Returning GUID values to ADO.NET clients

Martin Bell UK SQL Server MVP — Fri, 04 Nov 2011 20:51:28 GMT

My previous post showed how to return a database generated GUID as a stored procedure parameter, but if more than one GUID is generated what do you do?

Dew Drop – November 1, 2011 | Alvin Ashcraft's Morning Dew

Dew Drop – November 1, 2011 | Alvin Ashcraft's Morning Dew — Tue, 01 Nov 2011 13:35:01 GMT

Pingback from Dew Drop – November 1, 2011 | Alvin Ashcraft's Morning Dew

Using Powershell to remove strings in files

Martin Bell UK SQL Server MVP — Mon, 31 Oct 2011 22:26:54 GMT

One problem with building databases using batch files is the sys,sys_dependencies messages.

Finance Search – SQL Server Management Studio Express CTP

Finance Search – SQL Server Management Studio Express CTP — Tue, 18 Oct 2011 23:24:49 GMT

Pingback from Finance Search – SQL Server Management Studio Express CTP

Dew Drop – August 29, 2011 | Alvin Ashcraft's Morning Dew

Dew Drop – August 29, 2011 | Alvin Ashcraft's Morning Dew — Mon, 29 Aug 2011 12:19:16 GMT

Pingback from Dew Drop – August 29, 2011 | Alvin Ashcraft's Morning Dew

Volume Freespace

Martin Bell UK SQL Server MVP — Wed, 27 Jul 2011 20:14:54 GMT

In my last blog post I talked about a problem where the incorrect permissions on a mount point directory