ms sql server db - modernization · ms sql server db - modernization. agenda •it reality | data /...
TRANSCRIPT
Juan CruzAdvisory Systems Engineer | Microsoft Specialist
Dell EMC – [email protected]
MS SQL Server DB - Modernization
Agenda
• IT Reality | Data / Information
• MS SQL Server
• Modernization Strategies
• How to approach?
• SQL Server vNext (2019)
• Dell EMC Cloud – Azure Stack
• Summary / Dell EMC Offerings
IT Reality – Data at the core
TechnologiesProcess
People
Data
Follow Leverage
Enable
• Legacy applications – heavy with “Data Gravity”, will
never be going to the Public Cloud
• Azure Stack (App) and SQL Server (Data) and both
business enablers…and Powerful when modernized
together!
• Enable App owners and App Disposition Optimization
exercises to drive the modernization conversation
• IT Directors, DBA’s, System Administrators need to
create new processes utilizing new tooling and
technologies
• Business processes need to be modernized
regarding production and non-production data
isolation requirements
Modernize NEAR THE DATA!
What is driving your modernization initiative?
Move to cloudadopt an as-a-
service model
New versionsnew features &
performance improvements
Product retirementend of extended
support/end of life
Microsoft Azure StackWindows Server 2008
Windows Server 2003Windows Server 2016+
SQL Server 2008
SQL Server 2005SQL Server 2017+ Microsoft Azure SQL Database
Begin Modernizing Operations - Cloud OperatingWithout code changes - None require waiting for an admin
Teamwork and organization:
• Resource Groups
• Role-based access
• Change Auditing
• Locks
• Tags
VM Scale and Availability:
• Pay Per Use
• VM Scale Sets
• Availability Sets
• Resize VM
• Resize Disk
• Add Network Adapter
Self Service Virtual Networks:
• Firewall Rules
• Load Balancing
• Probes
• VPN
• Routes
• DNS
• Marketplace of 3rd party appliances
Self-Service Support:
• Boot Diagnostics
• Screen Shot
• Serial Logs
• Metrics
• Change Password
• Redeploy
Guest Management:
• Run Custom Code
• VM Extensions
• Software Inventory
• Change Tracking
Security:
• Default Firewall Restrictions
• VM Update/Patch Management
• Malware Status
DevOps:
• Infrastructure as Code
• Portal/PowerShell/CLI
• Integration with Azure DevOps and
Jenkins
• App Insights
Storage:
• Upload/Download VM Images
• Capture/Deploy VM Images
Business Continuity:
• VM Backup
• Disaster Recovery
© Copyright 2019 Dell Inc.7
SQL Server
The evolution of SQL Server
SQL Server 2008
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
SQL Server 2016 & 2017*
Transparent DB encryption
PowerPivot ● SharePoint integration ● Master Data Services
AlwaysOn ● In-Memory ColumnStore ● Data quality services ● Power View ● Cloud
In-memory across workloads ● Performance & scale ● Hybrid cloud optimized ● HDInsight ● Cloud BI
Industry-leading performance ● End-to-end mobile BI ● AI built-in ● Choice of language & platform ● Easy migration to the cloud
SQL Server 2019
Intelligence over all data ● Big data clusters with Spark and HDFS ● R and Python built-in ● Data classification & compliance tracking ● Azure Data Studio
Upgrade for more Windows Server innovation
Windows Server 2008Hyper-V
Windows Server 2008 R2Live Migration ● PowerShell
Windows Server 2012Storage Spaces ● Server Manager ● Hyper-V enhancements
Windows Server 2012 R2Storage Tiering ● Storage QoS ● Network virtualization ● IPAM
Windows Server 2016Shielded VMs ● Storage Spaces Direct ● Windows Server containers ● Network Controller
Windows Server 1709 & 1803Smaller container images ● Linux containers ● Windows Subsystem for Linux ● .NET 2.0 standard
Windows Server 2019Windows Admin Center ● System Insights ● Hyper-Converged Infrastructure ● Cluster Sets ● Azure Integration
Over 2/3 of all databases are powered by SQL
Source : IDC 201
>50% of the SQL install base is out of support life
✓ SQL 2005 is out of support now and SQL 2008 in 2019
✓ SQL 2008 was the last socket-based licensing model
✓ Microsoft is forcing the migration
SQL Server 2005 extended support ended in 2016% of instances SQL Version Current support level End Mainstream End Extended
8% SQL Server 2005 SQL Server 2005 SP4 is no longer supported. April 12, 2011 April 12, 2016
42% SQL Server 2008 and 2008 R2
SQL Server 2008 R2 is in extended support which includes security updates, paid support, and requires purchasing non-security hotfix support
July 8th, 2014 July 9, 2019
15% SQL Server 2012 SQL Server 2012 SP1+ is in mainstream support until CY 2017
July 11, 2017 July 12, 2022
SQL Server 2014 Currently supporting all versions July 9, 2019 July 9, 2024
SQL Server 2016 Currently supporting all versions July 13, 2021 July 14, 2026
SQL 2005No Security Updates
SQL 2008
No New Features
No Non-Security hotfixes
No Support (Phone, Email)
Microsoft’s end of support – Popular workloads
SQL 2008 / 2008 R2 July 9, 2019
Windows Server 2008 / 2008 R2 January 14, 2020
Exchange 2010 January 14, 2020
Windows 7 January 14, 2020
SharePoint 2010 (Remember SQL!) October 13, 2020
Impact: No Support, No Updates, No Fixes, No Security updates
Option 1: Upgrade
Option 2: Move to Azure
• To save money, you could simply move your Windows Server 2008/2008 R2 and SQL 2008/2008 R2 to Azure / Azure Stack by using the Azure Hybrid Use Benefit. 3 years of extended support.
Option 3: Buy extended security updates (This last path has not evolved at all.)
• You will be allowed to run Windows Server 2008/2008 R2 and SQL 2008/2008 R2 for 75% of the current operating system cost, and continue to receive security updates. For this extended support, you must have a Software Assurance or Enterprise Subscription agreement. 3 years of security updates.
AVOID BUSINESS RISK
Find lifecycle support deadlines at: support.microsoft.com/lifecycle
SQL Server 2008
& 2008 R2
2018 2019 2020
End of support means:
Get ready now to beat
EOS deadlines
Windows Server
2008 & 2008 R2
No security updates
Compliance concerns
Missed innovation opportunities
Beat the EOS deadlines
© Copyright 2019 Dell Inc.14
Modernization Strategies
Initial Steps
SQL Server LingoUnderstand so you can “talk the talk”
ApplicationCould access 1+ databases
ServerPhysical or virtual
InstanceSQL Server engine (best practice is
one per virtual server)
Database1 to many databases per instance
WorkloadCould access 1+ instances
Modernization OptionsThis is an sample not all are listed (all are IaaS except deploy DBaaS)
Upgrade
SQL Server platform (engine)
Database: backup from one version and restore to newer version (with limitations)
Deploy
Brand new install, including DBaaS
Consolidate
Virtualizing DB instances
Horizontal scaling of Databases grouped by application
Archive
Backup, readily available
Tiering, DevOps database repurposing
Migrate
Storage to storage (app constraints) - instances
SQL Server old to new version (new features, benefits) - database
Modernize on existing infrastructureCloud & Storage share many of the same benefits
• Already in place
• New deploy on existing
• 2008 hosted on older storage
• Block level availability &
replication
• Storage to storage migration (app
constraints) - instances
• SQL Server old to new version
upgrade (new features, benefits) -
database
• All flash performance, faster
backups
• Storage Data Deduplication
(XtremIO, PowerMax, etc.)
Any/all
workloads
© Copyright 2019 Dell Inc.18
So how do I get there?The “who” and “why”…
Start with the basics
DBA
Server &
Storage Admin
Database
Architect
App/Analytics
Owners
Assess their current database landscape
Understand their level of automation
Determine their command of their data
• Which version of SQL are you running?
• How many separate SQL instances do you manage?
• Have you virtualized SQL?
• How many are managed outside your org?
• How are you addressing security gaps?
• Have you enabled self service for BI and/or App Dev teams?
• Are you using Azure public Yes – Are you considering Azure stack
• How long does it take you to move project from dev into production
• Are you using SQL to power your custom applications?
1)
2)
3)• Do you have data science team? Are they using SQL?
• How are you using unstructured data in SQL based analytics?
• How old is your data by the time you analyze it in SQL?
• Are you enabling applications with advanced analytics?
How triggers influence platform selection
Business driver…
• Need for Innovation
• Cost Reduction
• OpEx v. CapEx
• Business Risk
• Security
• Competitive Pressure
• Regulatory Risk
• Global Reach
Indicated platform…
…PaaS
…SaaS
…IaaS – Public/Private
…Private IaaS
…Traditional I/S
…PaaS
…PaaS or Private Cloud
…Containers or Public Cloud
IT driver…
• Technical Debt
• Reduced IT Footprint
• Reliability
• Aging Infrastructure
• Vendor Lock-in
• Time to market
• Customer Satisfaction
• Scalability
Indicated platform…
…Containers > SaaS or PaaS
…Public XaaS
…PaaS
…IaaS
…Containers
…PaaS
…PaaS
…IaaS or Containers
© Copyright 2019 Dell Inc.21
SQL Server vNext
Insights in minutes
and rich reports
Most secure
over the last 8 years5
0
20
40
60
80
100
120
140
160
180
200
Vu
lnera
bilit
ies
(20
10-2
017
)
The best of Power BI and
SQL Server Reporting Services
with Power BI Report Server
Industry-leading
performance
#1 OLTP performance1
#1 DW performance on
1TB2, 10TB3, and 30TB4
SQL Server 2019Industry-leading performance and security, with intelligence over all your data
Private cloud Public cloud
Most consistent data platformIn-memory across all workloads
1/10th the cost of Oracle
Choice of platform
and language
T-SQL
Java
C/C++
SCALA
Node.js
C#/VB.NET
Python
Ruby
.NET core
Intelligence over
any data
Analytics over structured
and unstructured data with
the power of SQL and
Apache Spark
SQ
L
© Copyright 2019 Dell Inc.23 of Y
SQL Server AG and KubernetesDell EMC Persistent Storage
• AG concepts all apply
• Operator deployment
• Load Balancer on Primary App
• Load Balancer for Secondary Replicas
• Persistent Storage
• Container Storage Interface (CSI)
SQL Server Always Availability Groups - on Linux container - with Kubernetes
Kubernetes cluster
Load BalancerPod
Operator
Node
Pod
Node
SQL Server
primary
AG agent
Pod
Node
SQL Server
secondary
AG agent
Pod
Node
SQL Server
secondary
AG agent
AG
Load Balancer
Reporting
App
Primary
App
Dell EMC Persistent Storage
Persistent Volume Claim {/}{/}{/}{/}{/}
© Copyright 2019 Dell Inc.24 of Y
Closing features gaps for SQL Server on Linux
• Replication
• Distributed transactions
• Machine Learning
Open LDAP Provider support
The Microsoft Container Registry
SQL Server RedHat Container Images
Always On Availability Groups on Kubernetes
Enhancing the platform of choice
© Copyright 2019 Dell Inc.25 of Y
External tablesEasily combine across relational and non-relational data stores
© Copyright 2019 Dell Inc.26 of Y
Azure Data Studio tools experience
Azure Data Studio is a lightweight, open source,
cross-platform graphical management tool and code
editor
Enable a modern DevOps experience for database
developers and DBAs on their platform of choice
Simplify development, configuration,
management, monitoring and troubleshooting
for SQL databases on-premises and in the cloud
Use SQL Server Management Studio 18.0 Preview
to access, configure, manage, and administer all
SQL Server components
© Copyright 2019 Dell Inc.27 of Y
Platform modernization & migrationPathways for a future state Windows Server platform
Upgrade & Replatform
Migrate to on-premises cloud
Migrate to Hybrid Cloud
R E A D Y S O L U T I O N S
Consolidate & Archive
Existing Cloud
Infrastructure
Windows Server 2019
Legacy Windows
Server Workload
or Application
© Copyright 2019 Dell Inc.28
Dell EMC CloudAzure Stack
SQL Data
Modern application architectures on-premises
Apply modern architectures to on-premises apps not yet ready for cloud
• PaaS
• Serverless computing
• Microservices and containers
Move to Azure without code changes
Consistent programming model, skills, and processes
SQL Server and Azure Stack Integration
Unreliable connection to the
cloud
Integration w/ existing on-
prem apps
Regulations, Contracts, Data Sovereignty
Train in Azure at scale
Score locally in Azure Stack
Access to Local Object
Storage
Large Marketplace of Tools
App platform to develop ML
Solutions
Deployed on a Secure Infrastructure
Train & Score in SQL
Deliver Apps in Azure Stack
Hybrid Standalone
When t
o U
se
Be
ne
fits
Pa
tte
rns
Azure Stack Marketplace - open and flexible
Applications
Infrastructure
Management
Databases and
middleware
App frameworks
and tools
DevOps
© Copyright 2019 Dell Inc.33
Next Steps&Offerings
What is driving your modernization initiative?
Move to cloudadopt an as-a-
service model
New versionsnew features &
performance improvements
Product retirementend of extended
support/end of life
Microsoft Azure StackWindows Server 2008
Windows Server 2003Windows Server 2016+
SQL Server 2008
SQL Server 2005SQL Server 2017+ Microsoft Azure SQL Database
© Copyright 2018 Dell Inc.35
Sao Paulo
Round Rock
Mexico City
Santa ClaraNashville
Chicago
New York City
Washington DC
Dell Technologies Customer Solution Centers (AMS)A network of global Customer Solution Centers, helping Customers &
Partners to transform, strategize, architect, validate and build solutions
Customer Environment AnalysisCustomer Environment Analysis
Thank You!Muchas Gracias!!
Muito Obrigado!!!