Indexes can be incredibly beneficial to your database performance; however, they do come with a cost—indexes both consume storage space and affect insert performance. Therefore, it is important as...
2019-09-11 (first published: 2019-08-28)
2,802 reads
I recently had someone tell me, and I’m paraphrasing a bit here: We know how to fix this now, so ... Continue reading
2019-08-28
161 reads
Watch this week’s video on YouTube. Today I’m concluding my series on SQL Server execution plans by sharing the specific steps I take when troubleshooting a slow performing query....
2019-09-12 (first published: 2019-08-27)
1,827 reads
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
Today I'm...
2019-08-27
16 reads
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
Today I'm...
2019-08-27
24 reads
In two previous posts, I’ve showed how to configure Jenkins in a container as well as how to add the SQL Change Automation plugin. This post looks at an...
2019-09-12 (first published: 2019-08-26)
620 reads
I’m really excited for Redgate’s new SQL Change Automation plugin for SQL Server Management Studio (SSMS). SQL Change Automation lets DBAs and developers use a migrations-first approach to create...
2019-08-26
22 reads
I’ve never been terribly shy about my beliefs about IT certifications. I sincerely believe they are largely a waste of time. I do recognize that one thing they do...
2019-08-26
185 reads
If you can help it you probably shouldn’t be using triggers. But if you have to use a trigger you ... Continue reading
2019-09-09 (first published: 2019-08-26)
539 reads
Introduction I recently got a call from our DBA telling me that the CPU usage is hitting 100% on the DB server and the ETL process runs for more...
2019-09-04 (first published: 2019-08-26)
690 reads
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Comments posted to this topic are about the item Learn From History
Comments posted to this topic are about the item The SQL Server MCP Server
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers