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

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

Experienced DBA: Rookie Mistake

M.A.S.H 4077.  Mobile Army Surgical Hospital.  One of my all time favorite TV shows that I still watch to this...

Monday Coffee – Lab Environments

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

Setting up the Power BI Report Server Preview

Last week on May 17th the Power BI team announced the release of the Power BI Report Server preview. Power...

SQL Server – Service Terminated

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

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

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