Data.SQL.Saturday.LA

Event organizer: https://linktr.ee/sqlsatla Session Room: SIOS (@SIOSTech) Session Speakers: Kevin Mackey Session Hosts: Brodie Brickey Session Abstract: Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates provide by SSMS for views, stored procedures, functions. Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code. - Source to Target mapping documents can be used to generate the code to effect the mapping. - Service Broker activation stored procedures have a clearly defined structure. They can be mass-produced. - Standard CRUD stored procedures can be stamped out cookie-cutter fashion. - Business rules can be encoded in data and the code to implement them manufactured. Generated code has systematic errors. Fix the errors at the generator. All the code now works. If the code is so boring that a computer can produce it, why not spend your talent doing something interesting? Session Materials: https://github.com/kevinjmackey/SQLSaturdayLA2021 Session Feedback: https://forms.office.com/r/WnEujLYWE6

Event organizer: https://linktr.ee/sqlsatla Session Room: VMware (@vmware) Session Speakers: Dèjì Akọ́mọláfẹ́ (@Dejify) Session Hosts: Steve Rezhener (@SteveRezhener) Session Abstract: Virtualizing Microsoft SQL Server on vSphere has matured so much that one can almost say that it is now an exact Science (or a Fine Art, if you prefer). As the most virtualized Mission Critical Application, modern versions of Microsoft SQL Server continues to be purpose-built for life in the virtual world, with intelligence and capabilities to efficiently utilize all the benefits of Virtualization without the much-feared "added complexities". VMware vSphere continues to be the target platform for most MSSQL Server workloads and, with vSphere now being available in all major Public Cloud infrastructure, the trend promises to continue to go. That you will virtualize your MSSQL Server workloads is a given. The degree to which you will be success, though? Well, that's the unknown. This Session will attempt to present all the common pitfalls you need to avoid in your virtualization efforts, regardless of whether your Microsoft SQL Server virtualization is on-premise or in one of the various vSphere-based Hybrid Cloud options available from AWS, Microsoft, Google, Oracle, etc. Come with questions. I need to earn my keeps. Session Materials: https://github.com/iyaburo/PublicSlides/blob/main/Questions%20That%20Matter%20When%20Virtualizing%20SQL%20Server%20on%20vSphere-Git.pptx Session Feedback: https://forms.office.com/r/nMzn6uZYXE

Event organizer: https://linktr.ee/sqlsatla Session Room: WhereScape (@WhereScape) Session Speakers: David Patrick (@DavidEPatrick) Session Hosts: Laurie Carr (@LaurieLCarr) Session Abstract: Microsoft Dataverse (formerly known as the Common Data Service) lets you securely store and manage data that's used by business applications. Data within Dataverse is stored within a set of tables (fka entities). A table is a set of records used to store data, just like data is stored within a database. Learn how Microsoft Dataverse ties into Power Automate. Create a Flow, see what triggers and actions are available and how you can use this all to move data back and forth between environments such as Microsoft Dynamics and SharePoint! Session Materials: TBD Session Feedback: https://forms.office.com/r/TchhdEwYKe

Event organizer: https://linktr.ee/sqlsatla Session Room: WhereScape (@WhereScape) Session Speakers: David Patrick (@DavidEPatrick) Session Hosts: Laurie Carr (@LaurieLCarr) Session Abstract: Microsoft Dataverse (formerly known as the Common Data Service) lets you securely store and manage data that's used by business applications. Data within Dataverse is stored within a set of tables (fka entities). A table is a set of records used to store data, just like data is stored within a database. Learn how Microsoft Dataverse ties into Power Automate. Create a Flow, see what triggers and actions are available and how you can use this all to move data back and forth between environments such as Microsoft Dynamics and SharePoint! Session Materials: TBD Session Feedback: https://forms.office.com/r/TchhdEwYKe

Event organizer: https://linktr.ee/sqlsatla Session Room: Datavail (@datavail) Session Speakers: Hasan Savran (@SavranWeb) Session Hosts: Elaena Bakman (@Elaena_Bakman) Session Abstract: Azure SQL Database Edge is a containerized application that runs on either an ARM64 or an x64-based processor. SQL Database Edge is optimized specifically for IoT and edge workloads running on resource-constrained interactive devices such as cameras, scanners, IoT gateways, and light-weight edge servers. Hasan will share his experience with installing and connecting Azure SQL Database Edge to Raspberry Pi. Session Materials: TBD Session Feedback: https://forms.office.com/r/bRGd7xn5Fy

