SQL Server 2008 & 2008 R2 End of support Level 300

1. SQL Server 2008 & 2008 R2End of supportLevel 300 Speaker Name Title

2. When will end of support happen? SQL Server 2008 and 2008 R2 will no longer be supported starting on July 9, 2019. Learn more about the SQL Server support lifecycle: support.microsoft.com/lifecycle/

3. Avoid data breaches, unplanned maintenance costs and begin modernization before the end of support Mitigate risks with platform security and compliance Modernize to innovate Upgrade with better cost efficiency There will be no access to critical security updates, opening the potential for business interruptions Maintaining legacy systems can get expensive quickly Grow your environments with data, analytics and the cloud

4. Security & compliance Without security updates you may fail to comply with standards and regulations that can seriously hamper your ability to: • Protect against hackers, malware with root access to machines, man in the middle scenarios, and government subpoenas • Securely purge for customer data, leaving it vulnerable to access by outside parties • Utilize E2E data protection across SQL Server and frequently used together services At the end of support for SQL Server 2008 and SQL Server 2008 R2, there will be no more security updates and hotfixes from Microsoft, opening the door to potential business interruptions. Don’t take the risk of losing precious data or having issues with your business applications performance because of potential weaknesses of your environment by not upgrading! Regulatory compliance standards may no longer be met at end of support, such as: • GDPR for companies who do business in the EU • PCI DSS for storing and processing payment data • HIPAA for medical patient privacy • GLBA for financial institutions

5. DATA Security & Privacy solutions from SQL Server Help safeguard your business with a suite of security features to help with compliance

6. Cost efficiency At the end of support for SQL Server 2008 and 2008 R2, your maintenance costs may increase as your IT staff maintains your aging hardware, keeps intrusion and firewalls up to date, and handles network segmentation. Add six more years of product support beyond the end of Extended Support with SQL Server Extended Security Updates Windows Server Extended Security Updates and SQL Server Extended Security Updates support period for 2008/R2 versions

7. Modernizeto innovate The MODERN DATA Estate SQL Server family have evolved a lot since SQL Server 2008 and 2008 R2. With SQL Server 2017, customers don’t just get an update – they get in-memory performance across workloads, mission-critical high availability, end-to-end mobile BI, and in-database advanced analytics with security features built-in to help protect your data at rest and in motion – now on Linux and Docker containers HYBRID On-premises Private cloud Cloud Operational databases Operational databases Data warehouses Data warehouses Data lakes Data lakes Reason over any data, anywhere Flexibility of choice Security and performance

8. Pick your target destination Hybrid Cloud PaaS Azure SQL Database Virtualized Database Shared Infrastructure / Lower cost Easy and seamless migration to your modernization target of choice with Azure Database Migration Service On-premises: Complete data platform with mission critical performance and real time reporting Private Cloud: Dedicated business resources inside the enterprise IaaS: Keep management while reducing TCO with Azure VMs PaaS: Fully managed solution with high availability and scalability IaaS SQL Server in Azure VM Virtualizes Machines Virtual SQL Server Private Cloud Virtualized Machine + Appliance SQL Dedicated Infrastructure/ Higher cost Physical SQL Server Physical Machine (raw iron) SQL Higher administration Lower administration

9. 5 reasons SQL Server & Windows Server are better together Security built into both Major cost savings and unprecedented performance boosts Database uptime and reliability synergies Reach insights faster by running analytics at the point of creation Consistent data environment across hybrid cloud environments

10. Windows Server 2016 &SQL Server 2017 • SQL Cluster Hardware innovationsHardware innovations allow flexibility in High Availability and Disaster Recovery solutions in Windows Server 2016 with multi-domain and non-domain clusters Leverage the latest hardware innovations for your SQL Server 2017 solutions by upgrading to Windows Server 2016 Support for 24TB of memory from OS support Windows Server 2016 enables support for 640 cores Support for Storage Class Memory (SCM) such as NVDIMM-N to enable superfast disk IO SQL Server 2016/2017 Transaction Log tail on SCM to speed up log commits and to accelerate the database FlexibilityFlexibility in building redundant storage for business critical databases with Storage Spaces Direct with Direct Attached Storage (DAS) replication across nodes. A cost effective way to build redundant storage sub-systems. Achieve same SAN system redundancy with better TCO and faster data IO DB DB DB DB

11. more than an upgrade withSQL server 2017 With SQL Server 2017, your business doesn’t just receive an updated database. SQL Server 2017 is the industry leading data platform that provides built-in security, enhanced performance, and analytics to modernize your business. Now available also on Linux, SQL Server 2017 is the first commercial database with AI built-in and out-of-the-box. Transform your enterprise applications with a complete and robust mission critical data platform by upgrading your current SQL Server to SQL Server 2017. SQL #1 OLTP performance¹ #1 DW performance¹ #1 price/performance¹ #1 price/performance in TPC-H non-clustered as of 9/1/2017 - http://www.tpc.org/3323 #1 TPC-H non-clustered benchmark as of 9/1/2017 - http://www.tpc.org/3323 #1 TPC-E performance as of 9/1/2017 - http://www.tpc.org/4075

