Be Aware of CARTESIAN PRODUCT When Using Join Keys in SQL

I got a massive satisfaction last week when I was able to bring down the execution time of a sql...

SQL Server Monitoring: Creating your own metrics

The one and only important factor in monitoring is data. How much of x and how little of y? If...

SQLSat Pcola 2017 Security Principals and Permissions

Great attendance and awesome questions from my afternoon session on "SQL Security Principals and Permissions". As promised, both the demo...

VSTS– Hosted Agent is the Default for Releases

In keeping with the idea I don’t want this to get out of date, this is VSTS as of Jun...

Database Fundamentals #1: Install SQL Server

To get started with SQL Server, you need to install it. However, I’m not going to teach you how to...

Backup to NUL

Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In...

Endpoint Owners – Back to Basics

"What the heck is an endpoint?" Well, that is a good question. An endpoint in the simplest form is a connection or point of entry into SQL server.
Related Posts:

Changing...

Endpoint Owners – Back to Basics

Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...

SQL Server – Service Terminated

I had a messy (another one) day, last thing I wanted was a “broken” SQL Server instance where I was...

Monday Coffee – Lab Environments

Having a lab environment is an absolute must for any IT professional. You need somewhere that you can test out...