yourfanat wrote: I am using another tool for Oracle developers - dbForge Studio for Oracle. This IDE has lots of usefull features, among them: oracle designer, code competion and formatter, query builder, debugger, profiler, erxport/import, reports and many others. The latest version supports Oracle 12C. More information here.
In many cases, the end of the year gives you time to step back and take stock of the last 12 months. This is when many of us take a hard look at what worked and what did not, complete performance reviews, and formulate plans for the coming year. For me, it is all of those things plus a time when I u...
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.
As DevOps methodologies expand their reach across the enterprise, organizations face the daunting challenge of adapting related cloud strategies to ensure optimal alignment, from managing complexity to ensuring proper governance. How can culture, automation, legacy apps and even budget...
You know you need the cloud, but you’re hesitant to simply dump everything at Amazon since you know that not all workloads are suitable for cloud. You know that you want the kind of ease of use and scalability that you get with public cloud, but your applications are architected in a w...
Is advanced scheduling in Kubernetes achievable?Yes, however, how do you properly accommodate every real-life scenario that a Kubernetes user might encounter? How do you leverage advanced scheduling techniques to shape and describe each scenario in easy-to-use rules and configurations?...
The cloud era has reached the stage where it is no longer a question of whether a company should migrate, but when. Enterprises have embraced the outsourcing of where their various applications are stored and who manages them, saving significant investment along the way. Plus, the clou...
While some developers care passionately about how data centers and clouds are architected, for most, it is only the end result that matters. To the majority of companies, technology exists to solve a business problem, and only delivers value when it is solving that problem. 2017 brings...
DevOps is under attack because developers don’t want to mess with infrastructure. They will happily own their code into production, but want to use platforms instead of raw automation. That’s changing the landscape that we understand as DevOps with both architecture concepts (CloudNati...