(Nicholas Chase and Jason Bell) In part 4 of this series on analyzing data with XSLT, the MindMap Research Team realized that the cognitive data they’re analyzing might be easier to understand if represented in the 3D space for which it is intended. The team decides to use XSLT to transform it i
Other News
Message Received
(William Zack) The excited chatter about SQL Server 2005’s Common Language Runtime (CLR) integration and other new features has all but eclipsed another very powerful component: SQL Server Service Broker. Service Broker, a database-application framework that lets internal or external database-relate
A Closer Look at ADDM
(Kim Floss) In my last column, I focused on one of Oracle Database 10g’s quick wins for DBAs—using the new SQL Tuning Advisor to quickly tune poorly performing SQL statements—and touched only briefly on the new built-in diagnostic engine, Automatic Database Diagnostic Monitor (ADDM), which helps you
Risky Business, Part 1
(Dorian Pyle) Those who “learn” from the past may be condemned to faulty risk predictions. Risk is everywhere. Business risk takes many forms: risk of business failure, risk of lawsuits, risk of regulatory action, risk of disaster, and so on.
10 Steps to Securing your SQL Server
(Brian Knight) Securing your SQL Server can be an arduous task, but very rewarding. Nothing makes me personally prouder than running a penetration test on a server that we just secured and not seeing any hot spots. This article will focus on the ways to easily secure your SQL Server. Although this t
How is NULL internally stored in DB2?
(Craig Mullins) In DB2, a NULL is stored using a special one-byte null indicator that is “attached” to every nullable column. If the column is set to NULL, then the indicator field is used to record this. Using NULL will never save space in a DB2 database design – in fact, it will always add an extr
DB2 parallel operations and query performance
(Eric Garrigue Vesely) Parallelism can be employed in static and dynamic queries, local and remote data access, queries using single table scans and multi-table joins, access via an index or table scan, or list prefetch, sort, and inserts. Most parallel operations can be used on either partitioned o
Oracle’s BI Metamorphosis
Most folks agree that Oracle Corp. is a force to be reckoned with in the business intelligence (BI) space. After all, Oracle provides a stable of BI tools, and, thanks to its vaunted Oracle 9i database, also has a very strong data warehousing story.
FIX: A memory leak occurs in Analysis Services when a VBA function is used in a calculation
Memory usage increases for a client process that repeatedly queries Microsoft SQL Server 2000 Analysis Services, and the memory is not released after you disconnect from the Analysis server computer. This memory leak occurs when any Microsoft Visual Basic for Applications (VBA) function is used in a
ASP.NET 2.0’s Client Callback Feature
(Minh Nguyen) One of the most overlooked features of ASP.NET 2.0, part of Visual Studio 2005 or "Whidbey", is the Client Callback feature. This feature allows you to programmatically call server-side methods through client-side JavaScript code without the need for posting back the page. This art