Blog Home Page - Page 193 of 828 - SQL Authority with Pinal Dave

Jul27

SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLDB’ is Full Due to ‘DATABASE_MIRRORING’

SQL Error Messages, SQL High Availability, SQL Mirroring, SQL Scripts, SQL Server

It is interesting to see in SQL Server that same error message is raised due to multiple reasons. One such error is 9002. In this blog, we would quickly learn about the cause of error 9002: The transaction log for database ‘SQLDB’ is full due to ‘DATABASE_MIRRORING’

Jul26

SQL SERVER – Observation: ROWLOCK Hint and Slow Performance

Pinal Dave

SQL Performance

Query Hint, SQL Scripts, SQL Server

During my recent Comprehensive Database Performance Health Check Developer showed me a slow query which used ROWLOCK hint. The common understanding is that with the help of ROWLOCK hint SQL Server only locks a single row which eventually leads to performance but in their case, it was actually very much opposite. Let us see this scenario with a simple example.

Jul25

Fun Video – Real World Performance Solutions by Bert

Pinal Dave

SQL Video

Brent Ozar, SQL Performance, SQL Training

No Comments

Today, I am very happy to share a fun video about class Real World Performance Solutions. I was very fortunate that I got the opportunity to build this video with Bert Wagner. He is truly a talented SQL Server expert and amazingly creative with the videos. I have never seen in my life anyone so versatile with creative with educational videos.

Jul24

SQL SERVER – How to Listen on Multiple TCP Ports in SQL Server?

Pinal Dave

SQL Tips and Tricks

Computer Network, SQL Server, SQL Server Configuration, Starting SQL

During my recent engagement of Comprehensive Database Performance Health Check, Sr. DBA asked if it is possible to run SQL Server on multiple TCP Ports. The answer is Yes, it is very much possible.

Jul23

SQL SERVER – Quick Introduction to Startup Procedures

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Stored Procedure, Starting SQL

In today’s blog we are going to talk about the SQL Server feature which actually exists for a quite a while but interestingly enough it is not known much. Let us have a quick introduction to startup procedures.

Jul22

How Old Version of SQL Server Running on Server? – Interview Question of the Week #183

Pinal Dave

SQL Interview Questions and Answers

SQL Patch, SQL Scripts, SQL Server

No Comments

Question: How Old Version of SQL Server Running on Server?

Jul21

SQL SERVER – Install Error: Validation for Setting ‘AGTSVCACCOUNT’ Failed. Error Message: The RPC Server is Unavailable

Pinal Dave

SQL

Computer Network, SQL Error Messages, SQL Server, SQL Server Installation

During my consultancy engagement, my client’s DBA team was installing SQL Server and getting an error. Since they know my work style, I got pulled into fixing that issue. In this blog, we would learn how to fix SQL installation error: Validation for setting ‘AGTSVCACCOUNT’ failed. Error message: The RPC server is unavailable.

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 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 100 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.

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.