Two Types of Performance Counters

I had an issue where an instance of SQL Server was only showing the XTP (In Memory) performance counters. None...

Understanding Cosmos DB

Cosmos DB is an awesome product that is mainly used for large-scale OLTP solutions.  Any web, mobile, gaming, and IoT application that...

Understanding Cosmos DB

Cosmos DB is an awesome product that is mainly used for large-scale OLTP solutions.  Any web, mobile, gaming, and IoT application that...

Plan Metrics Without the Plan: Trace Flag 7412

I place a lot of emphasis on capturing actual execution plans because of the runtime metrics, but with Trace Flag...

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