This script will query msdb to determine the size of data and log files for all databases, along with the average sizes of full and transaction log backups. Results are averaged over the past two weeks, but this is easily changed.
2007-01-12 (first published: 2007-01-05)
1,586 reads
This VB script will attempt to make a connection to all SQL Servers enumerated in the SQLInventory table over Named Pipes and TCP\IP. If a SQL Instance is listed, it will attempt TCP\IP connections using both port and instance name. Once the connection is established to each server using each protocol, the script will query […]
2007-01-11 (first published: 2007-01-05)
1,227 reads
By Steve Jones
I am not a great software developer. I’m OK, and I do know how...
By Steve Jones
Today’s coping tip is to appreciate your hands and all the things they do...
By alevyinroc
On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...
So I'm using SQL Server 2014 and I've been using Jeff Moden's excellent string...
I'm changing the DB Compatibility mode to 2022 in SQL Managed Instance. below features...
Hi All, We see some tables in Prod are having 20-30 indexes and we...
Ask SSC