You can monitor your web application by given its url and by creating the job in sql server 2005 which will send you the mail when ever your website is down.
2016-11-07 (first published: 2009-06-17)
11,953 reads
Enhancement to Track database growth By Irwan Tjanterik, 2014/09/23
2016-11-03 (first published: 2014-10-07)
2,618 reads
This Script Generates A script to Create all Logins, Server Roles, DB Users and DB roles on a SQL Server.
2016-11-02 (first published: 2013-10-31)
33,337 reads
Add 3 columns, duration in seconds,Pagecount and fragmentation. For people like me who don't enjoy querying XML.
2016-10-31 (first published: 2015-11-12)
3,396 reads
Refresh all views in a database
2016-10-28 (first published: 2016-10-05)
23,054 reads
Using OVER clause with ROW_NUMBER() function to get top ranked employee detail as per each department.
2016-10-25 (first published: 2016-10-03)
803 reads
If you want to extract only deadlock details, use the script.
2016-10-24 (first published: 2014-12-03)
3,906 reads
Store a file & Retrive it in Sql Server
2016-10-21 (first published: 2015-05-12)
2,425 reads
Complete Details About Backups Taken a Day Ago.
2016-10-20 (first published: 2015-05-15)
1,628 reads
Calculates total length of services for a employee. Calculates( addition or subtraction) two internships in form of yy.mm.dd
2016-10-19 (first published: 2016-10-03)
510 reads