Category Archives: Miscellaneous

Next generation Windows File System – ReFS

Microsoft team is working on Windows 8 that’s a known fact but Microsoft is coming all together with a new FILE SYSTME, this is something new. YES, Microsoft has announced one of the most significant changes that will come with the Windows 8 a new file system, called ReFS, a recent post from Windows engineering [...]

Installing SQL Server 2008 R2 SP1

I was rebuilding my machine this week and I installed three Instances of SQL Server 2008 R2 on my Machine for testing purpose. I try to keep my version upto date, so I need to apply SQL Server 2008 R2 Service Pack 1 and Cumulative Update 4 for  SP1, which all together will bring my [...]

Physical SQL Server Hardware Configuration Planning Questionnaire

A DBA, need to consider the following point in mind, prior to fix Server Hardware Configuration. 1. Is this database designed for Online Transaction Processing (OLTP) or for a decision support system (DSS)? OLTP DSS OLTP and DSS both 2. Select a server platform for your database a. Dell Power edge b. Compaq c. Open [...]

What is Server Consolidation?

What is Server Consolidation? Server Consolidation is process for reducing the number of physical servers by consolidating onto fewer servers. This can be easily understand by following image.   What are the benefit for Server Consolidation ? There are aspects of server consolidation and several ways in which consolidation can result in tangible benefits, including [...]

Can I run SQL Server 2005 32 bit on a Windows Server 64 bit ?

YES, we can run SQL Server 32 bit on windows server 64 bit platforms. Will there be any changes required in SQL Server Configuration or application to run SQL Server 32 bit on a Windows Server 64 bit ? NO, no changes are required to run SQL Server 32 bit on a Windows Server 64 [...]

Can I use Profiler on SQL Server Express Edition ?

NO, SQL Server profiler is not supported on Express Edition. Recently, I came across with an incident, where one of my customer, wanted me to monitor SQL Statement on a Express Edition.  (Note: A Server, which has SQL Server Express edition installed, doesn’t host the profiler tool). So we have four workarounds available to run [...]

When SQL Server Evaluation Edition will Expire ?

Evaluation Edition works for 180 days from the date of installation. Thus, it’s very import for me to know when it is going to stop working There are three ways to get this information, Solution 1 Open the Management Studio, click on the "Help" of Menu Bar and then on "About". In the new window [...]