From Wikipedia, High availability is a system design approach and associated service implementation that ensures a prearranged level of operational…
SQL Server
“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…
Deploying AdventureWorks Analysis Database ..
If you are working with SQL Server then you might already have used this great cycle selling company’s database (AdventureWorks)…