MOST RECENT

I set up Visual Studio 2017, but the SSDT for SQL 2016 did not integrate so I am in Visual Studio 2015 Shell. I just created a Foreach Loop Container, and tried to get to the configuration screen and only ...

Jim Giercyk,

All DBAs have been asked to copy a database from one SQL instance to another. Even if the instances are identical, the relationship (SID) between the logins and table users are broken. Microsoft includes ...

Changhong Fu, SQL server AlwaysOn Availability Group

This article explains how data synchronization works on SQL Server AlwaysOn Availability Group and some details about how to use sys.dm_hadr_database_replic... table to check replica states.I borrowed ...

Alex Hildyard,

We're currently migrating our Confluence installation, and I was looking around for resources to provide some basic metrics, eg. the total number of (non-private) pages we are currently hosting. It appears ...

bconlon,

I was interested to see a tweet from Liquid Technologies promoting free licenses of its XML products for Microsoft Most Valuable Professionals (MVPs). So this got me wondering what else is available for ...