Jobs change over time, and database administrator jobs are no different. In this 35 minute recorded Twitch livestream (my first ever!) I talk about threats to DBA jobs and...
2019-01-18
15 reads
Sometimes you know that a problem occurred, but the tools are not giving you the right information. If you ever...
2019-02-04 (first published: 2019-01-18)
2,742 reads
When I first joined the programming team at my previous job in an aerospace company, the first observation I made...
2019-02-01 (first published: 2019-01-18)
2,107 reads
When you build a brand new shiny SQL Server, you want to get a lot of memory so your queries...
2019-01-31 (first published: 2019-01-18)
2,937 reads
User defined functions in SQL server can cause all kinds of performance problems, there are however some tricks that are...
2019-01-18
294 reads
My fifth data warehousing tip is to always use surrogate keys for your dimension and fact tables.
Surrogate keys are keys...
2019-02-07 (first published: 2019-01-18)
3,067 reads
DBCC CheckDB failed with error “DBCC could not obtain a lock on this object because the lock request timeout period...
2019-01-18
1,343 reads
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough...
2019-01-17
89 reads
Next week, I’m giving a free webcast for Redgate on DevOps fundamentals. DevOps is something I am a big proponent of for database administrators, developers, and company leaders. The...
2019-01-17
13 reads
When you’re querying the plan cache, you need to know the four primary objects: the query hash, query plan hash,...
2019-01-17
769 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 The SQL Server MCP Server
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Comments posted to this topic are about the item A Worse Computer; A Better...
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers