Hardware Archives - Page 2 of 2 - SQL Authority with Pinal Dave

This month's discount Comprehensive Database Performance Health Check Testimonials

A moving van at the open door of a new house at dusk, one last box on the ramp

Moving a Database to New Hardware With Little Downtime

April 28, 2012

SQL Tips and Tricks

DBA, Hardware, Log Shipping, SQL Backup and Restore, SQL Migration

Moving a database to new hardware with little downtime uses early restore, a maintained log chain, final synchronization, and a tested client switch.

A carpenter measuring an old doorway with a stretched string, fresh timber waiting uncut on trestles.

Sizing a New SQL Server

May 16, 2010

SQL Tips and Tricks

DBA, Hardware, SQL CPU, SQL Memory

Sizing a new SQL Server starts with workload evidence, growth, and recovery goals to estimate CPU, memory, storage, and headroom.

Two brass balance weights of different size on a laboratory balance

SQL SERVER – The Difference between Dual Core vs. Core 2 Duo

May 2, 2010

SQL Tips and Tricks

Hardware, SQL Server

Dual Core was a brand, not a core count. What actually matters for SQL Server is cores, clock speed and licensing. How to see what you really have.