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 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 upsearch.com. Follow Allen on Twitter: @SQLRunr

Articles
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
May 12, 2016
blog

The 7 C's of Data Quality

Data quality is really important. Why? Because it helps you save money while increasing profits because of accurate contact data. It’s important to understand what data quality is and why it is important....More
Apr 21, 2016
blog

Turning Global Addresses into your Biggest Asset

Sponsored Blog Are you dealing with national and international records? The more expansive your records are in territory, the more problems you will face when it comes to verifying addresses. Not only are you dealing with language differences, but you are also dealing with different address formatting for different countries....More
Mar 14, 2016
blog

Building Your Business with Quality Data

Your contact data is valuable, but is it up to its full potential? Without the proper maintenance, the quality of your data quickly decreases--so quickly that 50% of databases deteriorate after only two years. It is an absolute necessity to maintain your data in order to decrease costs and increase profits....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) ×