My kids have been on spring break all week. Being out of school with time on her hands… my daughter, Emilee, made a Spring Break Gift for me. (kind of like a birthday or Christmas gift)

So, knowing that my daughter loves to draw and create things… I could hardly wait to see what she had done for her loving and caring dad.

I open it. She quickly tells me it is a game. It’s called “pin the tail game”.
(I used to call it pin the tail on the donkey)

I was all cool with that until what came out of her mouth next….

“Dad… that face is a picture of you.”

Not sure what to think…

Anyone for a game of pin the tail on a Reeder?

In honor of my good friend Page Brooks…

(thanks to Dark Roasted Blend for to picture)

The other day, we noticed that when our CREATE DATABASE scripts were running… the databases were not created where we expected. Due to our setup, we want the databases and log files to use the SQL Server default locations.

We ran the following T-SQL to verify the default locations:

USE master GO DECLARE @SmoDefaultFile nvarchar(512) EXEC master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultData', @SmoDefaultFile OUTPUT DECLARE @SmoDefaultLog nvarchar(512) EXEC master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultLog', @SmoDefaultLog OUTPUT SELECT ISNULL(@SmoDefaultFile,N'') AS [DefaultFile], ISNULL(@SmoDefaultLog,N'') AS [DefaultLog]

Results…

DefaultFile	DefaultLog
——————————–	——————————–
D:\SQLDbs\Data	D:\SQLDbs\Logs
(1 row(s) affected)

Looks correct… why is it putting the database and log files in:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

Just to be sure… we verified this setting on the Server Properties screen in SQL Management Studio…

Looks correct…

What we found through testing… In order for the default locations to work as expected… SQL Server must be restarted. I feel (not proven) that SQL Server loads these values from the registry at startup, and does not update when the change happens on Server Properties.

We moved the event to April 29th for this month… Please help us by registering for the event.

Tuesday, April 29th, 2008
Chris Reeder, Chris Craft, and Page Brooks
Topic: SQL Server 2008, Windows Server 2008, and Visual Studio 2008 (Respectively)

Tuesday, April 29th, 2008, is the next meeting of the Pee Dee Area .NET User Group.

Chris Reeder, Chris Craft, and Page Brooks will be presenting on the latest exciting new products from Microsoft.  First, Chris Reeder will give us a run down on a few cool features in SQL Server 2008.  Next, Chris Craft will take us on a tour of some excellent new features in Internet Information Services 7 (IIS7).  Page Brooks will finish off the presentation with a few cool tips and tricks in Visual Studio 2008.

Please click the link below to register.  We use this information to determine how much food to buy!

Here is the tentative schedule:
6:00 PM – 6:20 PM Socializing / Free Dinner
6:20 PM – 6:30 PM Introduction, Sponsor Time, and News.
6:30 PM – 8:00 PM Presentations

I started using my Twitter account again… and then it happened…

I broke it!

I am not sure Twitter.com is ready for me!!!

When it gets back up an running…

Please feel free to follow me on Twitter @ http://twitter.com/clreeder

I almost made this post into one long April Fool’s joke about me becoming a Microsoft MVP…

but…..

• I could not think of anything I am even close to being competent enough to receive an MVP nomination… much less an actual MVP…
• With a site like StupidProgrammer.com, who would believe me about being an MVP…
• Does Microsoft have a MVP for great blogs… hum… that wouldn’t even get me a nomination…
• So, instead…

How about I send a shout out to Chris Craft for receiving his MVP in Device Application Development! That is not an April Fool’s joke!

Way to go Chris! You truly do show a deep commitment to the .NET community and have a GREAT willingness to help me others!>