How much space does each table take up?

In the DevOps world space matters, especially when you are using PAAS databases in the cloud such as Azure SQL Database (aka SQL Azure) where there can be tight space limits per database.  One useful way to keep track of how much space each table (and accompanying indexes) take up is to use a query…

0

AdventureWorks Community Sample Databases available for SQL Azure

It is a delight to announce the availability of the AdventureWorks Community Sample Databases for SQL Azure.  You can download the scripts and data files from CodePlex.  To install the databases on your SQL Azure server just follow the directions on the release page at CodePlex or in the ReadMe.htm file which is included in…

0

SQL Server 2008 SR4 sample database installer available

Based on the success of the new sample databases installer we created for SQL Server 2008R2, we’ve created a new samples refresh (SR4) for SQL Server 2008 on CodePlex at http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=37109.  This is a much simpler and more robust installer which allows you to select the databases that can be successfully installed, and also provides…

2

Code Samples for SQL Server 2008R2 November CTP available

It is a delight to announce that SQL Server 2008R2 November CTP3 code samples are now posted to CodePlex at http://sqlserversamples.codeplex.com/.  The wiki pages have been updated to reflect the availability of the new sample code installers.  These installers join the already released AdventureWorks Sample Databases for KJ on CodePlex and complete the sample work for SQL…

0

SQL Server 2008R2 Sample Databases Updated

The AdventureWorks sample databases for SQL Server 2008R2 have been updated and are available at http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=24854.  This version includes both the AdventureWorks 2008R2 schema and data, and the original AdventureWorks schema and data which shipped with SQL Server 2005.  With this one installation package you get the databases you’ll need to run most samples, and…

1

SQL Server 2008 (Katmai) October 2009 Samples Refresh 3 Available

SQL Server 2008 (Katmai) October 2009 Samples Refresh 3 is now available.  SQL Server 2008 (Katmai) Product Samples Refresh 3 is now live at http://sqlserversamples.codeplex.com/.  There are numerous bug fixes and a new sample, RSPermissions which demonstrates how to write an application which manages Reporting Services permissions via the Reporting Services Web Service API.  There…

0

The transition to community based development

The times they are a changin’  When I first started working on code to share with the SQL Community that code shipped in the box with very little community participation.  Over the years my job has changed and so has the processes we use to create open source samples and tools that we share with…

1

New step-by-step instructions for installing sample databases

The new sample database installers which shipped at the end of October 2008 greatly simplify the installation process for the sample databases.  For one thing, there are only three installers to choose from instead of tens of installers.  Just pick the install that is right for the architecture of the machine you’ll be installing on…

0

October 2008 SQL Server Samples Refresh

We’ve completed an October refresh of the SQL Server 2008 samples (http://CodePlex.com/SqlServerSamples). We’ve heard from you that the install experience for the databases was too complex and error prone.  In this refresh we’re providing a much simpler install experience with a lot fewer database installers to choose from.  Please let us know how you like this…

2

SQL Server 2008 Samples are here!

SQL Server 2008 samples are now available at http://codeplex.com/SqlServerSamples.  That’s our portal page to many different product and community projects on CodePlex with samples for SQL Server.  On the releases tab of the portal page you’ll find installers for downloading all the code samples.  If you’re looking for the sample databases for SQL Server 2008,…

3