Category: Database

SQL SERVER – Simple Explanation FORCE DEFAULT CARDINALITY ESTIMATION

I enjoy learning new things every single day and I must express my gratitude to all of you for helping me learn new things. One of my client Comprehensive Database Performance Health Check recently asked me if I can help them understand how FORCE DEFAULT CARDINALITY ESTIMATION works as during the consulting engagement we applied …


Backup compression in TDE enabled databases in SQL Server Always On Availability Groups

In the previous article, Transparent Data Encryption for SQL Server Always On Availability Groups, we discussed enabling TDE for the existing database in AG. In this article, we will explore options for a compressed backup of a TDE database. Introduction TDE protects the physical database, log, backup files using the IO encryptions. It uses the …


What is Temp Stored Procedures? – Interview Question of the Week #294

Question: What is Temp Stored Procedures? Answer: Temp stored procedures are kind of the stored procedures that are created with the help of the # at the beginning of the name and only available until the SQL Server restarts. When I go for SQL Server Performance Tuning Comprehensive Database Performance Health Check, one of the …


How to prepare for the Exam DP-200: Implementing an Azure Data Solution

In this article, we will show how to prepare yourself for one of the important Microsoft Azure exams, DP-200: Implementing an Azure Data Solution certificate exam. Exam Overview Implementing an Azure Data Solution certificate exam measures your intermediate-level knowledge in three main areas. This includes: How to implement data storage solutions, with relative questions weight …


SQL SERVER – Running Log Backup While Taking Full Backup

Recently, I got a very interesting question from my client of the Comprehensive Database Performance Health Check. As many of you know that I primarily focus on the SQL Server Performance issue. If your server is running slow, I would like to help it to run faster. My client recently noticed that their server was …


Learn MySQL: Delete and Update Statements

In this article, we are going to learn how we can update and delete data using Delete and Update statements. In my previous articles, we have learned how we can insert data using INSERT statement, and sort and filter data using WHERE and ORDER BY statements. To demonstrate UPDATE and DELETE statements, I have restored …


25 Recent SQL in Sixty Seconds Video

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 35 Pluralsight courses and has written over 5200 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 17+ years of hands-on experience, he holds a Masters of Science degree and …


Impact of dropping a login in the active directory tied to SQL Server Always On Availability Groups

This article explores the impact of dropping a login in the active directory if that owns a HADR endpoint and SQL Server Always On Availability Groups. It is the 23rd article in the SQL Server Always On Availability Group. Introduction Database security is a critical aspect, and it protects you from compromising integrity, availability, and …


SQL SERVER – Delete Statement and Index Usage

Recently I had a very interesting conversation with my client about Comprehensive Database Performance Health Check. The client wanted to know if the index help with the DELETE command as well. The answer is yes, Indexes do help with the DELETE statement. Let us see a simple example of the SELECT command and its execution …


Backup SQL databases on the AWS S3 bucket using Windows PowerShell

In this article, we will explore taking backups of native SQL databases into the AWS S3 bucket. Introduction Database backups are critical for database availability in case of any accidents. You might require these backups in case of any instance crash scenario, data deletion in the production environment. As it is essential to define your …