Allen is a Practice Leader for Upsearch in Northeast Ohio. 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 eight years. He's also the President of the Ohio North SQL Server User's Group and his site is at http://www.upsearch.com/sql.
Allen White has submitted 3 sessions for SQLBits XIV, although the agenda hasn't been chosen yet. See all submitted sessions
Using SQL Server Service Broker you can create near real-time data in your data warehouse for more timely analysis and reporting.
Using PowerShell you can manage both your on-premises SQL Servers and your Azure environment effectively.
PowerShell allows you to automate the process of gathering baseline performance data so you know what to look at when something goes wrong. This session covers how to gather those metrics with PowerShell, and reports to view the results.
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.