cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL Server Blog
Options
1,553

SQL Server 2022 Release Candidate 1 is now available

Ajay_MSFT on Sep 29 2022 10:33 AM
Try out the new features in SQL Server 2022 Release Candidate 1 which is now available for download.
900

Cumulative Update #18 for SQL Server 2019 RTM

HristinaSQL on Sep 28 2022 03:37 PM
The 18th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft Downloads site...
585

dbcc dumptrigger: Capture a dump for specific error and state

BobDorr on Sep 28 2022 07:13 AM
You can collect a process dump (SQL Dumper) when a specific error occurs using XEvent (error_reported/ex_raise2 events w...
881

Revamped SQL Permission system for Principle of Least Privilege and external policies – internals

AndreasWolter on Sep 27 2022 02:46 PM
A view under the hood of the revamped SQL Server permission system
933

Cumulative Update #31 for SQL Server 2017 RTM

HristinaSQL on Sep 20 2022 03:43 PM
The 31st cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site...
1,121

Released: Microsoft.Data.SqlClient 2.1.5

David-Engel on Sep 14 2022 05:12 PM
We have released an update to Microsoft.Data.SqlClient, version 2.1.5. The update addresses a couple of issues that are ...
643

Released: Microsoft.Data.SqlClient 4.0.2

David-Engel on Sep 14 2022 11:00 AM
We have released an update to Microsoft.Data.SqlClient, version 4.0.2. The update addresses several issues that are impo...
1,230

Released: Microsoft.Data.SqlClient 4.1.1

David-Engel on Sep 14 2022 09:00 AM
We have released an update to Microsoft.Data.SqlClient, version 4.1.1. The update addresses several issues that are impo...
1,235

Hotfix: JDBC Driver 11.2.1 for SQL Server Released

David-Engel on Sep 13 2022 04:54 PM
We recently released an update to Microsoft JDBC Driver for SQL Server, version 11.2.1. The update addresses a couple is...
1,791

Deploy Always On Availability Groups (AG) on SQL Server RHEL based Azure VMs - The Ansible Way!

amvin87 on Sep 02 2022 08:43 AM
1) Setting up and Configuring pacemaker cluster on three SQL Server RHEL based Azure VMs. 2) Configuring and deploying S...
966

Released: Microsoft.Data.SqlClient 2.1.5

David-Engel on Aug 31 2022 09:00 AM
We have released an update to Microsoft.Data.SqlClient, version 2.1.5. The update addresses a few issues that are import...
885

HOW IT WORKS: dm_os_ring_buffer vs XEvent *_ring_buffer_reported events

BobDorr on Aug 29 2022 08:52 AM
RESOURCE_MONITOR_RING_BUFFER vs resource_monitor_ring_buffer_recorded
1,440

Updates to the modern servicing model for SQL Server 2017 and future versions of SQL Server on Linux

amvin87 on Aug 25 2022 03:04 AM
Please do note that the previous Announcing the Modern Servicing Model for SQL Server | Microsoft Docs article has been ...
8,822

SQL Server 2022 Release Candidate 0 is now available

Ajay_MSFT on Aug 23 2022 03:48 PM
Try out the new features in SQL Server 2022 Release Candidate 0 which is now available for download.
2,677

New granular permissions for SQL Server 2022 and Azure SQL to improve adherence with PoLP

AndreasWolter on Aug 23 2022 11:30 AM
The new granular permissions in SQL Server 2022 explained.
1,574

Released: Microsoft.Data.SqlClient 3.1.1

David-Engel on Aug 12 2022 03:00 PM
We have released an update to Microsoft.Data.SqlClient 3.1, version 3.1.1. The update addresses several issues that are ...
1,892

Cumulative Update #17 for SQL Server 2019 RTM

HarveyMoraSQL on Aug 11 2022 03:05 PM
The 17th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft Downloads site...
1,565

JDBC Driver 11.2 for SQL Server Released

David-Engel on Aug 09 2022 03:34 PM
JDBC Driver 11.2 for SQL Server has been released, adding official support for Java 18, TDS 8.0 and several other improv...
1,630

ODBC Driver 18.1 for SQL Server Released

David-Engel on Aug 09 2022 03:19 PM
Version 18.1 of the Microsoft ODBC Driver for SQL Server has been released. Version 18.1 includes new features and fixes...
1,725

Released: General Availability of Microsoft.Data.SqlClient 5.0

David-Engel on Aug 08 2022 09:40 AM
We have released for general availability Microsoft.Data.SqlClient 5.0. This .NET Data Provider for SQL Server provides ...
5,058

SQL Server 2022 community technology preview 2.1 is now available

Ajay_MSFT on Jul 27 2022 10:46 AM
Try out the new features in SQL Server 2022 Community Technology Preview 2.1 which is now available for download.
1,369

Cumulative Update #30 for SQL Server 2017 RTM

HarveyMoraSQL on Jul 14 2022 09:12 AM
The 30th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site...
4,040

ODBC Driver 17.10 for SQL Server Released

David-Engel on Jul 13 2022 01:20 PM
Version 17.10 of the Microsoft ODBC Driver for SQL Server has been released. Version 17.10 includes a few minor changes ...
2,018

How to enable and run SQL best practices assessments on multiple SQL Servers on Azure VMs

EbruErsan on Jul 07 2022 07:02 AM
If you have more than a handful of SQL Servers on Azure VMs, you probably want to automate both the one-time operations ...
1,490

Released: SCOM Management Packs for SQL Server, RS, AS (7.0.38.0)

EbruErsan on Jul 01 2022 01:25 AM
Updates to SQL Server, Reporting Services, and Analysis Services Management Packs are available (7.0.38.0). You can down...
908

Early technical preview of JDBC Driver 11.1.2 for SQL Server released

David-Engel on Jun 23 2022 11:00 AM
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several additions and ch...

Latest Comments

amvin87
in AD(Active Directory) authentication for SQL Containers on Azure Kubernetes Service (AKS) on Sep 30 2022 06:36 AM
Hi Tom, Yes, that was a typo the 2nd command should have been different. Thank you for pointing this out. I have updated the blog with the right command. which are: adutil keytab createauto -k ~/container/mssql.keytab -p 1433 -H sqlinst1-0.contoso.com --password 'P@ssw0rd!' -s MSSQLSvcadutil keytab ...
0 Likes
TomPester
in AD(Active Directory) authentication for SQL Containers on Azure Kubernetes Service (AKS) on Sep 30 2022 02:02 AM
Cc @amvin87 
0 Likes
TomPester
in AD(Active Directory) authentication for SQL Containers on Azure Kubernetes Service (AKS) on Sep 30 2022 02:01 AM
Hi,Is this a typo in the blog? "We are now ready to create the keytab using the commands listed below:adutil keytab createauto -k ~/container/mssql.keytab -p 1433 -H sqlinst1-0.contoso.com --password 'P@ssw0rd!' -s MSSQLSvcadutil keytab createauto -k ~/container/mssql.keytab -p 1433 -H sqlinst1-0.co...
0 Likes
TomPester
in AD(Active Directory) authentication for SQL Containers on Azure Kubernetes Service (AKS) on Sep 28 2022 08:00 AM
Hello @amvin87 We are getting closer after 2 days :)We now get the following error and are stuck and it's not mentioned inhttps://learn.microsoft.com/en-us/sql/linux/sql-server-linux-ad-auth-troubleshooting?view=sql-server-linux-ver15 09/28/2022 14:42:28.814184419 Error [security.ldap] <0000000041/0...
0 Likes
SQLDBA2021
in Defragmenting Indexes on Sep 27 2022 10:00 AM
This article was extremely helpful. Thank you for sharing. I did have a question about your select query. It returns just about everything I receive from the SQL index fragmentation report, but I see several items in the index_name that have NULL values for some reason after running the query. I che...
0 Likes