Tag Archives: administration

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

Reserved Space

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