Error 8501 says MSDTC on server is unavailable, often while configuring replication. Start the Distributed Transaction Coordinator service to fix it.
datetime: Read Its Fractional-Second Rounding
datetime does not preserve every millisecond despite displaying three fractional digits. These typed conversions show its legacy rounding alongside the original datetime2 text.
SQL SERVER – Enumerations in Relational Database – Best Practice
Marko Parkkola from Finland shares a best practice for enumerations in relational database design: the right way to store them and one clearly wrong way.
SQL SERVER – Fix : Error : 3117 : The log or differential backup cannot be restored because no files are ready to rollforward
A reader restored a full backup, then hit Error 3117: the log or differential backup cannot be restored. Here is why it happens and what to do.
Reading a Network Trace of a SQL Server Connection
Read a network trace of a SQL Server connection by separating TCP, pre-login, TLS, login, and first-query delays before tuning queries.
JSON_ARRAY: Choose Whether NULL Elements Are Included
JSON_ARRAY constructs typed array text. Choose whether missing inputs disappear or remain JSON null placeholders before relying on positions.
SQL SERVER – Mirroring Configured Without Domain – The server network address TCP://SQLServerName:5023 can not be reached or does not exist
My friend kept getting the server network address cannot be reached error while testing mirroring configured without domain on his laptop. Here is why.