Counting references to a record in a table via Foreign Keys
I have recently needed to solve the task for my own purpose: to calculate the number of external...
Configuring Database Mail Notifications in MS SQL Server
Introduction Often, there is a need to somehow inform administrators about the problems with a server. Notifications are generally divided...
Synchronizing database structure between applications
Anyone who has ever developed applications that use a database has probably faced the problem of updating the database structure when the...
Understanding Dirty Read Problem with SQL Server
One of the most common problems that occur while running concurrent transactions is the Dirty Read...
Implementing OOP Inheritance in Classes that work with SQL and Entity Framework
This article is about creating a data model that would nicely fit SQL and contain “proper” OOP inheritance. I must say that I...
More about Introduction of Time zones in long-lived Project
Some time ago, we started to adapt the system to the new market that requires support for time zones. Initial research was described in the...
Introducing Common Table Expressions in SQL Server
Common Table Expressions, or CTE for short, is simply a technique to create a temporary set of...
Working with SQL Server in Hybrid Cloud Scenarios
A hybrid cloud is a fairly attractive model when implementing cloud computing in enterprise information systems, as this approach combines...
Execute Powershell in SSIS Using C#
Introduction PowerShell is a Shell included in Windows to automate tasks in the operative system and other applications like SQL Server,...
Transparent Data Encryption and Always Encrypted
If you need to store confidential data in your database, you can use data encryption. SQL Server...