SQL DBA Guru

• Backup and Restore  
  • Changing the default backup path
• Books
• Clustering
  • Installing SQL Server 2008 on Windows Cluster
• Interview Related
  • Concerns of an Interviewer
  • Interview Questions
• Standards and Best Practices
  • Database Standards
  • Security Standards
• DBA Related
  • Way to SQL Server DBA without any prior experience!
  • What to do during first few days as a SQL Server DBA?
  • What is the way or Career Path to becoming a DBA?
  • Topics to learn for becoming a SQL Server DBA
  • SQL Server Cumulative Updates And Builds
• Analysis Service
  • No mapping between account names and security IDs was done.
• General
  • Step by Step Database Migration
  • How to transfer Logins from one SQL Server to another?
  • How to grant a permisison to all the databases
  • Licensing Model
  • Shrinking a large MSDB database
• Monitoring
  • CPU Usage
  • DB Growth
• Powershell
• Scripts
• White Papers
  • Troubleshooting Performance Issues

Identify SQL Server version and edition

Download Service Pack 4 for Microsoft SQL Server 2005

Download Service Pack 2 for Microsoft SQL Server 2008

Download CUP2 for SQL Server 2008 R2

Download SharePoint Server 2010