(Brian Kelley) SQL Server has several methods of auditing logins and the simplest among these is to change the audit level within SQL Server. Using traces through Profiler or the set of trace stored procedures is another method, but most folks gets started by configuring auditing in Enterprise Manag
Author: SSWUG Research
In SQL: Unified Heterogeneous Virtual Hierarchical Views
(Michael M. David) This is the third and final part in this series of articles on ANSI SQL’s inherent hierarchical processing capability and its support of transparent native XML integration. Part 1, Using XML to Link Below the Root described how SQL can naturally integrate native XML at a full
DB2 64-Bit Support
This technote describes how to create and update a DB2 64-Bit instance.
SQL Server 2000 may overcommit physical memory on computers that are running Windows XP
Microsoft SQL Server 2000 may commit more memory than is physically available on a computer that is running Microsoft Windows XP. This problem only occurs for instances of SQL Server 2000 Service Pack 3 (SP3) or later versions. This problem may cause paging on the computer and lead to poor or slow p
Not Evil, Just Smelly
(Edd Dumbill) One wonderful and frustrating aspect of the XML community is its members’ willingness to reassess themselves and their endeavors, often entertaining deep divisions in views, and yet not self destruct into a puff of rhetorical logic. This was evidenced in a rather illuminating discu
SQL Server 2000 Report Pack for Microsoft Exchange
The SQL Server 2000 Report Pack for Microsoft Exchange is a set of 13 Microsoft SQL Server 2000 Reporting Services reports that work with a Microsoft Exchange sample reporting database. With the Report Pack, you have the choice of using the sample reports either as-is or as templates for designi
Part 2: Tuning Informix SQL
(Jianing Fan) This is the second of a two-part series on tuning Informix SQL. Part 1 introduced guidelines for SQL query tuning for Informix, looked at factors you need to consider when tuning SQL queries, and examined some real life tuning examples gathered from the author’s experience. Now the
.NET XML Best Practices: Reading XML Documents
(Aaron Skonnard) In the first part of this series, I covered the numerous XML-related classes in .NET for reading and writing XML documents and discussed the characteristics of each. As always in software development, there is a fundamental trade-off between performance/efficiency and productivi
J2EE Application Servers and Development Tools (The Minefield)
(Russell Ruggiero and Rex Brooks) While at lunch with two developers (J2EE and .NET), an interesting topic surfaced. The usual bantering about which camp had the better methodology was present, but one point hit home. Although, Microsoft embraces a different architecture compared with the Java three
Oracle Overhauls Analyzer Engine
(Jim Wagner) Oracle officials took the wraps off software formerly known as Sales Analyzer and Financial Analyzer, giving it a new database engine and name. Oracle Enterprise Planning and Budgeting (EPB) fills a gap in the Redwood Shores, Calif., company’s ERP software suite, providing real-time