SQL Server Blog

Options
2,279
uc-msft on Jan 03 2023 08:59 AM
684
SQL-Server-Team on Mar 23 2019 05:53 PM
983
SQL-Server-Team on Mar 23 2019 05:52 PM
1,751
SQL-Server-Team on Mar 23 2019 05:51 PM
2,151
Kyle Weller on Mar 23 2019 05:49 PM
608
SQL-Server-Team on Mar 23 2019 05:43 PM
1,190
SQL-Server-Team on Mar 23 2019 05:40 PM
997
SQL-Server-Team on Mar 23 2019 05:39 PM
988
Kyle Weller on Mar 23 2019 05:38 PM
1,018
SQL-Server-Team on Mar 23 2019 05:38 PM
2,517
Kyle Weller on Mar 23 2019 05:38 PM
547
SQL-Server-Team on Mar 23 2019 05:36 PM
705
SQL-Server-Team on Mar 23 2019 05:32 PM
1,188
SQL-Server-Team on Mar 23 2019 05:21 PM
688
SQL-Server-Team on Mar 23 2019 05:20 PM
481
SQL-Server-Team on Mar 23 2019 05:12 PM
793
SQL-Server-Team on Mar 23 2019 04:59 PM
782
SQL-Server-Team on Mar 23 2019 04:57 PM
529
SQL-Server-Team on Mar 23 2019 04:55 PM
629
SQL-Server-Team on Mar 23 2019 04:54 PM
927
SQL-Server-Team on Mar 23 2019 04:51 PM
865
SQL-Server-Team on Mar 23 2019 04:49 PM
649
SQL-Server-Team on Mar 23 2019 04:48 PM
522
SQL-Server-Team on Mar 23 2019 04:48 PM
470
SQL-Server-Team on Mar 23 2019 04:42 PM
703
SQL-Server-Team on Mar 23 2019 04:40 PM
2,446
SQL-Server-Team on Mar 23 2019 04:40 PM
799
SQL-Server-Team on Mar 23 2019 04:39 PM
4,939
SQL-Server-Team on Mar 23 2019 04:39 PM

Latest Comments

@DavidYorkshire Following up on your statement that WSUS isn't consistently for updates, with the example that new versions of Windows OS have been available through WSUS for years. Correct. You can update from Windows 8 -> 8.1 ->10 -> 11, or Windows Server 2016 -> 2019 -> 2022 and presumably -> 202...
0 Likes
@sgtmango333 We don't overwrite settings with any upgrade (minor or major). You have to import settings from a previous version to update them. We understand there is additional effort related to connection settings with SSMS 20 - that is why we shared information about the release in advance and no...
0 Likes
I understand the intent, but that makes life a difficult for those using a Central Management Server with hundreds of instances. That means that every one on my team must now connnect to every server and update this setting just to maintain functionality after installing version 20. So next question...
0 Likes
@TarynPratt wrote:At this point, patching SQL Server on Azure VMs through Azure Update Manager or Automated Patching via the SQL IaaS extension is not aware if the SQL Server is a part of an Always On availability group. It is important to keep this in mind when scheduling your updates with an autom...
1 Likes
@sgtmango333 I missed your question, apologies. It is not possible to set the default value for the Encryption property to optional. With SSMS 20 we upgraded to MDS 5.x, which sets Encryption to Mandatory (true) by default. We intentionally decided to stay with the default, to encourage folks toward...
1 Likes