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 snippet will return a count of the number of tables in a database. Make sure to change the “use” statement to the required database name USE YOUR_DATABASE_NAME SELECT COUNT(*) from information_schema.tables WHERE table_type = ‘base table’
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 …
Getting a list of databases on a MS SQL Server The below query will return a list of none system databases on a Microsoft SQL Server; SELECT name FROM master..sysdatabases WHERE dbid > 4 Or you can run the below …
