When Things That Are Supposed to Protect You Try to Kill You

This past week I was presented with a very unique issue.  A call came in with a production issue on...

Notes to a DBA who wishes to know more

I just sent this off to a fellow DBA who wanted some resources. You may also be one of those,...

SQL Server : Fixing the Orphaned Users

In my last post , we have discussed about orphaned uses and how to find out the orphaned users. In this...

SQL Server:Finding the Orphaned Users

Orphaned user is a common problem in SQL server world.When I was working on internal security audit of our production...

Creating and Managing User-Defined Roles in SQL Server 2012

SQL Server 2012 introduces user-defined server roles. These user-defined server roles are similar to fixed server roles with only difference...

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...