Browse by Tags

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...

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...

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...

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...

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...

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...