#Global Summit 2016

Presenter: Anton Umnikov
Task: Identify your slowest SQL queries and tune them for better performance
Approach: Use InterSystems’ query profiling and analysis tools. Discuss how system configuration can affect performance
 

This session will show you how you identify the weakest link in your application SQL and introduce you to the fine art of tuning those queries. To do this we will take a look at InterSystems query profiling and analysis tools, as well as how system configuration can impact SQL performance.

Problem: Obscurity on how our SQL engine works

Content related to this session, including slides, video and additional learning content can be found here.

 For Global Summit 2016, I set out to showcase a Reference Architecture I had been working on for a National Provider Directory solution with State Level Instances and a National Instance all running HealthShare Provider Directory and all running on AWS Infrastructure.

In short, I wanted to highlight:

• The implementation of Amazon Web Services to provision the infrastructure, including the auto-creation of the state level instances through Cloud Formation.
• The use of the HSPD Broadcast functionality to Notify Upstream Systems Changes in Master Provider Data.
• The implementation of a transformation of the standard Broadcast Object to HL7 MFN for interoperability.
• The principals of Master Data Management applied to the Provider Directory.

 It's almost time to get your customers upgraded to new versions - are you worried about showing off your SQL Performance after upgrades?  If you want to upgrade without worrying, then I have just the program for you!!!  Check out this video from Global Summit 2016 featuring yours truly explaining how to upgrade a system without worrying about pesky SQL queries showing on your waistline!  

https://www.youtube.com/watch?v=GfFPYfIoR_g

Unfortunately the video started after the Frozen Musical Sing-a-long, but it's 30 minutes of the most fun you'll have while learning tools and tips for Caché

During the Unconfernce and Sessions during the Global Summit several folks had questions and wanted to see how Ohio State setup our Managed Alerts.  Attached is an export I did along with Documentation I had given to our group here at OSU for Managed Alerts.

Hi!

Please find all the source code Global Summit 2016 Sessions and Experiences in following GitHub repositories:

• Document Data Model experience.
• InterSystems iKnow experience.
• Internet of things experience.
• Global Summit Sessions - folders inside this repository consist sources (if any) for related session.

Codes are in UDL form which is native to Atelier IDE.

Here is small guide how you can check out this project into your Atelier:

Let's see how to load code directly from GitHub URI. 

Open Atelier. Go to File -> Import -> Git -> Clone URI

   2. Specify URL for repository and press Next

   3.

Hello!

Link: https://demo.cachequality.com

In this presentation, developer oriented, we will cover this tool, how it works, how you can use it/administer it, etc. Duration 30 minutes.

The topics will include:

• a short presentation of Caché Quality and SonarQube (which this plugin uses),
• a demonstration of the rules and how to tailor them to your need.

Questions will be more than welcome! Hope to see you there!

And a big thanks to Evgeny Shvarov who made this possible!

Presenter: Kyle Baxter
Task: Upgrade to a new version of Caché without concerns about slowing existing SQL queries
Approach: Use the new Frozen Plans feature in Caché
 

Content related to this session, including slides, video and additional learning content can be found here.

Hi, Community!

The Second InterSystems Global Summit Contest finished yesterday, and we have a new winner!

John Murray has won the prize and showed very impressive contribution activity with the result:

• he did 20 posts with 40 votes on them,
• these posts were commented 96 times by other members
• made 53 comments with 39 positive votes.
• All this happened in 2 weeks.

Congratulations!

John gets Free Registration on InterSystems Global Summit 2016 and the 4-night stay in Arizona Biltmore, Waldorf Astoria Resort!

Thanks everyone who participated in this contest!