Installation Archives - SQLPerformance.com

General Database Server Build and Deployment Instructions

Glenn Berry (@GlennAlanBerry) of SQLskills.com shares his starting template for database server installation checklists.

Glenn Berry ◆ December 2, 2013

21

Prepare a new VM for SQL Server 2014 CTP1

Aaron Bertrand (@AaronBertrand) of SQL Sentry gives some quick advice about SQL Server 2014 CTP1: Plan to install it in its own virtual machine, because at this point it doesn't play well with others.

Aaron Bertrand ◆ June 25, 2013

6

Avoid HA/DR Solution Self-Delusion

SQLskills.com's Joe Sack (@josephsack) discusses some of the assumptions people can make when deciding on high availability / disaster recovery solutions they're going to use with SQL Server.

Joe Sack ◆ June 18, 2013

1

Making the Case for Regular SQL Server Servicing

Glenn Berry (@GlennAlanBerry) of SQLskills.com gives some pretty strong arguments for keeping your SQL Server instances current on both Service Packs and Cumulative Updates.

Glenn Berry ◆ March 28, 2013

7

Selecting a Processor for SQL Server 2012

Since Microsoft revamped the licensing model for SQL Server 2012, it is especially important to do some thoughtful analysis before you decide exactly which processor to use for a database server that will be running SQL Server 2012. The move to core-based licensing for SQL Server 2012 Enterprise Edition means that a careless decision about precisely what processor you will be running on can cost both a great deal of money and a great deal of performance and scalability.

Glenn Berry ◆ January 9, 2013

22

SQL Server 2012 Service Pack 1 & Cumulative Update 1

Recently, Microsoft pushed out Service Pack 1 for SQL Server 2012, and they quickly followed up with Cumulative Update 1 for Service Pack 1. The reason for this is that the service pack – due to longer development and regression testing cycles – did not contain any of the fixes from RTM Cumulative Updates 3 & 4. Since many people have waited – based on mostly speculative bias at this point – to even start testing SQL Server 2012 until Service Pack 1 was released, I thought it might be useful to cover a couple of the scenarios you might come across.

Aaron Bertrand ◆ December 12, 2012

6