Modernizing Your T-SQL: The Sequence Object

This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server.
Last year, you finally retired the last of your SQL Server...

"What did it take to become a MVP?"

@william_a_dba what did it take to become a MVP?— kennyb7322 (@kennyb7322) March 3, 2020

This tweet made me pause. I'll explain.Backstory (skip if you're not interested):On Sunday March 1,...

Improved VMware vCenter Performance Metric Logging

By default, the vSphere vCenter deployment contains a virtual appliance where the VMware management and orchestration platform, vCenter, resides and runs from. The default performance metric statistics collection interval...

Extended Events: system_health and a Long Running Query

Wouldn’t it be great to just quickly and easily take a look at your system to see if you had any queries that ran for a long time, but,...

Telecommute Resources

This is a summary of potential resources for any tech person who is interested in working from home – temporarily or full time. It came about from a twitter...

Notes from SQLSaturday Tampa 2020

The notes! Attendance was the speaker dinner was great! Always nice to have a lot of people there. During the day logistics all went well, though it’s still a...

Thanks for joining us at SQLSaturday Baton Rouge 2020 Business Intelligence edition

Thanks for joining us at the first annual SQLSaturday Baton Rouge Business Intelligence yesterday, put on by the Baton Rouge Analytics and Intelligence Network (#GOBRAIN!), an official chapter of...

A trusty old friend – The BCP utility

One of the requirements that springs up around data stores – regardless of if they are relational, not relational, cloud based or some other variety is (unsurprisingly) the need...

The four tenets of ETL testing

Every ETL pipeline is only ever as reliable as the data that the upstream system provides. It is inevitable that assumptions you make about the data you are provided...

The four tenets of ETL testing

Every ETL pipeline is only ever as reliable as the data that the upstream system provides. It is inevitable that assumptions you make about the data you are provided...