SQL Server Blog

Options
2,226
SrinivasSQL on Sep 14 2023 07:27 PM
2,746
HristinaSQL on Aug 14 2023 03:59 PM
2,281
SrinivasSQL on Aug 10 2023 05:11 PM
1,972
HarveyMoraSQL on Jul 13 2023 02:56 PM
2,503
EbruErsan on Jul 10 2023 05:07 AM
2,469
HarveyMoraSQL on Jun 15 2023 03:59 PM
3,133
HristinaSQL on Jun 15 2023 03:29 PM
3,009
SrinivasSQL on May 11 2023 02:59 PM
3,004
HarveyMoraSQL on Apr 13 2023 04:10 PM
2,694
SrinivasSQL on Apr 13 2023 03:40 PM
2,994
SrinivasSQL on Mar 15 2023 07:38 PM
3,020
SrinivasSQL on Feb 16 2023 10:18 PM
3,003
HarveyMoraSQL on Feb 16 2023 04:53 PM
3,040
HarveyMoraSQL on Feb 15 2023 05:22 PM
2,735
HarveyMoraSQL on Feb 15 2023 05:22 PM
2,073
HarveyMoraSQL on Feb 15 2023 05:22 PM
2,006
HarveyMoraSQL on Feb 15 2023 05:20 PM
1,976
HarveyMoraSQL on Feb 15 2023 05:19 PM
1,714
HarveyMoraSQL on Feb 15 2023 05:19 PM
1,699
HarveyMoraSQL on Feb 15 2023 05:19 PM
1,478
HarveyMoraSQL on Feb 15 2023 05:18 PM
1,513
HarveyMoraSQL on Feb 15 2023 05:18 PM
3,120
EbruErsan on Jan 09 2023 09:23 AM
7,577
subhojitbasak on Dec 19 2022 05:35 AM

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