Generic trigger for maintaining the Audit Log

This trigger will work even if you don't have the primary key on any table. Mechanism to configure the primary key in config table has been provided. This can be very helpful to solve the system audit requirements without much efforts.

Disclaimer : Audit Log trigger has performance overhead. It’s meant for table which is not frequently updated, deleted or inserted. Please take precaution when creating the trigger on the table having too many columns.

Compare Table Contents Procedure

Compare the content of two tables for differences

Fix all orphaned users in a database

Fix orphaned users on a restored db

Building calendar table using MTVF

This script is a small extension to this excellent article
http://www.sqlservercentral.com/articles/calendar/145206/

Calculate two internships

Calculates total length of services for a employee. Calculates( addition or subtraction) two internships in form of yy.mm.dd

Date calculation

Data calculation in form yy mm dd

Getting resource content from blocked process report

This script serves to display the content of the waiting resource. It is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCRL.

Getting resource name from blocked process report

The Resource name is most important information in the blocked process report.
The purpose of this script is to decode this information.
The script is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCLR.

List Extended Database properties for all databases

I am using database properties to add some useful information for each database. Tired of exploring each database from the menu in SSMS to look for specific information, I decided to make a script listing the extended properties for all my databases. I am pleased to offer this to the community 🙂

WorkDay Functions

Functions to list the number of work days in period , determine if a given date is a work day, add work days to a given date.
Uses a table of holidays and a tally table.