Released: General Availability of Microsoft.Data.SqlClient 5.0
We have released for general availability Microsoft.Data.SqlClient 5.0. This .NET Data Provider for SQL Server provides general connectivity […]
MS Tech Community
SQL Server 2022 community technology preview 2.1 is now available
Continuing with our release cadence, we’re excited to announce the release of SQL Server 2022 Community Technology Preview 2.1. […]
Cumulative Update #30 for SQL Server 2017 RTM
The 30th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft […]
Upcoming updates to SQL Server container images on Microsoft Artifact ...
As you may be aware, SQL Server container images are published and available on the Microsoft Artifact Registry […]
ODBC Driver 17.10 for SQL Server Released
Version 17.10 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 17.10 brings a few […]
How to enable and run SQL best practices assessments on ...
You can evaluate your SQL Server on Azure VM for configuration best practices using SQL best practices assessment […]
Released: SCOM Management Packs for SQL Server, RS, AS (7.0.38.0)
Updates to SQL Server, Reporting Services, and Analysis Services Management Packs are available (7.0.38.0). You can download the […]
Early technical preview of JDBC Driver 11.1.2 for SQL Server ...
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several […]
Released: Microsoft.Data.SqlClient 5.0 Preview 3
Microsoft.Data.SqlClient 5.0 Preview 3 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider […]
Hotfix: Microsoft Drivers 5.10.1 for PHP for SQL Server Released
We recently released an update to Microsoft Drivers for PHP for SQL Server, version 5.10.1. The update addresses a […]
Security Update for SQL Server 2019 RTM CU16
The Security Update for SQL Server 2019 RTM CU16 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2017 RTM CU29
The Security Update for SQL Server 2017 RTM CU29 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2016 SP3 Azure Connect Feature ...
The Security Update for SQL Server 2016 SP3 Azure Connect Feature Pack GDR is now available for download […]
Security Update for SQL Server 2016 SP3 GDR
The Security Update for SQL Server 2016 SP3 GDR is now available for download at the Microsoft Download […]
Security Update for SQL Server 2016 SP2 CU17
The Security Update for SQL Server 2016 SP2 CU17 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2016 SP2 GDR
The Security Update for SQL Server 2016 SP2 GDR is now available for download at the Microsoft Download […]
Security Update for SQL Server 2014 SP3 CU4
The Security Update for SQL Server 2014 SP3 CU4 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2014 SP3 GDR
The Security Update for SQL Server 2014 SP3 GDR is now available for download at the Microsoft Download […]
Temporal: Encountering Error 13535 Data modification failed on system-versioned table…
When 2 or more workers are modifying the same row, it is possible to encounter 13535. The time […]
Common Criteria EAL4 Certification for SQL19
In May 2022, representatives of the Spanish certification body CCN (Centro Cryptológico National), the Spanish evaluation facility DEKRA […]
How It Works: Workers, Tasks, Failed Logins – What is ...
From Customer Interesting point here is, current_workers_count is ~10X compared to active_workers_count; means no tasks assigned to 10X […]
SQL Server 2022 public preview is now available on Linux.
In continuation of last week’s announcement of SQL Server 2022 public preview, we are pleased to announce availability […]
New server roles for SQL Server 2022 and Azure SQL ...
The article is published here on the Azure SQL Blog: New server roles for Azure SQL Database and SQL […]
Hotfix: JDBC Driver 10.2.1 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 10.2.1. The update addresses a few […]
Spatial: WKT vs Static Geography Function Parameter Positioning Is Reversed
Be careful, this one caused me problems the other day. The WKT (Well-Known Text) format does not match […]
Early technical preview of JDBC Driver 11.1.1 for SQL Server ...
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several […]
How It Works: Temporary Objects – User Transaction Scope
Temporary tables (create table #tmp, select into #tmp, declare @t table, internal worktables from sorts, internal spills from […]
Cumulative Update #16 for SQL Server 2019 RTM
The 16th cumulative update release for SQL Server 2019 RTM for Windows is now available for download at […]
Released: Microsoft.Data.SqlClient 5.0 Preview 2
Microsoft.Data.SqlClient 5.0 Preview 2 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider […]
SQL Server 2022 Early Adoption Program Update – Applications Now ...
Since announcing SQL Server 2022 at Ignite in November 2021, the Early Adoption Program (EAP) has received over 2,500 […]
Early technical preview of JDBC Driver 11.1.0 for SQL Server ...
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several […]
Announcing general availability of the Ebdsv5 series Azure VMs!
This past November at Ignite we announced the public preview of the new Ebdsv5 series of VMs which […]
Cumulative Update #29 for SQL Server 2017 RTM
The 29th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft […]
Configure MSDTC to run Distributed transactions for SQL Server Linux ...
It’s been a while since I’ve had the opportunity to write and share a blog post about SQL […]
GA: SQL best practices assessment for SQL Server on Azure ...
Wouldn’t it be great if there was a way to learn if your SQL Server on Azure Virtual […]
Released: Microsoft.Data.SqlClient 5.0 Preview 1
Microsoft.Data.SqlClient 5.0 Preview 1 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider […]
Capture a Call Stack Without Generating A Dump
Warning (Beta): The RVA feature set is in rollout and subject to change and limitations. XEvent and […]
SQL 2016 – It Just Runs Faster: XEvent Linq Reader
Moved from: bobsql.com SQL Server 2016 improves the XEvent Linq reader scalability and performance. The XEvent UI in SQL Server […]
SQL 2016 – Leverages On Demand MSDTC Startup
Moved from: bobsql.com SQL Server leverages MSDTC for distributed transactions (begin distributed transaction, remote proc trans, etc.) Prior […]
SQL 2016 – It Just Runs Faster: In-Memory Optimized Database ...
Moved from: bobsql.com SQL Server leverages a worker pool for the In-Memory Optimized Database capabilities. Prior to SQL […]
SQL 2016 – It Just Runs Faster – AlwaysOn AES-NI ...
Moved from: bobsql.com The SQL Server 2016, AlwaysOn, log transport takes advantage of hardware based encryption to […]
SQL 2016 – It Just Runs Faster: AlwaysOn Parallel Compression ...
Moved from: bobsql.com SQL Server 2016 introduces two distinct changes in the AlwaysOn transport, compression design. Improved […]
SQL 2016 – It Just Runs Faster: AlwaysOn Log Transport ...
Moved from: bobsql.com The AlwaysOn log transport uses a SQL Broker based design to send and receive […]
SQL 2016 – It Just Runs Faster – BULK INSERT ...
Moved from: bobsql.com SQL Server 2016 enhanced the bulk insert activities (BULK INSERT), leveraging the CPUs vector […]
SQL 2016 – It Just Runs Faster: Column Store Uses ...
Moved from: bobsql.com SQL Server’s Column Store feature is designed to accommodate large amounts of data and […]
SQL 2016 – It Just Runs Faster: Multiple Log Writer ...
Moved from: bobsql.com SQL Server 2016 introduces multiple log writer workers to the engine. For many years the […]
SQL 2016 – It Just Runs Faster: Larger Data File ...
Moved from: bobsql.com SQL Server uses WriteFileGather for the vast majority of data file write requests. The logic is to […]
SQL 2016 – It Just Runs Faster: Indirect Checkpoint Default
Moved from: bobsql.com There are two(2) distinct checkpoint paths provided starting with SQL Server 2014, referred to […]
SQL 2016 – It Just Runs Faster: SOS_RWLock Redesign
Moved from: bobsql.com The SOS_RWLock is a synchronization primitive used in various places throughout the SQL Server […]
SQL 2016 – It Just Runs Faster: Dynamic Memory Object ...
Moved from: bobsql.com The CMemThread waits (PWAIT_MEMTHREAD) can be a point of contention as machine sizes advance. The CMemThread object […]