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...
Scheduled Maintenance of the 24/7 IS Database in MS SQL Server
Introduction This article is a short review of the main scheduled maintenance with a database of the 24/7 information system that does not...
Tips for Read/Write Locks Depending on Transaction Isolation Level in MSSQL
Read Uncommitted If data is being changed in one transaction, selection of this data (in other transaction or without a transaction) will...
Automatic Data Collection: Database Files and Logical Drives in MS SQL Server
Introduction It is important for a database administrator to know when there is no space on a disk....
