Windows - Spiderip-Blog

Published September 27, 2019 by admin

Export SQL Agent jobs with steps and scripts using SQL Command

Use the below SQL command to list all SQL server jobs USE [msdb] select spider.name, steps.step_id, steps.step_name, steps.command from

Windows

Export SQL Agent jobs with steps and scripts

comments

Published August 27, 2019 by admin

Validating commit log messages in VisualSVN Server

If you are using Visual SVN server 3.9 You can add the pre-commit hook using the following steps 1.Take the properties of the SVN project and click

Windows

svn visual svn hook pre commit hook

comments

Published January 10, 2019 by admin

IIS url rewrite one folder and sub-content to another domain with query string

IIS URL rewrite one folder and sub-content to another domain with query string I had one Wordpress Blog hosted on an IIS server and moved to a

Windows

iis url rewrite

comments

Published January 01, 2019 by admin

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'.

error CS0012: The type 'System.Object' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Runtime,

Windows

System.Object iis System.Runtime

comments

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 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 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

Export SQL Agent jobs with steps and scripts using SQL Command

Validating commit log messages in VisualSVN Server

IIS url rewrite one folder and sub-content to another domain with query string

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'.

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

MSSQL list all databases size

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

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