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 » service packs   (RSS)
Showing page 1 of 2 (20 total posts)
  • SQL Server 2012 Service Pack 2 is available - but there's a catch!

    Service Pack 2 is available: http://www.microsoft.com/en-us/download/details.aspx?id=43340 The build number is 11.0.5058, and this includes fixes up to and including SQL Server 2012 SP1 CU #9. (The complete list of fixes is exhaustive, including all fixes from SP1 CU #1 -> #9, but the post-CU #9 fixes are listed ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on June 10, 2014
  • SQL Server 2008 R2 Service Pack 2 is available

    Today Microsoft has released Service Pack 2 for SQL Server 2008 R2. http://www.microsoft.com/en-us/download/details.aspx?id=30437 The build number is 10.50.4000.0 and it includes fixes from 2008 R2 SP1 Cumulative Updates 1, 2, 3, 4 and 5. The fixes from Cumulative Updates 6 and 7 will be published in a subsequent cumulative update, so if ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 26, 2012
  • How Microsoft helps you NOT break your Windows Azure Application: Storage Services Versioning

    One of the advantages of using Windows Azure to run your code is that you don’t have to constantly manage upgrades on your platform. While that’s a big advantage indeed, it immediately brings up the question - how do the upgrades happen? Microsoft upgrades the Azure platform in periodic increments, and the components that are affected are ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 6, 2011
  • SQL Server 2008 Service Pack 3 is available!

    Today Microsoft released Service Pack 3 for SQL Server 2008. The build number is 10.00.5500. The announcement blog post from SQL Server Release Services team:http://blogs.msdn.com/b/sqlreleaseservices/archive/2011/10/06/sql-server-2008-sp3-is-now-available.aspx List of fixes:KB #2546951 : List of issues that are fixed by SQL Server 2008 Service ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 6, 2011
  • Downgrading a database : "You can't get there from here!"

    I see this question a lot: ''I have a SQL Server 2008 R2 database.  Can I attach it to a SQL Server 2008 SP2 instance?'' Part of this stems from the confusion over exactly what 2008 R2 is in the first place.  It is not a service pack to SQL Server 2008; it is its own, full-fledged version.  A lot of people don't fully realize this ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 21, 2011
  • SQL Server 2005 SP4 is here!

    Yes, the day has finally arrived, and a couple of weeks ahead of schedule.  Typically when Microsoft promises a release in Qx or Hx, the software comes on the last or second last day of that quarter or half.  This year, we get an early Christmas present: SQL Server 2005 SP4.   Downloads To download SP4, go to this ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 17, 2010
  • Bad habits to kick : using ancient copies of Books Online

    In my last post in this series, I talked about inconsistent table aliasing.  Today I was reminded of another behavior that DBAs and developers alike can be lazy about: keeping Books Online current. There are always going to be mistakes in any set of documentation, and this is especially true with the scope of SQL Server Books Online.  ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 22, 2010
  • Connect digest : 2009-12-31

    Like Hugo's immensely popular item pushing for SQL Server 2005 Service Pack 3, Steve Jones has created suggestions prompting new service packs for both 2005 and 2008: #522122 : Service Pack 4 for SQL Server 2005 #522123 : SQL Server 2008 Service Pack 2 In a predictability area, I suggested that online index rebuilds should populate ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 31, 2009
  • Installing Service Packs / Cumulative Updates on a SQL 2005 cluster

    In our environment, we run the task scheduler as a cluster resource, so that scheduled tasks always run on the active node.  (In ancient history, we would have scheduled tasks that weren't cluster aware - in the event of a failover, we'd have to manually disable task scheduler on the now passive node, and manually enable it on the active ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 20, 2009
  • How to really detect the version of SSMS you are running

    Earlier this week, a hotfix was released that, among other thigns, addressed an issue where, if you restored a 2000 database from 2005 SSMS, it did not go well.  The KB article (KB #972687) says that only certain versions of SSMS are affected, and proceeds to list build numbers that are from cumulative updates, not major service packs.  ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 21, 2009
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement