SQL Homework – July 2019 – Table Size

In general this homework series is meant to give you ideas of things to play with that most if not ... Continue reading

Weekly reading #20

Being MVP for the #11 straight year is something unique! Thank you! The first week of July has just started. So oficially we have started vacations and the team...

Thanks for Joining us at SQLSaturday Pensacola!

Thanks for joining us at #SQLSatPensacola!The 8:30am Careers in Technology panel featured lots of talk about Twitter, so might as well mention that the panelists were (in audience's order,...

Powershell script to find SQL Server instances on remote servers

This is actually part 2 of a process I am creating to automatically discover SQL Server instances in an Active Directory domain. So there will be a series of...

T-SQL Tuesday #115 – Dear 20-Year-Old Self

This month’s T-SQL Tuesday blog is brought to us by Mohammd Dorab (b | t) and this month topic is about what you would tell your 20-year-old self now...

T-SQL Tuesday #115 – Notes to 20 year old Wayne

  There’s a lot that goes on in June. From the 75th anniversary of D-Day, Fathers Day, to the official start of summer (though it feels like it already!)....

Detail Job History – Back to Basics

With this script, I have the ability to quick show which step is failing, what the command is for that step, what kind of process is running on that...

Detail Job History – Back to Basics

With this script, I have the ability to quick show which step is failing, what the command is for that step, what kind of process is running on that...

Find clustered index on non primary key columns

First, some blah... blah... blah...

By default when a primary key constrained is created on a table/view,  SQL Server automatically creates a unique clustered in order to enforce it.  And...

It’s interesting how an OR short circuits.

I recently did a post on the case expression short circuting and received a very very interesting comment from Chad ... Continue reading