Tag Archives: administration

The Aware DBA

A long time ago, at least, a long time in the eyes of my kids, I worked for a large organization as a production DBA. We had a generic monitoring tool, but it wasn’t SQL Server specific. I ended up … Continue reading

Posted in Editorial | Tagged ,

What’s the Mashup Engine?

I was testing something the other day and ran sp_who2 on a test instance. I saw this in the program listing: I had never seen the Mashup Engine listed in a program list, and I certainly don’t have any program … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Enable a Named Instance to Connect on 1433

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

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