SQL Server Magazine July 2007
[Focus]
Microsoft System Center 2007 products offer many new SQL Server management features, such as more detailed alerting, configuration management, and SQL Server–specific data protection.
By John Savill
[Features]
Use a single SELECT command to calculate the business age between two dates in a database.
By Marina Davydova
SQL Server 2005 Analysis Services offers a robust role-based security model for restricting access to Unified Dimensional Model objects and data.
By Teo Lachev
[Editorial]
Server consolidation is a popular trend, but this solution might not be right for your organization. Find out how SQL Server systems aren't always best-suited for consolidation.
By Michael Otey
[Reader to Reader]
If you're having trouble connecting to a hidden SQL Server named instance, try adapting the connection string. Here's how.
By Readers
When a SQL Server job fails, SQL Server Agent sends a notification but it doesn't include the error message generated by that job failure. Here's how you can have the error message emailed to you.
By Readers
If your queries against a table or database are running slow, the indexes in that table might be fragmented. The cspDefragIndexes stored procedure can quickly and easily take care of the problem.
By Readers
[Inside SQL Server]
SQL Server 2005 plan guides let you instruct the optimizer about when to use a particular hint, to boost a query's performance—but you should use them sparingly.
By Kalen Delaney
[Solutions by Design]
The star schema is the standard for supporting multidimensional cubes and supporting BI analysis across the organization.
By Michelle A. Poolet
[T-SQL Black Belt]
Need to identify sections of consecutive rows that share the same value? We demonstrate two techniques to solve the problem—one based on a subquery, and the other based on row numbers.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server–related products.
By Blake Eno
[SELECT TOP(X)]
You can back up SQL Server databases with the latest version of Microsoft System Center Data Protection Manager—DPM 2007—but there are also other good reasons to try DPM 2007, including CDP and 64-bit support.
By Michael Otey
[Tool Time with Kevin Kline]
Overwhelmed by all the data from those server-side traces or SQL Server Profiler sessions? This free graphical summary tool can help you make sense of it all and improve your system performance.
By Kevin Kline
[Review]
This SMB-oriented storage device can help make your small busniess's backup strategy worry-free.
By Michael Otey
XML tool suites from Altova and DataDirect Technologies are both excellent for XML editing and XML Web services support.
By William Sheldon
[Market Watch]
Multicore processors improve your systems by bringing better database performance and scalability without big changes in price and power requirements.
By Michael Otey
|
