Домашнее задание по курсу MS SQL Server Developer в OTUS. Занятие "03 - Подзапросы, CTE, временные таблицы". Задания выполняются с использованием базы данных ...

Inline subqueries in the SELECT or WHERE clauses are notorious for causing performance issues. When you use subqueries, you force SQL Server to process data in isolation, instead of creating an ...

What is the current behavior? executing sp_blitz returns result table, but also throws an error message. Msg 512, Level 16, State 1, Procedure #sp_Blitz, Line 9862 ...

A subquery in SQL Server is a query nested inside another query. Subqueries are often used to perform operations that depend on the results of another query. They can be placed in various parts of a ...

At today's kickoff for Microsoft Ignite, the company announced that SQL Server 2025 is finally coming. No timing was announced for the release, but based on prior versions, I would expect to see a ...

In announcing SQL Server Management Studio (SSMS) 21 Preview 1 this week, Microsoft revealed Copilot AI for the tool is also being previewed, privately. A Copilot for the tool that helps users manage, ...

Creating a Failover Cluster in the Windows server ensures high availability and reliability for apps and services. In this article, we will explain how to create a failover cluster in Windows Server, ...

Ahead of Microsoft Build (and a possible SQL Server announcement), let's break down what we know and speculate about what we don't. One topic that has come up in several conversations with customers ...

In the modern digital landscape, data privacy has become a paramount concern. As individuals and organizations seek to harness the power of artificial intelligence (AI) while maintaining control over ...

The next version of Windows Server is coming soon, and in this article I'll look at some of the improvements and new features. Recently Microsoft held a Windows Server summit, full of (pre-recorded ...