Tag Archives: administration

What’s the Mashup Engine?

Posted on April 24, 2019 by

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

Posted on April 22, 2019 by

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

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

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