Configuring Database Mail Notifications in MS SQL Server
Introduction Often, there is a need to somehow inform administrators about the problems with a...
Synchronizing database structure between applications
Anyone who has ever developed applications that use a database has probably faced the problem of updating the database structure when the...
Understanding Dirty Read Problem with SQL Server
One of the most common problems that occur while running concurrent transactions is the Dirty Read problem. A dirty read occurs when one...
More about Introduction of Time zones in long-lived Project
Some time ago, we started to adapt the system to the new market that requires support for time...
Key Indicators of Problem Design
The concept of good or bad design is relative. At the same time, there are some programming standards, which in most cases guarantee...
Transparent Data Encryption and Always Encrypted
If you need to store confidential data in your database, you can use data encryption. SQL Server supports encryption with symmetric keys,...
Why Multiple JOINs are bad for Query or Do Not Get in the Way of Optimizer
Recently, I came across an application that generated DB queries. I understand that there is...
USE HINT and DISABLE_OPTIMIZED_NESTED_LOOP
One of the available algorithms to join two tables together in SQL Server is Nested Loops. The nested loops join uses one join input as the...
SQL Server Security Ponderings
DBA is the guardian of the data, and there are two aspects of being a guardian. The first one is integrity. It includes tasks like checking...
SQL Server: The dark side of NVARCHAR
Introduction In this article, we are going to talk about using the nvarchar data type. We will...
