THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Documentation » Tips & Tricks   (RSS)
  • 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 way that you might find useful as well if you are in the same circumstance. I figured there must ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on July 25, 2011
  • 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 only cost’s you the time to read it .   Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on July 11, 2011
  • 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
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on January 17, 2011
  • 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 the result set. That sparked quite a debate amongst SQL Server programmers who belonged to ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on March 1, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement