In this brief post I will show you how I created a self-signed certificate to be used when configuring SSRS…
MSDTC, Triggers, and Firewalls. Oh my!
One Experience Troubleshooting Transactions Over Linked Servers The Backstory This client had been plagued by poor table and index design,…
Redundant Indexes Part 1: Identifying Redundant Indexes That Are Not Used To Service Queries
Overview Indexes are a powerful concept in any RDBMS. They can dramatically increase the performance of queries, but they can…
Altering Stored Procedure Families Programatically
Alter every stored procedure in a database that fits a given criteria Recently I had to search for, and update,…
Signing CLR Assemblies
So you want to load a CLR assembly into SQL Server. What’s that you say? You DONT want to set…
Linked Servers: SQL Server 2005 to SQL Server 7
Today I had the pleasure of creating a linked server on our main production SQL Server 2005 instance. The catch…
A Non-Trivial SQL CLR Table Value Function Example
Overview In this post I would like to demonstrate how to create a simple yet non-trivial CLR table-valued function (TVF).…
Msg 14274, Level 16, State 1, Procedure sp_add_job
Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. Recently I…
Scripting Stored Procedure Permissions
Overview When scripting stored procedure code for deployment to several servers, there are a few things to keep in mind. …
How to Kill a Profiler Trace
Using Profiler to run a trace can be an invaluable tool for troubleshooting performance problems with T-SQL code. Occasionally something…