How to Properly Use the T-SQL IsNumeric Function
This article is focused on the T-SQL (Transact-SQL) IsNumeric function and its proper use in...
Advanced SQL: Variations and Different Use cases of T-SQL Insert Statement
In my previous article, I demonstrated: Insert the output of the table-valued function in the SQL table. Insert the output of the...
.NET: Tools for working with multi-threading and asynchrony – Part 1
The need to do things in an asynchronous way – that is, dividing big tasks between multiple working units – was present long before the...
How to Automate the Process of SQL Server Database Schema Synchronization
The goal Keeping two databases in sync is a task we often encounter when working on SQL database...
Basic and Complex Uses of Not Equal Comparison Operator in T-SQL
This article is focused on the T-SQL Not Equal comparison operator (<>) and its uses in basic to slightly complicated SQL scripting...
T-SQL SET Operators Part 1: UNION and UNION ALL
In SQL Server, we can combine the same type of data from multiple tables using SET operators. After combining multiple SQL statements, it...
Automatic gathering of SQL Server configuration by using PowerShell
At present, the gathering of SQL Server configuration information is no longer a problem— the...
How to use SQL Cursors for Special Purposes
This article describes SQL cursors and how to use them for some special purposes. It highlights the importance of SQL cursors along with...
Concatenation in Transact-SQL
Introduction Assuming you maintain a table containing customer data, and your boss asks you to send him the current list of customers and...
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...
