​📄 Don't miss this article if you wish to improve your Dynamic #SQL skills! From it, you will learn the best practices of how it's best done in #InterSystemsIRIS and how to avoid SQL injection vulnerabilities and spaghetti code 👇

https://community.intersystems.com/post/dynamic-sql-best-practices-or-how-avoid-both-sql-injection-vulnerabilities-and-spaghetti-code

Enjoy!

​🧑‍💻 Want to quicken the execution of your queries? Follow this step-by-step explanation of how to add functional indexes to your #SQL queries on many-to-many relationship tables in #InterSystemsIRIS 👇

https://community.intersystems.com/post/functional-indices-lightning-fast-queries-many-many-relationship-tables

Have fun!

​Introducing InterSystems IRIS Cloud SQL and InterSystems IRIS Cloud IntegratedML, two new fully managed cloud services for smart data applications.

As part of the InterSystems Cloud portfolio, these cloud-native smart data services provide enterprise-class database and machine learning capabilities as self-service, fully managed offerings in the Amazon Web Services (AWS) cloud. With Cloud SQL and Cloud IntegratedML, SQL developers can now access a next-generation relational database-as-a-service (DBaaS) with embedded machine learning that is fast, easy to provision, and use.

Learn more about the future of SQL development with #InterSystemsIRIS Cloud #SQL and Cloud IntegratedML: bit.ly/3Oa9doc
Try these cloud offerings and automatically receive a $300 credit for running deployments of any size as a new subscriber: bit.ly/3SoXyEC

#SQLDevelopment #CloudNative #MachineLearning #ML

​🎇 We’re excited to introduce two new fully managed #cloud services: #InterSystemsIRIS Cloud SQL and InterSystems IRIS Cloud #IntegratedML. Cloud SQL empowers #application developers to build real-time applications with ease – with embedded AutoML capabilities, while Cloud IntegratedML allows #SQL developers to effortlessly develop and execute #MachineLearning models using SQL-like commands in a fully managed, elastic cloud-native environment.

🔗 AWS: bit.ly/3SoXyEC
🔗 Learn more: bit.ly/3Oa9doc

Revolutionize your data management experience, enjoy seamless integration, and harness the power of a dynamic cloud environment!

​🚀 Exciting news! We are introducing two cutting-edge, fully managed #cloud services: #InterSystemsIRIS Cloud SQL and InterSystems IRIS Cloud #IntegratedML. Cloud SQL facilitates the creation of real-time applications, while Cloud IntegratedML, equipped with embedded AutoML capabilities, empowers #SQL developers to effortlessly develop and run #machinelearning models using SQL-like commands in a fully managed, scalable, and cloud-native environment.

🔗 AWS: bit.ly/3SoXyEC
🔗 Learn more: bit.ly/3Oa9doc

PS. New subscribers automatically receive a $300 credit for running deployments of any size 💸

​🚀 Exciting news! We are introducing two cutting-edge, fully managed #cloud services: #InterSystemsIRIS Cloud SQL and InterSystems IRIS Cloud #IntegratedML. Cloud SQL facilitates the creation of real-time applications, while Cloud IntegratedML, equipped with embedded AutoML capabilities, empowers #SQL developers to effortlessly develop and run #machinelearning models using SQL-like commands in a fully managed, scalable, and cloud-native environment.

🔗 AWS: bit.ly/3SoXyEC
🔗 Learn more: bit.ly/3Oa9doc

PS. New subscribers automatically receive a $300 credit for running deployments of any size 💸

​🎥 Watch this #video to learn how the InterSystems AppServices team migrated a #datalake off of Microsoft #SQL Server to #InterSystemsIRIS, leading to such benefits as lower #maintenance, better #performance, and a better overall development fit 👇

https://community.intersystems.com/post/video-migrating-our-data-lake-ms-sql-server-intersystems-iris

Learn from the best! #GlobalSummit23

​📃 Check out this article to demystify the intricacies of setting up #TLS/SSL in #InterSystemsIRIS SuperServer by following the step-by-step guide on how to configure and test the connection using #SQL Clients apps using ODBC and JDBC 👇

