SQL Server Blog

Options
3,183
DavidEngelMS on Jan 30 2023 09:00 AM
4,499
David-Engel on Jan 20 2023 09:45 AM
2,362
David-Engel on Jan 13 2023 02:35 PM
2,979
David-Engel on Jan 13 2023 02:29 PM
2,442
David-Engel on Dec 16 2022 01:04 PM
12.2K
David-Engel on Dec 16 2022 12:58 PM
1,547
David-Engel on Dec 15 2022 08:30 AM
2,068
David-Engel on Dec 09 2022 08:00 AM
5,158
David-Engel on Dec 05 2022 05:19 PM
2,554
David-Engel on Nov 10 2022 04:15 PM
1,709
David-Engel on Nov 03 2022 05:07 PM
6,581
David-Engel on Nov 03 2022 02:54 PM
3,235
David-Engel on Oct 26 2022 04:18 PM
2,903
David-Engel on Oct 21 2022 08:00 AM
3,525
David-Engel on Oct 13 2022 04:29 PM
1,705
David-Engel on Sep 14 2022 05:12 PM
1,334
David-Engel on Sep 14 2022 11:00 AM
2,276
David-Engel on Sep 14 2022 09:00 AM
2,841
David-Engel on Sep 13 2022 04:54 PM
1,592
David-Engel on Aug 31 2022 09:00 AM
2,230
David-Engel on Aug 12 2022 03:00 PM
5,356
David-Engel on Aug 09 2022 03:34 PM
5,625
David-Engel on Aug 09 2022 03:19 PM
6,333
David-Engel on Aug 08 2022 09:40 AM
12.6K
David-Engel on Jul 13 2022 01:20 PM
1,535
David-Engel on Jun 23 2022 11:00 AM
1,902
David-Engel on Jun 17 2022 03:37 PM
2,666
David-Engel on Jun 17 2022 09:00 AM
3,301
David-Engel on May 13 2022 10:47 AM
1,721
David-Engel on Apr 22 2022 10:34 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