June 2009 - Posts

• Windows Live Writer – Good or Bad?

  <Updates at bottom of post> OK this will probably start a fire storm from Die- Hard Live Writer (LW) geeks but oh well :). I don’t blog as much as I would like and one reason is that I have had so much trouble getting posts properly formatted that Read More... Posted Friday, June 26, 2009 6:27 PM by Andrew Kelly | 15 Comments Filed under: Humor

• Cleaning up Un-Named Defaults

  I just had a situation in which we are automating the comparing of databases and I came across a bunch of Defaults that were never explicitly named. This causes them to get a new name each time you create them and makes it much more difficult to write Read More... Posted Friday, June 26, 2009 1:07 PM by Andrew Kelly | 10 Comments Filed under: Best Paractices, TSQL, Developer, Tips & Tricks

• Trace Flag Groupings

  I just saw a news group post by Paul Randal in which he explained how trace flags were grouped into certain categories and thought others may find this interesting as well. Please note that Paul stated that these are from memory so they may not be 100% Read More... Posted Sunday, June 21, 2009 12:56 PM by Andrew Kelly | 0 Comments Filed under: Documentation, Trivia

• SQLCMD Execution Order

  I find that many people don’t realize since SQL Server 2005 that you have the ability to execute SQLCMD commands or scripts directly in the Query Editor but it can come in handy at times. Even I don’t use it that as much as I should and I am aware of Read More... Posted Friday, June 05, 2009 8:53 PM by Andrew Kelly | 11 Comments Filed under: Tips & Tricks, Trivia