How to Restore a SQL Server Database Using dbatools Restore-DbaDatabase

June 17, 2025

In this blog post, we will audit the dbatools command Restore-DbaDatabase. I will test, review, and evaluate the script based on a series of identical steps. Our goal is to provide insights, warnings, and recommendations to help you use this script effectively and safely. Restore-DbaDatabase is powerful tool to automate the restore of any database,

It’s The Data, Stupid

November 6, 2014

No Offense I mean no offense by the title. The title goes back to American election politics. Someone somewhere (James Carville said this in 1991 about the focus of the campaign he managed for Bill Clinton.. Forgot that, but I found it in about 8 seconds because of fast data in the cloud). I’m not

SQLU DBA Week – DBA Progress Report

March 4, 2011

This week was DBA Week At SQL University. We’ve seen two great posts from Robert Davis, a couple posts from me and some input from DBA Coach LaRock. Today we’ll lighten things up. It’s Friday so let’s close our notebooks and have a classroom discussion about our attitudes and learning. There are all sorts of

SQLU DBA Week – Set It And….

March 2, 2011

Welcome to the third day of DBA week at SQL University. On day one, I kicked off the “back to basics” journey I’ve chosen for fellow students with my post reminding you that you’re only as good as your ability to restore. Microsoft Certified Master Robert Davis brought us a good reminder on Day 2

SQLU DBA Week – You Can Restore It! (right?)

February 28, 2011

Welcome to my first contribution to SQL University’s Database Administration Week! I am going to go back to some basics here this week. I know you’ve probably been with us for a few semesters and you don’t want to hear that. That’s fine, Microsoft Certified Master Robert Davis is also covering DBA week and he

SQL 2008 R2 LoadFest – Session Notes

September 25, 2010

I spoke today at the SQL Server 2008 R2 Load Fest put on by Andy Novick of Novick Software. Great turnout, and it is always fun to see so many folks working together on the task of figuring out the nuances of SQL Server installations together. Also good to see that you were able to

5 Things SQL Server Should DROP

May 11, 2010

When I picture Paul Randal, I picture a guy who likes to run up to a bees nest at a crowded picnic and give it a good couple whacks. You know what I mean, it’s that laughing picture in his twitter profile. Or maybe it’s the devil’s advocate style he has. Maybe it’s his controversial

Speaking at SNESSUG Wednesday!

May 11, 2010

Back in April, I invited Grant Fritchey to be our inaugural speaker to the Seacoast SQL Server User Group. My guess is he was frustrated with the traffic and time to drive from his office in Rhode Island up to New Hampshire in rush hour traffic. Why? Because shortly after his time speaking with us,

SeacoastSQL First Meeting Recap

April 19, 2010

(Written the night of the meeting, edited and posted after) Wow. I just got home from a really great night with a fun group of people. The first meeting (hopefully of many more) was a success (more on what that means from my point of view below) and we had an amazing turnout – By

What SQL instances are installed on my network?

February 25, 2009

Find All SQL Server Instances On Your Network! It’s been awhile since a tool has given me that giddy, starstruck feeling but it’s happened this week… If you ever struggle with instance discovery and management, I hope you get excited and try this tool out as well. Bear with me as I walk through it.