T-SQL
How to check if a SQL Server Agent job is running
I was getting an error that "SQLServerAgent Error: Request to run job <…
Read more
Forms Based Authentication in SharePoint 2013
Download a data file from a Claims based authentication SharePoint 2010 or SharePoint 2013 site programmatically using C# programming language.
It was required to download few data files from a SharePoint site which is us…
Read more
SSIS - How To Load Multiple Files ( .txt or .csv or .excel ) To a Table in SQL server ?
Overview Data upload from multiple files formats into one destination table …
Read more
How to create a new SSIS Package using SQL Server Business Intelligence?
Overview In this section we will talk about creating a new SSIS package from …
Read more
Implementing Registry entry configuration in SQL Server Integration Services
Scenario - Registry entry configuration is used very rarely. In my experienc…
Read more
Implementing Parent package configuration in SQL Server Integration Services
Scenario - Parent package configuration is very useful when it is required to…
Read more
Implementing SQL server package configuration in SQL Server Integration Services
Scenario - There are several ways to implement configuration in SQL Server In…
Read more
How to remove extra white space from the right side of the report page in SQL Server Reporting Services ?
In one of my SSRS support application, It was required to remove one column fr…
Read more
SQL Server Important and common interview queries
Question 2: Using CTE, how to write a recursive query which will define the or…
Read more
