Advanced insides into System Versioned Temporal Tables – Uwe Ricken

SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.

This session takes you behind the basics of Temporal Tables and answers – after a short introduction – the following questions:

– How to handle the change of NULL constraints?
– Can Temporal Tables be renamed and what happens to the System Versioned table?
– What will happen if you change meta data (data length, data type, …)?
– What happens if you drop a column or add another column to the Temporal Table?
– What about security for the system versioned table?
– What about calculated columns in the temporal table?

You are interested in the answers to all the above questions (and more). This session will answer most of your questions about Temporal Tables.

Uwe Ricken

Uwe Ricken is working with IT systems since the early ’90s. The start of experiences with Microsoft SQL Server came with the assignment for development of a membership administration software for the American Chamber of Commerce in Germany. The software has been distributed to five additional European countries.

The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a Senior DBA and Database Architect for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models, he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. The year 2013 finished with the first MVP award for his support to the Microsoft SQL Server community in Germany and Europe.

To provide his deep knowledge about Microsoft SQL Server to the interested Uwe Ricken is blogging since 2010 on about his daily experiences with Microsoft SQL Server. His blog posts are in German language only to provide the German-speaking SQL community inside views into the technology of Microsoft SQL Server.

Uwe Ricken is a speaker on many international conferences and events and preferred topics are Database Internals, Indexing, Architecture, and Development.

Storing and Searching Files in SQL Server Filetables – Sam Nasr

FileTables is a SQL Server feature that allows easy storage and access to documents dynamically.

After some initial setup, users can simply drag files into a folder and then be able to access their meta-data and contents through SQL Server, seamlessly. Due to the way FileTable uses the FileStream feature, it stores files on the file system but maintains the metadata in the database. This allows full control over the file while not bloating the database.

Sam Nasr

Sam Nasr has been a software developer since 1995, focusing mostly on Microsoft technologies. Having achieved multiple certifications from Microsoft (MCSA, MCAD, MCTS, and MCT), Sam develops, teaches, and tours the country to present various topics in .Net. He’s involved with the Cleveland C#/VB.Net User Group, where he has been the group leader since 2003. In addition, he’s the leader of the .Net Study Group, an author for Visual Studio Magazine, and a Microsoft MVP since 2013. When not coding, Sam loves spending time with his family and friends or volunteering at his local church.

Python for SQL Server dba & Developers – Jean Joseph

Nowadays, SQL Server Database Administrators and Developers need more expertise than SQL or PowerShell

You will learn the fundamentals of Python and how to leverage Python to retrieve and manipulate data from SQL Server. How Python can be used as an ETL and administration tool.

Jean Joseph – Data Engineer
Highly experienced in Big Data and traditional data technologies with a history of success in designing, implementing complex technical projects for diverse businesses in various stages of their development. Acknowledged as a leader capable of mentoring teams of different backgrounds and talents and inspiring individual efforts to deliver. Organized and detail-oriented, with a positive pro-active, and hardworking attitude. Performance history reflects a highly analytical strategic thinker with strengths in defining solutions and executing programs that have been invaluable to an all-encompassing range of projects and positions.

Introduction to Azure Synapse Serverless Pool – Warner Chaves

What started as Azure SQL Data Warehouse, has now evolved into Synapse Analytics, an all-encompassing analytics development service full of new features.

A key component of these new capabilities is the SQL Serverless Pool. This new db engine allows for querying and exploration of file based data through the familiar T-SQL syntax that we know. It also has a different cost model and internals.

In this demo-heavy session we will go over the main concepts behind Serverless Pools as well as demos to showcase the major features like EXTERNAL TABLES and the extended OPENROWSET function.

Query Store on-Prem and in the Cloud – Deepthi Goguri

Are you facing performance issues due to parameter-sensitive queries? Are many plans being generated for your queries and you cannot control choosing the plan best for your query? Come learn in this session how we can capture the different plans generated for those queries and decide which plan you can force for better performance using the Query Store feature.

Query Store feature introduced in SQL Server 2016 and has advanced its features introducing Wait stats per Query plan and Automatic Plan correction feature in SQL Server 2017 and Azure SQL database which will force the plans and resolve the issues automatically for you. Sound’s amazing, right?

Join Deepthi to know all about the Query Store feature and its advancements in detail so you can implement them to take advantage of this awesome feature!

