Few days ago a client requested the configuration of MSDTC (Microsoft Distributed Transaction Coordinator). NOTE: If you want to know more about it here is a nice FAQ from Microsoft blogs - MSDTC Recommendations on SQL Failover Cluster? The client has 2 machines: one an application server and one a database server. Both run on Windows Server 2016 OS and, the database server runs SQL Server 2016 using Availability Groups feature (where their databases resides).
One of the good things, when we have new clients, is that sometimes they have needs that you never heard before. This does not necessarily mean that they are complex. As a matter of fact, they can be really simple..now the question is..are they doable? :-) From my experience, this can happen mainly because one of two reasons, they have some very specific need, or because the way the application is built will make you work with features that you haven’t played yet.
This post is to answer the question: “You are used to seeing in the format of yyyy-MM-dd right?” that I have raised on my blog post Don’t cutoff yourself with dates in T-SQL – Did you know…. As you could see from that blog post, my screen shots were from VSCode and in this case using mssql extension, but this happens also on SQL Server Operations Studio. “But why are my datetimeoffset values on VSCode being showed in that format?
On my last article I shared how we can now Contribute to Microsoft Documentation. Today I bring another quick tip on Microsoft Documentation! Download Microsoft Documentation Did you know that we can download PDF files with Microsoft Documentation? I did not know until my colleague called my attention to it few days ago. Important note: This tip is not (yet?) available for all Microsoft’s product suite. You should confirm if this tip applies to the product you need.
Times have changed and Microsoft has changed the way we can contribute for documentation! We already have access to the source code from some programs. One example is PowerShell, that has an GitHub repository where anyone can contribute! Now anyone can contribute to the documentation too! How and where? If you haven’t seen before, now we have a pencil icon on the top right corner that makes possible to suggest a change.