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

Speaking? You? Go on. #tsql2sday #84

by Rob Sewell

SQL DBA With A Beard

This is a blog post for this month’s T-SQL Tuesday post, hosted by Andy Yun (b|t). T-SQL Tuesday is a monthly...

2016-11-08

375 reads

PowerBi and API – Visualising my Checkins

by Rob Sewell

SQL DBA With A Beard

For my own amusement and also to show my wife where I have been I use the Swarm check-in app...

2016-11-03 (first published: 2016-10-29)

2,180 reads

PSConfAsia 2016

by Rob Sewell

SQL DBA With A Beard

I have just got back to the UK from Singapore following the amazing PSConfAsia conference. I must say that Matt,...

2016-10-24

527 reads

PowerShell, Pester and Ola Hallengrens Maintenance Solution

by Rob Sewell

SQL DBA With A Beard

If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and...

2016-10-04 (first published: 2016-09-24)

3,759 reads

Converting SQL Agent Job Duration to TimeSpan using PowerShell

by Rob Sewell

SQL DBA With A Beard

When you look in msdb for the SQL Agent Job duration you will find that it is an int.

This is...

2016-09-15 (first published: 2016-09-12)

1,488 reads

The SQL Server Community Collaborative GitHub Organisation is born

by Rob Sewell

SQL DBA With A Beard

My wonderful friend Chrissy LeMaire and I are the creators of two GitHub repositories for SQL Server and PowerShell called...

2016-09-14

772 reads

Making Start-Demo work with multi-line commands without a backtick

by Rob Sewell

SQL DBA With A Beard

I love to speak about PowerShell. I really enjoy giving presentations and when I saw Start-Demo being used at the...

2016-08-29

530 reads

Remove-SQLDatabaseSafely My First Contribution to DBATools

by Rob Sewell

SQL DBA With A Beard

What is DBA Tools?
A collection of modules for SQL Server DBAs. It initially started out as ‘sqlmigration’, but has now...

2016-07-20

999 reads

Using the new SQLServer Powershell module to get SQL Agent Job Information

by Rob Sewell

SQL DBA With A Beard

So with the July Release of SSMS everything changed for using PowerShell with SQL. You can read the details here...

2016-07-14 (first published: 2016-07-03)

3,428 reads

PowerShell CMDLets added for SQL2016 Always Encrypted

by Rob Sewell

SQL DBA With A Beard

The post on the SQLServer blog at TechNet by the SQL Server Tools Team today made me jump out of...

2016-06-30

1,004 reads

Blogs

What is ALM in Fabric?

As someone who’s worked with data for over 20 years and with many cloud...

The Most Successful Startups in 2025 — And What They Have in Common

2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...

Blog a Day – Day 1: History of AI

By Vinay Thakur

it has been a year since i have not written much on the blog...

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