As SQL Server 2016 approaches end of support in July 2026, a look back at its groundbreaking innovations reveals how it reshaped Microsoft's data platform and why it's time to move forward. As I've ...

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

Another year passes. I was hoping to write more articles instead of just these end-of-the-year screeds, but I almost died in the spring semester, and it sucked up my time. Nevertheless, I will go ...

This repository contains the Azure SQL bindings for Azure Functions extension code as well as a quick start tutorial and samples illustrating how to use the binding in different ways. The types of ...

Abstract: In today's world, SQL Injection is a serious security threat over the Internet for the various dynamic web applications residing over the internet. These Web applications conduct many vital ...

Part of the SQL Server 2022 blog series. Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database ...

Part of the SQL Server 2022 blog series. Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database ...

We can use query store to check troubleshooting performance, Reference: https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...

If you want to do Advanced Analytics or Predictive Modeling directly into SQL Server, you can since the version 2016 thanks to SQL Server Machine Learning Services. In particular, you can take ...