Blog

Search results for: Report Server

SQL Server, T-SQL create Linked Server with Azure SQL Database

11-Nov-2017

SQL Server, T-SQL create Linked Server with Azure SQL Database

Today, we got a requirement to connect our Azure VM SQL (Report server) instance to access the Azure Database. Let me show you how create linked server for SQL Database on Azure from Azure VM SQL instance.

SQL Server: Use of Recursive Query with example

12-Aug-2015

SQL Server: Use of Recursive Query with example

One of the most benefit of CTE (Common Table Expressions) is that we can create recursive queries with them.