(Willie Favero) You’ve been hearing about it and reading about it for over a year now. In fact, there’s even a Redbook out that talks about it. It is Optimization Service Center (OSC), the DB2 9 replacement for Visual Explain plus much more… OSC is everything Visual Explain always dreamed it might
Other News
Consolidate Your Binding Code
(Matthew Cochran) I’ve noticed that in data driven UI projects there is often lots of repeated code wherever there is data binding. In this article we’ll look at consolidating all the binding code in a helper class to make projects much easier to maintain by reducing the amount of code we have to di
Reduce Code and Server Roundtrips
(Paul Delcogliano) Table-valued parameters are the long-awaited solution to a specific SQL Server shortcoming that has plagued developers for quite some time: SQL Server doesn’t provide a built-in way to send multiple rows of data as a single parameter to a stored procedure or a parameterized query.
Using dtutil to copy SSIS packages stored in SQL Server
(Yan Pan) In this article, we are going to discuss how to copy SSIS packages stored in SQL Server and their associated package roles using the dtutil command line utility.
SQL Server 2008: New (undocumented) physical row locator function
(Paul S. Randal) One of the drawbacks of not being in the SQL team at Microsoft any longer is that I don’t know about all the undocumented features in the next release – I have to hunt around for them like everyone else 🙁
CXMLFile – A Simple C++ XML Parser
(darkoman) This article is about a simple and fast C++ XML parser class. There is often a need for an effective XML parser that is able to load the XML document, validate it, and browse it. In .NET environment there is a large native support for handling a lot of types of XML documents, but the same
UDFs at the MySQL User’s conference
(Roland Bouman) The MySQL User’s conference will be held in less than a month from now!!!
Handling Early Arriving Facts in SQL Server Integration Services (SSIS) Packages
(Ray Barley) We typically use the Lookup Data Flow Transform to retrieve the surrogate key for a dimension row based on the natural key in a fact table. While this works well, we occasionally have a situation where a fact table row has a natural key that isn’t in our dimension table and we’re looki
Informix DBA: The IDS 11 Sysmaster Database, Part 2
(Lester Knutsen) In my previous column, I discussed five useful new tables in the Informix Dynamic Server (IDS) 11 Sysmaster database. In this column, I’ll continue that list.
Data Breaches and Lawsuits
New Show Posted – Watch Here SQLonCall: Manager or Leader? Where do you find good managers, how do you help them get started, etc. We take a look at the pros and cons of technical vs non-technical managers and a lot more. > Watch The Show Here SQL Connections: Orlando, FL Looking for the best in-person conference for learning about […]