Of course, it’s frustrating to discover a corrupted database on your SQL Server for apparent reasons. You can’t access the information, and your work stops. However, you can fix this problem in many ...

Sometimes, you may be unable to perform a sync on the server. Maybe you’re trying to sync a resource that doesn’t exist, or maybe you’ve got too much data and ...

The SQL Repay tool was created since SQL Server's Replay feature is based on SQL Server Profiler traces rather than SQL Server Extended Events. Other key features of the SQL Replay tool: We don't want ...

If you are asking “GUI-what?”, not to worry, you aren’t alone. A GUID is a Globally Unique Identifier that helps manage the relational data in the Common Data Service for Apps and SQL Server.

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of changes to your data. Here's how to both create those tables and alter existing tables so they track the ...

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of. SQL Server 2016 provides ...

This post was authored by Scott Konersmann, Partner Engineering Manager, SQL Server, Slava Oks, Partner Group Engineering Manager, SQL Server, and Tobias Ternstrom, Principal Program Manager, SQL ...