Concatenation in Transact-SQL
Introduction Assuming you maintain a table containing customer data, and your boss asks you to send...
Transferring Jobs and Schedules between Instances using T-SQL
Introduction Quite often, there is a need to transfer Agent jobs to a different instance of MS SQL Server. Restoring a msdb database will...
Basics of Running T-SQL Statements from Command Line using SQLCMD
This article is about developing a basic understanding of sqlcmd utility to run T-SQL commands directly from the command prompt without the...
How to Write T-SQL Queries Like a Pro
The skills of writing different types of SQL Server queries require you to have good knowledge in...
Traditional and Natively Compiled Scalar-Valued User-Defined Functions
In the software programming world, there are several approaches used by developers that help them with effortless software development....
T-SQL BEST Practices
In this article, we will discover some best practices of T-SQL queries. Badly written queries can cause performance and I/O problems. For...
Functional F# that slowly appears in C#
For some reason, we often do not use this functionality. Maybe we haven’t got used to it yet. And...
Resource Release in .NET Applications
In C#, there is one huge benefit, which is a drawback at the same time – an automatic garbage collection. With traditional desktop...
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....
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...