12. What’s New in SQL Server 2017 Since SQL Server 2008 & 2008 R2 OLTP Performance Security Business Intelligence Hybrid Cloud Data-tier application component project FileTablebuild on FILESTREAM Remote Blob Storage with SharePoint 2016 Statistical Semantic Search Contained Database Authentication Automatic Plan Correction Enhanced productivity and performance Power View Configurable reporting alerts Reporting as SharePoint Shared Service Disaster Recovery environment in Azure VMs using Always On Availability groups Stretch database Hybrid scenarios with SSIS Enhanced backup to Azure Easy migration to the cloud Secure backups to Azure with managed backups Enhanced connectors, new transformations, object-level security, ragged hierarchies** Mobile BI Enterprise-grade Analysis Services In-Memory analytics with Analysis Services Tabular Model Enhanced multidimensional models Modernized Reports and Dashboard with support for Mobile BI Create mobile reports using the SQL Server Mobile Report Publisher Consume with Power BI mobile apps HA for StreamInsight, complex event processing Import PowerPivot models into Analysis Services Advanced tabular mode • Direct Query Hybrid Transactional and Analytical Processing with real-time insights using In-Memory OLTP and Clustered Columnstore In-Memory Data Warehouse with Clustered Columnstore Indexes Unparalleled scalability with Windows Server 2016, with 24TB memory and Windows Server 2016 max cores Automatic failover between three synchronous replicas. Up to eight secondary replicas Buffer Pool Extension to SSDs Adaptive Query Processing Resource Governor with CPU, Memory and IO Governance Delayed Durability of Memory-Optimized Tables Query optimization enhancements Query Store • Local DB runtime (Express) Always Encrypted Dynamic Data Masking Row-Level Security Auditing CC certification at EAL2 level for SQL Server 2016 Backup encryption support Enhanced separation of duties Default schema for groups Programmability Enhancements Data Warehousing& Big Data Advanced Analytics Platform JSON support Spatial features, Full Globe and arcs Support for Temporal Tables Graph data support Machine Learning Services with built-in support for Python and R Operationalize Machine Learning algorithms with In-Database Machine Learning support RRE APIs with full parallelism and no memory limits for scale/performance Built-in In-memory Advanced Analytics Advanced data mining Support for Linux (RHEL, Suse, Ubuntu) Support for Docker containers and Kubernetes • Enhanced Always On Availability Groups with easy GUI-based Wizard Operational analytics Enhanced In-Memory DW with Clustered Columnstore Big Data integration with Hadoop and Azure Blob Storage Big Data Queries with T-SQL Enhanced database caching Enterprise Information Management (EIM) High Availability & Disaster Recovery Enhanced Integration Services Data Quality Services Master Data Services • Master Data Services Add-in for Excel

13. Accelerate app modernization with sql server

14. OLTP performance Industry leading performance in SQL Server 2017

15. In-memory Online transaction processing (oltp) Optimized performance of transaction processing, data ingestion, data load, and transient data scenarios Memory-optimized tables outperform traditional disk-based tables, leading to more responsive transactional applications Memory-optimized tables also improve throughput and reduce latency for transaction processing, and can help improve performance of transient data scenarios such as temp tables and ETL On-disk In-memory User App SQL Server In-memory OLTP

16. Real-time operational analytics with hybrid transactional-analytical processing (HTAP) Support for Columnstore and In-Memory allows you to generate analytics in real-time, direct from your transactional databases Analytics performed on operational data with minimal overhead Reduce storage needs with ColumnStore column compression and up to 100x faster queries In-memoryColumnStore +ETL In-memory OLTP 0100101010110

17. adaptive query processing Improved efficiency with Adaptive Query Processing Optimize memory grants for repeatable queries to avoid over or under allocating Adjust data join strategy for small or large tables tospeed joins Batch mode for memory grants feedback and adaptive joins 101010010101101010 101010010101101010010101 101010010101 101010 Before After Query 101010101010101001 101010101010101001 101001010110 101010101010101001010101010101001010 Adaptive Query Processing Learn Memory grant 101010101010101001 101010010101101010010101 101010010101 101010 101010101 101010101 101010101010101001 Run query 101010101010101001 101010101 101010101 Spill to disk All in memory

