🌟 Session Overview 🌟

Session Name: SQL from the Frontend: Viable or Not? Speaker: David Gomes Session Description: David has worked on apps with a “SQL from the client” architecture, and the development velocity was simply superb. At the same time, it comes with many challenges, particularly in terms of security and scalability. So, what’s the deal? Is it viable or not?

The tl;dr is that the technology is perhaps not ready yet, but it makes a lot of sense for a large swath of apps – especially for prototypes. However, this is a complex topic, and I’ll delve deeper into the security problems during this talk. 🚀 About Big Data and RPA 2024 🚀

Unlock the future of innovation and automation at Big Data & RPA Conference Europe 2024! 🌟 This unique event brings together the brightest minds in big data, machine learning, AI, and robotic process automation to explore cutting-edge solutions and trends shaping the tech landscape. Perfect for data engineers, analysts, RPA developers, and business leaders, the conference offers dual insights into the power of data-driven strategies and intelligent automation. 🚀 Gain practical knowledge on topics like hyperautomation, AI integration, advanced analytics, and workflow optimization while networking with global experts. Don’t miss this exclusive opportunity to expand your expertise and revolutionize your processes—all from the comfort of your home! 📊🤖✨

📅 Yearly Conferences: Curious about the evolution of QA? Check out our archive of past Big Data & RPA sessions. Watch the strategies and technologies evolve in our videos! 🚀 🔗 Find Other Years' Videos: 2023 Big Data Conference Europe https://www.youtube.com/playlist?list=PLqYhGsQ9iSEpb_oyAsg67PhpbrkCC59_g 2022 Big Data Conference Europe Online https://www.youtube.com/playlist?list=PLqYhGsQ9iSEryAOjmvdiaXTfjCg5j3HhT 2021 Big Data Conference Europe Online https://www.youtube.com/playlist?list=PLqYhGsQ9iSEqHwbQoWEXEJALFLKVDRXiP

💡 Stay Connected & Updated 💡

Don’t miss out on any updates or upcoming event information from Big Data & RPA Conference Europe. Follow us on our social media channels and visit our website to stay in the loop!

🌐 Website: https://bigdataconference.eu/, https://rpaconference.eu/ 👤 Facebook: https://www.facebook.com/bigdataconf, https://www.facebook.com/rpaeurope/ 🐦 Twitter: @BigDataConfEU, @europe_rpa 🔗 LinkedIn: https://www.linkedin.com/company/73234449/admin/dashboard/, https://www.linkedin.com/company/75464753/admin/dashboard/ 🎥 YouTube: http://www.youtube.com/@DATAMINERLT

In today’s data-driven world, effective monitoring and log analytics are crucial for ensuring reliability, improving performance, and resolving issues efficiently. Join this session to discover how Amazon OpenSearch Service enhances reliability with advanced observability capabilities, including distributed tracing, real-time metrics collection, and customizable dashboards. Learn how to use OpenSearch Service security features such as fine-grained access control, encryption, and audit logging to protect your data and ensure compliance. Gain practical insights into optimizing performance, securing your data infrastructure, and efficiently managing your OpenSearch Service cluster to ensure your applications run smoothly and efficiently.

Learn more: AWS re:Invent: https://go.aws/reinvent. More AWS events: https://go.aws/3kss9CP

Subscribe: More AWS videos: http://bit.ly/2O3zS75 More AWS events videos: http://bit.ly/316g9t4

About AWS: Amazon Web Services (AWS) hosts events, both online and in-person, bringing the cloud computing community together to connect, collaborate, and learn from AWS experts. AWS is the world's most comprehensive and broadly adopted cloud platform, offering over 200 fully featured services from data centers globally. Millions of customers—including the fastest-growing startups, largest enterprises, and leading government agencies—are using AWS to lower costs, become more agile, and innovate faster.

AWSreInvent #AWSreInvent2024

A practical introduction to data engineering on the powerful Snowflake cloud data platform. Data engineers create the pipelines that ingest raw data, transform it, and funnel it to the analysts and professionals who need it. The Snowflake cloud data platform provides a suite of productivity-focused tools and features that simplify building and maintaining data pipelines. In Snowflake Data Engineering, Snowflake Data Superhero Maja Ferle shows you how to get started. In Snowflake Data Engineering you will learn how to: Ingest data into Snowflake from both cloud and local file systems Transform data using functions, stored procedures, and SQL Orchestrate data pipelines with streams and tasks, and monitor their execution Use Snowpark to run Python code in your pipelines Deploy Snowflake objects and code using continuous integration principles Optimize performance and costs when ingesting data into Snowflake Snowflake Data Engineering reveals how Snowflake makes it easy to work with unstructured data, set up continuous ingestion with Snowpipe, and keep your data safe and secure with best-in-class data governance features. Along the way, you’ll practice the most important data engineering tasks as you work through relevant hands-on examples. Throughout, author Maja Ferle shares design tips drawn from her years of experience to ensure your pipeline follows the best practices of software engineering, security, and data governance. About the Technology Pipelines that ingest and transform raw data are the lifeblood of business analytics, and data engineers rely on Snowflake to help them deliver those pipelines efficiently. Snowflake is a full-service cloud-based platform that handles everything from near-infinite storage, fast elastic compute services, inbuilt AI/ML capabilities like vector search, text-to-SQL, code generation, and more. This book gives you what you need to create effective data pipelines on the Snowflake platform. About the Book Snowflake Data Engineering guides you skill-by-skill through accomplishing on-the-job data engineering tasks using Snowflake. You’ll start by building your first simple pipeline and then expand it by adding increasingly powerful features, including data governance and security, adding CI/CD into your pipelines, and even augmenting data with generative AI. You’ll be amazed how far you can go in just a few short chapters! What's Inside Ingest data from the cloud, APIs, or Snowflake Marketplace Orchestrate data pipelines with streams and tasks Optimize performance and cost About the Reader For software developers and data analysts. Readers should know the basics of SQL and the Cloud. About the Author Maja Ferle is a Snowflake Subject Matter Expert and a Snowflake Data Superhero who holds the SnowPro Advanced Data Engineer and the SnowPro Advanced Data Analyst certifications. Quotes An incredible guide for going from zero to production with Snowflake. - Doyle Turner, Microsoft A must-have if you’re looking to excel in the field of data engineering. - Isabella Renzetti, Data Analytics Consultant & Trainer Masterful! Unlocks the true potential of Snowflake for modern data engineers. - Shankar Narayanan, Microsoft Valuable insights will enhance your data engineering skills and lead to cost-effective solutions. A must read! - Frédéric L’Anglais, Maxa Comprehensive, up-to-date and packed with real-life code examples. - Albert Nogués, Danone

AWS customers use Amazon Redshift to modernize their data analytics workloads and deliver insights for their businesses. Learn how to design your analytics system to scale with your business needs. Explore the different patterns of multi-cluster architectures and best practices to deploy them cost-effectively. Explore how GE Aerospace overcame challenges with its on-premises system by using a combination of architectural patterns to create an extensible design that met strict compliance and security requirements, achieved performance targets, and shared data across its enterprise.

Learn more: AWS re:Invent: https://go.aws/reinvent. More AWS events: https://go.aws/3kss9CP

Subscribe: More AWS videos: http://bit.ly/2O3zS75 More AWS events videos: http://bit.ly/316g9t4

About AWS: Amazon Web Services (AWS) hosts events, both online and in-person, bringing the cloud computing community together to connect, collaborate, and learn from AWS experts. AWS is the world's most comprehensive and broadly adopted cloud platform, offering over 200 fully featured services from data centers globally. Millions of customers—including the fastest-growing startups, largest enterprises, and leading government agencies—are using AWS to lower costs, become more agile, and innovate faster.

AWSreInvent #AWSreInvent2024

In this session, explore how to use Amazon Q Business, a generative AI–powered assistant, to remove the tasks that slow your team down. Quickly customize Amazon Q Business to answer questions, provide summaries, generate content, and complete tasks based on data and information in your enterprise systems. Learn how Life360 uses Amazon Q Business to accelerate their 300 engineers to harness information sprawl and move faster. With security and privacy as central considerations, Amazon Q Business respects existing user identities, roles, and permissions, and allows administers to restrict sensitive topics, block keywords, and filter out inappropriate questions and answers.

Learn more: AWS re:Invent: https://go.aws/reinvent. More AWS events: https://go.aws/3kss9CP

Subscribe: More AWS videos: http://bit.ly/2O3zS75 More AWS events videos: http://bit.ly/316g9t4

About AWS: Amazon Web Services (AWS) hosts events, both online and in-person, bringing the cloud computing community together to connect, collaborate, and learn from AWS experts. AWS is the world's most comprehensive and broadly adopted cloud platform, offering over 200 fully featured services from data centers globally. Millions of customers—including the fastest-growing startups, largest enterprises, and leading government agencies—are using AWS to lower costs, become more agile, and innovate faster.

AWSreInvent #AWSreInvent2024

Data warehouses, data lakes, or both? Explore how Amazon SageMaker Lakehouse, a unified, open, and secure data lake house simplifies analytics and AI. This session unveils how SageMaker Lakehouse provides unified access to data across Amazon S3 data lakes, Amazon Redshift data warehouses, and third-party sources without altering your existing architecture. Learn how it breaks down data silos and opens your data estate with Apache Iceberg compatibility, offering flexibility to use preferred query engines and tools that accelerate your time to insights. Discover robust security features, including consistent fine-grained access controls, that help democratize data without compromises.

Learn more: AWS re:Invent: https://go.aws/reinvent. More AWS events: https://go.aws/3kss9CP

Subscribe: More AWS videos: http://bit.ly/2O3zS75 More AWS events videos: http://bit.ly/316g9t4

About AWS: Amazon Web Services (AWS) hosts events, both online and in-person, bringing the cloud computing community together to connect, collaborate, and learn from AWS experts. AWS is the world's most comprehensive and broadly adopted cloud platform, offering over 200 fully featured services from data centers globally. Millions of customers—including the fastest-growing startups, largest enterprises, and leading government agencies—are using AWS to lower costs, become more agile, and innovate faster.

AWSreInvent #AWSreInvent2024

Date: 2024-12-04. Panel discussion featuring Derrick A. Butts (CEO/Founder, Continuums Strategies LLC) and Eric L. Harris Jr. (Chief Information Security Officer, Charlie Norwood VA Medical Center), moderated by Tyrone T. McKinney. The panel will cover Cybersecurity 101, Recent Data Breaches, Emerging Threats, Best Practices & Practical Tips, Specializations in Cybersecurity, and Career Roadmaps.

When adopting generative AI, enterprises face unique challenges including scaling, cost management, and resource optimization. This session explores building a robust, enterprise-grade generative AI platform using Amazon Bedrock. Discover how to centrally manage AI resources while efficiently serving multiple teams through dedicated workspaces, which helps ensure security, compliance, and cost optimization. See demos of key features like provisioned throughput, prompt management, and prompt flows, providing insights into designing and implementing an enterprise-ready generative AI platform that balances innovation and scalability.

Learn more: AWS re:Invent: https://go.aws/reinvent. More AWS events: https://go.aws/3kss9CP

Subscribe: More AWS videos: http://bit.ly/2O3zS75 More AWS events videos: http://bit.ly/316g9t4

About AWS: Amazon Web Services (AWS) hosts events, both online and in-person, bringing the cloud computing community together to connect, collaborate, and learn from AWS experts. AWS is the world's most comprehensive and broadly adopted cloud platform, offering over 200 fully featured services from data centers globally. Millions of customers—including the fastest-growing startups, largest enterprises, and leading government agencies—are using AWS to lower costs, become more agile, and innovate faster.

AWSreInvent #AWSreInvent2024

Exploration of xIoT/OT devices, security vulnerabilities, and a live hacking demonstration with actionable security steps.

