DBblogger | Rajendra Gupta

SQL Database Backups using DBATools PowerShell Module

Want to learn how to set up a PowerShell DBA environment? Here's how to configure it for SQL Server backups. T

Space used by Individual tables in SQL Server

Learn how to manage SQL Server space used by individual tables with this tutorial. Read more here.

SQL Server Dynamic Management View(DMV)- sys.dm_exec_requests

Execute the sys.dm_exec_requests DMV in SQL Server Management Studio to get the status of the backup or restore operations.

Get SQL Server Configuration using T-SQL

As a SQL architect or database administrator, it is required to know how to get SQL Server configuration using T-SQL. This post will share

SQL Server – Retrieve Physical Cores, Physical and Virtual CPUs, and Processor type information

Today's post describes SQL queries to get the following information about the processors of a SQL Server instance: 1. The total number of ph

1,035 views0 comments