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...

SQL Server Application Roles

If you’re using Windows Authentication then you probably have a database user for each user of your application or at...

SQLSaturday Orlando 2017 Goes Live

Today we’re starting on our 11th SQLSaturday here in Orlando. Normally we rotate the leadership between oPASS and MagicPASS, but...

Top Function – Performance Gain

Recently, I presented at Singapore SQL Pass Chapter on the topic T-SQL Fun, and the most of the attendees were...

An Unexpected Side-Effect of Invoke-WebRequest

Recently I was working on a bit of PowerShell to download the awesome First Responder Kit from Brent Ozar Unlimited. The canonical URL for the FRK is http://firstresponderkit.org/ but...