Please consider that the below script uses the xp_cmdshell to issue  the files move commands to the underlying OS. It isn't default en...

Firts of all let me say I definitively love SQL Server and I'm really impressed about the product technical improvements in the last ...

Few days ago a customer asked me to implement a security auditing solution for their production instances of SQL Server, to track users a...

Great solution using SQL Server Service Broker: http://www.madeirasql.com/service-broker-asynchronous-triggers/ Use this version of SB_AT...

Some customer asked me for this info, because managing  Product Keys over the time  can become a very time-wasting activity. First of all ...