SQL Server 2008 and 2008 R2 L300 Deck

SQL Server 2008 and 2008 R2 L300 Deck

SQL Server 2008 & 2008 R2 End of support Speaker300 Name Level Title W H E N W I L L E N D O F S U P P O RT H A P P E N ? SQL Server 2008 and 2008 R2 will no longer be supported starting on July 9, 2019. Current support level End mainstream End extended SQL Server 2014 Currently supporting all versions July 9, 2019 July 9, 2024 SQL Server 2012 SQL Server 2012 SP2+ is in mainstream support until CY 2017 July 11, 2017 July 12, 2022

SQL Server 2008 and SQL Server 2008 R2 SQL Server 2008 and 2008 R2 are in extended support which includes security updates, paid support, and requires purchasing non-security hotfix support July 8, 2014 July 9, 2019 SQL Server 2005 SQL Server 2005 support ended on April 12, 2016 April 12, 2011 April 12, 2016 Learn more about the SQL Server support lifecycle: support.microsoft.com/lifecycle/ A V O I D D ATA B R E A C H E S , U N P L A N N E D M A I N T E N A N C E C O S T S A N D B E G I N M O D E R N I Z AT I O N B E F O R E T H E E N D O F S U P P O RT Mitigate risks with platform security and compliance There will be no access to critical security updates,

opening the potential for business interruptions Upgrade with better cost efficiency Maintaining legacy systems can get expensive quickly Modernize to innovate Grow your environments with data, analytics and the cloud SECURITY & COMPLIANCE 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. Dont 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! 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 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 D ATA S E C U R I T Y & P R I VA C Y S O LU T I O N S F R O M S Q L S E RV E R Help safeguard your business with a suite of security features to help with compliance Discover Manage Protect Data identification Tracking Access control

Granular authorization Data security Privacy by design Data Discovery & Classification Access control Transparent Data Encryption Administrators can manage and govern access to personal data with Windows authentication and Azure Active Directory authentication Help secure personal data through encryption at the physical storage layer using encryption-at-rest Role-based access control Always Encrypted Helps you search and identify personal data using queries Apply role-based access control to help manage authorization policies in the database, and to implement the separation of duties principle

Prevent unauthorized, highprivileged users from accessing data in transit, at rest, and while in use Full text queries Row-level security Using full-text queries against character-based data in SQL Server tables Prevent access to rows in a table (such as those that may contain sensitive information) based on characteristics of the user trying to access the data Always On Availability Groups Azure Data Catalog Dynamic Data Masking Unlock tribal knowledge by sharing information about data usage and intent throughout the organization Control access to sensitive data by enabling how much data to reveal with minimal impacts to app layers

Report SQL Server Audit SQL Server Audit Verify changes to data that occur in a SQL Server table Understand ongoing database activities, and analyze and investigate historical activity to identify potential threats or suspected abuse and security violations Scan, identify, and label columns containing potentially sensitive data in your database Metadata queries, SQL queries and statements Documentation Assessment of security SQL Server Audit Maintain audit trails and gain useful input for performing a Data Protection Impact Assessment (DPIA)

Vulnerability assessment Reports that can serve as a security assessment for your database. These reports can also be used as part of a Data Protection Impact Assessment (DPIA) Maximize the business continuity by enabling High Availability and Disaster Recovery built-in SQL Database Threat Detection Get help detecting anomalous database activities indicating potential security threats to the database 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

Extended support end date Extended Security Updates support period Windows Server 2008/R2 January 2020 January 2020 January 2026 SQL Server 2008/R2 July 2019 July 2019 July 2025 MODERNIZE T O I N N O V AT E T H E M O D E R N DATA E S TAT E SQL Server family have evolved a lot since SQL Server 2008 and 2008 R2. With SQL Server 2017, customers dont just get an update they get in-memory performance across workloads, missioncritical 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 Cloud On-premises Private cloud Operational databases Operational databases Data warehouses Data warehouses Data lakes Data lakes Reason over any data, anywhere Flexibility of choice Security and performance Easy and seamless migration to your modernization target of choice with Azure Database Migration Service

