April 22, 2024

SQL SERVER: Seamless Migration: On-Premise Report Server to Azure SQL Managed Instance

›
Recently, we got request from client to migrate their SQL Srrver Reports Server. We have analyzed and review that, they are actively using D...
November 17, 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 crea...

SQL Server Reporting Services, List out all the data sources with Report Name and Path

›
In Enterprise application, we can have many reports hosted. Sometimes there are few customized reports too. Over period of time, there may...
August 14, 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.   Recursi...
June 1, 2015

SQL Server, avoid encoding special character when using FOR XML PATH

›
From SQL 2005, we are using FOR XML PATH('') for the string concatenation. I have also mentioned the same in very old blog: Generat...
April 4, 2015

SQL SERVER: Find Current Location of Log File(s) with File Size of All the Database

›
As we are mostly engaged in SQL Assignments, we come to the place where we found that there are lots of ldf files which occupies lots of t...
1 comment:
September 4, 2014

SQL SERVER: SSIS - Rename and move files from source folder to destination folder

›
With SSIS, most of the time we need to process all the files from the folder. Once file has been processed, we need to move the file to ...
3 comments:
September 1, 2014

SQL SERVER: SSIS - Conditional Split Data Flow Transformation Task

›
Conditional Split transform use split the source row in easy to multiple groups in data flow and which Destination table populated. Lets...
August 6, 2014

SQL SERVER: Clone SSIS Package

›
Recently, I was assigned a job to create many DTSX packages. When I review the packages, I found those packages (Information flow) are mo...
June 14, 2014

SQL Yoga : Certificate Expired, Mirroring Stopped

›
Database Administrators might face this issue while certificate gets expired and database mirroring (Non domain database mirroring) gets...
1 comment: