The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
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.
By Michelle A. Poolet
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.
Determine the type of data warehouse you have and the workloads it uses so that you can then optimize its performance.
By Megan Keller
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 Bill McEvoy
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 Omri Bahat
Find missing SQL Server jobs and scheduling conflicts by using two scripts that supplement SQL Server Agent job tracking.
Learn how indexed views differ from regular views.
Learn how to retrieve values from a table and store the results.
By Michael Otey
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 William Vaughn
Learn how to create unique primary keys for customer use.
Learn how to use Visual Studio’s Microsoft ReportViewer to extract reports.
By Caroline Marwitz
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.
Learn how to use ADO.NET 3.5 Synchronization Services classes to keep data in sync.
By Itzik Ben-Gan
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
Check out new and improved SQL Server-related products from SQL Sentry, Quest Software, Sentrigo, and AMB.
By John Green
Pragmatic Works' DTS xChange converts DTS packages to native SSIS packages for use with SQL Server 2008 and SQL Server 2005.
advertisement