(Ronald) I’ve been playing more with the SHOW PROFILE command available as part of MySQL Community 5.0.37. Thanks to the author Jeremy Cole. This command can provide some interesting insight into the workings of MySQL. It does however like most new releases of software enable users to make suggestio
Author: SSWUG Research
Copy legacy Oracle tables with SQL*Plus
(Bob Watkins) You may be running Oracle 10g Release 2, but the applications you’re supporting may have been written much earlier. Tables developed in versions of Oracle prior to 8i often used the LONG datatype to store large amounts of text.
Totals and blank lines
(Michael Armstrong-Smith) The following is an interesting conundrum that I have come across recently and is something that you might be interested in knowing about. It’s concerned with what happens when you combine sub-totals and additional rows between group sorted items.
Custom Auto-Generated Sequences with SQL Server
(Jeff Smith) This article covers different ways to create sequence numbers. It starts with the basic identity and GUIDs and quickly moves to much more complicated sequence numbers including those with auto-incrementing mixed letters and numbers such as “A0001”, etc. The author shows one of the easie
Creating a Custom Content Formatter for SSNS 2005
(Joe Webb) Microsoft SQL Server Notification Services 2005 (SSNS 2005) provides a foundation for developing and hosting notification applications. Once the technology’s terminology, architecture, and core components are adequately understood, it’s possible to build robust and scalable notification a
Oracle Secure Backup, Part 2: A Sample Implementation
(Jim Czuprynski) With Oracle Secure Backup, Oracle now offers the capability to insure that all Recovery Manager (RMAN) backups are created and maintained in a secure fashion, all without the need for a potentially expensive and cumbersome media management layer (MML). This article – the second in t
Manage a media collection with Atom
(Nicholas Chase) You might know the Atom syndication format as a way to provide blog entry information. But, did you know that in conjunction with the Atom Publishing Protocol, you can use it to manage media files? This article shows you how to create a Web-based media repository with Atom.
FIX: You may receive an assertion or database corruption may occur when you use the bcp utility or the ‘Bulk Insert’ Transact-SQL command to import data in SQL Server 2000
When you use the bcp utility or the Bulk Insert Transact-SQL command to import data in Microsoft SQL Server 2000, you may receive an assertion. Or, database corruption may occur. Additionally, you may receive the following error message: Server: Msg 823, Level 24, State 2, Procedure gfspTMAppendT
Displaying Master-Details Relationships in ASP.NET 2.0
(Wei-Meng Lee) One of the common tasks in manipulating databases is displaying master-details relationships. A very good example is the SQL Server 2000 sample database pubs, which contains several interrelated tables. The authors table is related to the titles table through the titleauthor table (se
Data archiving with Informix Dynamic Server table-level restore
(Volker Fraenkle) If you need to archive your data for a long period of time, you must consider all the possible archiving techniques, and weigh their pros and cons. This article discusses the most common options for archiving your IBM Informix Dynamic Server (IDS) data, and illustrates techniques t