Now that I am one step closer to officially becoming the DBA at work, I am delving a bit more deeply into the non-development side of SQL Server than previously.  To do that, I am planning on watching a lot of videos, as I would rather not try to hit up my job’s training budget for this and any of the classes I might be interested in would run well over the $1000 I have that I could allocate toward such an endeavour.  As a result, I am looking at free sources of information.  I subscribe to and read SQL Server Central, but in addition, I watched the first SQLServerPedia tutorial and am intrigued and shall learn more.  I also have a plan to check out how closely SSWUG’s vidcasts match what I’m looking for.

A couple of weeks ago at work, our code generator application was not running—we would get a timeout message when it tried to hit a table in a database.  Thanks to this query over at SQLTeam, I found out that one of our developers had an IX lock on the particular table.  Unbeknownst to him, he forgot to commit or roll back a transaction he had pending, and part of this transaction involved updating values in that table.  Because he had an update lock, nobody else could read from that table, causing the code generator to crash.  After I had him roll back the transaction (after all—if it was that good an idea, he could run it again but commit this time, and I had no idea what he was trying to run), things were copacetic once more.  I’ve saved that query in my list of good queries, and am planning on adapting it for my own purposes.

2 thoughts on “Computing Notes

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s