Browse by Tags

• Central Management Servers
• DBA
• Developer
• Documentation
• Performance
• SolidQ Journal
• Trivia
• TSQL

• 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: Documentation, Tips & Tricks, Trivia, Central Management Servers

• The latest edition of the SolidQ Journal is now available

  The SolidQ Journal is published monthly by SolidQ and packed with lots of good information related to SQL Server and related topics. If you haven’t already signed up to get these each month then have a look here .  It’s a free resource that Read More... Posted Monday, July 11, 2011 8:57 PM by Andrew Kelly | 0 Comments Filed under: Documentation, Tips & Tricks, SolidQ Journal

• The January 2011 Edition of the SolidQ Journal is Out

  The latest edition of the SolidQ Journal is now available online at http://www.solidq.com/sqj/Pages/Home.aspx . Enjoy, Andrew J. Kelly Read More... Posted Monday, January 17, 2011 2:21 PM by Andrew Kelly | 1 Comments Filed under: Documentation, Tips & Tricks, SolidQ Journal

• 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

• Sometimes you just have to break it up

  I will be the 1st to admit that I am no Itzik Ben-Gan when it comes to writing complex SQL statements and I wonder at times how people come up with some of the Selects that I see.  Sometimes they are so complex or convoluted that I simply have a Read More... Posted Tuesday, April 14, 2009 8:19 PM by Andrew Kelly | 6 Comments Filed under: DBA, Tips & Tricks, Performance, Developer

• When a Function is indeed a Constant

  In my last blog post:   http://sqlblog.com/blogs/andrew_kelly/archive/2008/02/27/when-getdate-is-not-a-constant.aspx I mentioned that I ran across a situation in which GETDATE() used in a SELECT statement occasionally returned more than 1 value for Read More... Posted Saturday, March 01, 2008 12:19 PM by Andrew Kelly | 6 Comments Filed under: Documentation, Tips & Tricks, TSQL