SQL Server with Mr. Denny:

Storage


May 12, 2010  8:16 PM

EMC World Day 2 (2010)



Posted by: Denny Cherry
Bob Ward, Bruce Zimmerman, CLARiiON, EMC World, EMC World 2010, VMware

So yesterday was Day 2 of EMC World, and my body is really starting to feel it.  All the sessions today were top notch sessions. The first session yesterday was by Bruce Zimmerman.  For those of you in the SQL Server community that are reading this Bruce is to the EMC Storage community as Bob...

May 11, 2010  9:02 PM

EMC World Day 1



Posted by: Denny Cherry
EMC World, EMC World 2010

So yesterday was day 1 of EMC World.  I attended some great sessions (and one not so great one). The first session that I hit was the futures for the EMC CLARiiON's FLARE software.  For those that don't know what FLARE is, FLARE is the software which runs the array and handles all the...


May 10, 2010  2:26 PM

EMC World Day 0



Posted by: Denny Cherry
EMC World, EMC World 2010

Yesterday was Day 0 or EMC World which means that it's party day.  The day started with Registration and the Welcome reception.  If you've never been to EMC World, registration is probably the longest line in the place.  You've got all 10,000 or so attendees trying to get checked in. ...


May 9, 2010  6:46 PM

EMC World Day -1



Posted by: Denny Cherry
EMC World, EMC World 2010, Flickr, Twitter

My trip to EMC World started a day early this year.  With the long trip out here, and the events starting pretty early on Sunday afternoon, trying out on Sunday just doesn't work unless I want to sleep through the Sunday welcome reception and check in. And since I don't want to sleep through...


April 19, 2010  11:00 AM

Hey sysadmins, powerpivot is coming, and it’ll take a lot of disk space.



Posted by: Denny Cherry
Powerpivot, SQL Server, SQL Server 2008 R2, Storage

So if you haven't heard of PowerPivot yet, it's going to be the next best thing to sliced bread for your business users.  While it'll take a while for most IT shops to get the full Sharepoint & PowerPivot integration setup, PowerPivot will be available to your users within the next few weeks...


April 15, 2010  11:00 AM

Powering up and down a storage array may not be done in the order you think



Posted by: Denny Cherry
Storage

Powering up a single server is easy. Turn on the direct attached storage, then turn on the server.  Done.  When powering your storage array down or back up there is quite a bit more to it than that. The proper procedure for powering down your array is:

  1. Power off the...


March 25, 2010  11:00 AM

Using Service Broker instead of Replication



Posted by: Denny Cherry
Replication, Service Broker, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2

During my SQL Service Broker sessions I talk about using SQL Service Broker as a replacement for SQL Replication.  But I've never really documented how to do this other than bits and pieces here and there.  So here I'm going to try and spell out how I put a system like this together for an auto...


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


February 2, 2010  11:00 AM

Taking backups is good, but testing them is better.



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, Restore Database, Testing

I bet that if asked when the last time the database backup was taken and if it succeeded you would know off of the top of your head when that was.  But if I asked you when the last time your database was restored successfully would you know?


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: