Data.SQL.Saturday.LA

What is a SQL Saturday? Why attend a SQL Saturday event? When and where I can attend SQL Saturday events? What topics do SQL Saturday events cover? SQL Saturday events are about learning, networking, and having fun!

Event organizer: https://linktr.ee/sqlsatla Session Room: SIOS (@SIOSTech) Session Speakers: Torsten Strauß (@TorstenStrauss) Session Hosts: Brodie Brickey Session Abstract: In this session we will look at the design principals of the in-memory OLTP engine. We will understand how the in-memory engine optimizes data storage for main memory, eliminates latches and locks, and uses native compilation to reduce the CPU overhead. For this we will compare the traditional on-disk engine with the in-memory engine to decide when it makes sense to use in-memory OLTP. Session Materials: TBD Session Feedback: https://forms.office.com/r/1jYS6dJdMc

Event organizer: https://linktr.ee/sqlsatla Session Room: Lucient (@lucient_data) Session Speakers: Mikey Bronowski (@MikeyBronowski) Session Hosts: Maria Lopez (@Mimz_Techritory) Session Abstract: The good ol' agent, SQL Server Agent, is known widely in the DBA world. It is powerful, but... Azure SQL Database requires something more, something different. Meet elastic Elastic Database agent and its jobs! Session Materials: TBD Session Feedback: https://forms.office.com/r/2qU2C73NSk

Event organizer: https://linktr.ee/sqlsatla Session Room: SIOS (@SIOSTech) Session Speakers: Damir Matešić (@matesic_damir) Session Hosts: Brodie Brickey Session Abstract: JSON (JavaScript Object Notation) is a language in depended, very popular, open standard format for data exchange between applications and services. On this session accompanied by numerous examples we should pass through the usage of JSON in MS SQL. Main topics: - Format MS SQL data in JSON format - Read JSON data in MS SQL - Modify JSON data using JSON_MODIFY - JSON functions, tips & tricks Session Materials: https://github.com/matesic-damir/SQLSatLA---Advanced-data-types-JSON.git Session Feedback: https://forms.office.com/r/D6LBxgdiYJ

Event organizer: https://linktr.ee/sqlsatla Session Room: SIOS (@SIOSTech) Session Speakers: Amit Bansal (@A_Bansal) Session Hosts: Brodie Brickey Session Abstract: In this session, you will learn how to write optimized T-SQL code for SQL Server. You will see real-world examples related to Sarg-ability, Re-Writing T-SQL for better performance, SQL Injection, Parameterization and if time permits, we will also see the good and bad of Dynamic SQL. Session Materials: TBD Session Feedback: https://forms.office.com/r/ADCeJB9HxS

Event organizer: https://linktr.ee/sqlsatla Session Room: WhereScape (@WhereScape) Session Speakers: Luis Beltran (@darkicebeam) Session Hosts: Laurie Carr (@LaurieLCarr) Session Abstract: The development of Artificial Intelligence is increasingly present in our lives and as time goes by, its presence will grow thanks to the momentum that enterprises are currently providing. One of the most engaging AI applications is chatbots, which interact with users in real-time to assist them to perform a task -such as booking a hotel, answering a question or looking for specific information on the Internet- while simulating that a real human is behind the scene. Data is knowledge, and the data that has been stored in your Azure SQL database can be used as an input for a bot which assists a company's customers in order to process the information for them and return expected results. This session will be focused on explaining the actors involved when building a bot capable of obtaining data from your storage, including Azure SQL Database, Microsoft Bot Framework and LUIS (Language Understanding Intelligent Services). And you can integrate your bot on different channels such as Facebook Messenger, Microsoft Teams or even in your own website/app through Direct Line. Session Materials: TBD Session Feedback: https://forms.office.com/r/CyYm8r41pM

Event organizer: https://linktr.ee/sqlsatla Session Room: WhereScape (@WhereScape) Session Speakers: Dennes Torres (@Dennes) Session Hosts: Laurie Carr (@LaurieLCarr) Session Abstract: The M language provides to Power Query a very powerful way to develop ETL, way beyond the basic features you know. We can create functions, re-use functions, create loops, everything to turn our data transformations easier. During this session you will see many advanced techniques using M and Power Query Session Materials: https://github.com/DennesTorres/PowerBISQLSatLA Session Feedback: https://forms.office.com/r/sHc4WmrT9f

Event organizer: https://linktr.ee/sqlsatla Session Room: Datavail (@datavail) Session Speakers: Magnus Ahlkvist (@Transmokopter) Session Hosts: Elaena Bakman (@Elaena_Bakman) Session Abstract: I was very late to adopt PowerShell in my day-to-day work as a DBA. I did some copy/change "programming" with PowerShell. But it wasn't until I got in touch with DBATools that I really understood the power of PowerShell. In this session, I will demo some of the reasons I really love PowerShell and DBATools. I will cover a brief overview of DBATools and then jump into some scenarios where DBATools really helped me, including: - Automatic restore testing - Homecooked log shipping - Migration work Session Materials: TBD Session Feedback: https://forms.office.com/r/x098xFkG9b

Event organizer: https://linktr.ee/sqlsatla Session Room: Lucient (@lucient_data) Session Speakers: Ginger Grant (@DesertIsleSQL) Session Hosts: Maria Lopez (@Mimz_Techritory) Session Abstract: This session will provide a introduction into the different pools of Azure Synapse Analytics. We will look at how you can create a spark virtual database with Apache Spark Pools, create a data warehouse for large amounts of data with Dedicated Pools, perform ETL with Integrated Runtimes a type of Spark Pool, and create virtual databases and query flat files with Serverless Pools. We will look at how you can use these different pools to analyze and develop data in Azure. Session Materials: TBD Session Feedback: https://forms.office.com/r/QyD2vDFGGw

Event organizer: https://linktr.ee/sqlsatla Session Room: VMware (@vmware) Session Speakers: Kevin Chant (@kevchant) Sander Stad (@SQLStad) Session Hosts: Steve Rezhener (@SteveRezhener) Session Abstract: Welcome to GitHub DevOps Duet, a scenario where two teams (Dev and Ops) are going to start using GitHub Actions for Data Platform deployments. They need to figure out how to implement their processes within GitHub and make it work for all parties. We will discuss: - the challenges of implementing DevOps - setting up a database solution project - testing your database releases using tSQLt - setting up your GitHub Actions workflows - deploy database artifacts to multiple Data Platform solutions As part of the session we will cover the GitHub services you get including: - Actions - Projects - Security The session will cover how to setup projects for your tasks, set up workflows in GitHub Actions, security and so much more. If you want to find out more about how GitHub can be implemented for your DevOps process than come to our session Session Materials: TBD Session Feedback: https://forms.office.com/r/gLfpwvbjfF

Event organizer: https://linktr.ee/sqlsatla Session Room: Lucient (@lucient_data) Session Speakers: Jen Lunde Session Hosts: Maria Lopez (@Mimz_Techritory) Session Abstract: While some may love the opportunity to work from home, most are bound to run into communication challenges when working remotely at some point. Miscommunication at work can lead to unnecessary stress, frustration, and potentially negatively impact your performance, or the perception of your performance. In this session I will share best practices to keep communication productive and clear with your coworkers and supervisor, so you are equipped, productive and positive at work. Session Materials: https://github.com/JenLunde/SQLSaturdayLA2021.git Session Feedback: https://forms.office.com/r/J4zBddrdsk

Event organizer: https://linktr.ee/sqlsatla Session Room: WhereScape (@WhereScape) Session Speakers: Armando Lacerda (@arlacerda) Session Hosts: Laurie Carr (@LaurieLCarr) Session Abstract: You can deploy AI/ML solutions in multiple places: in IoT devices, at the cloud-edge, in cloud API endpoints and a few more locations. In this session will you learn the options available in Azure data platform services and how that can improve transactional systems in the back end as well as BI use cases. We will look into Azure SQL DB and Synapse Analytics and the opportunities to deploy Ai in these services. Session Materials: TBD Session Feedback: https://forms.office.com/r/Sk0K3byd21

Event organizer: https://linktr.ee/sqlsatla Session Room: Lucient (@lucient_data) Session Speakers: Brandon Leach (@SqlServerNerd) Session Hosts: Maria Lopez (@Mimz_Techritory) Session Abstract: Corruption can strike at any time. As DBAs how we alert, investigate, and respond can have a profound impact on our company. In this session we will learn how to detect and respond to various types of corruption. First we will be focus on ways to detect corruption early. This will include understanding tools available to us like DBCC CheckDB as well as the importance of testing your backups. We’ll look at some sample scripts to automate corruption checks and common alerts we should have set up on our instances. Then we will move onto how to respond. We’ll discuss the importance of incident management and the Disaster Recovery mindset and look at how we can analyze the situation safely as well as point out various pitfalls that trip people up. We’ll also discuss when and how we may be able to fix corruption vs restoring the database. Additionally we will look at a few common examples of corruption and how to fix them. Session Materials: TBD Session Feedback: https://forms.office.com/r/QF5ed2UVPd

Event organizer: https://linktr.ee/sqlsatla Session Room: SIOS (@SIOSTech) Session Speakers: Shane Welgama (@ShaneWelgama) Session Hosts: Brodie Brickey Session Abstract: Locking is an essential need to uphold data integrity. Managing locking behavior is also important when it comes to improving transaction concurrency. In this talk, we will dive into the locking behavior of SQL Server. We will learn how to uncover performance problems related to locks and lock escalations, when and why deadlocks happen, and the possible steps you can take to prevent deadlocks from happening. Join me in understanding the key to SQL Server’s locking behavior. Session Materials: TBD Session Feedback: https://forms.office.com/r/zL5V1VKp6F

