Blog Post

Dynamically Unpivot columns in SQL

Picture this, your data ingestion team has created a table that has the sales for each month year split into different columns. At first glance, you may think “what’s...

2024-05-27 (first published: )

445 reads

Blog Post

Derby City Data Days

It was awesome to see the Kentucky data community come out for the first Derby City Data Days in Louisville, KY! Bringing together communities from Ohio, Tennessee, and Kentucky,...


8 reads

Blog Post

SQLBits 2024 Recap

Had an absolutely amazing time at SQLBits this year! It was lovely to see all my data friends again and had the opportunity to introduce my husband to everyone...


4 reads

Blog Post

DataTune Nashville 2024 Recap

DataTune 2024 was a huge success! Thank you so much to the organizers who spent countless months planning and making this an incredible conference! It was so great to...

2024-03-18 (first published: )

103 reads


Six Months!


Oh good gosh. Six months without a single blog post. Most important information: I’m...

Async stats update causing blocking


I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up...

Level Up Your SQL Skills: The Best Intermediate to Advanced Courses


In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a...

Read the latest Blogs


Have you seen this in the news today?

By skeleton567

You might want to look into this issue: Windows flaw lets hackers sneak into...

how to find the cpu memory disk and network of the OS where RDS is residing.

By rajemessage 14195

hi, i have one RDS, but i do not have any other permissions, and...

“user_scans” of table “sys.dm_db_index_usage_stats”

By Meera

I am trying to find answer to the below. What exactly the scan means...

Visit the forum

Question of the Day

A Lack of Memory Grant Feedback Persistence

SQL Server has added an Intelligent Query Processing feature called Memory Grant Feedback. In SQL Server 2022, this can be persisted across queries to improve the performance of future executions. In SQL Server 2022, when is memory grant feedback not persisted if the plan is evicted from cache? (choose 2)

See possible answers