June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Migrating DTS Packages to Integration Services

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Business Intelligence, Data Warehousing, SQL White Papers
Migrating DTS Packages to Integration Services Writer: Brian Knight Published: July 2008 SQL Server Integration Services (SSIS) brings a revolutionary concept of enterprise-class ETL to the masses. The engine is robust enough to handle hundreds of millions of rows with ease, but is simple enough to let both developers and…
Read More

SQLAuthority News – Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL White Papers
Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation logo-sql08.gif SQL Server Technical Article Writers: Mark Theissen, Eric Kraemer Published: February 2009 To date, the implementation of a true hub-and-spoke architecture for a data warehouse environment has been an idealized and elusive goal. Although building a centralized “hub,”…
Read More

SQL SERVER – White Paper – Partitioned Table and Index Strategies Using SQL Server 2008

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices, SQL Index, SQL White Papers
Partitioned Table and Index Strategies Using SQL Server 2008 Writer: Ron Talmage, Solid Quality Mentors Technical Reviewer: Denny Lee, Wey Guy, Kevin Cox, Lubor Kollar, Susan Price – Microsoft Greg Low, Herbert Albert – Solid Quality Mentors When a database table grows in size to the hundreds of gigabytes or…
Read More

SQL Server – White Paper – An Introduction to Fast Track Data Warehouse Architectures by Erik Veerman

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Business Intelligence, Data Warehousing, SQL White Papers
An Introduction to Fast Track Data Warehouse Architectures SQL Server Technical Article Writer: Erik Veerman, Solid Quality Mentors Technical Reviewer: Mark Theissen, Scotty Moran, Val Fontama Published: February 2009 The performance and stability of any application solution—whether line of business, transactional, or business intelligence (BI)—hinges on the integration between solution…
Read More

SQL SERVER – White Papers – Consolidation Guidance for SQL Server – Consolidation Using SQL Server 2008

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, SQL White Papers
Consolidation Using SQL Server 2008 Writer: Allan Hirt, Megahirtz LLC (allan@sqlha.com) Technical Reviewers: Lindsey Allen, Madhan Arumugam, Ben DeBow, Sung Hsueh, Rebecca Laszlo, Claude Lorenson, Prem Mehra, Mark Pohto, Sambit Samal, and Buck Woody Published: October 2009 What are the considerations when creating a consolidation plan for my environment? What…
Read More

SQLAuthority News – SQL Server R2 Resources Downloads, Documentations

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Data Warehousing, Database, SQL Documentation, SQL Download, SQL White Papers
Microsoft SQL Server 2008 R2 November Community Technology Preview Building on SQL Server 2008, R2 provides an even more scalable data platform with comprehensive tools for managing your databases and applications, improving the quality of your data, and empowering your users to build rich analyses and reports using tools they…
Read More