Can You Hear It Now?

Here is a quick blog to show you something I discovered that I didn’t know existed.
I was on a Skype...

Database Fundamentals #16: Removing Data With T-SQL

Deleting data from a table using T-SQL works quite a lot like the UPDATE statement.

How it Works
In the same way...

DAX IF & Switch Statement Performance – Does Order Matter?

Intro
I’ve written a couple of article about IF & SWITCH in DAX over the past few years. Recently I noticed that...

Farewell, Tom Roush

My friend Tom died yesterday. I just heard the news a few hours ago and while it will take some...

I’m a Speaking Mentor!

I am so excited to announce that I have been accepted as a speaking mentor on SpeakingMentors.com!
I struggled for so...

Speaking at SQLSaturday 725 in Victoria

Victoria is on an island off the coast of Vancouver, British Columbia. The island is wisely called Vancouver Island. It...

SSMS Activity Monitor (Day 31)

SSMS provides an Activity Monitor, a process that displays various information about what all is going on with the instance....

Surround Code with Comments in SQL Prompt

I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things...

The difference between blogging about something you know, and something you are learning (Love blogging! Live!)

Close but you need to blog about learning while blogging about the difference of blogging when you are learning something...

The world of Automatic Tuning – SQL Server 2017

Times are changing, 10 years ago I would never have thought that self-tuning databases would be available as a packaged...