Understanding Pivot Operator in SQL
The pivot operator in SQL Server converts each row in the aggregated result set into corresponding...
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 can be created with built-in tools....
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...
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 projects I am currently working on. What...
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...
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 accomplish this task. You can utilize...
Upload Documents to Azure Data Lake and Export Data using SSIS
Introduction Azure is growing every day. Microsoft created Azure, which is a Cloud Computing...
