(Chris) While working on the next iteration of my SSIS ETL Framework, I’ve discovered that the capabilities of the out-of-the-box Execute Package task are quite lacking. Luckily, with SQL Server 2012, it has never been easier to execute SSIS packages programmatically.
Other News
Async & exceptions in C#
(Peter Torr) This quick post is motivated by a question on StackOverflow. Basically it is a simple console program you can run to see how exceptions are handled in C# async methods. Common wisdom is “don’t have async void methods; always return a Task” but that simple signature change is neither nec
Better Multi-language Programming with Metrics
(Stephen B. Morris) Multi-language coding is now pretty much the norm in modern enterprise development. Nearly gone are the days when a single language was used to solve all development problems. A couple of notable examples of multi-language development are GWT and PHP:
Upgrading to DB2 11 for z/OS – 22 Things to Think About NOW!
(Julian Stuhler) As a follow-up to my “DB2 10 upgrade – 23 Things to think about now” blog I’ve created a version for DB2 11. Once again this is intended for organisations who are planning an upgrade to DB2 11 and would like some guidance on what needs to be done prior to the upgrade.
Integrating IBM MobileFirst with Cast Iron connects mobile apps to the enterprise
(Jayanta Ranjan Das) The IBM MobileFirst Platform Foundation mobile application framework provides integration functionality through its adapter mechanism. MobileFirst adapters are components that are deployed to the server on the MobileFirst platform to access enterprise services.
Oracle: The Nuts And Bolts Of Basic Compression
(David Fitzjarrell) In previous articles compression options have been discussed, and now it’s time to see how Oracle performs basic compression. It isn’t really compression, it’s de-duplication, but it does result in space savings for data that won’t be modified after it’s ‘compressed’.
C# Meets JSON: Lightweight Data-Interchange Format Explained
(Michal Habalcik) Learn more about JSON, a popular lightweight data-interchange format and its usage in the C# programming language.
The Hitchhiker’s Guide to the EXPLAIN PLAN Part 29: Throw Away That EXPLAIN PLAN! (Part III)
(Iggy Fernandez) As I said, the second query is a performance hog beause it deletes all orphans created by the first query.
DB2 Security Policy
(Jack Vamvas) This DB2 Security Policy sample is a basis for applying DB2 security good practise and regular audits. A DB2 environment is characterised by various developers(internal), administrators (internal) and third party access (external). The DB2 security policy should reflect these differe
SQL With a Good Memory
You need to optimize your SQL database performance in SQL Server, and have discovered a large amount of the time to produce results is during disk access. You have plenty of memory on the machine, and want to take advantage of it. What options are available to you? Without doing anything SQL Server will take advantage of available memory to […]