Allen White

Allen
White
Practice Leader

Allen White is a Microsoft SQL Server MVP and Practice Leader at UpSearch. Allen has been working with relational database systems for over 20 years. He has architected database solutions in application areas like retail point-of-sale (POS), POS audit, loss prevention, logistics, school district information management, purchasing and asset inventory and runtime analytics. He currently serves the SQL Server community as President of the Ohio North SQL Server User Group, the Cleveland, OH based chapter of the Professional Association for SQL Server (PASS).  Contact Allen at upsearch.com. Follow Allen on Twitter: @SQLRunr

Articles
Man and woman working on laptops
Set Up Multiple Azure VM Servers with PowerShell
Learn how to set up multiple Microsoft Azure virtual machine (VM) Servers with PowerShell.
PowerShell list of SQL Servers available
Create a New Azure VM with PowerShell
Using PowerShell, you have a repeatable process to provision and access your SQL Server Azure VM environment, making the process consistent and much more easily manageable.
Using PowerShell to Get Started in Microsoft Azure
Microsoft Azure provides a whole new way to manage your data. Rather than having to buy expensive hardware and install SQL Server, you can spin up a new Microsoft Azure VM in a matter of minutes.
Red key labeled Backup on keyboard
Get Database Backup Details with PowerShell
PowerShell, with a little help from SQL Server Management Objects (SMO), gives you a more versatile way to grab database backup details.
Extract Report RDL with PowerShell 4
While SQL Server Reporting Services provides an easy way to upload an RDL file into Reporting Services, it doesn't provide an easy way to extract the RDL file. Fortunately, you can use the ReportService2010 web service to do this.
Gloved hand using yellow sponge to clean a surface.
Clean Up SQL Server Logins and Users with PowerShell
Here is a set of PowerShell code that can help you clean up orphaned logins and users in your SQL Servers.
PowerShell -ScriptBlock argument.
Use PowerShell Remoting to Manage SQL Servers Efficiently
PowerShell 2.0 introduced a different way to manage your servers, called remoting—it gives you a lightweight way to manage all of your servers, and manage them all at the same time.
Data written on keyboard
Use PowerShell to Load XML Data into SQL Server 2
PowerShell is a more efficient method for loading large data sets into SQL Server from XML than T-SQL. Learn how.
Woman working at her computer and talking on cell phone
Passing Command-Line Arguments to PowerShell
You can write easy scripts in PowerShell to get things done quickly, but as you get comfortable and want your scripts to be usable by your entire team, take advantage of the features of PowerShell command-line arguments to help those who use your scripts.
Red Error key on keyboard
Handling Errors in PowerShell
PowerShell provides ways to manage times when there are errors in the execution of our script so we can recover, and still get the job done.
computer keyboard red key labeled HELP
Add Help to your PowerShell Scripts
One of the greatest tools to assist with learning PowerShell is the help system, and specifically the Get-Help cmdlet. This cmdlet is one of the three key cmdlets in learning PowerShell, the other two being Get-Command and Get-Member.
SQL Server health check
Run Your SQL Server DBCCs and Check Your Errorlog with PowerShell
I've got PowerShell scripts for almost all my basic SQL Server management tasks, and DBCC CheckDB is no exception. Learn a quick way to get the recent contents of the error log that are relevant, so you can act on problems quickly.
Man looking at computer monitor
Getting SQL Server Performance Data with PowerShell
Learn two simple methods for getting SQL Server performance data with PowerShell.
Woman working on computer
Create Alert-Based Log Backups with PowerShell
It's important to have a backup strategy, and it's also important to have a plan to handle when that strategy just isn't enough.
copy computer keyboar key with data in background
Bulk Copy Data into SQL Server with PowerShell 3
The fastest way to get data into SQL Server is to use bulk copy methods, whether you use the old bcp utility or use the same capability in other ways.
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Fork in walking path
Aug 28, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 2: Putting AlwaysOn into Context

Despite similar intentions and high-level goals, the ways in which AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups tackle high availability and disaster recovery are quite different....More
start here sign
Aug 26, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 1: Introduction

While AlwaysOn Availability Groups are a powerful solution that let DBAs tackle both high availability and some disaster recovery concerns from within a single, unified, set of technologies and tooling, AlwaysOn Availability Groups also come with a number of challenges....More
Man deciding which door to choose
Aug 15, 2014
Sponsored

Choosing the Right Health Check

For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×