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
New Power BI Designer unifies the “power” tools
Jun 3, 2015
Article

Power BI Preview Gaining Market Momentum

As summer nears, the Power BI Preview is making bigger waves with every weekly release. Popular data sources and a plethora of Power BI Designer enhancements are being released at light speed pace. Check out the highlights on what has been released and what we might see next....More
Evolution of SQL Server continues
Jun 3, 2015
Article

What is Coming in SQL Server 2016 for Business Intelligence 1

Over the past few years we did not hear anything from Microsoft about SQL Server on-premises business intelligence enhancements. The extended cricket-chirping silence left us speculating about the future of Reporting Services, Analysis Services and other key technologies that are being used today to power critical decision making solutions. Good news, the waiting and wondering is over. Microsoft recently announced significant SQL Server on-premises upgrades for business intelligence in numerous presentations at both //build and Ignite conferences....More
May 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 25: Final Remarks on Backups

In the last few posts (posts 19 – 24) I’ve covered some high-level concerns and reviewed some details about how to implement and manage database backups against AlwaysOn Availability Group databases. Most of the information I’ve provided was pretty basic or elementary – along with some additional guidelines for things to watch out for when managing backups. Which is to say that backups are never something you can simply take for granted and they’re never something you just take lightly....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) ×