Haven't used SSMA for Sybase but have for Oracle to SQL Server. I think it's worth a look into, especially given SQL Server's shared history with Sybase and they both...

Is this still happening? This happens quite a lot in my environment and if accounts/SPNs are setup correctly it is usually the result of browser policies not trusting the site...

Like others I never had the opportunity to attend the PASS Summit but I did attend a couple of SQL Saturdays and a few local PASS chapter events (the early...

Yep, in addition to what was already mentioned in the article the SQL agent jobs related to a subscription will also need to be kept in sync between replicas. I...

Haven't really used TNSPing but looking at descriptions of it the utility just seems to verify connectivity to the Oracle db on the IP and port that Oracle is listening...

You cannot do an in-place downgrade, you'll have to:

•  Install a new SQL Server 2014 instance
• Script out the databases you want to bring from 2017 to 2014 (with something...

For question #1 another thing to keep in mind is that expiration date is a property that SQL Server does not honor. So even if the certificate is expired TDE...

Did you ever figure this out? Just curious because I did not see it, but what are your min/max server settings set to on the instance where the restore is...

How are the symmetric keys encrypted? Is it with a certificate?

Is this an SSRS instance or a PBIRS instance? Seems like this is a known issue with PBIRS that is probably not going to change.

https://community.powerbi.com/t5/Issues/Branding-issues-not-fixed-made-worse-with-October-2017-GA/idi-p/295246

Is this an upgrade or a migration? If it is a migration and cost is your limiting factor have you looked into installing SQL Server on Linux?

I second Terminals if you can get it at your place of work. It works great.

What happens if you try the install from a config file or command prompt switches, specifying Latin1_General_CI_AS as your collation?

I'm not so sure about that. gMSAs can be used for things like scheduled tasks and IIS app pools. I think it more depends on if a particular app is...

• This reply was modified 4 years, 9 months ago by  Joie Andrew.

Run:

EXEC sp_msforeachdb
'USE [?];
SELECT 
    TABLE_SCHEMA, 
    TABLE_NAME, 
    DB_NAME() AS "DATABASE_NAME" 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_TYPE = 'Base Table';';

against...