[SQL Snacks Video] The Basics of Joins

This is a special edition for SQL Snacks.  It is one (of many hopefully) SQL Snacks that has been recorded...

Bad Ideas: Alert Storming

Fellow DBA: There are so many alerts! It takes me a long time to get through them all. How do...

Issue with sys.dm_db_index_usage_stats in SQL Server 2012

I’d be struggling to remember a week where I hadn’t run a query against the dmv sys.dm_db_index_usage_stats to find unused...

Last Weeks Top “Reading” Links #74

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Look At The SQLSaturday Orlando Home Page

One of the weaknesses of the current SQLSaturday tool set is that the front page isn’t strong by default. It...

Two Digit Dates in SQL – MM/DD/YYYY

When creating dates or numbers as strings it is sometimes required to have two digit numbers.
For example, instead of...

Two Digit Dates in SQL – MM/DD/YYYY

When creating dates or numbers as strings it is sometimes required to have two digit numbers.

For example, instead of this:...

Doing it with the EzAPI

In my last post, I attempted to write a SQL Server Integration Services (SSIS) Package programmatically.
I used the API that...

VMware Certification Changes

The last twelve months in my certification world have been rather odd. First, Microsoft has terminated their Microsoft Certified SQL...

Auditing VMware vCenter Actions (on SQL Server)

When you’ve got a SIEM appliance or application, you want actions and events going into it as a central repository....