Transparent Data Encryption and Always Encrypted
If you need to store confidential data in your database, you can use data encryption. SQL Server...
SSAS: Attention, Accuracy, and All the Benefits
This article is about working with Microsoft Analysis Services and a little bit about the repository on Microsoft SQL...
Introduction to Temporary Tables in SQL Server
A temporary table in SQL Server, as the name suggests, is a database table that exists temporarily on the database server. A temporary...
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...
CombGuid: Generation of SQL Server-friendly Guid Values in .NET Applications
Usage of UUID as a primary key for tables has a bunch of pros, including the option to retrieve IDs for objects created in a client...
Pitfalls of Linked Server Usage
An interesting project related to the task queue processing come to the company I work for. It was previously developed by another team. We...
Dynamic T-SQL and Benefits of its Usage
In our projects, we have to cope with different tasks. To solve some of them, we use dynamic T-SQL....
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 explore how SQL Server stores this data type...
What Can Query Plan Tell?
Introduction SQL query describes the expected result, not the way to get the result. The set of...
