Performance of Table Variables in SQL Server
In this article, we are going to touch upon the topic of performance of table variables. In SQL...
Understanding Pivot Operator in SQL
The pivot operator in SQL Server converts each row in the aggregated result set into corresponding columns in the output set. The pivot...
Query Optimization in PostgreSQL. EXPLAIN Basics – Part 3
I continue a series of articles on the basics of EXPLAIN in PostgreSQL, which is a short review of Understanding EXPLAIN by Guillaume...
Sending a Query to All Databases of All Specified Servers in MS SQL Server and C#.NET
Often, it is necessary to send a query to all databases of all specified servers. Many DML-queries...
How to Analyze Activity of One Database in SQL Server
Using one SQL Server instance for many projects is not unusual. However, defining the most active project may be quite difficult. Today, I...
Using Expressions to Filter Data of Database
I would like to start with a description of the problem that I encountered. There are entities in the database that need to be...
What dangers can the update of .Net 4.6.1 to .Net 4.6.2 hide?
In this article, I would like to share a solution of unexpected problem occurred in one of the...
Query Optimization in PostgreSQL. EXPLAIN Basics – Part 2
In my previous article, we started to describe the basics of the EXPLAIN command and analyzed what happens in PostgreSQL when executing a...
Comparison of 6 Best Dependency Injection (DI) Inversion of Control (IoC) Containers
I have often questioned myself which IoC container would be suitable for this or that project best. Their performance is only one side of...
How Simple Is It to Move Data from Excel to SQL Server?
What could be simpler than to get data from an Excel table in SQL Server? There are many ways to...
