SQL Server – How to select a row randomly from a table
/************************************************************************* * Title : How to select a row from a table randomly * Solution : We can get the…
Month: August 2013
How to get list of all the failed SQL Agent Jobs in SQL Server
/*************************************************************************** * Title : How to find the list of all the failed SQL Jobs in SQL Server * Problem…
Write a T-SQL script to shrink the Transaction Log file of SQL Server Database
For shrinking the transaction log of any SQL Server database, simply run the below script on that database: USE YourDatabase_Name…
SQL Database Backups using T-SQL
1. Background This article describes and helps the users to take different types of SQL database backups using T-SQL script.…
T-SQL Programing Questions
1) If we have a table with a column named EmailID that contains emailIDs like Ram.sharma@gmail.com Shayam.singh@gmail.com How to get…
Unit Testing of SSRS Reports
1. Background The article describes how we can start the unit testing of SSRS reports. Unit testing helps us in…
SSRS Questions
1) How to implement Stepped-down group in Report? 2) How to use Gauge in the column of the Report to…
SSRS : Case Study for managing information about a mobile user
Objective: Create a report that’s gives complete information about a mobile user and its call history. Report should have a parameter…
SSRS – How to implement alternate background color in rows
1. Background The purpose of this article is to provide a way of showing different color in alternate rows in…
How to add additional Job step in all the existing jobs in an SQL Server instance
1. Background SQL Server Agent Jobs play an important role in the process automation of any application. Apart from Job…
Sample email format showing job failure notification
Background To monitor various automation processes of a system, alert and notification plays an important role that allows Users/Operation/Support team…
SQL Server Data Mining Presentation
Agenda What is Data Mining Data Mining Techniques Data Mining Algorithms Data Mining Architecture What is Data Mining Data Mining…