Portable and precise, this pocket-sized guide delivers immediate answers for the day-to-day administration of SQL Server 2005. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You’ll get the precise information you need to solve problems and get the job done whether you’re at your desk or in the field!
Get fast facts to:
- Install, configure, and tune SQL Server
- Administer servers and server groups
- Manage and optimize schemas, tables, indexes, and views
- Create logins, configure permissions, assign roles, and perform other essential security tasks
- Import, export, and transform data from various sources
- Implement replication and data merging, and manage data publication and subscription
- Plan and implement a comprehensive backup and recovery strategy
- Monitor server activity and resolve performance issues
- Take charge of automation and maintenance
William R. Stanek is a Microsoft MVP with 20+ years of experience in systems management and advanced programming. He is an award-winning author who’s written more than 100 books, including Windows 7 Administrator’s Pocket Consultant and Windows Server 2008 Inside Out. He is the series editor for the Pocket Consultant line of books.