(Tess Fernandez) In my last post I wrote a script to dump out all the ASP.NET requests on the heap. Since one of the most common memory issues I encounter is too much cache or session state I figured that showing you how to retreive session data would be good.
Other News
Data warehouse on System z featured in Virtual Trade Show
(Willie Favero) IBM is kicking off a Virtual Trade Show focused on Warehousing for System z with a “live ” event on September 18 and continuing “on demand” for another 90 days. This is an unusual approach patterned on Second Life that should provide a very interesting and informative experience for
How to resolve SQL object and column names all the way to base tables and columns in Oracle?
(Tanel Poder) If you have been involved in tuning SQL code which you have never seen before, you are probably familiar with the challenges of understanding what the code is trying to do. This can be especially time consuming when the SQL references lots of views, which reference views, which referen
Mini-tip #13 – Converting Between XML and Oracle Objects
(Lewis Cunningham) Sometimes you need to convert between an oracle object and xmltype. Recently, I had the need to do so to write some generic functionality. I need to be able to accept any object type, do some manipulation and enqueue it in a queue. That is a lot easier with XML. The programmers on
.NET Building Blocks: Build a Configurable Database Credential Selector
(Michael Sorens) Visual Studio provides convenient design-time wizards to define static database connection strings that you can store in your settings files. Storing connection strings in configuration files means you can update the connection string without having to recompile or redeploy the host
Introduction to Voice XML Part 5: Voice XML Meets Web 2.0
(Frank Coyle) This is the last article in our series on Voice XML, so let’s wrap things up by expanding your thinking about how you can use voice as an enabler for your applications. When we look at the classic success stories of Voice XML (for example, the American Airlines flight service or 1.800.
XMLTABLE by example, Part 2: Common scenarios for using XMLTABLE with DB2
(Vitor Rodrigues and Matthias Nicola) XMLTABLE is one of the most powerful functions in the SQL/XML standard and is available in IBM DB2 9 for Linux, Unix, and Windows as well as DB2 9 for z/OS. In part 1 of this two-part series on XMLTABLE you learned how to use XMLTABLE to retrieve XML data in rel
Enabling/Disabling query log without server restart in MySQL 5.0
(Peter Zaitsev) General query logging can be very handy in MySQL on profuction server for various debugging needs. Unfortunately you can’t switch it on and off without restarting server until MySQL 5.0.
SQL Server Alerts
(Buck Woody) Whenever you hear about SQL Server Alerts, it’s important to ask “which kind?” You’ll find references out on the web and in books that deal with alerts on two fronts. One is the alerting function you can set within the Windows System Monitor (although it’s also called Performance Monito
What’s new in SQL 2008 Part 2
(Don Schlichting) This article will highlight some of the new features and benefits found in SQL Server 2008. Some of the new features include Development changes, new Business Intelligence features, Integration additions, and new Data Types. Listed below are some of the items covered that were cove