The Reluctant DBA: SQL Server Basics

Price: $19.95

More and more companies are asking their IT pros and developers to manage their SQL Server systems instead of having a dedicated DBA on staff. However, most of these “reluctant DBAs” have little to no experience with relational database administration and are looking for quick answers to their questions on SQL Server basics. Here’s a compilation of SQL Server Magazine articles that provide reluctant DBAs with information about how to get started with the fundamentals of administering a SQL Server database including lots of basic T-SQL, plus basics on storage, performance tuning, security, and backup and recovery.

Organization by Topic

Overviews: How to Get Started with SQL Server

  • Seven Tips for SQL Server Production DBAs—InstantDoc ID 102136 (database administration)
  • The Mega Guide to Free SQL Server Tools—InstantDoc ID 102244
  • 9 Habits of Highly Effective DBAs—InstantDoc ID 46231
  • SQL Server 101: Essential Concepts for Windows Administrators—InstantDoc ID 46265
  • SQL Server Consolidation—InstantDoc ID 95461 (consolidation)

Storage

  • Maximize Storage Performance—InstantDoc ID 100893 (Storage, performance)
  • Configuring Storage for Your SQL Server Environment—InstantDoc ID 101672 (Storage)

Performance Tuning

  • Time to Defrag Your Indexes?—InstantDoc ID 102460 (performance tuning, indexing)
  • Finding Your Top 10 SQL Server Queries—InstantDoc ID 100121 (performance tuning)
  • Performance Secrets for SQL Server Developers—InstantDoc ID 99148 (performance tuning, development)

Security

  • 10 Steps to SQL Server 2005 Security—InstantDoc ID 95173
  • Securing Your SQL Server Environment—InstantDoc ID 102775 (Security)

Backup and Restore and Disaster Recovery

  • Backup and Restore Fundamentals—InstantDoc ID 98371 (Backup and recovery)
  • A Practical Approach to Database Mirroring—InstantDoc ID 95293 (high availability, disaster recovery)
Your Shopping Cart

Sponsored Introduction Continue on to (or wait seconds) ×