1 internautes sur 1 ont trouvé ce commentaire utile
- Publié sur Amazon.com
Format: Format Kindle
I have written a detailed chapter-by-chapter review of this book on [...] the first and last parts of this review follow:
Microsoft’s newly released SQL Server 2014 database is closely followed by its first book, how does it fare?
This is a small book, consisting of 125 pages (as a PDF), spread over six chapters. As explained in its introduction, it doesn’t cover everything, but rather provides a high-level overview of SQL Server 2014 functionality. It’s deemed suitable for DBAs, database developers, business intelligence users, power users and technical decision makers.
The book can be downloaded for free, in various formats, at: [...] although it will also be available commercially in print format.
The first three chapters relate to database administration, and the last three relate to business intelligence development.
Below is a chapter-by-chapter exploration of the topics covered.
Chapter 1 SQL Server 2014 editions and engine enhancements
The chapter opens with an outline of availability enhancements, namely the AlwaysOn Availability Groups have had the maximum number of secondary replicas increased from 4 to 8. This provides a greater ability to offload reporting/backups/extraction from the primary, as well as providing improved High Availability (HA) and Disaster Recovery (DR) options. The new Azure Replica wizard allows you to store a secondary in Windows Azure (Microsoft’s public cloud), providing additional DR safety.
Backup and restore have been enhanced, and despite the attention given to HA secondaries, backups and restores are still the cornerstone of recovery. It is now possible to backup to a URL destination (i.e. to Windows Azure), additionally, there is now native encryption for backups.
We now enter the area that has in many ways defined the release, scalability and performance enhancements. The major enhancements being:
•Use of In-Memory OLTP [Online Transaction Processing] (For most people this will be the most important feature of SQL Server 2014. Tables can now be stored in memory, reducing I/O, this together with a new lock/latch free concurrency model should ensure significantly improved throughput. Case studies have shown improvements in the range of x30)
•More computing resources (Microsoft’s Cloud using Windows Server 2012 R2, supports 2,048 logical processors for a Hyper-V host. A virtual environment can support 64 virtual CPUs and 1TB of memory)
•Resource Governor enhancements (I/O has been added to the resources to limit/prioritise)
•Buffer pool extension (This allows integration of non-volatile RAM [e.g. SSDs] with the database engine buffer pool, which can significantly improve I/O, giving less latency, faster throughput, more caching and faster queries)
•Columnstore enhancements (These are now updateable)
•Scale networking and storage (Features of Windows Server 2012 R2 provide improved scale and storage functionality for SQL Server 2014)
Security enhancements include new permissions to: connect any database, impersonate any login, select all user securables, and alter any database event session. Also included in this section is a diagram to remind readers that Microsoft has the best track record for security amongst the major database vendors (i.e. SQL Server, Oracle, MySQL, and DB2).
This is the first SQL Server 2014 book published, it’s relatively brief, consisting of just 6 chapters. The first 3 chapters relate to SQL Server 2014, and the other 3 chapters relate to other subjects that do not belong to this book.
The first 3 chapters, although brief, provide a good general technical overview of the major changes and functionality provided in SQL Server 2014. I would rate the first 3 chapters as 4 out of 5.
As you might expect, there is a degree of marketing/adverti$ing associated with this book, however it is not too onerous, just remember other solutions exist, especially with the cloud and big data.
One notable consideration is the mention of Microsoft’s cloud solution at almost any opportunity, it permeates the whole book. That said, some valid arguments are given for the inclusion of the cloud as part of your solutions.
If you need a technical overview of the new features of SQL Server 2014, I can recommend you read the first three chapters of this book.