sp_WhatsupQueryStore version 1.1 released
Today I released a new version of the sp_WhatsupQueryStore stored procedure. sp_WhatsupQueryStore returns many configuration and performance metrics that are...
2016-12-06
472 reads
Checking your Wait Stats via Power BI
Wait stats is my go to thing, however I do get bored just querying it via a table so I...
2016-12-06
807 reads
December: A two-line play.
“Wow! A family, a marathon, and two businesses! So how do you keep up with it all?” asked Twitter. “Work-life...
2016-12-05
597 reads
Presentations for SQL Server Beginners
Tired from all those blog postsFor my final blog post in the #gettingstarted, #iwanttohelp series, I decided to curate a...
2016-12-23 (first published: 2016-12-05)
3,290 reads
Optimize For Unknown
Hello Dear Reader! It's been a while. I was working with a friend and we came across an interesting problem. They had a large amount of skewness/data skew. This...
2016-12-05
8 reads
Optimize For Unknown
Hello Dear Reader! It's been a while. I was working with a friend and we came across an interesting problem....
2016-12-21 (first published: 2016-12-05)
3,327 reads
On Being Disruptive
Being disruptive is a powerful way to conduct business. Steve Jobs and Bill Gates insisted that computers belonged not just...
2016-12-20 (first published: 2016-12-05)
1,733 reads
Multivariate Variable Analysis using R
So far I’ve worked on simple analytical techniques using one or two variables in a dataset. This article is a...
2016-12-05
987 reads
Dynamically Set Powershell Variables from json
I created this small snippet to allow a list of values from a json file be turned into variables to...
2016-12-05
304 reads
Monday Coffee 2016-12-05
You are the DBA your company makes you. Aren’t you?
SQL Server has such a wide range of features that no...
2016-12-05
304 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers