AIOUG Webinar: When 7-bit ASCII ain’t enough – about NLS, Collation, Charsets, Unicode and such with Kim Berg Hansen

Greetings from All India Oracle Users Group (AIOUG)! We hope everyone at your end including you are safe!

The Covid-19 makes the user group events that are physical gatherings impossible. Over the past weeks, we have been looking at our calendar of events and re-imagining them as virtual web-based events. We have decided to host virtual based sessions every Wednesday. Please mark your calendars and find more details about this week’s webinar.

Session Title: When 7-bit ASCII ain’t enough – about NLS, Collation, Charsets, Unicode and such

Session Abstract:  A-Z in upper and lower case isn’t enough in a global world, you need to support all sorts of textual data. Oracle database can handle most of it, but there are pitfalls to be aware of – even using Unicode that should handle everything. Learn about NLS and collation and converting charactersets.

Session Description: How life as a DB developer would be much easier if the entire world was happy with just A-Z in upper and lower case. But the globalized world is a very diverse place with myriads of special characters and modifiers, different alphabets, writing directions, sorting and comparison rules, and many ways to encode these characters. So, your database and application absolutely need to know about these things and handle them correctly, or you’ll find your app displaying garbage or worse, storing garbage.

Oracle database offers many NLS (National Language Support) settings to handle such globalization on database, instance and session/client level. NLS functions are available in the SQL language to handle specific cases with code when the session settings aren’t granular enough. In Oracle 12.2 was added Collation support, where you specify right down on column level how this column should sort and compare values. You have choices whether to store everything with database characterset UTF8 or stick to a single-byte characterset – in both cases be aware of how conversion takes place if the client is not using the database characterset.

This presentation discusses many of the issues involved and ways to use NLS and Collation to avoid them. Pitfalls will be shown, where you can get mangled (or even invalid) data stored if you are not careful.

Speaker Bio:

Kim Berg Hansen is a database developer from Middelfart in Denmark. Originally wanting to work with electronics, he almost coincidentally tried computer programming and discovered where his talent lay, as the programs he did worked well be unlike the electronics projects he soldered that often failed. After that experience he progressed from Commodore Basic on VIC-20 over Modula-2 and C at Odense University to Oracle SQL and PL/SQL, which last two languages he now has worked with extensively since the year 2000. His professional passion is to work with data inside the database utilizing the SQL language to the fullest to achieve the best application experience for the users.

Kim shares his experience and knowledge by writing the “Practical Oracle SQL” book, blogging, presenting at various Oracle User Group conferences, and being the SQL quizmaster at the Oracle Dev Gym. His motivation is when peers go “now I understand” after his explanations, or when end users “can’t live without” his application coding. He is certified Oracle OCE in SQL as well as awarded Oracle ACE Director. Outside the coding world, Kim is married, loves to cook, and is a card-carrying member of the Danish Beer Enthusiasts association.

Date: 29th July 2020
Time: 2:00 – 3:30 pm IST

Registration Link:
https://bit.ly/3fNAp93

If you are AIOUG Member – Click Register Button

If you are Non AIOUG Member – Please sign up for “Starter (FREE) Membership” from https://www.aioug.org/join and Register

Upcoming Webinars: Please check the following page for our upcoming webinars and register to secure your seat.

https://bit.ly/2WSWV9p

We are looking at how we can deliver quality content and benefit to our members. We have some ideas including webinars of course but do you have any ideas of what you would like to see the AIOUG doing for you? If so, please get in touch – webinar@aioug.org

Regards,
Team AIOUG
webinar@aioug.org

AIOUG Webinar: Oracle RAC performance optimizations on Exadata with Anil Nair

Session Title:
Oracle RAC performance optimizations on Exadata

Session Abstract:
This presentation focuses on Oracle RAC optimizations on Exadata. The session will cover the Cache Fusion features which adapt to available hardware for optimal performance. This will include a broad range of topics like Multi-Tenant, Clusterware, ASM and In-Memory specific optimizations in Exadata implementation. It is quite remarkable how components of Oracle RAC work differently on engineered systems. There is an incredible amount of software engineering that goes in to ensure that the system scales efficiently.

Anil Nair
Sr Principal Product Manager (RAC), Oracle USA

Anil Nair is the Product Manager for Oracle Real Application Clusters (RAC). Oracle RAC is a cluster database with a shared cache architecture that overcomes the limitations of traditional shared-nothing and shared-disk approaches to provide highly scalable and available database solutions for all your business applications.

Anil has been involved with Oracle RAC since inception. He has helped various customers with Oracle solutions specifically around Performance, availability, Scalability aspects for about 20 years

CFP-CLOSE: Oracle Groundbreakers Yatra 2020 (AIOUG)

Hi all,

Just sharing the word about this tour I always wanted to attend, maybe now it’s online I can be there!

It is going to happen from 1st -15th July 2020.

From the organization committee:

The health of All India Oracle Users Community (AIOUG) is our primary concern. Considering global precautions for the COVID-19 Coronavirus, and building upon recommendations from the World Health Organization, AIOUG is taking a new approach to its Oracle Groundbreaker Yatra event. The event is a highly concentrated 15-day collaboration and transformation while providing the deep technical education needed for our Indian Oracle Community.

We will accept papers on any topic related to Oracle Cloud, Oracle Database, Oracle Applications, Middleware, Engineered Systems, BigData, Virtualization and Servers, and Storage. Please follow the following guidelines to submit your papers.

Please note that presentations should not have sales or marketing content. This is a user’s conference and should have technical value to the attendees. Presentations containing any kind of sales or marketing information will be disqualified.

Important Dates for Speakers:

• Deadline to submit abstracts: 7th June 2020

• Approximate date you will be notified: 14th June 2020

How to submit a paper:

A simple process to fill following Google Form:  https://forms.gle/PJSzBCFXa7dZ1xEA6

Selection Process:

Once the CFP closes, the presentations will be selected by a panel of judges who have attended previous AIOUG events.

Contact:

For questions regarding the Call for Proposals, send an e-mail to ogyatra@aioug.org

I did mine submissions already!

AIOUG Live with Jim Czuprynski: What’s Your Super-Power? Mine is Machine Learning with Oracle Autonomous DB

I just noticed this is happening tomorrow! Found by accident on the internet, but saw in person a similar session from Jim in some past events (when we attended in person) . You not retreat to attend this one!

Date : 3-JUN-2020
Time :06:00 PM IST

Session Abstract:
Artificial Intelligence (AI) and Machine Learning (ML) are a lot like preserving the Earth’s environment: Almost everyone is talking about what should be done to save it, but very few people have committed to actually doing something about it.

This session demonstrates a few real-life opportunities to discover unseen patterns and relationships within sample financial and election data by leveraging the AI and ML capabilities already built into Oracle Autonomous Database.

Session Outline:
Through presentations and online demonstrations, this session illustrates how to:
– Understand the basics of what AI and ML promise
– Use the built-in ML features of Autonomous Database to analyze data patterns in several dimensions
– Build simple visual models that uncover patterns hidden within data

Speaker Bio:
Jim Czuprynski has nearly four decades of professional experience in his career in information technology, serving diverse roles at several Fortune 1000 companies before becoming an Oracle DBA in 2001. He has been an Oracle ACE Director in 2014 and is a sought-after public speaker on Oracle Database technology features, presenting often at Oracle OpenWorld, IOUG COLLABORATE, ODTUG Kaleidoscope, Oracle CODE events, Oracle Development Community tours, and Oracle User Group conferences around the world.

Jim has authored over 100 articles focused on facets of Oracle Database administration to his credit since 2003 at databasejournal.com and IOUG SELECT. He has also co-authored four books on Oracle database technology. Jim’s blog, Generally … It Depends (http://jimczuprynski.wordpress.com), contains his regular observations on all things Oracle and the state of the IT industry. He is currently a Senior Enterprise Data Architect for Viscosity North America.

Registration Link-https://bit.ly/2Akj2gc

Thanks AIOUG for making it happen!

AIOUG Live with Jim Czuprynski: What’s Your Super-Power? Mine is Machine Learning with Oracle Autonomous DB (June 3rd 6PM IST)

Hey!

I just noticed this is happening tomorrow! Found by accident on the internet, but saw in person a similar session from Jim in some past events (when we attended in person) . You not retreat to attend this one!

Date : 3-JUN-2020
Time :06:00 PM IST

Session Abstract:
Artificial Intelligence (AI) and Machine Learning (ML) are a lot like preserving the Earth’s environment: Almost everyone is talking about what should be done to save it, but very few people have committed to actually doing something about it.

This session demonstrates a few real-life opportunities to discover unseen patterns and relationships within sample financial and election data by leveraging the AI and ML capabilities already built into Oracle Autonomous Database.

Session Outline:
Through presentations and online demonstrations, this session illustrates how to:
– Understand the basics of what AI and ML promise
– Use the built-in ML features of Autonomous Database to analyze data patterns in several dimensions
– Build simple visual models that uncover patterns hidden within data

Speaker Bio:
Jim Czuprynski has nearly four decades of professional experience in his career in information technology, serving diverse roles at several Fortune 1000 companies before becoming an Oracle DBA in 2001. He has been an Oracle ACE Director in 2014 and is a sought-after public speaker on Oracle Database technology features, presenting often at Oracle OpenWorld, IOUG COLLABORATE, ODTUG Kaleidoscope, Oracle CODE events, Oracle Development Community tours, and Oracle User Group conferences around the world.

Jim has authored over 100 articles focused on facets of Oracle Database administration to his credit since 2003 at databasejournal.com and IOUG SELECT. He has also co-authored four books on Oracle database technology. Jim’s blog, Generally … It Depends (http://jimczuprynski.wordpress.com), contains his regular observations on all things Oracle and the state of the IT industry. He is currently a Senior Enterprise Data Architect for Viscosity North America.

Registration Link-https://bit.ly/2Akj2gc

Thanks AIOUG for making it happen!

Oracle Groundbreakers Yatra 2020 (AIOUG) – Online – CFP is Open!

Hi all,

Just sharing the word about this tour I always wanted to attend, maybe now it’s online I can be there!

It is going to happen from 1st -15th July 2020.

From the organization committee:

The health of All India Oracle Users Community (AIOUG) is our primary concern. Considering global precautions for the COVID-19 Coronavirus, and building upon recommendations from the World Health Organization, AIOUG is taking a new approach to its Oracle Groundbreaker Yatra event. The event is a highly concentrated 15-day collaboration and transformation while providing the deep technical education needed for our Indian Oracle Community.

We will accept papers on any topic related to Oracle Cloud, Oracle Database, Oracle Applications, Middleware, Engineered Systems, BigData, Virtualization and Servers, and Storage. Please follow the following guidelines to submit your papers.

Please note that presentations should not have sales or marketing content. This is a user’s conference and should have technical value to the attendees. Presentations containing any kind of sales or marketing information will be disqualified.

Important Dates for Speakers:

• Deadline to submit abstracts: 7th June 2020

• Approximate date you will be notified: 14th June 2020

How to submit a paper:

A simple process to fill following Google Formhttps://forms.gle/PJSzBCFXa7dZ1xEA6

Selection Process:

Once the CFP closes, the presentations will be selected by a panel of judges who have attended previous AIOUG events.

Contact:

For questions regarding the Call for Proposals, send an e-mail to ogyatra@aioug.org

I did mine submissions already!

NewScreenshot 2020-05-27 às 21.05.56