Cumulative Update #7 for SQL Server 2019 RTM (Removed)
Edit (9/23/2020) There is a known issue with using database snapshots in SQL Server 2019 CU7, and it was removed from the Download Center, the Microsoft Update Catalog, and Linux repositories. Note that using DBCC CHECKDB is also affected because it ge …
The release of the Azure Data Studio extension generator is now available
This post is co-authored by Anjali Agarwal and Laura Jiang.The release of the Azure Data Studio extension generator is now available. Install the generator through npm and get started with extension development with these Azure Data Studio extension tu …
Azure Data Sessions You Won’t Want to Miss at SQLBits 2020
SQLBits 2020 is going digital this year – and, with less than a month away, the excitement for “the greatest data show” is only rising. It is the largest SQL Server and Microsoft Data Platform conference in Europe, bringing together custome …
Hotfix: JDBC Driver 8.4.1 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 8.4.1. The update addresses a few issues that are important to our customers. Fixed issuesFixed issue with SQLServerConnectionPoolProxy not being compatible with …
What is Azure SQL Edge | Data Exposed
In part one of this three-part series, Vasiya Krishnan introduces Azure SQL Edge and its features that make it the optimized database engine for IoT Scenarios. In part two, Vasiya will review customer examples and use cases, and in part three, she’ll c …
Released: Microsoft.Data.SqlClient 2.0.1
We recently released an update to Microsoft.Data.SqlClient, version 2.0.1. The update addresses several issues that are important to our customers. Updates in Microsoft.Data.SqlClient 2.0.1 include: AddedAdded support for a new Configuration …
Azure SQL Capacity Planning: Scenarios | Data Exposed
Capacity planning plays a critical role in migrating an existing application or designing a new one. In the final part of this three-part series with Silvano Coriani, we’ll review various Azure SQL capacity planning scenarios, as well as review best pr …
Released: Microsoft.Data.SqlClient 2.1 Preview 1
The SqlClient team is moving forward with continuous updates and improvements to the Microsoft.Data.SqlClient data provider for SQL Server. Our plan is to provide GA releases twice a year with two preview releases in between. This cadence should provid …
SQL Server Extents, PFS, GAM, SGAM and IAM and related corruptions-2
SQL Server Extents, PFS, GAM, SGAM and IAM and related corruptions-2 In previous post, we discussed the PFS, GAM and SGAM pages. Today, I’m going show you two related corruptions on these pages. SQL Server checks the bit in PFS, GAM, SGAM …
SQL Server GAM corruption samples
SQL Server Extents, PFS, GAM, SGAM and IAM and related corruptions-2 In previous post, we discussed the PFS, GAM and SGAM pages. Today, I’m going show you two related corruptions on these pages. SQL Server checks the bit in PFS, GAM, SGAM …
SQL Server Extents, PFS, GAM, SGAM and IAM and related corruptions
I’m going to start a series of posts talking about SQL Server allocation pages and corruption. Each post will have samples showing how SQL Server use these pages and scenarios of corruption. The first post will talk about the Extents, PFS, GAM, S …
SQL Service failed to start because of ‘Detected unsupported pre-release version of Windows’
1. SQL SERVER cannot start and reported ‘Failed to allocate pages’. It looks like memory shortage issue. But we are quite sure that the server has enough memory. So we decided to focus on ‘Detected unsupported pre-release version of Windows …
Released: SQL Server Management Pack (7.0.24.0)
An updated version of SQL Server Management Pack is ready. It has many new features which are mostly based on your feedback. Please download at: Microsoft System Center Management Pack for SQL Server What’s New Added a new “Se …
Azure SQL Capacity Planning: DTU or vCore? | Data Exposed
Capacity planning process plays a critical role in migrating to an existing application or designing a brand new one. In the second part of this three-part series with Silvano Coriani, learn about the differences between DTU and vCore when plann …
Commands we can use to manage SQL Server availability group on Linux Pacemaker cluster
Thanks to Jayantha Das, who shared some of the common command we use in SQL Server on Linux Pacemaker Maker cluster. This blog contains the pacemaker settings that we can modify. Unless explicitly required it is recommended that we don …