Microsoft® SQL Server™ 2005 Administrator’s Pocket Consultant William R. Stanek PDF

The practical, portable guide to SQL Server 2005! 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