SQL Server with Mr. Denny

February 20, 2012  2:00 PM

Cisco UCS and the dreaded unsupported-connectivity error

Posted by: Denny Cherry
Fabric Interconnects, UCS Manager, unsupported-connectivity

So while installing a new Cisco UCS system with the one of the newer builds of the firmware which was 2.0(1s) we were getting an error with both chassis which said they were in an unsupported-connectivity state.  The config that we setup was pretty basic and straight forward.  We have two UCS Fabric Interconnects, with two chassis, and two cables from each blade in each chassis going to the Fabric Interconnects.  There’s a diagram over there of what the system looks like for one of the two chassis (I love the fact that the management app makes nice diagrams like this).

When you configure a Cisco UCS system you tell the system how many cables the Fabric Interconnects should use to discover each chassis.  At least that is how the screen is worded.  What the setting actually means is how many cables should the Fabric Interconnects expect to see between each Interconnect and each blade in the chassis.  We configured the setting for “Platform Max” in case we decided to add more cables later even though we only had two cables now, and only planned on having 2 cables (as shown in the diagram) for the time being.  When we were set this way we had this strange unsupported-connectivity state error showing up for each of the chassis.

To fix this problem we had to change the discovery policy from “Platform Max” to 2 as shown in the below screenshot.

To make this change in the UCS Manager and select the equipment tab in the left menu.  On the right select Policies tab.  In the new lower tab menu select “Global Policies”.  From there you can change the Chassis Discovery Policy which you can see in the screenshot below.

Hopefully this helps you if you run into this problem.


February 16, 2012  2:00 PM

SQL Server isn’t always perfect

Posted by: Denny Cherry
sp_who3, SQL Server

SQL Server is a damn good product, but it sure isn’t perfect.  Like any good product out there people have come up with things that can be bolted onto the core to make SQL Server even better. Without these bolt on parts SQL Server looks a little dull.  But these bolt on parts may not make the engine run better, but they make it look a lot better and that makes us want to make the SQL engine run better.

Some of my favorites (in no particular order) include:

1. SSMS Tool Pack

The SSMS Tool Pack is a great add on for SQL Server Management Studio.  It’ll save you if SSMS crashes by auto saving all those unsaved SQL Scripts for you.  It’s got a great feature to help you read execution plans, a way to easily run a script against multiple databases, various templates, and much more.

2. SQLFool’s Index Rebuild / Defrag Script

Michelle (aka SQL Fool) has written a great Index rebuild and defrag stored procedure that anyone who is walking into a shop which isn’t going maintenance can take and throw onto the servers and happily know that the SQL Server will have some good maintenance being done automatically.  The script will do rebuilds online when possible, offline when it must and figures out the order that things should be done in.

3. sp_whoisactive

Adam was written sp_whoisactive and this is probably the gold standard is looking at what is causing SQL statements to wait, getting their execution plans, and a lot more.  I’m pretty sure that there is a switch in there somewhere that will tell sp_whoisactive to make me breakfast.  Adam has included loads of ways to filter the output so you can quickly and easily filter out all the spids that you don’t care about and get into the ones that you want.  You can even control the formatting of the output in a variety of ways so that it fits your needs.

4. sp_who3

