SQL Server with Mr. Denny

October 3, 2011  1:00 PM

MVP Deep Dives, get your MVP Deep Dives … and get it signed

Denny Cherry Denny Cherry Profile: Denny Cherry

For those of you attending the SQL PASS summit, if you are interested in picking up a copy of the second edition of the MVP Deep Dives book you’ll have a chance to not only pick it up at the summit, but also get it signed by a large portion of the books authors.

There will be two signing sessions, the first on Wednesday from 1pm until 1:30pm between the expo and dining halls (4th floor).  The second session will be Friday morning from 7:15am until 8:am in room 211 on the second floor (by the escalators).  I make no claims to how awake, sober or polite the MVPs will be at 7:15am on Friday morning.

If you are wondering when you’ll have time to pick up the book before the Wednesday book signing session, the onsite book store will be open all day or Wednesday from the time the exhibit hall opens (if not earlier) and they are opening on Tuesday evening during the welcome reception so you can pick up a copy then.

If you can’t make it to the signing, or the author you were looking for isn’t there for some reason because they are still drunk then look for people wearing the “MVP Deep Dives Author” flag from their badges.  If you haven’t been to the submit before, you’ll see what I mean pretty quickly.

See you at the summit.


September 29, 2011  1:00 PM

SQL Karaoke 2011 powered by NEC and Genesis Hosting Solutions

Denny Cherry Denny Cherry Profile: Denny Cherry

So this is the all important SQL Karaoke wrist band post.  In order to get your SQL Karaoke wrist band you must head over the NEC booth on Wednesday during the exhibit hall hours and talk to the fine folks that will be working there.  If they decide that you are worthy they will grace you with an all powerful wristband which will get you some free drinks at Bush Garden that night. Now keep in mind that there are a limited number of wristbands available.

Now myself and our awesome NEC rep will be arriving at 9:30 at Bush Garden (possibly even together).  Anything you drink before 9:30pm IS ON YOUR TAB.  Once the tab is open its first come, first served.  Don’t be greedy, we have a budget so don’t be drinking all of it.  We want the budget to last so that everyone can enjoy our sponsors amazing generosity, so I’ll say it again, don’t be a putz.

When the drinks run out, they run out.  If you get there late and the budget is gone, then sorry.  Crying to me will get some big old puppy dog eyes with my most polite and heartfelt “so sorry”.  Once the budget runs out I’ll grab the mic and let you know that you’ll need to open your own tab in a way that is truly “me”.

If when you get to the NEC booth the folks there don’t know what you are talking let me know on Twitter or email and I’ll get my guy down there to straighten them out.  There shouldn’t be any problems, we’ve got their marketing department running the show there.

Don’t forget to tip the nice lady that brings you the drinks and the KJ who lets us abuse him for the night.


September 28, 2011  5:00 AM

SQL Server Days Early Bird Discount Ends Friday

Denny Cherry Denny Cherry Profile: Denny Cherry

If you haven’t had a chance to get signed up for SQL Server Days in Belgium (November 14th and 15th) now is the time.  The early bird discount ends Friday meaning that when you remember to sign up on Monday the price goes from €79 to €99.

Now if you aren’t interested in saving €20 then by all means wait until Monday, but if it was up to me I’d want to save that €20 for someone else (good beer comes to mind), so go and sign up now. I’ll wait.

Not sure why you want to go to SQL Server Days?

The answer to that is simple.  There is a lot of top name speaker talent flying in, and they want to meet you at the event.  You’ve got some of the biggest speakers in the community speaking at this event.  Chris Webb (blog) is going to be speaking on SQL Server Analysis Services and the new DAX queries.  Jennifer Stirrup (blog | @jenstirrup) will be talking about the iPad and PowerPivot and how to get BI solutions into the hands of mobile users.  Kevin Kline (blog | twitter) will be talking about thoubleshooting SQL Server and much, much more.

Now stop reading and go sign up already and save yourself the €20.  I’ll see you there on the 14th and 15th.


September 27, 2011  11:00 AM

Split Multi Plan File Application

Denny Cherry Denny Cherry Profile: Denny Cherry

Recently I was working with a client, and the client wanted to send me a batch of SQL Server execution plans (about 300 of them) in a single file.  Normally I would just connect to the SQL Server and view the queries from there, but the client hadn’t gotten me VPN access to their network yet, so that wasn’t an option.  I didn’t really want to copy and paste the plans from the text file that they sent me one at a time, so I threw a little app together and figured that I should post it online in case any one else runs into this problem.  Just give it the big text file and point it towards an empty folder then click go.

You can download this from my site at your leisure.


SQL Server Days 2011

September 26, 2011  11:00 AM

SQL In The City is comming

Denny Cherry Denny Cherry Profile: Denny Cherry

RedGate’s SQL In The City is coming to the amazing Skirball Center in Los Angeles just a couple of weeks after the PASS summit.  This is a great change to see some great presentations giving by some of the top speakers in the SQL Server community (who all happen to be great friends of mine).

The speakers (including myself) are:

All this for the amazing low price of zero, zip, nada, nothing.  If you’ll be in town, or you can be in town this is a great opportunity to get some absolutely amazing SQL Server training.  Now is the time to register for the event and reserve yourself a seat before they are all gone.

See you at the Skirball center, and at the party after.


September 22, 2011  7:00 PM

SQL Server MVP Deep Dives Volume 2 available for pre-order

Denny Cherry Denny Cherry Profile: Denny Cherry

As you may or may not know, the SQL Server MVPs put out a book last year called the SQL Server MVP Deep Dives in which the proceeds of the book went to charity.  The MVPs have done a second volume of the book with once again the proceeds of the book going to charity.  This time around we as a group chose Operation Smile as the charity.  Now this isn’t an update to the first book, but a totally different book done under the same premise.

A large number of the MVPs submitted topic ideas and those who’s ideas were accepted (they didn’t want 10 chapters on PowerShell for example) were asked to write a chapter on that topic.  My chapter was on Storage (shocking I know) and got put in as Chapter 5.  You can see the chapter list over on Manning’s site (they are the publisher).  Currently you can’t pre-order from Manning, but you can from Amazon.  If you wait until you can get the book from Manning directly the charity will get a few extra bucks, but if you don’t want to wait we all totally understand.

Rumor has it that there will be another SQL Server Deep Dives book signing at the PASS summit this year.  If you are interested in getting your book signed by a large number of the authors this is your chance.  There aren’t that many times when this many of the authors are in the same room at the same time.  There hasn’t been any announcement about where or when it will be, but you should be able to pick up a copy of the book at the PASS summit book store so you don’t have to lug a copy from home then back home again.  I know that when the MVPs did the last MVP Deep Dives book the book store did sell out and they had to do a rush overnight over to get more copies for everyone.

I’ll see you at the PASS summit, and hopefully you’ll be carrying around a copy of the new SQL Server MVP Deep Dives Volume 2.


September 22, 2011  2:00 PM

You may have noticed I now speak perfect Spanish

Denny Cherry Denny Cherry Profile: Denny Cherry

OK, so that’s a total lie.  I can barely ask for a beer correctly in Spanish.  However for my Spanish speaking readers you will not be able to find my blog posts in Spanish.  My good friend Felipe Zuñiga (blog | @felipezuniga_) has begun translating this blog into Spanish, which he is then posting up on his blog.

I’m not sure how far back Felipe will be translating (there are currently over 600 posts on this site, so I’m guessing that not all of them will be done), but many of the new posts that I write he’ll be translating.  I think this is awesome for Felipe to do as this will increase the amount of information available to people in their native language, and all done in his spare time.  If you see Felipe at a conference or user group meeting, be sure to buy the man a beer.  Translating technical content is probably about the hardest thing that you can do, and he is doing this all for free.


September 19, 2011  7:13 PM

Slide Decks for #sqlsat95

Denny Cherry Denny Cherry Profile: Denny Cherry

This last weekend was SQL Saturday 95, and it was a great event.  I was speaking during 5 sessions.  Three were my own sessions, and two were panels (one panel I did solo as my co-presenter got sick and couldn’t make it).  For my three sessions you’ll find my slide decks below.

Table Indexing for the .NET Developer

Indexing Internals

SQL Server Clustering 101

I hope that everyone had as good a time at SQL Saturday as I did.


P.S. Something to note, don’t leave early after your raffle ticket is drawn.  We had so many great prizes that we ran out of raffle tickets and had to start drawing evals from the box for prize winners, so you might have won something else if you stuck around till the end.

September 15, 2011  8:41 AM

Heading to Europe in November for 2 great events

Denny Cherry Denny Cherry Profile: Denny Cherry

I’ve managed to put together a nice two city European tour this November thanks to the SQL Server community and some good friends over there.

My first stop will be November 12th, 2011 for the SQL Zaterdag IV in the Netherlands (the site is in Dutch and hasn’t been setup for the next event, yet).  This is a good old fashioned SQL Saturday except that it isn’t listed on the SQL Saturday website.  Something about the SQL Saturday site only being in English, and everyone over there speaking Dutch.  Hopefully they don’t expect a presentation in Dutch, if they do it’s going to be a really long hour.  I suppose I’ll have to learn how to say “Hello, where can I get a beer” at the very least.  Good thing there’s a 12 hour flight to get over there.

My second stop will be SQL Server Days over in Belgium where the organizers have asked me to come and speak this November 14th and 15th; presented by SQLUG.be and Microsoft Belux.  I’m not up on the schedule (yet), I don’t even know what sessions I’m going to be presenting yet (they haven’t picked them yet) but I’m going to be there and having a great time with all the attendees (as soon as they pick the sessions I’ll be presenting I’ll post them here).  I can’t wait to see everyone there.  SQL Server Days is a two day conference with some Microsoft speakers on the 14th and community speakers on the 15th.

This is a great opportunity for me because I’ll get to meet some new people who hopefully have read some of my stuff before, so I can get some new feedback and make some new friends.  (This is one of the things that I love about going to new places to present is meeting new people.)

There are some great speakers that I’m really looking forward to seeing again, or for the first time, such as Kevin Kline, Chris Webb, Dandy Weyn and Jennifer Stirrup.  Cost for SQL Server Days is VERY reasonable.  If you register in September it’s €79, after that it is €99.

So if you are in Europe and you’ve got the time, you should come check out these two great events.  As soon as I’ve got more information about the sessions that I’ll be presenting I’ll be sure to get that information published.

Hopefully I’ll see you at one or both events,


September 12, 2011  7:08 PM

SQL Karaoke is getting sponsored, and you get the benefits

Denny Cherry Denny Cherry Profile: Denny Cherry

So this year for the first time ever we have some sponsors for SQL Karaoke at the SQL PASS summit. A few fine companies have offered to open up the bar for our enjoyment. There will be a limited number of wristbands available for drinks, so be sure to find me Wednesday during the summit to get yours (more details about when and where I’ll be handing these out to follow as we get closer to the summit).  Many thanks to our sponsors NEC and Genesis Hosting Solutions.  Their support of our event is nothing short of awesome.

NEC is a regular SQL PASS so be sure to go to their booth and give them some love at the summit. NEC offers a wide range of products including great storage arrays and some of the most highly available servers around which are great for running SQL Server on.

Genesis sadly won’t be at the SQL PASS summit this year but there were kind enough to sponsor us anyway.  If you see Genesis Hosting at another conference be sure to show them the love in the booth.  Genesis Hosting Solutions offers a wide variety of hosting and virtualization solutions designed to meet the needs of any company from needing just a few VMs to hosting an entire virtual production or DR facility with hundreds or thousands of virtual machines.

Thanks again to both sponsors for helping us out.

See you at the summit,


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: