Browse by Tags

• 2008 R2
• Best Paractices
• Central Management Servers
• Developer
• Documentation
• Humor
• Storage
• Tips & Tricks

• Finding IP Addresses With CMS

  I was just tasked with putting together a list of all the IP Addresses of the SQL Servers that one of my clients deals with on a daily basis. In this case there was over 30 of them and while I could ping each one individually I found an easier Read More... Posted Monday, July 25, 2011 5:14 PM by Andrew Kelly | 2 Comments Filed under: Central Management Servers, Documentation, Tips & Tricks, Trivia

• SQL Server 2008 R2 System Views Map Poster

  The latest SQL Server 2008 R2 systems views map poster is available here: 2008 R2 Poster It’s available in a pdf or xps format so have fun with it.   Andy Read More... Posted Wednesday, December 08, 2010 9:21 PM by Andrew Kelly | 2 Comments Filed under: 2008 R2, Developer, Documentation, Trivia

• What 3 events Brought Me Here

  I am a few weeks late getting to this but here we go. Paul Randal tagged a few people including me with this challenge to state what 3 events got us to where we are today. Here is my story: Event 1 I suppose the first event was when I decided to Read More... Posted Wednesday, February 03, 2010 1:17 AM by Andrew Kelly | 1 Comments Filed under: Trivia

• SQL 2008 R2 Enhancement

  The additions or changes in SQL Server 2008 R2 are mostly BI related but there is one I just became aware of that serves a more general purpose but at the same time is fundamental in how the storage engine works related to locking.  I won’t Read More... Posted Monday, February 01, 2010 7:01 PM by Andrew Kelly | 5 Comments Filed under: 2008 R2, Storage, Trivia

• My Greatest Weakness

  I was just called out ( see here ) to blog about this topic by a good friend Mike Walsh who’s twitter name is @mike_walsh and it has been a long time since I blogged so here goes. First off lets be realistic and recognize that we as humans all Read More... Posted Tuesday, December 15, 2009 3:58 PM by Andrew Kelly | 8 Comments Filed under: Trivia

• 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

• How Dirty are your Reads?

  As a SQL Server consultant I get to see a lot of different sets of code written by all sorts of database developers from all over the world. And I have to say that one thing that is clear is most developers make abundant use of the NOLOCK query hint or Read More... Posted Friday, April 10, 2009 8:08 PM by Andrew Kelly | 20 Comments Filed under: Best Paractices, Developer, Humor, Trivia

• Debug button in SSMS 2008

  How many people are tired of accidentally hitting the toolbar button with the green triangle on it when trying to run a query in the Query Editor only to get into the debug mode?  If you are like me then I bet a lot of you:).  It only seems Read More... Posted Wednesday, September 17, 2008 5:44 PM by Andrew Kelly | 6 Comments Filed under: Documentation, Trivia

• OT - Where is the gas cap?

  I know this is a SQL blog but I need to take my mind out of the technical mode for a few minutes to gain some sanity and hey, this is a blog after all:).  I was thinking about something my wife reminded me of while we were driving a rental car in Read More... Posted Friday, April 04, 2008 10:33 AM by Andrew Kelly | 27 Comments Filed under: Trivia