Precons

Pre-Cons will be held on Friday May 5th.

PreCon: SQL Server 2022 Workshop - Bob Ward

Click Here To Register - https://bit.ly/3GOnMt6

Session Details:

Immerse yourself in this day-long workshop on SQL Server 2022 including presentations, hands-on exercises, and interactive Q&A taught by the Microsoft engineering team. You will learn all aspects of what is new in SQL Server 2022 including features for hybrid, built-in query intelligence, industry-proven engine, data virtualization and object storage, and new T-SQL capabilities. Attendees will need to bring their own laptop running Windows and will be provided instructions on software to be pre-installed including SQL Server 2022 Evaluation Edition and tools like SQL Server Management Studio. All attendees are expected to have a fundamental working knowledge of SQL Server including the T-SQL language, engine fundamentals, and use of tools like SQL Server Management Studio (SSMS). If you are looking to dive deep into “everything” SQL Server 2022 this workshop is for you.

Speaker:

Bob Ward is a Principal Architect for the Microsoft Azure Data team, which owns the development for all SQL Server versions. Bob has worked for Microsoft for 29 years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2022 including Azure SQL. Bob is a well-known speaker on SQL Server and Azure SQL, often presenting talks on new releases, internals, and specialized topics at events such as SQLBits, Azure Data Conference, Microsoft Build, Microsoft Inspire, Microsoft Ignite, PASS Summit, and many different events. You can also learn Azure SQL from him on the popular series https://aka.ms/azuresql4beginners. You can follow him at @bobwardms or linkedin.com/in/bobwardms. Bob is the author of the books Pro SQL Server on Linux, SQL Server 2019 Revealed, and Azure SQL Revealed available from Apress Media.

Pre-Con Special Notes:

You will also be required to buy a pay-by-plate daily parking permit ($5) on the day of the event. You may do this online or at one of the kiosks located in the garage. Kiosk map and pay by plate instructions: https://bit.ly/3IASwg6 - for a map: https://bit.ly/3qsPMLE

PreCon: Analytics with Azure Synapse & Power BI - Ginger Grant

Register Here - https://bit.ly/3HtzriV

Session Details:

In this all-day session we will be doing a deep dive into using Azure Synapse Analytics to create an analytics solution using the different components of Azure Synapse and visualize data with Power BI. Whether you choose to call it a Modern data warehouse or lakehouse or a datamart , the process to create it is the same, you need to gather the data from different data sources, analyze, transform, and develop a data model to provide user insight with the data by generating visuals on the data in Power BI.

The process involved sounds simple, but it involves a lot of different technology to create a robust scalable solution. This precon describes the components used to create a data lakehouse, perform serverless data analysis on flat files, develop code first data transformation pipelines, incorporate spark development, and implementing administration and security needed for a Power BI model with a Azure Synapse created backend.

By the end of the precon you will have the skills and code needed to implement this solution in your environment.

Agenda

• Introduction
• Developing a data lakehouse
• Analyzing the data
• Transformation layer
• Spark development
• Administration and security
• Data Analytics with Power BI

Speaker:

Ginger Grant is a Data Platform MVP who provides consulting services in advanced analytic solutions, including machine learning, data warehousing, and Power BI. She is an author of articles, books, and at DesertIsleSQL.com and uses her MCT to provide data platform training in topics such as Azure Synapse Analytics, Python and Azure Machine Learning.

Pre-Con Special Notes:

You will also be required to buy a pay-by-plate daily parking permit ($5) on the day of the event. You may do this online or at one of the kiosks located in the garage. Kiosk map and pay by plate instructions: https://bit.ly/3IASwg6 - for a map: https://bit.ly/3qsPMLE

PreCon: DBA 101: A Full Day of Fundamentals - Bradley Ball, Neeraj Jhaveri & Daniel Taylor

Click Here To Register - http://bit.ly/3iZ2eSM

Session Details:

Starting out as a DBA is rough. Nobody takes the time to show you the ropes. Everybody wants ‘advanced’ this, ‘Internals’ that, or Deep Dive level 1000! All that advanced stuff is great, but you need to build a foundation. Join us as we cover SQL Server step by step. During this pre-conference session we will review installing SQL Server or deploying it in Azure (all the different flavors), post configuration, setting up maintenance plans on-prem or what the equivalate is in Azure, reviewing essential concepts surrounding backups / HA / DR, and basic SQL Server and Identity Security.

Speakers:

Bradley Ball is a Sr. FastTrack Azure Engineer on the Microsoft CXP Product Group. He is a current Microsoft MVP Reconnect member and former MVP. Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office of the President of the United States, was the Data Platform Practice Manager for Pragmatic Works Consulting, and a Sr. Consultant for Microsoft Premier Support for Developers. He has presented at many SQL Saturdays, for PASS SSUG’s across the US from California to Puerto Rico to New Hampshire, SQL Rally, DevConnections, SQLBits 2015, TechReady 24, SQL Live 360 2011-2019, SQL Intersections 2019 - 2021, & the PASS Summit 2011-2015. He wrote Chapter 14 Page & Row Compression for PRO SQL Server 2012 Best Practices and he can be found blogging on http://www.sqlballs.com about anything else that interests him.

Neeraj Jhaveri is a Sr. Azure Fasttrack Engineer with expertise in providing Data, Analytics and AI solutions. Neeraj has MS in Computer Science from NYIT. He has about 20 years of experience in the IT industry as an Architect/Team Leader which includes experience in Data warehousing, Business Intelligence & analytics areas. IT Leader managing and delivering Big Data & Business Intelligence solutions while promoting analytics driven culture. He has worked closely with Client Managers, Solution Architects, Leads, Users and Development teams in successfully translating business requirements into specifications, planning and deliverable. Neeraj is one of the founding host of Tales from the Field youtube channel.

Daniel Taylor is a Microsoft Sr. Service Engineer, FastTrack for Azure and on the Azure Engineering CXP Team - I have presented a pre-con on Azure Dedicated Pools at SQL Saturday Jacksonville and was a speaker at many SQL Saturday events. My consulting role at Pragmatic Works provided me an opportunity to present the Airlift Dedicated Pool workshop to a large audience. Outside of public speaking engagements, my role within Microsoft has provided me with the opportunity to speak with large groups about the benefits of migrating to Azure, as well as, the capabilities of SQL Server on-premises and in the cloud. My passion these days is helping folks modernize within Azure utilizing one of our many PaaS solutions, as well as, the out of the box SQL Server product.

Pre-Con Special Notes:

You will also be required to buy a pay-by-plate daily parking permit ($5) on the day of the event. You may do this online or at one of the kiosks located in the garage. Kiosk map and pay by plate instructions: https://bit.ly/3IASwg6 - for a map: https://bit.ly/3qsPMLE

We will have a room set up for you to ask our SQL Experts for assistance with any current challenges you might be having. Look for this image posted at the door:

Return to the top of the page