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...
2016-05-02
7,724 reads
There are a multiple ways to suppress and remove the first line from text file. The first scenario would be writing...
2016-05-02
7,724 reads
This post is a requirement from one of my blog reader.
There are plenty of scripts available to get the backup...
2016-04-27
3,014 reads
In MongoDB,the limit() method is used to limit the result set to be returned. You can also use this with various...
2016-04-26
9,182 reads
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...
2016-04-20
724 reads
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...
2016-04-18 (first published: 2016-04-11)
1,483 reads
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”,...
2016-04-14
658 reads
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...
2016-04-13
571 reads
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);
2016-04-11
434 reads
The dropDatabase command drops the current database, deleting the associated data files.
Different methods to drop database
Method 1:
1. select the database...
2016-04-08
469 reads
There are two different ways of getting the desired result
The first method is iterating through each collection using for loop...
2016-04-07
310 reads
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item Bad Stored Procedures
Comments posted to this topic are about the item Disable All the Indexes
How do I disable all the indexes on the dbo.Logger table?
See possible answers