Hi Developers,
The new video from Global Summit 2019 is available on InterSystems Developers YouTube:
⏯ Introducing Analytic Workflows
Hey Developers,
Here is a digest of the InterSystems Data Points Podcasts in June 2020:
| New Podcasts in June | |||
| Episode | Podcast Name | Guest(-s) | Listens Count |
| #11 | @Ksenia Samokhvalova | 1 759 | |
| All Podcasts | |||
| Episode | Podcast Name | Guest(-s) | Total Listens |
| #11 | User Experience at InterSystems | @Ksenia Samokhvalova | 1 759 |
| #10 | All About SAM: System Alerting & Monitoring | @Luca Ravazzolo | 2 299 |
| #9 | Healthcare Interoperability: Part 2 | @Russ Leftwich @Jenny Ames |
2 244 |
| #8 | Healthcare Interoperability: Part 1 | @Russ Leftwich | 2 655 |
| #7 | Introducing InterSystems Reports | @Carmen Logue | 2 166 |
| #6 | InterSystems Certification | @James Kantor | 1 823 |
| #5 | Mirroring Databases for High Availability | @Bob Binstock | 2 361 |
| #4 | Optimizing Your SQL Performance | @Benjamin De Boe | 2 644 |
| #3 | IntegratedML in InterSystems IRIS | @Thomas Dyar | 3 733 |
| #2 | What is Kubernetes? | @Luca Ravazzolo | 3 628 |
| #1 | What is InterSystems IRIS? | @Jenny Ames | 3 461 |
Dear Developer,
Here is a digest of the InterSystems Data Points Podcasts in June 2020:
| New Podcasts in June | |||
| Episode | Podcast Name | Guest(-s) | Listens Count |
| #11 | @Ksenia Samokhvalova | 1 759 | |
| All Podcasts | |||
| Episode | Podcast Name | Guest(-s) | Total Listens |
| #11 | User Experience at InterSystems | @Ksenia Samokhvalova | 1 759 |
| #10 | All About SAM: System Alerting & Monitoring | @Luca Ravazzolo | 2 299 |
| #9 | Healthcare Interoperability: Part 2 | @Russ Leftwich @Jenny Ames |
2 244 |
| #8 | Healthcare Interoperability: Part 1 | @Russ Leftwich | 2 655 |
| #7 | Introducing InterSystems Reports | @Carmen Logue | 2 166 |
| #6 | InterSystems Certification | @James Kantor | 1 823 |
| #5 | Mirroring Databases for High Availability | @Bob Binstock | 2 361 |
| #4 | Optimizing Your SQL Performance | @Benjamin De Boe | 2 644 |
| #3 | IntegratedML in InterSystems IRIS | @Thomas Dyar | 3 733 |
| #2 | What is Kubernetes? | @Luca Ravazzolo | 3 628 |
| #1 | What is InterSystems IRIS? | @Jenny Ames | 3 461 |
¡Hola Comunidad!
Os traemos el cuarto episodio de Data Points, el podcast de InterSystems en inglés. En esta ocasión, charlamos con @Benjamin De Boe, que nos explica algunas de las cosas que podéis hacer para optimizar vuestras consultas SQL en InterSystems IRIS.
Todos hemos oído — tanto de nosotros mismos como de otros — la queja "esto va demasiado lento". Creo que Benjamin ha hecho un gran trabajo revisando todas las cosas en las que os podeis fijar en vuestras consultas en IRIS para descubrir lo que se puede mejorar.
Calling @Benjamin De Boe.
Hey Developers,
Here is a digest of the InterSystems Data Points Podcasts in May 2020:
| New Podcasts in May | |||
| Episode | Podcast Name | Guest(-s) | Listens Count |
| #10 | @Luca Ravazzolo | 1 723 | |
| #9 | Healthcare Interoperability: Part 2 | 1 869 | |
| All Podcasts | |||
| Episode | Podcast Name | Guest(-s) | Total Listens |
| #10 | All About SAM: System Alerting & Monitoring | @Luca Ravazzolo | 1 723 |
| #9 | Healthcare Interoperability: Part 2 | @Russ Leftwich @Jenny Ames |
1 869 |
| #8 | Healthcare Interoperability: Part 1 | @Russ Leftwich | 2 248 |
| #7 | Introducing InterSystems Reports | @Carmen Logue | 1 929 |
| #6 | InterSystems Certification | @James Kantor | 1 690 |
| #5 | Mirroring Databases for High Availability | @Bob Binstock | 2 168 |
| #4 | Optimizing Your SQL Performance | @Benjamin De Boe | 2 403 |
| #3 | IntegratedML in InterSystems IRIS | @Thomas Dyar | 3 264 |
| #2 | What is Kubernetes? | @Luca Ravazzolo | 3 373 |
| #1 | What is InterSystems IRIS? | @Jenny Ames | 3 265 |
Dear Developer,
Here is a digest of the InterSystems Data Points Podcasts in May 2020:
| New Podcasts in May | |||
| Episode | Podcast Name | Guest(-s) | Listens Count |
| #10 | @Luca Ravazzolo | 1 723 | |
| #9 | Healthcare Interoperability: Part 2 | 1 869 | |
| All Podcasts | |||
| Episode | Podcast Name | Guest(-s) | Total Listens |
| #10 | All About SAM: System Alerting & Monitoring | @Luca Ravazzolo | 1 723 |
| #9 | Healthcare Interoperability: Part 2 | @Russ Leftwich @Jenny Ames |
1 869 |
| #8 | Healthcare Interoperability: Part 1 | @Russ Leftwich | 2 248 |
| #7 | Introducing InterSystems Reports | @Carmen Logue | 1 929 |
| #6 | InterSystems Certification | @James Kantor | 1 690 |
| #5 | Mirroring Databases for High Availability | @Bob Binstock | 2 168 |
| #4 | Optimizing Your SQL Performance | @Benjamin De Boe | 2 403 |
| #3 | IntegratedML in InterSystems IRIS | @Thomas Dyar | 3 264 |
| #2 | What is Kubernetes? | @Luca Ravazzolo | 3 373 |
| #1 | What is InterSystems IRIS? | @Jenny Ames | 3 265 |
Thanks, @Benjamin De Boe ! It doesn't explain though (at least for me) why hosted variables can't be used for table and column names.
Hey Robert,
Thanks very much for this. It looks like I am closer but getting
[SQLCODE: <-131>:<After Insert trigger failed>]
[%msg: <21003,Cannot INSERT "NIActivityCode" because number is already used.>]
@Benjamin De Boe - thanks for letting me know its not available, I just figured I had a comma or apostrophe in the wrong place so I would have kept going around in circles. It does let me INSERT a single row including the ID so yeah perhaps I will just have to do one at a time if I cannot get Roberts solution going
Hi Community,
We're pleased to invite you to join the upcoming InterSystems IRIS 2020.1 Tech Talk: Data Science, ML & Analytics on April 21st at 10:00 AM EDT!
In this first installment of InterSystems IRIS 2020.1 Tech Talks, we put the spotlight on data science, machine learning (ML), and analytics. InterSystems IntegratedMLTM brings automated machine learning to SQL developers. We'll show you how this technology supports feature engineering and chooses the most appropriate ML model for your data, all from the comfort of a SQL interface. We'll also talk about what's new in our open analytics offerings. Finally, we'll share some big news about InterSystems Reports, our "pixel-perfect" reporting option. See how you can now generate beautiful reports and export to PDF, Excel, or HTML.
In Episode 4 of Data Points, we welcome @Benjamin De Boe to the pod to discuss some of the things you can do to optimize your SQL queries in InterSystems IRIS. We've all heard — either from ourselves or from others — the "this runs too slowly" complaint. I thought Benjamin did a great job walking through many of the things within IRIS you can look at with your queries to see what can be improved.
Hi Developers,
Enjoy watching the new video on InterSystems Developers YouTube:
⏯ SQL Performance: Need for Speed
Thanks Hao Ma, this sounds reasonable. Inviting @Benjamin De Boe , @Raj Singh to comment on this.
Hi Developers,
New video, recorded by @Benjamin De Boe, is available on InterSystems Developers YouTube:
⏯ Code in Any Language with InterSystems IRIS
Hi Developers!
Thank you for participating in the 2019 DC survey!
I'd love to share some results and answer some questions which were raised in the survey.
NPS 54
You give us 54 - which is really cool! Thank you for your trust, we'll try to prove it this year again!
Hi Community,
New video, recorded by @Benjamin De Boe, is available on InterSystems Developers YouTube:
⏯ What Developers Love About InterSystems IRIS
¡Hola Comunidad!
Tenemos un nuevo vídeo, disponible en el canal de YouTube de la Comunidad de Desarrolladores en inglés, grabado por @Benjamin De Boe:
Hi Developers,
New video, recorded by @Benjamin De Boe, is already on InterSystems Developers YouTube:
⏯ Python and InterSystems IRIS
¡Hola Comunidad!
Tenemos un nuevo vídeo, disponible en el canal de YouTube de la Comunidad de Desarrolladores en inglés, grabado por @Benjamin De Boe:
Escalabilidad sencilla con InterSystems IRIS
Hi Community,
The new video from Global Summit 2019 is already on InterSystems Developers YouTube:
⏯ InterSystems IRIS Roadmap: Analytics and AI
Have you made any progress on this?
We just starting playing around with using Web Data Connectors in Tableau to call APIs into Cache.
Best,
Mike
Thanks @Benjamin De Boe
I believe we are on a high enough version which should cater for this.
w $zv Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2017.2.2 (Build 865U) Mon Jun 25 2018 10:50:02 EDT
Wow! Bravo @Conor Walsh!
@Benjamin De Boe, we should definitely come up with some kind of encouragement for this on Global Masters 
Thank you @Benjamin De Boe !
As you described it: I followed the doc not being aware that it does not apply to Array!
Using a calculated property as you describe is excellent!