(Willie Favero) What is even more important, it’s a sign that maybe some of us “dinosaurs” can carve out an existence in the business for a few more years by playing with DB2, z/OS, and the myriad of products supported by IBM’s System z servers.
Author: SSWUG Research
Tips for tackling MySQL 5.0
Testing, testing, testing. IT pros have been checking out the new MySQL 5.0 open source database since its recent release its commercial parent, MySQL AB. Some of those IT pros put our resident MySQL expert, Mike Hillyer, to the test, too. In this tip, he answers users’ questions about the ins and o
Transaction failover effectiveness
(Bill Cullen) How effective ia transaction failover? If I have session-specific variables set in my session on node 1, are they maintained and accessible from node 2 if node 1 goes down? (i.e., v$session.client_info, mode, action, temp_tables, etc.) (R)
Mashups: The new breed of Web app
(Duane Merrill) A new breed of Web-based data integration applications is sprouting up all across the Internet. Colloquially termed mashups, their popularity stems from the emphasis on interactive user participation and the monster-of-Frankenstein-like manner in which they aggregate and stitch toget
Add some curves to your SQL Server Model database
(Arthur Fuller) Every installation of SQL Server installs a number of system databases. In keeping with the late Dr. E. F. Codd’s precepts, information about the database must be available using the same commands as you would use to interrogate your own databases. What better way to fulfill this man
Apache Derby resources from the Web services perspective, Part 2: Producing and consuming WS-Notifications with Derby
(David Medinets) Continue on your mission to make your resources service-oriented architecture (SOA)-friendly. Part 1 of this three-part tutorial series showed you how to use WS-Resources to refer to Apache Derby data and structures from within the inherently stateless environment of Web services. E
ASP.NET Tip: Binding to Alternate Data Sources
(Eric Smith) Two of the controls introduced with .NET were the validation control and the validation summary control. I do a lot of server-side validation and I liked the concept of the validation summary, where all the errors on the form are shown at once. JavaScript nag windows annoy me when they
Showplan Trace Events
(Gargi Sur) Besides SSMS, another great tool available to database developers and DBAs to view query plans and troubleshoot query compilation or execution issues is the SQL Server Profiler. In the Profiler, all the showplan events are listed under the Performance Event category. All the SQL Trace ev
.NET Hang Debugging Walkthrough
(Tess Ferrandez) I have talked about a number of different hang/performance issues in my posts. This post is a generic debugging walkthrough for hangs. It applies to all types of .NET processes and to some extent also to non-.net processes even though it has some .net specific items.
Working with Cross Page Posting Using ASP.NET 2.0
(Sanjit Sil) Cross Page Posting is a new feature in ASP.NET 2.0. By using this feature we can submit a form (say crosspage1.aspx) and post the form along with all its control values into another page (say crosspage2.aspx). Using this feature is straightforward and simple. We have to set PostBackU