(Brady Gaster) If you’re a web developer, Mads Kristensen and Jorge Gabuardi are about to be your new best friends. In this episode of Web Camps TV, Mads and Jorge introduce you to all the new features available in Visual Studio 11 for web developers
Other News
How do I compare statistics?
(Maria Colgan) This question came up recently when I was helping a customer migrate a large data warehouse to Oracle Database 11g. Prior to the upgrade, they were using an ESTIMATE_PERCENT of 0.000001, the smallest possible sample size allowed, when they gathering statistics on their larger tables.
V$EVENT_HISTOGRAM_METRIC
(Luca Canali) V$EVENT_HISTOGRAM_METRIC does not exist (at least up to 11.2.0.3) however it could be handy! The idea is combine the detailed information from event histograms and the ease of use of metric views.
CURRENT_SCN and CHECKPOINT_CHANGE#
(Hemant K Chitale) The V$DATABASE view provides the current SCN at the database level.
Improve your XSLT 2.0 stylesheets with types and schemas
(Priscilla Walmsley) The type-aware and schema-aware features of XSLT 2.0 can greatly assist you when you debug a stylesheet, and improve stylesheet quality and robustness in handling all input data. Learn how to use type-aware and schema-aware XSLT 2.0 during the debugging and testing process to av
Complete Analytics with IBM DB2 Query Management Facility: Accelerating Well-Informed Decisions Across the Enterprise
(Kristi Ramey, Mike Biere, Peter Richardson, Shawn Sullivan and Jeremy Weatherall) This book walks you through a practical solution to the challenges of business analytics, demonstrating how a business analytics solution hosted in Query Management Facility (QMF) on DB2 and System z can help you deli
SQL Server 2012 Integration Services – Package and Project Parameters
(Marcin Policht) In one of our recent articles published on this forum, we have described how variables can be used to simplify development and maintenance of SQL Server 2012 Integration Services packages and projects. As we have pointed out, variables serve a dual role. Their primary purpose is to
Learn and administer DB2 with Technology Explorer 4.2
Coming on the heels of DB2 Express-C 10.1 is Technology Explorer 4.2.
MySQL: How to Use the GRANT Statement
(wubayou) This tutorial will explain what the MySQL GRANT statement does and how it can be used to grant privileges to certain MySQL user accounts.
DB2 10: What’s new in DB2 10 for Linux, UNIX, and Windows
(Roman B. Melnyk) This article outlines the key features and enhancements in IBM DB2 10 for Linux, UNIX, and Windows. To be released in June, this latest version delivers new functionality that directly addresses your business needs in the areas of cost reduction, application performance, productivi