SQL Script – Report a databases table sizes in megabytes
The below SQL script will return a list of tables in a database along with the table sizes in MB. You will get a report like the below;
The below SQL script will return a list of tables in a database along with the table sizes in MB. You will get a report like the below;
Disabling and Enabling All SQL Server Agent Jobs As part of a recent Microsoft SQL Server migration project I had a need to disabled and enable all of the Agent Jobs as various points, the below scripts did the job. This …
In this post you will find some method of return some helpful information for Microsoft SQL Get a list of databases The below query will return a list of none system databases on a Microsoft SQL Server; Or you can …
Problem: Recently I had a need to upgrade our VMware vCenter server from 4.0 to 4.1 and also as the current server was on a 32-bit OS so I also needed to migrate to a new server. I started following …
The aim of this article is to configure Microsoft System Centre Configuration Manager 2007 SP1 or R2 to report on the locally installed printers, this in my case is very useful for reporting on printers installed and shared on our …