Another Unleashed behemoth!!! It is a whopping 1683 of printed pages and 2765 pages when you include the additional chapters available in the eBook you get with the printed book. If this book doesn't contain the information you need about SQL Server 2012, then you probably won't find it anywhere.
Just like I am not a server administrator, I am not a Database Administrator (DBA). I don't want to be a DBA, nothing against DBAs, but I just think it is a full time job. It is not possible for me to keep up with my .NET, iOS, Enterprise Architecture, and Software Architecture skills and also be an effective DBA.
Of course I have to be familiar enough with them to architect scalable, secure, high performing software, so I chose this book as my learning resource. It is a great resource. I have not gone too it and come away disappointed yet.
What does make this nice is there is a lot of developer content included with the book in addition to the DBA topics.
The book is broken down into 10 parts. Below is the entire Table of Contents-
Part I: Welcome to Microsoft SQL Server Chapter 1. SQL Server 2012 Overview Chapter 2. What’s New in SQL Server 2012 Chapter 3. Examples of SQL Server Implementations
Part II: SQL Server Tools and Utilities Chapter 4. SQL Server Management Studio Chapter 5. SQL Server Command-Line Utilities Chapter 6. SQL Server Profiler
Part III: SQL Server Administration Chapter 7. SQL Server System and Database Administration Chapter 8. Installing SQL Server 2012 Chapter 9. Upgrading to SQL Server 2012 Chapter 10. Client Installation and Configuration Chapter 11. Database Backup and Restore Chapter 12. Database Mail Chapter 13. SQL Server Agent Chapter 14. Administering SQL Server 2012 with PowerShell Chapter 15. SQL Server Policy-Based Management
Part IV: SQL Server Security Administration Chapter 16. Security and Compliance Chapter 17. Security and User Administration Chapter 18. Data Encryption
Part V: Database Administration Chapter 19. Creating and Managing Databases Chapter 20. Creating and Managing Tables Chapter 21. Creating and Managing Indexes Chapter 22. Implementing Data Integrity Chapter 23. Creating and Managing Views Chapter 24. Creating and Managing Stored Procedures Chapter 25. Creating and Managing User-Defined Functions Chapter 26. Creating and Managing Triggers Chapter 27. Transaction Management and the Transaction Log Chapter 28. Database Snapshots Chapter 29. Database Maintenance
Part VI: SQL Server Performance and Optimization Chapter 30. Data Structures, Indexes, and Performance Chapter 31. Understanding Query Optimization Chapter 32. Query Analysis Chapter 33. Locking and Performance Chapter 34. Database Design and Performance Chapter 35. Monitoring SQL Server Performance Chapter 36. SQL Server Database Engine Tuning Advisor Chapter 37. Managing Workloads with the Resource Governor Chapter 38. A Performance and Tuning Methodology
Part VII: SQL Server High Availability Chapter 39. SQL Server High Availability Fundamentals Chapter 40. Data Replication Chapter 41. Database Mirroring Chapter 42. SQL Server Failover Clustering Chapter 43. SQL Server AlwaysOn and Availability Groups
Part VIII: SQL Server Application Development Chapter 44. What’s New for Transact-SQL in SQL Server 2012 Chapter 45. Transact-SQL Programming Guidelines, Tips, and Tricks Chapter 46. Advanced Stored Procedure Programming and Optimization Chapter 47. SQL Server and the .NET Framework Chapter 48. SQLCLR: Developing SQL Server Objects in .NET Chapter 49. Using XML in SQL Server 2012 Chapter 50. SQL Server Service Broker Chapter 51. SQL Server Full-Text Search Chapter 52. Working with SQL Azure
Part IX: SQL Server Business Intelligence Features Chapter 53. SQL Server 2012 Analysis Services Chapter 54. SQL Server Integration Services Chapter 55. SQL Server 2012 Reporting Services Chapter 56. Master Data Services and Data Quality Services Chapter 57. Parallel Data Warehouse
Part X: Bonus Chapters Chapter 58. Managing Linked Servers Chapter 59. SQL Server Disaster Recovery Planning Chapter 60. SQL Server Configuration Options
Almost every chapter begins with a section that covers what is new in SQL Server 2012. There are a ton of diagrams that are really helpful with learning the topics, and a ton of great tables that help to summarize topics.
The thing I like most about this book is the quantity of information about profiling, tracing, monitoring, and performance. There is a whole chapter on locking!!! The authors writing style makes it an easy to read book, or at least as easy as server reading can get.
My only gripe about the book is that over 1000 of the pages are only available in eBook format. It is time to break this book down into 2, or maybe 3 printed volumes. I use eBooks for searching for topics, but do not read them. After 8 - 10 hours a day staring at a computer I don't want to read a book on one. This will be my last edition of this awesome book if I can't get it all in print when the next edition is released.
The code downloads are organized by chapter and usable are very usable. Each chapter has a folder.
If you are in anyway involved with SQL Server 2012, you owe it to yourself to get this book. It will not leave my side!!!!
I highly recommend this book for DBA's, developers, and architects.
Darktrace is the world's leading AI company for cyber security. Created by mathematicians from the University of Cambridge, Darktrace's Enterprise Immune System is the first non-consumer application of machine learning to work at scale, across all network types, from physical, vi...
Data center, on-premise, public-cloud, private-cloud, multi-cloud, hybrid-cloud, IoT, AI, edge, SaaS, PaaS... it's an availability, security, performance and integration nightmare even for the best of the best IT experts.
Organizations realize the tremendous benefits of everyt...
Now is the time for a truly global DX event, to bring together the leading minds from the technology world in a conversation about Digital Transformation. DX encompasses the continuing technology revolution, and is addressing society's most important issues throughout the entire ...
Atmosera delivers modern cloud services that maximize the advantages of cloud-based infrastructures. Offering private, hybrid, and public cloud solutions, Atmosera works closely with customers to engineer, deploy, and operate cloud architectures with advanced services that delive...
Intel is an American multinational corporation and technology company headquartered in Santa Clara, California, in the Silicon Valley. It is the world's second largest and second highest valued semiconductor chip maker based on revenue after being overtaken by Samsung, and is the...
Your registrations includes: Golden Pass Delegates will receive full conference access on October 20-22, 2008 including: Lunch and Coffee Breaks, Collectible Bag and Archives of all sessions on DVD. Includes access to all Conference Sessions including the Technical Sessions, Exhibits, Keynotes, Vendor Technology Presentations, and Power Panels.
AJAXWorld offers the undisputed best platform to position your company as a leading vendor in the fast-emerging marketplace for AJAX and Enterprise Web 2.0.
Who Should Attend?
• CTOs & VPs of Engineering
• Directors of Technology
• Sr. User Interface Architects
• Front-End Engineers
• VCs & Industry Analysts
• Directors of Business Development
• Software Engineers
• Senior Architects
• Application Programmers & Software Developers
• Project Managers
• Web Programmers & Designers
• Companies & Organizations that need to stay in front of the latest Web technology
AJAXWorld Security Bootcamp
Introducing at AJAXWorld RIA Conference 2008 West the world's first-ever full, one-day immersive "AJAX Security Bootcamp" - led by one of the world's foremost AJAX security experts and teachers, HP's Billy Hoffman.