More in Storage

  • Dec 21, 2011

    Me and My New Crucial M4 SSD 1

    So a few weeks ago I got a nice little present in the mail from Crucial. It was one of their nice new(ish) M4 SSDs with a massive 256 Gigs of free space. Here's a review of my experience with the drive so far......More
  • Dec 14, 2011

    Should I be using Fiber Channel, iSCSI or FCoE? 15

    This is really an it depends question. There are a variety of things which can influence which technology you select....More
  • Dec 7, 2011

    Can the fiber channel switch be a bottleneck? 1

    While it isn't the most common place that a performance bottleneck can happen, the fiber channel switches or Ethernet switches if you are using iSCSI or Fiber Channel Over Ethernet (FCoE) can become a performance bottleneck. The switches which run the network that the data travels over, reguardless of the technology involved can become a bottleneck....More
  • Nov 29, 2011

    When do I want to look at IOPs and when megs per second? 1

    IOPs and Megs Per second are two very different numbers, and there are specific times when you want to look at each one....More
  • Nov 22, 2011

    What are the seconds per read and seconds per write counters for?

    When and why should I be looking at the seconds per read / write counters?...More
  • Nov 15, 2011

    Can't I just build my own SAN using commodity hardware?

    It really comes down to what you want to spend your money on, managing your systems or building the storage array....More
  • Nov 8, 2011

    What are the benefits and issues with booting SQL Servers from the SAN?

    The benefits of booting your server's from the SAN come from the manageability side of things, while the down sides come in the performance side of things....More
  • Nov 2, 2011

    11 Glorious Sessions on Storage and Virtualization

    In this 11 session class we will learn all about enterprise storage and virtualization so that as the DBA we can make intelligent decisions about how to configure storage and when to virtualize servers as well as how to monitor and troubleshoot when using enterprise storage and/or virtualization....More
  • Yellow tennis ball on white tennis court baseline
    Nov 1, 2011

    What are storage baselines, and why do I need them?

    The what, where, and why of storage benchmarking....More
  • Oct 25, 2011

    Are your disks being short stroked?

    What is short stroking, besides something that sounds like it shouldn't be on this website?...More
  • Oct 21, 2011

    I predict that Facebook will become your digital water cooler for professional networking.

    Conventional wisdom claims that Linked In is "the" place for business social media while Facebook is for other stuff. I don’t claim to be a social media guru. However, I’m going to go out on a limb and say that I think that Facebook will emerge as "the" place to be for professionally oriented social networking....More
  • Oct 18, 2011

    Why do the bigger name brand storage arrays cost so much?

    The storage array market has really blown open recently with a lot of new companies getting into the storage array business. With all these newer companies in the market offering lower cost storage arrays asking why you should be paying more for a larger companies solution is a very valid question to be asking....More
  • Oct 11, 2011

    Why do people purchase SAN over DAS?

    As a DBA often the storage solution that is being used is simply thrust upon you. This will hopefully answer some of the questions of why you have a SAN in your environment instead of local disk....More
  • Oct 10, 2011

    Will you choose litigation or arbitration to settle disputes?

    The choice of arbitration or litigation is one of the most important business decisions you can make. It's also a decision typically ignored by small businesses until it's too late. You might think that arbitration and litigation is pretty a boring topic. I get that. But keep reading. Today’s post is powerful advice based on personal experience....More
  • Oct 4, 2011

    Let's Have Lunch and Talk Storage

    This year at the SQL PASS summit I'm once again taking a lunch table for the Birds of a Feather lunch on Friday. And even better than last year I don't have a session that I'm presenting right before lunch so I'll actually be there on time (last year I was like 30 minutes late because of Q&A in my session)....More
  • data storage rack
    Oct 4, 2011

    Should I be using table partitioning or auto tiering features of my storage array?

    Debating SQL Server's table partitioning and storage array level auto-tiering....More
  • Sep 29, 2011

    When should entrepreneurs start planning for key hires? 1

    Entrepreneurs should start planning for key hires a few months before they need becomes critical and urgent....More
  • Sep 28, 2011

    Just Ship it.

    Good enough is almost always better than nothing at all. Many of you will smile and nod sagely when you read that. Sure, that seems pretty obvious. But many people fail to ‘ship it’ when they have an idea. I’m in that boat. Do you struggle with this? What holds you back?...More
  • Sep 27, 2011

    What is tiered storage and how can I use it in my environment?

    Tiered storage (which you may have seen me talk about at the SQL PASS summit, SSWUG, user groups, SQL Saturday's, etc.) is a technique that storage administrators use which in a nutshell puts the most needed data on the fastest (and most expensive) storage available while data which doesn't need such high response times is put on to slower (and cheaper) storage....More
  • Sep 20, 2011

    What should I be asking my SAN sales guy so he'll give me real world numbers?

    In this blog post we talk about what you can do to get some real world performance numbers from your storage array vendor before purchasing. Sales teams are typically very closed about what sort of numbers you can get, and for good reason. However there is a way to get some real numbers from them....More
  • Sep 13, 2011

    Making a Large Virtual Lab Using Minimal Hard Drive Space

    As a presenter and author one of the biggest problems that I come across is running out of hard drive space when building virtual machines (VMs) for demos and screenshots. Up until very recently I was using a brand new virtual machine for each virtual machine that I needed and space was very tight....More
  • Sep 6, 2011

    Can Windows 2003 be used to host databases over a file share?

    In this post I talk about some of the reasons that older operating systems like Windows 2003 may not provide a good platform for remotely hosted SQL Server databases while Windows Server 2008 provide a better environment....More
  • Aug 30, 2011

    Storage Questions Answered, And For The Right Price

    When I started this blog I wanted to put together somewhere that people could get their real life storage questions answered without having to bring in a high priced consultant and paying for a bunch of consulting hours just to get what is usually a simple question answered....More
  • Aug 23, 2011

    Not All Data Compression Is Created Equal

    While we like to say that storage is cheap, the reality is that cheap is relative. If you don’t have budget for more storage, suddenly storage isn’t very cheap. Because of the absolutely massive amount of CPU power that we can pack into a server for relatively little money these days, storage compression is coming more and more the reality for more and more DBAs....More
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Jul 8, 2014

Replication: Sometimes More is Less

The unconventionality of having two publications for complex, unruly databases typically ends up saving huge amounts of time over the long haul and makes replication much easier to manage....More
Red restore key on computer keyboard
Jun 24, 2014

AlwaysOn Availability Groups and Third Party Log Readers

When DBAs and SysAdmins learn the ins-and-outs of AlwaysOn Availability Groups, they’re then able to address high availability and disaster recovery concerns from a single interface or set of tooling, thus providing better scalability of management....More
Microsoft Azure Machine Learning screenshot
Jun 20, 2014

Microsoft Cloud Predictive Analytics Preview Coming Soon

A preview of Azure Machine Learning, or Azure ML (project code name "Passau"), will be made publicly available in July 2014....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×