Blog Home Page - Page 129 of 830 - SQL Authority with Pinal Dave

The year 2019 has been wonderful for me as I was fortunate to publish 2 SQL Server Courses on Pluralsight. SQL Server Performance Tuning Focused Courses.

Oct23

SQL SERVER – Group By Orders Data by Columns Ascending

Pinal Dave

SQL Tips and Tricks

SQL Group By, SQL Order By, SQL Scripts, SQL Server

The question was about Group By Orders Data by Columns Ascending. DBA asked me an interesting question referring to my older blog.

Oct22

SQL SERVER – Upgrade Error: The Specified Service Does Not Exist as an Installed Service

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server, SQL Server Installation, SQL Upgrade, Starting SQL

No Comments

During an upgrade, as soon as they enter the product key and hit next, setup was failing with an upgrade error. Let us learn how to fix the error.

SQL SERVER – Find All Servers From Local Network – Using sqlcmd – Detect Installed SQL Server on Network

SQL SERVER - 2008 - Location of Activity Monitor - Where is SQL Serve Activity Monitor Located PinalAtWork

SQLAuthority News – 900th Article – 9 Best Practices – Important Milestones

SQL SERVER – AWE (Address Windowing Extensions) Explained in Simple Words

SQL SERVER – 2008 – Optimize for Ad hoc Workloads – Advance Performance Optimization

SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users

SQL SERVER – 2008 – Location of Activity Monitor – Where is SQL Serve Activity Monitor Located

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 104 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.

May 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Getting Second Row from Table

Why Query Store Actual Operation Mode is Not Same as Requested? – Interview Question of the Week #248

SQL SERVER – Identifying Query Generating Malicious Wait Type

SQL SERVER – Upgrade Rule Failure Error: No Custom Security Extensions

SQL SERVER – 2 SQL Server Courses on Pluralsight