Shared Infrastructure / Lower cost P I C K YO U R TA R G E T D E S T I N AT I O N Hybrid Cloud SQL PaaS Azure SQL Database Virtualized Database IaaS 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 Dedicated Infrastructure/ Higher cost SQL Server in Azure VM Virtualizes Machines Virtual SQL Server Private Cloud

Virtualized Machine + Appliance Physical SQL SQL Server Physical Machine (raw iron) Higher administration Lower administration 1. Security built into both 5 REASONS S Q L S E RV E R & W I N D O W S S E RV E R A R E B E TT E R TOGETHER 2. Major cost savings and unprecedented performance boosts 3. Database uptime and reliability synergies 4. Reach insights faster by running analytics at the point of creation 5. Consistent data environment across hybrid cloud environments

W I N D O W S S E RV E R 2016 & S Q L S E RV E R 2 0 1 7 SQL Cluster Hardware innovations Hardware 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 Flexibility Flexibility 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 subsystems. Achieve same SAN system redundancy with better TCO and faster data IO DB DB DB

DB MORE THAN AN U P G RA D E W I T H S Q L S E RV E R 2 0 1 7 With SQL Server 2017, your business doesnt 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. #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 SQL #1 OLTP performance #1 DW performance #1 price/performance

W H AT S N E W I N S Q L S E RV E R 2 0 1 7 S I N C E S Q L S E RV E R 2 0 0 8 & 2 0 0 8 R 2 OLTP Performance Sec urit y Hybrid Transactional and Analytical Processing with realtime insights using In-Memory OLTP and Clustered Columnstore Data-tier application component project FileTable build on FILESTREAM Always Encrypted Remote Blob Storage with SharePoint 2016 Row-Level Security In-Memory Data Warehouse with Clustered Columnstore Indexes Statistical Semantic Search CC certification at EAL2 level for SQL Server 2016 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 Contained Database Authentication Automatic Plan Correction Programm abilit y Enhancement s JSON support Dynamic Data Masking Auditing Backup encryption support Enhanced separation of duties Support for Temporal Tables Resource Governor with CPU, Memory and IO Governance Graph data support Enhanced In-Memory DW with Clustered Columnstore Query Store

Data Quality Services Local DB runtime (Express) Big Data integration with Hadoop and Azure Blob Storage Big Data Queries with T-SQL Enhanced Integration Services Master Data Services Master Data Services Add-in for Excel Configurable reporting alerts Enterprise-grade Analysis Services Enhanced database caching Power View 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 Disaster Recovery environment in Azure VMs using Always On Availability groups Stretch database Reporting as SharePoint Shared Hybrid scenarios with SSIS Service Enhanced backup to Azure In-Memory analytics with Analysis Services Tabular Model Modernized Reports and Dashboard with support for Mobile BI Adaptive Query Processing Query optimization enhancements Mobile BI Dat a War eho using & Big Dat a Operational analytics

Delayed Durability of MemoryOptimized Tables Enhanced productivity and performance Enhanced multidimensional models Spatial features, Full Globe and arcs Hybrid Cloud Enhanced connectors, new transformations, object-level security, ragged hierarchies** Default schema for groups Buffer Pool Extension to SSDs Enterprise Information Mana gement (EIM) Business Int elligence Easy migration to the cloud Secure backups to Azure with managed backups Advanced Analytics

Machine Learning Services with built-in support for Python and R Operationalize Machine Learning algorithms with InDatabase Machine Learning support RRE APIs with full parallelism and no memory limits for scale/performance Built-in In-memory Advanced Analytics Advanced data mining Platform Support for Linux (RHEL, Suse, Ubuntu) Support for Docker containers and Kubernetes High Availability & Disast er Recovery Enhanced Always On Availability Groups with easy GUI-based Wizard AC C E L E RAT E A P P M O D E R N I Z AT I O N WITH SQL SERVER Challenge Impact Application certification lagging behind faster

cadence of SQL Server release Inability to offer latest version of the application on modern SQL Server platform Upgrade customers to latest version on the application Revenue Inability of customer to leverage latest innovations in the application Supporting ISV customer on legacy application/SQL versions Higher cost to support multiple application versions Higher support cost to troubleshoot on legacy SQL Server Version specific scripts/methodology to monitor and troubleshoot OLTP PERFORMANCE

Industry leading performance in SQL Server 2017 Features In-Memory OLTP Real-time Operational Analytics (HTAP) Adaptive Query Processing Automatic Tuning IN-MEMORY ONLINE TRANS ACTION 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 REAL-TIME OPERATIONAL ANALYTICS WITH HYBRID TRANS ACTIONAL-ANALYTICAL

PROCESSING (HTAP) Support for Columnstore and In-Memory allows you to generate analytics in real-time, direct from your transactional databases In-memory ColumnStore Analytics performed on operational data with minimal overhead Reduce storage needs with ColumnStore column compression and up to 100x faster queries +ETL 010010101011 0 In-memory OLTP 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 to speed joins Batch mode for memory grants feedback and adaptive joins Before

10101 01010 10101 001 10101 00101 01101 01001 0101 10101 00101 01 10101 0 After 10101 00101 01101 01001 0101 10101 00101 01 10101 00101 01101 010 Query Lear n

Adaptive Query Processing 101 001 010 110 Memor y grant 10101 01010 10101 00101 01010 10101 00101 0 10 10 10 10 10 10 101 101 10101 01010 10101 001 10101

01010 10101 001 10101 01010 10101 001 10101 01010 10101 001 10 10 10 10 10 10 101 101 Run query Spill to disk All in memory 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 SECURITY Enterprise-grade security to protect, control and manage data Features Always Encrypted Row-Level Security Dynamic Data Masking SQL Server Audit Transparent Database Encryption ALWAYS ENCRYPTED Always Encrypted allows clients to encrypt sensitive data at rest and in motion without impacting your database performance Client side Always Encrypted Enhanced SQL Server Library Query

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 Server side SQL Data set Customer Credit card # Exp. Denny Usher 0x7ff654ae6d 4949-8003-84731930 5/17 Column master key

CIPHERTEXT Customer Credit card # Exp. Tim Irish 7/19 Denny Usher 1x7fg655se2e 4839-2939-19193987 0x7ff654ae6d 4949-8003-84730y8fj754ea2c 1930 Alicia Hodge 9000-4899-16001324 4/18 5/17 Column encryption key

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 Custome r1 Custome r2 Custome r3 SQL Server database DYNAMIC DATA MASKING Control sensitive data access Table.CreditCardNo 4465-6571-78685796 4468-7746-38481978 4484-5434-68586550 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 TSQL SQL Server 2017 Real-time data masking and partial masking CreditCardNo XXXX-XXXX-XXXX-5796 XXXX-XXXX-XXXX-1978 XXXX-XXXX-XXXX-6550 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 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 HIGH AVAILABILITY & DISASTER RECOVERY Meet HADR requirements for your SQL Server database systems Features Always On Availability Groups ALWAYS ON AVAIL ABILITY GROUPS Always On cross-platform capabilities with High Availability and Disaster Recovery for Linux and Windows Support for clusterless Availability Groups Windows 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 High availability Primary Sync/Async Replicas Linux Cross-operating system Sync/Async Replicas BUSINESS INTELLIGENCE Powerful modelling and reporting for business insights Features SQL Server 2017 Analysis Services Tabular Models SQL Server 2017 Reporting Services Power BI Dashboards SQL SERVER ANALYSIS SERVICES Transform complex data into business friendly models Combine data from multiple data sources and

apply business rules and security Data sources SQL Oracl e IBM Teradat a Sybas e Azure Blob Data feeds Excel Files Other s SQL Server Analysis Services

Match performance to the speed of business BI semantic model Explore models and gain instant insights using your favorite visualization tool Data modeling In-memory cache Security Business logic & metrics Lifecycle management Visualize Excel Power BI Third-party tools TABUL AR MODELS Powerful, lightweight analytical modeling Modern connectors for big data sources, additional databases, Azure stores, and diverse modern data sources

Data sources Visualiz e SSAS Sentimen t MySQL HDInsight Rich data transformations and mashups SharePoint In-memory performance Files Fast; dont need to build out data warehouse Azure Blob Transform Dynamics Online Others Churn

