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

Making a Change Log Easier With PowerShell

by Rob Sewell

SQL DBA With A Beard

Having a Change Log is a good thing. A quick and simple place to find out what has changed on...

2014-12-16 (first published: 2014-12-08)

5,137 reads

Giving Back – #TSQL2sday

by Rob Sewell

SQL DBA With A Beard

T-SQL Tuesday, which was started by Adam Machanic (blog|twitter) and is now starting its 6th year, is hosted by a...

2014-12-09

787 reads

A look at the SQL Assessment Intelligence Pack in Operational Insights

by Rob Sewell

SQL DBA With A Beard

Operational Insights is a service that has been added in preview to Azure. It enables you to collect, combine, correlate...

2014-11-28 (first published: 2014-11-24)

6,782 reads

Changing Delay Between Responses for SQL Alerts with Powershell

by Rob Sewell

SQL DBA With A Beard

So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on...

2014-11-28 (first published: 2014-11-18)

7,120 reads

#tsql2sday #60 – Something New Learned – Problem Step Recorder

by Rob Sewell

SQL DBA With A Beard

What is T-SQL Tuesday?

T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party...

2014-11-11

2,399 reads

Generating T-SQL Randomly with Powershell

by Rob Sewell

SQL DBA With A Beard

I have a lab on my laptop running various servers so that I can problem solve and learn and recently...

2014-11-05

540 reads

Emailing Disk Space Alerting With Powershell

by Rob Sewell

SQL DBA With A Beard

A DBA doesn’t want to run out of space on their servers, even in their labs! To avoid this happening...

2014-11-04

4,863 reads

Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell

by Rob Sewell

SQL DBA With A Beard

So you have read up on VLFs
No doubt you will have read this post by Kimberly Tripp and this one...

2014-10-06

694 reads

PowerShell Snippets A Great Learning Tool

by Rob Sewell

SQL DBA With A Beard

When I talk to people about Powershell they often ask how can they easily learn the syntax. Here’s a good...

2014-09-09

708 reads

Find Out Which Indexes are on which Filegroups using PowerShell And How To Find Other Information

by Rob Sewell

SQL DBA With A Beard

A short post today to pass on a script I wrote to fulfil a requirement I had.
Which indexes are on...

2014-09-07

515 reads

Blogs

AI Step 1

By Vinay Thakur

As this is an Artificial Intelligence (AI) World, things are changing. We can see that...

Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend

By Ige Adetokunbo Temitayo

In a containerized app, React and Chakra UI provide a robust and accessible user...

A New Word: Nachlophobia

nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...

Read the latest Blogs

Forums

identify consecutive records greater than 1

Hello I need help identifying all records that have consecutive hours (time in order)...

Call dynamic sql storedprocedure from SSIS execute sql task

hi, I have a table called Rules Create table Rules ( Id int ,...

Migrating database with many orphan users.

I am currently upgrading a very old database running SQL Server 2008 to SQL...

Visit the forum

Question of the Day

The Funny SELECTs

What is returned from this query?

SELECT
  ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013;

See possible answers