Operating on different source SQL Server instances in a single SSIS package
In some cases we need to do a single task for lots of SQL Server instances. Assume that we have…
Archive
Category: Business Intelligence – BI
How to install database diagram support programmatically
In the previous article we discussed about how migrating a database diagram into another database. In this article I’ll quickly…
How to copy or migrate database diagrams into another database
We discussed in one of the previous articles called “How to store a SQL Server database diagram into a file…
Digging into SQL Server 2012 columnstore index
The SQL Server 11.0 release (code named “Denali”) introduces a new data warehouse query acceleration feature based on a new…