I recently used the following TSQL on a Microsoft SQL server to create and populate a table from a table on a linked servers. In my case my linked server connection was linking to a MySQL database but the same …
The following is an example PowerShell script to connect to a Microsoft SQL Database and dump the results of a query into a CSV file. You will need to change the connections variables at the top of the script along …
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 …