SQL Server with Mr. Denny


January 16, 2012  2:00 PM

When you don’t QA, there are problems

Denny Cherry Denny Cherry Profile: Denny Cherry

Without a proper QA process things can end up going a little bit wrong.  Even the most basic of processes need to be checked and controlled, if they aren’t then things can end up going a little wrong.  Just like these very nice bolt on headlights that I installed on my motorcycle recently, there are simple things which can cause all sorts of problems.  A simple QA process at the light bar manufacturer would have caught the fact that the cowl on the left one only bolts on upside down.  Now the cowl isn’t installed wrong, and it isn’t made wrong.  The manufacturer simply put the wrong cowl in the package.  Granted this is pretty easy to fix, I call the manufacturer and they send me out the correct cowl.  But in the mean time my bike looks a little silly with an upside down cowl, and I have to wait for the new cowl to be delivered.

Just like in the IT space simple processes, like putting the correct cowl in the bag, need to be QA’ed to ensure that the system is running correctly as expected.  Without these processes in place even the simplest things can break down.  And in the IT world these things usually can’t be fixed as easily as sending out a new cowl to the client.  It usually involves systems being down for hours, data being lost or compromised, or worse.

Hopefully you’ll review your testing and QA processes and fix any gaps in your testing processes.

Denny

January 12, 2012  11:28 PM

MVP First Timers Webcast On Demand

Denny Cherry Denny Cherry Profile: Denny Cherry

For those of you who are going to the MVP Summit this year, I did a web cast on what to expect the first time you attend the MVP summit.  For some very annoying reason the video won’t embed correctly here, so you’ll find the video over on my site here.  It’s about 45 minutes long and tells you about the summit, what will happen if you break NDA at summit, some places to food and drinks, what guests can come to and what the can’t, etc.

Denny


January 12, 2012  2:00 PM

SQL Server 2012 Class March 19-22, 2012

Denny Cherry Denny Cherry Profile: Denny Cherry

This March I, Microsoft MVP for SQL Server and Microsoft Certified Master for SQL Server 2008 Denny Cherry, am teaching a 4 day class introducing SQL Server 2012.  This four day class is being offered for only $1200 for four full days of training on the newest version of Microsoft SQL Server 2012.  The class will cover installation options for rapid upgrades and deployments of SQL Server 2012 through the environment as well two days of looking at the newest and most exciting features of SQL Server 2012.  On the last day of the class we will focus on Table Partitioning, Transaction logs, encryption and permissions.  The full outline of the class is listed below.

Registration for this great 4 day class is now open, however seating is limited so get your reservation in now in order to attend this class.

DAY 1: Planning and Installation

  • Welcome and Introductions
  • Module 1: Installing and Configuring SQL Server 2012 on Windows Server Core
  • Module 2: Installing and Configuring SQL Server 2012 in a Cluster
  • Module 3: Performing unattended installations of SQL Server 2012
  • Module 4: Deploying SQL Server 2012 using sysprep
  • Module 5: Automating SQL Server 2012 installations with VMware’s vSphere Deployments
  • Module 6: SQL Server 2012 Storage Design Considerations
  • Module 7: Installing SQL Server 2012 in a virtual environment
  • Module 8: Securing a SQL Server 2012 installation

DAY 2: Mission Critical

  • Module 1: SQL Server 2012 AlwaysOn Overview
  • Module 2: Configuring SQL Server 2012 AlwaysOn
  • Module 3: SQL Server 2012 AlwaysOn Availability Groups Drilldown
  • Module 4: What’s new in SQL Server 2012 Manageability
  • Module 5: What’s new in Transact-SQL
  • Module 6: Migrating from SQL Server 2000/2005/2008 to SQL Server 2012

DAY 3: Breakthrough Insights

  • Module 1: Installing and configuring a SQL Server 2012 based Business Intelligence Environment
  • Module 2: Configuring SQL Server 2012 Business Intelligence
  • Module 3: Introduction to PowerPivot
  • Module 4: Introduction to PowerView
  • Module 5: Introduction to Dashboards and ScoreCards
  • Module 6: Optimizing your datawarehouse performance using ColumnStore index
  • Module 7: Introduction to Data Quality Services

DAY 4: Manageability and Security

  • Module 1: Table Partitioning for performance and saving money
  • Module 2: Transaction Logs from the inside out
  • Module 3: Certificates aren’t just for web browsing any more
  • Module 4: Data Encryption will keep your data safe if it escapes
  • Module 5: SQL Injection is a bigger problem then you want to think it is
  • Module 6: Permissions, Rights and Authorizations will keep your data safe


January 10, 2012  11:50 PM

Come check out a SQL pre-con at Tech Ed

