MS SQL – Copying a Linked Server Table
I recently used the following TSQL on a Microsoft SQL server to create and populate a table ...
Read More
Category: SQL
PowerShell – how to save an SQL query results to aN CSV file
The following is an example PowerShell script to connect to a Microsoft SQL Database and dump the...
Read More
SQL Snippet – Get the number of tables in a database
The below SQL snippet will return a count of the number of tables in a database. Make sure to...
Read More
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....
Read MoreDisabling and Enabling All SQL Server Agent Jobs
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 scripts...
Read More
Getting a list of databases on a MS SQL Server
Getting a list of databases on a MS SQL Server The below query will return a list of none system...
Read More
Recent Comments