How To Analyze Database Activity If You Don’t Have A Monitoring Tool Part 1

You overheard your managers discussing whether or not the recent product launch was successful. The director of sales was very confident about his claims and calling it a success. The director of marketing was challenging the claims. Your new boss, the director of IT, is still trying to figure out what was happening since he just took over the […]

How To Convince Your Boss (or Customer) To Re-Evaluate Your HA/DR Solution

Have you ever had a conversation with your boss (or customer, if you’re a consultant) that went something like this: (true conversation between a DBA and his boss) In most cases, unless you are really gifted with the art of persuasion, the conversation may fall flat on your face because no amount of technical proof […]

What Multibase Differential Backups Are and How They Can Cause Failures To Your Backup Strategies

Taking database backups is still considered to be the most important task that any database administrator does. That’s why it is also important to make sure that database backups not only complete successfully but have also been validated and tested. I’ve written several blog posts about the importance of backups and why having successful backups is not enough. […]

Delayed Durability in SQL Server 2014 and How You Can Take Advantage of It

There have been a lot of blog posts and articles written about the Delayed Durability feature in SQL Server 2014. Here are a couple of them to get you started. Delayed Durability in SQL Server 2014 by SQL Server MVP/Regional Director and SQLSkills CEO Paul Randal (blog | Twitter) Delayed Durability in SQL Server 2014 by […]