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

Jun29

SQL SERVER – Automatic Seeding of Availability Database ‘SQLAGDB’ in Availability Group ‘AG’ Failed With a Transient Error. The Operation Will be Retried

AlwaysOn, SQL High Availability, SQL Scripts, SQL Server

Earlier I have written few blogs about automatic seeding feature. In this blog we would learn how to fix error: Automatic seeding of availability database.

Jun28

SQL SERVER – Add Database to Availability Group Failure – This BACKUP or RESTORE Command is Not Supported on a Database Mirror or Secondary Replica

Pinal Dave

SQL

AlwaysOn, SQL Backup, SQL Error Messages, SQL High Availability, SQL Restore, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

In this blog post, we will fix the error related to This BACKUP or RESTORE command is not supported on a database mirror or secondary replica.

Jun27

SQL SERVER – Different Size of COPY_ONLY Full Backup on Primary and Secondary Replica in Always On

Pinal Dave

SQL Tips and Tricks

AlwaysOn, SQL Backup, SQL High Availability, SQL Scripts, SQL Server

No Comments

We will learn how the full backup size can be different on the primary and secondary replica for an availability database in Always On availability group.

Jun26

SQL SERVER – SUSPENDED Sessions Waiting on PAGELATCH_UP and PAGELATCH_SH – Solution

Pinal Dave

SQL Performance

SQL FileGroup, SQL Memory, SQL Server, SQL TempDB, SQL Wait Stats

Their server got tremendously slow with many sessions suspending in the status of SUSPENDED status and they were waiting on PAGELATCH_UP and PAGELATCH_SH.

Jun25

SQL SERVER – Getting Started with DBCC FLUSHAUTHCACHE on SQL Azure

Pinal Dave

SQL Tips and Tricks

SQL Azure, , SQL Scripts, SQL Server, SQL Server Security

No Comments

First thing first – the command DBCC FLUSHAUTHCACHE only is supported on SQL Azure. The behavior of change of password is a bit different on SQL Azure.

Jun24

SQL Saturday Prague 2019 – Pre-Con: 21 Essential Scripts: Performance Tuning for EVERYONE

Pinal Dave

SQLAuthority News

SQL Saturday, SQL Training

No Comments

I will be visiting SQL Saturday Prague 2019 and will be presenting my most popular pre-conference on September 20, 2019, at 9:00.

Jun23

What are the Different Types of SQL Server CHECKPOINT? – Interview Question of the Week #230

Pinal Dave

SQL Interview Questions and Answers

Question: What are the Different Types of SQL Server CHECKPOINT?

Answer: There are four different kinds of checkpoints 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.