With billions of IoT and OT devices powering manufacturing and industrial operations today, the xTended Internet of Things (xIoT) now surpasses traditional endpoints by an order of magnitude. Despite their critical roles, many of these IoT and OT Cyber-Physical Systems (CPS) remain overlooked and unsecured—operating with default or weak credentials, outdated firmware, insecure configurations, and an end-of-life state. This creates a vast and vulnerable attack surface that threat actors increasingly target to disrupt operations, exfiltrate data, or stage sophisticated ransomware attacks. The session will also delve into the anatomy of OT and OT-adjacent IoT cyberattacks, detailing how attackers exploit these devices to achieve malicious goals. A live hacking demonstration will showcase the methods used to compromise common, yet mission-critical, devices — emphasizing the importance of proactive security measures to disappoint bad actors. Attendees will leave with a deeper understanding of the scope and state of this attack surface, the critical role IoT and OT security plays in protecting the modern industrial landscape, and actionable steps that can be taken to strengthen their xIoT security posture.

Discussion on OT security and attacks on operational technology, with real-world implications for manufacturing.

In the increasingly vulnerable cybersecurity landscape, the manufacturing sector stands as a key target for security incidents. Upholding NIS2 compliance is not just a necessity— it's a strategic advantage. This talk offers exclusive insights into driving NIS2 compliance in a multi-national manufacturing environment where organizations must manage facilities in multiple EU Member States. You will learn tailored collaboration strategies with site personnel for comprehensive risk ownership and effective incident detection and response. We will delve into 'quick wins' for immediate security boosts and outline a strategic long-term roadmap. This session aims to equip attendees with the tools needed to bolster OT security and transform what we see as the common pain points into areas of strength.

Your MySQL instances are probably broken. Many developers face slow-running queries, issues related to database architecture, replication, or database security—and that’s only the beginning. This book will deliver answers to your most pressing MySQL database questions related to performance, availability, or security by uncovering what causes databases to break in the first place. At its core, this book provides you with the knowledge necessary for you to break your database instances so you can better optimize it for performance and secure it from data breaches. In other words, you’ll discover the sorts of actions, minor and major, that degrade databases so you can fix and ultimately preempt them. MySQL sometimes acts according to its own rules, and this book will help you keep it working on your terms. At the same time, you will learn to optimize your backup and recovery procedures, determine when and which data to index to achieve maximum performance, and choose the best MySQL configurations, among other essential skills. Most MySQL books focus exclusively on optimization, but this book argues that it’s just as important to pay attention to the ways databases break. Indeed, after reading this book, you will be able to safely break your database instances to expose and overcome the nuanced issues that affect performance, availability, and security. What You Will Learn Know the basics of MySQL and the storage engines innoDB and MyISAM Spot the ways you are harming your database’s performance, availability and security without even realizing it Fix minor bugs and issues that have surprisingly serious impact Optimize schema, data types, queries, indexes, and partitions to head off issues Understand key MySQL security strategies Who This Book Is For Database administrators, web developers, systems administrators, and security professionals with an intermediary knowledge of database management systems and building applications in MySQL

