Manage Your Transactions (So They Don’t Manage You – Part 2)

This is the final in a series on shrinking and transactions. You can see them all in the Shrinking & Transactions category. In part 1, we talked about factors that affect transaction log growth. We talked about what a SQL Server transaction is and the various modes SQL interacts with a transaction (Autocommit, Implicit Transactions and … Read more

Manage Your Transactions (So they don’t manage you – Part 1)

This is part 3 in a series on shrinking and transaction management. Click here for part 4. You can see them all in the Shrinking & Transactions category. If you are one of the people who have been reading this blog, you know where I stand on shrinking databases/log files. I don’t like the practice (Post 1, … Read more

Alphabet Blocks and a Solid Foundation

Continuing in the theme from last week’s post correlating the DBAs role to aspects of various careers (Pilots, Chefs and Doctors) an illustration came to me this past weekend. I was playing blocks with my 1 year old son. The game with him consists of me trying to hold him back for as long as … Read more