SQL Server with Mr. Denny:

December, 2011

December 30, 2011  2:00 PM

Have a great New Years

Posted by: 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...

December 28, 2011  2:00 PM

Just a few days left to rack up tax deductions

Posted by: Denny Cherry
Immersion Events, Social Commentary, SQL Cruise, SQL Excursions, SQL Skills

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

December 27, 2011  2:00 PM

Back To Basics: Why isn’t maintenace automatic?

Posted by: Denny Cherry
Back To Basics, Backup & recovery, Recovery, SQL Server

One of the questions which I see pop up from time to time (especially when I used to work for a VAR that wrote software for small businesses) is why doesn't SQL Server do the maintenance automatically?  Things like checking for corruption (DBCC CHECKDB), index defragmentation, backups, etc. The...

December 22, 2011  2:00 PM

Fragmentation may cause corruption

Posted by: Denny Cherry
Microsoft CSS, SQL Server

Let me start this off by saying that I chose the title of this blog post very carefully.  You'll note that it says "fragmentation may cause corruption" not that it will cause corruption, so before you go saying "Denny says that if you have any fragmentation of the database it'll become...

December 20, 2011  2:00 PM

Me, Sean and Jen all talking politics & more

Posted by: Denny Cherry
Sean McCown, SQL Server, Webcast

So last weekend I had the chance to fly over to Dallas and hang with Sean and Jen McCown (the Mignight DBAs) and be the guest on their web show all live and in person for the...

December 19, 2011  7:36 PM

Look out SQL Bits, here I come!

Posted by: Denny Cherry
In Person Events, SQL Bits, SQL Server, Storage, Virtualization

That's right, I'm headed out to the SQL Bits conference in London, England.  Apparently I've been on my best behavior this year, because the guys at SQL Bits have even selected me to deliver a pre-con on the Training Day. My...

December 19, 2011  2:00 PM

2011 Blog Post Wrap Up

Posted by: Denny Cherry
Social Commentary, SQL Server

With the end of 2011 quickly approaching, I decided to throw all the stats from this blog into Excel so I can see what the most popular blog posts that I've written are.  The results are pretty interesting and provide a bit of a view into what people are reading on my blog over the course of the...

December 15, 2011  2:00 PM

3rd Party Performance Monitoring Tools & CXPACKET

Posted by: Denny Cherry
Performance, Performance Problems, SQL Server, Storage

There are lots of great 3rd party monitoring tools on the market from a variety of vendors.  I want to start this post by saying up front that I'm not bashing them, or throwing stones.  That said... Some of the time these third party apps don't handle reporting CXPACKET waits very well.  The...

December 12, 2011  2:00 PM

Fixing Performance in Vendor Apps

Posted by: Denny Cherry
Indexing, Social Commentary, SQL Server

Lots of people out there manage 3rd party vendor apps.  However as anyone who has managed a vendor app can tell you, you don't really manage the app.  You simply backup the vendor database (assuming that they allow you to backup the database) and call the vendor when there are performance...

December 8, 2011  8:43 PM

TweetDeck 1.0 has been released.

Posted by: Denny Cherry
Social Commentary, SQL Server, Twitter

Yep, Twitter (who now owns TweetDeck) have released v1 of TweetDeck.  My first impression is "Don't do it, it's a trap".  At first I was all happy when I downloaded v1 because it wasn't an Abobe Air application.  Just a good old MSI installer which installed an HTML5 application.  The downside...

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: