SQL Server with Mr. Denny


May 14, 2012  2:00 PM

Be careful which node you install a clustered instance from

Denny Cherry Denny Cherry Profile: Denny Cherry

While installing a clustered SQL Server instance recently I ran across a bit of an annoyance.  When I was going through the SQL Installation process I didn’t pay any attention to which node of the cluster currently owned all the disks that I was planning on using for SQL Server.  Because of this when I got to the Data Directories screen none of the drives would validate.  This was because all of the disks were owned by the other node of the cluster.

There’s a few different ways to solve this problem.

  1. Run the installer on the other node.
  2. Move the available storage to the node you want it on via the command line.
  3. Down the node which is hosting the storage.

Option 1 pretty much sucks as you are about 1/2 way through the installer by the time to figure out this is a problem, but it will work.

Option 2 is a great solution, but you can’t do it via the Failover Cluster Administrator in Windows 2008 R2.  You have to use a command line tool called cluster.exe.  The syntax is as follows:

cluster group “Available Storage” /move:{New Node Name}

Option 3 is the fastest.  Just right click on the node in the Failover Cluster Administrator and select more options, then “Stop Cluster Service”.  Everything will failover to another node.  If you have a two node cluster this works fine, if you have a cluster with 3 or more nodes this probably won’t work very well.

Hopefully if you run into this annoying little issue, this will help you solve it.

Denny

May 10, 2012  2:00 PM

Presenting is Actually Hard Work

Denny Cherry Denny Cherry Profile: Denny Cherry

As I’ve been going through the process of getting my slide decks for Tech Ed, SQL Server Day 2012 and SQL Rally I’ve recome reminded that this whole process of writing presentations is actually pretty hard work.  Writting abstracts and getting them submitted is the easiest part of the entire process.  After that comes the nerve racking step of waiting for the approvals to be sent out.

Once you have been approved it’s time to being the brutal part of preparing the slides and demos and getting them submitted to the conference for their approval.  While it may appear like there is lots of time between the session abstracts being submitted and the conference actually happening, you can’t actually wait all that long to get everything completed.  This is because the side decks are due long before the actual conference happens.  This is done to ensure that the slides are complete, correct, and are ready to be used at the conference.  Speakers are obligated to submit their slide decks on time, and basically complete on what ever date the conference has specified.

It doesn’t really matter what level of conference you are dealing with, or how much experience you have as a speaker you must, as a speaker, have your matterials done on time and ready to be completed.  While you can always make minor tweaks and changes to the presentation the bulk of the presentation shouldn’t be changing after it is submitted and approved.


May 7, 2012  2:00 PM

SQL PASS 2012 First Timers Webcast

Denny Cherry Denny Cherry Profile: Denny Cherry

As the SQL PASS 2012 Summit is quickly approaching I’m announcing, well in advance, that I’ll be doing a another First Timers webcast.  The web cast won’t be for a while, but I wanted to start getting the word out there now.  I’ll be giving a repeat of my very popular webcast from last year on October 17th, 2012 at 1pm Pacific / 4pm Eastern.

You can sign up for the session here and get the meeting reminder and I’ll send out a reminder as the webcast gets closer as well so please use an actual email address.  Of course I won’t be giving anyone access to your information.

Thanks,

Denny


May 1, 2012  2:00 PM

Here is May, the month of Travel

Denny Cherry Denny Cherry Profile: Denny Cherry

So it appears that May is going to be one of the busier travel months for me this year (at least so far).  With three important week long events scheduled for this month it’s going to be a hell of a month.

First is SQL Rally where I’m in Dallas Texas from May 7th-12th (I’ve got a pre-con on the 8th and I want to be able to relax with friends Friday night before heading home no Saturday).

Next is SQL Excursions May 16th-20th. (Last chance to sign up to win a free ticket from Confio Software is basically now.)

After that is SQL Day 2012 is Poland where I’m giving a pre-con, the conference key note and a couple of regular sessions.

Don’t worry, that’s not everything.  I’ve also got on site work with clients and a data center migration to do between SQL Rally and SQL Excursions.

Basically the reason that I’m writing this is so that if you email me during May (or June as it’s not much better with two TechEd conferences back to back) don’t expect a prompt reply.  Do expect the longest craziest out of office response you’ve ever seen.

Denny


April 30, 2012  2:00 PM

New SQL Server 2012 Book Published

Denny Cherry Denny Cherry Profile: Denny Cherry

One of the many projects which I had the pleasure of working on during the second half of 2011 and the first quarter of 2012 was Wrox’s Professional SQL Server 2012 Administration which was just recently published.  Now I didn’t write the whole book, hell I didn’t even write 1/4 of the book but I worked with a great team of other authors who were Adam Jorgensen, Steven Wort, Ross LoForte, Brian Knight, Robert Cain, Jose Chinchilla, Audrey Hammonds, Scott Klein, Jorge Segarra and Gareth Swanepoel.

Now normally on a book project like this you’d be an author or an editor.  I got to play both roles giving Jason Strate an assist with the editing duties (obviously Jason did all the tech editing on my chapters).

As always you can find this book listed on my books page over on my website (www.mrdenny.com) so you can find it and all the other books which I’ve worked on over the years over there including some handy links over to Amazon where you can check out the books via the “Look Inside!” feature that Amazon offers where you can check out the books before actually purchasing.

Hopefully you get a copy of the book and enjoy it.  It was a bit of a painful process for all of us, but it was great to be working on the project with such a great group of people.

Denny


April 26, 2012  2:00 PM

Securing SQL Server 2nd Edition Coming Soon

Denny Cherry Denny Cherry Profile: Denny Cherry

In case you missed my announcement earlier this week over on SecuringSQLServer.com

I’m pleased to be able to announce that the 2nd edition of Securing SQL Server is going to be available soon.  It’s just been made available for pre-order on Amazon.com.  The second edition comes in at about 350 pages (according to Amazon, I don’t actually have a copy of it yet) while the first edition came in at about 270 pages so there has been a LOT of material added to the book.

While a lot of the new information is focused on SQL Server 2012, there is also a lot of new material which relates to older version of SQL Server including chapters on SQL Server Analysis Services and SQL Server Reporting Services, information on Instant File Initialization, EXECUTE AS, Database Firewalls, SAN Security, Actual Data Security (no idea how this got missed the first time around, but that’s to Brent Ozar for pointing it out).

As far as the SQL Server 2012 information you’ll find updated information about the SHA2 hashing algorithms, Securing AlwaysOn Availability Groups, Security and SQL Server Clustering, Security and Contained Databases and a lot more.

