Skip to content
Geeks Hangout
  • Home
  • Fixes
  • Tips
  • Scripts
  • Tools
  • About

SQL

MS SQL – Copying a Linked Server Table

January 6, 2021December 6, 2020 by Phil Eddies
sql linked server

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 …

Read more

Leave a comment

PowerShell – How to save an SQL query results to an CSV file

August 27, 2021June 3, 2018 by Phil Eddies

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 …

Read more

8 Comments

SQL Script – Report a databases table sizes in megabytes

October 10, 2021March 19, 2015 by Phil Eddies
SQL Server Banner

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;

Leave a comment

Disabling and Enabling All SQL Server Agent Jobs

December 20, 2015August 23, 2013 by Phil Eddies

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 …

Read more

Leave a comment

MS SQL Helpful Statistics Queries

February 3, 2022December 21, 2012 by Phil Eddies
SQL Server Banner

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 …

Read more

Leave a comment

Recent Posts

  • Azure Data Factory – Get and store a Key Vault secret as a variable
  • Microsoft Graph and Invoke-RestMethod [PowerShell]
  • Connect-MgGraph – Using a Service Principal [PowerShell]
  • Updating MalCare Security Plugin fails “This is usually due to inconsistent file permissions”

Recent Comments

  • Sanyi on Chrome – Silently Deploying an Extension using the Registry
  • Phil Eddies on Use VBS to populate and format Excel documents
  • Nitin G. on Use VBS to populate and format Excel documents
  • Nitin G. on Use VBS to populate and format Excel documents
© 2022 Geeks Hangout
Hosted by: Cloudways | Ads by: Ezoic | Theme: Generate Press
🛠 The Tools I Use 🛠
Ezoic Awards