NEON Enterprise Software-Events & Webinars

Website: HOADB2UG
Location: Radisson Hotel Lenexa
Abstracts:
The Impact of Regulatory Compliance on Database Administration
Governmental regulations are increasing in number, and many of them impact the way organizations must treat their data. Sarbanes-Oxley, HIPAA, BASEL II, and more make the news, but what do they mean to a DBA? This presentation will offer an overview of the regulations and their impact on database administration. Topics to be discussed include:

Presented by Craig Mullins,
Corporate Technologist, NESI

Location: Conseco Conference Center
11825 N. Pennslyvania St.
Carmel, Indiana
8:30 am to 1:00 pm
Abstracts:
The Impact of Regulatory Compliance on Database Administration
Governmental regulations are increasing in number, and many of them impact the way organizations must treat their data. Sarbanes-Oxley, HIPAA, BASEL II, and more make the news, but what do they mean to a DBA? This presentation will offer an overview of the regulations and their impact on database administration. Topics to be discussed include:

Presented by Craig Mullins,
Corporate Technologist, NESI

The DB2 Top Ten Lists
This presentation offers advice, guidelines, and observations on DB2 performance, administration, and development. The information is presented in a humorous fashion in the format of a series of Top Ten lists – kind of like if David Letterman were a DBA. This presentation was voted as one of the Top 10 presentations of IDUG in 2004.

Presented by Craig Mullins,
Corporate Technologist, NESI

Website: NEDB2UG
Location: Sturbridge Host Hotel
Abstracts:
DB2 9 for Developers Only!
This presentation highlights the DB2 9 for z/OS enhancements that directly impact DB2 application developers. Every release of DB2 is chock full of new features and functionality and that can make it hard to focus on those things that are most helpful for programmers. So instead of scanning volumes of manuals, you can watch this presentation which will distill the DB2 9 information down to cover what should be most important to programmer/analysts.

Examples of areas this presentation will cover include:

If you are a programmer wanting to learn more about DB2 9, or a DBA looking for the programmer’s perspective on DB2 9, this presentation should have something to offer you.

Presented by Craig Mullins,
Corporate Technologist, NESI

Website: CCDB2
Location: Institute for Learning
Abstracts: DB2 9 for Developers Only!
This presentation highlights the DB2 9 for z/OS enhancements that directly impact DB2 application developers. Every release of DB2 is chock full of new features and functionality and that can make it hard to focus on those things that are most helpful for programmers. So instead of scanning volumes of manuals, you can watch this presentation distills the DB2 9 information down to cover what should be most important to programmer/analysts.

Examples of areas this presentation will cover include:
• A brief overview of DB2 9 XML capability
• New data types and functions
• New SQL statements like INTERSECT, EXCEPT, MERGE, and TRUNCATE
• The ability to SELECT FROM and UPDATE, DELETE, or MERGE statement
• Improvements to existing SQL
• And more…

If you are a programmer wanting to learn more about DB2 9, or a DBA looking for the programmer’s perspective on DB2 9, this presentation should have something to offer you.
Hosted by Craig S. Mullins,
Corporate Technologist, NEON

Database Auditing: Who did what to which data when and how?
The combination of increasing government regulation and the need for securing corporate data has driven up the need to track who is accessing data in our corporate databases. This presentation discusses these drivers as well as presenting the requirements for auditing access to data stored in database management systems.
The goal of this presentation is to review the regulations impacting the need to audit, and then to discuss in detail the kinds of things that may need to be audited, along with the pros and cons of several ways of accomplishing this.

Presented by Craig S. Mullins,
Corporate Technologist, NEON

Website: IDUG
Location: Hilton Warsaw
Abstracts: Data Breach Protection: From a DB2 Perspective
Anyone who has been paying attention lately knows at least something about the large number of data breaches that have been in the news. Data breaches and the threat of lost or stolen data will continue to plague organizations until comprehensive plans are enacted to combat them. Although many of these breaches have not been at the database level, some have, and more will be unless better data protection policies and procedures are enacted on operational databases.
This presentation will provide an overview of the problem, providing examples of data breaches, their associated cost, and series of best practices for protecting your valuable production data.
Attend Craig's presentation and avoid having your company's name splashed on the front page because you did not adequately protect your databases.
You will -

•	Understand the various laws that have been enacted to combat data breaches and the trends toward increasing legislation
•	Learn how to calculate the cost of a data breach based on industry best practices and research from leading analysts
•	Gain knowledge of several best practices for managing data with the goal of protecting the data from surreptitious or nefarious access (and/or modification)
•	Learn about the available techniques for securing, encrypting, and masking data to minimize exposure of critical data
•	Uncover new data best practices for auditing access to database data and for protecting data stored for long-term retention

Hosted by Craig S. Mullins,
Corporate Technologist, NEON

Website: TCDBUG
Location: IBM, 3rd Floor
Abstracts:
The Impact of Regulatory Compliance on Database Administration
Governmental regulations are increasing in number, and many of them impact the way organizations must treat their data. Sarbanes-Oxley, HIPAA, BASEL II, and more make the news, but what do they mean to a DBA? This presentation will offer an overview of the regulations and their impact on database administration. Topics to be discussed include:

Presented by Craig Mullins,
Corporate Technologist, NESI

Database Auditing: Who did what to which data when and how?
The combination of increasing government regulation and the need for securing corporate data has driven up the need to track who is accessing data in our corporate databases. This presentation discusses these drivers as well as presenting the requirements for auditing access to data stored in database management systems.
The goal of this presentation is to review the regulations impacting the need to audit, and then to discuss in detail the kinds of things that may need to be audited, along with the pros and cons of several ways of accomplishing this.

Presented by Craig S. Mullins,
Corporate Technologist, NEON

Website: WDUG
Location: Northwestern Mutual Life
Abstracts:
Data Breach Protection: From a DB2 Perspective
Anyone who has been paying attention lately knows at least something about the large number of data breaches that have been in the news. Data breaches and the threat of lost or stolen data will continue to plague organizations until comprehensive plans are enacted to combat them. Although many of these breaches have not been at the database level, some have, and more will be unless better data protection policies and procedures are enacted on operational databases.
This presentation will provide an overview of the problem, providing examples of data breaches, their associated cost, and series of best practices for protecting your valuable production data.
Attend Craig's presentation and avoid having your company's name splashed on the front page because you did not adequately protect your databases.
You will -

•	Understand the various laws that have been enacted to combat data breaches and the trends toward increasing legislation
•	Learn how to calculate the cost of a data breach based on industry best practices and research from leading analysts
•	Gain knowledge of several best practices for managing data with the goal of protecting the data from surreptitious or nefarious access (and/or modification)
•	Learn about the available techniques for securing, encrypting, and masking data to minimize exposure of critical data
•	Uncover new data best practices for auditing access to database data and for protecting data stored for long-term retention

Hosted by Craig S. Mullins,
Corporate Technologist, NEON

Database Auditing: Who did what to which data when and how?
The combination of increasing government regulation and the need for securing corporate data has driven up the need to track who is accessing data in our corporate databases. This presentation discusses these drivers as well as presenting the requirements for auditing access to data stored in database management systems.
The goal of this presentation is to review the regulations impacting the need to audit, and then to discuss in detail the kinds of things that may need to be audited, along with the pros and cons of several ways of accomplishing this.

Presented by Craig S. Mullins,
Corporate Technologist, NEON

As the list of government regulations impacting IT grows organizations must adapt to understand and comply with new rules. This increasing compliance pressure is particularly intense on data stored in corporate databases. As such, organization need to be ever more vigilant in the techniques used to protect their data, and monitor access.

Database auditing, sometimes called data access auditing, is one technique growing in popularity as a response to the demands of regulatory compliance. At a high level, database auditing is basically a facility to track the use of database resources and authority. It can be used to help answer questions like “Who accessed or changed data?” and “What was actually changed?” and “When did it change?” This presentation will discuss the issues and requirements driving database auditing and serve as a roadmap of sorts for your data access auditing needs.

Presented by Craig Mullins, Corporate Technologist, NEON

Skyrocketing data volumes in conjunction with increasing governmental regulations conspire to make it difficult to ensure compliance. As required data retention periods increase it becomes imperative that organizations develop a solid practice for archiving and managing business data from their online operational databases.

The presentation offers an overview of the environment driving the need to archive database data, and describes how NEON Enterprise Software’s TITAN Archive delivers a comprehensive database archiving solution.
Presented by Craig Mullins, NEON

Looking for ways to reduce DB2 database maintenance costs? Learn how RealTime DBAExpert helps you accomplish this. With RealTime DBAExpert, you can identify and automatically schedule maintenance on an as-needed basis, eliminating unnecessary and costly utility jobs. Discover how RealTime DBAExpert exploits the use of RealTime Statistics to reduce the need for Runstats. Eliminate the need for pre-maintenance Runstats and Runstats-like scans and substantially reduce the need for post-maintenance Runstats and Runstats-like scans. RealTime DBAExpert enables on-demand scheduling that can reduce or eliminate database maintenance windows. Come learn how RealTime DBAExpert can reduce costs and help you perform DB2 database maintenance more efficiently.
Presented by Joe Brockert, NEON

This presentation offers a roadmap of sorts for DBAs at a higher level than just the bits and bytes. Based on the successful "Chicken Soup for the Soul" book series, this presentation offers database administration tasks, procedures, and operations. Topics covered include:

