SQL Server with Mr. Denny


September 26, 2012  7:00 PM

The 2012 Dynamic Database Project Award

Denny Cherry Denny Cherry Profile: Denny Cherry

SearchOracle.com and SearchSQLServer.com are teaming up to select three finalists and one winner of the 2012 Dynamic Database Project Award; and I’m going to be one of the judges.

To enter review the Dynamic Database Project Award webpage, download the entry form, fill it out and submit it.

The three finalists will have their projects featured on SearchSQLServer.com or SearchOracle.com; and the one winner will receive a brand new Apple iPad.  (See the award webpage for full details.)

Thanks,

Denny

September 21, 2012  5:21 PM

Recommended reading from mrdenny for September 21, 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


September 17, 2012  2:00 PM

SQL Saturday 157 Slide Decks and Sample Code

Denny Cherry Denny Cherry Profile: Denny Cherry

This last weekend we had our most recent SQL Saturday in San Diego, CA.  This was SQL Saturday 157 and it was a huge success.  Making this SQL Saturday even better than most was the fact that the SQL PASS Board of Directors had their quarterly meeting the days before so most of the board was able to attend the SQL Saturday as well in addition to all the local speakers and a few out of town speakers who were able to fly in.

I presented two sessions at this years SQL Saturday San Diego, and you can find the slide decks and the sample code for those two sessions below (including the slides which I didn’t get to).

SQL Server Partitioning From The Group Up

Table indexing for the .NET Developer

Even though the weather wasn’t quite what we were expecting (it’s supposed to be 80 this time of year, not 105) I still had a great time with everyone and I can’t wait to see everyone at the SQL PASS Summit in just a few short weeks.

Denny


September 14, 2012  5:23 PM

Recommended reading from mrdenny for September 14, 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


September 12, 2012  2:00 PM

When clustering guests, host them on different LUNs

Denny Cherry Denny Cherry Profile: Denny Cherry

When building virtual clusters under any HyperVisor you need to make sure that all the nodes of the cluster are being hosted on different LUNs on the hosts. If you build the VMs on the same LUN and that LUN fails for some reason then both of the nodes of the cluster will be down, and the whole point of clustering will have been lost.

While this hopefully goes without saying, it’s just another thing that needs to be thought about when building virtual SQL Server clusters.

Denny


September 10, 2012  5:41 PM

SQL Saturday 147 Slide Decks

Denny Cherry Denny Cherry Profile: Denny Cherry

I had the pleasure of speaking at SQL Saturday 147 in Recife, Brazil about 2 weeks ago.  I just realized that I never got my slide decks for my sessions uploaded.

I gave 3 sessions that weekend.

Table indexing for the .NET Developer

Reading the SQL Server Execution Plan

Where should I be encrypting my data

If you attended one of my sessions and you wanted a copy of the slide deck, here you go.

Denny

Update 9/10/2012 11:43am (Pacific Time): It appears that GoDaddy is under attack by Anonymous which has taken many sites offline (including my mrdenny.com site which is where those links above point to).  So for now those links won’t be working.  Once GoDaddy gets this all fixed (or I get fed up and move my site to another hosting provider) the links will start working again.


September 7, 2012  5:05 PM

Recommended reading from mrdenny for September 07, 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


September 6, 2012  11:41 PM

New Podcast called People Talking Tech

Denny Cherry Denny Cherry Profile: Denny Cherry

So in all my free time (that 7 minutes a week that I wasn’t already using for something) I’ve decided that I needed to try something new.  I’ve put together a new podcast called People Talking Tech (www.peopletalkingtech.com) where myself and whoever I can sucker into joining me is kind enough to join me will talk about something technical for your education, enjoyment, disgust, or whatever.

The pod cast episodes will be coming out Tuesday mornings (Pacific Time).  Once I get the first ones out I’ll be working on getting it submitted to iTunes so that you can pick it up there on your favorite fruity device.

The topics will vary depending on who my victim guest is that week.  We could be talking about Windows, SQL Server, Xbox, Surface, .NET, etc. or pretty much anything else that comes to mind.

These are totally un-scripted and for the most part un-edited.  Some come check them out.  I promise mild entertainment at the least. :)

While the site went live today the first episode will go live on September 11th.  My first guest is Karen Lopez.  You can find out a bit more about the show over on the People Talking Tech website (www.peopletalkingtech.com).

Denny


September 5, 2012  2:00 PM

The world does not revolve around cloud computing or coding.

Denny Cherry Denny Cherry Profile: Denny Cherry

Back on August 28th another ITKE poster wrote a blog post titled “The elephant not in the room” in which they talk about how if you want to work in IT in the future you better plan on working at one of the big cloud providers or you better be a programmer.  I’ve got one simple response to this.

Bull Shit!

While it is true that a lot of companies are moving SOME services to the cloud, most companies are not looking at moving every service to the cloud.  Even if they wanted to move everything to the cloud so that Amazon, Rackspace, Microsoft (Azure), etc. could handle the managing of the servers there are some things which will simply never sit in the public cloud.  Here’s a short list to start with…

  • Medical Data (there’s this thing called HIPAA that requires you know who has accessed the data)
  • Confidential data
  • Any customer data from companies in Europe
  • Most legacy applications which contain personally identifiable information

There are also plenty of services that IT provides that simply can’t be replaced by the cloud.  This includes things like:

  • Network infrastructure at the office
  • DHCP, DNS, Authentication, etc. services at the office
  • Telecom Services
  • File Servers
  • Account provisioning in what ever applications are running in the cloud

Even when services are moved to the oh so magical cloud there are still plenty of non-code things that need to be done by someone who works for the company who’s application will be hosted by the cloud.

  • Virtual Machine Architecture (remember when Amazon’s EC2 had that little problem with some of the groups going offline?)
  • Application deployments (separation of duties is still a SOX requirement when applications are in the cloud)
  • Disaster Recovery planning (realistically how would the business have reacted during that EC2 outage?)
  • Disaster Recovery testing (if you plan for a disaster and don’t test the plan, you’ve got nothing useful.)
  • Scaling applications (not everything automatically scales like they marketing material says)
  • Moving applications from one cloud provider to another (if I can save $10 a month by moving from EC2 to Rackspace for example, why shouldn’t I)
  • Database Index Tuning
  • Server Patching

On top of all of that, there’s other risks with moving everything that runs a company into the cloud.  Now that you no longer own the servers you can’t control what the other servers are running on the physical hardware.  So if that tier 1 application that requires millisecond response time isn’t getting it, there’s basically nothing that you can do.  And what happens where there’s an internet outage at the office and your employees can’t access the software they need to do their jobs?  Suddenly the savings of moving that tier 1 application to the cloud wasn’t the greatest plan.

Now there are definitely benefits to moving SOME application and services to the cloud, but the thought that everything will move to the cloud and if you want to stay employed you better learn how to write application code, is total crap.


August 31, 2012  5:21 PM

Recommended reading from mrdenny for August 31, 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 them 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: