SQL Server with Mr. Denny


May 22, 2012  9:00 AM

Still time to sign up for SQLDay 2012 pre-con

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

There is still plenty of time to get signed up for my SQLDay 2012 all day session in Poland this week on Thursday the 24th of May. Below you’ll find a description of the session which I’ll be teaching.

This session will be a two part session in which we will be focusing on two of the biggest topics in the DBA field. How to properly design your SAN storage solution and how to properly design your virtualization solution.

The storage portion of this session will focus on SAN storage, but most of the material will apply to direct attached storage as well.

In the first half of the session we’ll be focusing on the storage array. Storage can be one of the biggest bottlenecks when it comes to database performance. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives. We’ll be digging into LUNs, HBAs, the fabric, as well as the storage configuration.

After going over the components we’ll dig into some advanced storage configurations. This includes RAID groups, multi-pathing software, and proper redundant storage network design. We will also be digging into some advanced storage array backup techniques including taking storage level clones and snapshots. After going over these advanced techniques we will dig into how these can best be used to backup the SQL Server environment to provide maximum redundancy with no recurring tape costs.

In addition to theory, we’ll be looking at an actual SAN so that we can translate what we see in the Storage Array with what we see on the actual server.

In the second half of the day we’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea. Like everything in the database world there are no hard set answers as to if virtualization is a good idea or not, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money. There are some other times when you will be shooting yourself in the foot and virtualization isn’t a good idea. We’ll be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision.

We’ll look into how tie the virtual platforms to the storage array so that you can maximize the storage performance for your SQL Servers and the virtual environment.

I hope to see you in Poland at SQLDay 2012 later this week.

Denny

May 21, 2012  2:00 PM

What to do when your Twitter account gets hacked

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

On occasion Twitter accounts get hacked and are used to send out spam to other twitter followers, usually via Direct Message. When your twitter account is taken over there are two different things that you need to do in order to get your account back under your control.

The first is pretty straight forward, change your Twitter password. This is done by going to the Twitter web site (www.twitter.com) and logging in. Then you’ll need to go to your settings page (by clicking the little person drop down in the upper right, then selecting settings from the menu) and select the Password tab from the menu on the left. You can also get there directly from this link.

The second thing that needs to be done is to reset the rights that all the applications have to use your account. If you don’t do this, and one of the apps which has access to your account is what is sending out the direct messages, it will still be able to send out the direct messages. You do this by logging into the Twitter web site (www.twitter.com) and logging into your account, then going into your account settings (by clicking the little person drop down in the upper right, then selecting settings from the menu), then selecting “Apps” from the menu on the left. You can also get there directory from this link. From this page you’ll want to revoke access to every application listed. Then as you come across the applications naturally add them back, but don’t assume that the app that currently has the rights to your account should.

Once you’ve done both of these things you’ll need to change the password for any third party applications like Tweet Deck which logs in to the Twitter website directly, and any apps which need access to your Twitter account will need to be reauthorized. This sounds painful, but it isn’t. Check the website for your Twitter client on how to change the password which the application uses to log into the website.

Hopefully you never need this information, but if you hopefully this helps fix any problems that you have,
Denny


May 16, 2012  9:16 PM

Time to Register for TechEd pre-cons

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

So Microsoft TechEd is quickly approaching. If you wanted to sign up for a pre-con there is still time, and plenty of space left available at both the North America and Europe TechEd pre-cons. These pre-cons are full day long sessions, being presented in this case by Tom LaRock and myself.

In this session, learn about SQL Server 2008 R2 and SQL Server 2012 performance tuning and optimization. Industry Experts Thomas LaRock and Denny Cherry guide you through tools and best practices for tuning queries and improving performance within Microsoft SQL Server. This session details real-life performance problems which have been gathered and tuned using industry standard best practices and real-world skills.

You can sign up for North America here, or Europe here.

I’ll see you in Orlando or Amsterdam,
Denny


May 16, 2012  2:00 PM

The only good thing about Java is bitching about Java

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

So the other day I was having one of those days.  Nothing was going right, systems just didn’t want to work correctly, and Java had just pissed me off for the last time.  To put this into perspective Kris took her laptop into the living room to get some stuff done on it so that she wouldn’t have to deal with me.

So when EMC’s Unisphere didn’t want to load for me I posted online my love for Java.

I got a few responses that did brighten my day a little.  These include this one fro Mike in NYC:

This one from Wendy, with a following by Jonathan:

Another accurate response was from Geoff:

With I think the best being from Steve.

Denny


May 14, 2012  2:00 PM

Be careful which node you install a clustered instance from

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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
SQL

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
SQL

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
SQL

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
SQL

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
SQL

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.


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: