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 Twitter with VS Code

by Rob Sewell

SQL DBA With A Beard

So today I saw this tweet from Mathias in reply to Stefan and Amanda

That looks cool. Twitter in VS Code, one...

2017-04-28 (first published: 2017-04-19)

1,004 reads

PowerShell Function – Validating a Parameter Depending On A Previous Parameter’s Value

by Rob Sewell

SQL DBA With A Beard

I was chatting on the SQL Community Slack with my friend Sander Stad b | t about some functions he is writing for...

2017-04-26

441 reads

Testing SQL Server Access to a share with PowerShell using dbatools

by Rob Sewell

SQL DBA With A Beard

A good security practice is to backup our SQL Servers to a network share but not allow users to be...

2017-04-13 (first published: 2017-04-08)

1,326 reads

Why VS Code Increases my Productivity

by Rob Sewell

SQL DBA With A Beard

Last week I was showing a co-worker some PowerShell code and he asked what the editor was that I was...

2017-04-13

463 reads

Using Pester with dbatools Test-DbaLastBackup

by Rob Sewell

SQL DBA With A Beard

In previous posts I have shown how to use Test-DbaLastBackup from dbatools and how you can make use of the...

2017-04-11 (first published: 2017-03-25)

1,656 reads

Why Volunteer at SQLBits ?

by Rob Sewell

SQL DBA With A Beard

WARNING – Contains Orange and light-hearted photos
I have returned home from SQLBits 2017 The Disco Edition. I am exhausted, my...

2017-04-11

546 reads

Export SQL User Permissions to T-SQL script using PowerShell and dbatools

by Rob Sewell

SQL DBA With A Beard

There are times when DBA’s are required to export database user permissions to a file. This may be for a...

2017-04-10

2,354 reads

Testing the Identity Column usage in SQL Server with PowerShell and dbatools

by Rob Sewell

SQL DBA With A Beard

SQL Server uses identity columns to auto generate values, normally keys. When you create an identity column, it has a...

2017-04-07

561 reads

Backing up SQL Server on Linux using Ola Hallengrens Maintenance Solution

by Rob Sewell

SQL DBA With A Beard

With the release of SQL Server vNext CTP 1.4 SQL Agent was released for use on Linux. To install it...

2017-04-06 (first published: 2017-03-22)

1,845 reads

Using Pester with Get-DbaLastGoodCheckDb from dbatools

by Rob Sewell

SQL DBA With A Beard

In my last post I showed Get-DbaLastGoodCheckDb from dbatools. This module is a community based project written by excellent, brilliant...

2017-04-06

523 reads

Blogs

The First Steps: Understanding the Basics of FinOps

As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...

Monday Monitor Tips: AI Query Analysis

AI is everywhere. It’s in the news, it’s being added to every product, management...

AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation

By Vinay Thakur

RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...

Read the latest Blogs

Forums

would it be so terrible to install ssms on a few user desktops?

Hi, ssms is free here. I can think of other reasons to do this...

I'm thinking about submitting some articles

By Doctor Who 2

I've written some documentation on using different Markdown types of files on GitHub. It's...

Not Just an Upgrade

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Not Just an Upgrade

Visit the forum

Question of the Day

Restoring On Top I

I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?

USE Master
BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak'
GO

USE DNRTest
GO
CREATE TABLE MyTest(myid INT)
GO
USE master
RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACE

See possible answers