Los Angeles Data Platform

Abstract: Back to the Future is the greatest time travel movie ever. I'll show you how temporal tables work, in both SQL Server and Azure SQL Database, without needing a DeLorean. We cover point in time analysis, reconstructing state at any time in the past, recovering from accidental data loss, calculating trends, and my personal favorite: auditing. There's even a bit of In-Memory OLTP. This is a demo-heavy session. About Randolph Randolph West, founder of Born SQL, is an independent IT consultant, speaker, Calgary PASS user group leader, Microsoft Data Platform MVP, and lead author of “SQL Server 2019 Administration Inside Out”. Randolph specializes in SQL Server performance tuning, disaster recovery, and migrations from really old versions, with an emphasis on implementing best practices. Randolph has presented at PASS Summit, SQLBits, SQL Saturdays, and user groups. You can also find Randolph acting and directing on screen or the stage, or annoying people on Twitter. Do not trust Randolph around chocolate.

Interview with Randolph West RSVP here: https://ladataplatform2105.eventbrite.com/

Interview with Randolph West RSVP here: https://ladataplatform2105.eventbrite.com/

Abstract: Azure Synapse Workspace provides the ability to use both Apache Spark and Databricks. Which one should you use? The answer of course is “It Depends”. In this session we are going to review what the use cases are which would determine why you would select one tool over another. Here we will examine the costs, the kind of data being analyzed, how much data is processed, variability of data loads, and other variables which determine which solution should be implemented. This session will also review when a Spark based processing tool should be used and when you are better off another tool such as SQL on-demand or an Extract, Load and Transform (ELT) process. The demos will show how to implement each solution in the Azure Synapse Workspace and how each can be used to process data. About Ginger Ginger Grant is a Principal Consultant in Advanced Analytics. She manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.

Glance at all 2021 Los Angeles Data Platform User Group sessions

http://ladataplatform.eventbrite.com https://www.meetup.com/los-angeles-data-platform/

http://ladataplatform.eventbrite.com https://www.meetup.com/los-angeles-data-platform/

Abstract: The Microsoft Power Platform has become an innovative bridge between data interaction, visualization and analytics. The possibilities have become almost endless for businesses to engage with their data in amazing ways. In this session, I will show you an application using Power Apps and location services to track latitude and longitude coordinates on Bing maps. Attendees will learn how to configure and use the application on a mobile device. I will also show two approaches using AI within the application by using Azure SQL Database, Cognitive Services and Power Automate. An end-user will be able to leverage Bing Search for location-aware web searches while an administrator will be able to leverage the Azure SQL Database and Power Automate to send alerts based on predefined metrics. About Jeremy Jeremy Frye is a Sr. Manager of Data Analytics at Navisite. He has over 12 years of experience in database design, development, business intelligence, data analytics, and management across on-premises and cloud technologies. He is a frequent speaker the Microsoft community and a 3 time Microsoft PASS Summit speaker.

PolyBase is Microsoft’s great new replacement to linked servers. With the current version in SQL Server 2019, one can connect to multiple data sources such as Teradata, Apache, Hadoop, Oracle, and many many more. We will review best practices for setting up PolyBase and its Scale-Out groups as well as showing how it interacts in an Always On Availability Group. When Scaling-Out (up!), PolyBase is able to work harder and deliver more data. What happens when one of its node disappears? We will have a live demo demonstrating how to manage the Scale-Out group when bad things happen. In addition, the DMVs for managing PolyBase will be reviewed, and finally, there will be results of the impact of using multiple nodes in the Scale-Out group on the PolyBase queries! Prerequisites: Basic database administration skills/knowledge of HA concepts About Michael Michael Wall has been an IT professional going back to when he had his own software store and worked with his customers with their “dose” problems. Originally hired by a small consulting firm to write web pages, he was thrust into the SysAdmin world when their lead consultant changed the passwords of all of the servers at a major pulp and paper company’s systems to 100%s$%t and walked out the door. He was sent down with a copy of UNIX for Dummies and 50 cents for the bus ride back. Fast forward a few years, he was asked if he wanted to be a DBA after successfully managing a fifty server Y2K upgrade. Since then, he’s never looked back and has survived a number of data and system challenges.

Why should I care about ... partitioned views by Rick Lowe (@DataFLowe) Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And not necessarily just for standard edition who aren’t on the new service pack yet. If your data is time stamped, do you see different queries run against older data than new data? Do you with you could segment your data across multiple columns? Do you have data you need to partition horizontally? It’s possible partitioned views may still be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away … and possibly even after 2016 SP1. About Rick: Rick is a Microsoft Certified Master with more than 15 years of experience working with SQL Server. He currently works as an independent performance DBA/Developer for clients across the USA and Canada. He started his career as a database developer, but over time became more and more interested in how the database engine operated ... eventually becoming more focused on operational and performance issues than code. Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

Abstract: Many DBAs and Developers work with SQL Server but don’t fully understand how it really works behind the scenes. Join Deepthi on her dive into the internals of SQL Server to explain why knowing what goes on under the covers will help you make better decisions quickly when solving performance problems in SQL Server. This session will cover ACID properties, key components of the Cache in SQL Server, Relational Engine, Storage engine and the Transaction manager. You will learn how SQL Server manages Plan cache and Buffer pool and how SQL Server optimizer choose the plans. We will also cover what happens under the covers during read and write operations within SQL Server. This session also has Demos showing how components of SQL Engine works for queries. Deepthi will show you how the SQL engine thinks – enabling you to think like it! About Deepthi: Deepthi is a Database administrator with 7 years of experience. She completed her Masters in Computer Technology at Eastern Illinois University and she is a Microsoft certified solution expert (MCSE). You can find her blog at dbanuggets.com and follow her on twitter: @dbanuggets

