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 Agent [...]
Posts under ‘Administration’
SQL Snippet: Who owns that SQL Server Job?
SQL Snippet: What SQL Server Agent Jobs were running at that time?
Here is a SQL Snippet that can be used to identify the SQL Server Agent Jobs that were running on a server at a particular point in time.
This can come in very handy if you need to troubleshoot a performance issue after the fact and want to find out if there were any jobs running [...]
SQL Server Essentials – Part 2: Why you should be using the FULL Recovery Model
In Part 1 of the “SQL Server Essentials” series we discussed the Database Administrator’s primary responsibility.
Given that your data is so important, how can you manage and ensure it’s safekeeping? Should a data loss event occur, you want to be in a position to enable you to protect the majority, if not all, of your [...]
SQL Server Essentials – Part 1: The Database Administrator’s Primary Responsibility
You’re busy coding away at your workstation when all of a sudden your manager walks over to you all excited and begins discussing with you, the details of this great new application your company has just aquired. It turns out that he wants you to look after and administer this newly aquired application platform, which [...]
SQL Server Reporting Services Tip: email subscription tweak
What’s the problem?
How to configure SQL Server Reporting Services 2005 to permit users to assign the delivery email address for their own subscriptions.
Why does SQL Server work this way?
When you subscribe to a report, the e-mail delivery settings you work with vary depending on whether your Role includes the “Manage individual subscriptions” task or the [...]
The Definitive Introduction to SQL Server Indexes
It normally is not my style to write a blog post solely about a particular article someone else has published. Typically I just go ahead and add quality resources to the SQL Server Resources area of this site that I have either found myself or had recommended to me.
In this case however an exception must [...]
SQL Server Index Defrag Script: Update
Michelle Ufford (aka SQLFool) has released an update to her excellent index optimisation script. If you are not already using something similar to simplify your index optimisation database maintenance processes then you will find this to be extremely useful.
Check it out here: Index Defrag Script, V3.0
Michelle Ufford (aka SQLFool) has released an update to her [...]
Superb listing of free SQL Server tools
Paul Randal pointed me in the direction of an awesome resource list of FREE SQL Server tools. There is an absolute mountain of quality stuff here and I wanted to share it with you all.
Free SQL Server Tools that might make your life easier
Be sure to me know which resources you use and how you [...]
Performing fast SQL Server delete operations
There have been quite a few queries on the forums this past week with regard to performing fast delete operations on large tables and I wanted to share some of the possible solutions here with you.
Fast ordered delete using a view
To perform a fast ordered delete, take a look at the article Fast Ordered Delete [...]
Whitepaper: Troubleshooting Performance Problems in SQL Server 2008
No doubt you already know that I love nothing more than getting my hands on excellent technical resources for SQL Server. Well hot off the press is the latest Whitepaper offering from Microsoft that looks at troubleshooting performance problems in SQL Server 2008.
Naturally you may already be familiar with some of the techniques and practices [...]