Archive for May 2009
System Databases in SQL server 2005
Posted by: Manpreet Singh on: May 26, 2009
Whenever we install new SQL server instance on server, it include four system databases by default named: Master, Model, Tempdb, and MSDB. It also contains a fifth, stealth database that you will never see using any of the normal SQL tools or commands. This database is referred to as the resource database, but its actual [...]
Find percentage of work completed in SQL Server 2005
Posted by: Manpreet Singh on: May 25, 2009
Yesterday, I and my friend were taking manual backup of database on development server through management studio and suddenly management studio stop responding. I knew that this is happening due to the load added by backup process. We were wondering if there is any TSQL statement through which we can find the status of task [...]
Configuring Active Directory and Domain Controller
Posted by: Manpreet Singh on: May 19, 2009
Installing Active Directory needs static IP address. This can be assign by selecting network card properties and then typing in the IP address we wish to use. The subnet mask must also be provided. Both values must be correctly chosen given the networking configuration of the network that the cluster will be a part of. [...]
Changing SQL Server services account
Posted by: Manpreet Singh on: May 18, 2009
One of my pal is working on a project where they don’t have any dedicated SQL server DBA (they rather have developer DBA). One day he called me and told that he was having a problem with one of their SQL server instances. The instance was installed in my supervision so I was quite sure [...]
Changing SQL Server Instance’s Name
Posted by: Manpreet Singh on: May 15, 2009
Working in test environment we need to frequently deploy test machines with very short notice. The best way to do it quickly is to use any virtualization product. I personally use VMWARE server as it is free and easy to operate. We can build one VM machine and can use it just by copying it [...]
Biztalk BizTalkDTADb Database Size Problem
Posted by: Manpreet Singh on: May 14, 2009
Today one of our development SQL servers was Showing low disk space. The server hosts databases for BizTalk server. When I enquired the issue I found BizTalkDTADb is taking most of the disk space, around 33 gigs. The server is development server and I got surprised as I never thought that a BizTalk server database [...]
