SQL Server Blog

Options
10.1K
DavidEngelMS on Apr 09 2024 11:10 AM
9,975
erinstellato on Feb 29 2024 03:50 PM
2,117
DavidEngelMS on Feb 16 2024 02:42 PM
2,164
DavidEngelMS on Feb 16 2024 02:35 PM
1,841
DavidEngelMS on Feb 16 2024 02:02 PM
3,303
DavidEngelMS on Jan 31 2024 09:00 AM
1,947
DavidEngelMS on Jan 31 2024 09:00 AM
11.6K
DavidEngelMS on Jan 09 2024 11:34 AM
56.1K
DavidEngelMS on Oct 11 2023 08:40 AM
2,014
DavidEngelMS on Sep 05 2023 09:12 AM
3,126
erinstellato on Aug 07 2023 12:06 PM
3,369
DavidEngelMS on Aug 03 2023 09:00 AM
2,490
DavidEngelMS on Aug 03 2023 09:00 AM
2,809
DavidEngelMS on Jul 21 2023 09:15 AM
5,046
jes_schultz on Jul 05 2023 10:51 AM
126K
DavidEngelMS on Jun 15 2023 11:13 AM
3,669
DavidEngelMS on Jun 09 2023 09:00 AM
9,786
erinstellato on Jun 08 2023 12:55 PM
2,354
DavidEngelMS on Jun 08 2023 10:45 AM
2,258
DavidEngelMS on Jun 08 2023 09:00 AM
4,626
erinstellato on May 25 2023 08:31 AM
7,675
jes_schultz on May 11 2023 06:36 AM
3,881
DavidEngelMS on May 05 2023 11:28 AM
2,061
DavidEngelMS on May 05 2023 11:00 AM
5,450
erinstellato on Apr 12 2023 10:46 AM
7,309
erinstellato on Apr 01 2023 05:51 PM
10.5K
DavidEngelMS on Mar 07 2023 10:16 AM
7,987
DavidEngelMS on Feb 15 2023 08:10 AM
4,522
DavidEngelMS on Feb 15 2023 08:00 AM
4,810
DavidEngelMS on Feb 01 2023 02:36 PM

Latest Comments

Hello Mr Banerjee. It's a really very helpful video. I have a real time scenario can you please suggest me what is your view on that ?In my current production server an architecture was decided that is going to have 2 vms for db server where 1 will be primary and 2nd will be secondary. But suddenly ...
0 Likes
@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