SQL DBA With A Beard

Whilst I was writing my Test-DbaLastBackup Posts I ran into a common error I get when importing datatables into a...

2017-04-01

1,431 reads

Getting SQL Server File Sizes and Space Used with dbatools

by Rob Sewell

SQL DBA With A Beard

I read a great blog post about answering the question how big is the database using T-SQL on SQL Buffet...

2017-03-29

958 reads

Test your Sqlserver backups on Linux with PowerShell and dbatools

by Rob Sewell

SQL DBA With A Beard

I have written about Test-DbaLastBackup in posts here, here and here. They have been Windows only posts.
With SQL Server vNext...

2017-03-27

341 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,618 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,822 reads

Taking dbatools Test-DbaLastBackup a little further

by Rob Sewell

SQL DBA With A Beard

In a previous post I showed how easy it is to test your backups using Test-DbaLastBackup
Today I thought I would...

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

1,909 reads

Testing Your SQL Server Backups the Easy Way with PowerShell & dbatools

by Rob Sewell

SQL DBA With A Beard

In a previous post I wrote about how easy it was to restore a whole SQL Servers user databases from...

2017-03-20

964 reads

Restoring an entire SQL Server user databases with PowerShell using dbatools

by Rob Sewell

SQL DBA With A Beard

All the good DBAs backup their databases.
A significant amount of SQL DBAs use Ola Hallengrens maintenance solution to do so.
This...

2017-03-29 (first published: 2017-03-18)

3,012 reads

Adding a PowerShell Job Step to an existing SQL Agent Job Step with PowerShell

by Rob Sewell

SQL DBA With A Beard

In my last post I showed how to add a T-SQL Job step to an existing SQL Agent Job. The...

2017-03-13

1,111 reads

VS Code PowerShell Snippets

by Rob Sewell

SQL DBA With A Beard

Just a quick post, as much as a reminder for me as anything, but also useful to those that attended...

2017-03-17 (first published: 2017-03-12)

2,652 reads

SQL DBA With A Beard

Max Length of a column in a DataTable in PowerShell

Getting SQL Server File Sizes and Space Used with dbatools

Test your Sqlserver backups on Linux with PowerShell and dbatools

Using Pester with dbatools Test-DbaLastBackup

Backing up SQL Server on Linux using Ola Hallengrens Maintenance Solution

Taking dbatools Test-DbaLastBackup a little further

Testing Your SQL Server Backups the Easy Way with PowerShell & dbatools

Restoring an entire SQL Server user databases with PowerShell using dbatools

Adding a PowerShell Job Step to an existing SQL Agent Job Step with PowerShell

VS Code PowerShell Snippets

Blogs

My 2024 in Data: Music

A New Word: Suente

Side Projects

Forums

Timeout Error while executing a TSQL statement in Sql server Express Edition

Timeout Error while executing a TSQL statement in Sql server Express Edition

Sql script replace and rearrange numbers

Question of the Day

DCL