SQL Server 2012 DBA Recipes is chock-full of task-oriented examples for database administrators faced with more tasks on their to-do lists than fit into a day's work. Examples are couched in Apress' popular, problem/solution format, and cover the gamut from small-business to enterprise database environments. You're provided with effective and proven solutions to accomplish just about any DBA task that you may encounter during your daily work. You can feel confident taking the reliable solutions that are demonstrated in this book and applying them in your own working or testing environment.
The solutions in SQL Server 2012 DBA Recipes have been built and tested using the most current SQL Server 2012 software. Robust coverage is given to important new features such as SQL Server AlwaysOn. You also get solid-coverage of DBA-amplification features such as Policy-Based Management and PowerShell that serve as long levers by which you can move the world, or at least do more in less time, and with less effort. SQL Server 2012 DBA Recipes is the perfect lever by which you can extend your productivity as a DBA. Archimedes would be proud.
- Covers the latest release, including new features such as SQL Server AlwaysOn and FileStream.
- Shows the use of performance-amplifying tools such as PowerShell and Policy-Based Management.
- Aids in removing the burden of mundane tasks, enabling you to focus on the more interesting, proactive side of database administration.
Sprache
Verlagsort
Zielgruppe
Produkt-Hinweis
Broschur/Paperback
Klebebindung
Maße
Höhe: 235 mm
Breite: 191 mm
Gewicht
ISBN-13
978-1-4302-5089-0 (9781430250890)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Edgar Lanting is a professional database administrator who is currently working as a database consultant and likes to work with Microsoft SQL Server, Oracle RDBMS, and MySQL Server databases. Edgar has been an IT Professional for over 18 years. He started out as a Unix and Windows System Administrator. While working alongside a team of DBAs, he decided to join them and never looked back. Since then he's specialized as a technical DBA. His system administration experience is invaluable, enabling him to see the broader picture and look at an issue from different perspectives. When not working, Edgar enjoys spending time with his wife and pet dog in a small town in the Netherlands.
- Backup and Recovery
- Security
- User Administration
- Jobs and Automation
- Performance and Tuning
- PowerShell
- Notifications
- Policies
- Encryption
- Snapshots
- Maintenance
- Transactions
- Importing and Exporting
- FileStream
- AlwaysOn
- Mirroring and Replication
- Appendix A
