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

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

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

Power BI Custom Visuals Class (Module 106 – Ring Chart MAQ Software)

In this module you will learn how to use the Ring Chart by MAQ Software. The Ring Chart is similar...

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

Temporary Post Used For Theme Detection (84fc925e-61af-4c19-b75b-9b99021b1635 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (e4f4591b-a7d5-4be4-937e-8d6230ec51d8 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

Collation considerations to create robust queries

Is your code "This" robust?What is Collation? In short words: are the sorting rules, case, and accent sensitivity properties for...

Notes on the May 2018 SQLOrlando Meetup

Late writing notes!
55 registered, 28 attended. Not bad, and about on track for expected 50% drop. Really, 28 made for...