•		Offers a framework for DB2 database administration
•		Provides control objectives for DBAs to ensure an effective DB2 environment
•		Offers best practices for DBA tasks such as database design, performance management, etc.
•		How to expand your horizons from being viewed only as technicians to being viewed as integral to the business
•		Guidance on how to interact with other IT professionals

Presented by Craig S. Mullins, NEON

Skyrocketing data volumes in conjunction with increasing governmental regulations conspire to make it difficult to ensure compliance. As required data retention periods increase it becomes imperative that organizations develop a solid practice for archiving and managing business data from their online operational databases. But there are many aspects of database archiving for long-term data retention that need to be analyzed and understood before you undertake an archiving project. This presentation offers an overview of the issues driving the need to archive, discusses the technology requirements for database archiving, and describes how TITAN Archive delivers a comprehensive database archiving solution.
Presented by Craig Mullins & Bill Baker, NEON

Are you making plans to migrate to a new version of DB2? Do you know what impact the access changes for dynamic SQL will have on performance? When migrating to a new DB2 version, access path changes for dynamic SQL are unpredictable – as is the impact those changes will have on application performance. Learn how you can use Bind ImpactExpert to eliminate the unwanted surprises in version migration by performing a “precheck” on dynamic SQL access path changes.

Join Craig Mullins, DB2 Expert, and Joe Brockert, Sr. Software Consultant, for a discussion about the issues associated with dynamic SQL during a DB2 migration and a live demo of Bind ImpactExpert. See the solution that provides predictability in access path changes.

Most changes are strictly controlled in the mainframe environment. But that is not the case for DB2 access paths. When we BIND or REBIND a program, DB2 formulates access paths "on the fly" and we do not have any control over what DB2 creates. This lack of control over changes can cause unpredictable performance.

NEON's Bind ImpactExpert product can help you analyze and manage access path changes, thus delivering better control over DB2 applications. Whether upgrading to a new version of DB2, introducing program changes, or simply rebinding for performance, Bind ImpactExpert helps bring a change control discipline to the DB2 access path generation process.

Join Craig Mullins, DB2 Expert, and Joe Brockert, Sr. Software Consultant, for a discussion about managing access paths and a live demo of Bind ImpactExpert. See the solution that provides predictability in access path changes.

A variety of trends and issues are contributing to the growing requirement within enterprises to archive database data for long-term retention and preservation. This presentation will review the trends driving database archiving, including regulatory compliance issues, e-discovery, operational performance improvement, and retiring legacy applications. After examining the driving forces for database archiving, we will walk through the basic steps required to implement best practices based database archiving practice.

If your databases are bursting at the seams, your organization is experiencing compliance-related troubles and/or lawsuits, or you need to figure out how to sunset an old database application or two, this presentation will provide guidance, advice, and a workable template for you to follow.
Presented by Craig Mullins, NEON

Protecting corporate data is a requirement of doing business in today's regulatory and security-minded business environment. Protecting corporate data—an especially sensitive data—is a matter of knowing who is accessing data and what are they doing with it. There have been many solutions for addressing this need on distributed databases, but no reasonable solution for protecting mainframe data until now.

This webinar introduces Guardium for Mainframes, the only database auditing solution available that provides 100% visibility into mainframe database activities without impacting normal business operations. See how the product gives you better insight into database activity without the performance penalty of typical database trace utilities and without relying on inadequate log file data. Guardium for Mainframes provides 100% visibility into all database activities, letting you identify access to sensitive data and potential security breaches, in real-time, and without sacrificing performance or availability.

Presented by Bill Baker, Software Consultant, NEON

Anyone who has been paying attention lately knows at least something about the large number of data breaches that have been in the news. Data breaches and the threat of lost or stolen data will continue to plague organizations until comprehensive plans are enacted to combat them. Although many of these breaches have not been at the database level, some have, and more will be unless better data protection policies and procedures are enacted on operational databases.

This presentation will provide an overview of the problem, providing examples of data breaches, their associated cost, and series of best practices for protecting your valuable production data.

Attend Craig's presentation and avoid having your company's name splashed on the front page because you did not adequately protect your databases.

Understand the various laws that have been enacted to combat data breaches and the trends toward increasing legislation
Learn how to calculate the cost of a data breach based on industry best practices and research from leading analysts
Gain knowledge of several best practices for managing data with the goal of protecting the data from surreptitious or nefarious access (and/or modification)
Learn about the available techniques for securing, encrypting, and masking data to minimize exposure of critical data
Uncover new data best practices for auditing access to database data and for protecting data stored for long-term retention

Presented by Craig Mullins, Corporate Technologist, NEON