Category: "SQL Server"

PerfMon - Sizing an existing database environment

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

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

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 ..."

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

  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 »

A long, long time ago ...

A long time ago :-) more »

#CU package 5 for SQL Server 2008 R2

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

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

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

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 »