Bad installer. You need to get the version for Express with advanced services. So, uninstall/reinstall or add a named instance.

The 2016 forums weren't expanded by default. My apologies for...

It's not quite clear what you mean. I think you need to provide more DDL and sample data to show something.

If you're matching on 'Wed', then isn't F10 always Wednesday,...

To add to what Jeff said, once you use the Table Designer to make changes, don't click "save".

Instead, use Table Designer | Generate Change Script or click the icon that...

I'm not sure. I believe that the underlying WSFC can work for an AG.

As far as using the database in the AG for SSAS, I assume using the virtual instance/db...

I understand concerns, but remember, Jeff, no code is ever unchecked. Part of the process is ensuring that code runs through a set of checks, whatever those are. Those can...

Don't confuse clustering (WSFC or FCI, depending on Windows version) with Availability Groups. They're separate.

I'm not an SSAS expert, but there isn't a database per se, correct? Isn't there a...

I think you can do this. It appears the WSFC will work with SSAS, which I think means NLB isn't needed. The resource should appear as a clustered item with...

I think I was confused as to what you were looking at. I see now since there aren't two CustomerName items in each element that there's a good chance that...

TomThomson (6/23/2016)

---

Not a very good question, because the answer (at least for SQL Server 2012, SQL server 2014, and SQL Server 2016) depends on whether the index is partitioned or...

A couple things. First idea is that there isn't any order here. So there isn't a "first" concept. I'm hoping you realize that. With that in mind, other than order,...

First, are you trying to create HA for SSAS? Meaning you want SSAS to live on the cluster and fail from one node to the other? I did see this,...

Is Performance Advisor running under a developer account?

You don't need to set SQL Server in single user mode to use the DAC. This is a single threaded connection available for adminstrators that doesn't get resources blocked by...

You should also be sure your VM has resources. A database server VM is not like some other file server, print server, etc. VM. This needs more resources, more minimums,...

Perhaps. It seems that there are people that use R to do analysis in business over and over, on datasets that are refreshed as new data comes in. SQL Server...