John Sansom – SQL Server DBA in the UK Rotating Header Image

Posts from ‘March, 2010’

Something for the Weekend: SQL Server Links 12/03/10

I hope you’ve had a great week! Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy! SQL Server Links Tuning SQL Server Transactions – and Meetings – Using a similar problem solving approach for hosting meetings and tuning transactions. The root of all Evil – I know this pain all [...]

SQL Snippet: Who owns that SQL Server Job?

Here is a handy T-SQL script that will list all SQL Server Agent Job owners by job. From an administration perspective, this query can come in handy when you need to ensure/validate the job owners on your server. One common mistake that I have seen is that when a user creates a new SQL Server [...]