Rob Sewell

Rob was a SQL Server DBA with a passion for Powershell, Azure, Automation, and SQL (PaaS geddit?). Now he just helps people. He is a Cloud and Data Center MVP and a Data Platform MVP, an officer for the PASS DevOps Virtual Chapter, co-leader of Data South West and PSConf EU organiser and has spoken at and volunteered at many Data and PowerShell events all over the world. He is a proud supporter of the Data and Powershell communities.

He relishes sharing and learning and can be found doing both via Twitter and his blog. He spends most of his time looking at a screen and loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, you can find him on the cricket field in the summer and flying a drone in the winter.

He has a fabulous beard

Twitter: @@SQLDbaWithBeard
LinkedIn: https://linkedin.com/in/robsewellsqldba

Using Docker to run Integration Tests for dbachecks

by Rob Sewell

SQL DBA With A Beard

My wonderful friend André Kamman wrote a fantastic blog post this week SQL Server Container Instances via Cloudshell about how...

2019-02-06 (first published: 2019-01-19)

2,268 reads

Running Windows and Linux SQL Containers together

by Rob Sewell

SQL DBA With A Beard

Just for fun I decided to spend Christmas Eve getting Windows and Linux SQL containers running together.

WARNING
This is NOT a...

2019-01-04 (first published: 2018-12-24)

1,880 reads

SQL Server Availability Group FailoverDetection Utility PowerShell Function Improvements – Named Instances, Archiving Data, Speed

by Rob Sewell

SQL DBA With A Beard

In my last post I wrote about a new function for gathering the data and running the FailoverDetection utility by...

2018-12-19 (first published: 2018-12-01)

1,856 reads

Gathering all the Logs and Running the Availability Group Failover Detection Utility with PowerShell

by Rob Sewell

SQL DBA With A Beard

30/11/2018 – Function has been updated to deal with named instances.
Last week the Tiger Team released their Availability Group Failover Detection...

2018-12-17 (first published: 2018-11-28)

1,990 reads

Getting the SQL Version from a backup using dbatools ………. on PowerShell Core

by Rob Sewell

SQL DBA With A Beard

Following an upgrade to SQL Server the backup share had a number of backups, some from the old version and...

2018-12-12 (first published: 2018-11-26)

1,722 reads

Getting SQL Services, Starting, Stopping and Restarting them with dbatools

by Rob Sewell

SQL DBA With A Beard

There was a question in the #dbatools slack channel

Getting dbatools
dbatools enables you to administer SQL Server with PowerShell. To get...

2018-12-03

307 reads

PASS Summit, SQLTrain and My First US SQL Saturday

by Rob Sewell

SQL DBA With A Beard

Next week is the week when I used to dread looking at Twitter and especially the #PASSsummit hashtag, watching all of...

2018-10-31

258 reads

Checking Trace Flags with dbachecks, online docs and PSPowerHour

by Rob Sewell

SQL DBA With A Beard

It’s been a few weeks since i have blogged as I have been busy with a lot of other things....

2018-10-10 (first published: 2018-09-29)

1,955 reads

Deploying To a Power Bi Report Server with PowerShell

by Rob Sewell

SQL DBA With A Beard

Just a quick post to share some code that I used to solve a problem I had recently.
I needed to...

2018-09-04 (first published: 2018-08-21)

5,735 reads

A PowerShell Conference In A Book

by Rob Sewell

SQL DBA With A Beard

A Question
Shortly after the European PowerShell Conference and the PowerShell and Devops 2018 summit in the USA Mike Robbins b...

2018-08-17 (first published: 2018-08-01)

2,741 reads

Blogs

How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment

By Koen Verbeeck

Quite the title, so let me set the stage first. You have an Azure...

Deployment Pipelines in Fabric – What Are They?

In the realm of software development and content creation, the deployment pipeline serves as...

Ad Hoc SQL Server Help

I just need a few hours of your time… We get a variation of...

Read the latest Blogs

Forums

A Quick Restore

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Quick Restore

Guarding Against SQL Injection at the Database Layer (SQL Server)

Comments posted to this topic are about the item Guarding Against SQL Injection at...

Ola Hallengren Index Optimize Maintenance can we have data compression = page

I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...

Visit the forum

Question of the Day

A Quick Restore

While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:

USE DNRTest

BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak'
GO
/*
Bunch of stuff tested here
*/RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACE

What happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance.

See possible answers