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

What Does The GO Command Do?

Watch this week’s episode on YouTube.
When I started working with T-SQL, I thought the GO command was optional, kind of...

Azure PowerShell – List Virtual Machine Sizes

For those who use PowerShell to do things in Azure you will know that occasionally there is a parameter that...