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

awhite@allenmwhite.com http://upsearch.com/

Allen’s Recent activity

Gloved hand using yellow sponge to clean a surface
Clean Up SQL Server Logins and Users with PowerShell
May 15, 2014
Unless you've got a well-defined strategy to manage SQL Server logins and database users via Active Directory groups (as I usually recommend when setting up SQL Server security), you're going to eventually find you...
Data written on keyboard
Use PowerShell to Load XML Data into SQL Server
Apr 21, 2014
Using Service Broker to move data asynchronously from one application to another, I've become comfortable with parsing and loading XML data into SQL Server tables. If the number of rows is relatively small, Xquery...
Woman working at her computer and talking on cell phone
Passing Command-Line Arguments to PowerShell
Apr 07, 2014
You can use scripts to automate all of your SQL Server management processes because it allows you to know that the task is done consistently and with a minimum of effort. (You really don't want to use the SQL...
Red Error key on keyboard
Handling Errors in PowerShell
Mar 24, 2014
As DBAs, we're always working on protecting ourselves from problems by disaster recovery procedures like backups, but in our haste to get a script done, we also are prone to forget the same concept within our code...
computer keyboard red key labeled HELP
Add Help to your PowerShell Scripts
Mar 17, 2014
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-Com...
Man looking at computer monitor
Getting SQL Server Performance Data with PowerShell
Feb 18, 2014
Once you've got your SQL Server environment set up and working the way you want it, it's time to start gathering your baseline performance data. A baseline is critical because every workload is different, and...
Woman working on computer
Create Alert-Based Log Backups with PowerShell
Jan 14, 2014
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. There's a lot of activity that SQL Server records in the transaction log...
copy computer keyboar key with data in background
Bulk Copy Data into SQL Server with PowerShell
Jan 13, 2014
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. T-SQL supports the BULK INSERT command as well, allowing you to...
Load More