The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Say goodbye to tedious manual database-security checks. With Dan Sawyer's know-how and script, you can develop an organized security-testing plan that checks your designated configuration settings and reports the testing results.
By Brian Larson
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 Tyler Chessman
Learn different ways to build a report model.
By Dan Sawyer
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
Microsoft’s Vaquar Pirzada explains how to use the sp_scriptdynamicupdproc stored procedure to include Identity field values in transactional replication.
Microsoft’s Vaquar Pirzada gives you options for performing very large set updates in SQL Server 2000.
Check out Report Builder, a new and easy-to-learn ad hoc reporting tool in SQL Server 2005 Reporting Services.
By Blake Eno
Check out new and improved SQL Server–related products.
By Michael Otey
The 64-bit question faced by other administrators spells a 64-bit advantage for SQL Server admins—here's why!
By Trisha Pendley
SQL Server performance monitoring tools can help you detect and resolve performance problems before they become serious. Which tool should you consider?
By Itzik Ben-Gan
In this third part of a four-part series about custom aggregations, we look at a class of solutions that relies on UDAs.
By Mel Shum
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.
In SQL Server 2005, you create a VSortedOrders view in the Northwind database, then issue a particular query. The results aren't what you expected. Can you identify the bug in the code and suggest a solution?
By Brian Moran
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 Dusan Petkovic
Aggregate and rank window functions benefit BI projects.
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 Kalen Delaney
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.
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
: 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 Matt Nunn
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.
Access Oracle data from SQL Server using these basic steps.
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.
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.
Learn how to restore the registry and environment settings required by DTS if you're upgrading to SQL Server 2005.
By Andrew Potter
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.
Microsoft has changed the way that Books Online (BOL) works. Now, you have the added option to search Internet sources.
advertisement