The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Learn how to manage SQL Server and protect your databases with System Center 2007. Your system needs the support of several Windows services to function reliably, and our tour of the new System Center products will help you keep an eye on all of them.
By Michael Otey
This SMB-oriented storage device can help make your small busniess's backup strategy worry-free.
By Marina Davydova
Use a single SELECT command to calculate the business age between two dates in a database.
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.
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 John Savill
Learn about the updated products that comprise the latest version of Microsoft System Center.
By Blake Eno
Check out new and improved SQL Server–related products.
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
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.
Multicore processors improve your systems by bringing better database performance and scalability without big changes in price and power requirements.
If you're having trouble connecting to a hidden SQL Server named instance, try adapting the connection string. Here's how.
By William Sheldon
XML tool suites from Altova and DataDirect Technologies are both excellent for XML editing and XML Web services support.
By Jameel Ahmed
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 Michelle A. Poolet
Learn how BI and data warehousing are related.
By 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.
The star schema is the standard for supporting multidimensional cubes and supporting BI analysis across the organization.
By Kalen Delaney
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 Itzik Ben-Gan
Get the solution to June's puzzle "Same Birthday," and prepare your mind for July's puzzle, which involves an insect and two trains on a collision course.
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 Teo Lachev
SQL Server 2005 Analysis Services offers a robust role-based security model for restricting access to Unified Dimensional Model objects and data.
advertisement