SQL Server Magazine September 2008
[Focus]
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 Keller
[Features]
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
Find missing SQL Server jobs and scheduling conflicts by using two scripts that supplement SQL Server Agent job tracking.
By Omri Bahat
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]
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
[Solutions by Design]
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]
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]
Check out new and improved SQL Server-related products from SQL Sentry, Quest Software, Sentrigo, and AMB.
By Editors
[Review]
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 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
|