Revenue Data analysi s Excel Tableau Power BI 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 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 DATA WAREHOUSING & BIG DATA Bring together data from different locations to find insights Features Columnstore Polybase COLUMNSTORE Clustered Columnstore Indexes with wide support of data types Online non-clustered columnstore index build and rebuild support added Data stored as columns Existin g Table Row Group s Column Segments Columnstor e 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 Compresse d Column Segments 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 Hadoop Results SQL Server Azure Blob Storage ADVANCED ANALYTICS Discover new insights about your business Features Machine Learning Server with Python and R

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 SQL The best AI innovation from Microsoft and open-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 2017 HYBRID CLOUD Extend to the cloud and get more from your data Features High Availability and Disaster Recovery in Azure VMs Stretch Database Backup to Azure HYBRID AVAIL ABILITY AND DIS ASTER 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 Asynchronou s commit VPN tunnel On-premise network Domain controller WSFC cluster Synchronou s commit Primary replica Secondary replica File share witness STRETCH DATABASE Take advantage of cloud economics of lower cost compute and storage without full

migration Internet boundary Creates a secure linked server definition in the on-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 Local DB Linked servers Remote endpoin t Local data Remote data Eligible data On-premises instance Azure BACKUP TO AZURE

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

Features Support for Linux (RHEL, Suse and Ubuntu) Support for Docker containers and Kubernetes 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) 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 ENTERPRISE INFORMATION MANAGEMENT A rich set of features designed to improve overall relevance and value of organizational information Features Enhanced SSIS Master Data Services Data Quality Services

ENTERPRISE INFORMATION MANAGEMENT SQL Server 2017 offers a full suite of tools for Enterprise Information Management Data quality services Master data services Knowledge-based data cleansing & matching Excel UI to manage data & dimensions Help produce accurate, trustworthy data Standalone & SSIS integrated Rapid, easy data loading Deliver credible, consistent data to the right users with end-to-end data integration, cleansing and data management Cleans e Manage Integrate Enhanced integration

services Integrated deployment & management Improved user experience 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 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: MDS Administratio n Initializ e

Data changes WCF data service Source system Master data manager Excel with MDS addin Discover and define non-transactional lists of data Compile maintainable, reliable master lists Deliver and manage Master Data Management (MDM) solutions ETL Notifications Outlook EDW MDS repository 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 Buil d Knowledge management Discover/ explore data Source data It performs various cleansing processes: Data correction Knowledge base Integrated profiling Standardization Deduplicat e (match) Enrichment Matchingtypically for de-duplication Manage knowledge/

matching policy Correct/ standardize (cleanse) Data quality project Use Processed data PROGRAMMABILITY ENHANCEMENTS Code, programming models and interfaces Features JSON support Temporal Tables 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 ISJSON JSON_VALUE JSON_QUERY OPENJSON Transforms JSON text to table [ { Number:SO043659, Date:2011-0531T00:00:00 AccountNumber:AW29825, Price:59.99, Quantity:1 }, { Number:SO043661, Date:2011-0601T00:00:00 AccountNumber:AW73565, Price:24.99, Quantity:3 }, ] Number Date Custome r

Price Quantit y SO4365 9 2011-0531T00:00:00 MSFT 59.9 9 1 SO4366 1 2011-0601T00:00:00 Nokia 24.9 9 3 FOR JSON Formats result set as JSON

text TEMPORAL TABLES Built-in support for providing information about data stored in the table at any point in time Can be used as a data recovery tool Temporal table (actual data) Automatically keep history of the data in the table Audit data changes and perform data forensics Calculate trends over time Temporal queries (time travel, etc.) History table S Q L S E RV E R O N A Z U R E V I RT U A L M A C H I N E S Easily migrate your SQL Server workloads to the cloud Operating system choice Support for Windows Server, Red Hat Enterprise Linux, SUSE Linux Enterprise Server and Ubuntu Linux

Cloud flexibility Hybrid connectivity Tuned for performance Highly-secured and trusted Set up and manage your SQL Server deployments in minutes, and then scale Get the most out of your on-premises investments, and take advantage of all that Azure offers Meet your toughest demands with virtual machines optimized by the team that built SQL Server Protect your entire data estate with a highlysecured database on the most compliant

