(Willie Favero) I thought I would do a little self promotion today and let anyone who is within driving distance of Costa Mesa, CA that I will be presenting next week at LA Area DB2 User Group meeting on December 6, 2007. I’m hoping that I will get to see a lot of friends from the LA area at the […]
Other News
Creating and Consuming ASP.NET AJAX Page Methods
(Dan Wahlin) Web services provide a great way to exchange data between ASP.NET AJAX pages and a server using lightweight JSON messages (see my previous articles for examples of integrating Web services into ASP.NET AJAX applications). However, creating a separate .ASMX Web service file and adding th
Enterprise Search: Do You Know What’s Out There?
(Michael Pastore) Today’s enterprises create a lot of digital content, and there’s no shortage of places to keep it. The content we create finds its way to company intranets, project workspaces, desktop PCs, and networked storage. It’s structured, it’s unstructured, it’s in e-mails, and it’s on hard
Removing un-wanted text from strings in Oracle
Performing string manipulation is very common regardless of the RDBMS that we use. There are lots of string functions available like substr, instr, lpad, rpad etc. to perform string manipulation. We have also covered some of them in our previous blog posts. Recently at the client site, we came acros
Developing MySQL Applications with Eclipse CDT
(Mark Schoonover) In September, the Developer Zone featured Chapter 6 of Paul DuBois’ MySQL, 3rd edition on Writing C Programs with the MySQL C API. This month, we continue in this series on developing MySQL applications in C with a tutorial from Mark Schoonover about using the Eclipse CDT (C Develo
Dynamic Performance Tables
(Ayyappa Yelburgi) Throughout its operation, Oracle maintains a set of virtual tables that record current database activity. These tables are created by Oracle and are called dynamic performance tables.
The DBA’s Toolbox (Part 1)
(Buck Woody) This guide, and indeed the entire InformIT.com site, is designed to help you succeed as a Database Technology Professional. I’ve got hundreds of articles here on concepts, processes and tools for everything from configuring SQL Server to working with Business Intelligence.
Manage Unknown Members in Analysis Services 2005, Part I
(William Pearson) In this two-part article, we will consider the management of the Unknown Member within Analysis Services. The Unknown Member settings offer us capabilities, similar to those found in once dominant enterprise BI applications such as Cognos PowerPlay / Transformer, for handling scena
Extend SSIS packages with scripting and programming
(Serdar Yegulalp) SQL Server Integration Services (SSIS), Microsoft’s replacement in SQL Server 2005 for Data Transformation Services (DTS), comes loaded with a broad spectrum of components for importing data and turning it into a living thing, not just something to be passively imported. But there
Invoking a WCF Service from a CLR Trigger
(Sam Shiles) This article will walk you through all the steps necessary to setup a sample project demonstrating how to create a CLR Trigger in SQL 2005 that will communicate with a WCF service of your design. This is not an introduction to WCF but more an introduction to using WCF from SQL Server 20