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 … Read more
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 … Read more
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 … Read more
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 … Read more
I had another tip posted over at MSSQLTips today, you can find it at http://www.mssqltips.com/tip.asp?tip=1938 The tip helps you configure a policy inside of PBM that will help you to determine how badly your transaction logs are fragmented.
Linked server configurations are often overlooked when it comes to environmental baselines. I don’t know of too many people who go out of their way to track such details. And I have often been surprised by vendor software packages that claim to track system changes but do not include linked server information. One thing about … Read more
