From Wikipedia, High availability is a system design approach and associated service implementation that ensures a prearranged level of operational performance will be met during a contractual measurement period. And it could include multiple database and application server connected in a clustered environment with redundant hardware. One of the method to make ASP.NET application available
Category: 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 for that purpose because I didn’t wanted to do tests on my TestDB so quickest option was to use “Copy Database” feature in SSMS, because other option like restoring backup of DB with another name
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 for experiments. It allows to use RAM as a HDD !! So if you have enough RAM you can throw some RAM to this tool (free version has 4Gb max limit) and you will get
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 for each and every app it was required me to confirm, if I wanted to perform some task which required access to core system. It was more like low level mimic of Linux. But after
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 another server. You will have all finely setup SQL Server Logins and their related database users but when you copy or move your database those Server Logins will not get transferred automatically. Result is what
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 old question (which I was asked in almost all interviews) is “What is difference between DELETE and TRUNCATE ?” And usually if you read on internet you will see that people answer it with just
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) at least once. Microsoft has created this cycle selling company database for SQL Server 2005 and later versions, before this sample we had “NorthWind” database. Anyways, if you try to install these sample databases you