(Payton Byrd) I’ve finished my first set of stored proc benchmarks comparing the performance of SQL CLR stored procs written in C# compared to TSQL Stored Procs. Intuitively, TSQL stored procs should be faster than CLR stored procs, but my testing proves otherwise. How did the test end up? Read on t
Author: SSWUG Research
MS SQL Joins – Part 1
(Don Schlichting) This article explores various methods of Joining, where data from multiple tables are returned in one record set by defining logical relationships.
Implementing Property Overloading in PHP 4
(Alejandro Gervasio) The object-oriented paradigm includes the ability to overload classes; not surprisingly, this is possible in PHP. In this first part of a series, you will learn how to implement class overloading in PHP 4, specifically using the “overload()” function, which comes in handy for tr
Hello World, Part 3: WebSphere Integration Developer
(Jane Fung) Welcome to the third tutorial in the “Hello World” series, which provides high-level overviews of various IBM software products. This tutorial will give you a high-level introduction to WebSphere Integration Developer. It includes three practical hands-on exercises in which you’ll create
Thinking XML: Manage XML data sets for security
(Uche Ogbuji) Most developers have to learn a different playbook when they deal with XML and they’re used to database technologies. XML’s transparency requires a lot of care when you expose XML to applications on a network. Carelessness in this regard can lead to security breaches. Learn about the s
Create a graphic representation of any XML document using SVG
(Edmond Woychowsky) Some wise individual or maybe it was some advertising executive, once said that a picture is worth a thousand words. Whatever the source, this phrase has become one of those proverbs that is instantly recognizable as true. Say it and everyone nods in agreement, people are basical
Ten IIS tips to lock down SQL Server
(Kevin Beaver) Interestingly after all the database breaches and hype over locking down SQL Server, I still come across many SQL Server systems riddled with holes. SQL Server 2005 aside – a DBMS that comes pretty secure out of the box for those who’ve dared to deploy it – there are still many SQL Se
Crossing Over/ Breaking the DB2 Platform Barrier
(Jim Wankowski) The popularity of DB2 UDB running on distributed platforms continues to grow. The sudden growth and popularity of DB2 on distributed platforms has resulted in a shortage of experienced non-mainframe DB2 DBAs. IT departments today have to deal with tightening budgets and shrinking st
Making the Most of Oracle SQL Developer Reports
(Lewis R. Cunningham) Oracle SQL Developer (formerly Project Raptor) is Oracle’s new multiplatform graphical user interface (GUI) for developers and DBAs. Like Oracle Database 10g Express Edition (XE) and Oracle JDeveloper, Oracle SQL Developer can be downloaded completely free. Oracle SQL Developer
Oracle Responds To Real-Time Events
(David A. Utter) Popularity of service-oriented architectures (SOA) on standards-based platforms continues to grow. However, they are dependent on the input of the application user. Without that input, the SOA-based application is just the sound of one hand clapping.