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

What is an Event-Less Extended Event Session?

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

Making Sense of the Power BI Ecosystem Presentation Materials

I just wrapped up my first presentation on Making Sense of the Power BI Ecosystem at SQL Saturday #755 in...

Double Win- Watch DeWitt and Help SQLSoldier's Loved Ones!

Brent Ozar (blog/@BrentO) is sponsoring a special webcast in a couple weeks, with an amazing presenter:

https://www.brentozar.com/archive/2018/06/announcing-a-very-special-sqlfamily-webcast-with-dr-david-dewitt/
The webcast (“SQL Query Optimization....

Building a Personal VPN Azure Solution

Since joining Denny Cherry & Associates Consulting, I tend to travel about once a month.  This isn’t a huge amount and...

Project Euler

I like having problems to practice solving in computer science. It can be a fun hobby, and it exercises your...

No @@ServerName on Linux

I setup a new instance of SQL Server on Linux some time ago. At the time, the Linux machine didn’t...

Removing the time element from a datetime

Killing Time – or removing the time element from a datetime
Over the course of time, we all collect scripts and routines...

SQL in the City Streamed: June 2018

Next week, Redgate Software, will be putting on SQL in the City Streamed. These events are a great way to...

Upcoming: Speaking on permissions at PASS Summit 2018 and 24 Hours of PASS

I’m excited to announce that I’ve been selected to present at the PASS Summit! This will be my fourth year speaking at the Summit, and it’s always a privilege....