| | |  | Software Engineering | Home » » » Beginning SQL Server 2008 Administration | | | | | | | Product Promotions: | | | | | Description: | | Beginning SQL Server 2008 Administration is essential for anyone wishing to learn about implementing and managing SQL Server 2008 database. From college students, to experienced database administrators from other platforms, to those already familiar with SQL Server and wanting to fill in some gaps of knowledge, this book will bring all readers up to speed on the enterprise platform Microsoft SQL Server 2008. - Clearly describes relational database concepts
- Explains the SQL Server database engine and supporting tools
- Shows various database maintenance scenarios
What you’ll learn - To understand core concepts of relational databases
- How to install SQL Server in your environment
- How to use the tools that come with SQL Server to perform daily administrative tasks
- How to design and implement a database maintenance plan in SQL Server
- Configuring database security and protect your sensitive data from intruders
- How to meet regulatory and government compliance requirements like Sarbanes-Oxley and the Payment Card Industry (PCI) regulations
Who this book is for This book is primarily for those who are aspiring to become SQL Server 2008 database administrators. Reading this book gives you a great foundation of knowledge upon which to build a future career in database administration. You might be new to SQL Server 2008, or you might have experience with competing products such as Oracle. Either way, this book gets you up to speed quickly in managing SQL Server 2008, helping you transfer your existing knowledge into the SQL Server 2008 environment. Table of Contents - The Database Administration Profession
- Planning and Installing SQL Server 2008
- What’s in the Toolbox?
- Creating Tables and Other Objects
- Transact-SQL
- SQL Server Internals
- Storage Management Strategies
- Database Backup Strategies
- Database Restore Strategies
- Common Database Maintenance Tasks
- Automation Through SQLCMD and PowerShell
- Database Maintenance Plans
- Performance Tuning and Optimization
- SQL Server Security
- Auditing, Encryption, and Compliance
- SQL Server in the Enterprise
- Where to Go Next?
| | | Features: | |
• ISBN13: 9781430224136
• Condition: New
• Notes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!
| | | Product Details: | | | Author:
| Robert Walters | | Paperback:
| 400 pages | | Publisher:
| Apress | | Publication Date:
| October 07, 2009 | | Language:
| English | | ISBN:
| 1430224134 | | Product Length:
| 9.3 inches | | Product Width:
| 7.54 inches | | Product Height:
| 0.93 inches | | Product Weight:
| 1.35 pounds | | Package Length:
| 9.21 inches | | Package Width:
| 7.48 inches | | Package Height:
| 1.02 inches | | Package Weight:
| 1.37 pounds | | Average Customer Rating:
|  based on 2 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 2 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
7 of 7 found the following review helpful:
Great Beginner BookJun 05, 2010
By David Hayden
"Developer"
I own all kinds of SQL Server Developer books and have been developing web applications targeting SQL Server for years. What I didn't know a lot about is the proper way to install, administer, secure and maintain SQL Server and a current project has me doing a number of administrative duties on top of my typical developer duties.
This book really hit the sweet spot for me as it gave me a decent balance of concepts and recipes. It provides a good understanding of how to administer SQL Server and shows you solutions to common, day-to-day administration. First thing I wanted to do was achieve an automated, backup strategy for the various databases and was literally able to do this within a few hours using the samples in the book. I was also able to apply encryption and compression which was icing on the cake. I also added a couple of maintenance plans that kicked off nightly and weekly to target common issues that may affect performance. And then, of course, the coverage on how to add users and roles and lock down privileges was very useful to gain a better understanding of how to minimize security risks, etc.
If you are new to SQL Server 2008 administration, this is a really nice first book for someone who needs to learn the concepts quickly and apply those concepts right away. It walks you through numerous screenshots in SQL Server Management Studio and gives you useful recipes and solutions to solve common problems. The book gets you started on your journey and then as you want to learn more you can purchase advanced books as necessary.
3 of 3 found the following review helpful:
Very good for the beginnersAug 07, 2011
By Qamrul Islam
I have been a Database Programmer / Developer for a number of years. I needed to perform some Database Administration tasks at my current job, and this book was very handy explaining the basics step-by-step.
| | |
|
