Category: "SQL Server"
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… 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 »
#CU package 5 for SQL Server 2008 R2
Dec 21st
The Cumulative update package 5 for SQL Server 2008 R2 (Build 10.50.1753.0) is available:
http://support.microsoft.com/kb/2438347/
And here you can get the whole information of builds that were released after SQL Server 2008 R2 was released:… more »
#CU package 13 for SQL Server 2005 Service Pack 3
Dec 21st
The Cumulative update package 13 for SQL Server 2005 Service Pack 3 (Build 9.00.4315) is available at:
http://support.microsoft.com/kb/2345449
And here you can get the whole information of builds that were released after SQL Server 2005 builds that were… more »
Backup, Integrity Check and Index Optimization - CTP
Dec 6th
Ola Hallengren and his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization (Best Free Tool - Gold)scripts, a solution based on stored procedures, functions, sqlcmd and SQL Server Agent jobs.
He makes some inte… more »
Microsoft Driver for PHP for SQL Server 2.0.1
Dec 2nd
The Microsoft Drivers for PHP for SQL Server provide connectivity to Microsoft SQL Server from PHP applications. In addition to some important bug fixes for the existing SQLSRV driver, version 2.0 release adds support for PDO with a new PDO_SQLSRV… more »