Utilities: RML Utilities from PSS

The SQL Server PSS group announces the release of RML Utilities.

 From the blog post: 

The Microsoft SQL Server support team uses several internally-written utilities to make it easier to work on a typical customer support case. These utilities may also be useful to database developers and system administrators who work with Microsoft SQL Server 2000 and Microsoft SQL Server 2005.  The utilities are collectively called the RML Utilities for SQL Server.


With the RML Utilities you can answer questions such as the following:


·         Which application, database or login is consuming the most resources, and which queries are responsible for that.

·         Whether there were any plan changes for a batch during the time when the trace was captured and how each of those plans performed.

·         What queries are running slower in today’s data as compared to a previous set of data.


You can also test how the system will behave with some change (different service pack or hot fix build, changing a stored procedure or function, modifying or adding indexes, and so forth) by using the provided tools to replay the trace files against another instance of SQL Server.  If you capture trace during this replay you can use the tools to directly compare to the original baseline capture.

Very cool!

o<:{> Andy

SSIS Third-Party Components: CozyRoc

CozyRoc has a suite of Control Flow Tasks that are worth a look. We’re using the SFTP (Secure FTP) and SSH Connection Manager on my current project.

Once we identified the need for SFTP, I looked around and identified a couple companies / products. The CozyRoc download was the only one I could make work.

I’ve communicated with the company a few times with questions about functionality. I found Ivan to be very responsive and refreshingly open.

We’re planning to use other tasks in the suite as well: the Script Task Plus, Zip Task, and Database Partitions Task are slated for use. It’s all good stuff and the price is extremely reasonable ($99.95!) – especially when compared to the competition.

Kudos Ivan.

:{> Andy


Utilities: SourceGear’s DiffMerge

I like SourceGear. I like what I know about the company, the people, and their products – mostly the people.

SourceGear DiffMerge is helping me this morning. I created an FTP class  in an SSIS Script Task from code I found online because… well, that’s another post. At this point in my refactoring, I have implemented this class in a couple/three places. As the project has matured, subtle differences have emerged between the functionality in one implementation and others.

It’s now time to fix that with some refactoring and consolidation. The end result will likely be an assembly in the GAC. (Again, more for another post…)

I’m using SourceGear DiffMerge to compare the text in the classes. Simple, clean, efficient, fast. DiffMerge doesn’t automatically refactor for me. It just tells me what the differences are and where they lie in my code. It allows me many options for merging the files, but it doesn’t force them on me when I start.

Maybe, just maybe, all I want to do is see the differences first.

Great product, and it’s free.


:{> Andy

Installing Virtual Server On Vista Ultimate 64-bit


This may be a little off-topic.

I use Virtual Server and Virtual PC a lot for things like testing beta and CTP releases of SQL Server. I don’t have time or the inclination to reformat physical hard drives, load an OS, or even fiddle with restoring from an enterprise backup solution like Ghost.

I blogged about configuring IIS7 for Reporting Services 2005, so this may have more relevance than I imagine.


If you’re not using virtualized machines or servers, you should check them out. They’re great for testing new stuff – relatively risk-free. I am aware of two flavors of virtual engines: VMWare and Microsoft products: Virtual PC and Virtual Server.

I have no experience with VMWare.

The Microsoft products are 100% free (as in beer).

I do not know which is better. I imagine that, like all things in life, one has advantages over the other and vice versa. The Microsoft stuff does what I need, so I’ve not ventured to search greener pastures (ever wonder why those pastures are greener? Think about it).

Get To The Configuration Already!

When I installed Virtual Server 2005 R2 SP1 on my newish Vista Ultimate 64-bit machine, I saw quirky stuff. For example, I could not change the port for admin – it defaulted to 80 and gave me an error message stating my server “didn’t allow” installations on other ports.

Reeeeaaallly? Huh.

I proceeded with the installation anyway and nothing worked. Well, nothing in Virtual Server. I could not get to the administrative page and, in case you’ve never worked with Virtual Server, you can do nothing unless you can reach the administration page. (Note, you can do stuff if you like to type. I don’t like to type.)

search ensued. I found a good article on why this was happening and how to fix it. It happens because IIS7 isn’t configured (out of the box) to allow Virtual Server 2005 R2 to do its thing. To fix it, open Control Panel, Programs and Features (the snappy new Add/Remove Programs), then click “Turn Windows features on or off”.

You want to navigate to Internet Information Services folder and make your Windows Features look like this:

(A Thousand Words)

The image above may be the first on the web (it was the only one I could find) of how to configure IIS7 on Vista Ultimate 64-bit for both SSRS 2005 and Virtual Server 2005 R2.

Note you still get the Configure Components screen displayed above – the one with port textbox disabled and set to 80 – at least in Vista Ultimate. But you also get these screens:


:{> Andy

SSRS 2008 Is IIS-Free

Microsoft has severed the IIS dependency for SQL Server Reporting Services (SSRS) in the 2008 version, according to a couple sources.

Reasons cited include :

  • Deployment considerations (some enterprises prohibit IIS on database servers).
  • Better configuration.
  • Better resource management.

 :{> Andy

Installing Reporting Services 2005 on Vista

I have a new Dell desktop. The first thing I did was install Vista 64-bit and bumped it up to 4GB of RAM.

I’m now trying to install a default instance of SQL Server 2005 Developer and can’t get Reporting Services to run because IIS isn’t installed. After trying the click-a-bunch-of-stuff in the “Turn Windows features on or off” dialog, I decided to read the instructions. I may have to start by reading the instructions from now on… click-a-bunch-of-stuff may no longer be my default…

The instructions are here – and I am happy to Report (pun intended) that they work.

The dialog you’re after looks like this:

Be sure to install the latest service pack (SP2 at the time of this writing) when the install completes.

:{> Andy