The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
See how to help clients locate databases quickly and securely by adding SQL Server to Active Directory. Then, learn two ways to retrieve IDENTITY column values through ADO.NET, how to use Analysis Services to build detailed financial reports, and more!
By Itzik Ben-Gan
Come around the back for a peek into the hidden workings of some undocumented UDF features.
By Brian Moran
Is there a way to change the ordinal position of a column in a table without recreating the table?
By Chad Miller
A bit of essential information for those unfamiliar with Active Directory programming.
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 Michael Otey
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.
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 Yoram Levin
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 Roman Rehak
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
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.
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.
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 Eric Brown
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 Kalen Delaney
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.
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.
Windows Server 2003 doesn't support SQL Server 2000 Service Pack 2 (SP2) and earlier, but you can install those releases.
The availability of multiple JDBC drivers helps SQL Server compete head-to-head with Oracle and DB2 as an enterprise database for Java applications.
advertisement