A View Is Not A Table

Blog post #4 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel
In SQL Server, in the T-SQL you use to query...

Query Store and Optimize For Ad Hoc

I love presenting sessions because you get so many interesting questions. For example, what happens with Optimize for Ad Hoc...

Views and Simplification

I’ve been getting lots of questions on views lately. Must be something in the water.
Because SQL Server allows you to...

Speaker of the Month: April 2016

THIS IS NOT AN APRIL FOOL POST!
Seriously.
My Speaker of the Month for April 2016 is Keith Tate (b|t) and his...

Do You Teach Azure Data Platform?

I offer instruction on the Azure Data Platform, and have for about six years, since shortly after it came out....

Cross Database Query in Azure SQL Database

You can’t query across databases in Azure SQL Database… or can you?
Let’s check. I’ve created two new databases on an...

Happy Dance!

I’m all like:

Because I saw this on an eval:
I’ve been trying to ramp up to take advantage of my MSDN...

PASS Board 2016: Update #2

Time flies. I didn’t notice that I hadn’t posted an update in February.
There’s been a lot going on since I...

Leadership Lessons

Not for you, for me.
I’m sure you’ve heard the statement: Praise in public. Criticize in private.
I agree with this approach....

Opportunities To Talk

It’s weird being an introvert who likes to talk to people, but what can I do. I like talking to...