Who are these scripts for? You need to troubleshoot performance problems with SQL Server, and you need to do it now. You don't have time to track down a bunch of DMVs, figure out Extended Events, ...

The “Conversion failed when converting date and/or time from character string” error in SQL Server appears when SQL Server cannot interpret a text value as a ...

A Technical Project Manager with expertise in agile methodologies, project planning, quality assurance, and more. SQL (Structured Query Language) is the universal language for managing and interacting ...

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 ...

We are pleased to announce the general availability of the Azure AD support for the the SQL Server connector. The Azure AD authentication for Azure SQL Database provides significant security benefits ...

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 ...

This blog post was authored by: Sahaj Saini, PM on the Microsoft Analytics Platform System (APS) team. In this blog post, we’ll provide a quick overview of Symmetric Multi-Processing (SMP) vs.