Tag Archives: administration

Enable a Named Instance to Connect on 1433

Posted on April 22, 2019 by way0utwest

My default setup for a few years is to only use named instances, usually with a standard SQL2014 or SQL 2016 as the name of the instance. Recently, I set up a new instance and needed to connect from another … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Changing the Database Collation–#SQLNewBlogger

Posted on February 27, 2019 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was testing some changes recently and needed to verify how things worked in a different collation. Here’s the … Continue reading →

Posted in Blog | Tagged , | 1 Comment

Reserved Space

Posted on January 30, 2019 by way0utwest

Many of us that work with SQL Server are familiar with the idea of reserving space that our system might need later. This is normal operation in SQL Server, where we pre-allocate space to data and log files, knowing that … Continue reading →

Posted in Editorial | Tagged | Comments Off on Reserved Space

Mitigate Issues Early

Posted on November 28, 2018 by way0utwest

This is a great postmortem from Basecamp with a detailed explanation of a problem and how they are hoping to avoid issues with their service. Basecamp is a Software as a Service tool from 37 Signals that had an outage recently. Actually, the service … Continue reading →

Posted in Editorial | Tagged | Comments Off on Mitigate Issues Early