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

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

The BaCON Debacle, or Who’s Mike?

Who is Mike in the business intelligence/analytics world?
Is it Mike White? If it is, he’s the guy I call for...

A Bad Day with Backups

I learned a hard lesson when I first started as a DBA.  Although to be honest, it’s not a lesson...

SQLSaturday Orlando Marketing Plan-Part 47

Notes:
We sent out a final you haven’t paid for lunch reminder on Wed, asked for a reply if they were...

An Amazing Conference

I said that I’d write about some good things PASS does, and I’ll make it a point to do so....

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