Allen is a Data Platform Consultant. He's been both a developer and an administrator so understands both perspectives towards database technology, and loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last twelve years, and is in his third year as a PASS Director.
Allen White has submitted 4 sessions for SQLBits 2019, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

SQL Server provides a wealth of tools in the box to help you spot troublesome queries. We'll explore those and examine how they can best be used.
This session will cover the kinds of disaster recovery problems that can occur in your data center, and how you can prepare to be ready for them.
Baselines guide you to the problems when performance issues arise, and you can use PowerShell to capture your baseline. This session will teach you what's important in a baseline and how to capture it.
Using SQL Server Service Broker you can create near real-time data in your data warehouse for more timely analysis and reporting.

Sessions

Previous Sessions

It's important to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. This session will show you how to use PowerShell to gather your baseline and how to report it.
Service Broker was introduced in SQL Server 2005 to provide asyncronous messaging in your database applications. In this session we'll walk you through the basics of Service Broker and show how you can use it to build highly scalable applications.
This session will demonstrate scripts to gather server inventory data and SQL Server and operating system performance data with PowerShell and provide reports to stay on top of your servers.
ETL Development takes time. Allen will show how PowerShell and BIML combine to make the development process seamless, consistent and reduces costly development time dramatically.
Using SQL Server Service Broker you can create near real-time data in your data warehouse for more timely analysis and reporting.