Working with time series data in SQL Server 2022 and Azure SQL
Time series capabilities in SQL Server were introduced in Azure SQL Edge, Microsoft’s version of SQL Server for the Internet of Things. Read more
SQL Server 2022
Cardinality Estimation Feedback in SQL Server 2022
In SQL Server 2022, we have introduced a method of CE Feedback which adjusts those assumptions in a per-query way, based on actual performance of the query over time. Read more
Azure Synapse Link for SQL
Azure Synapse Link for SQL provides an automated way to extract data from source operational systems without having to build custom ETL processes. Read more
Intelligent Query Processing: feature family additions
SQL Server 2022 expands and improves query performance feedback mechanisms and adds two new features—parameter sensitive plans and optimized plan forcing. Read more
Query Store hints in SQL Server 2022
Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database workloads. Read more
Azure Data Studio August Release
SQL Server 2022, the most Azure-enabled release of SQL Server yet was announced in May and is publicly available in preview. SQL Server 2022 (preview) is now also available as an option in the Azure Data Studio Deployment Wizard. Read more
Register today—Free Azure Data training at Data Platform Summit 2022
Data Platform Virtual Summit 2022 (DPS 2022), a free global learning event for data professionals, is just a few weeks away running from September 19–23. Read more
Establish digital trust in your data with ledger in SQL Server 2022
We are pleased to introduce you to ledger, a new technology that uses the power of blockchain to offer a tamper-proof record of data modifications. Currently in Azure SQL, this feature is also part of the SQL Server 2022 release. Read more
Azure Active Directory authentication for SQL Server 2022
Part of the SQL Server 2022 blog series. Azure Active Directory (Azure AD) authentication is now supported for SQL Server 2022 preview on-premises for Windows and Linux Operating Systems. Azure AD Authentication methods The new functionality extends existing authentication modes, such as SQL authentication and Windows authentication, allowing users to connect to SQL Server 2022 using Read more
Improve scalability with system page latch concurrency enhancements in SQL Server 2022
Over the past several SQL Server releases, Microsoft has improved the concurrency and performance of the tempdb database. In SQL Server 2022 we are addressing one of the last areas of contention by introducing concurrent global allocation map (GAM) and shared global allocation map (SGAM) updates which will give SQL Server 2022 a big improvement Read more
Improve scalability with Buffer Pool Parallel Scan in SQL Server 2022
Buffer Pool Parallel Scan is a new feature in SQL Server 2022 that improves the scalability of several common scenarios in SQL Server and as a result, could significantly improve the performance of your database workloads. Read more
PASS Data Community Summit keynote: a bridge to a new universe
It is almost time for PASS Data Community Summit 2021, a free online conference for the Microsoft data platform professional. The conference, hosted by Redgate, will include the latest SQL Server and Azure data innovations, practical training, and networking to empower you to transform your career and your organization. This year’s event is coming to Read more