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 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.
blue backup key on grey computer keyboard
PowerShell Lets You Back Up SQL Server Your Way 2
One of the things that makes me really enjoy having PowerShell in my tool belt is the ability to approach a problem from many different angles. Let's take backups, for example.
Modify Columns and Stored Procedures in PowerShell
How many times have you run into a case where your database design is "almost" right?
data written over numbers
Add Columns to Multiple Tables with PowerShell
Here's how to add columns to multiple SQL Server tables with PowerShell to store values showing the last time a row was modified, and who modified it.
Error message with blue background
Set Up Operators and Alerts in PowerShell
One important task that is often neglected by DBAs when setting up SQL Server, is defining operators and alerts. Learn how to set up operators and alerts in PowerShell.
Creating tables in PowerShell with SQL Server Management Objects (SMO)
Create Database Tables in PowerShell with SMO 3
Here's a step-by-step guide for creating tables in PowerShell with SQL Server Management Objects (SMO).
computer keyboard with red email key
Script Your Database Mail Setup
Here's a PowerShell script I use to set up SQL Server's Database Mail feature to email notification to me when critical alerts fire or when jobs fail.
SQL Server checklist
Use PowerShell to Create Agent Jobs 3
Learn how to use PowerShell to create Agent Jobs and have an easy way to make sure you're always capturing performance data automatically on any server you set up.
man sitting in fron to three computer monitors
Review Database File Properties with PowerShell
One of the things a database administrator needs to keep track of is the usage of the file systems where the database files are kept.
Yellow computer key labeled customize
Set Database Option Properties with PowerShell
SQL Server databases have a lot of options you can change so that you can properly manage your databases. Check out these useful scripts and tips.
Windows PowerShell script with dark blue backgroud
Gather SQL Server Instance Information with PowerShell
Getting started managing SQL Server with PowerShell isn't hard, but it does require some fundamentals. Here are some PowerShell basics to get you started!

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
Young man working at a computer
Oct 30, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 12: Issues with Enabling and Disabling Batch Jobs

An in-depth look at some of the concerns involved with enabling/disabling entire SQL Server jobs based upon whether they should be run, or not—and then look at options for addressing those concerns....More
Fort in the road
Oct 22, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 11: A Fork in the Road

A quick overview of the pros and cons of dynamic detection at job execution time or the option of dynamically enabling/disabling jobs....More
business people around a table and laptop
Oct 9, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 10: Dynamic Detection Gotcha #3

You can interject a SQL Server Job Step into your Jobs and have this new/injected Job Step do some checking for you. Here's a look at everything that’s involved in such an approach....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) ×