This week’s 5 tips will be on a topic very near to my heart, database corruption. I want to do the 5 tips a little differently this time. The tips will not just be 5 tips in no particular order. These tips will be tips as well as steps on what to do starting with…
Month: December 2017
5 Tips for Friday: Preparing for the Holidays
With the holiday season upon us for much of the world, I find myself thinking of ways to ensure that we have a quiet season outside of the office. Nobody wants to spend a family get-together fixing problems at work. I know most of you know what I mean. It’s a DBA’s lot in life…
Restrict the usage of a SQL Server Authenticated Application Id
SQL Server login ids may not be the most secure thing in the world but they are likely to be around for quite a while and one of the more common uses of them is as an application id. An application uses a SQL Server id to connect to SQL and then controls its own…
5 Tips for Friday: Monitoring and Alerting
I really think monitoring is an under-appreciated topic in our industry. Sure, that’s several companies that make pretty good morning writing monitoring software. Cards on the table, I even worked for one of them several years ago. Whether you invest in 3rd party monitoring software or not, you really should have some full solution in…