Martin Bell UK SQL Server MVP - All Comments

A New Default Profiler Template

Martin Bell UK SQL Server MVP — Sun, 03 Jun 2012 19:59:07 GMT

I wrote a new Default Profiler Trace Template because MS said they wouldn't

PAL and SQLDiag with SQL Server 2012 | My Love with SQL Server | Scoop.it

PAL and SQLDiag with SQL Server 2012 | My Love with SQL Server | Scoop.it — Fri, 25 May 2012 04:44:19 GMT

Pingback from PAL and SQLDiag with SQL Server 2012 | My Love with SQL Server | Scoop.it

Dew Drop – May 8, 2012 (#1,322) | Alvin Ashcraft's Morning Dew

Dew Drop – May 8, 2012 (#1,322) | Alvin Ashcraft's Morning Dew — Tue, 08 May 2012 11:41:55 GMT

Pingback from Dew Drop – May 8, 2012 (#1,322) | Alvin Ashcraft's Morning Dew

Changing SQL Server Port with Powershell

Martin Bell UK SQL Server MVP — Mon, 07 May 2012 16:56:46 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.

Changing SQL Server Port with Powershell

Martin Bell UK SQL Server MVP — Mon, 07 May 2012 16:56:43 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.

SCCM 2012 failing pre-req check (SQL Perms)

SCCM 2012 failing pre-req check (SQL Perms) — Tue, 28 Feb 2012 07:38:50 GMT

Pingback from SCCM 2012 failing pre-req check (SQL Perms)

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.