Blog - comments

I don't know any documentation about those EC and ECJ. And I'm sorry I don't know the consequence of...
Hi Franck thanks for clarifying this. I was already wondering about the difference between EC and EC...
Reiner
Sometimes with a group of transactions generating many archived logs, shipped and applied on standby...
Rick Chen
Thanks Franck, Let's change active/passive solution to other words. how about "RMAN script manual ma...
Rick Chen
Hi Franck, almost missed that article... - thank you! Having studied history for a lot of years I li...
Martin Preiss
Blog Stéphane Savorgnano SQL Server 2012: Service Pack 1 (SP1) now available

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.

SQL Server 2012: Service Pack 1 (SP1) now available

Some days ago, the 6th of November, the first Service Pack for SQL Server 2012 was made available on the Microsoft website.

SQL Server 2012 Service Pack 1 includes SQL Server 2012 Cumulative Update 1 (CU1) and SQL Server 2012 Cumulative Update 2 (CU2) and therefore all hotfixes that they were included.

Which issues are fixed in the SP1:

There are 13 issues fixed:

  • 2 for Availability Group
  • 1 for SSIS
  • 1 for Data Quality Client
  • 4 for Data Quality Services
  • 1 for Cluster
  • 4 for Master Data Services

What’s new for SQL Server 2012 SP1:

  • Cross-Cluster Migration of AlwaysOn Availability Groups for OS Upgrade
  • Selective XML Index
  • DBCC SHOW_STATISTICS works with SELECT permission
  • New DMV returns statistics properties(sys.dm_db_stats_properties)
  • SSMS Complete in Express
  • SlipStream Full Installation(You can install a SQL Server 2012 SP1 directly)
  • Business Intelligence highlights (with SQL Server 2012 SP1, Office and SharePoint Server 2013 )
  • Management Object Support Added for Resource Governor DDL

Historic of SQL Server 2012

If you update your SQL Server 2012, you will have a new build version: 11.00.3000.

I give you a quick summary of Microsoft SQL Server 2012 builds since the beginning:

Date SQL Server 2012 version Build

November 2010

Community Technology Preview 1 (CTP1)

11.00.1103

July 2011

Community Technology Preview 3 (CTP3)

11.00.1440 

November 2011

Release Candidate 0 (RC0)

11.00.1750 

December 2011

Release Candidate 1 (RC1)

11.00.1913 

March 2012

RTM

11.00.2100

April 2012

Cumulative Update 1 (CU1)

11.00.2316

June 2012

Cumulative Update 2 (CU2)

11.00.2325

August 2012

Cumulative Update 3 (CU3)

11.00.2332

October 2012

Microsoft Security Bulletin MS12-070

11.00.2376

October 2012

Cumulative Update 4 (CU4)

11.00.2383

November 2012

Service Pack 1 (SP1)

11.00.3000

If you want more informations and download this SQL Server 2012 Service Pack 1 click here.

Conclusion

After eight months Microsoft has released first Service Pack for SQL Server 2012.
SQL Server Service Pack 1 includes fixes to issues and also quit a lot of good new features.
Service Pack are very critical and important for bug fixing point of view and product upgrade so take care to install it quickly.
Microsoft has also released in october a Security Bulletin to resolve a vulnerability in Microsoft SQL Server on systems running SQL Server Reporting Service. So if you use SSRS don't forget also to install this security patch.
Microsoft provides also SQL Server 2012 Feature Pack which is a collection of stand-alone packages which provide additional value for Microsoft SQL Server 2012 SP1.

Rate this blog entry:
1

Stéphane Savorgnano is Consultant at dbi services. He has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. Stéphane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012 as well as Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. Stéphane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking / Financial Services, Chemicals & Pharmaceuticals, etc.

Comments

  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Sunday, 23 November 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter