Log in | Register

Bhagwan Singh Jatav, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Bhagwan Singh Jatav, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

BhagwanSinghJatav

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

About Bhagwan Singh Jatav

This author has not yet filled in any details.
So far Bhagwan Singh Jatav has created 8 entries.

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

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 file with time stamp every time the package ran and export data to that newly created file.

In this post will demonstrate this step […]

By |February 19th, 2013|Categories: SQL Server||6 Comments

SQL Server – Steps to create Integration Services Catalogs and deploy SSIS package in SQL Server 2012 SSISDB

There have been some rather significant changes made to SSIS in SQL Server 2012. One of which is package deployment. In 2005 and 2008, one could easily deploy packages to the MSDB. In 2012, this has been changed. Before you can deploy anything, there has to be an integration services catalog.

Here are the steps […]

By |September 28th, 2012|Categories: SQL Server|Tags: , |8 Comments

SQL Server Best Practices – Series 5

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 for your product, then ask your analyst. If he does not know tell him to find out.

If you are writing the SQL to return all employees […]

By |March 20th, 2012|Categories: SQL Server||0 Comments

SQL Server Best Practices – Series 4

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 exploits vulnerabilities in input validation to run arbitrary commands in the database. It can occur when your application uses input to construct dynamic SQL statements to […]

By |March 20th, 2012|Categories: SQL Server||0 Comments

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

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’,

@rmtpassword=’########’

/* For security reasons the linked server remote logins password is changed with ######## */

EXEC master.dbo.sp_serveroption @server=N’ADSI’,

@optname=N’collation compatible’,

@optvalue=N’false’

GO

EXEC master.dbo.sp_serveroption @server=N’ADSI’,  @optname=N’data access’, @optvalue=N’true’

GO

EXEC master.dbo.sp_serveroption @server=N’ADSI’, @optname=N’dist’, @optvalue=N’false’

GO

EXEC master.dbo.sp_serveroption @server=N’ADSI’, @optname=N’pub’, @optvalue=N’false’

GO

EXEC master.dbo.sp_serveroption @server=N’ADSI’, @optname=N’rpc’, @optvalue=N’false’

GO

EXEC […]

By |March 20th, 2012|Categories: SQL Server||1 Comment

SQL Server Best Practices – Series 3

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 ambiguity, and is directly compatible with Oracle.

Purely as a matter of style, try not to use a right outer join when a left outer join will […]

By |March 19th, 2012|Categories: SQL Server||1 Comment

SQL Server Best Practices – Series 2

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 other scalability issues. It is very important that everyone follow these standards when writing stored procedure code. These standards apply equally well to all DBMSs […]

By |March 19th, 2012|Categories: SQL Server||2 Comments

SQL Server Best Practices – Series 1

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 key. This violates one of the design principles of normalisation, but the speed gain is so huge compared to the purely theoretical disadvantage that it’s […]

By |March 19th, 2012|Categories: SQL Server||0 Comments
Newsletter_Footer