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
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 2
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!
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) ×