SQL Server with Mr. Denny:

SQL Server


March 22, 2010  11:00 AM

SQL Saturday 44 is coming up quickly (#sqlsat44)



Posted by: Denny Cherry
In Person Events, SQL PASS, SQL Saturday

Coming up in April (the 24th to be specific) is SQL Saturday 44, the first SQL Saturday event here in Southern California.  The event will be held in Huntington Beach at Golden West...

Bookmark and Share     0 Comments     RSS Feed     Email a friend

March 16, 2010  4:19 AM

EMC and NetApp are having a little fun with each other to help cure cancer



Posted by: Denny Cherry
EMC, NetApp, SQL Server

I read this on the net tonight and thought it was an awesome idea.

A friend and colleague at NetApp let me know they were doing a drive for St. Baldricks – a campaign...


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 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...


February 22, 2010  10:14 PM

I must have had a great time at the MVP summit, I’m sick as hell



Posted by: Denny Cherry
MVP Summit, SQL Karaoke, SQL PASS

I'm not that kind of sick, any hangover would be long gone by now.  But the lack of sleep has caught up with me.  I've got exactly 5 days to get over it before my next trip, which will hopefully be much more tame. So last week was the MVP Summit (


February 8, 2010  11:00 AM

Using XMLNAMESPACES within a function



Posted by: Denny Cherry
Functions, T/SQL, XML

Recently one of my developers asked me to begin returning data from a function as XML instead of a comma separated list.  My thoughts on this was awesome, another cursor getting removed from the system.  I'll write a quick FOR XML AUTO, ROOT('root') at the bottom of the SELECT statement being...


January 21, 2010  11:00 AM

SQL PASS Session Stats



Posted by: Denny Cherry
Evals, In Person Events, PASS

So I got my session stats from my SQL PASS presentation a little while back, but I've been so busy I haven't been able to put up a post about them. My Session was DBA-421 Storage for the DBA. I had a great response rate on the evals with 66 evals turned in (there were about 100-120 people in the...


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: