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
Woman managing cloud databases
Manage Azure SQL Databases with PowerShell
Using Microsoft's Database-As-A-Service (DBaaS) offering gives you the flexibility to create databases as you need them, and you let Microsoft worry about backups, disaster recovery, and any other maintenance you normally focus on.
Illustration of computer servers in the cloud
Use PowerShell Remoting to Manage Azure VMs
The ability to use remoting to manage your SQL servers is critical to minimizing the time it takes to make sure everything's running smoothly, so you can focus on the problems that are impacting the business.
Update Excel Spreadsheets from PowerShell
Learn to update Excel spreadsheets from PowerShell for times when it's problematic to use something like SQL Server Reporting Services (SSRS) to create a report.
Man and woman working on laptops
Set Up Multiple Azure VM Servers with PowerShell
Learn how to set up multiple Microsoft Azure virtual machine (VM) Servers with PowerShell.
PowerShell list of SQL Servers available
Create a New Azure VM with PowerShell
Using PowerShell, you have a repeatable process to provision and access your SQL Server Azure VM environment, making the process consistent and much more easily manageable.
Using PowerShell to Get Started in Microsoft Azure
Microsoft Azure provides a whole new way to manage your data. Rather than having to buy expensive hardware and install SQL Server, you can spin up a new Microsoft Azure VM in a matter of minutes.
Red key labeled Backup on keyboard
Get Database Backup Details with PowerShell
PowerShell, with a little help from SQL Server Management Objects (SMO), gives you a more versatile way to grab database backup details.
Extract Report RDL with PowerShell 4
While SQL Server Reporting Services provides an easy way to upload an RDL file into Reporting Services, it doesn't provide an easy way to extract the RDL file. Fortunately, you can use the ReportService2010 web service to do this.
Gloved hand using yellow sponge to clean a surface.
Clean Up SQL Server Logins and Users with PowerShell
Here is a set of PowerShell code that can help you clean up orphaned logins and users in your SQL Servers.
PowerShell -ScriptBlock argument.
Use PowerShell Remoting to Manage SQL Servers Efficiently
PowerShell 2.0 introduced a different way to manage your servers, called remoting—it gives you a lightweight way to manage all of your servers, and manage them all at the same time.
Data written on keyboard
Use PowerShell to Load XML Data into SQL Server 2
PowerShell is a more efficient method for loading large data sets into SQL Server from XML than T-SQL. Learn how.
Woman working at her computer and talking on cell phone
Passing Command-Line Arguments to PowerShell
You can write easy scripts in PowerShell to get things done quickly, but as you get comfortable and want your scripts to be usable by your entire team, take advantage of the features of PowerShell command-line arguments to help those who use your scripts.
Red Error key on keyboard
Handling Errors in PowerShell
PowerShell provides ways to manage times when there are errors in the execution of our script so we can recover, and still get the job done.
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
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.

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
Fort in the road
Oct 22, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 11: A Fork in the Road

A quick overview of the pros and cons of dynamic detection at job execution time or the option of dynamically enabling/disabling jobs....More
business people around a table and laptop
Oct 9, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 10: Dynamic Detection Gotcha #3

You can interject a SQL Server Job Step into your Jobs and have this new/injected Job Step do some checking for you. Here's a look at everything that’s involved in such an approach....More
Man holding a piece of paper with the word GOTCHA
Oct 7, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 9: Dynamic Detection Gotcha #2 3

Given that a USE statement is parsed before code is actually run, there are a few options that could be used as a around when it comes to detecting whether or not code should be run....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) ×