Denny Cherry Denny Cherry Profile: Denny Cherry

In addition to delivering a pre-con at Tech Ed Europe (which I blogged about yesterday) I can proudly say that Thomas LaRock (@sqlrockstar | blog) and I will be presenting a pre-con at Tech Ed North America as well.  Check out the pre-con pages and get registered.  At both conferences we will be doing the same pre-con (but feel free to sign up for both) session titled “Microsoft SQL Server Performance Tuning and Optimization”.

North America

Europe

I hope to see you at Tech Ed.

Denny


January 10, 2012  12:20 AM

Europe just can’t get rid of me!

Denny Cherry Denny Cherry Profile: Denny Cherry

No matter how hard Europe tries to keep me away, I’ll be back in June for the premier Microsoft conference, Tech Ed Europe 2012. And not only will I be attending, but little old me will be presenting a pre-con on SQL Server Performance Tuning (about half way down the page). I’ll be joined turning the pre-con by my co-presentor Thomas LaRock (@sqlrockstar | blog).

Registration for the pre-cons has opened, so get registered for both the pre-cons and the full Tech Ed Europe conference now.

See you in Europe in June!

Denny


January 9, 2012  7:00 PM

Meme Monday: what is your first blog post?

Denny Cherry Denny Cherry Profile: Denny Cherry

As I got tagged by Denis Gobo (@DenisGobo | blog) on his Meme Monday post, here it is.  Denis (I have to try really hard not to put two n’s in his name) asked “What is the first blog post you wrote and when did you write it?”

For me that was October 10th, 2007 when I posted a blog post here on this site titled “Getting the right disk config for your SQL Server“.  Since that blog post went live I’ve posted almost 700 blog posts on this blog (this post is #695) and I’ve started blogging on the SQL Server Pro website (formally known as SQL Server Magazine) on my “Troubleshooting SQL Server Storage Problems” blog.

After reading through my post from 2007 even though some time has passed since that article was written and the technology has changed a bit, that post is just at relevant today as it was back in 2007.

Denny


January 2, 2012  2:00 PM

All hail Bill Graziano now known as El Hefe

Denny Cherry Denny Cherry Profile: Denny Cherry

Today (technically yesterday) begins the reign of the new president of the SQL PASS organization.  Taking the lead of the organization is someone who I’m happy to call a good friend, Bill Graziano (@billgraziano | blog).  I think that Bill will do a great job at the head of our organization and I can’t wait to see how he does.  Bill has quite a bit of experience with PASS having previously served at the VP of Finance and the VP of Marketing as well as several years as a member of the board of directors.

All hail our new SQL overload “El Hefe” may he treat us well during his reign.

Denny


January 2, 2012  2:00 PM

SQL Server 2012 Training Annoucement

Denny Cherry Denny Cherry Profile: Denny Cherry

I am please to announce the first of my SQL Server 2012 training classes being held March 19-22 at the Microsoft office in Los Angeles, California.  This isn’t a short class, but a 4 day training class which will cover installation, manageability, security, high availability as well as the new and improved BI features.

All the information about the class including the course outline and pricing are all listed on the class information page.  Seats for the class are limited so be sure to get signed up quickly.  If you sign up during January be sure to use the discount code “BlogReader” save $100 on the cost of the class.

I hope to see you at the class.

Denny


December 30, 2011  2:00 PM

Have a great New Years

Denny Cherry Denny Cherry Profile: Denny Cherry

It’s December 30th.  Who the hell wants to read technical blogs today.  God knows I sure don’t want to write one.

So I’m going to finish what needs to be finished for the year, play hooky for the rest of the day and be done with 2011.  I’m looking forward to 2012 in a big way.  I’ve got some big conferences lined up to speak at, some great classes and other events that I’m speaking at.

Have some fun this weekend and party like is 2012, because well it is.  We’ve earned it, and if you believe that Mayan’s it’s the last new years ever so go nuts.

Denny


December 28, 2011  2:00 PM

Just a few days left to rack up tax deductions

Denny Cherry Denny Cherry Profile: Denny Cherry

There’s only a few days left in 2011, which means that there is only a few days left to rack up tax deductions for the 2011 tax year.  Things like career development (like training classes) can usually be taken as tax deductions when you itemize your taxes.  Typically training events like SQL Excursions, SQL Skills Immersion Events, and SQL Cruise would count as tax deductions.  You don’t need to take the training in 2011, you only need to pay for the training in the 2011 calender year.  If you think that you may end up having to pay some taxes for this year, a great way to get some training and reduce your taxable income for the year 2011 all in one shot.

Of course you should check with your accountant to make sure that what you are paying for qualify as a tax deduction.

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: