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 Oracle error message is very common for database administrators. Learn how to diagnose & resolve this common issue here today.

Vijay Muthu | February 4, 2021

Data Types: The Importance of Choosing the Correct Data Type

Most DBAs have struggled with the pros and cons of choosing one data type over another. This blog post discusses different situations.

Craig Mullins | October 11, 2017

How to Recover a Table from an Oracle 12c RMAN Backup

Our database experts explain how to recover and restore a table from an Oracle 12c RMAN Backup with this step-by-step blog. Read more.

Megan Elphingstone | February 2, 2017

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.