What Is SQL Saturday?

I was recently approached and asked, “What is SQL Saturday? I actually get asked that question more times than not...

Learning Azure From The Web

I’m working on a technical blog post that I hope to be putting up soon. I’ve run into a number...

Hiding tables in SSMS Object Explorer

Extended Properties
Sometimes you find out the strangest things about SQL Server. I’ve written about extended properties before but had no...

Sampling Distribution and Central Limit Theorem

In this post am going to explain (in highly simplified terms) two very important statistical concepts – the sampling distribution and central...

Test the SQL Server database collation with PowerShell and dbatools

If your server collation is different to your database collation then you may find that you get an error similar...

How to Become a SQL Server Database Administrator

I wrote How to Become a SQL Server Database Administrator (email address required for download) a few years ago as a project...

Olcot and Arratoon Ancestry

I have spent a fair amount of time researching the Olcot and Arratoon ancestry and I am very interested in the family tree, especially pre 1900 in India. If...

Tuga IT 2017 Tickets are on sale

I am glad to announce thatTuga IT 2017 Tickets are finally on sale!

Wait a second, you might think – on sale?...

Monday Coffee 2017-04-03

Last week Pass announced changes to how speakers are going to be selected for their annual conference (you can read...

Monday Coffee 2017-04-03

Last week Pass announced changes to how speakers are going to be selected for their annual conference (you can read...