We’re improving DataFramed, and we need your help! We want to hear what you have to say about the show, and how we can make it more enjoyable for you—find out more here. With the EU AI Act coming into effect, the AI industry faces a pivotal moment. This regulation is a landmark step for AI governance and challenges data and AI teams to rethink their approach to AI development and deployment. How will this legislation influence the way AI systems are built and used? What are the key compliance requirements that organizations need to be aware of? And how can companies balance regulatory obligations with the drive for innovation and growth? Dan Nechita led the technical negotiations for the EU Artificial Intelligence Act on behalf of the European Parliament. For the 2019-2024 mandate, besides artificial intelligence, he focused on digital regulation, security and defense, and the transatlantic partnership as Head of Cabinet for Dragos Tudorache, MEP. Previously, he was a State Counselor for the Romanian Prime Minister with a mandate on e-governance, digitalization, and cybersecurity. He worked at the World Security Institute (the Global Zero nuclear disarmament initiative); at the Brookings Institution Center of Executive Education; as a graduate teaching assistant at the George Washington University; at the ABC News Political Unit; and as a research assistant at the Arnold A. Saltzman Institute of War and Peace at Columbia. He is an expert project evaluator for the European Commission and a member of expert AI working groups with the World Economic Forum and the United Nations. Dan is a graduate of the George Washington University (M.A.) and Columbia University in the City of New York (B.A.). In the episode, Adel and Dan explore the EU AI Act's significance, risk classification frameworks, organizational compliance strategies, the intersection with existing regulations, AI literacy requirements, and the future of AI legislation, and much more. Links Mentioned in the Show: The EU AI ActConnect with DanCourse: Understanding the EU AI ActRelated Episode: Guardrails for the Future of AI with Viktor Mayer-Schönberger, Professor of Internet Governance and Regulation at the University of OxfordRewatch sessions from RADAR: Forward Edition New to DataCamp? Learn on the go using the DataCamp mobile app Empower your business with world-class data and AI skills with DataCamp for business

In this session, we will explore the roadmap of SQL Server including future capabilities for AI applications deeply integrated into the security zone of the SQL Server engine. We will also show you AI assisted experiences to help you manage SQL Server including tools like SQL Server Management Studio (SSMS), Query Store, Intelligent Query Processing and Azure Arc. Learn how AI can streamline your workflow, reduce context switching, and boost overall efficiency.

𝗦𝗽𝗲𝗮𝗸𝗲𝗿𝘀: * Joe Sack * Erin Stellato * Bob Ward

𝗦𝗲𝘀𝘀𝗶𝗼𝗻 𝗜𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻: This is one of many sessions from the Microsoft Ignite 2024 event. View even more sessions on-demand and learn about Microsoft Ignite at https://ignite.microsoft.com

BRK195 | English (US) | Data

MSIgnite

GenAI applications and Copilots are transforming the SQL experience. Join us to learn how Microsoft delivers an optimal platform for new AI workloads using vectors and RAG patterns, while ensuring ROI, performance, and security your business demands today. Discover the latest innovations for Azure SQL for gen AI applications and database context-aware Copilots, powered by Azure SQL Database Hyperscale. Ensure your SQL estate is future-ready in this era of intelligent applications and analytics.

𝗦𝗽𝗲𝗮𝗸𝗲𝗿𝘀: * John Tracy * Bob Ward * Muazma Zahid

𝗦𝗲𝘀𝘀𝗶𝗼𝗻 𝗜𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻: This is one of many sessions from the Microsoft Ignite 2024 event. View even more sessions on-demand and learn about Microsoft Ignite at https://ignite.microsoft.com

BRK192 | English (US) | Data

MSIgnite

Join us for an enlightening session on building and using trustworthy AI applications that prioritize safety, security, and privacy. Discover best practices for AI security and mitigating emerging threats, learn how to develop applications with built-in safety and guardrails, manage compliance, and safeguard sensitive data.

𝗦𝗽𝗲𝗮𝗸𝗲𝗿𝘀: * Sarah Bird * Sumit Bhattacharyya * Anna Maria Brunnhofer-Pedemonte * John Israel * Markus Mooslechner * Herain Oberoi

𝗦𝗲𝘀𝘀𝗶𝗼𝗻 𝗜𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻: This is one of many sessions from the Microsoft Ignite 2024 event. View even more sessions on-demand and learn about Microsoft Ignite at https://ignite.microsoft.com

BRK129 | English (US) | AI

MSIgnite

Join us for a deep dive into Azure AI Foundry with a focus on security and IT governance. This session is tailored for IT admins, security pros, and developers committed to shifting left in their security practices. We'll explore enterprise security promises in Azure AI, including capabilities and controls for network security, data encryption, and identity management to ensure your GenAI projects remain secure and compliant throughout the GenAI development lifecycle.

𝗦𝗽𝗲𝗮𝗸𝗲𝗿𝘀: * Dennis Eikenboom * Meera Kurup

