Blog Home Page - Page 155 of 831 - SQL Authority with Pinal Dave

May4

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

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.

May3

SQL SERVER 2008 R2 – I Support You Beyond July 9 2019

Pinal Dave

SQL Performance

SQL Server 2008 R2, Support

No Comments

One of my clients is primarily using SQL Server 2008 R2 for most of their application. SQL SERVER 2008 R2 – I Support You Beyond July 9 2019

May2

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

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.

May1

Recorded Class Instant Learning – SQL Server Performance Tuning Practical Workshop

Pinal Dave

SQLAuthority News

Instant Learning, SQL Training, Webinar, Workshop

No Comments

There is a huge demand for this workshop as it contains around 3 hours and 49 minutes of unique recorded content which is considered as absolutely Trade Secret for SQL Server Performance Tuning Consultant.

Apr30

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

Pinal Dave

SQL Video

SQL Performance, SQL Server

No Comments

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.

Apr29

Download SQL Server Management Studio 18.0 (General Availability)

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.

Apr28

How I Know If I am DBOWNER or Not in SQL Server? – Interview Question of the Week #222

Pinal Dave

SQL Interview Questions and Answers

SQL Scripts, SQL Server, SQL Server Security

No Comments

Question: How I Know If I am DBOWNER or Not in SQL Server?

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 109 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.