January, 2009

First Beta of Standalone SQL Agent released

It took me a little less time than I expected to get an acceptable build put together. Continued »

Standalone SQL Agent Status Update (Jan 28, 2009)

I’ve made some good progress on the Standalone SQL Agent that I’ve been working on. Continued »

SoCalCodeCamp Photos were posted

Marc Salsberry has posted some pictures from the SoCal Code Camp on his facebook page.

If you know of other pictures please post links here or on Twitter with the #socalcodecamp tag.

Denny

Back To Basics: What are indexes and what are they used for?

A while back someone posted on the ITKE forum asking what Indexes where, and what they were used for. I put up a quick answer, but I felt that it deserved a more in depth blog post; so here it is.

Continued »

How do you source control your database, in your environment?

I’m curious about how various people are handling source control in their environment for the database? SSIS, SSRS, etc are all easy. They plug directly into the normal source control providers. But how do you handle SQL object changes like table changes, and stored procedure changes?

Continued »

#SoCalCodeCamp was a blast

This weekends SoCal Code Camp was great. Continued »

Viewing SQL Server Plan Guides

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 »

SoCal Code Camp This Weekend

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.

Denny

Windows 7 After my first week

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

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

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.

Denny