Deepthi is a SQL Server Database Administrator with several years of experience in Administering SQL Servers. She is a Microsoft certified trainer and Microsoft certified professional with an Associate and Expert level Certification in Data Management and Analytics. Deepthi blogs for Deepthi is a Co-Organizer for Microsoft Data and AI South Florida user group and Data Platform Diversity, Equity, and Inclusion Virtual Group. She is a Volunteer for Data platform Women in Technology user group. She is a Friend of Redgate. Along with this, Deepthi loves arts and crafts. You can contact her on Twitter @dbanuggets.

Introducing SQL Server 2022 – Bob Ward

SQL Server 2022 is here! In this session, I’ll go over all the new capabilities in SQL Server 2022 including how to connect with Azure for disaster recovery, near real-time analytics, and security. I will show you innovations in the database engine for security, performance, and availability.

You will learn about enhancements to Query Store and the next generation of Intelligent Query Processing allowing you to gain performance with no code changes. You will love the demo for this one!

I’ll also show you new extensions for the T-SQL language including data virtualization object storage, JSON functions, and time series. This is the session you won’t want to miss to learn about SQL Server 2022.

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 27+ years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2019 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 Red Hat Summit, SQLBits, SQLIntersection, Microsoft Inspire, Microsoft Ignite, and many different virtual events. You can also learn Azure SQL from him on the popular series You can follow him at @bobwardms or Bob is the author of the books Pro SQL Server on Linux, SQL Server 2019 Revealed, and Azure SQL Revealed available from Apress Media.

Azure SQL Server & DevOps – Alpa Buddhabhatti

In this session, I will show how to create CICD pipelines for Azure SQL Server. Also will show a demo to deploy Azure SQL Server in different environments. This demo will also use the following technologies:
* Azure Key Vault
* Azure SQL Server

The main goal of this session is to provide basic knowledge of Azure DevOps so attendees will leave with Azure DevOps knowledge on how to apply this in different scenarios.

Speaker: Alpa
Alpa is an Azure Consultant with a passion for data and technology at Cluster Reply UK. She is Microsoft Certified Trainer and certified in Azure Data engineer and Azure Data Science. She is working on Azure services such as Logic Apps, Azure Functions, Azure Key Vault, Azure, Azure Data Factory, Azure Storage, and Azure Data Lake.

Infrastructure DBA In the Cloud – Kellyn Pot’Vin-Gorman

With migrations to the cloud at an all time high, knowing that 80% of existing RDBMS workloads migrate to the cloud as Infrastructure as a Service, (IaaS) is important. This session will go over everything you need to know about IaaS in Azure, around recommended practice and cloud infrastructure, taught by someone who has no other option- The SME for Oracle on Azure IaaS. This session is valuable to both Microsoft specialists and multi-platform technologists, covering infrastructure database administration.

Kellyn Pot’Vin-Gorman is a member of the Oak Table Network, an Idera ACE and Oracle ACE Director alumnus. In recent years she’s leveraged her vast database and DevOps skills as the SME for Oracle on Azure at Microsoft in the Customer Success Architecture and Engineering Team. Kellyn is known for her extensive work with multi-database platforms, cloud migrations, DevOps, environment optimization tuning, automation, and architecture design. Her blog, and social media activity under her handle, DBAKevlar is well respected for her insight and content.

The Encryption Primer – Steve Jones

SQL Server has a number of encryption features that allow you to better secure your data. This session will examine the basics of encryption and cover the various ways in which you can encode and decode your data to protect it from unauthorized access. Cell level encryption, Transparent Data Encryption, and backup encryption will all be discussed. This session is designed for those who want to learn the basics of how to protect their data.

Speaker: Steve Jones
Steve Jones has been working with databases and computers for over two decades. He has worked with SQL Server since 1991, from v4.2 through SQL Server 2016. He has been a DBA, developer, and manager in a variety of large and small companies across multiple industries. In 2001 Steve founded SQLServerCentral with two partners and has been publishing technical articles and facilitating discussions among SQL Server professionals ever since. He currently is the full time editor of SQLServerCentral, as well as an evangelist for Redgate Software. Steve is a 10 year Microsoft Data Platform MVP and lives on a horse ranch in Colorado.

Azure SQL: Year in review with Bob Ward and Anna Hoffman

In this session, join Bob Ward and Anna Hoffman for a special “What’s new in Azure SQL” session. You’ll receive the year in review updates containing all things SQL Server and Azure SQL in 2021. This not-to-miss session will include demos and a sneak peak at the future! You’ll also be able to get your questions answered related to anything that has come out in the past year.