cloud up or down CLOUD FLEXIBILITY Fast time-to-value with cloud flexibility Set up and manage your SQL Server deployments in minutes, then scale up or scale down on the fly Any SQL Server version and edition, on the VM size you need with easy migration from Azure Database Migration Service SQL Server is guaranteed to run the same in Azure VMs as on-premises Different VM types optimized for customer use case: General purpose Compute optimized Memory optimized Storage optimized GPU optimized High performance compute DEVELOP AND TEST IN THE CLOUD Spin up a new development environment in minutes, and only pay for what you use Low virtual machine usage costs mean you pay only cents per hour, while using all the features you need for development and testing TFS in Azure Dev

Work Stations SQL Server dev tools onpremises SQL Server in an Azure VM Deploy SQL Server on-premises ALWAYS ON AVAIL ABILITY GROUP SQL Server 2017 gives you up to eight readable replicas, which you can deploy to a fast-growing list of Azure regions around the world Set up fast failover for database applications running in Azure Cross-region connectivity Azure Region 1 Secondary replicas Expres s route Asynchronou

s commit Improve business continuity in the event of disaster by placing your SQL Server Always On Availability Group replicas in virtual machines Azure Region 2 Secondary replicas Azure VPN tunnel BI Scale-out On-premises network Synchronou s commit Primary replica Secondary replica A Z U R E S Q L D ATA B A S E The intelligent relational cloud database service Intelligent performance

Realize automatic performance improvements from continuous assessment and innovation Scales on the fly Business continuity Works in your environment Advanced threat protection Change service tiers, performance levels, and storage dynamically without downtime Easily manage and monitor business critical functions for reliable operations Develop your app and connect to SQL Database with the tools and platforms you prefer

Build security-enhanced apps with built-in protection and industryleading compliance A Z U R E S Q L D ATA B A S E F E AT U R E S OLTP performance Security High Availability & Disaster Recovery Biz model & SKUs Columnstore Engine Audit 99.99% SLA DTU/eDTU In-Memory OLTP Threat Detection Geo-restore <=1TB Query Store

Centralized dashboard OMS Active geo replicas (4) Bigger std: S4-S12 Index Optimization SQL Firewall Multi-AZ Separate compute and storage Automatic tuning RLS, Dynamic data masking Auto query plan correction AAD and MFA Performance Insight in OMS Encrypt in motion (TLS) Adaptive Query Processing Always Encrypted (equality) TDE & BYK Service endpoint Always Encrypted (secure enclave)

Azure Hybrid Benefit Backup and restore Cost optimization Backup with health check Intelligent PaaS 35 days PITR 10 years data retention Vulnerability assessment Advanced Analytics Distributed application Native PREDICT Change Tracking R Services Transaction replication SQL Graph Data sync SSIS service ADVANCED THREAT PROTECTION

Advanced Threat Protection (ATP) provides a single go-to location for discovering, classifying and protecting sensitive data, managing your database vulnerabilities, and detecting anomalous activities that could indicate a threat to the database. With one click, you can enable ATP on your entire database server, applying to all databases on the server. ATP includes: SQL Threat Detection SQL Vulnerability Assessment SQL Information Protection (currently in preview) HIGH-AVAIL ABILITY PL ATFORM Single logical database Recovery from machine failure Critical capabilities: Create new replica Synchronize data Stay consistent

Detect failures Failover 99.99% availability Reads are completed at the primary S Writes are replicated to secondaries P DB Ack value Ack Write Read write P S P Write

Ack S S AZURE SQL DATABASE ADVISOR IMPROVES PERFORMANCE Index tuning recommendations tailored to each DB Recommendations are based on the observed usage, and evolve as the DB workload changes Support for CREATE and DROP index, more types of recommendations underway Intelligent service for implementing and validating index recommendations Full-auto mode takes care of indexes for your DB Manual review and apply mode for full control AUTOMATIC TUNING Continuously optimized by the platform One-click to enable Prevent and mitigate issues No app changes needed Tuning actions Create missing indexes Drop unused/duplicate indexes Force last good plan SCAL ABILITY OPTIONS IN AZURE SQL DATABASE Horizontal: scale out or scale in

Change service tiers for a given database as capacity needs fluctuate Add or remove databases (sharded and/or in a pool) as more or less capacity is needed Scale up/down Vertical: scale up or scale down Premium Basic Standard Basic Scale out/in Premium Basic Basic READ SCALE- OUT Read scale-out support in the Premium and Business critical service tiers for Azure SQL Database Load balance Azure SQL Database read-only workloads using the capacity of read-only

