Database Restores – Zeroing Out Log Files

I recently came across a question on the #sqlhelp Twitter feed that I thought was interesting.  The question pertains to...

Unit testing with SQL Server article on SQLServerCentral.com

My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).

You...

Unit testing with SQL Server article on SQLServerCentral.com

My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).

You...

tSQLt with TRY..CATCH

Someone asked me the question recently about how tSQLt works with TRY..CATCH blocks and the exceptions that we might test...

I am a Superhero

Two weeks ago I attended SQLBits in London. This is probably the biggest SQL Server conference in Europe, and this...

Toshiba Portege Z301-A Review

Last year I purchased a Lenovo W530. Nightmares then ensued. Nice laptop if you just want to use it as...

Clean out all bad characters from a string.

I have a customer who is having a problem with a load. He is getting a fair number of bad...

The Idea Book

How many times have you said to yourself, “Someone should build an application that does [x]…”, or “Wouldn’t it be...

Welcome to BlobEater

I am an IT Professional from the UK with a huge interest in MS technology especially SQL Server and Azure. During...

Gotcha! PowerShell Array Initialization, Difference between PowerShell 2.0 and 4.0

I like to initialize my arrays by strongly typing my variable as an array, and setting it to null. PowerShell...