(morgan tocker) I’m about to start working through converting a large MySQL installation to InnoDB. For the particular use case durability is desired, and with MyISAM a loss of power almost certainly guarantees data loss. Durability is not available as an option.
Author: SSWUG Research
Oracle Database 12c: Pattern Matching through MATCH_RECOGNIZE in SQL
(Lucas Jellema) Oracle 8i (8.1.6 if I remember correctly) started with the introduction of a that wonderful new phenomenon in SQL: Analytical Functions. Functions that basically allow the result for one row in the result set to be calculated using the values in other rows.
SSWUGtv News: The Microsoft re-org, super-long-life storage technologies and Amazon AWS price drops – get the details here!
Video Programming for IT Professionals
How do companies prevent remote workers from feeling left out?
I received the following question from a reporter: How do companies prevent remote workers from feeling "left out"? Incentives, such as bringing in lunch to headquarters staff and allowing casual attire in the office after employees meet certain goals, do nothing for those who work from home. What
Gather IO statistics down to the SQL Server database file level
(Greg Robidoux) When managing your SQL Server environment there are many aspects that need to be reviewed to determine where the bottlenecks are occurring to ensure you are getting the best performance possible. SQL Server offers many great tools and functions to determine issues with locking, bloc
HTML5 and SharePoint 2010 – Part 2: An Overview (Continued)
(Eric Overfield) So you want to get started and would like to start using HTML5 tags now? What to do? Don’t fret, it’s easy.
Object Pool Design Pattern
(Richard Carr) The object pool pattern is a creational design pattern that can improve performance when working with classes that are slow to instantiate. Rather than constructing new objects, reusable objects are retrieved from, and released to, a pool as required.
SQL SERVER – Check If Column Exists in SQL Server Table
(Pinal Dave) A very frequent task among SQL developers is to check if any specific column exists in the database table or not. Based on the output developers perform various tasks. Here are couple of simple tricks which you can use to check if column exists in your database table or not.
Big Data: 3 Criteria for Invaluable Analytics
(Dave Beulke) In last week’s blog post on company and government analysis of our digital footprints, I mentioned several aspects of the Big Data digital horizon.
How to find a DB2 Java Driver version?
(Cristian Molaro) The DB2 for z/OS version 10 DDF migration infoapar II14619 should be in the list of your most regarded references in your migration to DB2 10. It provides up to date and critical information that helps to migrate to DB2 10 safelly.