SQL Server – Internals of sp_spaceused

This article is an effort to dissect the output of the sp_spaceused stored procedure.

Introduction
Understanding the database usage internals and the growth trends...

tSQLt Course

In the last half of 2017, I decided to run a tSQLt course and went down the route of putting together a free 12-week email course. The intention was...

tSQLt Course

In the last half of 2017, I decided to run a tSQLt course and went down the route of putting...

tSQLt Course

In the last half of 2017, I decided to run a tSQLt course and went down the route of putting...

Forensic Analysis of Log files in SQL Server

The Importance of Log Files in SQL Server
On the SQL server every day we perform many transactions and as we...

Giving back – Speaking Mentors

I’ve been incredibly lucky in my career. I’ve somehow managed to meet and become friends with highly talented people who...

How to write a PowerShell function to use Confirm, Verbose and WhatIf

In my last blog post I showed how to run a script with the WhatIf parameter. This assumes that the...

Learning Goals–January Review

In December I participated in T-SQL Tuesday #97 and wrote a post about 2018 goals. I promptly spent two weeks...

PASS Summit 2017 Wrap-Up - The People!

I need a new social media profile picture.
That’s one of the most important (non-technical) conclusions I drew from my week at PASS Summit 2017. It seemed like everywhere I...

SQL Homework – February 2018 – Work with security

This month let’s create some security!
Create logins: GUI 5 pts/Script 5 pts

Create a SQL login and a Windows authenticated login....