Dear SQL DBA: Remembering Robert Davis, DBA Hero
What makes a person a DBA Hero? In this episode, I talk about how Robert Davis made a huge impact on the SQL Server community, and the traits that...
2018-08-02
28 reads
Blog Posts
How to Change SQL Server License or Product Key?
Yesterday, I was doing SQL Server Database stress and benchmarking testing on the client side. When I started ramping-up more...
2018-08-02
137,368 reads
The Figleaf Data Masking Beta
I’ve been using the Redgate Software Data Masker for SQL Server in a number of situations to help customers. This...
2018-08-02 (first published: 2018-07-17)
2,053 reads
Data lakes and swamps, oh my
I was lamenting to my friend and fellow MVP Shamir Charania (blog | Twitter) that I didn’t have a topic for...
2018-08-01 (first published: 2018-07-18)
2,975 reads
Don’t do these things in SQL Server
Recently Brent Ozar posted a link to the PostgreSQL “Don’t do this” page, which I am shamelessly reproducing below, re-tailored...
2018-08-01
517 reads
First time speaker at Denver’s SQL local group
06/21 was the date that marked my career as data professional, for the first time ever I decided to participate as...
2018-08-01
253 reads
Have you ever wonder why Log Send Rate doesn’t show against Primary Replica on the AlwaysOn Dashboard?
Recently, I was working on the AlwaysOn Availability group issue where the log records were not moving from primary to...
2018-08-01
473 reads
Schedule an Extended Event to run at a Specific Time
When you are using the extended event to capture some data for troubleshooting purpose, you may want to start or...
2018-08-01 (first published: 2018-07-18)
5,326 reads
SQL Homework – August 2018 – Set up database mail
This month’s homework is pretty simple to say, not necessarily easy to do. Set up database mail.
Why database mail?...
2018-08-01
336 reads
Community Engagements Second Half of 2018 – It’s all about Biml
I have a couple of community engagements coming up in the second half of 2018 and I’d like to share...
2018-07-31
338 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