|
Make migrating/promoting DTS packages and SSIS packages from dev to test to production seamless and easy |
|
Making DTS and SSIS Packages Portable — AZ SQL Server Users Group Feb 2006 |
|
Articles |
|
Sometimes you just need to extract every other row from a result set. Other times you need a row number so as to provide paging in a web application.
Here is an example of how to extract every other row from a result set in both SQL Server 2000 and SQL Server 2005 |
|
SQL 2000 and 2005 How to use Row Numbering to get every other row from a result set |
|
Learn how to migrate from SQL 7 and SQL 2000 to SQL 2005. Inplace upgrade and side by side migration will be covered. Upgrade Advisor, Backup and Restore, Detach and Attach, and SSIS will be discussed in relation to upgrading. |
|
Migrating to SQL Server 2005 — Desert Code Camp Oct 2006 |
|
Expand your bag of tricks by learning more about how to use XML in both SQL 2005 and SQL 2000. XQuery (including FLOWR), FOR XML and OPEN XML
|
|
XML Inside SQL Server 2005 — Desert Code Camp May 2006 |
|
Add to your Bag of T-SQL tricks. Learn about the enhancements to T-SQL with SQL Server 2005: NTILE, RANK, Row_Number, Output, Pivot, UnPivot, Common table expressions, recursion using Common table expressions, AND APPLY. |
|
T-SQL 2005 Enhancements, Tricks and Tips — Desert Code Camp May 2006 |
|
Learn how to use the Windows Script Host and Windows Management Instrumentation (focus on VBScript, with a Jscript and Perl example as well) to make better login scripts, and automate some of your administrative chores. |
|
Automate Windows Administration — LOPSA Phoenix SysAdmin Days Nov 6-7 2006 |