Script to Delete SQL Server Data in Batches
In this tip we cover a T-SQL script that allows you to batch delete older data from tables and save the deleted records to an archive table.
Alejandro Cobar is an MCP, SQL Server DBA and Developer with 10+ years of experience working in a variety of environments.
- MSSQLTips Awards: Author of the Year - 2020 | Rising Star (50+ tips) - 2021 | Author Contender - 2019, 2021
SQL Server Backup Size vs Database Size Script
In this article we look at different ways to determine how much disk space is needed for a SQL Server database restore prior to restoring a database.
Inventory SQL Server Agent Jobs for all Instances with PowerShell
In this tip we look at a PowerShell script you can use to gather information about all SQL Server Agent jobs on all SQL Server instances in your environment for quick reporting and analysis.
Find SQL Server Installation Date for all Instances with PowerShell
In this tip we look at a PowerShell script you can use to gather information about the installation date for all of your SQL Servers.
How to Check Monthly Growth of Database in SQL Server
In this tip we look at a way to trend the growth of a SQL Server database by looking at the sizes of database backups over time.
SQL Server Configuration Settings Query
In this tip we look at a script that gives a quick overview of SQL Server configuration settings like memory, parallelism, version, edition, patch level, etc.
Collect SQL Server Index Usage for All Instances with PowerShell
In this tip we look at a PowerShell script you can use to collect index information for all of your SQL Server instances that you manage.
Get SQL Server MSDB Size and Largest Table for All Instances
Check out this PowerShell script that will help identify size of the MSDB database as well as the largest table in the database across all of your instances to make decisions on the needed SQL Server maintenance.
Synchronize SQL Server Agent Jobs for Database Mirroring
In this tip we look at a PowerShell script that can be used to find mismatched SQL Server Agent Jobs on the principal and mirror instances for database mirroring.
Powershell Script to Collect SQL Server Inventory
In this tip we look at a PowerShell script that can be used to gather data from all your SQL Server instances and databases to build an inventory list.
SQL Server Database Mirroring Missing Logins Report
In this tip we look at a PowerShell script that can help identify mismatches for logins for SQL Server Database Mirroring principal and mirror instances.
SQL Server Disk Space Monitoring for All Instances with PowerShell
Check out this tip that has a SQL Server stored procedure to find any low disk space issues for all of your SQL Server databases on all instances.
SQL Server DB Mirroring Status Check and Manual Failover PS Scripts
In this tip we have a PowerShell script that can be used to check the status of SQL Server database mirroring as well as generate the code need for a failover of the databases.
SQL Server DB Mirroring Status Check and Manual Failover TSQL Scripts
In this tip we have a script that can be used to check the status of database mirroring as well as generate the code need for a failover of the databases.
Monitor CPU and Memory for All SQL Server Instances with PowerShell
Learn how to collect cpu and memory usage for all of your SQL Server instances using PowerShell.
Auto Generate NetBackup script to backup SQL Server databases
In this tip we look at how we can use SQL Server to auto generate a backup script for NetBackup to make sure we backup the required databases.
Always On Availability Groups Monitoring and Alerting – Part 2
In this tip we look at some additional scripts that you can use to monitor your SQL Server AlwaysOn Availability Groups.
Always On Availability Group Inventory and Monitoring Scripts – Part 1
In this tip we look at scripts that can be used to monitor the status of your SQL Server AlwaysOn Availability Groups across your entire environment.
Configuring Extended Events to find Locking Issues in SQL Server
In this tip we show how to use the SSMS GUI to build an extended events session for locking in SQL Server.
Get most recent SQL Server backup information for all databases
In this tip we look at a T-SQL script that you can use to get the latest backup information for all of your SQL Server databases. In addition, there is a PowerShell option do this for multiple servers.
SQL Server Database Mirroring Inventory and Monitoring Scripts
In this tip we look at some PowerShell scripts you can use to check on SQL Server database mirroring status for your servers in your environment.
Simple Corruption Check for all SQL Server databases
In this tip we look at a SQL Server scripts to collect DBCC CHECKDB information and a SQL Agent job to schedule data collection. In addition, there is a PowerShell version included as well.