SQL Server Magazine May 2008
[Features]
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 Craig Utley
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 Don Kiely
Heed this advice about how to identify duplicate or redundant indexes on the tables in your databases.
By Andrew J. Kelly
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 Bill McEvoy
[Editorial]
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 Michael Otey
[Reader to Reader]
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.
By Bill McEvoy
[Solutions by Design]
Find out how you can keep your data warehouse design simple by placing miscellaneous attributes into junk dimensions.
By Michelle A. Poolet
[T-SQL Black Belt]
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 Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server-related products from LogRhythm, Embarcadero, Vertica, and Markus Gruber.
By Editors
[SELECT TOP(X)]
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.
By Michael Otey
[Tool Time with Kevin Kline]
The SSMS Tools Pack provides features, such as a query logging tool, that enhance SQL Server Management Studio’s functionality.
By Kevin Kline
[Review]
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 John Green
|
