YOUR CHANNEL IS LOADING

LATEST EPISODES MORE EPISODES

  • 1

    A Break from Data

  • 2

    Making New Infrastructure Investments

  • 3

    Use Tools

  • 4

    The TCO of the Cloud

  • 5

    Continuous Releases

The Voice of the DBA The Bottom Line

MEVIOtoday

Aug 10, 2010 The Bottom Line

I think SQL Server is an amazing product, and I'm always thrilled to see new features that expand the list of things you can do with the platform. It's not that often that I find the platform lacking, and can usually make it work for me. However there are a few cumbersome processes that have shown the rough edges of SQL Server over the years.

I started really managing SQL Server with v6.x. I had used SQL Server v4.2, but was more of an administrator keeping the server going for third party products. With v6.x at a few companies I deployed, upgraded, and recovered servers on a regular basis. One of the truly rough edges that existed in that version was the need to actually know the sizes of each allocation of disk space for your database. We didn't have auto-grow back then; you had to manually add space to the database AND keep track of that allocation size for DR purposes. A royal PIA that had me cursing the developers at Microsoft more than once.

Read the rest of "Fooling SQL Server" at SQLServerCentral