SQL Server on Linux: Scatter/Gather == Vectored I/OMoved from: bobsql.com Scatter/gather capabilities allow more efficient memory to disk transfers reducing redundant memory copies, sorting […] 23 février 2022 dans Sites Microsoft par MS Tech Community
SQL Server On Linux: Core-minidumps and BreakpadMoved from: bobsql.com As pointed out in my previous post, debugging on Linux brings a few new twists to […] 23 février 2022 dans Sites Microsoft par MS Tech Community
How It Works: SQL Server Deadlock Trace Flag 1222 OutputMoved from: bobsql.com The trace flag 1222 can be very powerful and helpful in tracking down the cause of a […] 23 février 2022 dans Sites Microsoft par MS Tech Community
SQL Server Mysteries: The Case of the Suspended, Awaiting Command, ...Moved from: bobsql.com I ran into a scenario showing my session as suspended, awaiting command and blocked! My first thought was that […] 23 février 2022 dans Sites Microsoft par MS Tech Community
SQL Server Management Studio Provides–“XE Profiler”Moved from: bobsql.com Bob Ward and I worked with our SQL Server Tool developers (thanks David) to […] 23 février 2022 dans Sites Microsoft par MS Tech Community
How It Works: SQL Server DTC (MSDTC and XA Transactions)Moved from: bobsql.com I have found the term DTC is used in many ways so for the […] 23 février 2022 dans Sites Microsoft par MS Tech Community
SQL Server on Linux: Kerberos Troubleshooting, Hints and Tips and ...Moved from: bobsql.com SQL Server on Linux uses the GSSAPI and SSSD service for Active Directory (AD) authentication activities. Thus, Kerberos […] 23 février 2022 dans Sites Microsoft par MS Tech Community
SQL Server on Linux: CU4 – NewSequentialId() – UuidMoved from: bobsql.com Prior to SQL Server 2017 CU4 for Linux (Linux only) the generation of a sequential UUID […] 23 février 2022 dans Sites Microsoft par MS Tech Community
SQL Server 2017 Improved Resource Usage On Smaller MachinesMoved from: bobsql.com What does improving resource usage on smaller machines really mean? https://support.microsoft.com/en-us/help/4078095 SQL Server is designed […] 23 février 2022 dans Sites Microsoft par MS Tech Community
SQL Server on Linux: Why Do I Have Two SQL ...Moved from: bobsql.com When starting SQL Server on Linux why are there two (2) sqlservr processes? […] 23 février 2022 dans Sites Microsoft par MS Tech Community
Meme Week: SET DEADLOCK_PRIORITY HIGHHey, this seems harmless. Seriously, don’t SET DEADLOCK_PRIORITY HIGH. Even setting it to low can be a bad […] 23 février 2022 dans Sites anglophones étiqueté Locking, Blocking, and Isolation Levels par brentozar.com
Moving from ‘Chaotic’ to ‘Managed’ Database Development using FlywayThe post Moving from ‘Chaotic’ to ‘Managed’ Database Development using Flyway appeared first on SQLServerCentral. 23 février 2022 dans Sites anglophones étiqueté flyway / Vendors/3rd-party Products par sqlservercentral.com
Getting started with MySQLThe post Getting started with MySQL appeared first on SQLServerCentral. 23 février 2022 dans Sites anglophones étiqueté MySQL par sqlservercentral.com
Using Azure File and Blob Storage with Azure VMs – ...Introduction Azure provides different storage solutions that enterprises can use. This article will go through how we can […] 23 février 2022 dans Sites anglophones étiqueté AzCopy / Azure BLOB Storage / Azure Files / Azure VM / Uncategorized par sqlservercentral.com