Author: Bhagwan Singh Jatav

Recently I got a requirement to export error data to a newly created excel file every time the SQL Server Integration Services package runs. The challenge here was to create new excel …

SQL Server Integration Services 2012 – Create New Excel File Dynamically to Export Data Read More

SQL Server Best Practices – Series 5 1.6 Testing SQL 1.6.1 Key SQL Key SQL should always be tested on high volume data. If you have no idea what high volume is …

SQL Server Best Practices – Series 5 Read More

SQL Server Best Practices – Series 4 1.5 Preventing SQL Injection Attacks 1.5.1 Explanation of the problem Here is an excerpt from Microsoft documentation that neatly explains this problem: A SQL injection attack …

SQL Server Best Practices – Series 4 Read More

Steps to access LDAP information in SQL server.  1. SQL Commands for Creating linked Server   EXEC master.dbo.sp_addlinkedserver @server = N’ADSI’, @srvproduct=N’Directory Services’, @provider=N’ADsDSOObject’ EXEC master.dbo.sp_addlinkedsrvlogin  @rmtsrvname=N’ADSI’, @useself=N’False’, @locallogin=NULL, @rmtuser=N’ Domain\UserName’, …

SQL Server 2005 – Get LDAP (Lightweight Directory Access Protocol) Informtion Read More

SQL Server Best Practices – Series 3 1.4 SELECT Queries 1.4.1 Joins Always use ANSI join syntax instead of the old Transact-SQL style. This is faster to execute, does not have problems with …

SQL Server Best Practices – Series 3 Read More

SQL Server Best Practices – Series 2 1.3 Cursors The use of cursors is often the single biggest cause of slow stored procedures, and is a major cause of transaction blocking and …

SQL Server Best Practices – Series 2 Read More

SQL Server Best Practices – Series 1 1.1 Table Design The ideal table design for efficiency is to have one long integer ID column in every table acting as the primary …

SQL Server Best Practices – Series 1 Read More