SQL Server 2022 is now generally available
Part of theSQL Server 2022 blog series.Today, we announced the general availability of SQL Server 2022, the most Azure-enabled release of SQL Server yet, with continued innovation across performance, security, and availability1. This marks the latest m …
Link feature for Azure SQL Managed Instance: Connecting SQL Server 2022 to the cloud, reimagined
Part of theSQL Server 2022 blog series.We are excited to announce general availability (GA) of the link feature for Managed Instance for SQL Server 2022the most Azure-enabled release of SQL Server yet. We are also excited to announce a limited preview …
Azure SQL Database External REST Endpoints Integration Public Preview
The ability to call a REST endpoint natively from Azure SQL Database, which was made available via an Early Adopter Preview in May, is now moving to Public Preview. I’m extremely happy that as of today the new system stored procedure sp_invoke_external …
Report Server Temporary database configuration with Always on Availability groups in SQL server
Report Server uses Report Server Temporary database to store session and execution data, information related to cached reports. These tables in the ReporServerTemp database hold temporary data and there are certain Stored Procedures which periodically …
Released: Microsoft.Data.SqlClient 5.1 Preview 2
Microsoft.Data.SqlClient 5.1 Preview 2 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider for SQL Server. Our plan is to provide GA releases twice a year with two or three preview releases in …
Optimum performance for your data with SQL Server 2022
Dell, HPE, Lenovo, and Supermicro, amongst other Server OEMs, announced availability today of new systems running on AMD EPYC™ processor-based servers designed to optimize performance, transaction processing rates, availability, and security with SQL S …
Azure Data Studio and BDC Retirement
In February of this year, retirement of SQL Server 2019 Big Data Clusters Add-On was announced (Big data options on the Microsoft SQL Server platform – SQL Server | Microsoft Docs), with support continuing through February 2025. Customers can cur …
.NET 7 is Available Today
Download .NET 7 today! .NET 7 brings your apps increased performance and new features for C# 11/F# 7, .NET MAUI, ASP.NET Core/Blazor, Web APIs, WinForms, WPF and more. With .NET 7, you can also easily containerize your .NET 7 projects, set up CI/CD wor …
PASS Data Community Summit 2022 keynote: Transform your data estate with Microsoft’s Intelligent Data Platform
I look forward to seeing you at PASS Data Community Summit, a conference curated for the Microsoft data platform professional. Hosted by Redgate, this hybrid event will include the latest innovation across SQL Server and the entire Microsoft Intelligen …
Entity Framework Core 7 (EF7) is available today
Entity Framework Core (EF Core) 7 is available on NuGet today! EF Core 7 is the successor to EF Core 6, and can be referred to as EF7 for brevity. EF Core 7 contains many features that help in porting « classic » EF6 applications to use EF7. As such, we …
Connecting the Dots of Azure SQL CICD Part 2: Local Development
Join us for part two of our Azure SQL database change management (CICD) series. This post covers local development environments with Visual Studio Code. Prerequisites Check For Database Projects to deploy correctly, we need to have the .NET Core SDK in …
Take the SQL Server Mac challenge
When I graduated from college, one of the first computers I ever used was a MacIntosh. I loved the Mac, the user interface, and the overall footprint of that computer. I also started my career developing on UNIX systems with C++ and databases like Ingr …
Early technical preview of JDBC Driver 12.1.0 for SQL Server released
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several additions and changes. Precompiled binaries are available on GitHub and also on Maven Central. Below is a summary of th …
Update: ODBC Driver 18.1.2 for SQL Server Released
Version 18.1.2 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 18.1.2 brings a few fixes to the driver. Fixes Fix VBS-NONE enclave attestation protocol Fix error when retrieving numeric column with Regional=Yes Fix …
Multi-column statistics
In post SQL Server CE: Multiple single-column statistics, I discussed how SQL Server calculates Multiple single-column statistics. I’m going to talk about the ‘multiple-columns statistics’ today. Here are examples , adventure 20 …