SQL Server Magazine April 2004
[Focus]
By adding SQL Server to Active Directory, you can help clients locate databases quickly, easily, and securely. AD's Service Publication and lookup let you keep server and database information up-to-date in a dynamic environment--or several of them.
By Chad Miller
[Features]
Analysis Services lets you create financial reports, but not always in the format your users need. Fortunately, you can learn from other developers. Here’s how one OLAP development team created detailed financial reports for a large banking group.
By Yoram Levin
The Database Maintenance Plan Wizard makes creating maintenance plans easy, but making less-optimal (or erroneous) choices is also easy. Follow these guidelines and avoid these gotchas when creating maintenance plans.
By Roman Rehak
ADO.NET is great for developing scalable Web applications, but it can be harder to use for development tasks such as retrieving IDENTITY column values. Try these two technniques for revealing your SQL Server's secret IDENTITY column values.
By Michael Otey
[SQL Server Savvy]
Is there a way to change the ordinal position of a column in a table without recreating the table?
By Brian Moran
SQL Server 7.0 doesn't provide a mechanism for changing collations on the fly. To change the collation of an existing database you'll need to rebuild the master database or reinstall SQL Server.
By Brian Moran
Windows Server 2003 doesn't support SQL Server 2000 Service Pack 2 (SP2) and earlier, but you can install those releases.
By Brian Moran
Windows Server 2003's Web Edition doesn't support SQL Server 2003 Standard and Enterprise Editions. You need to upgrade to Standard or Enterprise editions of Windows Server 2003 or run your database on another server.
By Brian Moran
If you accidentally delete a system stored procedure, how can you get Enterprise Manager to list the object as a system procedure after you add it back into the master database?
By Brian Moran
[Editorial]
The availability of multiple JDBC drivers helps SQL Server compete head-to-head with Oracle and DB2 as an enterprise database for Java applications.
By Michael Otey
[Inside SQL Server]
Yukon is bringing some important changes in security, including user/schema separation. But before you can take advantage of those changes, you need to understand how SQL Server deals with object ownership now.
By Kalen Delaney
[T-SQL Black Belt]
Come around the back for a peek into the hidden workings of some undocumented UDF features.
By Itzik Ben-Gan
[SELECT TOP(X)]
Microsoft’s new tool, the SQL Server 2000 Best Practices Analyzer, will help you keep your systems running at their peak by checking for the implementation of common best practices.
By Michael Otey
[Lessons from the Field]
The SQL Server Development Customer Advisory Team helps customers to implement high-volume data loading. In this month’s column, the team shares data-loading basics and information that will help you optimize your SQL Server bulk-load performance.
By Microsoft's SQL Server Development Team
[Preparing for SQL Server 2005]
To handle the needs of highly scalable business applications, Yukon’s SQL Server Service Broker lets internal and external processes send and receive reliable, asynchronous messages through extensions to T-SQL DML.
By Eric Brown
|