https://community.intersystems.com/post/configuring-tls-ssl-iris-superserver-work-odbcjdbc-clients

Let's make secure connections the foundation of our digital world!

​☕️ Watch this #video to learn how to use #Java to run concurrent workloads of high-speed ingestion and analytics using #SQL and how to enrich messages via high-speed Message Broker in #InterSystemsIRIS👇

https://community.intersystems.com/post/video-high-speed-ingestion-using-intersystems-iris-persister-java

Unlock your Java potential! #GlobalSummit23

​🤖 Watch this #video to learn how #VectorSearch powers Retrieval-Augmented Generation (RAG) for chatbots using #SQL access to #InterSystemsIRIS data 👇

https://community.intersystems.com/post/video-chatbots-are-all-rage-generative-ai-intersystems-iris

Get the most out of #AI! #GlobalSummit24

​📊 Watch this #video to learn some strategies for enhancing security in #InterSystemsIRIS, including protection against #SQL injections, auditing, privileges, and federated authentication 👇

https://community.intersystems.com/post/video-navigating-sql-privileges-and-security-intersystems-iris

Enjoy!

​🐍 Interested in using #Python to work with #SQL using the #ORM for the objects in #InterSystemsIRIS? Follow this article to learn how it can be done with SQL Alchemy 👇

https://community.intersystems.com/post/sqlalchemy-python-sql-toolkit-and-object-relational-mapper

Have fun!

​🔗 Want to connect your #InterSystemsIRIS Cloud #SQL to #DBeaver with SSL/TLS for a secure setup? Read this article to get the key steps:

1️⃣ Setting up Cloud SQL with SSL/TLS
2️⃣ Configuring DBeaver for secure connections
3️⃣ Importing certificates
4️⃣ Troubleshooting tips

https://community.intersystems.com/post/connecting-cloud-sql-dbeaver-using-ssltls

Enjoy!

​📷 Here comes the last phase of training a #GenAI model - prompt before the prompt! Watch this #video to discover how adding instructions, context, or relevant data to a user's query before it reaches the #AI can significantly improve the accuracy and relevance of responses.

We’ll cover real-world examples, like improving healthcare chatbots and converting natural language into #SQL queries, and explain how this method can make AI systems smarter and more reliable.

https://community.intersystems.com/post/video-prompt-prompt-third-step-genai-model-training

Enjoy!

📹 Watch this #video to learn how the Israeli Ministry of Health overcame challenges deploying #InterSystemsIRIS FHIR Server and FHIR #SQL Builder for major national initiatives 👇

https://community.intersystems.com/post/video-fhir-repository-and-fhir-sql-builder

See how #FHIR solutions can drive innovation at scale!

​📺 Watch this #video to learn how to deploy #InterSystemsIRIS Cloud Document and easily import data, run #SQL queries, and integrate with your applications 👇

https://community.intersystems.com/post/video-getting-started-intersystems-iris-cloud-document

Enjoy the simplicity of your documents in the #cloud!

​🏥 Follow this detailed step-by-step #tutorial about #FHIR #SQL Builder that allows you to use a graphic interface to make sense of your #health data 👇

https://community.intersystems.com/post/fhir-sql-builder-step-step

Work smart, not hard!

​📹 Discover how the #OMOP Platform by InterSystems supports researchers by transforming #EHR data into the OMOP format. This #video showcases its #FHIR-to-OMOP pipeline, automated data and terminology mapping, and error reporting, all hosted on #IntersystemsIRIS Cloud #SQL 👇

https://community.intersystems.com/post/video-introduction-omop-platform

Simplify your data transformation process today! #Cloud

​🚀 When working with #InterSystemsIRIS, choosing between Dynamic and Embedded #SQL can impact your app's performance. This article dives into how response times differ based on SQL type, class structures, and parameters 👇

https://community.intersystems.com/post/response-times-when-using-dynamic-and-embedded-sql

Learn how to optimize your queries!

​⏱️ Dealing with massive datasets and complex queries? Explore how long-running #SQL queries can be optimized in #InterSystemsIRIS, focusing on #performance improvements for large, relational tables with billions of rows👇

https://community.intersystems.com/post/long-running-sql-queries-sample-exploration

Make your data work for you!