If you already have a copy of the 1st edition I encourage you to take a look at the second edition as well.  I know that it’s really soon for a second edition of a book (the first edition just came out February 2011, but this new edition comes on the release of SQL Server 2012.

Hopefully you pre-order you copy today.

Denny

P.S. Yes this edition will be available for the Kindle as well, that takes a little time.  As soon as I know that it’s been posted for the Kindle (usually happens a little after Amazon gets the physical books) I’ll post another announcement here.

P.P.S. If you visit my SecuringSQLServer.com site I’ve updated everything there for the new edition.  You can always find the old edition listed on the Other Books page on that site or on the Books page on mrdenny.com.


April 23, 2012  5:25 PM

What’s wrong with the University of Florida?

Denny Cherry Denny Cherry Profile: Denny Cherry

This past week the University of Florida decided that they no longer need to teach their customers (let’s be realistic with decisions like this, colleges don’t have students anymore they have customers) Computer Science. This is doing a major disservice to the customers of the University of Florida. Computer Sciences (and STEM in general) are the future of the American economy. Without offering Customer Science as a major many of the students won’t be able to compete in the work force.

What makes this even more insane is that this only saved about $1.7M and the University of Florida then decided to increase the athletic budget by more than $2M. This just goes to show that the University of Florida doesn’t give a damn about their customers and they only care about making more money to put into their big pile of money. If this wasn’t the case they money would be getting put into something that didn’t make a profit (like teaching students) instead of things that do make a profit (like football).

Now I’m not against sports, let me get that out there before I start getting hate mail from people.  And while sports is fun and a great way to get publicity for the school, if the school is really, really lucky one of the guys on the football team per year will be drafted into the NFL, while everyone with a CS degree will end up working somewhere doing something with computers.  Based on those numbers alone you would think that the Computer Science department would be worth spending a few dollars on.

Now I received a couple of replies on Twitter when this first came out saying that the University of Florida didn’t have a very good Computer Science program.  And frankly with an annual budget of $1.9M I’m not that surprised.  With needing to keep software refreshed, paying teachers, etc. $1.9M doesn’t exactly go all that far.  If they were sick of having a really poor Computer Sciences department maybe they should have found a way to raise the budget for the department and brought in some industry professionals as guest speakers to try and breathe some life into the department instead of just shutting the doors on the department and being done with it.

I’m done ranting.  Back to your regularly scheduled programming.

Denny


April 23, 2012  2:00 PM

Windows Hot Fix makes SQL 2012 AG’s fail over faster

Denny Cherry Denny Cherry Profile: Denny Cherry

Microsoft has recently released hot fix 388724 under MS KB 2687741 which resolves a performance issue when failing over a SQL Server 2012 Availability Group from one replica to another.

The basic jist of the problem is that there was an issue with the inter-node communication within the Windows cluster which caused the AG to take longer than expected to fail over.

If you are having this problem I’d recommend reading this MS KB and getting the hot fix installed on your cluster.  As this is just a hot fix and not a service pack (it should be included in Windows 2008 R2 SP2) I’d recommend only installing this if you are having the problem it shows.

Denny


April 19, 2012  2:00 PM

AlwaysOn and your application source code

Denny Cherry Denny Cherry Profile: Denny Cherry

One of the things that people will need to change to their applications when using AlwaysOn under SQL Server 2012 will be that the applications will need to have retry logic added to the application so that if the SQL Server is down that the application can retry the connection.

Now this shouldn’t be anything new to the application developers as even today there’s nothing that says that the SQL Server database will always be available.  Instead of failing the application on the first connection attempt, or the first time that the command was run, the command should be rerun, probably a couple of times.  Now if the error that you get back is from the SQL Server itself you don’t want to retry.  You’ll only want to retry if the database was up and you got back a normal error message.

If you are working with SQL Azure this same logic applies to your application there as well.

While I’d love to provide you with some sample source code here, I’m not a .NET developer and the last thing that you want me doing is writing .NET source code so I’ll leave that for the .NET professionals.

Denny


April 18, 2012  8:30 AM

Storage and Virtualization in Poland May 24

Denny Cherry Denny Cherry Profile: Denny Cherry

Come and join me in Poland, May 24th, 2012 (24-05-2012) at SQL Day 2012.  During this day long session we will be looking at storage and virtualization from a DBA perspective with the end goal of the day being to improve the your knowledge of enterprise storage and enterprise virtualization.

While we won’t be looking at a specific storage vender or a specific virtualization platform we’ll be covering a lot of the common techniques between them, and looking at a lot of enterprise class theory. The entire day long session is open for Q & A (Questions and Answers) so we can discuss vendor specific issues that you are having in your enterprise today.  Be sure to check out the SQL Day 2012 pricing page for more information about pricing (the page is in Polish so I can’t read it, but I’m pretty sure it shows the pre-con pricing at 400 PLN + 23% VAT and the regular conference at 300 PLN + 23% VAT.

There are lots of great pre-cons going on, on the 24th so if mine doesn’t interest you, but sure to check out the other pre-cons which are going on that day as well.

Denny


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: