In T-SQL there is really interesting clause available which allows DB engine to execute some particular module (function, SP, trigger…
SQL Server
High Availability in ASP.NET application
From Wikipedia, High availability is a system design approach and associated service implementation that ensures a prearranged level of operational…
“Copy database” operation, quick ‘n easy way to make duplicate database
I was trying to create a demo for one of my experiment, and I had to make create duplicate database…
SQL Server with in-memory TempDB
Today, I did some experiment with SQL Server. I have been using an awesome tool called RamDisk now and then…
Side effects of User Account Control (UAC) of Windows 7
When I used it for first time I thought that UAC was really annoying feature of Windows Vista. I mean…
Managing Orphaned database users in SQL Server
It one of the most common issue you will face when you will move/copy your database from one server to…
Truncate Vs Delete in SQL Server
If you have been looking for job in Database related field then you might be already familiar with this age…