How to enable xp_cmdshell in SQL Server
Xp_cmdshell is an extended stored procedure that provides an environment analogous to a Windows command shell and passes in a…
Category: SQL Server
T-SQL script to get list of all the tables having triggers in a database with trigger name.
Approach: Sys.objects table contains information about all the objects of a database We are filtering the trigger objects with TYPE…
How to process OLAP Cube using SQL Server Agent Job
1. Background The purpose of this document is to describe a way of processing OLAP cube using SQL Server Agent…
How to create Connection String using Notepad
1. Background The purpose of this document is to describe how to create connection string for OLE DB provider and…
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…
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 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…
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.…
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 – How to remove HTML tags from data
1. Background The purpose of this article is to provide a way of cleaning up of HTML tags within the…