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

Using the ADO.NET Connection String
The ADO.NET connection string contains the information that a script needs to connect to a SQL Server database. Here's what you need to know to create one.
Add SQL Server Job Failure Notifications with PowerShell 2
Learn how to add SQL Server job failure notifications with PowerShell.
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.

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
Nov 3, 2015

Climb the Steps Toward Data Quality Success

Melissa Data's Data Quality Analyst Joseph Vertido explains how Gartner defines the critical data quality steps to prevent bad data from entering your systems in the first place, and then keep it clean over time....More
Sep 29, 2015

Data Breaches and Insider Threats

I’ll sound a bit like Captain Obvious for bringing this up, but it’s important to remember that security encompasses a lot more than protecting sensitive data from the specter of outsider threats like hackers. Properly implemented security policies also account for threat-models that include insiders – or people within your organization....More
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups 1

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....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) ×