Five database management trends to embrace in 2019
In 2018, companies looked for ways to improve their database performance and security. Their aim was to keep up with...
2019-01-07
307 reads
Blog Posts
Five database management trends to embrace in 2019
In 2018, companies looked for ways to improve their database performance and security. Their aim was to keep up with ever-higher expectations of speed, privacy and returns on investment....
2019-01-07
16 reads
How to Change Suspect Mode to Normal Mode in SQL Server Database
If you are reading this, you are desperately looking for solutions to change suspect mode to normal mode. It also means that your database has gone into the suspect...
2019-01-07
27 reads
How to Change Suspect Mode to Normal Mode in SQL Server Database
If you are reading this, you are desperately looking for solutions to change suspect mode to normal mode. It also...
2019-01-07
227 reads
Profiler Is Dead, Long Live Extended Events
OK, so profiler isn’t actually dead, it has however been deprecated since 2012 and has had no new features since...
2019-01-07
631 reads
Query plan hash
This is post 3 in the series about query fingerprints. Here’s the previous posts in this series:
Query HashSQL Handle
What is...
2019-01-07
896 reads
Quick and Easy XE for Azure DB
The Cloud
It has been a minute since I gave much love or attention to Extended Events in Azure SQL DB....
2019-01-07 (first published: 2018-12-24)
1,497 reads
SQL Bits Precon 2019
I am extremely happy to announce that I’ll be presenting a preconference training session with Bob Pusateri at this year’s...
2019-01-07
264 reads
The Top 4 Data Technology Trends Every DBA Should Know About in 2019
Join Sentry One, Kevin Kline, and me in an exciting (and laugh-filled) panel session this Wednesday, January 9th, at 2pm...
2019-01-07
45 reads
What is the Max Degree of Parallelism setting for SQL Server?
Max Degree of Parallelism is a setting that is often changed to improve performance in SQL Server. What exactly does...
2019-01-07 (first published: 2018-12-21)
2,767 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
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...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
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