(K. Scott Allen) Now that we know a bit about how modules work at an API level, we can look at questions that will be asked more than once in the lifetime of a project, like when to create a module, how many modules to create, and how to organize source code files for a module.
Author: SSWUG Research
Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 – Part 3
(Sadequl Hussain) New to MAP 5.0 is another feature called the Software Usage Tracker. This is an audit mechanism that allows you to track the number of users or devices accessing your servers. The information from these audits can help people responsible for managing software licensing to get a bet
SQL Server 2012 AlwaysOn vs. Database Mirroring
(Michael Otey) Probably the most anticipated new feature in the SQL Server 2012 (formerly code-named Denali) release is the new AlwaysOn Availability Groups high-availability feature. Earlier versions of SQL Server provided Windows Failover Clustering (WSFC), designed for server-level protection, an
IDUG 2013 Announcement: DB2 Family Integrates JSON, Graph Document and Key Value Data Stores
(Dave Beulke) The International DB2 User Group (IDUG) North American conference celebrated both DB2 for z/OS’ 30-year anniversary and its own 25-year anniversary last week in Orlando.
ADF client-side architecture – Select All
(Diana Veerman) A little while ago I got a very nice challenge: play around with the ADF client-side framework.
Exporting Schema Statistics
(Brian Diehl) While most of us are familiar with the schema statistics used by the Cost-Based Optimizer (CBO), something not so well know is the ability to export/import these statistics using the DBMS_STATS package.
Automate Data Mapping and Transformation with FlowForce Server
(DaveMcG) Altova FlowForce Server, launched on April 29, 2013, includes numerous enhancements over earlier beta releases and one of the most exciting new features is the implementation of StyleVision Server.
DBCC CleanTable
(Steve Stedman) Many times I have worked on a database that has evolved over 10 or more years of changes from different developers and DBAs. One of the signs I see in databases like this is the waste associated with obsolete columns.
Important !! Clustering Factor Calculation Improvement (Fix You)
(Richard Foote) I’m currently not allowed to discuss Oracle 12c Database goodies but I am allowed to discuss things perhaps initially intended for 12c that are currently available and already back-ported to 11g.
More family matters: Selected common SQL features for developers of portable DB2 applications
(Serge Rielau) Are you writing SQL applications that need to be portable across DB2 platforms? Are you looking for information to help ensure your DB2 applications are portable?