SQL Server Archives - Page 98 of 347 - SQL Authority with Pinal Dave

SQL SERVER – Error: 9642 – An error occurred in a Service Broker/Database Mirroring transport connection endpoint

May 4, 2019

SQL Backup, SQL Error Messages, SQL High Availability, SQL Server

During my consultancy engagement, my client’s DBA team was checked ERRORLOG and asked me the possible cause of below error about service broker.

SQL SERVER – Global Variable @@DEF_SORTORDER_ID – Old and May be Deprecated

May 2, 2019

Pinal Dave

SQL Tips and Tricks

SQL Collation, SQL Deprecated Feature, SQL Scripts, SQL Server

I always blog about things which are new and updated but today we are going to write about something which is very old and it is near deprecated. We are going to about the global variable @@DEF_SORTORDER_ID. Let us see what it is and how it was used once.

DBA Fundamentals – 3 Performance Tuning Tricks you Always Wanted to Know

April 30, 2019

Pinal Dave

SQL Video

SQL Performance, SQL Server

Today we will see a free online video which I did for DBA Fundamentals Virtual Chapters for PASS. The title of the video is 3 Performance Tuning Tricks you Always Wanted to Know.

Download SQL Server Management Studio 18.0 (General Availability)

April 29, 2019

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Management Studio, SSMS

I am really happy that Microsoft has finally announced the general availability of SQL Server Management Studio 18.0. It is the latest version of SSMS available and it works flawlessly with SQL Server 2019 and earlier versions of SQL Server.