By Michael Otey, 05/23/2006
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 ...
By Brian Moran, 05/23/2006
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 Dan Sawyer, 05/23/2006
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 Itzik Ben-Gan, 05/23/2006
By Matt Nunn, 05/23/2006
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 Mel Shum, 05/23/2006
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 Microsoft's SQL Server Development Team, 05/23/2006
Microsoft’s Vaquar Pirzada gives you options for performing very large set updates in SQL Server 2000.
By Tyler Chessman, 05/23/2006
Check out Report Builder, a new and easy-to-learn ad hoc reporting tool in SQL Server 2005 Reporting Services.
By Kalen Delaney, 05/23/2006
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 ...
By Brian Larson, 05/23/2006
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 Microsoft's SQL Server Development Team, 05/23/2006
Microsoft’s Vaquar Pirzada explains how to use the sp_scriptdynamicupdproc stored procedure to include Identity field values in transactional replication.
By Brian Moran, 05/23/2006
: 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 ...
By Michael Otey, 05/23/2006
The 64-bit question faced by other administrators spells a 64-bit advantage for SQL Server admins—here's why!
By Itzik Ben-Gan, 05/23/2006
In this third part of a four-part series about custom aggregations, we look at a class of solutions that relies on UDAs.
By Tyler Chessman, 05/23/2006
Learn different ways to build a report model.
By Blake Eno, 05/23/2006
Check out new and improved SQL Server–related products.
By Dusan Petkovic, 05/23/2006
Aggregate and rank window functions benefit BI projects.
By Itzik Ben-Gan, 05/23/2006
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 ...
By Trisha Pendley, 05/23/2006
SQL Server performance monitoring tools can help you detect and resolve performance problems before they become serious. Which tool should you consider?
By Brian Moran, 05/23/2006
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 ...
By Brian Moran, 04/20/2006
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 Michael Otey, 04/20/2006
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 ...
By Michael Otey, 04/20/2006
Access Oracle data from SQL Server using these basic steps.
By Andrew Potter, 04/20/2006
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 ...
By Brian Moran, 04/20/2006
Learn how to restore the registry and environment settings required by DTS if you're upgrading to SQL Server 2005.
By Brian Moran, 03/22/2006
Microsoft has changed the way that Books Online (BOL) works. Now, you have the added option to search Internet sources.