SQL Queries for SQL Server

Troubleshoot Slow-Running Queries In SQL Server

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...

12d

Azure SQL vs SQL Server: Which One Should You Choose for Your Next Project?

For most teams migrating an existing SQL Server estate, Azure SQL Managed Instance is the easiest starting point. It keeps the SQL Server feel, including SQL Agent and linked servers, while removing ...

Visual Studio Magazine

How to Query JSON Data with SQL Server 2016

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

Visual Studio Magazine

Working with JSON in SQL Queries

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

Redmond Magazine

Understanding Dirty Reads: What NOLOCK Does to Your Queries

Let's break down when it's ideal to use the NOLOCK hint and when you should never use it. As a consultant, I work on wide swaths of database systems, which means I get to see many, many SQL statements ...

Hosted on MSN

SQL Server gains local AI and secure RAG integration options

SQL Server 2025 is introducing AI-native capabilities alongside new approaches for secure integration with large language models. Enterprises can now run local AI models such as Llama 3 via Ollama for ...