Skip to content
spiderip logo
Published November 09, 2018 by admin

MSSQL list all databases size

We can retrieve database sizes using below query: 1. with fs as ( select database_id, type, size * 8.0 / 1024 size from sys.master_files ) select

Read More MSSQL list all databases size

Windows

MSSQL

comments

Published October 29, 2018 by admin

The WebResource.axd handler must be registered in the configuration to process this request

The WebResource.axd handler must be registered in the configuration to process this request There are 2 steps to solve this issue 1.Change the

Read More The WebResource.axd handler must be registered in the configuration to process this request

Windows

WebResource.axd

comments

Published October 19, 2018 by admin

Powershell Move all files from folders and subfolders into single folder

Here's the PowerShell script to Move all files from folders and subfolders into a single folder Get-ChildItem -Path source -Recurse -File | Move-Item

Read More Powershell Move all files from folders and subfolders into single folder

Scripts

olders and subfolders into single folder

comments

Published October 10, 2018 by admin

Powershell script to connect to office365 with username and password

Here is the PowerShell script to connect to office365 with username and password and run queries. $Office365Username =

Read More Powershell script to connect to office365 with username and password

Scripts

office365

comments

Published August 13, 2018 by admin

SQL Server shrinkdatabase of all databases in MSSQL Server

Best Practices https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkfile-transact-sql?view=sql-server-2017 Consider the

Read More SQL Server shrinkdatabase of all databases in MSSQL Server

Windows

SQL

comments

Published August 13, 2018 by admin

Get list of databases from SQL Server

Execute this query to list of databases from SQL Server SELECT name FROM master.dbo.sysdatabases

Read More Get list of databases from SQL Server

Windows

SQL Tsql

comments

Published August 09, 2018 by admin

Postgres database with compressed option on windows

Here is a simple command to take Postgres Database backup with Compress option pg_dump -Fc dbname > filename Here is the official document from

Read More Postgres database with compressed option on windows

Windows

Postgres pg dump

comments

Published August 02, 2018 by admin

iisexpress.exe has exited with code 0 in visual studio 2015 on windows 10 machine

After Installing Visual studio Ent version 2015 on Latest Windows 10 Version I am getting the following error during the project run. iisexpress.exe

Read More iisexpress.exe has exited with code 0 in visual studio 2015 on windows 10 machine

Windows

iisexpress vs2015

comments

Published July 27, 2018 by admin

Install and configure OpenVPN server and route all client internet traffic through VPN tunnel

Install and configure OpenVPN server and route all client internet traffic through the VPN tunnel. My Test environment is Server: Windows Server 2012

Read More Install and configure OpenVPN server and route all client internet traffic through VPN tunnel

Windows

openvpn vpn

comments

Published July 16, 2018 by admin

linux disk space full but no files

Suddenly one of the Linux servers shows disk space is full but couldn't find huge files on the drive. This is due to that a process has opened a

Read More linux disk space full but no files

Linux

linux disk du df lsof

comments

  • « Prev
  • 1
  • 2
  • 3
  • 4
  • Next »

Recent Posts

  • Export SQL Agent jobs with steps and scripts using SQL Command
  • Validating commit log messages in VisualSVN Server
  • Linux copy folder structure without files to a new location
  • PowerShell script to send email using Amazon SES with credentials
  • IIS url rewrite one folder and sub-content to another domain with query string

Popular Posts

  • Powershell script to import a certificate to the local machine trusted root certificate store
  • TortoiseSVN overlay icons not showing in windows 10
  • Powershell Invoke-WebRequest ignore certificate warning
  • error CS0012: The type 'System.Object' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Runtime, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.
  • PowerShell script to Remotely Enable a Local administrator Account and set a password.

Archive

  • ▼ 2019 (7)
    • September (1)
    • August (1)
    • February (1)
    • January (4)
  • ► 2018 (33)
    • November (4)
    • October (3)
    • August (4)
    • July (7)
    • June (8)
    • May (2)
    • April (5)

Popular Tags

  • linux (3)
  • powershell (3)
  • disk (2)
  • SQL (2)
  • iis (2)

Spiderip-Blog

Spiderip blog offer latest powershell scripts and resources