by Andrew Allen – Sometimes we need (or want) to know who is using rollback and how much they are using. This script will show you who is using which rbs, how much rollback they are using, their sid/serial, and, optionally, when their session began and when they were last active in the database.
Author: SSWUG Research
Inherit the Database
In this article, Steven Feuerstein, coauthor of Oracle PL/SQL Programming, 3rd Edition, offers a quick review of object types and then shows how you can build “object type hierarchies” by taking advantage of inheritance.
Performance Tuning for SQL Server Developers
Don’t think that performance tuning your SQL Server applications is regulated to the end of the development process. If you want your SQL Server-based applications to scale and run at their full potential, you must begin considering scalability and performance issues during the early stages of your
CHECK It Out
By Itzik Ben-Gan – For accuracy and performance, you need to make sure that all IP addresses in your tables are valid. Here’s how to write a CHECK constraint that validates character strings containing IP addresses.
SQL Server Agent – Creating an Alert for ‘Could Not Allocate Space’ 1105 Errors
Alexzander Nepomnjashiy continues his new series that focuses on SQL Server alerts and errors with a look into creating a specific alert for ‘Could Not Allocate Space’ 1105 errors.
Community and Specifications
by Kendall Grant Clark – In this week’s column I return to pick up a bit more of the community’s debate about XML 1.1 before reviewing several other matters, including XInclude security and what processes or methodologies make for good XML specifications.
XML Matters: YAML improves on XML
By David Mertz, Ph.D. – In this article, David introduces you to YAML, a data serialization format that can be easily read by humans and is well-suited to encoding the data types used in dynamic programming languages. In contrast to XML, YAML uses clean and very minimal structural indicators, relyin
The horror of XML
By Larry Seltzer – I don’t know about you, but I’m scared. XML is becoming complex, and it was an inherently fat way to represent data to begin with. In fact, according to the W3C (the keepers of the Web), “XML is verbose, but that is not a problem.” This was a conscious decision by XML’s des
Oracle Plans Channel Program Tweaks
By Barbara Darrow – Oracle is honing its channel programs in hopes of reinvigorating software sales.For one thing, the database kingpin, which is trying to expand its franchise into business applications and Web application servers, will now segment its partner designations along product lin
Use SQL Server Triggers to Track Unauthorized Database Changes
by Susan Sales Harkins and Arthur Fuller – SQL Server can do all the work of tracking database modifications by responding to changes with predefined tasks.