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,521 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

967 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

344 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,644 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,827 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,914 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

982 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,031 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,128 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,663 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

Cyber Scams and Operation Shamrock

The Book of Redgate: Ingeniously Simple

Building a Todo List RESTful API in C++ with Docker, GitHub Actions, Azure ACR: A Beginner’s Guide

Forums

BULK INSERT messing up import of CSV file with a comma in it

Users Default Schema in a stored procedure.

Calculating Difference between Multiple Dates for a Given Condition in HH:MM:SS

Question of the Day

Updating a Data API Builder Connection String

SQL DBA With A Beard

Blogs

Forums

Question of the Day

Cookies on SQLServerCentral