Everything you Need to Know about Database Normalization
The Relational Model of data management was first developed by Dr. Edgar F. Codd in 1969. Modern...
.NET – Tools for working with multithreading and asynchrony – Part 2
This article comprises the second part of my speech at the multithreading meetup. You can have a look at the first part here. In the first...
Understanding SQL Server Always Encrypted
Security is one of the most important requirements for a data-driven system. Encryption is one of the ways to secure the data. Wikipedia...
Update SQL Server statistics using a database maintenance plan
Database backups, integrity checks, and performance optimizations are core regular tasks of DBAs....
Creating Customer-Focused SSRS Reports with Parameters
This article talks about how to create a basic customer-focused report using SQL Server Reporting Services (SSRS). The article also...
How to Document Your SQL Server Database
The process of documenting a SQL Server database is a complete and continuous process that should start during the database design and...
Parameter Sniffing Primer
Introduction Developers are often told to use stored procedures in order to avoid the so-called ad...
Auto Create Statistics and Auto Update Statistics
Statistics comprises lightweight objects that are used by SQL Server Query optimizer to determine the optimal way to retrieve data from the...
SSRS Reports Development in Simple Terms
The article is dedicated to the fundamentals of SQL Server Reporting Services (SSRS) development and aimed at beginners and professionals...
Several Ways to Insert Split Delimited Strings in a Column
In this article, I will demonstrate several ways to split the delimited string and insert it in...
