Select Page


Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.

Author: JP Chen
Browse Blog Categories

DBA Toolbox – Creating Your Own DBA Utilities Database

As a DBA, you can develop your own toolbox and be a master in the craft of administering and managing databases.

JP Chen | June 23, 2016

How to Stripe Your Backups into Multiple Files

In this blog, we will explore the option to stripe the backup files into four by first running the database backups using one file.

JP Chen | June 16, 2016

Checking the SQL Server Agent Status

In this blog, we will explore and share with you how to quick stop, start, and run a script to check the SQL Server Agent status.

JP Chen | May 26, 2016

Comparing DBaaS Options from Amazon and Microsoft

We compare Amazon RDS & Microsoft Azure SQL Databases. Cloud-based computing holds promise for businesses that no longer need to own and maintain fixed-hardware assets.

JP Chen | December 3, 2015

Querying the SQL Server Instance and OS Level Details

If you need to query more than 100+ SQL Server instances, you will need to register all the instances into a group and run a multi-server query.

JP Chen | November 10, 2015

How to Automate the Database Restore Process

This blog will explore on how we can automate the database restore process by generating the required TSQL statements. Read on to learn more.

JP Chen | November 5, 2015

Scripting Out SQL Server Logins, Server Role Assignments, and Server Permissions

This blog reviews how you can generate scripts for SQL server logins, role assignments, and server permissions for a smooth migration.

JP Chen | October 1, 2015

Querying Database File Properties

You may wish to increase the file autogrowth size if they are set at rather small increments or set to increase by a percentage. You can right-click on the database and select “Properties” in the pop-up menu,then click on the “Files” page.

JP Chen | July 28, 2015

Querying the Drive Space Utilization

How can you query the disk drives space utilization to show all the drives, total capacity, free space, and percentage free for the drives that contain the SQL Server databases data and log files?

JP Chen | July 9, 2015

3 Slick Scripts for Database Mail Alerts and Reports

Database Mail enables you to send e-mail messages from the SQL Server Database Engine. Database Mail uses the standard Simple Mail Transfer Protocol (SMTP) to send mail.

JP Chen | June 16, 2015

7 Steps to Setting Up Database Mail

As an alternative to SQL Mail, Microsoft suggest using Database Mail. They advise using Database Mail because SQL Mail will be removed in a future version of SQL Server, so using Database Mail in new development work should save you some future heartache.

JP Chen | June 9, 2015

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.