(Christian Antognini) Recently I was involved in a project where I had to trace the database calls of an application based on Oracle Portal 10.1.4. The basic requirements were the following:
Other News
Invoking A Native JavaScript Constructor Using Call() Or Apply()
(Ben Nadel) This morning, I was working on some JavaScript code in which I wanted to create a proxy to a native JavaScript constructor (ex. Array, String).
Writing New Hash Functions for SQL Server
(Thomas Kejser) In this blog, I will explore ideas for extending SQL Server with new, fast hash functions. As will be shown, the high speed, built in functions CHECKSUM and BINARY_CHECKSUM are not always optimal hash functions, when you require the function to spread data evenly over an integer spac
Reading results of SHOW statements, on server side
(Shlomi Noach) SHOW statements are show stoppers on server side. While clients can get a SHOW statement as a result set just as any normal SELECT, things are not as such on server side.
SQL SERVER – 2012 – Summary of All the Analytic Functions – MSDN and SQLAuthority
(Pinal Dave) SQL Server 2012 (RC0 Available here) has introduced new analytic functions. These functions were long awaited and I am glad that they are here.
Install and configure DB2 on UNIX to support change and configuration management
(Vivek K Pandey) You can use several relational database management system (RDBMS) with IBM Rational ClearQuest versions 7.1.2 and higher, including Oracle, Microsoft SQL Server, Microsoft Access, and IBM DB2.
Reader Comments from Editorials Last Week
"Care and Feeding of the SQL Server Transaction Log" Class – Starts Tomorrow Thanks to SQL Server MVP Kalen Delaney, you can learn why the transaction log is considered to be one of the most important components contributing to database perforemance. Click Here to register for the online class. Reader Comments – Version Does Matter Following are a couple of […]
SSWUG TV – Interview with Josef Richberg, SSWUG.ORG Presenter and Red Gate Software’s Exceptional DBA of 2009.
Pro-Center Video Programming for IT Professionals
SharePoint 2010 – How to Get XML Sample Data for Debugging Web Parts that support XSL transform customization (e.g. Search and Content Query Web Parts)
(David Klein) XSLT is the preferred technology for customizing the visual output of SharePoint Web parts (primarily as it is standards-based and non-proprietary). However, there is absolutely no XSLT debugging support provided within the SharePoint environment (this is surprising as it is so pervasi
More on DB2 for z/OS Best Practices
(Susan Visser) The DB2 for z/OS Best Practices developerWorks Webpage contains many recommendations by subject matter experts on how to best use DB2 for z/OS. Two DB2 for z/OS Distinguished Engineers, John Campbell and Haakon Roberts, recently recorded some of their popular presentations outlining