(Ajay Sood) Large numbers of extract, transform, and load (ETL) jobs need to be validated during the following two common job lifecycle scenarios: Migrating ETL projects/jobs from older version to a new version, or moving jobs from development to QA to production.
Author: SSWUG Research
Create Custom jQuery Function (jQuery Plugins)
(Sachin Kalia) In this article I am sharing my thoughts of a custom jQuery function and how to create it when its required to customize the code according requirements.
Do you know BLU?
(Susan Visser) I’d like to introduce you to BLU…. or to be more exact, DB2 with BLU Accelerator. This is an incredible piece of technology that was created by technical geniuses from IBM.
Getting Started Testing Databases with tSQLt
(Robert Sheldon) There are several frameworks for assisting with the testing of SQL Server databases, but tSQLt is popular because it is written in TSQL and is simple for a database developer to set up and use. It doesn’t get in the way.
Deciding to reorg DB2 tables with overflow value
(Jack Vamvas) As table data changes , logically sequential data may be on non-sequential physical pages. The database needs to perform added reads . Table Fragmentation leads to a slower response time.
SQL Injection Risks
(Michael McLaughlin) While I tried to deflect how you perform SQL Injection attacks against a MySQL procedure, my students requested that I post examples of what to do to avoid SQL injection, and what not to do to invite attacks.
Enable Tracing Logs with Coded UI Test (CUIT) in Visual Studio 2012
(Gouri Sohoni) In this article, we will find out how to enable tracing logs when executing with Coded UI Test in Visual Studio 2012. We can use these logs for debugging which will make it easier to find out issues when a Coded UI Test fails.
Geek City: More statistics info available!
(Kalen Delaney) I just started using a new DMV (one that’s actually an ‘F’ not a ‘V’, as in Function) that gives us more info about distribution statistics. It returns info about the last statistics update date (which is also available with a function STATS_DATE()). It also provides the number of ro
Storage Modes in SSAS (MOLAP, ROLAP and HOLAP)
(Arshad Ali) There are three standard storage modes (MOLAP, ROLAP and HOLAP) in OLAP applications which affect the performance of OLAP queries and cube processing, storage requirements and also determine storage locations.
Starting SOA/BPM Suite with wlst via nodemanager
(Martien van den Akker) Today I installed the brand new SOA and BPM Suite 11g PS6. The last few months for me were dedicated in deepdiving WebLogic to deliver a Tuning and Troubleshooting course for two customers.