Event organizer: https://linktr.ee/sqlsatla Session Room: Datavail (@datavail) Session Speakers: Hasan Savran (@SavranWeb) Session Hosts: Elaena Bakman (@Elaena_Bakman) Session Abstract: Azure SQL Database Edge is a containerized application that runs on either an ARM64 or an x64-based processor. SQL Database Edge is optimized specifically for IoT and edge workloads running on resource-constrained interactive devices such as cameras, scanners, IoT gateways, and light-weight edge servers. Hasan will share his experience with installing and connecting Azure SQL Database Edge to Raspberry Pi. Session Materials: TBD Session Feedback: https://forms.office.com/r/bRGd7xn5Fy

Event organizer: https://linktr.ee/sqlsatla Session Room: Datavail (@datavail) Session Speakers: Kevin Feasel (@feaselkl) Session Hosts: Elaena Bakman (@Elaena_Bakman) Session Abstract: The breadth of data platform options available to us today is staggering: between relational, object, graph, and document databases, we have a wide array of storage options, as well as a huge number of access and analysis tools. This talk will walk you through data platform, data analysis, and data processing options. We'll discuss when to use (and when not to use) Spark, R, Airflow, and Power BI, as well as a range of other interesting tools and technologies. By the end of this talk, you may not have MongoDB or Neo4J, but you will know where they might (or might not!) fit in your environment. Session Materials: https://www.catallaxyservices.com/presentations/curated-data-platform/ Session Feedback: https://forms.office.com/r/LkUP7t96Bm

Event organizer: https://linktr.ee/sqlsatla Session Room: Datavail (@datavail) Session Speakers: Kevin Feasel (@feaselkl) Session Hosts: Elaena Bakman (@Elaena_Bakman) Session Abstract: The breadth of data platform options available to us today is staggering: between relational, object, graph, and document databases, we have a wide array of storage options, as well as a huge number of access and analysis tools. This talk will walk you through data platform, data analysis, and data processing options. We'll discuss when to use (and when not to use) Spark, R, Airflow, and Power BI, as well as a range of other interesting tools and technologies. By the end of this talk, you may not have MongoDB or Neo4J, but you will know where they might (or might not!) fit in your environment. Session Materials: https://www.catallaxyservices.com/presentations/curated-data-platform/ Session Feedback: https://forms.office.com/r/LkUP7t96Bm

Event organizer: https://linktr.ee/sqlsatla Session Room: Datavail (@datavail) Session Speakers: JP Chen Session Hosts: Elaena Bakman (@Elaena_Bakman) Session Abstract: Are you interested in migrating your SQL Server instances over to the cloud? But, not sure how to get started? In this presentation, we will define what Database as a Service (DBaaS) is, build your Amazon RDS for SQL Server instance, administer your instance, migrate a sample database from on-premises over to your instance, and configure backup and restore. By the end of the presentation, you will understand the steps required to get started with your migrations over to Amazon RDS for SQL Server. Session Materials: TBD Session Feedback: https://forms.office.com/r/xrMV0arcif

Event organizer: https://linktr.ee/sqlsatla Session Room: WhereScape (@WhereScape) Session Speakers: Nikola Ilic (@DataMozart) Session Hosts: Laurie Carr (@LaurieLCarr) Session Abstract: By introducing Azure Synapse Analytics, Microsoft created a whole new perspective when it comes to data treatment. Some core concepts, such as traditional data warehousing, came under more scrutiny, while various fresh approaches started to pop up after data nerds became aware of the new capabilities that Synapse brought to the table. Not that Synapse made a strong impact on data ingestion, transformation, and storage options only – it also offered a whole new set of possibilities for data serving and visualization! During the session, we will try to explore how Power BI works in synergy with the new platform. What options we, Power BI developers, have when working with Synapse? In which data analytics scenarios, Synapse will play on the edge, helping you to achieve the (im)possible? When would you want to take advantage of the innovative solutions within Synapse, and when would you be better sticking with more conventional approaches? What are the best practices when using Power BI – Synapse combo, and which parameters should you evaluate before making a final decision on which path to take. Once we’re done, I believe that you should get a better understanding of the “pros” and “cons” for each of the available options when it comes to integration between Power BI and Synapse. Session Materials: https://github.com/NikolaIlic/Sessions-materials/tree/main/SQL%20Sat%20LA%202021-06-12 Session Feedback: https://forms.office.com/r/9dXXtTmTyG

Event organizer: https://linktr.ee/sqlsatla Session Room: Datavail (@datavail) Session Speakers: JP Chen Session Hosts: Elaena Bakman (@Elaena_Bakman) Session Abstract: Are you interested in migrating your SQL Server instances over to the cloud? But, not sure how to get started? In this presentation, we will define what Database as a Service (DBaaS) is, build your Amazon RDS for SQL Server instance, administer your instance, migrate a sample database from on-premises over to your instance, and configure backup and restore. By the end of the presentation, you will understand the steps required to get started with your migrations over to Amazon RDS for SQL Server. Session Materials: TBD Session Feedback: https://forms.office.com/r/xrMV0arcif

Event organizer: https://linktr.ee/sqlsatla Session Room: WhereScape (@WhereScape) Session Speakers: Nikola Ilic (@DataMozart) Session Hosts: Laurie Carr (@LaurieLCarr) Session Abstract: By introducing Azure Synapse Analytics, Microsoft created a whole new perspective when it comes to data treatment. Some core concepts, such as traditional data warehousing, came under more scrutiny, while various fresh approaches started to pop up after data nerds became aware of the new capabilities that Synapse brought to the table. Not that Synapse made a strong impact on data ingestion, transformation, and storage options only – it also offered a whole new set of possibilities for data serving and visualization! During the session, we will try to explore how Power BI works in synergy with the new platform. What options we, Power BI developers, have when working with Synapse? In which data analytics scenarios, Synapse will play on the edge, helping you to achieve the (im)possible? When would you want to take advantage of the innovative solutions within Synapse, and when would you be better sticking with more conventional approaches? What are the best practices when using Power BI – Synapse combo, and which parameters should you evaluate before making a final decision on which path to take. Once we’re done, I believe that you should get a better understanding of the “pros” and “cons” for each of the available options when it comes to integration between Power BI and Synapse. Session Materials: https://github.com/NikolaIlic/Sessions-materials/tree/main/SQL%20Sat%20LA%202021-06-12 Session Feedback: https://forms.office.com/r/9dXXtTmTyG

Event organizer: https://linktr.ee/sqlsatla Session Room: WhereScape (@WhereScape) Session Speakers: Anil Mahadev (@sqlservercowboy) Session Hosts: Laurie Carr (@LaurieLCarr) Session Abstract: Understanding the differences in SQL Server data warehouse architecture, approach, and benefits between leveraging Microsoft SQL Server Integration Services (SSIS) versus WhereScape® RED automation software is integral to choosing the right toolset for your data warehouse or big data integration project. This session gives an overview of both offerings to help you gain a clear grasp of the functionality each offers and which approach is best suited to the development methodologies and vision within your IT organization. Session Materials: https://github.com/anilm2021/sqlsatla2021 Session Feedback: https://forms.office.com/r/zHw3uhvjG6

Event organizer: https://linktr.ee/sqlsatla Session Room: WhereScape (@WhereScape) Session Speakers: Anil Mahadev (@sqlservercowboy) Session Hosts: Laurie Carr (@LaurieLCarr) Session Abstract: Understanding the differences in SQL Server data warehouse architecture, approach, and benefits between leveraging Microsoft SQL Server Integration Services (SSIS) versus WhereScape® RED automation software is integral to choosing the right toolset for your data warehouse or big data integration project. This session gives an overview of both offerings to help you gain a clear grasp of the functionality each offers and which approach is best suited to the development methodologies and vision within your IT organization. Session Materials: https://github.com/anilm2021/sqlsatla2021 Session Feedback: https://forms.office.com/r/zHw3uhvjG6

Event organizer: https://linktr.ee/sqlsatla Session Room: Datavail (@datavail) Session Speakers: Erik Monchen (@erikmonchen) Session Hosts: Elaena Bakman (@Elaena_Bakman) Session Abstract: This session is a showcase of a project where no less than 60 Million new data records per day had to be processed on a relational on-premise SQL Server database. After the explanation of the business case, I will guide you through the solution that is primarily focused on using partitions and some tips and tricks of how to manage them. The goal of this session is not to give you a deep dive into partitioning and indexing, but to give you input on scenarios that could help you in similar projects or with similar business cases Session Materials: https://github.com/erikmonchen/conferences/tree/main/2021-06-12%20Data%20Sat%20Los%20Angeles%20-%20Partitioning Session Feedback: https://forms.office.com/r/7L4nVa6hac

