How to Write Stored Procedures for Professional SSRS Reports
In this article, we’ll talk about professional SQL Server Reporting Services reports, how to...
Calculate the median by using Transact SQL
The statistical median is the value which separates a dataset into halves – one comprises greater values, and the other 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...
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. 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...
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 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...