Blog

SQL on Linux: Connecting to and Querying SQL on Linux

SQL Server expert JP Chen maps out the steps to cover connecting and querying SSMS and Azure Data Studio.

How To Fix Log Shipping Failure Errors In SQL Server

Learn how to fix common Log Shipping Failure errors in SQL Server. Follow Datavail’s step-by-step instructions, screenshots, and software script here!

How to Restore Multiple Backup Files in SQL Server from Striped Backup Files

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.

SQL Server Query: Querying the 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.

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.

RAID For SQL Server: What RAID Should You Use?

Which RAID should you use with SQL Server? Learn the differences between RAID 0, RAID 1, RAID 5, and RAID 10, along with best practices.

Move SPFILE from ASM to File System

The following is an example of how to move your SPFILE from ASM to your file system or vice versa.