Abstract: Tintri has recently released its much-anticipated “SQL Integrated Storage” as part of its Intelligent Infrastructure product lineup. This session will go over this offering in detailed demos and show this how this Industry-first solution benefits DBAs and infrastructure admins. This will be an interactive session and questions are encouraged. About Rob and Shawn: Rob Girard, Principal Technical Marketing Engineer @ Tintri Shawn Meyers, Field CTO @ Tintri Both Rob & Shawn have presented many times together & separately at various VMworlds, SQL PASS Summits, SQL Saturdays and other industry events. Both have a strong 20+ year Infrastructure & Virtualization background supporting SQL Server and other Enterprise IT.

Abstract: This session will take a look at the new Query Store feature in SQL Server 2016. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse. We will take a hands-on look at how to use Query Store to troubleshoot problems as well as some of the new DMVs you can use to find issues as they arise. And see what is new in SQL Server 2017. About Tracy: Tracy Boggiano is the Database Superhero for ChannelAdvisor. She has spent over 20 years in IT and has used SQL Server since 1999. Tracy covers all aspects of administration and deals heavily with performance tuning and high availability and disaster recovery. Tracy has volunteered through the NC Guardian ad Litem program since 2003 advocating for abused and neglected foster children in court.

Abstract: Do you spend your days slinging T-SQL code? Want to improve your T-SQL game? If you answered yes, then this session is for you. This demo-intensive session will showcase a collection of my favorite beginner and intermediate level tips and tricks. We will explore how to identify and fix some common T-SQL anti-patterns, my favorite SSMS productivity tricks, and clever solutions to some common but not easily-coded challenges. This session targets both developers and DBAs; the only prerequisites are the desire to write better T-SQL code and aim of living an easier life! About Andy: Andy Yun is a SentryOne Senior Solutions Engineer and a Microsoft MVP. He has been working with SQL Server for 15 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQL Saturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQL Saturday Organizing Committee.

Abstract: Lift and shift is an utopia many IT professionals have about moving on-prem resources to the cloud. The truth is we must understand how the cloud works so we adjust, design accordingly and deliver to expectations. As SQL DBAs we have options. We can choose between IaaS or PaaS, between SQL in a VM or SQL DB, NoSQL options, Azure Data Warehouse some more. In this session we will dive into these options and understand some key points on the platform through some demos. You will learn: Basic elements of Azure cloud ecosystem VM disks specifics for SQL 2016/2017 Azure SQL Database and Elastic pools Azure Data Warehouse and Cosmos DB About Armando: Armando Lacerda has over 30 years in the information processing field as a developer and system integrator; 20 years working with SQL Server since version 6; cross platform experience with Oracle and IBM SQL/DS and DB2; Microsoft Certified Trainer for over 20 years. Azure system architect.

Absratct: Containerization is a hot topic these days, and SQL Server’s ability to run inside containers on both Windows and Mac has revolutionized the way developers work with Microsoft’s venerable database engine. This dynamic session starts with a quick introduction to Docker and how it utilizes OS virtualization in Windows 10 and Windows Server 2019 to provide isolation across multiple containers running on your machine. Then you’ll see how fast and easy it is to spin up any number of SQL Server instances to run in both Windows and Linux containers simultaneously. Get bit by the Docker bug, and you’ll never go through the pain of installing SQL Server on your development machine ever again! About Leonard: Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner. Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences. Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.

Abstract: A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators. About Marsha: Marsha Pierce lives in Nashville, TN. She studied Computer Science, Mathematics, and French at Belmont University. She has 23 years of experience as a DBA, which means she has broken and fixed a lot of stuff. Before joining Pure Storage, she was an architect at HCA and Asurion. She is passionate about DevOps, Storage, Performance Tuning, and Standardization.

Abstract: Containers and Kubernetes have become buzzwords in the application development world, but how do these technologies fit with SQL Server? This session will discuss the basics of containers and Kubernetes and explain how we can use containers with databases in SQL Server. We will also briefly look at the future of SQL Server with Kubernetes support. About Steve: Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

Abstract: The Analytics service in Azure DevOps Services provides all-over insights to your DevOps data: work item tracking, CI/CD pipelines, testing process, etc. Built on top of columnstore indexes, the Analytics service has to deal with 100s of millions of records and daily growth in 10s of millions, only a few minutes delay from operation store, sub-second query performance for in-product experiences as well as 3rd party extensions, Power BI integration and ad-hoc queries. Working on it, I've learned a lot of DOs and DON'Ts about columnstore indexes. The session covers how to: * partition columnstore indexes in a multitenant environment * maintain columnstore indexes in case of updates and/or purge to keep segment elimination possible * evolve database schema without downtimes and maintenance windows * design to benefit from predicate and aggregation pushdown * deal with edge case like ad-hoc queries for raw data and paging * choose between CCI and NCCI based on usage patterns About Konstantin: Konstantin is an industry expert who loves optimizing the performance at least in 10x. More data - more fun. Konstantin is a Principal Software Engineer at Azure DevOps Services, where he works on moving the Analytics for software engineering to a completely new level. Konstantin was born and had been working in Ukraine for a long time, passionately sharing his knowledge with Ukrainian and other European data communities. Before joining Microsoft in 2012, he was a Data Platform MVP for many years.