Inside SQL Server

Technology perspectives, tips, futures, and occaisonal humor from inside Redmond's building 35.

  • Inside SQL Server

    Tricks to help DBA's get more sleep

    • 1 Comments
    If you are a DBA, the chances are that your sheep counting is interrupted by a pager or cellphone going off in the middle of the night. While you can't eliminate it, having an explicit Service Level Agreement will help you to handle outages that occur...
  • Inside SQL Server

    MTBF is useless - how to decide when to use RAID for Database High Availability

    • 1 Comments
    Building reliable database systems is complicated by the fact that, as engineers, we tend to think about system design in a narrow way that is usually focused on the individual technologies. In order to make the right choices about when to use specific...
  • Inside SQL Server

    When you need to fix copies of data that get out of sync with each other

    • 1 Comments
    I can't tell you how many times I've been in the situation of trying to figure out what has changed between two tables. Often this happens when you create copies of schemas. Maybe you have a dev, test, QA and production environment and they all contain...
  • Inside SQL Server

    Got database scale?

    • 1 Comments
    As you might expect given the size of Microsoft, there are many websites which must be able to scale to very high levels. Have you ever wondered how this is acheived? It would be impossible to use a single server to support the databases on the highest...
  • Inside SQL Server

    Bio

    • 1 Comments
    I just realized I hadn't included my bio when I started blogging. After graduation in 1990, I started working as a developer on the mainframe for GTE Data Systems in Florida and moved into DB2, Informix, Datacom, and Oracle administration in the centralized...
  • Inside SQL Server

    How safe is your database?

    • 1 Comments
    Ensuring your database is protected from loss is about as enjoyable as a dentist visit. We all know that we should have backups, and maybe even have thought about where we store the backups. I want to mention two items to think about today to save you...
  • Inside SQL Server

    When inserts don't scale, it's not time to bail

    • 1 Comments
    I often encounter questions on why an insert heavy workload doesn't scale well when moving a workload from a small server in a test environment to a much more powerful production server. Usually customers resolve the issue by adding multiple parallel...
  • Inside SQL Server

    Great SQL Server resources

    • 0 Comments
    The customer advisory team works directly with our biggest customers. Check out their blogs here: http://blogs.msdn.com/sqlcat/ Euan has a good blog with particular emphasis on tools. Euan owned the DTS product (now SSIS) before his current role http...
  • Inside SQL Server

    SQL Server 2005 SP2 is just around the corner

    • 1 Comments
    In case you were wondering... The SP2 relese of SQL Server is likely to be available in late March or early April. There is a really great new performance optimization in the SP: compressed vardecimal. Numeric and Vardecimal will save significant space...
  • Inside SQL Server

    Database virtualization is virtually certain

    • 1 Comments
    You may not realize it, but operating system virtualization is at least 40 years old. That's eons in the technology world. The first virtualization offering that I remember was IBM VM, however there were others before that point. IBM had an internal project...
  • Inside SQL Server

    Zero to high availability in 60 seconds...

    • 1 Comments
    I am a car fanatic. My first car was a Triumph GT6+ which I noticed under a tarp in my neighbors garage. It had been sitting idle for ten years. Six years ago, I modified a Mustang extensively, adding Brembo brakes and a supercharger, exhaust headers...
Page 1 of 1 (11 items)