I’m cheating a little on this one, as I’m the one that wrote sp_who3, but it’s my list and I’m allowed to do that.  sp_who3 will normally show the same output as it’s mild mannered cousin sp_who2.  But when you call sp_who3 and pass it a spid that you are looking for a massive dump of information about that spid is returned.  This dump includes the current statement which is being processed, the entire batch which is being processed, all the information formatted like the old sysprocesses table about all the threads for the SPID (very useful when seeing CXPACKET waits) and a ton of locking information.  While the output isn’t very pretty, its functional.  Personally I use sp_who3 to dig into parallel queries after I’ve done the initial identification of the problem using sp_whoisactive.  (While the site only says SQL 2005 as the newest version that version works just fine on anything newer than SQL 2005.

Now go download and install these bolt-ons to your SQL Servers.  I’ll wait…

Now that you’ve got all these bolt on parts installed, can’t you see how much nicer it is to work on the SQL engine.  It’s easier to get at the information that you need.  It’s easier to keep the system up and running.  And you want to work on the system more now that it’s prettier and easier to work on.  Much like my motorcycle is much prettier now that it has all those shiny parts bolted onto it.


February 13, 2012  2:00 PM

SQL Rally here I come

Posted by: Denny Cherry
In Person Events, SQL PASS, SQL Server, Storage, Virtualization

So I think it’s been kept pretty quiet so far, as I’ve been insanely busy the last few weeks, but I am so thrilled to say that I’ve been picked to present a pre-con at the SQL PASS Rally in Dallas, Texas either on May 8th or May 9th (I haven’t been told which day yet).  Either way I can’t wait to come down and talk about storage and virtualization with you, yes you, for the whole day.  If that sounds like something you’d be interested in then get signed up (as soon as registration opens) and we’ll have some fun learning and making fun of your favorite storage admin.


P.S. Don’t forget about my 4 day SQL Server 2012 class in Los Angeles in March and SQL Excursions in Napa, CA in May.

February 9, 2012  2:00 PM

Still Room Left In My SQL Server 2012 Class

Posted by: Denny Cherry
Class, SQL Server

If you are looking for some great SQL Server 2012 training so that you are up to speed on the new version I’ve got some good news for you.  There are still seats available in my SQL Server 2012 class in Los Angeles March 19th-22nd, 2012.  During this class we will cover a variety of subjects including installing/upgrading, deployment automation, AlwaysOn, the changes to T/SQL, planning a migration, the new enhancements to the BI presentation layer, as well as partitioning and data security.

Now don’t worry, this class isn’t just lecturer for four days.  It’ll be a very interactive class with labs to do through out the week to ensure that you’ve got a solid understanding of the concepts that we are talking about.  By the time you are done with this four day class you should be ready and able to begin upgrading SQL Servers to SQL Server 2012 successfully as well as be able to bring back the other portions of the class to share with the other departments within your company.


February 6, 2012  2:00 PM

Stop putting it off, it’s time to sign up for SQL Pre-Cons

Posted by: Denny Cherry
In Person Events, Performance, Query tuning, SQL Server, Tech Ed, Tech Ed 2012, Tech Ed Europe, Tech Ed North America

If you are headed to Microsoft’s Tech Ed North America or Tech Ed Europe you should really look at signing up for a SQL Server Pre-Con.  The pre-cons are full day sessions focusing on a specific topic, led by an industry expert.  In the case of the SQL Server pre-con “Microsoft SQL Server Performance Tuning and Optimization” you’ve got an all day session with SQL Server MVPs Denny Cherry (@mrdenny | site) and Thomas LaRock (@sqlrockstar | blog).

If you haven’t signed up for Tech Ed yet it appears that there are even some early bird discounts which are available for people that sign up before the end of February for Tech Ed North America and before the end of March for Tech Ed Europe.  This makes it an even better deal because who doesn’t like saving money.

Hopefully you’ll join us in Orlando for Tech Ed North America or in Amsterdam for Tech Ed Europe for a great day of SQL Server training.


P.S. Don’t forget about my 4 day SQL Server 2012 class in Los Angeles in March and SQL Excursions in Napa, CA in May.

February 6, 2012  2:00 PM

Drying Out a Wet Laptop

Posted by: Denny Cherry
Distaster Recovery, Laptop, SQL, SQL Server

The other day I had a VERY unpleasant situation happen.  I managed to dump a basically full 64oz (1.8 liter) cup of iced tea all over my desk.  In theory this shouldn’t be a problem but it landed right on top of one of my laptops.  Thankfully the laptop was off but it was plugged in when this happened.  Now I’ve dumped water on computer components before, and I’ve had a pretty good track record with getting things dried out pretty easily, so I figured that I’d share my little trick that I use with everyone.  It’s actually quite an easy process, and works with more than just electronics.  In fact I’ve even used it to dry out the inside of our car.  The method of choice?


Yep, that’s right good old fashioned white dinner rice, uncooked of course.  The reason that rice works is because rice makes an amazing desiccant.  For those who missed the episode of Numbers where they talked about desiccant’s, a desiccant is something that draws the moisture out of something else.  In the cast of the TV show it was drawing the water out of a dead body, in this case out of my dead laptop (they didn’t use rice in the show).  You know those little packets that come in just about everything that you buy, that say “Don’t eat” on them?  That’s a desiccant.

In the case of the laptop, I quickly unplugged it and pulled out the battery.  Then got a box a bit bitter than the laptop, and dumped a bunch of rice into the box, dropped in the laptop, which I then covered with more rice.  Then the battery and an HP TouchPad that got drenched as well.  Cover everything with a healthy layer of rice and let sit for several days.  The nice thing about this technique is that there’s no head, no chemicals, no cloth or paper towels to touch anything in the laptop.  Just the rice absorbing up any water in the laptop.

When doing this with a car, you can’t put the car in a box and fill it, so a slightly different approach is needed.  In my case we had a car door opened just a crack which let in rain water (yes it really does rain in Southern California).  Using a vacuum and towels we could only get so much water out, but we didn’t want to worry about the floor of the car rusting out.  So we pored about 10 pounds of white rice into the floor board of the car a waited about 6-8 hours for the rice to absorb all the water.  When we vacuumed out the rice everything underneath was nice and dry.

Back to the laptop.  I left the laptop in the rice for about a week in this case, and thankfully the laptop came back in perfect working order.

To pull this off I used about 15-20 pounds of rice total.  When I dumped the cup Kris went to Costco and picked up a 50 pound bag of rice and I used a large bowl to get it into the box.

Hopefully you never have to use this trick, but if you do there it is.


February 2, 2012  2:00 PM

Getting TweetDeck 0.38.2

Posted by: Denny Cherry
Social Commentary, Twitter

In case you missed it Twitter released v1 of TweetDeck, and it sucks.

All however is not lost as the folks at codelog.org have posted the Air 0.38.2 version of TweetDeck.Apparently the guy over at codelog.org has taken his site down. Here’s another download site.

So if you need to rebuild your computer and you want to get a version of TweetDeck that doesn’t suck you can download the old version from codelog.org and keep the usable version instead of the garbage which is TweetDeck 1.0.  Hopefully Twitter will make TweetDeck 2.0 actually usable. Until then we have 0.38.2.


January 29, 2012  2:00 PM

Slide Decks for SoCal Code Camp

Posted by: Denny Cherry
In Person Events, SoCal Code Camp, SQL Server

Here are my slide decks from SoCal Code Camp last weekend.

Indexing for the .NET Developer

Table Partitioning

I had a great time as always, and I look forward to seeing everyone at the next event.


January 26, 2012  2:00 PM

What’s in my laptop bag?

Posted by: Denny Cherry
Social Commentary, SQL Server, Travel

The year of 2012 will be the first year that I’m expecting to fly over 100,000 miles.  So far I’ve got three flights to Seattle that have happened or are scheduled.  Four flights to Europe planned, random flights to Orlando, Atlanta, New York, San Francisco, Las Vegas, and Tuscon (among others).

In 2011 I did pretty good at about 52,000 miles during the year.  I get pretty amazed by all the crap that I have crammed in my laptop bag.  If you’ve ever wondered just what it takes to get me around the world and back again without going stir crazy here’s what is in my laptop bag.

That’s about it.  You’ll notice a few things that you might expect to see that you don’t, like paper, pens, etc. as I rarely travel with paper and pen any more as I use my iPad for note taking at conferences, meetings, etc.  When I carried paper with me, it usually went in a pretty nice looking leather folder it actually reduced quite a bit a weight when I removed the paper and pens.

Now getting all this stuff through security can be a royal pain some times.  Best case getting all this passed the idiots highly professional personal at TSA means throwing the laptop in one bin, iPad and kindle in a second bin and shoes, belt, jacket, etc. in a third bin.  However on occasion I get a TSA monkey agent who decides that all the cables in my laptop bag are an issue and they decide to dismantle my laptop bag to make sure that all the cables are acceptable for getting on the plane.  You see I have all the cables wrapped with Velcro strips so that I can keep the cables from getting all over the place and keep them from taking up to much space.

And of course none of this includes clothing, SWAG, or anything else in my normal luggage.


January 23, 2012  2:00 PM

Speaking in Poland as SQLDay 2012

Posted by: Denny Cherry
Consulting, SQL Server

I’m thrilled to announce that I’ll be speaking at another great event in Europe.  This time at SQL Day 2012, which this year is growing from a one day event to a three day event.  This great event is being hosted in Wroclaw, Poland May 24th-26th, 2012.  I know that not all the details for the event have been ironed out yet, but I know that I’ll be giving a presentation on Storage, and I’ll be giving a keynote talk on something (I haven’t really decided what, but I’m sure it’ll include SQL Server 2012 and probably bacon).

Personally I can’t wait to get there and meet all the new faces, not to mention say hello to some old friends including the other announced speakers such as Chris Testa-O’Neill, Jen Stirrup, Neil Hambly to name just a few.  There is a SQLDay 2012 Community Night in the planning which I know basically nothing about yet, but it looks like it’ll be a lot of fun.  According to the SQLDay 2012 site…

… we plan to meet Friday evening at SQLDay 2012 Community Night, where you will be able to get to know, talk with the speakers, make new contacts …

I don’t know about you, but that sounds like a pretty good community night to me.

As a side note, if you would like to talk to me about some on site consulting rates in Poland around the same dates please let me know and we can get something scheduled.  I’d love to extend my stay for a few extra days.


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: