SQL Server Magazine September 2008

    Options
Implementing Microsoft's BI Platform
What does it take to get an end-to-end BI solution running? How long do you spend on the data warehouse, and how much does it all cost? Get first-hand answers from a large company’s BI director. 		  • Subscribe
• Renew
• Master CD
• Change Mailing Address
• Customer Service
• Back Issues
• Article Reprints
• Group Discounts

Browse Archived Articles By: Issue | Author | Subject | Department |


[Focus]

Implementing Microsoft's BI Platform

Premier Bankcard’s BI Director, Ron Van Zanten, shares his experience deploying Microsoft’s SQL Server 2005 BI platform--how long it took to get the data warehouse up and running and the challenges faced during implementation.
By Megan Bearly 



[Features]

Desperately Seeking Samples

Educate yourself on the design and operation concepts for databases and data warehouses by taking advantage of Microsoft’s sample databases. Although the business scenarios are fictitious, they translate to real-world uses.
By Michelle A. Poolet 

Plugging the Gaps in SQL Server Job Tracking

Find missing SQL Server jobs and scheduling conflicts by using two scripts that supplement SQL Server Agent job tracking.
By Omri Bahat 

T-SQL 101: Views

The virtual nature of a view is its greatest strength and its greatest weakness. Here's what you need to know to create views and use them wisely.
By Bill McEvoy 



[Editorial]

Demystifying SQL Server Virtualization This article is only available to registered users. Sign up now and get instant access!

Michael Otey dispels some myths surrounding SQL Server virtualization, including the notion that all virtualization platforms are created equal. He explains the high-level differences between the hosted, hypervisor, and virtualized OS platforms.
By Michael Otey 



[Reader to Reader]

Get Rid of Gaps in Numerical Sequences This article is only available to registered users. Sign up now and get instant access!

Although companies might want integer sequences in database applications to be gapless, gaps occur frequently. Here's a solution that you can use to eliminate existing and avoid new gaps.
By Readers 



[Solutions by Design]

Data Warehouse Workloads and Use Cases

Determine the type of data warehouse you have and the workloads it uses so that you can then optimize its performance.
By Michelle A. Poolet 



[T-SQL Black Belt]

Discover the Benefits of Filtered Indexes and Statistics

Learn how you can take advantage of SQL Server 2008’s filtered indexes and statistics feature to improve query performance and obtain detailed and accurate distribution statistics.
By Itzik Ben-Gan 



[New Products]

New Products

Check out new and improved SQL Server-related products from SQL Sentry, Quest Software, Sentrigo, and AMB.
By Editors 



[SELECT TOP(X)]

T-SQL Enhancements in SQL Server 2008, Part 2 This article is only available to registered users. Sign up now and get instant access!

SQL Server 2008 powers up T-SQL with new features such as the GROUPING SETS operator and table-valued parameters.
By Michael Otey 



[Review]

DTS xChange

Pragmatic Works' DTS xChange converts DTS packages to native SSIS packages for use with SQL Server 2008 and SQL Server 2005.
By John Green 



[Buyer's Guide]

Database Encryption Solutions

Database encryption can protect your data from internal and external attacks. When choosing a solution, consider who you are protecting data for and who you are protecting it from, along with any compliance regulations.
By Caroline Marwitz