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...

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...

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...

DBA 101: Unique Constraint vs Unique Index

Designing a rock solid application and database can be difficult. New features and overlapping features mean that you’re able to...

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...

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...

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...

ScriptDom parsing and NoViableAltExceptions

If you have ever tried to debug a program that used the TSql Script Dom to parse some T-SQL you...