This is yet another FAQ from Microsoft public SQL Server newsgroups. Lot of SQL Server developers are used to using @@IDENTITY to retrieve the value of the IDENTITY column immediately after inserting a row. We are missing that functionality when it comes to inserting rows with GUIDs as keys. Unfortu
Community
Detailed locking view: sp_lock2
By Alexander Chigrik – As a SQL Server DBA, I often need a reference to information about locks. Microsoft recommends using the sp_lock system stored procedure to report locks information. This very useful procedure returns the information about SQL Server process ID, which lock the data, about loc
Control Log File Growth to Avoid Out-of-Space Errors
By Andrew Georgopulos – The first step in my initiation as a SQL Server admin came after only a week or two on the job. I was confronted with a message that made my palms sweat. The error read something like this:
Startup bets on XML for integration
By Carolyn A. April – STARTUP ENOSYS SOFTWARE officially launches on Monday, rolling out a suite of data integration software that company officials claim features the first commercially available engine based on the XQuery standard.
Apache Ant 1.5Beta2
The Apache Jakarta Project has released version 1.5Beta2 of its cross-platform Java- and XML-based build tool, Ant.
Microsoft, Softricity Enter Agreement
Two promote a complementary solution that allows enterprise companies to manage existing Windows-based applications as XML Web services over corporate networks.
Using One-Way Functions to Protect Sensitive Information in SQL Server Databases
by Peter Wayner – Find out how one-way functions can be used to help protect sensitive data in your SQL Server databases.
SQL Server in the Fast Lane
By Michael Otey – Here are seven facts that reveal why SQL Server’s market share is increasing so quickly.
Support WebCast: Programming ADO SQLXML to Execute SQLXML Queries
Thursday, June 6, 2002: 10:00 A.M. Pacific time – The objective of this session is to introduce Visual Studio developers to the basics of using ADO in Microsoft Visual Studio 6.0 and ASP applications to access SQL Server data as XML by executing SQLML queries. You will learn about the underlying arc
Full Outer Joins in Oracle9i
Learn how to use the new ANSI-compliant join syntax, which simplifies the task of performing a full outer join, from Sanjay Mishra, coauthor of Mastering Oracle SQL.