#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

 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:

Hello community!

At the global summit in Phoenix, we (Lite Solutions) will be presenting a tool performing static code analysis on ObjectScript source files. You can see it in action at this URL:

https://demo.cachequality.com

Technically, the tool is a language plugin over SonarQube (http://sonarqube.org) and consists of three main parts:

• parsing the language,
• collecting metrics,
• collecting issues.

The third point is where we kindly request for feedback.

Hi, Community!

This week we have two videos.

Please find the second Developer Community Video of the week on InterSystems Developers YouTube Channel: 

Turning Accountants into Explorers

Hi, Community! 

Please find the Developer Community Video of the week on InterSystems Developers YouTube Channel:

System Sizing for Insanely Large Deployments

Hi Community! 

Check the new video on InterSystems Developers YouTube Channel:

Tier 1 Applications in a Virtual Environment

Hi Community!

Please find the Developer Community Video of the week:

Failover for Cloud and Wide-Area Networks 

Hi, Community!

Check the new video of the week on the InterSystems Developers YouTube Channel: 

LDAP - Beyond the Simple Schema

Hi Community!

Please find the Developer Community video of the week on the InterSystems Developers YouTube Channel: 

Upgrades - Minimizing Business Disruption

Hi Community!

Check the new video on the. InterSystems Developers YouTube Channel:

Many Data Sources - One Application

Hi Community!

Please find the Developer Community video of the week:  

Monitoring : Don't Turn a Drama into a Crisis 

Hi Community!

Check the new video of the week on the InterSystems Developers YouTube Channel:

Adding Alchemy to Unstructured Data

 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é SQL!

I am trying to find the presentation for the User Group Sessions that were given at Global Summit last week. In particular the Healthshare Provider Directory presentation, so I can share the ideas with others at my organization. Does anyone know where I can find those? I am not seeing them under the Global Summit tag.

Thanks

Scott Roth

The Ohio State University Wexner Medical Center

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

Please use the following link to see all Global Summit 2016 sessions and links to additional content, including session materials.

https://community.intersystems.com/global-summit-2016

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!

Hi, Community!

The Second Global Summit Free Registration Contest is running and we have only one week to celebrate new winner!

Here is current leaderboard amongst non-InterSystems DC Members after a half of the race:

(If you want to see contribution from InterSystems employees just set the filter value in the Deepsee dashboard)

John Murray contributed more than others last week.  John is a leader, but he did the result only for one week! 

There is one week more and so everyone can be a winner! 

Do posts, make comments, vote for your favorite writers and come to the InterSystems Global Summit 2016!

Hi Community!

I'm pleased to announce that  the winner of the Global Summit Free Registration Contest is...

Hello Community!

Win the Developer Community MVP (most valuable participant) award in February, and receive a free registration to the Solution Developers Conference at InterSystems Global Summit 2016!

The Solution Developers Conference is like the live version of the Developer Community. It’s where you can connect with your peers, and with InterSystems developers and product managers face-to-face! You’ll hear about our newest technologies, and how they can be used to super-charge your development projects. (Learn more about the Solution Developers Conference and InterSystems Global Summit. ) 

Hi, Community!

We've started InterSystems Global Summit Free Registration Contest this week.

Here is interactive leaderboard available! 

Hi, Community!

There are only six days left to win InterSystems Developer Community MVP prize.

As it was announced in addition to Free Registration on InterSystems Global Summit winner gets 4 nights stay in the Arizona Baltimore, Waldorf Astoria Resort.

We measure contribution to Developer Community on valuable posts and comments and prepared special leaderboard built on InterSystems DeepSee.

By default, it shows all the members. We added the filter to the dashboard to show leaderboard without members who are InterSystems employees.

So here is current leaderboard without InterSystems members: