Transaction logs are one of the most critical parts of a database and should be managed as such. Running out of disk space can cause application errors and even database corruption. If your transaction log is continually growing there are...
I previously blogged about how important I think retrospectives are, and you can read it here. We recently decided to try and mix up our team EOS Level 10 meeting slightly by replacing the Issue Identification and Resolution portion of...
Without reflection there can be no learning. Reflection is the time when we look at what we have done, including actions and behaviors, and evaluate what worked or did not work for a situation. This could be as individuals, a...
There I was minding my own business having breakfast and reading SQL Server Central‘s editorial when I saw a link to Alex Kuznetsov’s Defensive Database Programming book. I read the book a year or so ago, and much of it will not come as any...
It is not always intuitive on how to setup a linked server with an alias, or setup security for the linked server when it will be used via a SQL Agent Processing Job. Here are a few notes to make...