Select Page

9 How-to Blog Posts to Improve Your SQL Server Skills

Author: Eric Russo | | September 28, 2016

We do a lot of blogging here at Datavail – and I mean a lot – and though we’re sure that you follow every post with the scrutiny of a find-toothed comb, it’s easy to miss a post here and there, potentially one that has some valuable information that could improve your job performance. For that reason, we’re offering the first in a series of blog posts that will group all the rest of our blog posts by overall topic. This should help you to not only find all the tips, tricks, and secrets you may have missed along the way, but enable you to get all the value of our expertise on a particular topic in one fell swoop!

This week, we’re going to cover our most important, most popular How-to’s for SQL Server. Between these nine posts, you’ll get valuable information on how to find, stripe, and restore backups, check the SQL Server agent status, automate the database restore process, and more. Take a look at the nine posts below and read the summaries to find the information you need the most.

Where Are Your Backups?

In this blog, we will explore the required system tables, functions, and the techniques to create a backup history report.

Read more

How to Stripe Your Backups into Multiple Files

This post covers the option to stripe the backup files into four by first running the database backups using one file and then stripe them into four files. We will then compare the backup durations.

Read more

How to Restore Your Backups from Striped Backup Files

As a continuation of the previous post on how to stripe your backups into multiple files, we will look into how we can generate the TSQL restore scripts automatically and then execute them to perform the restores.

Read more

How to Check the Recent Restore Details

As part of the migration project steps, you need to create a report to show the restore details such as the restore option, recovery options, restore start time, source file, and where the file was restored. This post will show you how.

Read more

How to Automate the Database Restore Process

In this blog, we will explore on how we can automate the database restore process by generating the required TSQL statements.

Read more

How to Rename a Database and its Logical and Physical Files

What are the required steps to query the existing logical and physical file name, rename a database, rename the logical file names, and rename the physical file names? This blog post reviews the process.

Read more

Checking the SQL Server Agent Status

Read this post to learn how to quick stop, start, and run a script to check the SQL Server Agent status.

Read more

Querying the SQL Server Instance and OS Level Details

Learn how to develop an Excel report to show all the instance level details such as instance name, version, edition, service pack, server authentication mode, if it’s clustered, the current node name, server collation, # of CPUs, and memory of the Operating System.

Read more

Great tip for SQL Server DBAs – Uninstall Programs from Command Line

A quick and easy tip for uninstalling programs from the command line.

Read more

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS:could not resolve the connect identifier specified” Oracle error is a commonly seen message for database administrators.

Vijay Muthu | February 4, 2021

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

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

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

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.