replicas Load balance complex analytical workloads without affecting the primary OLTP workload POINT-IN-TIME RESTORE Automatic backups Full backups weekly, differential backup daily, log backups every 5 minutes Daily and weekly backups automatically uploaded to geo-redundant Azure Storage sabcp01bl21 sabcp01bl21 Azure SQL Database backups Azure storage Geo-replicated Self-service restore Point-in-time up to a second granularity REST API, PowerShell, or Azure portal Creates a new database in the same logical server Tiered retention policy Basic 7 days Standard 35 days Premium 35 days *No additional cost to retain backups

Restore from backup LONG-TERM DATA RETENTION Store specified SQL database full backups in RA-GRS blob storage for up to 10 years Restore any backup as a new database Define parameters for backup: weekly, monthly, yearly or week of year AZURE DATABASE MIGRATION SERVICE Resilient migration Homogeneou s sources A seamless, end-to-end solution for moving on-premises SQL Server, Oracle, and other relational databases to the cloud Two modes of migration: online and offline migrations Learn more with the Data Migration Guide Heterogeneo us sources Azure Database Migration Service (Azure DMS)

Orchestrati on Scale migration AZURE HYBRID BENEFIT FOR SQL SERVER License trade-in values Take an inventory of on-premises licenses to determine potential for conversion SQL Server cores with SA license vCores on Azure SQL Database Convert on-premises cores to vCores to maximize value of investments 1 Standard license core = 1 General Purpose core 1 Enterprise license core = 1 Business Critical core SQL Server Standard Edition General purpose vCore 1 Enterprise license core = 4 General Purpose cores (virtualization benefit) Business critical

vCore SQL Server Enterprise Edition 4x General purpose vCores VIRTUAL CORES FOR AZURE SQL DATABASE Choice between vCores and DTUs in Azure SQL Database as a unit of measure for available CPU Understand your compute requirements in the cloud vs. what you use on-premises today Easier to right-size the destination environment by removing the guesswork of DTUs 8 16 Number of vCores 1 on-premises core = 1 vCore on Gen4 hardware On-premises 24 M I G R AT I N G F R O M S Q L S E RV E R 2 0 0 8 & 2 0 0 8 R 2 T O S Q L S E RV E R 2 0 1 7

1 Discover & Assess Download and install the MAP Toolkit for discovery and use Data Migration Assistant (DMA) to assess schema and database 2 Migrate Use Data Migration Assistant (DMA) migrate schema and database 3 Optimize Remediate applications and perform validation tests with Database Experimentation Assistant ( DEA) Tools and considerations Backup and restore: Back up taken on SQL Server 2008 or SQL Server 2008 R2 can be restored to SQL Server 2017 Tools: MAP Toolkit, Database Migration Assistant (DMA), Database Experimentation Assistant (DEA) Database mirroring: Database mirroring is supported if principal is running SQL Server 2008 SP3 or later, or SQL Server 2008 R2 SP2 or later, and mirror is running SQL Server 2017. If a failover, either automatic or manual, happens such that SQL Server 2017 instance becomes principal, SQL Server 2008 or SQL Server 2008 R2 instance becomes mirror and will NOT receive changes from principal.

Log shipping: Log shipping is supported if primary is running SQL Server 2008 SP3 or later, or SQL Server 2008 R2 SP2 or later, and secondary is running SQL Server 2017. If a failover, either automatic or manual, happens such that SQL Server 2017 instance becomes primary, SQL Server 2008 or SQL Server 2008 R2 instance becomes secondary and will NOT receive changes from primary Bulk load: Tables can be bulk copied from SQL Server 2008 or SQL Server 2008 R2 to SQL Server 2017 M I G RAT I N G F R O M S Q L S E RV E R 2 0 0 8 & 2 0 0 8 R 2 TO AZURE VMS 1 Discover & Assess Download and install the MAP Toolkit to identify and discover data sources and use Data Migration Assistant (DMA) to assess your source database before migrating your SQL Server instance 2 Migrate Use Azure Database Migration Service (DMS) to migrate schema and database Tools and considerations Tools: MAP Toolkit, Database Migration Assistant (DMA), Database Experimentation Assistant (DEA)

