Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Nakul Vachhrajani is a Technical Specialist & Systems development professional with iGATE. He holds a MCTS (SQL Server 2008: Implementation & Maintenance)
Browse by Tags · View All
#SQLServer 299
SQL Server 298
Administration 251
DBA 240
T-SQL 230
#TSQL 228
Development 223
Tips 211
Guidance 144
Best Practices 119

Archive · View All
April 2011 14
March 2012 11
December 2011 11
March 2011 11
December 2012 10
October 2011 10
January 2011 10
September 2013 9
January 2013 9
November 2012 9

#0227 - SQL Server - SQL Server Build Lists - staying up-to-date with the SQL Server builds

Dec 31 2012 12:00AM by Nakul Vachhrajani   

I was recently working on a particular loaned-in SQL Server instance and remarked to a friend that the owning team did not keep their instance up-to-date on the latest and greatest of SQL Server patches and updates. Immediately, the friend enquired as to how I came in possession of this information, to which I explained the following:

Fetching the SQL Server product version

Fetching the SQL Server Product Version is quite easy, and can be done in multiple ways. Two of the most used ones are:

Using @@VERSION

This has to be perhaps the most popular method of knowing the SQL Server product version – simple and easy to use. However for me, the query returns a little too much data in the sense that it also returns the processor architecture information, installation date, OS version, etc – something which I did not set out to do.

SELECT @@VERSION

And the output on one of my test systems is:

Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (Intel X86)
    Oct 19 2012 13:43:21
    Copyright (c) Microsoft Corporation
    Enterprise Evaluation Edition on Windows NT 6.2 <X86> (Build 8400: ) (VM)

Using SERVERPROPERTY

This one is my favourite because it is precise and provides just the information that has been requested.

SELECT SERVERPROPERTY('ProductVersion') AS ProductVersion
/*
ProductVersion
--------------------
11.0.3000.0
*/

Staying up-to-date with the SQL Server builds released to market by Microsoft

Now that I have the Product Version # for the installed instance of SQL Server, I can look it up in the official SQL Server build lists for the builds that are released to market by Microsoft:

  • KB957826 - Where to find information about the latest SQL Server builds

The KB957826 links to various other KB articles listing the builds that have been released since particular build of SQL Server was released. For example, 11.0.3000.0 is SQL 2012 SP1 whereas a CU has already been released (http://support.microsoft.com/kb/2765331).

Alternatively, if the Microsoft KB article becomes too much information to digest, one can also refer the one on SQLServerCentral (http://www.sqlservercentral.com/articles/Build+List/71065/).

Until we meet next time,

Be courteous. Drive responsibly.

Tags: #SQLServer, SQL Server, Administration, DBA, Tips, Best Practices, Installation


Nakul Vachhrajani
4 · 36% · 11521
6
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

2  Comments  

  • Hi Nakul Fantastic one.

    The Links which u have shared with us is really useful to beginners as well as experienced ones to refresh their knowledge about product version.

    http://support.microsoft.com/kb/957826

    http://support.microsoft.com/kb/2765331

    commented on Jan 2 2013 3:54AM
    Bala Krishna
    83 · 2% · 678
  • @Balakrishna141: I am glad you found the post useful! Do keep the feedback coming.

    commented on Jan 2 2013 10:55AM
    Nakul Vachhrajani
    4 · 36% · 11521

Your Comment


Sign Up or Login to post a comment.

"#0227 - SQL Server - SQL Server Build Lists - staying up-to-date with the SQL Server builds" rated 5 out of 5 by 6 readers
#0227 - SQL Server - SQL Server Build Lists - staying up-to-date with the SQL Server builds , 5.0 out of 5 based on 6 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]