SQL Server 2022 is here! Let’s Discuss
Wed, 16 Nov 2022 17:14:16 -0000
|Read Time: 0 minutes
Today at the PASS Community Data Summit, Microsoft announced the general availability of SQL Server 2022. Over the past year Dell Technologies has been working closely with Microsoft to make sure that when this day arrived, our joint customers would be ready to rapidly adopt the latest release and be able to deploy and manage with confidence based on documented testing and best practices.
Schedule
Dell Technologies is a gold sponsor at PASS 2022 and will be engaging with both in-person and virtual conference attendees in the following ways:
In-person sessions
Wednesday 9:30am – 10:45: SQL Server 2022 – A Year in (P)review in room 604
Thursday 6:45AM – 7:45: Deploying and Running SQL Server 2022 on Azure Stack HCI in rooms 602-604
On demand session
Rethink your Backup and Recovery Strategy with SQL Server 2022 available in catalog
Birds of a Feather
Wednesday 12:30 - 2:30 Hybrid Cloud Data Services in Dining Hall 4EF
Thursday 12:30 – 2:30 SQL Server 2022: A Dell Perspective in Dining Hall 4EF
In addition to these sessions, we are excited to announce a wide range of available assets today to assist you with getting the most value out of your Microsoft data platform.
New Feature: T-SQL Snapshot Backups
Taking snapshots of databases isn’t new technology, however, having the ability to leverage them in a supported way on Microsoft SQL Server while leveraging T-SQL is very exciting. Storage-based snapshots are not meant to replace all traditional database backups. Off-appliance and/or offsite backups are still a best practice for full data protection. However, most backup and restore activities do not require off-appliance or offsite backups, and this is where time and space efficiencies come in. Storage-based snapshots accelerate the majority of backup and recovery scenarios without affecting traditional database backups.
In the links below, we show how to leverage this feature our PowerStore, PowerMax, and PowerFlex storage platforms. This is a very effective tool moving forward for Windows, Linux and even containerized environments.
SQL Server 2022 – Time to Rethink your Backup and Recovery Strategy | Dell Technologies Info Hub
SQL Server 2022 Backup Using T-SQL and Dell PowerFlex Storage Snapshots | Dell Technologies Info Hub
SQL Server 2022 Data Analytics with Dell PowerEdge and Dell ECS
Data virtualization has become popular among large enterprises because unstructured and semi-structured data is everywhere and leveraging this data is challenging. SQL Server 2022 PolyBase makes data virtualization possible for data scientists to use T-SQL for analytic workloads by querying data directly from S3-compatible object storage without separately installing client connection software.
Dell ECS is a modern object storage platform designed for both traditional and next-generation workloads and it provides organizations with an on-premises alternative to public cloud solutions. Dell Technologies has been named a Leader in the 2022 Gartner® Magic Quadrant™ for Distributed File Systems and Object Storage1 for the seventh year in a row – a Leader every year since the commencement of this report. According to the Gartner report, Dell Technologies has also once again received the highest overall position for its Ability to Execute in the Leaders quadrant of the report.1
As organizations, both large and small, seek to gain an edge with their intelligent data estate, access to all types of datasets must be made available. SQL Server 2022 and Dell ECS is the preferred technology for querying the Data Lake using a T-SQL surface area. This combination of products and tools yields modern opportunities to store and manage different types of data on-premises and at public cloud scale. This white paper provides an insight into the benefits of a powerful, agile, and flexible infrastructure for SQL Server 2022 data analytics.
New Feature: Backing up SQL Server to Dell ECS
In the same paper above, we leveraged the same environment to showcase the new SQL Server 2022 capabilities to run backup and restore of databases leveraging object storage with Dell ECS. One of the benefits of being able to leverage object storage is the ability to move larger read-only tables outside of the SQL database. This reduced the footprint of the database and decreases the time it takes to backup and restore.
In this document we provide the configuration steps for creating the required credential inside the SQL Server Instance for connection to ECS as well as show the correct syntax for backing up and restoring a database.
SQL Server 2022 on Dell Integrated System (DIS) for Azure Stack HCI
Dell Azure Stack HCI provides a flexible, highly available, and cost-effective platform to host Online Transaction Processing (OLTP) workloads such as SQL Server 2022. In this reference architecture we evaluated some performance results and design best practices for a cluster of AMD EPYC™ 7003 Series Processors with 3D V-Cache based DIS for Azure Stack HCI. This cost-effective solution offers strong performance results, a low data center footprint, and a highly flexible configuration in terms of compute and storage.
For those of you joining us in person at PASS, we will be jointly hosting a breakfast session with AMD and to present the reference architecture, design principles and configuration best practices for a SQL Server 2022 solution for Windows Server 2022 on Azure Stack HCI – AX7525.
Join Dell Technologies and AMD for breakfast here.
azure-stack-hci-and-the-microsoft-data-platform.pdf (delltechnologies.com)
Take the next steps
Dell Technologies Solutions for Microsoft Data Platform | Dell USA
Dell Technologies Solutions for Microsoft Azure Arc | Dell USA
PASS Data Community Summit November 15-18 2022
1Gartner, Inc. “Magic Quadrant™ for Distributed File Systems and Object Storage” by Julia Palmer, Jerry Rozeman, Chandra Mukhyala, Jeff Vogel, October 19, 2022. Dell Technologies was previously recognized as Dell EMC in the Magic Quadrant (2016-2019).
Related Blog Posts
Joint engineering with AMD for SQL Server 2022
Mon, 14 Nov 2022 13:49:15 -0000
|Read Time: 0 minutes
In preparation for the PASS Data Community Summit, Dell Technologies has been heads down in our engineering labs testing some of the new features of SQL Server 2022. In this blog we will highlight a number of use cases, leveraging AMD EPYC™ 7003 Series Processors with 3D V-Cache. 3D V-Cache processors utilize AMD’s ground-breaking 3D Chiplet architecture with up to 768MBs of L3 cache per socket while providing socket compatibility with existing AMD EPYC™ 7003 platforms. AMD EPYC is optimized for performance with up to 64 cores and 4TB of memory per CPU.
SQL Server 2022 is the most Azure-enabled release of SQL Server, with continued innovation across performance, security, and availability. SQL Server 2022 is part of the Microsoft Intelligent Data Platform, which unifies operational databases, analytics, and data governance. The reference architecture below shows how an Azure Arc-enabled Azure Stack HCI platform helps to consolidate virtualized SQL Server workloads and get up and running quickly on SQL Server 2022.
SQL Server 2022 on Azure Stack HCI
Dell Azure Stack HCI provides a flexible, highly available, and cost-effective platform to host Online Transaction Processing (OLTP) workloads such as SQL Server 2022. This document provides customers with best practice recommendations on how to deploy SQL Server 2022 on a Dell Integrated System (DIS) for Azure Stack HCI. These best practices consider both performance and high availability.
We also evaluated some performance results and design best practices for a cluster of AMD EPYC™ 7003 Series Processors with 3D V-Cache based DIS for Azure Stack HCI. This cost-effective solution offers strong performance results, a low data center footprint, and a highly flexible configuration in terms of compute and storage.
Only Azure Stack HCI from Dell Technologies leverages Dell OpenManage Integration for Windows Admin Center to orchestrate full stack lifecycle management, enabling complex tasks to be completed in a fraction of the time.
Read the full paper here.
If you are joining Dell Technologies and AMD at the PASS Data Community Summit (November 15th-18th, please join us for breakfast session and get all the details on this solution and ask the experts all of the questions you may have.
Attending the PASS Community Data Summit? Register for the breakfast here.
SQL Server 2022 Data Analytics with Dell PowerEdge and Dell ECS
Data virtualization has become popular among large enterprises because unstructured and semi-structured data is everywhere and using this data is challenging. SQL Server 2022 PolyBase makes data virtualization possible for data scientists to use T-SQL for analytic workloads by querying data directly from S3-compatible object storage without separately installing client connection software.
Data analytic workloads can be CPU intensive and selecting the optimal CPUs for the data analytic servers can be challenging, time consuming, and expensive. Because running T-SQL queries for data analytics require quick response time, as in the previous document, here we leveraged the new Milan-X AMD EPYC processor with 3D V-Cache technology. The AMD 3D V-Cache technology is the first implementation of the AMD 3D Chiplet Architecture. 3D V-Cache product offers three times the L3 cache compared to standard 3rd Gen EPYC processors and keeps memory intensive compute closer to the core speeding up performance for database and analytics workloads. AMD 3rd Gen EPYC™ Processors with 3D V-Cache helps customers optimize core usage, license costs and total cost-of-ownership.
ECS, a modern object storage platform designed for both traditional and next-generation workloads, provides organizations with an on-premises alternative to public cloud solutions. Dell Technologies has been named a Leader in the 2022 Gartner® Magic Quadrant™ for Distributed File Systems and Object Storage for the seventh year in a row – a Leader every year since the commencement of this report. According to the Gartner report, Dell Technologies has also once again received the highest overall position for its Ability to Execute in the Leaders quadrant of the report (based on Bellcore component reliability modeling across all AX-nodes).
As organizations, both large and small, seek to gain an edge with their intelligent data estate, access to all types of datasets must be made available. SQL Server 2022 and Dell ECS is the preferred technology for querying the Data Lake using a T-SQL surface area. This combination of products and tools yields modern opportunities to store and manage different types of data on-premises and at public cloud scale.
Read the full paper here.
SQL Server 2022 Backup & Restore with Dell ECS S3 Object Storage
In the same paper above, we leveraged the same environment to showcase the new SQL Server 2022 capabilities to run backup and restore of databases leveraging object storage with Dell ECS. One of the benefits of being able to leverage object storage is the ability to move larger read-only tables outside of the SQL database. This reduced the footprint of the database and decreases the time it takes to backup and restore.
In this document we provide the configuration steps for creating the required credential inside the SQL Server Instance for connection to ECS as well as show the correct syntax for backing up and restoring a database.
Take the next step…
Microsoft Azure Stack HCI | Dell USA
Dell Technologies Solutions for Microsoft Data Platform | Dell USA
Dell Technologies Solutions for Microsoft Azure Arc | Dell USA