(TheloniusFunk) In this programming tutorial you will learn how to work with the PHP array_combine function, which allows you to combine arrays into a single array.
Other News
File Exists Check in SSIS
(VidhyaSagar) Couple of weeks back I was working with a SSIS package development. My requirement is to check whether the file exists before I start importing the data. If it doesn’t exist then the package should update the db table. When I heard this requirement I thought I can make use of the “File
Materialized Views & Partition Change Tracking
(Uwe Hesse) During the 11g Data Warehouse Administration course that I delivered this week in Munich, I have shown this demonstration about Partition Change Tracking (PCT) that I’d like to share with the Oracle Community. You may have a look here for an Introduction into Materialized Views if that t
When is v$sesstat really updated?
(Craig Shallahamer) Statistics are meaningful when we understand them and potentially dangerous when we don’t. In the Oracle performance analysis arena, the instance statistics views (v$[ses,sys]stat) are used quite a bit. While there are many sources describing what a statistic means, what remains
That Time I Accidentally Deleted All the Oracle Databases
(Jeff Smith) My data hero, Karen Lopez aka @datachick, is hosting a blog meme for this friday called “#FailFriday: I was young and didn’t know any better.”
Using the DebuggerBrowsable Attribute
(Richard Carr) Visual Studio’s debugging windows and tools allow you to examine in-scope objects and the values contained within their properties, indexers and fields. When this is undesirable, a class may change the way in which its debugging information is provided.
Execute TSQL statement with ExecuteStoreQuery in entity framework 4.0
(Jalpesh) I was playing with entity framework in recent days and I was searching something that how we can execute TSQL statement in entity framework. And I have found one great way to do that with entity framework ‘ExecuteStoreQuery’ method. It’s executes a TSQL statement against data source given
PODCAST: Time Travel Query for DB2 10
How does data change over time? Why is it important to manage and track those temporal changes? In this IBM data management podcast, we talk with Matthias Nicola, senior technical staff member on the IBM DB2 performance team, about temporal data management features within DB2 10 that give you the po
IBM Data Replication Updated for DB2 10 on UNIX and Windows
(david t) Along with today’s announcement about the new version of DB2 and InfoSphere Warehouse, IBM also announced an updated release of InfoSphere Data Replication to support the new DB2. All of IBM’s data replication technologies – CDC, SQL Replication, and Q Replication – have been updated to s
MySQL queries with REGEXP
(Thomas) Official MySQL documentation provides information that using regular expressions is “powerful way of specifying a pattern for a complex search”. Is it really such a powerful way of filtering and should be used, or is it a solution that should be avoided? As it usually happens in real life,