David Tate

Latest

Out of space error when moving tempdb

Quirk in SQL Server to do with sizing tempdb that I ran into today: SQL Server checks the current location when you move tempdb to see if there is enough space not the new location. From: Configuring Database Files for Optimal Performance The below script will move TempDB from its

How to complain

Let’s talk about one of the ills facing any group of people who are passionate about their work – ‘complaining about how bad things are’. I’ll list some personal do’s and don’ts on effective complaining, and ways that organizations can help it not destroy morale.Every person

Fixing problems Part 1: Introduction and Attitude Adjustment

As DBAs, software developers, Homo Sapiens, and lovers we have to solve problems. There is a common misconception that support is for the more junior folks on a team and thus being good at it is a sign of “being a little baby”. While support is a great way to

Exception (Mis)Handling

Exception handling was originally created to try to give developers a way to separate out error handling so that it wouldn’t clutter up and distract from the core functionality trying to be accomplished. When done well, exception handling can provide a clean way to instrument and separate truly exceptional

Key considerations for your next development job

As a developer, your basic job is to create things. Since the world needs software in every industry you might think that one is the same as the next, and you’d be shamefully wrong. Outside of the obvious questions you should ask yourself when looking for your next gig

Complexity

Complexity

Software Development is management of true complexity, not false complexity

Triggers Part 3: FAQ and FOP Continued

This is part of a 3 part epic mini-series on triggers, view Part 1 and Part 2. How many triggers should you have per table? Ideally zero. If you have any then there should be one. There is no guarantee on the ordering of trigger firings, they normally fire