18. Automatic tuning Automatic tuning is a continuous monitoring and analysis process that constantly learns about the characteristic of your workload and identify potential issues and improvements Automatic tuning notifies you when a potential performance issue is detected, and lets you apply corrective actions, or lets the Database Engine automatically fix performance problems. Learn Adapt Verify

19. Security Enterprise-grade security to protect, control and manage data

20. ALWAYS ENCRYPTED Always Encrypted allows clients to encrypt sensitive data at rest and in motion without impacting your database performance Encryption is transparent to applications, automatically encrypt and decrypt sensitive data in the client applications Encryption keys sit in the trusted area with the customer and are not revealed to the Database Engine Query encrypted data without needing to first de-encrypt Client side Server side Always Encrypted SQL Query EnhancedSQL Server Library Data set CIPHERTEXT Column master key Column encryption key

21. Row-level security Fine-grained access control over specific rows in a database Prevent unauthorized access when filtering in multitenant applications Enforcement logic inside the database and schema bound to the table Centralize Row-Level access logic within the database Provide end-user specific access control over sensitive data in a customer database. For example, customer call center, account manager see different data Customer 1 Customer 2 Customer 3 SQL Server database

22. Dynamic DATA masking Control sensitive data access Non-privileged users cannot see or access sensitive data Apply data masking in real-time to query results based on security policy Easy configuration using Azure Portal when using Azure SQL Database Easy configuration using DDM functions in T-SQL Real-time data masking and partial masking SQL Server 2017

23. SQL server audit Enable, store, and view audits on various server and database objects with dedicated tools Define multiple server or database audits to run simultaneously Track and log user-defined database-level audits with the help of predefined templates Retain an audit trail of selected events Report on database activities Analyze reports for events and trends

24. Transparent Database Encryption All customer data encrypted at rest Encryption keys managed can be managed by customer or by Azure Key Vault No application changes Transparent encryption/decryption of data using hardware acceleration SQL Database

25. High availability & disaster recovery Meet HADR requirements for your SQL Server database systems

26. Always on availability groups Always On cross-platform capabilities with High Availability and Disaster Recovery for Linux and Windows Support for clusterless Availability Groups Ultimate High Availability with OS-level redundancy and low-downtime migration Load balancing of readable secondaries Automatic Failover of Business Critical workloads and application in few seconds Automated Disaster Recovery environment Support for Disaster Recovery environment in Azure VMs Windows High availability Primary Sync/Async Replicas Linux Cross-operating system Sync/Async Replicas

27. Business intelligence Powerful modelling and reporting for business insights

28. SQL Server Analysis services Transform complex data into business friendly models Combine data from multiple data sources and apply business rules and security Match performance to the speed of business Explore models and gain instant insights using your favorite visualization tool Data sources SQL Oracle IBM Teradata Sybase Azure Blob Data feeds Excel Files Others SQL Server Analysis Services BI semantic model Data modeling In-memory cache Security Business logic & metrics Lifecycle management Visualize Excel Power BI Third-party tools

29. Tabular Models Powerful, lightweight analytical modeling Modern connectors for big data sources, additional databases, Azure stores, and diverse modern data sources Rich data transformations and mashups In-memory performance Fast; don’t need to build out data warehouse SSAS Data sources Visualize Sentiment MySQL HDInsight Excel Data analysis Churn SharePoint Transform Tableau Files Power BI Azure Blob Revenue Dynamics Online Others…

30. SQL Server 2017 Reporting Services On-premises solution for deploying and managing reports Paginated reports Design beautiful, document-style reports for export to Word, Excel, PowerPoint, PDF, and printing Mobile reports Create responsive, interactive reports optimized for mobile devices Modern web portal Access both types of reports in one modern,cross-browser web portal

31. Power bi dashboards Get more from existing Reporting Services investments Pin report items to Power BI dashboards Monitor the most important metrics and trends in one place Pin charts, gauges, maps, and images as tiles to Power BI dashboards Drill through to source reports Refresh tiles on a schedule

32. Data warehousing & BIG Data Bring together data from different locations to find insights

33. Columnstore Clustered Columnstore Indexes with wide support of data types Online non-clustered columnstore index build and rebuild support added Reduce data warehouse storage Provides a very high level of data compression, typically 10x, to reduce your data warehouse storage cost significantly. Indexing on a column with repeated values vastly improves performance for analytics and ad hoc queries More data fits in memory Batch-mode execution • Data stored as columns Existing Table Row Groups Column Segments Columnstore Compressed Column Segments

34. polybase Execute T-SQL queries against relational data in SQL Server and semi-structured data in Hadoop or Azure Blob Storage Leverage existing T-SQL skills and BI tools to gain insights from different data stores Query Results Hadoop SQL Server Azure Blob Storage

35. Advanced analytics Discover new insights about your business

36. Machine learning with built-in support for python and r High-performance machine learning and AI wherever your data lives, on-premises or in the cloud Support for pre-trained Microsoft ML algorithms The best AI innovation from Microsoft andopen-source. Support for thousands of open source machine learning algorithms Simple, secure, and high-scale operationalization and administration Deep ecosystem engagements to deliver customer success with optimal total cost of ownership SQL 2017

37. Hybrid cloud Extend to the cloud and get more from your data

38. Hybrid availability and disaster recovery for SQL server in azure VM Extend on-premises Always On Availability Groups to Microsoft Azure by provisioning one or more Azure VMs with SQL Server Add them as replicas to your on-premises Availability Group Disaster recovery solution for your SQL Server databases in a hybrid environment Secondary replica Asynchronous commit VPN tunnel On-premise network Domain controller WSFC cluster Synchronous commit Primary replica Secondary replica File share witness

39. Stretch database Take advantage of cloud economics of lower cost compute and storage without full migration Creates a secure linked server definition in theon-premises SQL Server Targets remote endpoint with linked server definition Provisions remote resources and begins to migrate eligible data, if migration is enabled Queries against tables run against both local database and remote endpoint Internet boundary Linked servers On-premises instance Azure Local DB Remote endpoint Local data Remote data Eligible data

40. Backup to azure Enhanced backup to Azure Granular control of the backup schedule Local staging support for faster recovery and resiliency to transient network issues Support for system databases Support for simple recovery mode Backup to Azure block blobs Cost savings on storage Significantly improved restore performance More granular control over Azure Storage Azure Storage snapshot backup Fastest method for creating backups and running restores SQL Server database files onAzure Blob Storage

41. platform Flexibility of platform choice with SQL Server 2017

42. Support for linux SQL Server on Linux provides choice across platforms Build intelligent applications on any data, any platform, and any language on-premises and in the cloud Linux distributions including Red Hat Enterprise Linux (RHEL), Ubuntu, and SUSE Enterprise Linux (SLES)

43. Support for docker and kubernetes Container platforms for SQL Server provide benefits such as: Faster time to deployment Develop on the OS of your choice Packaging dependencies with SQL Server Higher density, lower disk space requirements Deploy exactly what you development and test

44. Enterprise information management A rich set of features designed to improve overall relevance and value of organizational information

45. Enterprise Information Management SQL Server 2017 offers a full suite of tools for Enterprise Information Management Help produce accurate, trustworthy data Deliver credible, consistent data to the right users with end-to-end data integration, cleansing and data management • Data quality services • Knowledge-based data cleansing & matching • Standalone & SSIS integrated • Master data services • Excel UI to manage data & dimensions • Rapid, easy data loading Cleanse Manage Integrate • Enhanced integration services • Integrated deployment & management • Improved user experience

46. Enhanced sql server integration services SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformation solutions – primarily for ETL processing Scenarios in which SSIS is useful include: Assessing data quality Cleansing and standardizing data Merging data from heterogeneous data stores Implementing ad hoc data transfers Automating administrative tasks Orchestrating Azure data processes

47. Master data services SQL Server Master Data Services (MDS) has been designed to deliver credible, consistent data with user-centric data governance Performance is improved for staging millions of records using the staging stored procedure Enables organizations to: Discover and define non-transactional lists of data Compile maintainable, reliable master lists Deliver and manage Master Data Management (MDM) solutions MDS Administration Master data manager Initialize Data changes Excel with MDS add-in WCF data service Source system ETL Notifications Outlook EDW MDS repository

48. Data quality services SQL Server Data Quality Services (DQS) is a knowledge-driven data cleansing service DQS can help deliver complete, valid, consistent, and accurate data It performs various cleansing processes: Data correction Standardization Enrichment Matching—typically for de-duplication Build Knowledgemanagement Manage knowledge/ matching policy Discover/ explore data Source data Knowledge base Integrated profiling Dataquality project Correct/ standardize (cleanse) Deduplicate (match) Use Processed data

49. Programmability enhancements Code, programming models and interfaces

50. Json support JSON functions in SQL Server enable you to combine NoSQL and relational concepts in the same database Parse JSON text and read or modify values Transform arrays of JSON objects into table format Run any Transact-SQL query on the converted JSON objects Format the results of Transact-SQL queries in JSON format Built-in functions ISJSONJSON_VALUEJSON_QUERY OPENJSON Transforms JSON text to table [ { “Number”:“SO043659”, “Date”:“2011-05-31T00:00:00” “AccountNumber”:“AW29825”, “Price”:59.99, “Quantity”:1 }, { “Number”:“SO043661”, “Date”:“2011-06-01T00:00:00” “AccountNumber”:“AW73565”, “Price”:24.99, “Quantity”:3 }, ] FOR JSON Formats result set as JSON text