Introducing Microsoft SQL Server 2014 (Anglais) Broché – 6 mai 2014
|Neuf à partir de||Occasion à partir de|
- Choisissez parmi 17 000 points de collecte en France
- Les membres du programme Amazon Premium bénéficient de livraison gratuites illimitées
- Trouvez votre point de collecte et ajoutez-le à votre carnet d’adresses
- Sélectionnez cette adresse lors de votre commande
Les clients ayant acheté cet article ont également acheté
Descriptions du produit
Présentation de l'éditeur
NOTE: This title is also available as a free eBook on the Microsoft Download Center. It is offered for sale in print format as a convenience.
Get a head start evaluating SQL Server 2014 - guided by two experts who have worked with the technology from the earliest beta. Based on Community Technology Preview 2 (CTP2) software, this guide introduces new features and capabilities, with practical insights on how SQL Server 2014 can meet the needs of your business. Get the early, high-level overview you need to begin preparing your deployment now.
- SQL Server 2014 Editions and engine enhancements
- Mission-critical performance enhancements
- Hybrid cloud enhancements
- Self-service Business Intelligence enhancements in Microsoft Excel
- Enterprise information management enhancements
- Big Data solutions
Biographie de l'auteur
Aucun appareil Kindle n'est requis. Téléchargez l'une des applis Kindle gratuites et commencez à lire les livres Kindle sur votre smartphone, tablette ou ordinateur.
Pour obtenir l'appli gratuite, saisissez votre numéro de téléphone mobile.
Détails sur le produit
Commentaires en ligne
Commentaires client les plus utiles sur Amazon.com (beta)
If you are involved in Big Data, it includes some useful introductory info about the Microsoft approach.
So often these kinds of books feel like they are written by marketers, or people who have only just played with a beta - but this book isn't that type. I'd pay good money for this. Recommended.
I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.
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.
I'm gravely concerned by the lack of thorough and technical resources appearing for the technologies emerging with each new and rapid release, save a handful of white papers that seem to appear at the end of "v current." Even samples and tutorials are not keeping pace.