Browse by Tags
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"
Read More...
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.
Read More...
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
Read More...
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
Read More...
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
Read More...
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.msdn.com/sqlcat/archive/2008/12/08/ultimate-guide-to-upgrading-to-sql-server-2008.aspx
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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=ea283d46-125f-4f94-9059-87681c0ab587&DisplayLang=en
Read More...
Sometime I have been asked that how to find out who dropped/altered/created table/stored procedure. Well, SQL 2005 has out-of-the-box solution to this problem. This works in SQL 2008 as well. Schema Change History is the report which would give details.
Read More...
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 >>>>>>
Read More...
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 IP as
Read More...
