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!

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Two women looking a man's computer monitor
Sep 17, 2014
Article

AlwaysOn Availability Groups and SQL Server Jobs, Part 6: High-Level Options and Rationale for Handling Batch Jobs

There are a couple of options for how we could handle batch jobs when Availability Groups are thrown into the mix....More
Sep 12, 2014
Sponsored

Managing a Healthy SQL Server Database: Three Principles We Overlook

In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More
Exclamation marke on yellow road sign
Sep 9, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 5: Setting Up Failover Alerts

Alerts represent a great way to take a proactive stance on being notified or alerted when something ugly, potentially ugly, or important happens on a SQL Server. On most servers that I manage, I typically deploy a whole bevy of different alerts....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) ×