𝗦𝗲𝘀𝘀𝗶𝗼𝗻 𝗜𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻: This is one of many sessions from the Microsoft Ignite 2024 event. View even more sessions on-demand and learn about Microsoft Ignite at https://ignite.microsoft.com

BRK122 | English (US) | AI

MSIgnite

All the mistakes you might make with SQL Server—and how to avoid them! 100 SQL Server Mistakes and How to Avoid Them prepares you for the pitfalls database professionals often encounter—from administration to development, availability, and security. You'll learn to sidestep common errors that slow down your T-SQL code and ensure your SQL Server is installed and configured to handle anything your organization throws at it. Inside 100 SQL Server Mistakes and How to Avoid Them you'll learn to avoid: Development errors when writing T-SQL Installation and administration mistakes Optimization missteps Common pitfalls relating to high availability and disaster recovery (HA/DR) Security oversights that can endanger your data 100 SQL Server Mistakes and How to Avoid Them doesn't focus on the "happy path"—instead, it covers all the errors and problems you might face as a SQL Server developer or administrator. Each chapter is filled with real-world issues drawn from author Peter A. Carter’s two-decade-long career in SQL Server. Peter's seasoned advice helps dispel myths, debunk misconceptions, and set you on the right road. About the Technology Perfecting a SQL Server system can be a complex balancing act. Why is T-SQL running so slowly? Are the right data available? Are we protected against data theft? What about that new server instance I need to administer? Even the most skilled SQL Server experts make mistakes that cost time and performance. This book can help you get it right the first time. About the Book 100 SQL Server Mistakes and How to Avoid Them focuses exclusively on the errors that you might—and probably will—make as a SQL Server admin or developer. Real-world examples, code samples, and helpful diagrams make it easy to understand each issue and its solution. You’ll learn how to write performant code, design efficient database schemas, implement error handling, work with complex data types, and much more, all in a friendly, common-sense problem/solution format. What's Inside T-SQL development Installation, administration, and optimization High availability and security About the Reader Readers need to understand basic SQL Server concepts and SQL queries. Perfect for junior database admins, full-stack developers, and “accidental” DBAs. About the Author Peter A. Carter is a SQL Server expert with experience developing, administering, and architecting data-tier applications and SQL Server platforms. Quotes A masterful job! Covers the nuances of SQL Server that a new admin, or even an experienced one, needs to understand. - Allen White, SQL Server MVP 2007-2022 Quick, actionable advice that greatly improved my SQL Server skills. - Ruben Vandeginste, PeopleWare A practical path through pitfalls in administration and development with specific solutions, examples, and code snippets. - Josephine Bush, sqlkitty.com Worth reading for the testing and debugging section alone! - Mike McQuillan, McQTech Ltd.

This book, "Power Apps Tips, Tricks, and Best Practices," is your guide to mastering the development of robust Power Apps solutions. Through its structured and practical approach, you'll gain insights into planning, building, and maintaining applications using the Power Platform. Master advanced techniques, integrate with other systems, and ensure governance and security for professional-grade outcomes. What this Book will help me do Create scalable and maintainable applications using Power Apps. Master the setup and integration of Power Apps with tools like Power Automate and Power BI. Apply governance and security measures effectively to your Power Apps solutions. Leverage advanced topics such as data connections, Copilot Studio, and error handling. Optimize application interfaces through best practices using filtering, formatting, and formulas. Author(s) Andrea Pinillos and Tim Weinzapfel, experienced practitioners in Power Platform technologies, bring their expertise to this book. With years of professional experience in design and implementation, they use their hands-on knowledge to explain complex topics simply and clearly. Their passion for teaching is evident in their step-by-step approach to help you build Power Apps effectively. Who is it for? This book is designed for business analysts, IT professionals, and developers aiming to improve their app development skills. It accommodates both technical and non-technical users with an interest in Power Apps and the Power Platform. Readers should have a basic understanding of Microsoft 365 and Power Apps, although advanced topics are explained for beginners to comprehend easily.