This exciting ninety minute webinar will examine the top 10 most compelling reasons that will convince managers, database administrators (DBAs), and application developers to install and deploy DB2 9 for z/OS as quickly as they possibly can! (R)
Author: SSWUG Research
Changing Hostnames in Oracle RAC
(Alex Gorbachev) Sometime there is a desperate need to change hostnames for one or all nodes of an Oracle RAC cluster. However, this operation is not officially supported.
Data Warehousing: Ensuring Data Integrity with End-to-End and Statistical Process Controls
(Cindy Maurer) Data warehousing holds much promise to provide competitive advantage through derived business intelligence, but the promise cannot be realized unless you ensure the integrity of your data. To ensure data integrity you must have end-to-end controls and the ability to identify data anom
Performance analysis tools for SQL Server
(Serdar Yegulalp) It’s something of a truism that a complex SQL Server setup needs to be tuned to run properly. The good news is that most of the SQL Server tools you can pick up to accomplish that job are either already available in your backyard, or can be downloaded for nothing. What’s required m
XML and the DataSet
With ADO.NET you can fill a DataSet from an XML stream or document. You can use the XML stream or document to supply to the DataSet either data, schema information, or both. The information supplied from the XML stream or document can be combined with existing data or schema information already pres
Debunking GROUP BY Myths
(Roland Bouman) There is a popular myth about the SQL GROUP BY clause. The myth holds that ‘standard SQL’ requires columns referenced in the SELECT list of a query to also appear in the GROUP BY clause, unless these columns appear exclusively in an aggregated expression. MySQL is often accused of vi
Text Metrics in the .Net Framework, Part I
(Peter Aitken) I think that the tools that the .Net Framework provides for text output are truly impressive. Even so, the precise positioning of text remains problematic. This is the first of two articles that explore tools and techniques for positioning text output. Let’s start with some background
Partner TechTip: According to Recent IBM Announcements, Query/400 Is Outdated
(Tom Huntington) Do you provide your users with a modern “look and feel” for their System i data? Are your users telling you that green-screen reports are unacceptable? Is your backlog of text-based reports overwhelming? Is your data warehouse project over budget, past due, and unsatisfying to users
Oracle Session Tracing Part IV
(James F. Koopmann) In Part III we left off displaying the enabled traces and statistic gatherings we enabled through the DBMS_MONITOR package.
Analysis Services Processing Best Practices
(Denny Lee, Nicholas Dristas and Carl Rabeler) The recommendations in this white paper provide best practices for processing in Microsoft SQL Server 2005 Analysis Services. These performance optimizations are based on real-world implementations with some of our top customers and partners who use SQL