10 Years Young

It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the...

It’s Azure T-SQL Tuesday #103

I’m slightly surprised that there haven’t been more invitations about Azure, with the main development branch of SQL Server being...

Getting Started with Mssql-cli tool

A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements and business...

I’m published at Simple-Talk!

My first article has gone live at Simple-Talk! Thanks to Aunt Kathi for the opportunity!
Detecting Data Breaches
I’m also still writing...

Moving to Azure: A change in processes – TSQL Tuesday 103

For this month’s t-sql Tuesday our host Bjoern Peters (b/t) wants us to describe our experiences with Azure SQL Database...

Prioritizing Index Performance Pains – What I Learned From Brent Ozar’s Master Index Tuning Class

I love continuing my education in SQL Server.  Recently I was fortunate enough to take Brent Ozar’s 3-day live online...

Prioritizing Index Performance Pains - What I Learned From Brent Ozar's Master Index Tuning Class

Watch this week's video on YouTube
I love continuing my education in SQL Server.
Recently I was fortunate enough to take Brent Ozar's 3-day live online Master Index Tuning training class.
Since...

Prioritizing Index Performance Pains - What I Learned From Brent Ozar's Master Index Tuning Class

Watch this week's video on YouTube
I love continuing my education in SQL Server.
Recently I was fortunate enough to take Brent Ozar's 3-day live online Master Index Tuning training class.
Since...

Changing the Collation of the Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?

Demystifying What “sqlservr -q” Actually Does
(last updated: 2019-01-07 @ 02:25 EST / 2019-01-07 @ 07:45 UTC )
For various reasons, people sometimes find themselves...

More Changes to PoshSSDTBuildDeploy - DeployReport Information

Hello!

This is going to be a short one because I’ve been working hard all evening on this, and frankly I’m a little tired. But I’ve made a change to...