Learn how to create an instance of SQL Server on Azure VMs here. 3 Optimize Remediate applications and perform validation tests with Database Experimentation Assistant ( DEA) , using Database Migration Guide as key resource M I G R AT I N G F R O M S Q L S E RV E R 2 0 0 8 & 2 0 0 8 R 2 T O A Z U R E S Q L D ATA B A S E 1 Discover & Assess Download and install the MAP Toolkit to identify and discover data sources and use Data Migration Assistant (DMA) to assess your source database before migrating your SQL Server instance 2 Migrate Use Azure Database Migration Servi ce (DMS) to migrate schema and database Tools and considerations

Tools: MAP Toolkit, Database Migration Assistant (DMA), Azure Database Migration Service (DMS) Bulk load: Tables can be bulk copied out from SQL Server 2008 or SQL Server 2008 R2 and then bulk copied into Azure SQL Database 3 Optimize Remediate applications and perform validation tests with Database Experimentation Assistant ( DEA) , using Database Migration Guide as key resource M I G R AT I N G F R O M S Q L S E RV E R 2 0 0 8 & 2 0 0 8 R 2 T O A Z U R E S Q L D ATA B A S E M A N A G E D I N S TA N C E 1 Discover & Assess Download and install the MAP Toolkit to identify and discover data sources and use Data Migration Assistant (DMA) to assess your source database before migrating your SQL Server instance 2 Migrate Use Azure Database Migration Servi ce (DMS) to migrate schema and

database Tools and considerations Tools: Migration supported by Azure Database Migration Service (DMS) Bulk load: Tables can be bulk copied out from SQL Server 2008 or SQL Server 2008 R2 and then bulk copied into Azure SQL Database Managed Instance 3 Optimize Remediate applications and perform validation tests with Database Experimentation Assistant ( DEA) , using Database Migration Guide as key resource S Q L S E RV E R 2 0 1 7 M O M E N T U M 2,000,000 + Docker pulls It was incredibly easy to set up and move SQL Server from Windows to Linux Dean Chen VP of Engineering, dv01 One of the easiest migration experiences that we've had

Chris Amaris CTO, Convergent Computing It guarantees compatibility with more target customers Ron Dunn Lead Developer, Ajilius DELIVERING INSIGHTS FOR INVESTORS 15X FA S T E R Real-time analytics with SQL Server on Challenge Linux FinTech companys loan intelligence platform experienced performance slowdowns with PostgreSQL Slow query speeds and time-consuming maintenance Impact Query times cut from 30 to <2 seconds with SQL Server Management time reduced 90% Simplified dev operations with Linux The biggest benefit for us was that we were able to switch SQL Server to Linux and not have degradation in other areas. Devon Hinton, Software Engineer, dv01

HUMANTECH MOVES TO SQL SERVER 2017 ON LINUX TO REDUCE COSTS AND BOOST EFFICIENCY Scenario Humantech is one of the worlds largest providers of ergonomics consulting and software services. The company decided to standardize its IT environment on one operating system in order to promote its continued growth and success. However, Humantech wanted to keep its preferred Windows database, Microsoft SQL Server, because of the solutions reliable performance and familiar technology. Solution To satisfy both needs, the company upgraded from SQL Server 2008 to SQL Server 2017 on Linux. Now, Humantech saves on IT maintenance and has an updated database that offers fast operation and strong security. During the restore process, you simply upgrade the SQL Server 2017 database along the way. As a result, it was easy to deploy and gave us confidence in the evaluation. - Ken Lupo, Director of Technology at Humantech We did not want to go for a walk on the wild side. Our goal was to ensure that our solutions would be as durable, off-the-shelf, and minimally customized as possible, which is why we sought to go with a flexible database that we already knew so well. - Jim Good, President of Humantech A Z U R E I S T H E M O S T C O S T- E F F E C T I V E F O R S Q L S E RV E R Azure Hybrid Benefit can help customers save 55%* for SQL Server by bringing their on-premises licenses (vs. pay-as-you-use) Software Assurance cost Base rate

