Archive for the ‘Prechecks’ Category
Limitations in 64-Bit Windows server 2003
Posted by: Manpreet Singh on: July 21, 2009
Windows Server 2003 is considered to be one of the most scalable operating system when running on 64 bit platform. But still there are some consideration which must be consider before migrating SQL Server to 64 bit enviournment
There are some limitations of windows server 2003 which must be addressed before migrating SQL server to [...]
SQL Installation Server Setup Checklist
Posted by: Manpreet Singh on: June 26, 2009
Before Install
Create at least one new Active Directory account for SQL Server.
This is best practices, and a popular shortcut is to run all of the database servers under the same service account. I’ve run into two problems with this approach. First, I’ve had a sysadmin repeatedly fat-finger the service account password, thereby locking out [...]
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 [...]
Important Points before Planning Replication Strategy
Posted by: Manpreet Singh on: May 12, 2009
There are many factors which decide the proper working of replication. We must consider all the factors which are important to make sure that the deployment goes as smoother as possible. I have enlisted some considerations which I feel is important and should be addressed before planning any replication strategy.
Application Requirement: before implementing any replication [...]
