Undercover Catalogue 0.1 Released
Easily Keep Track of All Your SQL Servers
We know what it’s like when you’ve got 101 SQL Servers to manage,...
2018-08-28
285 reads
Blog Posts
Upcoming Performance Tuning Webcast
On September 13, 2018, at 3 PM Eastern (USA), I’ll be giving a webcast for MSSQLTips.com on finding and correcting...
2018-08-28
217 reads
What is Automatic Tuning in Azure SQL Database
Microsoft has long given us DBA tools and suggestions to help tune databases, to fix queries with indexes, and many...
2018-08-28
521 reads
Advantages of Azure Resource Manager (ARM) Deployment Model
Are you just starting out with Azure and wonder: What is Azure Resource Manager (ARM) Deployment Model? Or what’s the...
2018-08-27
270 reads
Copying formatted text out of a grid column.
I was reading a post today by Bert Wagner (b/t).
Displaying Long Variable Values in SQL Server
By the way, if...
2018-08-27
914 reads
SQL Server Encryption, What’s The Key Hierarchy All About?
I’m sure that we all know that SQL Server includes all sorts of interesting functionality to allow us to encrypt...
2018-08-27 (first published: 2018-08-09)
1,848 reads
SQLCLR vs SQL Server 2017, Part 8: Is SQLCLR Deprecated in Favor of Python or R (sp_execute_external_script)?
(last updated: 2019-01-10 @ 18:00 EST / 2019-01-10 @ 23:00 UTC )
With the additional (and annoying) configuration step required to get SQLCLR Assemblies...
2018-08-27 (first published: 2018-08-09)
4,070 reads
Two Posts About PASS
I’m a little late getting to this, but I think both of these are worth reading:
https://www.linkedin.com/pulse/open-letter-pass-group-leaders-sql-saturday-steve-rezhener-mba/https://medium.com/@SteffLocke/sqlsaturdays-shouldnt-give-up-pass-money-a478a97ee0c7Suggest you post any thoughts...
2018-08-27
276 reads
Why I Love Extended Events, Reason 394: Customize Live Data
There are so many reasons to love Extended Events that it can really be overwhelming, but, one more reason that...
2018-08-27
359 reads
Azure Every Day, Azure Data Week, and More Azure
As you likely know, I am a Principal Consultant at Pragmatic Works. This year we have been doing some great...
2018-08-25
392 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