Calculate the median by using Transact SQL
The statistical median is the value which separates a dataset into halves – one comprises...
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 relational database management systems...
.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...
Update SQL Server statistics using a database maintenance plan
Database backups, integrity checks, and performance optimizations are core regular tasks of DBAs. The client data is very important for a...
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...
Parameter Sniffing Primer
Introduction Developers are often told to use stored procedures in order to avoid the so-called ad hoc queries which can result in...
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...
