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

By | In Blog, SQL Server | September 28th, 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

Contact Us
Eric Russo
Senior Vice President of Database Services
Eric Russo is SVP of Database Services overseeing all of Datavail’s database practices including project and managed services for MS SQL, Oracle, Oracle EBS, MySQL, MongoDB, SharePoint and DB2. He is also the Product Owner for Datavail Delta, a database monitoring tool. He has 21 years’ experience in technology including 16 years in database management. His management success and style has attracted top DBAs from around the world to create one of the most talented and largest SQL Server teams. He has been with Datavail since 2008: previous to that his work experiences include DBA Manager at StrataVia, Senior Web Developer at Manifest Information Systems and SQL Server DBA at Clark County, Nevada.

Leave a Reply

Your email address will not be published.
Required fields are marked (*).