Named and Optional Arguments in Office Development Using C#

In this video demo, I show you how to add text to a document and then convert it to a table, without using all sixteen parameters that are possible with the ConvertToTable method.  See the Video: How to Use Named and Optional Arguments in Office Programming (C#)     You can learn more in the overview of this feature, or follow along step-by-step .

See more here:
Named and Optional Arguments in Office Development Using C#

Upgrading an Application from SQL Server 2000 to SQL Server 2008

Microsoft® SQL Server® 2008 offers a plethora of new features targeted to end-users, DBAs, and developers alike. But what if you are still in the once bountiful but now barren land of SQL Server 2000? Follow along as we show you how to migrate a SQL Server 2000 database to SQL Server 2008 and reasons for migrating to SQL Server 2008.

See more here: 
Upgrading an Application from SQL Server 2000 to SQL Server 2008

Restore a SQL Server 2008 Database into SQL Server 2005

You likely will need to test data against SQL Server 2008 and SQL Server 2005, but ordinary backups are incompatible. Use SQL Server 2008′s Generate SQL Server Scripts Wizard to push your SQL Server 2008 data back into SQL Server 2005.

Continued here: 
Restore a SQL Server 2008 Database into SQL Server 2005