Startup Jobs

Are there things you need to make sure are running when your SQL Agent starts? Did you know that you...

Quebec Human Rights Commission Ignores Racism Documented by CRT Judge (Civil Evidence), Ignores E-mail Evidence & Botches Up Investigation

After seeking justice in this matter for years, I am obliged to bring this issue up again (since it affects...

Auto Shrink of all T-Log File on a SQL Instance - TSQL

This Script will shrink all the T-Log files of SQL instance if there is no active tracsaction on the database. The...

Replace NOT IN with JOIN

Example of how to replace NOT IN clause with JOIN

/*NOT IN query*/
USEAdventureWorks;GOSELECTProductIDFROMProduction.ProductWHEREProductIDNOTIN(SELECTProductIDFROMProduction.WorkOrder);

/*JOIN Query*/:-
SELECTp.ProductIDFROMProduction.ProductpLEFTJOINProduction.WorkOrderwONp.ProductID=w.ProductIDWHEREw.ProductIDISNULL;

SQL security scripting - TSQL

SQL DBA often needs to script SQL Logins,Server roles,database users and Roles. Although its easy to script login,roles and users with...

SQL Server 2012 – Enter the EOMONTH Function

In this blog post, I will be sharing a new date feature in SQL Server 2012 called the EOMONTH (End...

SQL database Incremental Shrink TSQL

When we shrink a SQL database through GUI we usually find the database never releases all the free space, It...

Performing Unattended Installs of SQL Server 2012

In my post here, I’ve discussed the procedure to perform attended installation of SQL Server 2012 on a Windows Server...

SQLSailor is exploring(Part4) – Basic DML,DDL operations with SQL Databases on Windows Azure

In this post we will review some basic DML,DDL capabilities of SQL Database on windows Azure.
This post is in continuation with my...

SQL Server 2008 R2 Service Pack 2 Cumulative Update 1

Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 1, which is Build 10.50.4260.0. This CU has...