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

Jul15

How to Convert Hex Windows Error Codes to the Meaningful Error Message – 0x80040002 and 0x80040005 and others? – Interview Question of the Week #182

SQL Error Messages, SQL Server, SQL Server Security

This blog is not specific to SQL Server, but I have recently seen hex error codes in SQL Server ERRORLOG and it took me little time to get the meaning of it. In this blog, we would learn about how to convert a hex windows error codes to meaningful error messages.

Jul14

SQL SERVER – Execution Plan Ignores Tabs, Spaces and Comments

Pinal Dave

SQL Tips and Tricks

Execution Plan, SQL Scripts, SQL Server, SQL Stored Procedure

No Comments

Just another day I was delivering my training SQL Server Performance Tuning Practical Workshop, I noticed that organizations had many stored procedures but none of the SP had any comments. When I asked them why their Stored Procedures does not have comments, their point was that they believed because of the comments, the size of the execution plan increases. Not True, when SQL Server builds an execution plan, it ignores tabs, spaces, and all the comments.

Jul13

SQL SERVER – Puzzle – Why Such a Complicated Execution Plan for a Single Row, Single Table Query?

Pinal Dave

SQL Puzzle

Execution Plan, SQL Scripts, SQL Server

It has been awhile since I asked any puzzle on SQLAuthority.com, Let us see a very simple puzzle today which involves execution plan as well.

Jul12

Scalability and Availability Challenges and Shareplex Solutions

If you ask any DBA in the world about their wildest dream, they will always say that want to manage a huge database platform which is scalable whenever it needs to and available always. If you are a DBA, you will agree with the statement. Every DBA who is going home after a day-long work only dreams that a) he does not have to wake up mid-night and b) the first task next day is not to worry about the capacity of the server. Let us learn about Scalability and Availability Challenges and Shareplex Solutions.

Jul11

Practical Real World Performance Tuning – Class Preparation and Setup

Pinal Dave

SQL Performance

Brent Ozar, SQL Training

This blog post is a follow-up a blog post in the series of the blog post I am writing for my most popular online class Practical Real World Performance Tuning with Brent Ozar. In this blog post, we will discuss how do I do class preparation and setup.

Jul10

SQL SERVER – Event ID:7034 – MSSQLSERVER Service Terminated Unexpectedly. It has Done this 6 time(s)

Pinal Dave

SQL

SQL Error Messages, SQL Log, Starting SQL

Recently, I came across a strange issue. I noticed that the SQL Server service terminates and restarts automatically and doesn’t restart.

Jul9

SQL SERVER – Backup to URL – Script to Generate the Create Credential and Backup Command using Access Keys

Pinal Dave

SQL

SQL Azure, SQL Backup, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security

Backup to URL is one of the common methods used in SQL Server perform backup to Azure Blob Storage. In this blog, I am going to share a script to generate the create credential and backup command using access keys.

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.