SQL Server Database Administration Archives

Migrating On-Prem SQL to Azure SQL MI

Posted on April 30, 2025 by Zubair Shaik

Migrating SQL Jobs and Logins

Posted on April 30, 2025April 30, 2025 by Zubair Shaik

Migrating SQL Jobs and Logins from one SQL Server instance to another is a common task during server upgrades, migrations, or setting up new environments. This process involves moving SQL….

SQL Server

File Stream and File Table

Posted on April 28, 2025April 28, 2025 by Zubair Shaik

FileStream and FileTable in SQL Server: A Detailed Guide Introduction SQL Server provides a variety of ways to store and manage data, with some methods being particularly well-suited for handling….

SQL Server

Activity Monitor and DMV Usage

Posted on April 28, 2025April 28, 2025 by Zubair Shaik

Activity Monitor and DMV Usage in SQL Server: A Comprehensive Guide Table of Contents 1. Introduction to Activity Monitor in SQL Server What is Activity Monitor? SQL Server Activity Monitor….