The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Are BI improvements in SQL Server 2008 enough to make you want to upgrade? To answer that question, explore enhancements to SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services.
By Kevin Kline
The SSMS Tools Pack provides features, such as a query logging tool, that enhance SQL Server Management Studio’s functionality.
By Itzik Ben-Gan
Handling distribution of events over time is tricky. Break the problem into steps. If handling all of a task’s requirements at once is too complicated, relax some requirements, solve a simpler form of the problem, then reintroduce the complexity layers.
By Michelle A. Poolet
Find out how you can keep your data warehouse design simple by placing miscellaneous attributes into junk dimensions.
By Bill McEvoy
Ensuring that databases are being backed up properly is an important but time-consuming task, especially for DBAs who manage multiple servers and databases. The sp_ShowBackups stored procedure makes this task quick and easy.
SELECT queries aren't just for retrieving data. You can also summarize that data by incorporating COUNT, MIN, MAX, AVG, and SUM functions into SELECT queries.
By Craig Utley
Learn how to build proper dimensions, add useful hierarchies that support user’s navigational needs, then perform the important step of adding attribute relationships to make your users' data analysis fast and easy.
By Michael Otey
Michael looks at some of SQL Server 2008's benchmark scores and discusses why the TPC-E benchmark currently isn't useful for comparing database platforms.
By John Green
These solutions help protect your SQL Server environment from unwanted modification by registering changes to data, server configurations, and schemas. Find out which one you can use to roll back changes or to migrate databases to a different platform.
By Don Kiely
Fortify the security of your SQL Server environment by using an assortment of tools for locating servers, identifying security best practices, cracking passwords, and finding vulnerabilities.
By
Check out new and improved SQL Server-related products from LogRhythm, Embarcadero, Vertica, and Markus Gruber.
By Andrew J. Kelly
Heed this advice about how to identify duplicate or redundant indexes on the tables in your databases.
Get the solution to April’s puzzle, “Suicidal Mosquito,” and prepare your mind for May’s puzzle, which involves distance calculation.
Client network libraries are vital in SQL Server, enabling the communications link between client applications and the SQL Server system. This list will help you get acquainted with SQL Server 2005’s client network libraries.
advertisement