Wow, that title is a bit of a mouthful, let me give you a scenario to help understand what the business problem was that I ran in to today. We have a production database running on SQL 2008 which contains a CLR procedure that accepts a reportID value, queries some data and writes out to…
Month: July 2012
AD Accounts Are Great, But…
Using Windows Authentication for your database is a great best practice to follow. However, one caveat to remember as one of my administrators found out today. Do not use that account as a login if it is also the account you use for your database. We setup an AD account for his database, that part…
Presentation Ponderings
After my first presentation at SQL Saturday Pensacola, I am ready to do another and need to submit for SQL Saturday Orlando later this month. All of that is not a problem, I just don’t know if I should do what I did in Pensacola and expand on it because the audience seemed to enjoy…
Changing SQL Agent Job Subsystem Queue Lengths
In the event you are running a lot of jobs on your SQL Server, or you happen to have a great number of jobs that kick off close to each other and use the same subsystem (i.e. PowerShell) then you might receive a warning in the SQL Agent Error Log stating that the job step…