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
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 5
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
Jul 6, 2016
Sponsored

Using BI Office Together with Microsoft Power BI Desktop to Unlock Business Insights

It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More
Jul 6, 2016
Sponsored

Why It’s Important to Unlock Business Insights Trapped on Individual Desktops

To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More
May 12, 2016
blog

The 7 C's of Data Quality

Data quality is really important. Why? Because it helps you save money while increasing profits because of accurate contact data. It’s important to understand what data quality is and why it is important....More

Sponsored Introduction Continue on to (or wait seconds) ×