Custom Data Purging in SQL Monitor
In talking to a customer recently, they were worried about the amount of data kept by SQL Monitor. That’s a...
2018-08-30
409 reads
Blog Posts
Helpful Undocumented Stored Procedure “sp_MsForEachDB”
This week’s post will be a short one to talk about a very helpful stored procedure in SQL Server called...
2018-08-30
278 reads
Maps in Power BI. Do I really need them?
(2018-Aug-30) While preparing for a recent Power BI Toronto meetup session, I found a very valuable whitepaper on Maps in...
2018-08-30
1,122 reads
Repair Visual Studio for Mac: Extension node not found in path
A few months ago I ran into a problem after updating Visual Studio for Mac, where it would not start....
2018-08-30
350 reads
Talking Data: Six Word Stories
In six words, can you give a compelling description of your data?
I’m taking the Microsoft DAT248x course as part of...
2018-08-30
330 reads
The unwanted Side Effects of enabling Read Committed Snapshot Isolation
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-08-30
2,285 reads
A software architect replaces a relational database with a relational database
Content warning: This is the second (and final) rebuttal essay about why someone is wrong on the Internet. It is...
2018-08-29
315 reads
Azure SQL Database disaster recovery
My last blog post was on Azure SQL Database high availability and I would like to continue along that discussion with a blog post about disaster recovery in Azure SQL...
2018-08-29
33 reads
Azure SQL Database disaster recovery
My last blog post was on Azure SQL Database high availability and I would like to continue along that discussion with...
2018-08-29
1,115 reads
Cleaning up Query Store data after database restore
Query Store is a very powerful tool for performance tuning, if you are not using it already you should!! It...
2018-08-29 (first published: 2018-08-13)
2,082 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers