I presented two sessions at TechInsight 2010 in Kuala Lumpur, Malaysia, from June 29 to July 1, 2010. The best part of the trip was the people and their response.
Sizing a New SQL Server
Sizing a new SQL Server starts with workload evidence, growth, and recovery goals to estimate CPU, memory, storage, and headroom.
Installing SQL Server Silently From the Command Line
Installing SQL Server silently takes a reviewed ConfigurationFile.ini, required setup switches, and a check of logs and active instance settings.
A Daily DBA Checklist You Can Run as One Script
Run a daily DBA checklist that reports stale backups, failed jobs, offline databases, recent errors, low volume space and current blocking.
Watching the tempdb Version Store
Watch the tempdb version store with per-database space DMVs, find transactions that delay cleanup, and plan capacity from trends.
SQL SERVER – Enumerations in Relational Database – Best Practice
Marko Parkkola from Finland shares a best practice for enumerations in relational database design: the right way to store them and one clearly wrong way.
Backing Up SQL Server Express Without Agent
Backing up SQL Server Express requires a BACKUP script, sqlcmd, Windows Task Scheduler, retention rules, and proof that restores work.