MS SQL 2012 SP1 released

Microsoft SQL Server 2012 service packs are cumulative updates and upgrade all editions and service levels of SQL Server 2012 to SP1. This service pack contains SQL Server 2012 Cumulative Update 1 (CU1) and Cumulative Update 2 (CU2).
This download site contains the following packages and service patches for the Microsoft SQL Server 2012 SP1 release:

  1. Microsoft SQL Server 2012 SP1 Update – this package contains the Microsoft SQL Server 2012 Service Pack 1 update to be applied to existing SQL Server 2012 installations.
  2. Microsoft SQL Server 2012 SP1 Slipstream– This package provides the capability to perform new SQL Server 2012 instance installations (or SQL Server 2008/SQL Server 2008 R2 Upgrades) culminating with Service Pack 1 pre-installed. The slipstream installation package consists of a compressed self-extracting .exe and a ‘.box’ payload file that contains the original SQL Server 2012 release along with Service Pack 1. The .exe file can be directly executed, or utilized from the command prompt just as SQL Server 2012 Setup.exe would be (See Install SQL Server 2012 from the Command Prompt).

You can download the service pack here.

Free E-Book–Introducing SQL Server 2012

If you are looking to have a book on hand whilst getting to grips with SQL Server 2012 then you’ll be interested in the free E-book currently being offered by MS Press and written by Ross Mistry (@RossMistry) and Stacia Misner (@StaciaMisner). You can download the PDF version of this title here (288 pages; 10.8 MB).

sql2012

PART I DATABASE ADMINISTRATION

Continue reading “Free E-Book–Introducing SQL Server 2012”

how to shrink scvmm 2012 DB

Ok, you have had your SCVMM server running for a while now, all roles and services installed on a single server. Remember that the SCVMM 2008 R2 server installs a SQL 2005 Express if you don’t specify another instance for this purpose.
The storage limit for a database in SQL 2005 Express is 4GB, so what do you do when the VirtualManagerDB_log starts to grow out of control ? Continue reading “how to shrink scvmm 2012 DB”

SQL Server 2008 R2: Unlock the Locks

Database troubleshooting is not for the faint of heart, especially when it comes to troubleshooting locking and blocking problems. Sometimes the elephant in the room is actually a rhino, a problem that seems like something else that can make troubleshooting all the more difficult and frustrating. Other times, the answer you’re looking for is staring you right in the face. This is the case with SQL Server 2008 R2, which has a known locking issue you can resolve by simply applying the latest service pack or update. Continue reading “SQL Server 2008 R2: Unlock the Locks”