SQL Server Blog

Options
1,144
HarveyMoraSQL on Apr 11 2024 04:14 PM
1,158
HarveyMoraSQL on Apr 09 2024 02:03 PM
1,026
HarveyMoraSQL on Apr 09 2024 02:03 PM
1,296
HarveyMoraSQL on Apr 09 2024 02:03 PM
1,232
HarveyMoraSQL on Apr 09 2024 02:02 PM
1,362
EbruErsan on Apr 03 2024 01:17 PM
1,725
SrinivasSQL on Mar 14 2024 04:37 PM
4,907
DavidLevy on Feb 28 2024 02:49 PM
2,176
SrinivasSQL on Feb 15 2024 01:54 PM
1,821
EbruErsan on Jan 26 2024 12:45 AM
2,356
SrinivasSQL on Jan 11 2024 06:45 PM
1,859
SrinivasSQL on Jan 10 2024 09:50 AM
2,279
SrinivasSQL on Jan 10 2024 09:40 AM
3,080
SrinivasSQL on Dec 14 2023 04:39 PM
2,961
SrinivasSQL on Nov 30 2023 01:59 PM
2,861
EbruErsan on Nov 19 2023 11:47 PM
2,815
SrinivasSQL on Nov 16 2023 04:57 PM
4,144
Wolfgang-Peter on Oct 13 2023 11:20 AM
2,592
SrinivasSQL on Oct 13 2023 09:03 AM
2,076
SrinivasSQL on Oct 13 2023 08:56 AM
18.5K
SrinivasSQL on Oct 11 2023 12:36 PM
2,563
SrinivasSQL on Oct 11 2023 12:31 PM
2,520
SrinivasSQL on Oct 11 2023 12:29 PM
1,912
SrinivasSQL on Oct 11 2023 12:27 PM
1,819
SrinivasSQL on Oct 11 2023 12:19 PM
1,648
SrinivasSQL on Oct 11 2023 12:17 PM
1,576
SrinivasSQL on Oct 11 2023 12:16 PM
1,669
SrinivasSQL on Oct 11 2023 12:14 PM
1,573
SrinivasSQL on Oct 11 2023 12:12 PM
1,398
SrinivasSQL on Oct 11 2023 12:08 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