Search results for: Report Server
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.
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.
