Webinar Title: Data Security in the Age of Regulatory Compliance Presenter: Craig S. Mullins
As governmental regulations expand, organizations need to deploy better controls to ensure quality data and properly protected database systems. Sarbanes-Oxley, HIPAA, BASEL II, PCI DSS and more make the news, but what do they mean in terms of your data? And what steps can be taken to ensure compliance?
Anyone who has been paying attention lately knows at least something about the large number of data breaches in the news… and their impact on business. Data breaches and the threat of lost or stolen data will continue to plague organizations until comprehensive plans are enacted to combat them. Many of these breaches have been at the database level, and more will be unless better data protection policies and procedures are enacted on operational databases.
As a result of expanded regulations and the ever-present specter of data breaches, data security has grown in importance. And that places new burdens on DBAs and data management professionals. This presentation will offer an overview of this new landscape focusing particularly on techniques for improving data and database security.
Topics to be discussed include:
An Introduction to Industry and Governmental Regulations
The Pervasiveness of Data Breaches with Techniques for Avoidance and Remediation
Craig gave another great presentation yesterday on how to control your rolling four hour average (R4H). When you’re on variable workload licensing, understanding and controlling the R4H is critical to keeping your monthly bill in check. Craig discusses how you can directly restrict the R4H using soft capping and how techniques like tuning DB2 can reduce your overall CPU consumption – and subsequently your R4H. You can download Craig’s presentation slide deck here.
Register here to watch the replay and to join our mailing list – we’ll keep you in the loop about our upcoming DB2 webinars and our other DB2 resources!
Alternatively, if you don’t want to register, you can just watch the replay below. Enjoy!
If you have any questions or comments, we’re all ears! Send us a message here.
Variable workload licensing can be a powerful mechanism to reduce your mainframe software costs. But are you taking full advantage of the opportunities that exist to lower your monthly software bill? Do you know how the rolling four hour (R4H) average impacts your bill and what you can do to lower that average?
This free webinar, sponsored by SoftBase and delivered by Craig S. Mullins, will provide education on variable workload licensing, the R4H, and soft capping… and then focus on ways to reduce the R4H by tuning DB2 resources.
SoftBase – Craig Mullins and SoftBase Present: Reduce Costs by Tuning…
SoftBase will be giving away a signed copy of Craig Mullins’ DB2 Developer’s Guide, Sixth Edition. Attend for your chance to win!
We’ve seen a huge response to the Sheryl Larsen webinar we sponsored yesterday, titled “Find Lost Money in your SQL: Efficiently Finding and Fixing High Resource Consuming SQL”.
It was an incredibly informative and educational webinar, in which Sheryl showed us dozens of ways to reduce CPU usage. At the end of the webinar, we talked breifly about our new ROI calculator for multi-row FETCH, which estimates the amount of money your shop will save over a 5 year period by implementing multi-row FETCH manually, or by using SoftBase’s Attach Facility MRF feature which automatically retrofits your applications for multi-row FETCH. You can input a few variables, and we’ll generate a custom 5-year savings and ROI forecast, specific to your shop! It’s quick easy, and a little fun! Here are a few neat examples of what we’ll create for you (did I mention it’s FREE?)
Sheryl Larsen and SoftBase have teamed up to bring you a crash course in serious SQL and application performance improvement.
In this presentation, Sheryl will demonstrate how to find, analyze and tune the top 40 expensive queries. Special emphasis will be on finding the cursors that could benefit from multi-row fetch. In addition, Sheryl will discuss designing perfect indexes, MQTs and AQTs, along with manual query rewrite, SQL exploitation and, most importantly, proper use.
Sheryl will also show you a revolutionary new way to implement multi-row FETCH in your existing applications without the time consuming recoding and testing.
There’s a lot of material to cover in this presentation, so be ready to take notes!
If you can’t attend the live presentation, a replay will be available the following day through the registration link above.
Throughout our interactions with customers, we found that most shops aren’t using multi-row FETCH in their existing applications. We found that a little strange, considering multi-row FETCH (MRF) has been shown to improve FETCH statement CPU on the order of 50-70%, and it’s been available since DB2 v8. And based on the level of interest in MRF we’ve seen, it’s safe to say that most DB2 users understand its benefits. So why aren’t more shops using it?
A few weeks ago, my assumption was that a combination of lack of training and resources forced shops to put multi-row FETCH on the back-burner. There’s a lot at stake running a company database, and the highest priority for a database professional has always been to keep it running – so performance tuning, albeit very important, never ranks as high a priority as ‘keeping things from breaking’.
According to a recent poll of over we performed in Craig Mullin’s Multi-Row FETCH Webinar, over 350 database professionals told us why they don’t use MRF in their old applications.
Over half said they either lacked sufficient developer resources or had other priorities. Those folks should talk to us about our Attach Facility’s MRF feature! It puts multi-row FETCH in your old applications quickly, automatically and without development. Sound interesting? Shoot us a quick email here and we’ll send you details.
We had a great turnout at the webinar – 581 database professionals dropped in to listen to Craig talk about implementing muti-row FETCH. He showed some VERY impressive savings. The video below is a replay, the entire video is an hour.
The MRF feature of Attach Facility is a very hot topic right now – Craig talks about it in the webinar towards the end. It will allow you to implement multi-row FETCH without making any coding changes! Wouldn’t it be great to save 74% FETCH statement CPU by flipping a switch! Please contact us if you have any questions! Call us at (800) 669-7076 or go here. We’d love to hear from you!
Multi-row FETCH, available in DB2 since Version 8, has the capability to dramatically improve the performance of DB2-based database applications. This presentation will introduce and define multi-row FETCH, how to use it, and the performance implications of doing so. The presentation will also touch upon multi-row UPDATE. And it will introduce the new SoftBase Attach Facility MRF Feature, which allows you to implement multi-row FETCH without coding changes.
If you do miss the live webinar, check back later soon – we’ll have a video replay available in our blog!
If you have any questions about our MRF product, which has shown CPU savings as high as 74% in FETCH statements during beta testing, click here to contact us now! Or email us at contactus (at) softbase.com or call us at 800-669-7076.
Last September, SoftBase and IDUG sponsored a webinar featuring Craig Mullins discussing upgrading to DB2 version 10 and the impact on developers. You can watch the video below!
Here’s the video replay of Craig’s presentation:
Here’s Craig discussing how to best prepare your applications for the upgrade, and how to test them afterward:
Contact us for more information about our products!
