Availability Groups – a hybrid of SQL Server Database Mirroring and Windows Failover Clustering – are becoming the de-facto standard for implementation of high availability solutions for Microsoft SQL Server. While the learning curve...

Earlier this month Microsoft released version 16.5.2 of SQL Server Management Studio. Customers identified issues with the release causing Microsoft to pull the download. The replacement is now available.

If you are looking to create an application to monitor or track a process and do not want to have to write much code, take a look at Power Apps and Flow.  These products are designed to be able to provide a more self-service development environ...

Microsoft continues to release updates to the flagship management tool for SQL Server, Management Studio, on their monthly cadence. The latest version just went public and is available for download here...

In this article, I provide a few tips concerning working with temporal tables, such as presenting the period column values in a desired target time zone, presenting degenerate intervals and an optimization used by the CONTAINED IN subclause.

In an earlier article I wrote of "orphaned logins": logins that have a sid mismatch with an associated database user. I had a reader ask if there was a process for identifying yet another aspect of failed connectivity: logins where the...