Install SQL via Windows Command Line

I have been on a mission to find easier ways to install SQL Server.  I have recently been working on...

SQL Homework – July 2018 – Create a SQL Agent Job

For this month’s homework let’s try something a bit different. SQL Agent jobs are a very powerful tool frequently used...

Testing BackBlaze Restores

The most important thing for a data guy is having a way to restore data. If security, performance, etc. are...

Back to #SQLSat Louisville

Next week is SQL Saturday #729 – Lousiville and I’m making the trip. This will be my third or fourth trip...

Baton Rouge User Groups Networking Night

What a great evening of interesting presentations, professional networking, and Jambalaya!We had 5 speakers last night on topics covering: Availability Groups (me), software documentation, leveraging the SQL Server community,...

MSDTC Supported Configurations

The MSDTC Configuration Conundrum MSDTC configuration is not as straight forward as you might think.  It’s a different choice if...

Save your execution plans!

Working with performance problems and query tuning can be a headache and take a lot of time.  Most companies I...

SQL .NET Requirements

SQL Server Install Requirements

SQL Server Installation requirements indicate .NET 3.5, 4.0, or 4.6 depending on the version. This is not including SSMS. At this point you shouldn’t use SSMS...

SQL Server : Understanding Backup and Restore operations using Docker Containers

In this article, we will discuss the concepts of database backup-and-restore operations on SQL Server Docker containers. This is certainly...

Why Aren’t You Using SSMS 17?

Last fall, Microsoft split the coding and release of SQL Server Management Studio away from any dependency on the server...