This topic came up on a forum post recently, and after responding a couple of times to the thread I had to jump into one of my VMs to figure out what exactly the problem was. If you use Server Audits in SQL Server, one of the features that you might be interested in is [...]
Jonathan Kehayias
The Rambling DBA
Resolving Error 33204 SQL Server Audit could not write to the security log
Posted on: June 22, 2012 9:50 pm
Creating a new Login on Multiple Servers with the same SID using Powershell
Posted on: June 24, 2011 10:12 pm
Steve Jones (Blog|Twitter) asked a question on the #sqlhelp hash tag tonight that I found interesting so I thought I’d play around with Powershell for a few minutes and see if I could beat Aaron Nelson (Blog|Twitter) to the punch with a Powershell answer for once. Steve’s question was: @wayoutwest: “Anyone have a PSH script [...]
Certificate Signing Stored Procedures in Multiple Databases
Posted on: April 26, 2011 10:17 pm
Yesterday I received an email asking me a question related to my Using a Certificate Signed Stored Procedure to Execute sp_send_dbmail on SQL Server Central that intrigued me enough that I had to put a couple of minutes into actually figuring out what the problem the being encountered was. In the article, I show how [...]
