The other day Aaron Bertrand pointed out that a recent tip I wrote had a rather nasty oversight. You can read more about the discussion over at his blog.
The short of it is this: what I wrote in the tip is cot very clear, and is most likely going to be interpreted wrongly. Aaron’s post [...]
MSSQLTips
Backup Compression Tip
I had a new tip go live today over at MSSQLTips, it is on backup compression and you can read more about it by going here.
Backup compression is a feature offered with the Enterprise version of SQL 2008. After having native compression available in Sybase ASE for years I was happy to see that Microsoft [...]
SQL Server Audit Tips
I had two tips go live this past week over at MSSQLTips, both with regards to the SQL Server Audit feature in SQL 2008. The first tip shows how to enable SQL Server Audit. The second tip shows how to use the AUDIT_CHANGE_GROUP to monitor changes to your audit configurations. Some people would call that [...]
Two Things To Tell You
I have three things to tell you today.
First, I have a new article over at MSSQLTips.com, this one on configuring a SQL Server 2008 Audit. Head over there and check it out, I give the details you need in order to get your instance configured for auditing.
Second, and somewhat related, I have submitted a session [...]