SQL Server with Mr. Denny


October 26, 2012  5:12 PM

Recommended reading from mrdenny for October 26, 2012

Denny Cherry Denny Cherry Profile: Denny Cherry

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week.

Hopefully you find these articles as useful as I did.

Denny

October 22, 2012  9:53 PM

But We Are Hosted In The Cloud, We Don’t Need To Think About Architecture!

Denny Cherry Denny Cherry Profile: Denny Cherry

So you have moved your infrastructure into the cloud and everything is growing and going wonderfully.  Now you’ve got some consultant or job application telling you that you need to think about HA, DR and overall platform architecture.  How should you tell them that they are wrong?

You shouldn’t.

Just because you are hosted in the cloud (and it doesn’t matter which cloud) you still need to plan for system failures and major outages.  In case you missed it today there was a large portion of the Internet which wasn’t available today because of am Amazon AWS outage which happened.  And this isn’t the first time that something like this has happened.

When moving applications and services up to a managed cloud like EC2, AWS, Rackspace, Azure, etc. you still need to take the time to plan out how the application or service is going to run in the event that the primary cloud is offline, or that there’s some sort of network issue, etc.

Denny


October 19, 2012  5:14 PM

Recommended reading from mrdenny for October 19, 2012

Denny Cherry Denny Cherry Profile: Denny Cherry

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week.

Hopefully you find these articles as useful as I did.

Denny


October 18, 2012  5:38 PM

SQL PASS 2012 1st Timers Webcast Recording

Denny Cherry Denny Cherry Profile: Denny Cherry

So yesterday was my SQL PASS 2012 1st timers webcast and it went great.  Lots of great questions from the audience which I think we even got all of answered.  If you missed the session and wanted to catch the recording it’s posted up on the live meeting site.  At the moment I can’t get the recording posted anywhere else, but I’m working on it.  For now feel free to use the live meeting version.  When you go to the live meeting site it will ask you for a Recording Key, just leave this blank.

Do note that you’ll want to use the low-res version.  The high-res version doesn’t work.

The recording will be available there until October 2013, but you’ll probably want to watch the video before the summit.

See you at the summit,

Denny


October 17, 2012  10:00 PM

SQL Karaoke at the 2012 SQL PASS Summit has a sponsor

Denny Cherry Denny Cherry Profile: Denny Cherry

I’m pleased to be able to announce that SQL Karaoke night (Wednesday night at Bush Garden in the International District) has a sponsor again this year.  The fine people over at Idera Software have agreed to sponsor the evenings activities this year.  The sponsorship for this year will be very similar to last years.  Anyone and everyone is welcome to attend the insane SQL Karaoke night at Bush Garden (614 Maynard Ave. South Seattle, WA).

However in order to get the free drinks you’ll need to go and see the fine folks at the Idera booth during the day while the exhibit hall is open.  At the Idera booth you’ll be able to pick up a wristband which is good for one night, and one night only.  After that the only thing you need to do is have some dinner and at about 9:30pm Wednesday night head over to Bush Garden.  Wristbands are given out first come, first served using what ever criteria the fine folks at the Idera booth come up with.

Bush Garden is about a 30 minute walk (I’d recommend walking in a group if you want to walk) from the convention center.  From the convention center walk down Pike (towards the water) and turn right on 6th.  Walk for about a mile then turn right on Jackson, then left on Maynard.  It’s about 2 1/2 blocks down on the left.

Unfortunately Bush Garden isn’t in the best of neighborhoods so do use caution.

Personally I recommend a taxi as I’m lazy and it’s a long walk.  A cab should cost you about $5 or so to get there from the convention center and/or hotel.

If you are looking for a great way to unwind and watch some people do some great singing (and some others make total fools of themselves) this is THE party to go to.  It’s also a great place to meet some of the MVPs as well as some of the folks from the product group.  If you aren’t sure what you are getting in for by attending, don’t forget to check out the website.

The wristbands to come with a budget attached, so drinks will be first come first served.  As always please don’t go overboard with drinking.

See you at Bush Garden,

Denny


October 17, 2012  2:00 PM

SQL PASS 2012 First Timers Webcast Is TODAY!!! #sqlpass

Denny Cherry Denny Cherry Profile: Denny Cherry

Don’t forget that my SQL PASS Summit First Timers Webcast is going to be today at 1pm Pacific / 4pm Eastern (find your local time).  This is the second annual SQL PASS Summit First Timers Webcast as the one I did last year was so well received.

During this webcast I’ll be telling you a lot of what you’ll need to know about the Seattle Convention Center, how to get around town, how to get to the hotels from the airport, where to find places for dinner, how to find your way around the convention center, and much more.

If you’ve been to the PASS Summit in Seattle before I’d recommend watching anyway as there will be some new information for you.  Most importantly where breakfast and lunch will be served as the lunch hall is moving.

You do need to fill out my annoying registration form to get the meeting info.  The form is painless I promise.

I’ll see you this afternoon.

Denny


October 16, 2012  5:56 PM

There is still time to sign up for SQL PASS PreCons

Denny Cherry Denny Cherry Profile: Denny Cherry

This year the PASS Summit has 14 fantastic PreCons which are available for attendees to sign up for at an additional cost of just $395 per precon.  These precons are full day sessions with some fantastic presenters including myself, Louis Davisson, Rod Colledge, Jessica Moss, Brian Knight, Allen White, Itzik Ben-Gan, Bob Ward, Allan Hirt and Grant Fritchey as well as a several others.

These sessions are a fantastic deal as you get a full day session, hand out, lunch plus lots of time to chat with the presenter and attendees before the sessions, during the breaks as well as after the session.

Can’t decide which session you want to attend?  No problem there are two days of PreCons so you’ll be able to turn the 3 day PASS Summit into a 5 day conference for just a few hundred dollars more.  If you are heading out to the PASS Summit I’d really encourage you to sign up for one of the pre-cons.  I’d love to have you in my pre-con called “SQL Server 2012 in a Highly Available World” where we are going to walk through all of the high availability options which are available in SQL Server 2012 (as well as in the older versions as well), learn how to get them setup and most importantly figure out when we should be using each one.

If you are already signed up you can modify your registration or contact the registration contact listed on the registration page and she’ll be happy to add a pre-con onto your registration.

I look forward to seeing you at the summit, and at my precon,

Denny


October 12, 2012  5:23 PM

Recommended reading from mrdenny for October 12, 2012

Denny Cherry Denny Cherry Profile: Denny Cherry

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week.

Hopefully you find these articles as useful as I did.

Denny


October 10, 2012  9:00 AM

Encrypting data in the same column

Denny Cherry Denny Cherry Profile: Denny Cherry

I wrote a little while ago about the fact that sensitive data needs to be encrypted within the database for all applications.  This is the first technique that is available to you to encrypt data in a database with as little outage as possible.

In this technique we’ll encrypt the data using just a single column.  This technique requires butting some additional logic within the application to figure out if the value is encrypted or not, but other than that logic, which you can leave in and strip out later the changes to the application are pretty minimal as the column stays the same, so that means that the stored procedures don’t need to be changed.

The first thing to remember is that the encrypted data will be larger, possibly much larger than the plain text version of the data.  Because of this you’ll need to increase the size of the field which you’ll be putting the data into.  Now the good news is that if this column isn’t indexed this change should be pretty quick and easy as it should just be a meta change which tells the SQL Server that the column size can be bigger without having to actually change the pages.  You can see this by making some changes to the [HumanResources].[Employee] table within the AdventureWorks database.  By turning on STATISTICS IO and using the ALTER TABLE statement we see that there is no IO generated when we change the size of the LoginID column from nvarchar(256) to nvarchar(512).

set statistics io on
alter table MyTable
alter column LoginID nvarchar(512)

Once the column is made larger the .NET code needs to be modified to see if the data is compressed for not.  Now there is no sure fire way to check to see if a value has been encrypted or not, but a pretty good test is to look at the last two characters of the value.  If they are both an equal sign (==) then it is probably safe to assume that the value is encrypted.  To don’t want to just attempt to decrypt the data and look for an error message, and if there is an error assume that the encrypted value is in plain text, throwing and catching error messages in .NET is very expensive, especially compared to simply checking to see if the last two characters are an equal sign.  This isn’t to say that you shouldn’t have TRY/CATCH logic around the code that decrypts the values as someone could easily enough put two equal signs at the end of their password.

At this point either a .NET app or a T-SQL script can loop through the values in the table which aren’t encrypted and then encrypt them, updating the rows which aren’t already encrypted.

Look for more blog posts in this series on how to encrypt data which already exists within your applications database.

Denny


October 5, 2012  5:08 PM

Recommended reading from mrdenny for October 05, 2012

Denny Cherry Denny Cherry Profile: Denny Cherry

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week.

Hopefully you find these articles as useful as I did.

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: