PowerSehll : How to suppress the table heading and remove the blank space from a text file

There are a multiple ways to suppress and remove the first line from text file. The first scenario would be writing...

PowerShell – SQL Databases Backup Status Report of Multiple Servers

 
This post is a requirement from one of my blog reader.
There are plenty of scripts available to get the backup...

MongoDB : How to get Top, Bottom,Middle and Range of records

In MongoDB,the limit() method is used to limit the result set to be returned. You can also use this with various...

MongoDB – Insert,Update,Upsert and Delete Examples – CRUD

In MongoDB we have to use either insert() or save() method to add the document to a collection

Insert Single document
> db.employee.insert( 
    {"employee_id":1101, 
    "name":"Prashanth", 
    "sal":90000, 
    "dob": newDate(1983,2,3,5,20), 
    "department": 
        [ 
            'DB Amdin','DB Developer' 
        ], 
    "Location":"New York"});
Insert Multiple...

MongoDB – How to Copy Database

Using copydb
Run the copydb under admin database with from,to, host parameters
>use admin
switched to db admin
> db.runCommand({ copydb: 1, fromdb: “test”,...

MongoDB – List All the databases

The function getDBs() function returns all the database list
db.getMongo().getDBs()
The runCommand is a special type of query called a database command and...

SQL DB Details Of Multiple Servers Using PowerShell

 
One of my blog reader requested me to get the DB details(Server,DBName,Size,SpaceAvailable,LogSize,PercentUsed Log Space,compatiblilty mode, recovery model etc:-) using PowerShell...

MongoDB -Get Total datasize of all DB’s

var sum = 0; db.getMongo().getDBs()[“databases”].forEach(function(x) { sum += db.getMongo().getDB(x.name).stats().dataSize }); print(sum );

OR
db = db.getSiblingDB(“admin”);
dbs = db.runCommand({ “listDatabases”: 1 }).databases;
var sum1=0;dbs.forEach(function(database) { sum1+=db.getMongo().getDB(database.name).stats().dataSize }); print(sum1);

MongoDB – Drop database

The dropDatabase command drops the current database, deleting the associated data files.
Different methods to drop database

Method 1:
1. select the database...

MongoDB -Get Size, RowCount, CollectionSize

There are two different ways of getting the desired result
The first method is iterating through each collection using for loop...