SQL Server with Mr. Denny:

March, 2010


March 15, 2010  11:00 AM

SQL 2008 R2 is pricy, but so is that other database.



Posted by: Denny Cherry
SQL Server

There's a lot of talk about the new SQL Server 2008 R2 pricing.  To give you an idea of why people are complaining... (Keep in mind that all prices on this page a CPU licensing.)

Version Standard Enterprise Data...

March 11, 2010  11:00 AM

My Slide decks SQL Saturday 33 (#sqlsat33)



Posted by: Denny Cherry

I presented three sessions at SQL Saturday 33 this last weekend.  Here are the slide decks and sample code that I used during my presentations.   Bookmark and Share     0 Comments     RSS Feed     Email a friend


March 9, 2010  11:05 PM

Oh man, someone put my blog posts on TechNet… #tnSqlDC



Posted by: Denny Cherry
Arnie Rowland, Buck Woody, Mayhem, SQL Server, TechNet, Twitter

Yep, that's right, someone over at Microsoft has gone completely crazy and syndicated not just my blog but my Tweets as well over on the technet.microsoft.com site.


March 9, 2010  8:00 PM

IO, IO, It’s Off To Disk We Go! #TSQL2sDay



Posted by: Denny Cherry
Microsoft Windows, Performance Problems, SQL Server, Storage, TSQL2sDay

So today is #TSQL2sDay, and this months topic is Disk IO.  Storage is something I love working in, so I figured why not, I'll post something. Hopefully everyone knows that your storage solution is the most critical when it...


March 8, 2010  11:00 AM

How do I deal with a rollback which is stuck at 0% remaining?



Posted by: Denny Cherry
SQL Server

Every once and a while you have to kill a SPID in SQL Server.  And on a rare occasion the SPID will rollback, but won't actually rollback and go away.  While this is annoying there isn't actually anything bad going on.  The SQL Server is running just fine, however you won't be able to kill this...


March 3, 2010  6:23 PM

Getting set up for multi-server management with SQL Server 2008 R2



Posted by: Denny Cherry
MSM, Multi-Server Management, SearchSQLServer.com, SQL Server, SQL Server 2008 R2

I've just published a new article up on SearchSQLServer.com where I'm talking about how to setup the new Multi-Server Management feature of SQL Server 2008 R2 complete with some screen shots in case you...


March 1, 2010  11:00 AM

Somehow I missed a milestone…



Posted by: Denny Cherry
Blog, Professional Development

I logged into my WordPress admin site and saw something that I never thought that I'd see.  Somehow I've managed to publish just over 400 blog posts.

Bookmark and Share     2 Comments     RSS Feed     Email a friend


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: