Resources – Migration from SQL 2000/SQL2005 to SQL 2008

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 MSDN Link Resources for Upgrading to SQL Server 2008 SQL Server UE team…

3

How do I define a policy in SQL Server 2008 to evaluate if a Trace Flag is enabled ?

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 researching I found Blogs from Dan Jones (PBM Program…

0

What was the date on Last Monday?

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 Of The…

2

Workstation components installed but only the Configuration Tab shows. What’s up?

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 and even after successful installation SQL Server Management Studio is missing even if workstation…

1

How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 5)

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 have setup files. I have copied the image on…

66

How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 4)

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 are going to use Disk M for MSDTC and Disk X…

20

SQL 2005 Cluster Setup Checklist

  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 Guide to Creating and Configuring a Server Cluster under Windows Server 2003 http://www.microsoft.com/downloads/details.aspx?FamilyID=a5bbb021-0760-48f3-a53b-0351fc3337a1&DisplayLang=en SQL Clustering White paper: .  http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en…

19

Script : Map All Orphan Users to Logins else create login and map

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 >>>>>> If (login not exists)create login and map login with userelsemap login with user <Replace MYDB and Password as…

2

How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)

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 10.10.10.1 (once you hit tab, subnet…

13

How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 2)

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 Quorum virtual disk. In the menu of Virtual Server, click on…

0