SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

SQL Server 2008 R2 Update: Enhancements and Cloud Integration - May 2010

oberon avatar
oberon
17 diapositives · 318 Views · Aug 06, 2014

In May 2010, SQL Server 2008 R2 was launched, offering significant improvements and features for users. With the introduction of SQL Azure, Microsoft aims for a cloud-based SQL server experience that complements traditional on-premise installations. Key highlights include enhanced scalability, client-side PowerPivot for self-service business intelligence, and new server-side functionalities like improved compression and Hyper-V support. The continuous monitoring of industry trends emphasizes SQL Server's adaptability to evolving business demands, making it essential for modern IT infrastructures.

SQL Server 2008 R2 Update: Enhancements and Cloud Integration - May 2010 - slide 1
01 / 17SQL Server 2008 R2 Update: Enhancements and Cloud Integration - May 2010
1 / 17

Télécharger la présentation

SQL Server 2008 R2 Update: Enhancements and Cloud Integration - May 2010
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. SQL Server Update – May 2010 Gavin Paynehttp://blog.gavinpayneuk.com twitter: @GavinPayneUK

  2. Presentation Summary • SQL Server 2008 R2 will be available in May • SQL Azure is now available and gaining credibility • SQL Server is now scaling massively

  3. Recent Industry Observations from MSFT • Current Business TrendsGlobalisation – 24/7 and distributed workloadsCompliance – Information handling under scrutinyBusiness Intelligence – Covered on a further slideAgility – Change, acquisition and mergers now common • Current Technology TrendsVirtualisation– The biggest request of Microsoft right nowCloud– Bleeding edge adoption building concept confidenceHardware– Nehalem technology, 8-core CPU, SSD

  4. SQL Server 2008 R2 – What’s New? Highlights • Client-side Features PowerPivot– Self-service BI through Excel • Server-side FeaturesEnhanced Hyper-V support – virtualisation enablerDatacenter edition – delivering massive scalabilityEnhanced compression – operational I/O reducerSysprep support – simplifying implementation

  5. Why Client-side BI Now? • In the economic downturn BI was a growth market • Marketplaces and their data were changing by the hour • End-users wanted to analyse and report in real time • Data warehouses refreshed too infrequently • And were owned, defined and controlled by IT • Solution – self-service BI tools which IT can still manage

  6. SQL Server 2008 R2 – What’s Changed? Two notable changes in R2: • LicensingEnterprise and Datacenter editions align with Windows- VM usage rights changed • Backup Compression Now available in Standard Edition- Game changer for DBAs and 3rd party backup compression providers

  7. SQL Server 2008 R2 – Product Breadth Reminder of what now comes in the SQL Server box:

  8. SQL Server 2008 R2 Parallel Data Warehouse • Appliance format massive scale data warehouse • Sold with specific hardware as a complete solution • Scales to hundreds of TBs • Deploys multiple centrally controlled database nodes • SQL Server Fast Track methodology for smaller DWs

  9. SQL Azure • Cloud-based SQL Server • Relational database to compliment Windows Azure • Designed to mirror SQL Server 2008’s core functionality • At a price point which cannot be ignored for very long

  10. SQL Azure • Launched in February 2010 • Already a small but notable and increasing user base • Currently aimed at “department sized” applications • 1GB and 10GB offerings today • Designed for HA but no database backup facility yet

  11. SQL Azure • Microsoft aim for Service Updates every 8 weeks • Due soon are:Reporting services and BI functions Spatial data types 50GB database option • Unlike other vendors, Microsoft already have the functionality written, they just need to re-deploy it to the cloud

  12. SQL Azure • Microsoft’s long term aim is to “make cloud irrelevant” • Where your code and data are hosted is based on today’s business requirements, could change at midday • However, in the medium term cloud and on-premise versions of SQL Server may have parallel functionality roadmaps

  13. SQL Server Scalability • SQL Server is now the most demanding application to use Windows Server – everything else scales out • SQL Server can and is now powering the world’s most demanding business application infrastructures • Microsoft’s SQLCAT team focus on delivering these platforms - http://sqlcat.com/ • Their web site is loaded with best practice

  14. SQL Server Scalability In Depth • Windows Enterprise and Datacenter editions can deliver massive computing power to SQL Server • 128 CPU cores, 2TB memory, 200+ TB OLTP databases • Intel’s latest Nehalem CPUs are powering a revolution in X64 server capability • Itanium support has been dropped – no longer required

  15. SQL Server Scalability Tips From The Field • Hyper-threading is back and recommended • NUMA boundaries will become part of daily life • NIC activity is now a workload of its own • Disk alignment maybe simple but is a huge quick win • Centralised SQL Server management will be essential as databases outnumber DBAs

  16. Solid State Devices • SSDs have now arrived, expensive but mainstream • Not all SSDs are the same, some using SATA • FusionIO appearing as a popular brand • Very low latency, very high I/O rates • Not a cure for badly designed schemas or SANs, but will no doubt be used as one

  17. Conclusion • SQL Server 2008 R2 has been released • Some good changes for those motivated to use them • SQL Azure has made a good entrance and will become a no-brainer for some future deployments • Virtualisation and consolidation are today’s biggest activities within IT – SQL Server can be very efficient • SQL Server can also be very powerful