(Howard Baldwin) Howard Baldwin talks with DB2 expert Roger Sanders about how he got involved in DB2 certification, how the test are put together, and how certification can help you grow professionally.
Other News
Limitations of Static Named Sets in SQL Server Analysis Services (SSAS)
(Siddharth Mehta) Creating named sets for frequently used fields in a query, is a very common practice to facilitate easier querying of a cube by users. Developers generally overlook a very important specification when creating named sets, which is to make the named set dynamic.
Compensating for Bad Schema – Triggers
SelecTViews With Stephen Wynkoop Mongo for Windows Phone SDK available, SQL Injection in the Cloud, an Interview with Sherri McDonald about SSRS and training coming soon [Watch the Show] Compensating for Bad Schema – Triggers Triggers are a great asset to any DBA. They allow a database to react to modification of data through Insert, Update or Delete actions. They […]
Update Connection Pools in OBIEE 11g
(chet justice) This is not rocket science, but I’ve had to document this a number of times so that the production/operations/DBA team(s) can go in an update the password. I’m tired of redoing it every time.
DB2 10 for z/OS: Planning for the New DB2 10 Features
(Dave Beulke) The annual North American IDUG Conference was held in Anaheim, California a couple of weeks ago where the latest and greatest information about DB2, and a lot of material on DB2 10, was unveiled.
Problems with MMM for MySQL
(Shlomi Noach) I recently encountered troubling issues with MMM for MySQL deployments, leading me to the decision to cease using it on production.
Hierarchical data using CTE (Common Table Expression) with Depth First Strategy – SQL Server
(Paresh Prajapati) CTE (Common Table Expression) is best feature to get the hierarchy of the data and hierarchical depth. Using CTE we can also get the data easily by level wise with parent and child relation.
Consuming a Web Service created through Sql Server HTTP Endpoints via Web Service task in SSIS
(Niladri_Biswas) Web services allow various applications to communicate with each other. They are based on certain standards
Programmatically Completing A List Of Movie Showtimes In ColdFusion – Simplified
(Ben Nadel) A couple of days ago, I came up with a solution for fleshing out a list of movie showtimes that only provided a partial set of AM/PM indicators. I wasn’t terribly happy with the ColdFusion solution I came up with; however, it was the first solution that I had that actually seemed to work
OWB – Mapping Scripting Accelerator
(dallan) Carrying on from the ODI posts on building lots of simple interfaces rapidly using the SDK, we can see here how to use the OMB scripting commands in OWB to build maps in an identical manner as the post here. The script takes as input the same control file used in the post on the ODI SDK whi