This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-03-04 (first published: 2022-02-16)
274 reads
Last year I wrote a series of posts about accessibility as it relates to presentations, and one aspect which I didn’t cover is within the documents themselves. We create...
2022-02-16
97 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-02-16
46 reads
Learn about SQL Server key lookup performance and how to improve the performance of key lookup queries.
2022-02-16
264 reads
This article focuses on getting the Displays Estimated and Actual number of Rows from the SQL Server Execution Plan. Read More
2022-02-28 (first published: 2022-02-16)
565 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-02-15
29 reads
No doubt there will be a need for you to split off your analytical queries from the main database for performance reasons. If you have been following me in...
2022-02-15
30 reads
For those of you that need to setup Kerberos constrained delegation for Group Managed Service Accounts, you will likely get more familiar with msDS-AllowedToDelegateTo. This attribute stores a list...
2022-02-15
293 reads
I like Extended Events and I regularly use the Session Properties window to create and explore sessions. I’m in the window all the time, noting it’s quirks & odd...
2022-03-02 (first published: 2022-02-15)
223 reads
I recently got an update from the SQL Monitor PM on the progress we’ve made across all the teams. We have a number focusing on different aspects of the...
2022-02-14
46 reads
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Hello experts, An application team has asked us to modify a SQL Agent job....
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Comments posted to this topic are about the item Finding Bad Queries