More in Storage

  • Dec 28, 2011

    What perfmon counters can I trust when using SAN disks?

    Knowing which counters can be trusted to give you valid information and which counters can't be trusted is very important to properly monitoring and troubleshooting storage and Microsoft SQL Server....More
  • 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

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Mar 17, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 21: Assigning Backup Preferences

An option when creating new AlwaysOn Availability Groups is to specify Backup Preferences. It’s also something you can easily configure once the Availability Group has been set up as well – by simply right-clicking on the Availability Group and selecting Properties – then navigating into the Backup Preferences tab.  ...More
Mar 14, 2015

For Data Quality, Intelligent Rules Add Value to the Golden Record 5

The quest for the Golden Record to achieve a single, accurate and complete version of a customer record is worth the pursuit to attain survivorship. Record matching and consolidation are only the beginning. Melissa Data takes a new approach. Learn how to apply intelligent rules based on reference data to make smarter and better decisions for data cleansing....More
Mar 12, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 20: Avoiding Backup Fragmentation

On SQL Servers where Availability Groups (or Mirroring) isn’t in play, I typically recommend keeping a combination of on-box backups along with copying said backups off-box as well. Obviously, keeping databases AND backups on the SAME server is the metaphorical equivalent of putting all of your eggs in one basket – and therefore something you should avoid like the plague....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) ×