SQL Server Blog

Options
1,316
TarynPratt on Apr 15 2024 06:43 PM
1,093
HarveyMoraSQL on Apr 11 2024 04:14 PM
1,077
HarveyMoraSQL on Apr 09 2024 02:03 PM
973
HarveyMoraSQL on Apr 09 2024 02:03 PM
1,252
HarveyMoraSQL on Apr 09 2024 02:03 PM
1,174
HarveyMoraSQL on Apr 09 2024 02:02 PM
7,514
DavidEngelMS on Apr 09 2024 11:10 AM
1,346
EbruErsan on Apr 03 2024 01:17 PM
12K
erinstellato on Mar 19 2024 11:18 AM
1,707
SrinivasSQL on Mar 14 2024 04:37 PM
9,609
erinstellato on Feb 29 2024 03:50 PM
4,828
DavidLevy on Feb 28 2024 02:49 PM
3,600
Venkata Raj Pochiraju on Feb 26 2024 09:06 AM
2,077
DavidEngelMS on Feb 16 2024 02:42 PM
2,110
DavidEngelMS on Feb 16 2024 02:35 PM
1,784
DavidEngelMS on Feb 16 2024 02:02 PM
17.3K
erinstellato on Feb 16 2024 10:51 AM
2,154
SrinivasSQL on Feb 15 2024 01:54 PM
3,259
DavidEngelMS on Jan 31 2024 09:00 AM
1,908
DavidEngelMS on Jan 31 2024 09:00 AM
1,803
EbruErsan on Jan 26 2024 12:45 AM
2,334
SrinivasSQL on Jan 11 2024 06:45 PM
1,844
SrinivasSQL on Jan 10 2024 09:50 AM
2,260
SrinivasSQL on Jan 10 2024 09:40 AM
11.5K
DavidEngelMS on Jan 09 2024 11:34 AM
3,063
SrinivasSQL on Dec 14 2023 04:39 PM
5,632
Venkata Raj Pochiraju on Dec 12 2023 07:07 PM
2,945
SrinivasSQL on Nov 30 2023 01:59 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