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).