License Included With Azure Hybrid Benefit *Pay a reduced rate on vCore-based options and save in highly-virtualized scenarios Up to 55 percent savings Customer total Migrate to Azure SQL DB Managed Instance or VMs Azure SQL Database Managed Instance offers a fully-managed option to eliminate challenges with end of support Azure virtual machines include 3 more years of Extended Security Updates for SQL Server 2008 or 2008 R2 at no additional charge Modernize when ready Upgrade in Azure when ready Or transform apps and data with Azure services U PG RADE ON-PREMISES Upgrade to latest version SQL Server 2017 Cant meet the deadline? Protect server workloads

Purchase Extended Security Updates to get 3 more years of security updates for SQL Server 2008 or 2008 R2. Upgrade when ready C U S T O M E R R E S O U RC E S F O R 100% D ATA E S TAT E M O D E R N I Z AT I O N Scenario Offer/resource Customer needs more time to plan my upgrade Extended Security Updates Customer is investing in projects on Linux SQL Server on Red Hat Enterprise Linux offer Customer wants to move my on-premises SQL Server and Windows Server licenses to IaaS License mobility Azure Hybrid Benefit Customer wants to move my on-premises SQL Server licenses to PaaS Azure Hybrid Benefit Customer wants to scale through private cloud

Unlimited virtualization benefits S TA RT YO U R M I G RAT I O N J O U R N E Y T O D AY 1 Discover Identify your databases to upgrade Run the MAP toolkit 2 Assess & Migrate Make the move Use the Database Migration Guid e to obtain Technical and Business guidance 3 Optimize Explore options to unlock your app potential with Cloud and AI Innovate faster with SQL Server 2017 and

Azure Data Services Copyright Microsoft Corporation. All rights reserved.

Recently Viewed Presentations

  • Bunsen Burner Bunsen Burner An important piece of

    Bunsen Burner Bunsen Burner An important piece of

    Bunsen Burner. An important piece of equipment used for heating in the lab. Can be very dangerous if care is not taken. Parts of the Bunsen Burner. Barrel . Collar. Gas Hose. Air hole . Gas Jet. Base. Hottest part...
  • www.eecs.ucf.edu

    www.eecs.ucf.edu

    Software Flow Chart. Microcontroller. Arduino Nano. Purpose: Control all other components. Operation of LEDs. ... PCB, and Bluetooth problems are about factoring the best choice from different possibilities. Arduino, app, and design problems will be solved with practice as work...
  • Truth and Reality: Short Stories Unit continued…

    Truth and Reality: Short Stories Unit continued…

    5. credulity - antonym. 6. oppressive - antonym. No - 'cred' means believe, so incredible means unbelievable. ... Your enemy's friend is your enemy. I am nobody. "What a pity that youth must be wasted on the young." - George...
  • Mentor Certification

    Mentor Certification

    Each dirty dish has a designated spot in the Hobart. This step also includes pulling all clean plates, glasses, and silverware that needs to be brought up to the expo line [The expo line is the main wait station and...
  • Sakai Web Design - University of Delaware

    Sakai Web Design - University of Delaware

    [email protected] is a secured Web server that uses the https protocol. If you have http resources on an https page, you will get an annoying warning about mixing secure and non-secure items. To prevent this, either put everything into Sakai...
  • Experimental and CFD investigations into slamming of small,

    Experimental and CFD investigations into slamming of small,

    RANS equations (ANSYS CFX 11) Transient simulation. Equations of motion solved at each timestep. Initial investigations used published experimental data for validation. Results - wedge impact. CFD Improvements. Boundary layer development on an impulsively started flat plate.
  • UTEACH RECRUITMENT and TEACHING IN ENGLAND THINKING ABOUT

    UTEACH RECRUITMENT and TEACHING IN ENGLAND THINKING ABOUT

    uteach recruitment and teaching in england
  • Analyst briefing 15th Jan 2019 Underwritin g comes

    Analyst briefing 15th Jan 2019 Underwritin g comes

    Dividend yield is calculated as the total calendar year cash dividends divided by the year end share price. RoE excludes the impact of warrant exercises 2011 peer group included Amlin, Aspen, Axis, Beazley, Catlin, Endurance, Flagstone, Hiscox, Montpelier, Renaissance Re...