How to Write Stored Procedures for Professional SSRS Reports

Business intelligence, Database development, SSRS, Stored Procedures

In this article, we’ll talk about professional SQL Server Reporting Services reports, how to...
Read More

Calculate the median by using Transact SQL

Languages & Coding, T-SQL

The statistical median is the value which separates a dataset into halves – one comprises greater values, and the other comprises...
Read More

Everything you Need to Know about Database Normalization

Database administration, Database Optimization & Structure

The Relational Model of data management was first developed by Dr. Edgar F. Codd in 1969. Modern relational database management systems...
Read More

.NET – Tools for working with multithreading and asynchrony – Part 2

ASP .NET CORE, Languages & Coding, Tools & technologies

This article comprises the second part of my speech at the multithreading meetup. You can have a...
Read More

Understanding SQL Server Always Encrypted

Database administration, Security

Security is one of the most important requirements for a data-driven system. Encryption is one of the ways to secure the data. Wikipedia...
Read More

Update SQL Server statistics using a database maintenance plan

Database administration, Database Optimization & Structure

Database backups, integrity checks, and performance optimizations are core regular tasks of DBAs. The client data is very important for a...
Read More

Creating Customer-Focused SSRS Reports with Parameters

Business intelligence, SSRS

This article talks about how to create a basic customer-focused report using SQL Server Reporting...
Read More

How to Document Your SQL Server Database

Database development, Visual Studio

The process of documenting a SQL Server database is a complete and continuous process that should start during the database design and...
Read More

Parameter Sniffing Primer

Database development, Stored Procedures

Introduction Developers are often told to use stored procedures in order to avoid the so-called ad hoc queries which can result in...
Read More

Auto Create Statistics and Auto Update Statistics

Languages & Coding, SSMS, T-SQL, Tools & technologies

Statistics comprises lightweight objects that are used by SQL Server Query optimizer to determine...
Read More
Close