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

Query To Retrieve Statistics Data: dm_db_stats_histogram

Starting with SQL Server 2016 Sp1 CU2, a new way of directly querying statistics, specifically the histogram, has been introduced:...

Spreading Job Run Times Out on an MSX/TSX Scheduled Job

Problem
My company heavily uses MSX/TSX jobs for everything.  But our SAN doesn’t necessarily like if we run all our index...

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

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

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

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

Interview questions: What’s the first thing you would do if a user reports slowness.

We’ve been doing a fair amount of interviewing recently and one of our big questions is What do you do...

Project Euler

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