PASS Rocks SQL Saturday

I had another piece that looked at some issues with PASS slated for today, but it’s been a tough morning....

People Helping People – Volunteers

Continuing on with things that PASS does well, since I want to be balanced, I wanted to talk about volunteers....

Reblog: September 19 to September 25

Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...

Re-Indexing - The quest of ultimate automation

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...