SQL Azure -- Relational Database in the Cloud - At Code Camp 13, Waltham Satu...
SQL Azure is Microsoft's relational database offering in the cloud. While it's similar to SQL Server 2008 there are enough differences that it's important to understand what you can and can not do with SQL Azure.
Topics:
* Signing up for SQL Azure
* Creating a database
* Differences from SQL Server 2008
* Moving schema and data up and down from the cloud
* Using the Sync Framework 2.0 to move data
Introduction to SQL Server Integration Services (SSIS)
This presentation and code example are an introduction to SQL Server Integration Services (SSIS) the ETL tool that is part of SQL Server 2005 and 2008. The presentation was first given at the New England Visual Basic Professionals in March 2010.
dba_spaceused
This article presents a stored procedure for convenient reporting of the space consumed by each table. It's uses SQL Server's sp_spaceused to compatibility but includes the schema so that like named tables can be distinguished.