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 …
Memory Grant Feedback: Persistence and Percentile Grant
Part of the SQL Server 2022 blog series.Memory grant feedback (MGF) is an existing feature in SQL Server, with two critical improvements available in SQL Server 2022: feedback persistence, and percentile grant feedback. These two features enhance the b …
OLE DB Driver 19.2 for SQL Server Released
Version 19.2 of the Microsoft OLE DB Driver for SQL Server has been released. Version 19.1 includes new features that improve security in the driver. Features Support for TLS 1.3 with TDS 8.0 Support for the Server Certificate connecti …
Connecting the Dots of Azure SQL CICD Part 1: Getting Started
Azure SQL CICD Part 1: Getting Started Continuous Integration (CI) and Continuous Delivery/Deployment (CD) are a set of principles or methodologies that empower development teams to deliver code faster, more reliably, and with fewer bugs compared to tr …
Released: Microsoft.Data.SqlClient 5.1 Preview 1
Microsoft.Data.SqlClient 5.1 Preview 1 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 …
Support reminder for older versions of Visual Studio
We want to keep you secure when using Visual Studio. If you’re using an older version of Visual Studio, we have several reminders about upcoming events in the Visual Studio support lifecycle. First, if you’re using the Community Edition of Visual Studi …
Intelligent Query Processing: degree of parallelism feedback
SQL Server 2022, UpdatesPart of the SQL Server 2022 blog series.DOP inefficiencies are a constant challenge; Current DOP methods are inefficientThe degree of parallelism (DOP) with which a query is executed can greatly impact its performance. Any …
Released: Microsoft.Data.SqlClient 5.0.1
We have released an update to Microsoft.Data.SqlClient, version 5.0.1. The update addresses several issues that are important to our customers. Updates in Microsoft.Data.SqlClient 5.0.1 include: Fixed Fixed missing HostNameInCertific …
Modernize your data estate on SQL from cloud to edge
Experience SQL innovation with consistency and rich Azure integration At this year’s Microsoft Ignite 2022 event, we talked about doing more with less and unlocking the value of your data. Leveraging the cloud to reduce costs, drive productivity …
Announcing Entity Framework Core 7 RC2: JSON Columns
Entity Framework Core 7 (EF7) RC2 has shipped! The RC2 release contains all features planned for the EF7 GA release. This includes: Mapping to SQL Server JSON Columns ExecuteUpdate and ExecuteDelete (Bulk updates) Improved performance for SaveChanges T …