This provides the fundamentals of the SQL-API and covers the general concepts using the SQL-API

In this article I will describe how to change a default value for selecting and editing N rows in SQL Server 2012.

This article describes how to uninstall a SQL Server instance in SQL Server 2008R2 and 2008.

This article gives an overview of Conditional split transformation in SSIS. This is used to route data rows to various outputs based on conditions. This is similar to a case statement in programmin...

This article explains the Foreach File enumerator functionality of SSIS for each loop container.

This article describes how to restore a SQL Server backup using one of multiple methods using Transact-SQL.

This article describes SQL Server database transaction LOG backups and how to take a SQL Server database transaction LOG backup with multiple methods using Transact-SQL.

Here you will find how can we use the COALESCE keyword in SQL Server.

This article describes SQL Server database backups and how to take a SQL Server database backup with multiple methods using Transact-SQL.

In this article I will explain how to track the user that dropped/deleted TSQL on SQL Server Objects.

In this article I will explain how to change an instance name using a SQL Server alias.

This article explains Transact-SQL Programming in SQL Server.

This article explains the Replace function in SQL Server. It also provides a brief description of the differences between the Replace and Stuff functions.

This article explains the dense rank function in SQL Server.

This article explains User Defined Functions in SQL Server.

This article shows how to make a Dedicated Administrator Connection (DAC) to allow administrators emergency access to SQL Server via SQL Server Management Studio (SSMS) or via command prompt (SQLCM...

This article explains views in SQL Server.

This article explains QueryNotification and SQLCacheDependency in SQL Server.

This article explains Union and Union All in SQL Server.

Set operators are used to combine results from two or more SELECT statements.