SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Sean Woehrle

SQLServerCentral.com profile

   Items 1 to 3 of 3   

Implementation of partition switching within SSIS

In the third part of a series on loading a partitioned data warehouse efficiently, we see how SSIS can be used to perform the ETL tasks.  Read more...
Rating: |  Discuss |   Briefcase | 4,824 reads

Partitioning Data in a Multi-tenant Data Warehouse Solution

Part two of our series looks at the partitioning strategy to separate customers' data, providing security and performance.  Read more...
By Sean Woehrle 2014/04/22 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 4,827 reads

SaaS and Multi-tenancy Models

If you need to architect a multi-tenant Analysis Services project, what are your options? This piece from Sean Woehrle shows four options and explains why he picked a particular one.  Read more...
By Sean Woehrle 2014/03/11 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 5,347 reads
   Items 1 to 3 of 3