Articles

A Game-Changer for Database Management: Hands-On with Copilot for Azure SQL Database

As cloud technologies continue to evolve, managing and optimizing databases in the cloud has become a complex yet critical task for developers and database administrators. Microsoft Azure offers a vast array of tools and services to help streamline this process, one of which is Copilot for Azure SQL Database. This tool leverages the power of […]

A Game-Changer for Database Management: Hands-On with Copilot for Azure SQL Database Read More »

SQL Server Migration with dbatools: A Production Workflow from Start to Finish

SQL Server Migration with dbatools: A Production Workflow from Start to Finish – SQLYARD Leave a Comment / Articles, DBA Checklist / By SQLYARD SQL Server Migration with dbatools: A Production Workflow from Start to Finish By SQLYARD · SQLYARD.com · May 2026 · Estimated read: 20–25 min Most articles about dbatools list its 500-plus

SQL Server Migration with dbatools: A Production Workflow from Start to Finish Read More »

SQL Server Performance Tuning Using Wait Statistics

SQL Server Performance Tuning Using Wait Statistics – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD SQL Server Performance Tuning Using Wait Statistics By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 14–17 min Wait statistics are the starting point for every SQL Server performance investigation. When a query cannot

SQL Server Performance Tuning Using Wait Statistics Read More »

Understanding the Difference Between a Stored Procedure and a Function

Summary: When working with databases, particularly relational databases like MySQL, SQL Server, or PostgreSQL, you’ll often encounter two important types of programmable objects: stored procedures and functions. Both are used to perform operations and encapsulate reusable SQL code, but they serve different purposes and have distinct characteristics. In this blog, we’ll dive into the differences

Understanding the Difference Between a Stored Procedure and a Function Read More »

SQL Server Archive Process Using a Stored Procedure and SQL Agent Job

SQL Server Archive Process Using a Stored Procedure and SQL Agent Job – SQLYARD Leave a Comment / Articles, Scripts / By SQLYARD SQL Server Archive Process Using a Stored Procedure and SQL Agent Job By David Yard · SQLYARD.com · April 2026 · Estimated read: 15–18 min Compatibility: This approach works on all SQL

SQL Server Archive Process Using a Stored Procedure and SQL Agent Job Read More »

SQL Server 2022: Azure Integration, Query Intelligence, Security, and Data Virtualization

SQL Server 2022: Azure Integration, Query Intelligence, Security, and Data Virtualization | SQLYARD Leave a Comment / Articles, Cloud and Azure / By SQLYARD SQL Server 2022: Azure Integration, Query Intelligence, Security, and Data Virtualization By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 12–15 min SQL Server 2022 (16.x) SQL Server 2022

SQL Server 2022: Azure Integration, Query Intelligence, Security, and Data Virtualization Read More »

Exploring the Current Landscape of Analytical Systems in the Microsoft Data Platform

In our previous discussion, we delved into the realm of operational databases within the Microsoft Data Platform, recognizing the divergent nature of analytic databases such as data warehouses in the cloud environment. Operational databases prioritize hardware and architecture for optimal write throughput, contrasting with the focus of analytic databases on large batch data ingestion and

Exploring the Current Landscape of Analytical Systems in the Microsoft Data Platform Read More »

Evaluating Microsoft’s Transactional Database Solutions in the Current Cloud Environment

The rapid evolution of cloud services demands a nuanced understanding of the current state of transactional database solutions within the Microsoft Data Platform, encompassing Azure services, with a comparative exploration of options available on Amazon Web Services (AWS). Given the dynamic nature of cloud technology, what may be the optimal solution today could evolve within

Evaluating Microsoft’s Transactional Database Solutions in the Current Cloud Environment Read More »

Unleash the Power of AI with Copilot for Azure SQL Database

Unleash the Power of AI with Copilot for Azure SQL Database In the rapidly evolving landscape of technology, innovation is the key to staying ahead. Enter Copilot for Azure SQL Database, an exciting new tool that harnesses the power of artificial intelligence (AI) to revolutionize database management. Whether you’re a seasoned developer or just starting

Unleash the Power of AI with Copilot for Azure SQL Database Read More »

SQL Server Archive Process Using Filegroups and Table Partitioning

SQL Server Archive Process Using Filegroups and Table Partitioning – SQLYARD Leave a Comment / Scripts / By SQLYARD SQL Server Archive Process Using Filegroups and Table Partitioning By David Yard · SQLYARD.com · April 2026 · Estimated read: 15–18 min Compatibility: Table partitioning and filegroup-based archiving requires SQL Server Enterprise Edition (or Developer Edition

SQL Server Archive Process Using Filegroups and Table Partitioning Read More »

What is Microsoft Fabric?

Microsoft Fabric is a unified analytics solution tailored for enterprises, encompassing data movement, data science, Real-Time Analytics, and business intelligence functionalities. It presents a complete array of services, including data lake management, data engineering, and data integration, consolidated into a single platform. By opting for Fabric, there’s no need to assemble disparate services from various

What is Microsoft Fabric? Read More »

Cardinality Estimation Feedback in SQL Server 2022 and 2025

Cardinality Estimation Feedback in SQL Server 2022 and 2025 – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD Cardinality Estimation Feedback in SQL Server 2022 and 2025 By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 12–15 min SQL Server 2022 and 2025 · Azure SQL Database · Compatibility Level

Cardinality Estimation Feedback in SQL Server 2022 and 2025 Read More »

ALERT-Microsoft SQL servers backdoored with new malware

This malicious software has been infecting hundreds of servers around the globe, compromising sensitive data and causing extensive damage. The main risk of SQL Servers lies in their ability to evade detection. Many antivirus programs have trouble identifying this type of malware, and it can often slip through firewall defenses unnoticed. To protect against SQL

ALERT-Microsoft SQL servers backdoored with new malware Read More »

Overview of Service Principal Name and Kerberos authentication in SQL Server

SQL Server supports two authentication modes: Windows Authentication mode and SQL Server Authentication mode. In Windows Authentication mode, SQL Server uses Kerberos security protocol for authentication. Kerberos is a computer network authentication protocol that works on the basis of “tickets” to allow nodes communicating over a non-secure network to prove their identity to one another

Overview of Service Principal Name and Kerberos authentication in SQL Server Read More »

SQL Server 2022

SQL Server 2022 promises to be a game-changer for businesses of all sizes. For starters, the new SQL Server will include support for SQL Graph, which will enable companies to easily incorporate complex data relationships into their databases. In addition, SQL Server 2022 will offer enhanced performance and security features, making it an ideal choice

SQL Server 2022 Read More »