SQL Server Magazine June 2006
[Focus]
Discover the keys to effective database-security testing: a well–thought-out testing plan, consistent reporting and bug-checking, and the use of scripts to automate testing tasks.
By Dan Sawyer
[Features]
Good news: You no longer need to write the same code in multiple places in Reporting Services. You’ll be pleased to see how easily you can use custom data processing extensions to share data sets across multiple reports.
By Andrew Potter
Are you unsure about whether to use database or storage replication to replicate your data? Here are three factors to consider before deciding which is best for you.
By Mel Shum
Check out Report Builder, a new and easy-to-learn ad hoc reporting tool in SQL Server 2005 Reporting Services.
By Tyler Chessman
Aggregate and rank window functions benefit BI projects.
By Dusan Petkovic
[SQL Server Savvy]
SQL Server Configuration Manager and SQL Server Surface Area Configuration tool have a lot in common, but Microsoft MVPs provide a general rule of thumb for when to use these tools.
By Brian Moran
Learn how to restore the registry and environment settings required by DTS if you're upgrading to SQL Server 2005.
By Brian Moran
Microsoft has changed the way that Books Online (BOL) works. Now, you have the added option to search Internet sources.
By Brian Moran
Yes, finding information about keyboard short cuts can be a challenge, but here's how users can find some of the common DExplore shortcuts.
By Brian Moran
It’s a good idea to know what third-party monitoring tools are doing if you choose to run them on your server. Here’s a problem you might encounter.
By Brian Moran
: SQL Server 2005 provides a new function called NewSequentialID that is very similar to NewID(). Find out which function gives better performance and which function lists results in sequential order.
By Brian Moran
[Editorial]
The x64 architecture is accelerating the move to 64-bit computing in the Windows Server space and database world. Both existing 32-bit executable programs and native 64-bit programs are benefiting with enhanced performance.
By Michael Otey
This first service pack isn’t driven by a bug issue. Instead, it's a push to deliver the features missing from the current release of SQL Server 2005–most notably database mirroring, an important feature in the very first CTPs of SQL Server 2005
By Michael Otey
[Inside SQL Server]
SQL Server 2005’s enhanced storage model adds flexibility for storing variable-length data, addresses the storage needs of partitioned tables and indexes, and provides views for tracking an object’s space usage.
By Kalen Delaney
[T-SQL Black Belt]
In this third part of a four-part series about custom aggregations, we look at a class of solutions that relies on UDAs.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server–related products.
By Blake Eno
[SELECT TOP(X)]
The 64-bit question faced by other administrators spells a 64-bit advantage for SQL Server admins—here's why!
By Michael Otey
Access Oracle data from SQL Server using these basic steps.
By Michael Otey
[Ask Microsoft]
Microsoft’s Vaquar Pirzada gives you options for performing very large set updates in SQL Server 2000.
By Microsoft's SQL Server Development Team
Microsoft’s Vaquar Pirzada explains how to use the sp_scriptdynamicupdproc stored procedure to include Identity field values in transactional replication.
By Microsoft's SQL Server Development Team
[From the Casebook of B.I. Powers, Consulting Detective ...]
A fanatical collector demands a report that will let her see everything in her collections. Can B.I. Powers provide the solution by modifying a Reporting Services parameter?
By Brian Larson
[Exploring SQL Server 2005]
SQL Server 2005 took the test and, with the help of a few key features, keeps its promise to be more productive than SQL Server 2000 and Oracle 10g R2.
By Matt Nunn
[Buyer's Guide]
SQL Server performance monitoring tools can help you detect and resolve performance problems before they become serious. Which tool should you consider?
By Trisha Pendley
|
