(Daniel Millwood and Martin Cocks) Service-Oriented Architecture (SOA) provides business agility and resilience through re-use, loose coupling, flexibility, interoperability, integration and governance. These benefits are realized by separating service descriptions from their implementations, and us
Author: SSWUG Research
Finding if a String Contains a SubString
(Ged Mead) Although I’m now quite familiar with using them, I’ve always thought that IndexOf and LastIndexOf to be rather arcane methods of finding out if a particular character or string existed inside another one. You know the kind of thing – you have a text source that you’ve read into memory,
Avoid DLL Hell with Registration-free COM
(John Douglas) Reusable, dynamically linked components are generally a good idea, because they allow you to leverage code and save memory rather than reinvent the wheel. But with thousands of developers leveraging thousands of native DLLs—and no OS-enforced systematic control of versioning or instal
Beginning SQL Server 2005 Reporting Services Part 3: The Chart Control
(Steve Joubert) This is Part 3 of a four-part article series on SQL Server Reporting Services 2005 (SSRS). Part 1 provided a step-by-step guide to basic report creation and Part 2 took a tour of some of the core SSRS features and functions that you’ll need to develop dynamic reports. Here, we turn o
Make DB2 Data Downloads Easy with Start CGI SQL Session (STRCGISQL)
(Steven Goetjen) If you have ever needed to download DB2/400 data to your PC and view the data in MS Excel, as an HTML document, as a simple XML document, or just as a text file, you know how tricky this task can be. As a System i developer, I spend much of my time downloading information from the b
A Quick Way to Visualize SQL Statements in SQL Server 2005 Management Studio
(Gopal Rangaswamy) You can quickly visualize complex queries by simply selecting the complex query text in SQL Server 2005 Management Studio, then right clicking on the selection and picking “Design Query in Editor…”
Assess a SQL Server database developer applicant’s skills with this TSQL test
(Tim Chapman) Last week, I presented a list of the baseline technical questions I ask SQL Server database developers during an interview. If I am satisfied with an applicant’s responses to the verbal portion of the interview, I like to test their TSQL programming ability; there is no better way to s
Observers Mull Impact Of Oracle’s Unbreakable Linux 2.0
(Paula Rooney) Oracle’s Unbreakable Linux 2.0 likely won’t fragment the Linux distribution business out of the gate, but the long-term impact on Red Hat, Novell and the operating system market remains unclear, industry observers say.
Oracle 10g Security, Part 1: Fine-Grained Auditing
(Jim Czuprynski) Oracle 10g extends the original fine-grained auditing (FGA) features that Oracle 9iR2 introduced, including expanded capacity to audit for specific events based on statements issued, the columns that a SQL statement has accessed, and even the subset of data that the statement is aff
What to tune in MySQL Server after installation
(Peter Zaitsev) My favorite question during Interview for people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server straight after installation, assuming it was installed with default settings.