SQL Server Magazine August 2005
[Focus]
The release of SQL Server 2005 brings lots of changes in every aspect of the product. Join Kalen Delaney and Ron Talmage on an exploration of the new management tools.
By Kalen Delaney , et al.
[Features]
If you're looking for an easy-to-use solution for your organization's high-availability and disaster-recovery needs, this real-world example can help you decide whether merge replication is a good choice for you.
By Gary Zaika
SQL Server 2005 Integration Services (SSIS) still includes familiar security functions such as password encryption, but the approach has changed dramatically. Take a look at the new security features and learn how and when to use them.
By Kirk Haselden
Are your tables out of control? This method lets you flexibly add tables to your database application while keeping your database structure manageable.
By Bálint Nagy , et al.
[SQL Server Savvy]
A few months ago, Microsoft launched a new-and-improved SQL Server TechCenter "designed to connect you with SQL Server-related resources from Microsoft and the broader SQL Server community."
By Brian Moran
If you want Profiler to show timings between 0 and 10 ms, all you have to do is tell your boss that you want to install a non-supported extended stored procedure that's based on non-supported technology from Microsoft Research.
By Brian Moran
You can use a simple technique that relies on xp_cmdshell to perform a reverse DNS lookup.
By Brian Moran
Is there a way to simulate a parallel plan on a uni-processor server for testing and development purposes?
By Brian Moran
A quick query to find out whether two fields together are unique and if you can use the combination as a primary key.
By Brian Moran
[Editorial]
Despite the slew of new features in other areas of the product, SQL Server 2005 could easily be known as "the BI release."
By Michael Otey
[Inside SQL Server]
You can work around some of the drawbacks of conditionally recompiling stored procedures, but be careful when handling dynamic SQL.
By Kalen Delaney
[T-SQL Black Belt]
Dealing with auditing issues can be tricky, and you need to apply logic to come up with solutions. T-SQL master Itzik Ben-Gan offers these tips for audit triggers.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server–related products.
By Dawn Cyr
[SELECT TOP(X)]
Temporary tables are a great T-SQL developer feature that lets you store and process intermediate results. Here are seven tips to help you manage the temporary tables your T-SQL procedures use.
By Michael Otey
[Preparing for SQL Server 2005]
Report Builder is an end-user reporting tool that lets business users create Reporting Services reports without using Visual Studio. Learn how this tools works and how it can simplify your life.
By Matt Nunn
[Hands On]
A reader highlights his favorite product: SQL Turbo
By Dawn Cyr
|
