SQLServer Just tweeted ********************************************** Did you know: in SQL Server 2022, you can back up or restore databases using simple storage service-compatible object storage, on-premises or in the cloud. This post explains how: https://t.co/2pwCv4s8Fx #SQLServer2022 #Storage https://t.co/yziric8kRc
Microsoft SQL Server Blog
Backup and restore to URL for S3-compatible object storage - Microsoft SQL Server Blog
Backup and restore to S3-compatible object storage is a new feature introduced in SQL Server 2022, on-premises or in the cloud.
SQLServer Just tweeted ********************************************** 👀 Tune in for a Data Exposed exclusive! Learn more about what you can expect at #PASSDataCommunitySummit and find out how you can get involved: https://t.co/FusCjAjGbG #SQLServer2022
YouTube
SQL Server 2022 @ PASS Data Community Summit | Data Exposed Exclusive
In this Data Exposed Exclusive, join Anna Hoffman, Annabel Bradford, and Bob Ward as they discuss everything you need to know about the upcoming PASS Data Community Summit! Whether you join the conference online or in person, you'll be able to connect, share…
SQLServer Just tweeted ********************************************** SQL Server 2022 introduces the latest version of PolyBase, which includes updates for: ✔️ Querying data where it lives ✔️ Virtualizing data ✔️ Using REST APIs Read about the updates on the SQL Server blog: https://t.co/oQWNkPZkzH #SQLServer2022 #SQLServer https://t.co/GB7q1fCubH
Microsoft SQL Server Blog
Data Virtualization with PolyBase for SQL Server 2022 - Microsoft SQL Server Blog
SQL Server 2022 introduces the newest version of PolyBase, and with it the capability to query data where it lives, virtualize data, and use REST APIs.
SQLServer Just tweeted ********************************************** Get the right degree of parallelism (DOP) without extensive manual tests using DOP feedback for #SQLServer2022! Read more: https://t.co/RaTJsOYKN8 https://t.co/fOhcBBErQs
Microsoft SQL Server Blog
Intelligent Query Processing: degree of parallelism feedback - Microsoft SQL Server Blog
DOP feedback for SQL 22 addresses a long-held challenge for our customers: finding the right degree of parallelism for each query without having to manually test and tweak each query for optimal performance.
SQLServer Just tweeted ********************************************** RT @AzureSQL: Join us as we kick-off💥a new series on Data Exposed all about the features and enhancements now available in #SQLServer2022 - this week on Data Exposed with @AnalyticAnna & @bobwardms! Watch 📺: https://t.co/iAO7Wyvl8q #AzureSQL https://t.co/86i7Sf3yfh
YouTube
SQL Server 2022: Introducing SQL Server 2022 General Availability [Ep. 1] | Data Exposed
The latest release of SQL Server, SQL Server 2022, is now available. Join Anna Hoffman and Bob Ward in this episode of Data Exposed as they walk you through the most Azure-enabled release of SQL Server yet. With continued innovation in performance, security…
SQLServer Just tweeted ********************************************** You can now tailor models to a specific query when using Cardinality Estimation Feedback in #SQLServer2022! Learn more about model variants: https://t.co/amtjqv41kA
Microsoft SQL Server Blog
Cardinality Estimation Feedback in SQL Server 2022 - Microsoft SQL Server Blog
In SQL Server 2022, we have introduced a method of CE Feedback which adjusts those assumptions in a per-query way. Learn more.
SQLServer Just tweeted ********************************************** 🥳 SQL Server 2022 is now available! Tune in for the first episode of a new Data Exposed series to learn all about #SQLServer2022's capabilities and how it integrates with the Microsoft Intelligent Data Platform: https://t.co/pIIdDMauRb #DataExposed https://t.co/XQ7qMek7sE
YouTube
SQL Server 2022: Introducing SQL Server 2022 General Availability [Ep. 1] | Data Exposed
The latest release of SQL Server, SQL Server 2022, is now available. Join Anna Hoffman and Bob Ward in this episode of Data Exposed as they walk you through the most Azure-enabled release of SQL Server yet. With continued innovation in performance, security…
SQLServer Just tweeted ********************************************** #ICYMI Check out this new Data Exposed episode covering how #SQLServer2022 is cloud connected. A few topics ☔Business continuity through Azure SQL MI 💫Azure Synapse Link for SQL Server 🪪Azure Active Directory for SQL Server 🔐Microsoft Purview access policies for SQL Server https://t.co/zXBuND3Twf
SQLServer Just tweeted ********************************************** RT @AzureSQL: Learn about what's new in Visual Studio Extensions for SSAS and SSRS in #SQLServer2022 & more - this week on Data Exposed with @AnalyticAnna and Subhojit Basak. Watch 📺: https://t.co/R5i0XLPGus #AzureSQL https://t.co/7hCXFUuoeS
YouTube
What’s New in Visual Studio Extensions for SSAS and SSRS | Data Exposed
The latest version of SSAS and SSRS was released on November 17, 2022. In this episode of Data Exposed with Anna Hoffman and Subhojit Basak, they'll highlight the major improvements and additions released in the latest version.
00:00 Introduction
01:30 SQL…
00:00 Introduction
01:30 SQL…
SQLServer Just tweeted ********************************************** RT @AzureSQL: With the new Intelligent Query Processing scenarios & Query Store enhancements you can accelerate query performance & tuning with no code changes required. Learn more in this episode with @AnalyticAnna & @bobwardms! Watch 📺: https://t.co/UdC2Atx41z #AzureSQL #SQLServer2022 https://t.co/OPSO5aqHm7
YouTube
SQL Server 2022: Built-in Query Intelligence [Ep. 3] | Data Exposed
In this episode of Data Exposed with Anna Hoffman and Bob Ward, take advantage of performance and availability for faster queries and to help ensure business continuity. Accelerate query performance and tuning with no code changes required with new Intelligent…
SQLServer Just tweeted ********************************************** RT @AzureSQL: 22 second, 2.5 TB database backup and restore. Take point-in-time restores for massive multi-terabyte databases from hours to seconds. See it work for #SQLServer2022: https://t.co/wnUZxObclx #AzureSQL https://t.co/g5WocJASwN
YouTube
Query Performance & Database Failover | SQL Server 2022 Updates
Improve hybrid workloads with updates to SQL Server 2022, now generally available. Link local SQL Servers to Azure SQL Managed Instances for bidirectional disaster recovery, achieve massive speedups with differential snapshot-based backup and restore, as…
SQLServer Just tweeted ********************************************** Faster queries? ✔️ Better business continuity? ✔️ Tuning with no code changes? ✔️ Learn more about enhancing query performance during this episode of Data Exposed: https://t.co/WNeYOkeAsc #SQLServer2022 #DataExposed https://t.co/9hjL9h0tYl
YouTube
SQL Server 2022: Built-in Query Intelligence [Ep. 3] | Data Exposed
In this episode of Data Exposed with Anna Hoffman and Bob Ward, take advantage of performance and availability for faster queries and to help ensure business continuity. Accelerate query performance and tuning with no code changes required with new Intelligent…
SQLServer Just tweeted ********************************************** RT @AzureSQL: This week on Data Exposed with @AnalyticAnna & @bobwardms, learn how #SQLServer2022 brings more security to the database with always encrypted enhancements and SQL Ledger, an immutable ledger to track evidence of tampering. Watch 📺: https://t.co/aZYiQD0hkS #AzureSQL https://t.co/aQi0aRE5P0
YouTube
SQL Server 2022: Security, scalability, availability [Ep. 4] | Data Exposed
SQL Server 2022 brings more security to the database rated as least vulnerable over the last ten years with always encrypted enhancements and SQL Ledger, an immutable ledger to track evidence of tampering. Additional Azure-enabled features including Microsoft…
SQLServer Just tweeted ********************************************** Learn about the new layers of protection and access control in SQL Server 2022 on this episode of Data Exposed: https://t.co/9kb07hWYR2 #SQLServer2022 #DataExposed https://t.co/24Bz35wyYP
YouTube
SQL Server 2022: Security, scalability, availability [Ep. 4] | Data Exposed
SQL Server 2022 brings more security to the database rated as least vulnerable over the last ten years with always encrypted enhancements and SQL Ledger, an immutable ledger to track evidence of tampering. Additional Azure-enabled features including Microsoft…
SQLServer Just tweeted ********************************************** RT @AzureSQL: Learn about some of the new snapshot capabilities built in with T-SQL in #SQLServer2022, this week on Data Exposed with @AnalyticAnna & Perry Skountrianos. Watch 📺: https://t.co/CI9ScEE1TW #AzureSQL #SQLServer https://t.co/A2YZ1Z1SX6
YouTube
Rethink your backup & recovery strategy w/ T-SQL Snapshot Backup in SQL Server 2022 | Data Exposed
In this Data Exposed episode with Anna Hoffman and Perry Skountrianos, we will discuss the new capability in SQL Server 2022 that introduces new cross platform T-SQL commands to perform a snapshot backup of your user databases. We will cover the use cases…
SQLServer Just tweeted ********************************************** RT @AzureSQL: Let's discuss the new foundational capability in #SQLServer2022 that leverages acceleration technologies from partners such as Intel to provide extended capabilities - this week on Data Exposed with @AnalyticAnna & @dpless. Watch 📺: https://t.co/Pm1QFigbeC #AzureSQL #SQLServer https://t.co/r7x3euwNXb
YouTube
SQL Server 2022 acceleration & offloading with Intel® QuickAssist Technology (QAT) | Data Exposed
In this episode with Anna Hoffman and David Pless, we will discuss the new foundational capability in SQL Server 2022 that leverages acceleration technologies from partners such as Intel to provide extended capabilities.
At release, Intel® QuickAssist Technology…
At release, Intel® QuickAssist Technology…
SQLServer Just tweeted ********************************************** RT @AzureSQL: Next in the #SQLServer2022 Data Exposed series, @AnalyticAnna & @bobwardms teach you how to integrate #SQLServer with other data sources and data lakes including Azure Storage and S3 compatible object storage providers. Watch 📺: https://t.co/ZV3DDqwRnK #AzureSQL https://t.co/I78QHyraf7
YouTube
SQL Server 2022: Data Virtualization and Object Storage [Ep. 5] | Data Exposed
SQL Server 2022 enables new data scenarios through data virtualization. In this episode of Data Exposed with Anna Hoffman and Bob Ward, learn how to integrate SQL Server with other data sources and data lakes including Azure Storage and S3 compatible object…
SQLServer Just tweeted ********************************************** RT @AzureSQL: Find out about all the ✨NEW✨ T-SQL enhancements in #SQLServer2022 - this week on Data Exposed with @AnalyticAnna & @bobwardms. Watch 📺: https://t.co/UiQf4gwyBt #AzureSQL https://t.co/f0AH49Emn4
YouTube
SQL Server 2022: T-SQL Enhancements [Ep. 6] | Data Exposed
In this episode of Data Exposed with Anna Hoffman and Bob Ward, enhance your application with new T-SQL language capabilities including JSON, core engine, and time series.
0:00 Introduction
0:53 Language enhancements for developers
2:00 Examples
5:08 Summary…
0:00 Introduction
0:53 Language enhancements for developers
2:00 Examples
5:08 Summary…
SQLServer Just tweeted ********************************************** SQL Server 2022 has accelerated database recovery enhancements! Read about the improvements to persistent version store cleanup and management: https://t.co/FJ6qYQvXfo #SQLServer2022 #DataManagement https://t.co/HjFQntdb7D
Microsoft SQL Server Blog
Accelerated Database Recovery enhancements in SQL Server 2022
We are excited to share that there are several Accelerated Database Recovery enhancements in SQL Server 2022.
SQLServer Just tweeted ********************************************** Learn about cross-platform T-SQL commands for snapshot backups of user databases, with end-to-end demo and usage tips for devs and database admins: https://t.co/mzovfz54kd #DataExposed #SQLServer2022 https://t.co/kJSw8qGP6o
YouTube
Rethink your backup & recovery strategy w/ T-SQL Snapshot Backup in SQL Server 2022 | Data Exposed
In this Data Exposed episode with Anna Hoffman and Perry Skountrianos, we will discuss the new capability in SQL Server 2022 that introduces new cross platform T-SQL commands to perform a snapshot backup of your user databases. We will cover the use cases…