Tuesday, December 13, 2016

Microsoft SQL Server Non-Contained Object Migration Deployment Procedure using Powershell

›
As a DBA we all face the challenge of migration databases from one servers to another or even the whole servers at some times. The Datab...
Tuesday, January 19, 2016

SQL Server 2016 Express LocalDB

›
As Microsoft SQL Server 2016 comes with a lot of new and exciting features for SQL Server Database Administrators, the developers do not n...
Monday, June 29, 2015

Generate Publication Stored Procedure in SQL Server 2014

›
In Transaction Replication at times the Subscription Stored Procedures (inset, update or deleted) get out of sync with Publication.  To ge...
Monday, October 28, 2013

Get current running Job Schedule Id or Name in SQL Server

›
Here is a simple TSQL code that gives you the Schedule Name & ID which invoked he current job execution.  DECLARE @Schedule_Name_I...
Thursday, July 05, 2012

Execute a command for a batch in Windows 2008 Server

›
ForFiles This is a command in windows 20008 for applying specified command on each file for a batch.  For example if want to delete ...
Monday, June 11, 2012

Atlantis Schema Inspector - by "Atlantis Interactive"

›
Another handy tool to compare schema in SQL Server. SQL Server Schema Comparison and Scripting Tool. Atlantis Schema Inspector is...

SQL Load Generator by CodePlex

›
A very handy tool to generate a good load, a must have tool.  SQL Load Generator is used to run multiple concurrent queries against SQ...
Wednesday, November 23, 2011

Calculate difference of Time only between two dates while discarding difference of dates in SQL Server/ extract time and calculate difference between two dates in SQL Server

›
DECLARE @DateTimeOne DATETIME DECLARE @DateTimeTwo DATETIME SET @DateTimeOne = '1900-01-01 10:41:09.250' SET @DateTimeTwo ...
Friday, June 24, 2011

Working with Email Address in SQL Server ( Validate Email Address )

›
at times working with email addresses in sql server becomes difficult so here is a UDF you can use to validate the email address It will ...
Tuesday, January 11, 2011

Best Practices for using DATETIME column in sql server 2005 and 2008

›
Best Practices for using DATETIME column in sql server 2005 and 2008 In production environment we have seen that there are certain times wh...