Browse by Tags

Tagged Content List
  • Blog Post: Which Edition of SQL Server 2008 R2 should you use?

    SQL Server 2008 R2 has just released to manufacturing (RTM’d) as I write this. With each new release, we make changes to the “Editions” we offer. A SQL Server “version” deals with the major changes in the product – and “edition” is a set of features and capabilities within that version (you’re welcome...
  • Blog Post: Spit it out already!

    You’ve probably seen that commercial where the chewing-gum company van stalks the guy who has been chewing the same piece of gum too long, and they attack him and make him chew another piece. I feel like that with SQL Server 2000. Almost every shop I go into has at least one primary application running...
  • Blog Post: SQL Server Best Practices: Protect CmdExec

    In SQL Server, there are times that you need to do things in the operating system, and to allow that there is a feature called CmdExec. This is not always a good thing –whenever you leave the confines of SQL Server and go out to the operating system, you can cause issues, not the least of which are security...
  • Blog Post: The SQL Server Central Management System

    Yesterday I delivered a pre-conference session at TechEd US in Los Angeles. I covered lots of SQL Server 2008 features, but the key was that we ended up putting them all together for a single purpose. Most of us have a way of aggregating the data about our systems. We do it through lists, spreadsheets...
  • Blog Post: Service Broker and the Need for Planning

    I mentioned yesterday about the database I was using implemented Service Broker. I wanted to mention (again) the incredible need for planning when you're setting up a project. Whenever you're working on something as distributed as Service Broker, you have to include the logical diagrams as well as the...
  • Blog Post: Support for SQL Server 2000 is ending - make your plans!

    We're at the end of "Mainstream" support for SQL Server 2000, which is April 8th, 2008. If you're still using this version in your enterprise, you need to plan to move off of that version platform starting now. Many folks are planning to "jump" from SQL Server 2000 to SQL Server 2008, but if you need...
Page 1 of 1 (6 items)