By Dee Quang - Ever get confused by or dislike using the SQL Server Integration Services deployment wizard? Learn how to manually deploy the packages to SQL Server 2005 and configure the packages in a multitude of ways as well.
Ponderings about the Tech Ed 2007 Keynote
The people at Microsoft are busy with lots of products. Did someone forget that they should be excited about them?
Temporary Tables vs. Table Variables and Their Effect on SQL Server Performance
Follow an experiment and draw interesting conclusions on where and when to use temporary tables or table variables.
Report Solution Patterns and Recipes: Creating Sparklines
In the last of this three-part SQL Server Reporting Services recipe series, Wrox author Paul Turley shows how to create the graphics for word-size graphics that visualization pioneer Edward Tufte dubbed sparklines.
Forging Transact SQL Code with CodeSmith
If you're haven't used CodeSmith for your TSQL coding yet, now's the time. This template-based code generator enables you to add fire-and-forget programming to your TSQL development.
SQL Server 2005 Compact Edition: The Little Engine That Can
Microsoft SQL Server 2005 Compact Edition provides relational database functionality for mobile and desktop applications through a lightweight and easily distributable engine. Take a look under the hood.