Event organizer: https://linktr.ee/sqlsatla Session Room: Datavail (@datavail) Session Speakers: Erik Monchen (@erikmonchen) Session Hosts: Elaena Bakman (@Elaena_Bakman) Session Abstract: This session is a showcase of a project where no less than 60 Million new data records per day had to be processed on a relational on-premise SQL Server database. After the explanation of the business case, I will guide you through the solution that is primarily focused on using partitions and some tips and tricks of how to manage them. The goal of this session is not to give you a deep dive into partitioning and indexing, but to give you input on scenarios that could help you in similar projects or with similar business cases Session Materials: https://github.com/erikmonchen/conferences/tree/main/2021-06-12%20Data%20Sat%20Los%20Angeles%20-%20Partitioning Session Feedback: https://forms.office.com/r/7L4nVa6hac

Event organizer: https://linktr.ee/sqlsatla Session Room: VMware (@vmware) Session Speakers: Kathi Kellenberger (@auntkathi) Session Hosts: Steve Rezhener (@SteveRezhener) Session Abstract: Over the years, many DBAs have avoided using Extended Events and continued using Trace. At first, this made sense because Extended Events had no user interface and you had to know XML to work with it. Eventually, Microsoft added a GUI, but many folks continued to use familiar tools. In this session, sponsored by Redgate, learn how to transition from Trace to Extended Events. You’ll find that it’s easy when you take the right approach. Session Materials: https://github.com/KathiKellenberger/ExtendedEvents Session Feedback: https://forms.office.com/r/yVuVpey6Ge

Event organizer: https://linktr.ee/sqlsatla Session Room: VMware (@vmware) Session Speakers: Kathi Kellenberger (@auntkathi) Session Hosts: Steve Rezhener (@SteveRezhener) Session Abstract: Over the years, many DBAs have avoided using Extended Events and continued using Trace. At first, this made sense because Extended Events had no user interface and you had to know XML to work with it. Eventually, Microsoft added a GUI, but many folks continued to use familiar tools. In this session, sponsored by Redgate, learn how to transition from Trace to Extended Events. You’ll find that it’s easy when you take the right approach. Session Materials: https://github.com/KathiKellenberger/ExtendedEvents Session Feedback: https://forms.office.com/r/yVuVpey6Ge

2021 SQLSATLA Speaker announcement! Kevin Mackey is a software architect with a track record of creative and effective delivery of results for organizations who want to translate data into information. In his session, Don't just code it–Generate it, you will learn how to write code, that writes code and translates data into information. --- Our 2021 SQL Saturday LA event is scheduled for June 12th, 2021. This event is free to attend and will be virtual, so you can join from the comfort of your home! If you are interested in Data Engineering, Python, Artificial Intelligence, DevOps, Azure, AWS, SQL, Business Intelligence, Machine Learning, MySQL, Women In Tech, Personal Branding, Careers in Tech and more, this event is for you! Please follow this link to reserve your spot: https://www.eventbrite.com/e/virtual-2021-datasqlsaturdayla-tickets-136013374665 Join our Facebook community! https://www.facebook.com/SQLSatLA Hope to see you all there!!

2021 SQLSATLA Speaker announcement! Kevin Mackey is a software architect with a track record of creative and effective delivery of results for organizations who want to translate data into information. In his session, Don't just code it–Generate it, you will learn how to write code, that writes code and translates data into information. --- Our 2021 SQL Saturday LA event is scheduled for June 12th, 2021. This event is free to attend and will be virtual, so you can join from the comfort of your home! If you are interested in Data Engineering, Python, Artificial Intelligence, DevOps, Azure, AWS, SQL, Business Intelligence, Machine Learning, MySQL, Women In Tech, Personal Branding, Careers in Tech and more, this event is for you! Please follow this link to reserve your spot: https://www.eventbrite.com/e/virtual-2021-datasqlsaturdayla-tickets-136013374665 Join our Facebook community! https://www.facebook.com/SQLSatLA Hope to see you all there!!