Event organizer: https://linktr.ee/sqlsatla Session Room: Lucient (@lucient_data) Session Speakers: Ray Kim (@PianoRayK) Session Hosts: Maria Lopez (@Mimz_Techritory) Session Abstract: Networking. You keep hearing that word throughout your career development, but you don’t know much about it, much less, how to do it. You want to connect with technical and data professionals, so you attend events such as SQL Saturday and your local user group. But what about your book club, your gym, your church group, or your kid’s soccer game? Those are prime — and overlooked — opportunities to network! In this interactive session, we will discuss networking — what it is, why it’s important, and where opportunities exist. You will even have an opportunity to practice networking within the confines of our room. You might even leave this session with new networking contacts that you didn’t previously have! Bring business cards if you have them! Session Materials: TBD Session Feedback: https://forms.office.com/r/1StHzz0DzB

Event organizer: https://linktr.ee/sqlsatla Session Room: Lucient (@lucient_data) Session Speakers: Mark Runyon (@aspprogrammer) Session Hosts: Maria Lopez (@Mimz_Techritory) Session Abstract: The skills that make you a brilliant technologist don't always map over when you want to take the next step into a leadership position. In this session, we will look at key skills to develop in order to prepare for the next step in your IT career. Session Materials: TBD Session Feedback: https://forms.office.com/r/BpSpYGw7VS

Event organizer: https://linktr.ee/sqlsatla Session Room: Lucient (@lucient_data) Session Speakers: Mark Runyon (@aspprogrammer) Session Hosts: Maria Lopez (@Mimz_Techritory) Session Abstract: The skills that make you a brilliant technologist don't always map over when you want to take the next step into a leadership position. In this session, we will look at key skills to develop in order to prepare for the next step in your IT career. Session Materials: TBD Session Feedback: https://forms.office.com/r/BpSpYGw7VS

Event organizer: https://linktr.ee/sqlsatla Session Room: VMware (@vmware) Session Speakers: Jared Poche (sqljared) Session Hosts: Steve Rezhener (@SteveRezhener) Session Abstract: Query optimization is relatively easy when you look at a plan and find table scans, hash match joins, and missing indexes. But how do you find opportunities when all the low hanging fruit has been picked? This session is a case study on improving a procedure that runs 350 million times per day, so any improvement is greatly magnified. We will discuss where we found opportunities to improve a procedure running in 3.1 milliseconds; how effective our attempts were, what didn't work, and the results achieved. Session Materials: TBD Session Feedback: https://forms.office.com/r/p4JGycv9Wu

Event organizer: https://linktr.ee/sqlsatla Session Room: VMware (@vmware) Session Speakers: Jared Poche (sqljared) Session Hosts: Steve Rezhener (@SteveRezhener) Session Abstract: Query optimization is relatively easy when you look at a plan and find table scans, hash match joins, and missing indexes. But how do you find opportunities when all the low hanging fruit has been picked? This session is a case study on improving a procedure that runs 350 million times per day, so any improvement is greatly magnified. We will discuss where we found opportunities to improve a procedure running in 3.1 milliseconds; how effective our attempts were, what didn't work, and the results achieved. Session Materials: TBD Session Feedback: https://forms.office.com/r/p4JGycv9Wu

Event organizer: https://linktr.ee/sqlsatla Session Room: VMware (@vmware) Session Speakers: Shayon Sanyal Session Hosts: Steve Rezhener (@SteveRezhener) Session Abstract: Amazon Aurora is a relational database service that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. The PostgreSQL-compatible edition of Aurora delivers up to 3X the throughput of standard PostgreSQL running on the same hardware, enabling existing PostgreSQL applications and tools to run without requiring modification. The combination of PostgreSQL compatibility with Aurora enterprise database capabilities provides an ideal target for commercial database migrations. Session Materials: TBD Session Feedback: https://forms.office.com/r/RRDNFPTQdw

Event organizer: https://linktr.ee/sqlsatla Session Room: VMware (@vmware) Session Speakers: Shayon Sanyal Session Hosts: Steve Rezhener (@SteveRezhener) Session Abstract: Amazon Aurora is a relational database service that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. The PostgreSQL-compatible edition of Aurora delivers up to 3X the throughput of standard PostgreSQL running on the same hardware, enabling existing PostgreSQL applications and tools to run without requiring modification. The combination of PostgreSQL compatibility with Aurora enterprise database capabilities provides an ideal target for commercial database migrations. Session Materials: TBD Session Feedback: https://forms.office.com/r/RRDNFPTQdw

Event organizer: https://linktr.ee/sqlsatla Session Room: SIOS (@SIOSTech) Session Speakers: David Bermingham (@daveberm) Session Hosts: Brodie Brickey Session Abstract: This session sponsored by SIOS technology will give an overview of their Windows and Linux clustering solutions that enables high availability and disaster recovery configurations on-prem, in the cloud and hybrid cloud. Session Materials: TBD Session Feedback: https://forms.office.com/r/685HvMyq7a

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: SIOS (@SIOSTech) Session Speakers: David Bermingham (@daveberm) Session Hosts: Brodie Brickey Session Abstract: This session sponsored by SIOS technology will give an overview of their Windows and Linux clustering solutions that enables high availability and disaster recovery configurations on-prem, in the cloud and hybrid cloud. Session Materials: TBD Session Feedback: https://forms.office.com/r/685HvMyq7a

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