Query Fingerprints and Plan Fingerprints

September 9, 2008 at 8:32 am (nHibernate, SQL Server 2008, TSQL) (, , , , , )

SQL Server 2008 has been released, but the full capabilities of the product are still be discovered. This isn’t a case of discovery so much as Microsoft, in the person of Bart Duncan, has shown us something new. Read the article. This is one of the most exciting things I’ve seen in a long time. It’s especially exciting as we see databases becoming less and less manageable through the implementation of tools like nHibernate.

As I noted in a previous post, nHibernate will create a lot of execution plans. With the capabilities here, we’ll be able to easily and quickly aggregate some of those plans to identify the costly queries coming out of nHibernate without having to resort to 24 hour Profiler monitoring.

Great stuff.

Permalink Leave a Comment

SQL Server 2008 Install, cont.

August 15, 2008 at 1:30 pm (SQL Server 2008, Tools) (, , )

OK. Hopefully you’re all reading this stuff BEFORE trying to do the install and certainly BEFORE uninstalling everything in sight. The latest version of SQL Prompt, version 3.9, is 2008 compatible AND doesn’t cause this problem with the install.

So, I’ve got to reinstall the software. Time to track down my license. I hope I kept that email.

Permalink 1 Comment

SQL Server 2008 Install, cont.

August 15, 2008 at 1:20 pm (SQL Server 2008, Tools) (, , )

OK. I found some information. The first suggests uninstalling SQL Prompt. I tried it and that did the trick. The second suggest was to do a brute-force removal of the registry key: HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90. I didn’t get there.  Install is running on the desktop now.

That seems a bit mean of Microsoft, requiring me to uninstall Red Gate’s SQL Prompt, especially since it’s such a great little tool. I wonder if I can install it on top of 2008? Time for some more research.

Permalink Leave a Comment

SQL Server 2008 Install

August 15, 2008 at 1:14 pm (SQL Server 2008) (, , )

I just finished the install of SQL Server 2008 RTM on my laptop. No real issues except that it wanted SP1 of Visual Studio installed before it would complete. Once I had that done, everything was up and running. The new install routines are nicer than the old ones if a bit more detailed.

My desktop is another matter. SQL Server 2008 objected to a SQL Server 2005 Express install. I removed that. It still thinks Express is installed. I’m removing all of SQL Server 2005 to see what happens.  The error reported was pretty non-helpful.

This is a bit odd since the laptop also has a copy of Express installed.

Well, uninstalling all things SQL Server didn’t work. Sql2005SsmsExpressFacet is failing. It simply states: “The SQL Server 2005 Express Tools are installed. To continue, remove the SQL SErver 2005 Express Tools.” Time for a bit of research.

Permalink 2 Comments

Performance Studio

April 1, 2008 at 6:54 pm (SQL Server 2008, Tools) (, , , , , , )

I just found out about some new functionality coming out in SQL Server 2008 called Performance Studio. It’s actually largely a framework around which you can build performance monitoring routines for an entire enterprise. This sounds terrific. I’m going to dig into a bit and make it my presentation for the Heroes {Community} Launch event at SNESSUG next week. Here’s a Technet webcast on the topic. Here’s a very nice blog entry over at SQLTeam (I suppose I should ad them to my blog roll) discussing the function of the Data Collector, the foundation for this new framework. Performance Studio only works with 2008 systems though, so that’s something to take into account. Although I see an interview with Brad McGehee that says it’s not enterprise ready. Another something to take into account.

Permalink 1 Comment

SQL Server 2008 November CTP

March 6, 2008 at 7:49 pm (SQL Server 2008) (, , , )

My fault, my fault, my most grevious fault… I installed the November CTP to my virtual machine without making a backup of the virtual first. Now I can’t get the November CTP to uninstall and the February CTP won’t install on top of it. ARRRGGGGH!

Anyway, I’ll be getting back to 2008 tomorrow, hopefully, after the admin guys get me a new virtual.

Permalink Leave a Comment

« Previous page