October 2012 – SQL Circuit

Database Migration from SQL Server 2000 to 2008/2008 R2/2012

1. Background: The purpose of this article is to lay out the structure for database migration from SQL 2000/2005 to…

1. Background This article describes how to set the orientation of text box in a report using SSRS 2008 R2/2012.…

String functions perform an operation on an input string and return a string or numeric value: 1) ASCII (character_expression): Returns…

Questions with Single correct answer 1) What is the name of main repository DB of Reporting service? a) ReportingDB b) …

1. Background This article describes how to add Images in the report. Many times, Report needs some special symbols or…

1. Background This article describes how to implement Gauge data region in the report. Many Dashboard and Score Card reports…

1. Background The purpose of this article is to provide a way of implementing Email subscription for a report using…

1. Background This article describes how to convert the row data into single comma separated string. While developing software application,…

1. Background The basic aim of this article is to describe a way of sending email notification whenever insufficient disk…

1. Background The purpose of this article is to describe implementation of database mail configuration in SQL Server so that…

1. Background The purpose of this article is to describe how to create a file share subscription for a report…

Background The purpose of this article is to provide a step-by-step method of creating a linked server that point to…