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 is the past 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 Follow Allen on Twitter: @SQLRunr

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 1
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.
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
Nov 3, 2015

Climb the Steps Toward Data Quality Success

Melissa Data's Data Quality Analyst Joseph Vertido explains how Gartner defines the critical data quality steps to prevent bad data from entering your systems in the first place, and then keep it clean over time....More
Sep 29, 2015

Data Breaches and Insider Threats

I’ll sound a bit like Captain Obvious for bringing this up, but it’s important to remember that security encompasses a lot more than protecting sensitive data from the specter of outsider threats like hackers. Properly implemented security policies also account for threat-models that include insiders – or people within your organization....More
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups 1

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....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) ×