By Robert R. Blizard – This SQL*Plus script lets you list the KEPT status for PL/SQL objects (Packages, Procedures, Functions, and Triggers) in your database. You can show objects with a KEPT status of YES, NO, or both, and select the schema to show using standard Oracle wildcards. The script also l
Author: SSWUG Research
SQL Server Log Shipping Overview
This article by SSWUG columnist Don Hite will describe the SQL server 2000 enterprise editions log shipping process and provide you with a quick background on it. Log shipping is particularly useful when a primary SQL server’s database or the server itself fails. Such failures can greatl
JavaTM Web Services Developer Pack 1.0
The JavaTM Web Services Developer Pack (Java WSDP) is an integrated toolset that in conjunction with the Java platform allows Java developers to build, test and deploy XML applications, Web services, and Web applications. The technologies comprising the Java WSDP v1.0 include the Java APIs for XML i
Securing your J2ME/MIDP apps
XML digital signature technology can help you implement lightweight and flexible security solutions for wireless Web services applications. In this article, Michael Yuan discusses the importance of XML digital signatures and their application. He also walks through the digital signature APIs of the
Microsoft to Give XML Bigger Role in Office
By Peter Galli – Microsoft Corp., which faces mounting competition and price pressure focused on its Office desktop productivity suite, is set to release the first beta of an Office upgrade.
SQL Server 7.0: index statistics details
By Alexander Chigrik – In this article, I want to tell you about distribution statistics, and about how you can view and update distribution statistics.
Automate the Documentation of SQL Server Using Total SQL Analyzer
by Brad M. McGehee – As SQL Server DBAs and developers, we all know how important it is to document our database designs and server configurations. Producing and maintaining complete SQL Server documentation is an important job of every SQL Server developer and DBA. Here are just a few of benefits o
Monitoring Current Number of Processes per Active Instance and Server
by Ilya Petrenko – Description: Here is a UNIX script (ksh) that will populate a report about current processes per Instance ( Local ( LOCAL=NO ) and remote (LOCAL=YES) ). This is useful for monitoring activities especially when application server site is “bombing” back-end site.
DBAs prep to skip Oracle school
By Sara Cushman – Oracle this week revamped their certification requirements, adding a $2,000 “hands-on” class that must be completed even by those who pass the company’s four exams. The company has added the class to its Oracle9i DBA Oracle Certified Professional (OCP) path, saying the new m
Upcoming Chat: SQL Server Replication
Wednesday, June 26 – Learn the best strategies to implement replication and troubleshoot any technical hurdles along the way from Microsoft’s own replication experts! This chat will cover all types of replication including Transactional Replication, Merge Replication and Snapshot Replication in SQL
