By Michelle A. Poolet, 04/19/2007
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 ...
By Omri Bahat, 04/19/2007
Discover why SQL Server's built-in dependency tracking functionality doesn't work well and how the dependency checker avoids the same problems.
By Rodney Landrum, 04/19/2007
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 Tyler Chessman, 04/19/2007
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 ...
By Bill McEvoy, 04/19/2007
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 Jason Picker, 04/19/2007
This BI tool offers a rich set of visualizations to provide insight into your data.
By John Green, 04/19/2007
Simplify your SQL Server backup and recovery efforts with this disk-to-disk backup solution.
By Itzik Ben-Gan, 04/19/2007
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, ...
By Sean McCown, 04/19/2007
Looking for high availability? You can implement database mirroring as an alternative to expensive third-party solutions. Here’s how.
By Itzik Ben-Gan, 04/19/2007
Get the solution to April's puzzle, "Naming an Heir," and prepare your mind for May's puzzle, which involves determining the next number in a series.
By Kent Mitchell, 04/19/2007
Here's a technique that you can use to improve the performance of queries that run slow because of bookmark lookups.
By Michael Otey, 04/19/2007
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 ...
By Editors, 04/19/2007
Our editors share insights from their conversations with AppDev Products and Pillar Data Systems.
By Allan Hirt, 04/19/2007
Hire someone to assist you in analyzing and assessing your SQL Server environment.
By Allan Hirt, 04/19/2007
Learn what steps to take to assess your SQL Server environment and determine whether planning a workload consolidation makes sense.
By Umachandar Jayachandran, 04/19/2007
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 Michael Otey, 04/19/2007
Do you run SQL Server in a virtual environment? Learn these best practices for virtualization, from memory allocation to clustering, and more.
By Blake Eno, 04/19/2007
Check out new and improved SQL Server–related products.