Using dbatools for automated restore and CHECKDB

OK, so if you haven’t heard of the dbatools.io project run by Chrissy LeMaire and company…you’ve likely been living under a rock. I strongly encourage you to check it out...

This blog post is just a quick follow from my presentation last week for the SQL PASS PowerShell Virtual Chapter....

Blog Challenge: I am watching you!

I decided to accept Grant’s (TheScaryDBA) challenge found here- http://www.scarydba.com/2017/03/02/random-blog-post-challenge/ where we have to write a technical blog post that incorporates a certain...

Copying data from On Prem SQL to ADLS with ADF and Biml – Part 1

Apologies for the overly acronym-laden title as I was trying to keep it concise but descriptive. And we all know...

DBA 101: File growth

Maintaining a database is an important job of the DBA role. One of the many maintenance tasks is ensuring that...

Friday Reading 2017-03-03

Fun week, lot’s of things going on and throughout I’ve been reading…
Windows Server Premium Assurance and SQL Server Premium Assurance

Microsoft...

I Don’t Understand

I suspect this may make a few people angry, but I felt the need to share.
I was recently asked to...

Is Your Database App Ready for the Cloud?

The cloud has evolved. Just a few years ago, cloud-based applications were the exception rather than the rule, and on-premises...

So I have a new home! Welcome to cjsommer.com part deux!

Just wanted to put a quick post out there for the people who follow me. I very recently made a...

Do you need a degree to be DBA?

This question gets asked a lot and reoccurs over the years. Do you need a degree to be DBA? I have seen...