SQL Server with Mr. Denny:

January, 2009


January 29, 2009  11:10 PM

First Beta of Standalone SQL Agent released



Posted by: Denny Cherry

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

January 29, 2009  7:03 PM

Standalone SQL Agent Status Update (Jan 28, 2009)



Posted by: Denny Cherry

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


January 29, 2009  8:27 AM

SoCalCodeCamp Photos were posted



Posted by: Denny Cherry
SoCal Code Camp

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...


January 26, 2009  12:00 PM

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



Posted by: Denny Cherry
Back To Basics, Identity theft, Index, Index Scan

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.


January 26, 2009  7:54 AM

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



Posted by: Denny Cherry
Source Control

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?


January 26, 2009  2:06 AM

#SoCalCodeCamp was a blast



Posted by: Denny Cherry
SoCal Code Camp, Twitter

This weekends SoCal Code Camp was great. Continued »


January 22, 2009  3:00 PM

Viewing SQL Server Plan Guides



Posted by: Denny Cherry
Code Snippet, Plan Guides, SQL Server 2005, SQL Server 2008, sys.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...


January 21, 2009  11:00 AM

SoCal Code Camp This Weekend



Posted by: Denny Cherry
Code Camp, In Person Events, Twitter

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...


January 21, 2009  10:57 AM

Windows 7 After my first week



Posted by: Denny Cherry
Windows 7

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



Posted by: 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...