By Lisa Vaas – NetIQ Corp. aims to make defragmenting tables in and general management of Microsoft Corp.’s SQL Server database easier with an update to its SQL Management Suite of tools.
Author: SSWUG Research
Oracle patches prompt downtime debate
By Gareth Morgan – Oracle’s decision to release individual patches for “big and nasty” flaws in its database products has stirred controversy over how to minimise disruption while maintaining security.Last week Oracle released six separate patches for vulnerabilities, four of them for ‘criti
Develop a Consistent Naming Convention for Your Database Objects
by Drew Georgopulos – The sheer number of objects in a database makes keeping track of them difficult. As your system grows in complexity, identifying the objects’ dependencies and their purposes can quickly become confusing. Adopt a naming convention that limits the ambiguity and uncertainty surrou
e-business on demand: A developer’s roadmap
By Alfredo Gutierrez – IBM has defined e-business on demand as an enterprise whose business processes — integrated end-to-end across the company and with key partners, suppliers, and customers — can respond with speed to any customer demand, market opportunity, or external threat. Are you wonderin
Modular Speech Application Development Using VoiceXML
By Hitesh Seth – One thing weve learned from Web-based application development is that tools are useful only if they can reuse components and third-party libraries and make it easy to assemble applications. This article reviews how we can build modular speech applications using VoiceXML. The focus w
IBM Aims To Help Partners Become ‘Web Services Gurus’
By Elizabeth Montalbano – At PartnerWorld, IBM plans to unveil a new developer subscription service and a host of programs to help partners deploy Web services, an IBM executive said. The new developer service, called IBM developerWorks Toolbox, is similar to Microsoft Developer Network and M
Monitor SYS and SYSTEM Accounts
by Daniel Stanley – Create a procedure to monitor and log users logging onto the database with the SYS and SYSTEM accounts. Create two new SYS objects:
Return all values in a comma-delimited string
(Preethiviraj Kulasingham) This script will return one big string where the rows are seperated by commas. When getting a set of rows of a field (any string type field), this script could be used to find the field names seperated by commas. It works on SQL server 2000 and 7.0. (R)
Create Reusable Windows Data Entry Controls
by Tim Landgrave – When bad client logic allows invalid data to make it to the database, only to be rejected on an insert or update operation, extra database calls are generated. This isn’t a problem when you’re developing applications for a small number of users in a connected environment. But in a
DTS Programming Techniques Used in Microsoft SQL Server Accelerator for Business Intelligence
Learn about the Data Transformation Services (DTS) programming techniques used in SQL Server Accelerator for Business Intelligence (BI Accelerator). Using these techniques, the Microsoft BI Practices team created an extensible data movement system for analytical applications that developers can exte