Archive for: 2018 - Spiderip-Blog

Published November 22, 2018 by admin

How to install Remote server Administration (RSAT) on Windows 10 1809 version

After upgrade to windows 10 1809 version, I am unable to Install RSAT tools (Remote Server Administration Tools) Starting with Windows 10 October

Windows

rsat windows 10

comments

Published November 15, 2018 by admin

MySQL Your Password does not Satisfy the Current Policy Requirements on linux machine

After installation of Mysql on one of our Linux machine I am unable to grant permission for user and getting the following error Your Password does

Linux

mysql linux validate password policy

comments

Published November 09, 2018 by admin

How to use Key Vault soft-delete with PowerShell

For an existing key vault named "spiderip", enable soft-delete as follows. Connect-AzureRmAccount ($resource = Get-AzureRmResource -ResourceId

Scripts

Azure key keyvault

comments

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

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

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

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 =

Uncategorized

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

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

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

Windows

Postgres pg dump

comments

How to install Remote server Administration (RSAT) on Windows 10 1809 version

MySQL Your Password does not Satisfy the Current Policy Requirements on linux machine

How to use Key Vault soft-delete with PowerShell

MSSQL list all databases size

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

Powershell Move all files from folders and subfolders into single folder

Powershell script to connect to office365 with username and password

SQL Server shrinkdatabase of all databases in MSSQL Server

Get list of databases from SQL Server

Postgres database with compressed option on windows

Recent Posts

Popular Posts

Archive

Popular Tags