Overview of SQL Server BI Model
SQL Server Business Intelligence Model basically consists of four main services i.e. SQL Server Relational services, Integration Services, Analysis Services…
Month: August 2013
How to get the DDMMYYYYHHMMSSMMM and YYYYMMDDHHMMSSMMM date formats in SQL Server.
Below are the SQL statements by which we can get the required formats: DDMMYYYYHHMMSSMMM format : SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(),…
How to store and retrieve the Image data directly from SQL Server Table
1. Background The purpose of this article is to describe a way of storing the Image data into SQL Server…
How to script all the SQL Agent Jobs in a single script file
Background The purpose of this article is to provide a way of scripting out all the SQL Agent jobs in…
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…
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…