First of all, many thanks to all the friends and followers who always inspire me to share my knowledge with the world. In recent past I have been actively participating in MSDN forums and realized that there is so much knowledge to be shared. Many times...

Most of us know the SQL Server next version – code name “Denali” CTP1 has been released. Today, I have downloaded and installed it on my VM to lean more.. Here is the download link As soon as I started setup, after few steps, I was stuck with below error...

Few readers contacted me offline for next part. Here is the second part.. http://blogs.msdn.com/sqlserverfaq/archive/2010/04/28/how-to-install-clustered-sql-server-2008-on-windows-2008-cluster-using-hyper-v-guest-clustering-part-2.aspx Thanks for the...

After hearing a lots of feedback on my previous blog post on SQL 2005 Cluster on Virtual Server, I decided to spend some time to write a blog to install SQL 2008 on Windows 2008 R2 Cluster in Virtual Environment using Hyper-V. New Series is posted here...

Few days back there was a question in our internal forum about moving SQL Server from Standalone to cluster environment. Based on my experience there are many ways to move standalone SQL Server to clustered SQL Server. As you all know that SQL Server...

Recently I have worked on one of the case where SQL Server Express Edition was failing with Error The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files"...

While working with a customer, we identified that there is a easy way to find missing index of a given query using Management Studio (SQL 2008 onwards). So I thought of sharing along with a demo. Below is the demo script to create objects needed.  ...

I decided to write a new blog series to Install SQL Server 2008 on Windows 2008 cluster in Virtual environment. Since I got brand new Windows 2008 64 Bit machine, i decided to use Hyper-V to play around. I could install Hyper-V without any issue but I...

Once you install evaluation edition of SQL Server 2008 and then perform in place upgrade to full version, you may get below error message when you open SQL Server Management Studio. For better search, below is the text of the message Microsoft SQL Server...

Sometime back I was asked by one of my customer who wanted to change the startup account for SQLServer Service and SQLBrowser Service without manually going to SQL Server Configuration Manager and changing password there. By the way, did you know... You...

I will keep on adding the resources which I would find useful to help customer upgrading from SQL Server 2000/SQL Server 2005 to SQL Server 2008 White paper written by experts SQL Server 2008 Upgrade Technical Reference Guide SQLCAT Team Blog http://blogs...

Someone posted this question in one of the internal forums and I found this interesting so thought of posting the solution. We are not allowed to add new facets in Policy Based Management and I could not find any facet which checks for trace flags. While...

One of my friend asked me logic/Query to find date of last Monday. Everyday of the week can be identified as a number i.e. Sunday is 1, Monday is 2 and so on... Since he wanted to find out date on Monday, it is 2nd day of week. Below is the logic Monday...

Q. Where is Management studio? I installed all components in SQL Setup. Q. Workstation components installed but only the Configuration Tab shows. What's up? I have come across this situation many times where someone is trying to install SQL Server 2005...

This is the last part of the series. Once you have configured windows cluster and MSDTC, installing SQL is piece of cake. I already mentioned in part 1 that you have to download ISO (SQLEVAL.ISO) which we would need to attached as CD drive which would...

In previous parts( Part 1 , Part 2 and Part 3 ), we have completed windows clustering. Now, before installing SQL Cluster we have to configure MSDTC. We also need to make some shared drive which we would use to keep SQL Server databases and MSDTC. We...

I know there are many resources on various web sites to install SQL Server 2005 on Cluster. Below are the three documents which I always share with my customers. Server Clusters: Storage Area Networks http://www.microsoft.com/downloads/details.aspx?FamilyID...

Once of my customer asked for an "automated" script which would find all the users, which are not mapped to login and map them. Below is the logic which can be used. <<<<<<<<<< PLEASE READ DISCLAIMER >>>>>>...

In Part 1 and Part 2 , we configured till setting up Quorum drive on MyNode1. First we need to change the IP address of heartbeat network which we added to MyNode1 and MyNode2. Below is the screen shot of heartbeat IP on MyNode1. We need to give...

In Part 1 we have made our Virtual network ready which is having a domain controller and two member servers (MyNode1 and MyNode2) Lets start making cluster... Create Quorum Disk For cluster we need a Quorum disk. Below are the steps to make a...

After delivering SQL Training, I realized that there is a need to write a blog which talks about Installing SQL Server 2005 cluster on Virtual Environment. Many DBA wants to see how Cluster looks like and they don't have capability to buy/see actual cluster...

In SQL Server 2000 and earlier version, there was no easy way to find blocking on server. You need to capture Blocker script and do analysis. Going forward, in SQL Server 2005 there is new event in profier trace called "Blocked Process Report" Event Class...