Compared to SQL Server, Oracle allows a DBA to go much further under the hood to properly manage data space requirements. However, space allocation in Oracle is complicated. Joe Lax shows you how locally managed tablespaces can let the database engine make most of the decisions for you.
Author: SSWUG Research
ROLLUP feature in Oracle 8i
By Srinivas Chittimalla – If you wish to find, for example, the number of employees by department, you can use the following query (using the standard demo tables in Oracle).
Configuring a Mail Profile for SQL Server
You can configure a SQL Server mail profile so you can send and receive e-mail by running Transact-SQL code (for example, by using the xp_sendmail extended stored procedure to send e-mail). You can also configure a mail profile for SQL Server Agent so that e-mail will be sent to operators automatica
Creating Alerts on Database Server Performance Conditions with Performance Monitor
Alexzander Nepomnjashiy continues his series focusing on SQL Server alerts and errors with a detailed look into using the Windows Performance Monitor to proactively track SQL Server performance.
XML Versus the Infoset
by Rich Salz – In my prior columns I’ve examined specific protocols and pieces of the web services infrastructure, including WSDL, SOAP attachments, and so on.But in this column I venture a bit further afield; it’s more like an op-ed than straight reportage: less fact, more opinion, if you w
SOAP Web Services: built on a contradiction?
The fifth annual Forum XML, on November 12-14 in Paris, featured a consistent theme–that SOAP-based Web Services seem more than ever based on a contradiction, even as they are being positioned by vendors as a foundation for both loosely coupled systems and a new RPC architecture.
Automate Stored Procedure Parameters
by Dan Wahlin – Dealing with parameters in stored procedures can be laborious and time-intensive. Simplify the process with XML—download a sample app to show you how.
Proper XML Output in Python
by Uche Ogbuji – I planned to conclude my exploration of 4Suite this time, but events since last month’s article led me to discuss some fundamental techniques for Python-XML processing first. First, I consider ways of producing XML output in Python, which might make you wonder what’s wrong with good
Tip: Use imports and includes to override XSLT templates
By Nicholas Chase – Extensible Stylesheet Language Transformations (XSLT) provide two different ways to combine several style sheets in the transformation of a single source document. In the process, it’s almost inevitable that more than one template can apply to a single node. Which template is act
Beware of Illegal Characters in XML
by Jonathan Goodyear – If your XML parsing takes a sudden wrong turn, your XML file might contain an illegal character. Learn what these characters are, when they crop up, and what to do about them.