Nathan v Wilson

In the past off season, the Tigers were rumored to be in the running to sign closer Brian (The Beard) Wilson as well as who they eventually signed, Joe Nathan.

As of June 9, 2014, here is a comparison of Nathan and Wilson. Stats are very close. Almost equally horrible.

GP IP H R ER HR BB SO W L SV HLD BLSV WHIP ERA
Nathan 25 23 25 18 18 4 11 21 2 2 13 0 4 1.57 7.04
Wilson 25 20.2 23 15 14 3 16 26 0 2 0 8 1 1.89 6.10

Updated stats as of the All-Star Game. Even closer.

GP IP H R ER HR BB SO W L SV HLD BLSV WHIP ERA
Nathan 36 33.2 37 22 21 5 14 35 4 2 19 0 5 1.51 5.61
Wilson 37 30.1 34 20 19 3 23 35 1 3 1 14 2 1.88 5.64

SQL 2008 upgrade to SQL 2012

Background

Our SQL 2012 project started with getting a sandbox VM configured. Installing SQL 2008 and subsequently upgrading the instance to SQL 2012. Went swimmingly. No real issues.

The First Upgrade
We scheduled the upgrade of our development instance for April 23, 2014. I kicked off the installer at 4:01pm ET on 4/23/2014. At approximately 4:45, I was presented with this error:

Error1

TEXT: The folder ‘’ does not exist. The folder is expected to exist to set permission on it. Examine why the folder does not exist and recreate it.

Quick aside: The error message is pretty specific and anybody that takes the time to read it would know what the problem is. This is really all you want from an error message, so kudos to Microsoft for this portion of it.

Before clicking OK, I went out to my drive to look at my directory structure. Turns out, there must have been some issue when I first installed this instance because the directory structure looked like this:
F:\MSSQL10.SQLDEV\MSSQL\Data\
–This contained all of my databases

F:\MSSQL10.SQLDEV\MSSQL\Data\MSSQL10.SQLDEV\MSSQL\DATA
–This had just been created in the last few minutes

F:\MSSQL10.SQLDEV\MSSQL\Data\MSSQL10.SQLDEV\MSSQL\DATA.OFF
F:\MSSQL10.SQLDEV\MSSQL\Data\MSSQL10.SQLDEV\MSSQL\JOBS.OFF
F:\MSSQL10.SQLDEV\MSSQL\Data\MSSQL10.SQLDEV\MSSQL\LOG.OFF
–These were empty and apparently created during the installation, but I then reconfigured SQL to not use them. Or, so I thought 

So, I renamed the ‘jobs.off’ and ‘log.off’ directories to remove the ‘.off’ portion. Easy enough. I find it really interesting that the installer created its own Data directory, but wouldn’t do that for the JOBS directory.

I then clicked on OK in the error dialog hoping the installer would retry the operation and continue. No dice on that.

About 2 minutes after clicking OK, the upgrade process finished with this lovely dialog.

DEV_image2

There is nothing quite like seeing RED on your summary screen. Summary is basically saying that everything worked, except for the database engine. You know, the most important part. The heart of everything. That part failed, but hey…your tools will work.

I also received a message that the computer needed to be restarted. So, of course, whenever there is an error first step is to reboot. So, I did that.

After the reboot, I ran the SQL 2012 setup.exe again (right-click, run as Administrator). Went through all of the beginning dialogs without an issue, setup rules, checks, product key, blah, blah, blah. When I got to the ‘select instance’ page, it correctly listed the SQL 2008 instances as well as both the SQL 2008 and 2012 versions of the shared components.

DEV_image3

I chose our DEV instance to upgrade and clicked Next and was moved to the ‘select features’ screen.

DEV_image4

The instance was pre-selected and I couldn’t click or unclick anything, so I just clicked next of course and was given this error.

DEV_image5

TAG: There are validation errors on this page. Click OK to close this dialog box. Review errors at the bottom of the setup page, then provide valid parameters or click Help for more information.

At the bottom of the screen is “there are no features selected for upgrade.”

What do you mean there are no features selected for upgrade? The instance is selected right on the same screen!

This was the time I started spinning my wheels for probably 30-45 minutes. A lot of looking at things on the server, rebooting the server and Googling everything I could think of.

I found a lot of blogs that spoke about this ‘no feature selected’ error, but their ‘select feature’ dialog didn’t list their instance properly. This was not my situation.

I also found a number of blogs that indicated I needed to uninstall my instance. This was not going to happen as my DEV instance was still fine – it was still SQL 2008 and was functional.

Of course, throughout this, I had reviewed my logs in the C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log directories. I finally found the big clue in the file “Summary_A2SQLDEV01_20140423_171837_GlobalRules.txt”. Here is one section of the file (I removed a couple columns for readability sake):

Product features discovered:

Product Instance Instance ID Feature
SQL Server 2008 sqldev mssql10.sqldev Database Engine Services
SQL Server 2008 sqltest mssql10.sqltest Database Engine Services
SQL Server 2008 Management Tools – Basic
SQL Server 2008 Management Tools – Complete
SQL Server 2008 Integration Services
SQL Server 2012 sqldev.inactive mssql11.sqldev Database Engine Services
SQL Server 2012 Management Tools – Basic
SQL Server 2012 Management Tools – Complete
SQL Server 2012 Integration Services

The clue is that there is a SQL 2008 “SQLDEV” instance as well as a SQL 2012 “SQLDEV.inactive” instance. What the heck? I thought it was upgrading my instance, not creating a new ‘inactive’ one? But, OK. hmmm.

At least I had a new keyword to Google with. I read a few more things and developed a strategy to remove the ‘inactive’ or ‘orphaned’ instance.

First, determine the ProductCode (GUID) of this inactive instance, then uninstall it from the command line and then retry the upgrade.

Determine product code:
In the log directories for the most recent failed attempt, I went to the Datastore directory and found the file “Datastore_Discovery.xml”. I opened this and searched for the keyword ‘inactive’. Found it. I then located the product code in the same section of the XML file.

Uninstall:
Now that I had the ProductCode, I should be OK to uninstall it. But, being the cautious person that I am, I wanted to verify that this ProductCode was actually for SQL 2012 installation (and NOT either of my functional SQL 2008 instances), so I opened regedit and searched for 19B2A97C-02C3-4AC7-BE72-A823E0BC895A. I only found one occurance of it and it was specifically for SQL 2012, so I was confident.

I opened a command line and executed “msiexec /x {19B2A97C-02C3-4AC7-BE72-A823E0BC895A}.

This brought up a very generic and ominous “are you sure you want to uninstall this product” dialog (it does not indicate what the product is). After clicking yes or OK, a SQL 2012 screen appeared and within a minute it was completed.

Things looked clean.

I restarted the installer from scratch. Went impatiently though all of the screens waiting to get to the feature selection. When I got there and clicked next, the dialog moved to the instance configuration screen! Success. I clicked though the rest of the prompts and started the upgrade. After a short 7 minutes, I got this beautiful message.

DEV_image6

I rebooted the server and then started the installation of CU8. It was slow, but was progressing. After about 10 minutes, my remote desktop session disconnected and wouldn’t reconnect. I tried pinging my DEV server with no reply. VM had crashed? In the middle of the upgrade? How in the world would SQL Server installer handle this? My evening was shot.

I contacted our support guys and shortly after my pings started getting answered, I got the ‘OK , try again’ email. As I logged back in, I didn’t know what I’d find in terms of a broken instance. But I was greeted with the wonderful “upgrade progress” dialog. The session had continued to run the entire time I couldn’t get to it. The VM had not crashed, the problem was just with my communicated with the VM. Phew!

Another 15 minutes of waiting before I got this:

DEV_image7

Done!!!

 

 

Tags: SQL 2008 2012 UPGRADE INSTALLATION ERROR FEATURE FOLDER DIRECTORY

 

Richard Sherman and Erin Andrews

Immediately following the Seattle Seahawks NFC championship game victory over the San Francisco 49ers on January 19, 2014, Erin Andrews interviewed Seahawks cornerback Richard Sherman. Here is the interview.

Sherman has been widely and viciously attacked for his over-the-top rant.

A little context

  • Sherman had just completed the biggest game of his life.
  • He had just made the biggest play in that game.
  • His team had just advanced to the Super Bowl.
  • Sherman is a very emotional, loud, trash-talking player. This is well known.
  • After the final play of consequence (not including the kneel downs), Sherman was pushed in the face by Michael Crabtree.
  • I think it is a safe assumption that Crabtree and Sherman were jawing at each other for the entire game.
  • So, after all this, Erin Andrews and her producers at Fox decide to get Sherman live on camera immediately after the final gun sounds.

A few questions

  • Was the end result not predictable?
  • Was it not understood that he would be emotional with tons of adrenaline flowing?
  • Did Fox hope that he would say something loud and perhaps over the line? Or at least near the line?
  • If Fox truly didn’t want this to happen, were they stupid enough to not expect it?
  • Could they have recorded the segment and aired it 30 seconds later if it was appropriate?
  • Could they have waited 10 minutes to interview Sherman?
  • Were there not other players available for comment?

My Take

Sherman is a human being. He is not a robot. To expect him to complete this game one second and flip the switch to non-game mode the next second is stupid and naïve.

We want our football players to be aggressive. They have to be aggressive to be employed at the NFL level. We want them to rise to the occasion at the most important and most stressful times. Is it fair to expect these same players to be aggressive, violent AND to be subdued immediately following a game?

The analogy I would draw is some of the new ‘targetting’ rules in the NFL. We want defensive backs to be aggressive and not give up receptions or big plays, but if a receiver lowers his head 6 inches, they are supposed to hold up and not complete the hit they have been making their whole lives. Again, these are people not robots.

I am not a Seahawks fan. I am a long suffering Lions fan. I had not dog in the race in the NFC title game, but I think Sherman was fine and is being wrongly criticized. If you are angry for what happened, blame Fox and Erin Andrews. Although, I think Andrews handled the outburst as well as possibly could be expected of her. But, she truly only has herself and anybody in the Fox booth to blame.

2013 Michigan v 2012 Michigan State

2014 UNIVERSITY OF MICHIGAN TEAM: GOOD OR NOT?

The UM football team underachieved in the 2013 season. They finished 7-6 after they were embarrassed in their bowl game. They played some close games, but so what, close isn’t good enough. They were probably 4 plays away from being 11-1 in the regular season (with the only clear loss coming against MSU).

But, could close games in 2013 mean anything for the 2014 season? Maybe. To believe this is even a possibility, you just need to look at the 2012 Michigan State University team; keeping in mind that the 2013 MSU team put up an incredible 12-1 season, including a Big Ten championship and a Rose Bowl victory.

Following the 2013 UM season, newly hired offensive coordinator David Nussmeier famously said this: “We were 11 points away from being 11-1″.

Following the 2012 season, MSU head coach Mark Dantonio made this statement: “When you look at last season, we were so close in so many different areas from having another 10, 11-win season”

Granted Dantonio didn’t identify the exactly number of points in his statement, but the sentiment is the same as the Nuss statement. They were very close to having a very good season.

Both teams were very unlucky at times. They were both bad at times and they both had some good moments.

So, this got me thinking….how similar were these two teams? Lets look.

RESULTS

  Record Bowl Close Losses Close Wins
2012 MSU 7-6 Buffalo Wild Wings Lost 5 by 13 points Won 4 by 12 points
2013 UM 7-6 Buffalo Wild Wings Lost 4 by 11 points Won 3 by 15 points

Had MSU lost all their close games, they would have gone 3-10. If they had won all the close games, they’d have been 12-1. Had UM lost all their close games, they would have gone 4-9. If they had won all the close games, they’d have been 11-2. Of course, if they had lost all close games, both teams would have played one fewer game due to not being bowl eligible.

Truly astounding how close those numbers are.

Here are some schedule-related similarities. Also amazing.

  1. MSU started the season with a win over a ranked team in Boise State. They then had a blowout win over CMU.
  2. UM started the season with a blowout win over CMU. They then beat a ranked Notre Dame team.
  3. Each team had comfortable wins over Minnesota.
  4. Each team lost to Iowa by 3 points.
  5. Each team lost to Nebraska by 4 points on their home field.
  6. Each team lost to Ohio State by a single point on their home field.
  7. UM beat MSU in 2012. MSU beat UM in 2013.

Weird, huh?

OFFENSIVE STATISTICS

  Passing Yards Rushing Yards Total Offense First Downs Turnovers
2012 MSU 209.9 149.4 359.3 10.7 18
2013 UM 247.8 125.7 373.5 11.4 21

Again, very close. Passing yards shows a clear advantage towards 2013 UM, while the rushing yards is equally slanted towards 2012 MSU. Lets look at the players that put up those numbers.

QUARTERBACK STATISTICS

  Attempts Comp Yards Comp Pct TD INT
Andrew Maxwell (MSU) 466 234 2606 52.5 13 9
Devin Gardner (UM) 345 208 2960 60.3 21 11

Gardner was clearly superior in 2013 than Maxwell was in 2012. I don’t think many people would argue with this.

COACHING CHANGES

The 2012 MSU team’s play calling duties were in the hands of offensive coordinator Dan Roushar, who left MSU to work for the New Orleans Saints following the 2012 season. He was replaced by Jim Bollman, who along with Dave Warner called the offensive plays in the turnaround 2013 season.

The 2014 Michigan team will only have one coaching change of note from the 2013 team and that is the firing of Al Borges and subsequent hiring of Dave Nussmeier as offensive coordinator. This means a new play caller for the coming season.

DIFFERENCES

There are a few glaring differences between the two squads. Rushing offense and overall defense are the biggest.

RUNNING BACK STATISTICS

  Carries Yards TD Receptions Yards TD
Le’Veon Bell (MSU) 382 1793 12 32 167 1
Fitz Toussaint (UM) 185 648 13 18 203 0

Le’Veon Bell was probably the single biggest difference between these two teams. Michigan had nobody that even comes close to what he produced. But Bell was not on the team the following year when MSU had the big turnaround.

DEFENSIVE STATISTICS

  Passing Defense Rushing Defense Total Points Allowed
2012 MSU 175.8 98.6 274.4 212
2013 UM 231.3 140.2 371.5 349

WOW. Yeah, I guess its safe to say MSU defense was considerably better. And their defense improved even further from 2012 to their big 2013 season.

BOWL GAME

The other difference, and I’m not sure if it is a ‘big’ difference or not, is the results in the Buffalo Wild Wings Bowl. MSU beat TCU 17-16 in the 2012 BWW Bowl. UM was housed by Kansas State 31-14 in the 2013 BWW Bowl. Does this provide momentum heading into the following season? I doubt it especially when there is large turnover of players. But, as a program, it might add a little bit of confidence and swagger.

CONCLUSIONS

So, does this stuff mean anything? ANYTHING AT ALL?

If nothing else, it shows an incredible similarity between these two teams. Both underachieved. Both lost close games. Both lost games at home and on the road. Both won close games. Both turned the ball over too much. Both were very disappointed in the results of the season.

Obviously, we do not know until the 2014 season rolls around, but I think it at least shows a season based on close losses can possibly lead to a much better season the following year. The other possibility is that MSU having core strengths of defense and rushing is a much better foundation for success in future years than UM’s core strength of … of … help me out here. What was their strength?

Winter Vortex 2014 Comments

Comments about the weather in January, 2014.

Bo Schembechler: “Anybody complaining about Michigan weather isn’t a Michigan Man.”
Mark Dantonio: “Last night, I dreamt about summer. Dream big, people, dream big.”
Tom Izzo: “If its too cold for you, then you have become a little too fat and sassy.”
Brady Hoke: “Sure, it’s cold. Its winter in Michigan fergodsakes.”
Matt Millen: “This cold is more valuable than a first round wide receiver.”
Brent Musberger: “The only good thing about this weather is seeing Katherine Webb’s nips.”
Jim Leyland: “It’s so damned cold that I only went outside for a smoke 25 times today.”
Barack Obama: “This weather is a clear signal that both sides of the isle must work together to eliminate the power of the meteorologist.”
Nancy Kerrigan: “WHYYYYYYYYYYYYYYYYYYY is it so cold.”
Tonya Harding: “Shuck the fuck up, Nancy.”

Teams younger that I am

How much older are you than professional sports teams?

imagesimages2 images3

Here is an exercise anybody take do. It is a way for sports fans to show their age.

This is a list of all professional franchises in the NBA, NFL and Major League Baseball that were either created or relocated (and renamed) after my birth.

NOTE: I excluded NHL for now because it would take a lot more work as I do not know a lot of the teams well enough. Will add it later.

MLB

Arizona Diamondbacks
-First Season in 1998.

Colorado Rockies
-First Season in 1995.

Los Angeles Angels
-Renamed from Anaheim Angels in 2005.
-Renamed from California Angels in 1997.

Miami Marlins
-Renamed from Florida Marlins in 2012.
-First Season in 1993.

Seattle Mariners
-First Season in 1977.

Tampa Bay Rays
-Renamed from Devil Rays in 2008.
-First Season in 1998.

Toronto Blue Jays
-First Season in 1977.

Washington Nationals
-Relocated from Montreal (Expos) in 2005.
-First season in 1969.

Teams new or changed in my lifetime: 8
Total teams in MLB: 30
Percentage of MLB teams that are new in my lifetime: 26%

NFL

Arizona Cardinals
-Renamed from Phoenix Cardinals in 1994.
-Relocated from St Louis in 1988.

Baltimore Ravens
-Relocated from Cleveland (Browns) in 1996.

Carolina Panthers
-First Season in 1995.

Cleveland Browns
-First Season in 1999.

Houston Texans
-First Season in 2002.

Indianapolis Colts
-Relocated from Baltimore in 1984.

Jacksonville Jaguars
-First Season in 1995.

Oakland Raiders
-Relocated from Los Angeles to Oakland in 1995.
-Relocated from Oakland to Los Angeles in 1982.

St Louis Rams
-Relocated from Los Angeles in 1995.

Tennessee Titans
-Renamed from Tennessee Oilers in 1999.
-Relocated from Houston (Oilers) in 1997.

Teams new or changed in my lifetime: 10
Total teams in NFL: 32
Percentage of NFL teams that are new in my lifetime: 31%

NBA

Brooklyn Nets
-Renamed from New Jersey Nets in 2012.
-Renamed from New York Nets in 1977.

Charlotte Bobcats
-First Season in 2004.

Indiana Pacers
-First Season in 1967.

Memphis Grizzlies
-Relocated from Vancouver in 2001.
-First season in 1995.

Miami Heat
-First season in 1989.

Minnesota Timberwolves
-First season in 1989.

New Orleans Pelicans
-Renamed from New Orleans Hornets in 2013.
-Relocated from Charlotte (Hornets) in 2003.

Oklahoma City Thunder
-Relocated from Seattle (Supersonics) in 2008.

Orlando Magic
-First season in 1989.

Toronto Raptors
-First season in 1995.

Utah Jazz
-Relocated from New Orleans in 1979.
-First season in 1974.

Washington Wizards
-Renamed from Washington Bullets in 1997.

Teams new or changed in my lifetime: 12
Total teams in NBA: 30
Percentage of NBA teams that are new in my lifetime: 40%

Summary

Total teams in MLB, NFL and NBA combined: 92
Teams new or changed in my lifetime: 30
Percentage of NBA teams that are new in my lifetime: 33%

33%! Holy CRAP!!!

1/3 of all teams have changed or were founded since I was young. That is crazy. Just one more sign that I am older than I feel.

Sunset

The view of aging from a man in his 40′s.

Sunset

Sunset

When the sun begins its long ascent

to the sky;

one thinks it will never reach its peak.

When the sun hovers overhead

during mid morning;

one thinks it is their own shine

permanently placed to keep them beaming with youth.

When the sun begins its short descent;

doubts and second thoughts

begin to creep.

One starts to wonder what it will feel like

watching the sad, sad sunset.

Wondering if a mark,

or an everlasting imprint;

will be left behind.

The goals of youth, long past;

realities of age, fresh.

Dark thoughts persist;

fearing what it will be like

to leave this life

falling far short of youthful dreams.

Sadness fills;

thinking that the sunset will come

far too soon.