SQL Server Magazine May 2007
[Focus]
Data Mining Add-ins for Office 2007 help you develop business intelligence by using the power of SQL Server 2005 and Microsoft Office Excel 2007 to analyze your organization's data.
By Tyler Chessman
[Features]
Discover why SQL Server's built-in dependency tracking functionality doesn't work well and how the dependency checker avoids the same problems.
By Omri Bahat
Looking for high availability? You can implement database mirroring as an alternative to expensive third-party solutions. Here’s how.
By Sean McCown
Learn what steps to take to assess your SQL Server environment and determine whether planning a workload consolidation makes sense.
By Allan Hirt
Create an SSIS package that connects to all your SQL Server machines, pulls information into a central repository database, and feeds the combined data to a report.
By Rodney Landrum
[Editorial]
As you prepare to use either multicore CPU's or virtualization, you must be aware of the licensing ramifications for the OSs that support them and aplications such as SQL Server 2005.
By Michael Otey
[Reader Challenge]
Test your SQL Server savvy in this month's Reader Challenge. Submit your solution in an email message to challenge@sqlmag.com by May 10.
By Umachandar Jayachandran
[Reader to Reader]
Here's a technique that you can use to improve the performance of queries that run slow because of bookmark lookups.
By Kent Mitchell
Here's a search engine that targets SQL-related Web sites, which means you can enter fewer parameters when conducting searches for SQL material.
By Bill McEvoy
[Solutions by Design]
SQL Server sprawl is becoming an increasing headache for DBAs everywhere. But database consolidation's no picnic either. A centralized structure will ensure you keep your consolidation as simple as possible.
By Michelle A. Poolet
[T-SQL Black Belt]
This fourth part of a series about datetime challenges and calculations focuses on techniques for calculating the date of the first and last occurrences of a weekday in a month, based on a given event date.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server–related products.
By Blake Eno
[SELECT TOP(X)]
Do you run SQL Server in a virtual environment? Learn these best practices for virtualization, from memory allocation to clustering, and more.
By Michael Otey
[Review]
Simplify your SQL Server backup and recovery efforts with this disk-to-disk backup solution.
By John Green
This BI tool offers a rich set of visualizations to provide insight into your data.
By Jason Picker
[Industry Bytes]
Our editors share insights from their conversations with AppDev Products and Pillar Data Systems.
By Editors
|
