Category: SQL Server
SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available
May 15th
List of bugs that are fixed in SQL Server 2008 R2 Service Pack 2 CTP (Customer Technology Preview): http://support.microsoft.com/kb/2630455
How to obtain the latest service pack for SQL Server 2008 R2: http://support.microsoft.com/kb/2527041
Mic… more »
Database Engine Service Startup Options in SQL Server 2012
May 11th
Before SQL Server 2012, it was a difficult work to add a trace flag or a startup parameter other than the default startup parameters that SQL Server uses. And, by the way, how the paramater is added from SSCM - the registry keys may not be created corre… more »
CU 6 for SQL Server 2008 R2 Service Pack 1
Apr 18th
The Cumulative update package 6 for SQL Server 2008 R2 Service Pack 1 (Build 10.50.2811.0) is available:
http://support.microsoft.com/kb/2679367/
And here you can get the whole information of builds that were released after SQL Server 2008 R2 Service… more »
#CU 13 for SQL Server 2008 R2
Apr 17th
The Cumulative update package 13 for SQL Server 2008 R2 (Build 10.50.1815.0) is available:
http://support.microsoft.com/kb/2679366/
And here you can get the whole information of builds that were released after SQL Server 2012 was released:
http://sup… more »
#CU package 1 for SQL Server 2012
Apr 12th
The Cumulative update package 1 for SQL Server 2012 (Build 11.0.2316.0) is available:
http://support.microsoft.com/kb/2679368/
And here you can get the whole information of builds that were released after SQL Server 2012 was released:
http://support.… more »
PerfMon - Sizing an existing database environment
Apr 10th
Estimating the number of I/Os required for a system is crucial when sizing one or multiple existing databases on a new I/O subsystem to the SQL Server. Often in mixed environments (OLTP/RDW) we must take the blended approach for managing the I/O for our… more »
SQL 2012 RTM available for TechNet customers to download
Apr 3rd
Microsoft has announce the general availability (GA) of SQL Server 2012 for purchase and download.
You can download the latest version of SQL Server 2012 here. Also, for a deep dive on all things SQL Server 2012, check out the SQL Server 2012 Virtual L… more »
Introducing Microsoft SQL Server 2012 - Free ebook
Mar 20th
Introducing Microsoft SQL Server 2012 includes 10 chapters:
PART 1 DATABASE ADMINISTRATION (by Ross Mistry)CHAPTER 1 SQL Server 2012 Editions and Engine Enhancements CHAPTER 2 High-Availability and Disaster-Recovery Enhancements CHAPTER 3 Perf… more »
Free e-book sample chapters from Microsoft Press "Introducing Microsoft SQL Server Code ..."
Mar 9th
For a limited time, you can download this two-chapter special excerpt of Introducing Microsoft SQL Server Code Named "Denali," by Ross Mistry and Stacia Misner. This e-book excerpt includes previews of Chapter 2: High Availability and Disaster Recove… more »
SQL Server Edtions on Windows Server 8
Mar 5th
First, SQL Server 2005 will not be supported on Windows Server 8 (in any case of the Windows 8 Preview!) And what versions are supported on Windows Server 8?
Here they are:
SQL Server 2008 SP3 and above
SQL Server 2008 R2 SP1 and above
SQL… more »





