The Curious Engineer

All blogs / Databases

Helping community in helping themselves...

learn.microsoft.com/en-us/archive/blogs/arali

DatabasesMicrosoft blogsMSDN archive

’10’15’20’25
Posts
37 from 25 Nov 2009 to 4 Mar 2010
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/arali/feed.xml

2010 19

  1. Basic Storage Modes (MOLAP, ROLAP and HOLAP) in Analysis Services
  2. SQL Server 2008 R2 - SQL Azure Enhancements
  3. SQL Azure - Starting up...
  4. How to upgrade SSIS 2005 Packages to SSIS 2008
  5. Transfer SQL Server database schema objects and data to another server or database with SMO
  6. Backup and Restore SQL Server databases programmatically with SMO
  7. Generate SQL Scripts for database objects with SMO
  8. Accessing SQL Server programmatically with SQL Server Management Objects (SMO)
  9. Database Impersonation with EXEC AS in SQL Server
  10. Executing dynamic SQL scripts on remote SQL Server with EXEC AT statement
  11. Reorganize and Rebuild Index in SQL Server 2005 and 2008
  12. Identifying fragmentation level in SQL Server 2005 and 2008
  13. Spatial Data Types (GEOMETRY and GEOGRAPHY) in SQL Server 2008
  14. FILESTREAM Data Type in SQL Server 2008
  15. Large User Defined Types in SQL Server 2008
  16. HIERARCHYID Data Type in SQL Server 2008
  17. New Date and Time Data Types in SQL Server 2008
  18. User-Defined Table Type and Table Valued Parameter (TVP) in SQL Server 2008
  19. SQL Server 2008 : T-SQL Enhancements

2009 18

  1. SQL Server Integration Services ( SSIS ) - Best Practices
  2. Sending HTML formatted email from SSIS (SQL Server Integration Services)
  3. VSTA support for Script Task and Script Component in SSIS ( SQL Server Integration Services ) 2008
  4. Pipeline Performance Improvements in SSIS ( SQL Server Integration Services ) 2008
  5. Data Profiling task in SSIS (SQL Server Integration Services ) 2008
  6. Lookup Transformation in SSIS ( SQL Server Integration Services ) 2005 and 2008
  7. SQL Server Integration Services ( SSIS ) Parallel Processing
  8. Designing an ODS / DW with high availability and consistency
  9. SQL Server Integration Services ( SSIS ) Buffer Management
  10. SQL Server Integration Services ( SSIS ) Transformation and Execution Tree
  11. SQL Server Integration Services ( SSIS ) Architecture
  12. SQL Server Integration Services (SSIS) - Checkpoint Restart-ability
  13. SQL Server Integration Services (SSIS) - Transaction Support
  14. SQL Server Integration Services (SSIS) - Event Handlers
  15. SQL Server Integration Services (SSIS) - Event Logging
  16. Introduction of SQL Server Integration Services - A Tutorial article
  17. About Me
  18. SQL Server - Max Degree of Parallelism (MAXDOP)