Database Upgrade to SQL Server 2008 Tools and Approaches

Performing an upgrade is a complex and often risky project. A successful upgrade can provide an organization with a modern platform for development and production. An unsuccessful upgrade can cause lost time and money, and it can create a bad perception for the future.

This paper documents approaches and tools that can help DBAs and developers to achieve successful and mostly painless upgrade of SQL Server databases from Microsoft® SQL Server® 2000 or SQL Server 2005 to SQL Server 2008 (or SQL Server 2008 R2).

Tally Table Uses - Part II

In part II of this series, Sioban Krzywicki shows us another way Tally Tables have helped solve problems - Text Parsing.

Implementing SSIS Package Configurations

Marcin Policht demonstrates how to leverage SQL Server Integration Services (SSIS) package variables in order to modify SSIS properties without directly editing package content.

Parallelism and Performance: Are You Getting Full Return on Your CPU Investment?

A webinar from the PASS Performance VC on Aug 3, 2010

Tally Table Uses - Part I

In the first part of a series on Tally Tables, Sioban Krzywicki shows how a Tally Table has helped out with fiscal year calculations.

Making your database changes backward compatible: Changing a relationship

Let's face it: requirements change. There is usually a lot of churn during the design and initial development stages, but changes can happen to mature applications, too. The key is to introduce those changes with the least amount of effort and risk.

Fall 2010 Speaking Opportunities

There is no shortage of events that you can attend this fall and many of them are looking for speakers. If you've solved a problem at work, maybe you want to present a solution at one of these great events.

TSQL LAB 2 - Writing Conditional WHERE Clauses

Jacob Sebastian takes a look at some different ways to write your WHERE clauses. A good basic article for those starting to work with T-SQL.

Database Source Control- The Crib Sheet

As part of our long-running Cribsheet series, we asked William to come up with a brief summary of what was involved in bringing database development work under source control. What are the advantages it brings, and are there disadvantages?

New Features in Reporting Services 2008 and 2008 R2

Quietly, Microsoft has been making radical improvements to Reporting Services; but precisely what was introduced, and when? We asked Bill Pearson, the well-known BI expert, to come up with a definitive survey of the more recent changes and how they help the user of Reporting Services.