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