UIIPA – Our 32nd Year!

UIIPA – Our 32nd Year!

Utah IBM i Professionals Association

Posts filed under Database

January Meeting: SQL Tips and Techniques on the IBM i

UPDATE: We want to thank David Larsen for a great presentation. If you were not able to make it to the meeting you can access his reference material here: 1) 33-Page slide deck  2) Document with all reference links

 

sqlSpeaker: David Larsen, Software Engineer at Lagoon Corporation

Topic: SQL Tips and Techniques on the IBM i

Date: Wednesday, January 14th, 2015

Time: 11:00 a.m. – 12:00 noon

Location: Murray City Offices (City Council Chambers), 5025 South State Street, Murray, Utah.

Our user group presentation this month will be by David Larsen. He will be introducing the basics of SQL and its implementation on the IBM i. For some of you, SQL is a very familiar tool you use every day. But for others it is a mystery of what it actually is and why you would want to use it. David will give us an overview of SQL with examples of SQL generation with System Navigator, some embedded SQL examples and many tips on how to get started using SQL. So come and learn how to use this very powerful tool.

New Picture (2)

David Larson is currently a software engineer at Lagoon Corporation. Previously he was the Director of Information Systems at Murray City for 16 years and also served as IT Director and Manager with other companies. He is also a founding member of the user group and has worked on the IBM i for many years.

 

sql-join

October Meeting: SQL for the System Admin

UPDATE: Scott gave a great presentation with tons of useful information. If you missed the presentation or would like a copy of his PowerPoint slides, you can get a copy of them here: SQL for the system administrator – UIIPA- October-2014

New Picture (1)

Our October meeting will be held on Wednesday, October 8th at 11:00 a.m. at the Murray City Offices (City Council Chambers), 5025 South State Street. Everyone is welcome to attend.

NOTE: This will be a 90 minute session so plan accordingly. Also, lunch will be served!

Topic: SQL for the System Admin: IBM i Commands, APIs and the role of DB2 for i and SQL

Speaker: Scott Fortsie, DB2 for i Business Architect (Via Webcast)

Big-SQL_27224636This presentation will focus on the ways in which SQL on IBM i can be used to accomplish a number of tasks that are unrelated to traditional uses of SQL. Although the central theme of these capabilities will be systems administration, benefits can be realized beyond that topic.

You’ll learn about the SQL capabilities that exist for systems management purposes. This presentation will include working SQL examples and some compelling reasons to add SQL to your set of skills.

Note that this session has been updated for IBM i 7.2 and will include a preview of the new services coming to 6.1, 7.1 and 7.2 in 4Q/2014.

Here is the basic outline for this presentation:

  • Traditional IBM i Interfaces
  • SQL is Key for IBM i
  • SQL Catalogs
  • SQL’s TCP/IP Services
  • SQL’s Work Management Detail
  • Security with SQL
  • SQL Storage Devices
  • SQL Journal Details
  • Find SQL Catalogs and Services
  • Get Going with SQL on IBM i

There are a lot of great new SQL-based services for you to use on IBM i 7.1 (and 6.1). By coming to this presentation you will position yourself for success by having the recipe to get you started in learning and implementing SQL.

Scott ForstieScott Forstie is the DB2 for i Business Architect, SQL Development team leader, and IBM i developerWorks content manager. In addition to his development roles, he is a frequently published author on SQL and database topics. (http://iprodeveloper.com/author/scott-forstie) He has worked for IBM nearly 25 years, working primarily on IBM i. Scott can be reached by email at forstie@us.ibm.com or followed on Twitter at @Forstie_IBMi, where he is trying to mix DB2 for i, business, and social.

September Meeting: Business Intelligence and Data Analytics – What’s the Difference?

Our September meeting will be held on Wednesday, September 10th at 11:00 a.m. at the Murray City Offices (City Council Chambers), 5025 South State Street. Everyone is welcome to attend.

NOTE: Lunch will be served!

Topic: Business intelligence and Data Analytics – What’s the Difference?

Speaker: Diana Stater

what-we-do_data_analytics

Diana Stater of New Generation Software, Inc. (NGS), will break through the jargon of business intelligence and data analytics using the “Analytics Triangle” to help you understand the goals of descriptive, predictive, and prescriptive analytics, and the database management tasks and data visualization techniques that support them.  You’ll gain insight into the very different perspectives and roles of programmers, business analysts, executives, and customers/suppliers. The presentation will also include some practical applications of “big data” concepts for small to mid-size, B2B companies.

Diana StaterDiana Stater is a Business Intelligence and Financial Management Software Specialist with New Generation Software, Inc.  New Generation Software, Inc. (NGS) is a leading provider of business intelligence, query/reporting, and analytics solutions designed for IBM i users.

April Meeting: DB2 Database Security and Privacy

UPDATE: Thank you Dean for a great presentation. For those who would like a copy of his presentation you can click on this link: DB2 Database Security and Privacy

Our April meeting will be held on Wednesday, April 9th at 11:00 a.m. at the Murray City Offices (City Council Chambers), 5025 South State Street. Everyone is welcome to attend and enjoy a FREE PIZZA LUNCH at the end of the presentation!

 

Topic: DB2 Database Security and Privacy

Speaker: Dean Compher

 

Identity TheftIf you aren’t scared about the security of your database, you should be!

  • Is your database protected?
  • Do you know who is accessing your data?
  • Who is changing your data?
  • Who is stealing your data?
  • DB2 is not your grandma’s database anymore. Don’t protect it like it is.

For database security answers, “DB2 Dean” Compher is the go-to guy. Come hear Dean teach us the ins and outs of database security at our April meeting.

dataprotectionThe security and privacy of the data in your relational databases is becoming harder to protect all of the time. As you can see from the news reports about the Target credit card breach and the State of Utah Medicaid records breach, perimeter security is not adequate. Multiple layers of security are needed to have a good defense including the ability to obfuscate test databases that you copy from production and being able to monitor who is doing what in your production DB2 databases and send immediate alerts when policies are violated.

This includes obvious threats such as access from unknown IP addresses and observing unusual patterns of access. In this discussion we will review the tools IBM provides to centrally privatize test data and monitor production access for your DB2 on iSeries databases and other databases in your organization as well.

Dean Compher

Dean Compher is an IBM Technical Sales Specialist (a.k.a. Sales Engineer) in Utah who supports IBM’s Big Data and Information management products including databases, data governance, information life cycle management, and data security tools. Dean has many years of IT experience including application development and database administration. While he works more in the realm of Linux, UNIX and windows tools, many of these tools span platforms including the security tools and DB2 Connect. Plus he has many contacts in the iSeries world and can usually find iSeries help when needed. You can access Dean’s web site for futher information here: www.db2Dean.com