2021 SQLSATLA Speaker announcement! Kathi Kellenberger is the editor of Simple Talk at Redgate. Kathi's lecture topic is Getting Started with Extended Events. Over the years, many DBAs have avoided using Extended Events and continued using Trace. In this session, sponsored by Redgate, you will learn the best approach to transition from Trace to Extended Events. --- Our 2021 SQL Saturday LA event is scheduled for June 12th, 2021. This event is free to attend and will be virtual, so you can join from the comfort of your home! If you are interested in Data Engineering, Python, Artificial Intelligence, DevOps, Azure, AWS, SQL, Business Intelligence, Machine Learning, MySQL, Women In Tech, Personal Branding, Careers in Tech and more, this event is for you! Please follow this link to reserve your spot: https://www.eventbrite.com/e/virtual-2021-datasqlsaturdayla-tickets-136013374665 Join our Facebook community! https://www.facebook.com/SQLSatLA Hope to see you all there!!

2021 SQLSATLA Speaker announcement! Kathi Kellenberger is the editor of Simple Talk at Redgate. Kathi's lecture topic is Getting Started with Extended Events. Over the years, many DBAs have avoided using Extended Events and continued using Trace. In this session, sponsored by Redgate, you will learn the best approach to transition from Trace to Extended Events. --- Our 2021 SQL Saturday LA event is scheduled for June 12th, 2021. This event is free to attend and will be virtual, so you can join from the comfort of your home! If you are interested in Data Engineering, Python, Artificial Intelligence, DevOps, Azure, AWS, SQL, Business Intelligence, Machine Learning, MySQL, Women In Tech, Personal Branding, Careers in Tech and more, this event is for you! Please follow this link to reserve your spot: https://www.eventbrite.com/e/virtual-2021-datasqlsaturdayla-tickets-136013374665 Join our Facebook community! https://www.facebook.com/SQLSatLA Hope to see you all there!!

2021 SQLSATLA Speaker announcement! Kevin Feasel is the CTO at Envizage and is a Microsoft Data Platform MVP. Kevin will be presenting on The Curated Data Platform. This talk will walk you through data platform, data analysis, and data processing options. He will discuss when to use Spark, R, Airflow, and Power BI, as well as a range of other interesting tools and technologies. --- Our 2021 SQL Saturday LA event is scheduled for June 12th, 2021. This event is free to attend and will be virtual, so you can join from the comfort of your home! If you are interested in Data Engineering, Python, Artificial Intelligence, DevOps, Azure, AWS, SQL, Business Intelligence, Machine Learning, MySQL, Women In Tech, Personal Branding, Careers in Tech and more, this event is for you! Please follow this link to reserve your spot: https://www.eventbrite.com/e/virtual-2021-datasqlsaturdayla-tickets-136013374665 Join our Facebook community! https://www.facebook.com/SQLSatLA We are also accepting speakers! If you are interested in speaking at the 2021 event, follow this link below to submit you session: https://sessionize.com/2021-sql-saturday-in-los-angeles Hope to see you all there!!

2021 SQLSATLA Speaker announcement! Kevin Feasel is the CTO at Envizage and is a Microsoft Data Platform MVP. Kevin will be presenting on The Curated Data Platform. This talk will walk you through data platform, data analysis, and data processing options. He will discuss when to use Spark, R, Airflow, and Power BI, as well as a range of other interesting tools and technologies. --- Our 2021 SQL Saturday LA event is scheduled for June 12th, 2021. This event is free to attend and will be virtual, so you can join from the comfort of your home! If you are interested in Data Engineering, Python, Artificial Intelligence, DevOps, Azure, AWS, SQL, Business Intelligence, Machine Learning, MySQL, Women In Tech, Personal Branding, Careers in Tech and more, this event is for you! Please follow this link to reserve your spot: https://www.eventbrite.com/e/virtual-2021-datasqlsaturdayla-tickets-136013374665 Join our Facebook community! https://www.facebook.com/SQLSatLA We are also accepting speakers! If you are interested in speaking at the 2021 event, follow this link below to submit you session: https://sessionize.com/2021-sql-saturday-in-los-angeles Hope to see you all there!!

Loading SQL Server Data with PowerShell by Sean McCown (@KenpoDBA) PowerShell has become the defacto standard for scripting Microsoft products. However, putting data in text files doesn’t scale. Here I’m going to show you the ins and outs of loading data into SQL Server using PowerShell for the purpose of centralizing collections. We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting. This is a no holds barred session taught by an enterprise SQL Server scripting expert. You can’t afford to miss this session if you do any level of scripting in your shop. Prerequisites: Basic understanding of PowerShell syntax.