By John Green, 04/29/2008
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 ...
By Michael Otey, 04/29/2008
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, 04/29/2008
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 ...
By Andrew J. Kelly, 04/29/2008
Heed this advice about how to identify duplicate or redundant indexes on the tables in your databases.
By Kevin Kline, 04/29/2008
The SSMS Tools Pack provides features, such as a query logging tool, that enhance SQL Server Management Studio’s functionality.
By Editors, 04/29/2008
Check out new and improved SQL Server-related products from LogRhythm, Embarcadero, Vertica, and Markus Gruber.
By Michelle A. Poolet, 04/29/2008
Find out how you can keep your data warehouse design simple by placing miscellaneous attributes into junk dimensions.
By Don Kiely, 04/29/2008
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 ...
By Bill McEvoy, 04/29/2008
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 ...
By Craig Utley, 04/29/2008
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 ...
By Itzik Ben-Gan, 04/29/2008
Get the solution to April’s puzzle, “Suicidal Mosquito,” and prepare your mind for May’s puzzle, which involves distance calculation.
By Bill McEvoy, 04/29/2008
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 Itzik Ben-Gan, 04/29/2008
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, ...