SQL Server with Mr. Denny

January 22, 2009  3:00 PM

Viewing SQL Server Plan Guides

Denny Cherry Denny Cherry Profile: Denny Cherry

So you’ve saved a plan guide into your SQL server, and you want to look at the plan.  You can Query the sys.plan_guides catalog view and see the data exactly as you entered it, which works fine if you just have a hint in there.  But if you have a full XML query plan that isn’t going to do you a lot of good since SSMS isn’t going to want to show you the all the XML as it is probably longer than it wants to display.

This little query should help you with that.  You may need adjust it slightly to account for extra spaces in your plan guide, I tried to account for double spaces, but if you have more than two spaces anywhere in the top part you’ll need to tweak it.

Continued »

January 21, 2009  11:00 AM

SoCal Code Camp This Weekend

Denny Cherry Denny Cherry Profile: Denny Cherry

Don’t forget that the SoCal Code Camp is this weekend on the Cal State Fullerton Campus.

The Code Camp is a free training session with about 100 sessions being held by local IT Professionals for local IT Professionals (or anyone else who wants to come and listen).

If you are looking for database sessions, last time I looked there were 9 SQL Server sessions being presented.

See you at the code camp.


January 21, 2009  10:57 AM

Windows 7 After my first week

Denny Cherry Denny Cherry Profile: Denny Cherry

Well, I’ve had Windows 7 for a week now, so I think that its time for an update. Continued »

January 20, 2009  9:12 PM

The virus Win32/Conflicker.B is still running around the Internet

Denny Cherry Denny Cherry Profile: Denny Cherry

Apparently the computer virus Win32/Conflicker.B is still running around the net causing all sorts of problems.

In order to kill this threat Microsoft has done a few things.

Back in October they released Microsoft Security Bulletin MS08-067.

Microsoft has updated the Malicious Software Removal Tool to detect and remove variants of Win32/Conflicker.B.  This update can be downloaded from the Microsoft Update site or through its KB article.

There is a KB Article specifically about the virus it self.

Microsoft is recommending that you immediately apply MS08-067 to all unpatched systems to prevent the threat.


January 18, 2009  1:04 PM

January 2009 Code Camp Presentations

Denny Cherry Denny Cherry Profile: Denny Cherry

With the SoCal Code Camp this weekend, I’ve managed to get my slide decks put together early enough to get them posted well in advance this time. Continued »

January 15, 2009  11:00 AM

Reading the Error Messages is key

Denny Cherry Denny Cherry Profile: Denny Cherry

I have a gripe that I need to air.

I can’t stress this enough.  Actually reading the error messages when there is a problem is key to solving the problems.

Most of the time (I admit, not all the time) SQL Server will give you some very useful information about what to do next.

Continued »

January 15, 2009  10:06 AM

Windows 7 and Cisco VPN Software

Denny Cherry Denny Cherry Profile: Denny Cherry

We use Cisco VPN Software to access the office from home, Starbucks, etc.

There are several threads on the subject on the net (I used this one).  There are a couple of workarounds which are mentioned including backing up the ndis.sys file and putting it back after the install but before the reboot.  (This didn’t work for me, my laptop still blue screened.)

Another fix was to run the installer in Administration mode (I opened a command prompt using the “Run As Administrator” from the right click) then ran the installer.  (This did work for me.)

One annoying thing was when I imported our PCF file the group password wasn’t imported.  I had to use a Cisco VPN Client Password Decoder website to get the password from the PCF file to put into the address book.  Everything worked fine after that (at least so far).

Hopefully someone else finds this useful.


January 15, 2009  3:47 AM

My first day with Windows 7

Denny Cherry Denny Cherry Profile: Denny Cherry

Today was my first day using Windows 7 as my primary OS.  I took the time this afternoon to install Windows 7 and start getting everything set back up. Continued »

January 12, 2009  11:00 AM

Phishers Are Going After Twitter

Denny Cherry Denny Cherry Profile: Denny Cherry

Apparently Twitter has officially gone mainstream.

Why do I say officially when they are been around for years and have over a Billion tweets?  Because phishers are now going after Twitter accounts.

So far they appear to be only getting your twitter account info and sending more messages to other people.  I would imaging in a short amount of time these attacks will become more nafarous.


January 10, 2009  3:06 AM

Standalone SQL Agent Progress Update 1/9/08

Denny Cherry Denny Cherry Profile: Denny Cherry

I’ve reached a milestone of sorts in the development process which I’d like to share. Continued »

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: