Posts tagged with: development

Troubleshooting a Full Transaction Log

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...
Continue Reading →

[We] ain’t afraid of no [retrospective] (Retrospective Activity)

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...
Continue Reading →

Using visual aids for actionable reflection

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...
Continue Reading →

Defensive Database Programming

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...
Continue Reading →

Linked Server Setup with Alias and SQL Server Agent support

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...
Continue Reading →