This is just a test.

This weekend is going to be full of tennis for me. I can watch a live stream of Wimbeldon online via NBC’s web site – http://wimbledonlive.nbcsports.com/

The live stream is even in HD quality, pretty amazing!

And starting tonight, the Pacific Continental Bank Open Tennis Championship starts at Eugene Swim & Tennis Club.  I’ll be there most of the weekend watching and taking in some sun.  If you’re in Eugene, check it out, it is open to the public.

I have to get my own Auto Tune.  Check the comments on Vimeo for some out takes.

Auto Tuning from Casey Donahue on Vimeo.

Wow, just wow.  This is simply amazing skill.  Is it wrong to want my boys to be able to ride like this?

My boss at work sent me an email about this.  Looks pretty interesting.  From their web site:

What is SQLSaturday?

It’s a one day free training event for SQL Server professionals organized by a local user group.  It takes a lot of work and a lot of volunteers, but it’s also a lot of fun.

Looks like there is one in Portland, Oregon on June 6th.  I’m thinking about attending.  Check out their web site for more details:  http://sqlsaturday.com/

I’ve always been a fan of Kathy Sierra and was extremely disappointed when she retired from blogging.  Thankfully Twitter came along and she’s participating in the conversation again.  It’s good to have her unique perspective and information flow back.

Today she posted:

I haven’t done much with Action Mapping, but I can quickly see how they can help you achieve goals.

Here’s the presentation.

Perfect couch for a geek office!

We’ve been migrating some of our production databases at work to SQL 2008 and I’m finding that Microsoft changed a lot. They updated the BACKUP LOG t-sql command and removed the TRUNCATE_ONLY switch, which means quickly and easily purging the transaction log requires a bit more work. I spent a little while yesterday and wrote the following T-SQL to purge the logs.


------------------------------------------------------------------------------
-- Otto R. Radke - http://ottoradke.com
-- Info: T-SQL script to shrink a database's transaction log. Just set the
-- database name below and run the script and it will shrink the
-- transaction log.
------------------------------------------------------------------------------
------------------------------------------------------------------------------
-- Update the line below with the name of the database who's transaction
-- log you want to shrink.
------------------------------------------------------------------------------
USE YourDatabaseName
------------------------------------------------------------------------------
-- Don't change anything below this line.
------------------------------------------------------------------------------
GO
-- Declare variables
DECLARE @SqlStatement as nvarchar(max)
DECLARE @LogFileLogicalName as sysname
-- Alter the database to simple recovery
SET @SqlStatement = 'ALTER DATABASE ' + DB_NAME() + ' SET RECOVERY SIMPLE'
EXEC ( @SqlStatement )
-- Make sure it has been altered
SELECT [name], [recovery_model_desc] FROM sys.databases WHERE [name] = DB_NAME()
-- Set the log file name variable
SELECT @LogFileLogicalName = [Name] FROM sys.database_files WHERE type = 1
-- Shrink the logfile
DBCC Shrinkfile(@LogFileLogicalName, 1)
-- Alter the database back to FULL
SET @SqlStatement = 'ALTER DATABASE ' + DB_NAME() + ' SET RECOVERY FULL'
EXEC ( @SqlStatement )
-- Make sure it has been changed back to full
SET @SqlStatement = 'SELECT [name], [recovery_model_desc] FROM ' + DB_NAME() + '.sys.databases WHERE [name] = ''' + DB_NAME() + ''''
EXEC ( @SqlStatement )
------------------------------------------------------------------------------


If you want a copy of the source, let me know and I’ll either update this post with the source or email it to you.

A friend sent this to me and it is way fun!