Script to find orphaned/unreachable job steps within your SQL jobs
SQL jobs are great as the SQL agent job engine allows for very granular control over jobs that are created...
2012-08-23
2,612 reads
Blog Posts
SQL Server 2005 Diagnostic Information Queries (August 2012)
Here is the August 2012 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements....
2012-08-23
1,102 reads
Tips For Minimizing Deadlocks in SQL Server
Database servers are configured in such a way that they can service multiple requests from multiple users. Obviously this increases...
2012-08-23
2,485 reads
Transparent Data Encryption (TDE) with Database Mirroring
Database security is essential for the organisations working in healthcare and financial sector because the databases in such organisations contain...
2012-08-23
1,747 reads
24 Hours of PASS, Fall 2012
It’s time to get your learn on again. The schedule for the Fall 24 Hours of PASS is up and...
2012-08-22
703 reads
I Think I Need A Writing Table
I’m writing this Friday evening in Cleveland at the hotel, relaxing after the speaker dinner and getting ready for SQLSaturday...
2012-08-22
702 reads
I’m Speaking at SQLSaturday #156–Providence
I’m excited to be back on the speaking circuit. I was able to attend SQLSaturday #122 – Louisville thanks to Idera and the ACE program. Now I’m on...
2012-08-22
15 reads
I’m Speaking at SQLSaturday #156–Providence
I’m excited to be back on the speaking circuit. I was able to attend SQLSaturday #122 – Louisville thanks to Idera...
2012-08-22
729 reads
Lost in Translation – Deprecated System Tables – sysdepends
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-08-22
1,233 reads
Running in Central Park at SQL in the City New York
I just booked my tickets for New York City. I’m coming into the city on Sept 27, at 2pm, with...
2012-08-22 (first published: 2012-08-20)
1,587 reads
Blogs
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries