Oh BTW, On top of compression, you may also want to fiddle around with following settings to see what works best for you !

--Media Set Options
 ...

This may be a start

;With cteSel as (
Select cUser, dDate, rank() over ( partition by cUser Order by cUser, dDate desc) UserDateRank
from #tmp_UserDates
) 
Select distinct *
from cteSel
where...

Compressed backups are available on every edition except Express Edition  !...

SSMS-Setup-ENU.18.8.exe /Passive DoNotInstallAzureDataStudio=1 /install /quiet /norestart /log SSMS_install.log

ref: last line of this paragraph

• This reply was modified 4 years, 5 months ago by Johan Bijnens.

Did you try

select convert(decimal(22,2), Case when Sum(@q *COALESCE(NULLIF(COALESCE(@Weight, 0), 0), 0.01)) < 0.01 then 0.01
else Sum(@q *COALESCE(NULLIF(COALESCE(@Weight, 0), 0), 0.01)) 
end )

That is a concern you should have expressed during the interview.

If you want it to be interpreted correctly ... ask your MS representative.

• This reply was modified 4 years, 5 months ago by Johan Bijnens.

I hope this can help out

We use DNS Aliasses for most of our sqlserver servers.

Hence connections to myco-dev-proj\Instance001 will get pointed to effectiveDevServer999\Instance001

We keep instance names unique !

When preparing an upgrade by new server installation,...

• did you hit the refresh button in SSMS ?
• can you see the job active in SQLAgent

  

...

Check: https://www.sqlservercentral.com/articles/using-database-master-keys-in-sql-server

I haven't tested SSB with AGs myself. #blush# ( because we do not use it in that way )

because the log backup actually resets marks the log to be overwritten.

Preceding a full backup, you are sure that the next log backup will no longer contain encrypted log data.

only TCP/IP active ? ( Check SQL Server 20** Configuration Manager / Network Configuration )

we actually need your full bcp command to figure out what's going on.

REM Create_FMT_files
bcp "[yourdb].[yourschema].[yourtableorview]" format NUL -fD:\BCP\BCPExp\yourdb_yourschema_yourtableorview.fmt -S yoursqlserver -U sqluser-P sqlpwd -n  -o D:\BCP\BCPExp\yourdb_yourschema_yourtableorview_fmt.log...

• This reply was modified 4 years, 5 months ago by Johan Bijnens.
• This reply was modified 4 years, 5 months ago by Johan Bijnens.

yes, you can.

ALTER DATABASE [master] SET COMPATIBILITY_LEVEL = 130

Do you have proprietary objects deployed in master db ?

if yes, can you check they are still working as...