I understand SSMS supports Azure DW, that should make it even easier to add the support for APS/PDW in SSMS.

Microsoft APS : Please increase Sessions from current 32 (Load 10 ,Query 22) to greater than 64

Justification : in real world we are seeing more adhoc users usage + Loads so 32 is very small which is creating huge ripple effect on APS Query Performance & user satisfaction.

I've had to create an audit process using a control table that holds the primary key columns for all the tables and a procedure that spins through all the tables looking for duplicate counts based off those keys. After 2 years of adding tables with no validation for this, the first time I ran the audit 6 months ago, it found duplication in more than 10-20% of our tables. We're still cleaning up our legacy ETL feeds and removing duplicates. Looking for and cleaning up duplicates after they hit the system is very inefficient.

We have a naming standard for our indexes but since we can't script the name of the index in a create table command, we have to use a separate create index command. This is a bit of a hassle when moving objects around. Viewing the code of a table in Visual Studio does not include the index names so when we use this function we have to manually change the script it generates.

Hi,

When you enable TDE on database in PDW, AU7 it does not compress the backup, this results in double backup size than AU4. We have to enable TDE due to Security requirement as we have some personal information.
There is financial implication an more storage is required and more data to backup to tape. If service is handled by third party, then there is administration cost increased as well.

Native SQL Server 2016 supports backup compression with TDE enabled. It is just matter or enabling as per bellow link:

https://blogs.msdn.microsoft.com/sql_server_team/backup-compression-for-tde-enabled-databases-important-fixes-in-sql-2016-sp1-cu4-and-sql-2016-rtm-cu7/

Right now the only supported way to backup APS is to an IP Address (UNC path), please add the ability to backup to a FQDN path.

Extend DMVs definition in order to allow fields greater than 4000 chars, so to be able to see the entire text of a submitted command.

Many of our tables have VARCHAR(MAX) columns which means we cannot use columnstore indexes. This limits performance of these tables. Please allow support for columnstore with varchar(max) as per SMP editions of SQL Server.