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

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 will know that the process is extremely slow and...

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

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

Implicit Time Conversions – #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...