Streamed

April 1-3, 2020

Three days of online events

Redgate has a long history of working closely with the community. From our publishing sites, Simple Talk and SQL Server Central, through to our speaker sessions at industry events and webinar program, we value sharing resources with the community. Over the coming weeks, we want to make sure that our community continues to be supported by Redgate, and that our customers have access to free, useful content.

From April 1 – 3 we’ll be running Redgate Streamed, a virtual conference bringing together world-class industry speakers, educational content, and opportunities to network with your peers. As we won't be attending SQL Bits this March, we're donating the budget we would have spent to help the World Health Organization's COVID-19 response fund. We'll donate an additional $1 on behalf of everyone who registers, as well. So even if you can’t join us live, be sure to register, and you’ll receive the recordings to watch afterwards.

We hope that Redgate Streamed will provide the opportunity for us to come together, learn from each other, and feel connected during this period.

Register now

Wednesday 1st AprilSee the agendaRegister now
Thursday 2nd AprilSee the agendaRegister now
Friday 3rd AprilSee the agendaRegister now

Visit Redgate’s Virtual Booth

Join post-session discussions, book a meeting with a Redgate Advocate, see a live demo, or enter our competition.

Go to the Virtual Booth

Wednesday

1 April

Time (BST / CDT)Session
2PM / 8AMUse Git for database code: From cheat sheets to Pull Requests
Kendra Little, Microsoft Data Platform MVP and DevOps Advocate

You're a developer or DBA who wants to get your database code into version control, but you're not sure how to work with it. How do you work with database code in Git? What are branches, and should you use them with database code? Join this session for key tips on how to choose the right strategy to author and control the flow of database changes for your team. We will discuss multiple popular branching models along with “fit notes” describing the strengths and weaknesses of each model. You’ll also get a cheat sheet to help you learn core commands in Git.

Show abstract

3PM / 9AMDatabase DevOps with Containers
Rob Richardson, Microsoft Cloud and Datacenter Management MVP and Software Craftsman

Unlike CI/CD pipelines for applications, we can’t just delete the database and pop up a new one with each new version. Let’s start with the production database, and get SQL Server content to developers in containers, and then flow schema and lookup data back into production with migration tools. You can bring the reliability and automation of CI/CD pipelines to Database DevOps with containers.

Show abstract

4PM / 10AMBlogging and writing for the Tech Professional
Kathi Kellenberger, Microsoft Data Platform MVP and Simple Talk Editor

Have you considered writing a blog, article or even a book but didn’t know how to get started? Have you wondered if writing is worth the time and effort? Being a technical writer can help you build your brand and get noticed. It might lead to that next job opportunity or help you get consulting clients. Not only that, people from around the world can learn from what you write – you will be making a difference!

Show abstract

5PM / 11AMLearn to effectively use Extended Events
Grant Fritchey, Microsoft Data Platform MVP and PASS Immediate Past President

Too many people have looked at Extended Events, seen what looks like a horrible interface, heard about the XML, and subsequently run away. This session is here to show you how to effectively use Extended Events to monitor your query performance, and more, in an efficient and useful way. The interface for Extended Events isn't bad, just grossly misunderstood. After you attend this session, you'll be able to easily do things that you've never been able to do with Trace or Profiler. You need a more efficient query metrics tool, and it's waiting for you in Extended Events.

Show abstract

6PM / 12PMPanel: How database DevOps levels up remote work
Kendra Little, Microsoft Data Platform MVP and DevOps Advocate
Grant Fritchey, Microsoft Data Platform MVP and PASS Immediate Past President
Steve Jones, Microsoft Data Platform MVP and SQLServerCentral Editor

Globally, organizations are reacting quickly to the spread of COVID-19: suddenly more teams than ever are working from home, meetings are going online as travel is cancelled, and people are needing to learn to work together in new ways. Join our panel to get tips on key steps to take with your database environments, tips on working from home, and thoughts on how you can best empower your teammates and customers to work well in this tricky time.

Show abstract

Thursday

2 April

Time (BST / CDT)Session
2PM / 8AMProtect your data by design: Creating a data masking strategy
Chris Unwin, Data Privacy and Protection Specialist

Data Breaches are seemingly never ending in today's world with new ones coming to light every single day. To try and mitigate the fallout of a data breach we can implement a data masking strategy throughout our environments, so why haven't we already? In this session, you'll learn the traditional blockers to, and issues with masking data, how to overcome these, and how you can build your own masking plan to ensure the security of your data in pre-production.

Show abstract

3PM / 9AMShortcuts from an impatient DBA
Andy Mallon, Microsoft Data Platform MVP and Founder of BostonSQL

This session is about performance tuning your day. We spend a lot of time thinking about how to write efficient code, but we don't spend a lot of time thinking about how to be efficient with how we use our tools. In this session I will show you some lesser known keyboard shortcuts, tips, tricks, and hacks that will make your day easier. These are the tricks I've picked up over the years that help me get my work done quicker and easier. Even the most seasoned Database Professionals will learn a new trick that makes SSMS even easier to use.

Show abstract

4PM / 10AMThe basics of unit tests with tsqlt
Steve Jones, Microsoft Data Platform MVP and SQLServerCentral Editor

Unit testing has become commonplace for most application developers and the rule, rather than the exception, in a DevOps software development pipeline. Unit testing has been harder for database developers, but we do have a few options. Redgate supports the tsqlt project, which provides a unit testing framework for T-SQL code. In this session, Steve Jones will cover the basics of how to write, execute, and maintain unit tests for your database project.

Show abstract

5PM / 11AMSQL Injection: How it works, how to stop it
Grant Fritchey, Microsoft Data Platform MVP and PASS Immediate Past President

This session will explain and demonstrate exactly how a SQL Injection attack occurs. While the core vulnerability is easy to understand, exactly how hackers exploit that vulnerability is not. I'll show you how a hacker explores your database through SQL Injection to find vulnerabilities and sensitive data. Better still, I'll show you the errors that this exploration generates as a mechanism for monitoring your systems to find SQL Injection attacks. Finally, I'll show you the steps you should be taking to properly secure your systems in order to completely avoid SQL Injection attacks.

Show abstract

6PM / 12PMPanel: How to learn automation in Azure DevOps
Cathrine Wilhelmsen, Microsoft Data Platform MVP & Azure Data Engineer Associate
Grant Fritchey, Microsoft DatA Platform MVP and PASS Immediate Past President
Kendra Little, Microsoft Data Platform MVP and DevOps Advocate

Change is happening rapidly: new cloud services appear every day. Websites containing documentation you’ve used for years are reorganized, and all the links you once relied on no longer work. Certifications and their training plans appear and disappear before you turn around. You’re ready to learn automation, but where do you begin? Join our panel to hear their experiences learning automation using the Microsoft Data Platform. They’ll share lessons they learned, tips to succeed, and answer your questions on how to begin and level up your knowledge of Azure DevOps

Show abstract

Friday

3 April

Time (BST / CDT)Session
2PM / 8AMSQL Notebooks in Azure Data Studio for the DBA
Rob Sewell, Microsoft Cloud and Data Center Management MVP and Powershell evangelist

An Azure Data Studio recent release introduced SQL Notebooks as a capability. While you might have read about notebooks being used for Data Science, this session is for DBAs. You will see how you can use SQL Notebooks to simplify your work. You will learn about SQL Notebooks from installing them in Azure Data Studio to creating a Notebook for Glenn Berry's Diagnostic queries as well as numerous use cases for you to use in your daily workload.

Show abstract

3PM / 9AMConvince the DBA to support DevOps
Grant Fritchey, Microsoft DatA Platform MVP and PASS Immediate Past President

As a developer, you know that using DevOps methodologies successfully can lead to massive improvements in your ability to quickly and safely deliver more and better functionality to your business. However, you have an old-school DBA who refuses to get on board with automation and a shift-left mentality. This session is specifically designed to give you the tools and the language you need to talk to your DBA in a language they'll understand. You'll be able to convince them that not only is implementing DevOps good for the organization, it will lead to a safer database environment. Get your DBA into the modern age using the knowledge from this session.

Show abstract

4PM / 10AMAn introduction to Intelligent Query Processing
Kathi Kellenberger, Microsoft Data Platform MVP and Simple Talk Editor

Over the past 10 years or so, each version of SQL Server has arrived with exciting new features like Columnstore, in-memory tables, and Availability Groups. You may not know, however, that Microsoft has invested heavily in the optimizer as well. Starting in 2017, Microsoft created a new group of features called Intelligent Query Processing. These features just make many queries run faster – without code changes.

Show abstract

5PM / 11AMIndex tuning in an agile world
Kendra Little, Microsoft Data Platform MVP and DevOps Advocate

Software developers increasingly work across databases and applications, and there are fewer and fewer dedicated database developers each year. This produces a new opportunity for database administrators and developers who are interested in performance: the role of the incremental index tuner. In this session you will learn a framework for developing and tuning indexes in SQL Server, and how to apply this framework in an Agile development context.

Show abstract

6PM / 12PMPanel: The future of Database Administration and Development
Kendra Little, Microsoft Data Platform MVP and DevOps Advocate
Grant Fritchey, Microsoft Data Platform MVP and PASS Immediate Past President
Steve Jones, Microsoft Data Platform MVP and SQLServerCentral Editor

Will database administrators exist in 5 years? In 10 years? Who will write code for databases, and how will it be deployed? While relational databases and the processes around them have evolved slowly over the past 20 years, we see the rate of change increasing regarding the processes, tools, and the roles of the people who work with databases. Join this panel session to hear what Redgate’s Advocates have learned from research, discussions with customers, and collaboration with experts and leading vendors in the marketplace. Bring your questions, comments and predictions!

Show abstract

Here's just a few of the experts you'll join

Kendra Little

Data Platform MVP, DevOps Advocate at Redgate, littlekendra.com

Kendra is a Microsoft Certified Master and a Microsoft MVP. She has taught developers and DBAs around the world to write fast, reliable code for SQL Server.

Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to manage and deploy changes to performance critical databases at Microsoft Corporation, working with systems from internal source control databases to customer-facing very large databases (VLDBs). Since then, Kendra has worked internationally as a trainer and consultant, specializing in performance tuning and practical code patterns for SQL Server. She joined Redgate as an Advocate in 2018.

@Kendra_Little

Steve Jones

Data Platform MVP, Editor at sqlservercentral.com

Steve 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.

@way0utwest

Grant Fritchey

Data Platform MVP, Advocate at Redgate, scarydba.com

Grant Fritchey is a Data Platform MVP with over 30 years' experience in IT, including time spent in support and development.

He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. Grant volunteers for PASS and is on the Board of Directors as the Immediate Past President. He joined Redgate Software as a product advocate January 2011.

@GFritchey

Kathi Kellenberger

Data Platform MVP, Editor at Simple Talk

Kathi Kellenberger is the Editor of Simple Talk and a Microsoft Data Platform MVP. She has worked with SQL Server for almost 20 years and has authored, co-authored, or tech edited over a dozen technical books.

Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings.

@auntkathi

Rob Richardson

Software Craftsman and Microsoft MVP

Rob is a software craftsman building web properties in ASP.NET and Node, Angular and React. He’s a Microsoft Visual Studio MVP, published author, frequent speaker at conferences, user groups, and community events, and a diligent teacher and student of high quality software development. You can find this and other talks on his blog at https://robrich.org/presentations.

@rob_rich

Chris Unwin

Data Privacy and Protection Specialist at Redgate

Chris is the Data Privacy and Protection Solution Specialist at Redgate. He started his career in SQL Server development and ERP configuration and joined Redgate in 2016. Chris works with a variety of companies, helping many of our global customers solve a variety of challenges; from rolling changes forward efficiently, to providing the best possible data-compliant, pre-production environments.

Andy Mallon

Microsoft Data Platform MVP and Founder of BostonSQL

Andy is a SQL Server DBA and Microsoft Data Platform MVP who has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. Since 2003, he's been supporting high-volume, highly-available OLTP environments with demanding performance needs. Andy is the founder of BostonSQL, past organizer of SQL Saturday Boston, and speaker at many SQL Server user groups & SQL Saturdays.

Cathrine Wilhelmsen

Microsoft Data Platform MVP & Azure Data Engineer Associate

Cathrine loves teaching and sharing knowledge. She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Warehousing, Data Integration, Analytics, and Reporting projects. Her core skills are Azure Data Factory, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she’s active in the SQL Server community as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.

Rob Sewell

Microsoft Cloud and Data Center Management MVP and Powershell evangelist

Rob is a database automation expert and DBA with a passion for helping his peers increase their data’s performance through automation. Every day he watches first-hand the power of modern database and application technologies transform organizations, and he gets lit up by helping others experience the same. For over 10 years he's been working in complex environments on diverse teams. As a Data Platform Microsoft MVP, he spends his time sharing performance knowledge at global Data Platform events. He also trains teams on modern database platform technologies. He believes that database teams can use modern workplace technologies like PowerShell and Azure DevOps to scale and manage their critical systems, leaving time in the day to actually work on projects that move the business forward.

Redgate