(Jeffrey Juday) Often in software development, a new tool introduces old, reliable, battle-tested techniques to an equally reliable and mature platform. SQL Server 2005 Service Broker is such a technology. Service Broker brings the world of asynchronous messaging to the SQL Server database platform.
Author: SSWUG Research
SQL Server 2005 Common Table Expressions
(Nigel Rivett) In my opinion, Common Table Expressions (CTEs) are one of the most exciting features to be introduced with SQL Server 2005. A CTE is a “temporary result set” that exists only within the scope of a single SQL statement. It allows access to functionality within that single SQL statement
Build Brilliant Client/Server Apps with J2ME, PHP, and MySQL
(Alessandro Lacava) Write once, run anywhere. This Java motto seems to hold true even for mobile devices. Indeed, since it was born J2ME has had an ever-increasing impact on mobile development. Some may argue that J2ME is not as portable as other Java technologies, but even so, the result obtained o
Interview Tips for Aspiring Junior DBAs
(Steve Callan) Finally, after countless hours of scouring the Internet, you have come across a job posting for a junior Oracle DBA position, which includes the words you have been waiting for all this time: 0-2 years experience (zero being the operative word or number here). Armed with your fresh, j
Defcon 2006: Oracle not so ‘unbreakable’
(Humphrey Cheung) Your company’s cleaning staff could be illegally moonlighting as your Oracle database administrator. Alexander Kornbrust, founder and CEO of Red Database Security, says hackers could easily exploit vulnerabilities in Oracle database and gain administrator access. Speaking at the De
Partition indexes for improved SQL Server 2005 performance
(Serdar Yegulalp) Index partitioning is one of a number of new features introduced in SQL Server 2005 as a way to distribute the load for a given index across multiple files, which can enhance parallelism or improve index performance in other ways. (R)
XML in Firefox 1.5, Part 3: JavaScript meets XML in Firefox
(Uche Ogbuji) In this third article of the XML in Firefox 1.5 series, you learn to manipulate XML with the JavaScript implementation in Mozilla Firefox. In the first two articles, XML in Firefox 1.5, Part 1: Overview of XML features and XML in Firefox 1.5, Part 2: Basic XML processing, you learned a
Typed XML programmer — What are your pains today?
(Ralf Lämmel) Let me recall my simple definition of typed XML programming that I offered previously: “Typed XML programming is XML programming in mainstream OO languages like C#, Java and VB while leveraging XML schemas as part of the XML programming model”. With an eye on what people are doing with
FIX: The SQL Server process may end unexpectedly when you turn on trace flag -T1204 and a profiler trace is capturing the Lock:DeadLock Chain event in SQL Server 2000 SP4
A computer that is running the Microsoft SQL Server 2000 SP4 may unexpectedly end the SQL Server process and you may receive the following message in the SQL Server log: spid4 SqlSecurityHandler is invoked. Server is terminating.
Beyond the Guidelines: Advanced Accessibility Techniques
(Trenton Moss) When creating accessible web sites, most web developers and web managers follow the W3C’s Web Content Accessibility Guidelines, or WCAG for short. And rightly so — after all, these guidelines are the most comprehensive accessibility resource on the Web today.