Re-Indexing - The quest of ultimate automation

Re-Indexing - The quest of ultimate automation

Re-Indexing – The quest of ultimate automation

In this session, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a...

Wait Statistics #4 LCK_M_xx

In the 4th article of the Wait Statistics series we will dive into LCK_M_xx waits. This is another wait type...

Why I’m Only Casting One Vote This Year in the PASS Election

First, a reminder/disclaimer that I am serving on the PASS NomCom this year. The four candidates in the election are...

Convert UK Postcode to Latitude/Longitude/Northing/Easting using SQL CLR

Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...

Convert UK Postcode to Latitude/Longitude/Northing/Easting using SQL CLR

Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...

Four Big Things PASS Could Do Next Year

Here’s my wish list:
Fix the membership problem. One voter, one vote. That’s what we want. The current hack of requiring...

Installing SQL Server 2014 Language Reference Help from disk

Some weeks ago I had to wipe my machine and reinstall everything from scratch, SQL Server included.
For some reason that I...

Presto Chango

About six months ago, I wrote a post reviewing a book titled The Phoenix Project. In that post, I compared...