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

968 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

346 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,650 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,833 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,920 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

985 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,035 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,130 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,670 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

SQL Server is Slow, part 3 of 4

AI Model Size, Parameters and Download

Expanding Your DBA Horizons: Installing PostgreSQL in a Home Lab

Forums

caught off guard by some greek lettering in a warehouse feed

Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY

Vector Datatype

Question of the Day

Vector Datatype