MongoDB – Local and Remote Connections in Mongo Shell
To Install and Getting started with MongoDB refer the below links
Getting Started with MongoDBInstall MongoDB 3.2 on WindowsInstallation Guide
How to...
2016-04-06
515 reads
To Install and Getting started with MongoDB refer the below links
Getting Started with MongoDBInstall MongoDB 3.2 on WindowsInstallation Guide
How to...
2016-04-06
515 reads
Calculating Collection Size
We can get the size of a collections by using the shell’s functions
db.collection.dataSize(): Returns data size in bytes...
2016-04-05
590 reads
We can get the size of a document is by using the shell’s Object.bsonsize() function.We pass the object_id of the document...
2016-04-04
526 reads
Overview
MS SQL Server is the relational database management system used to store information in form of tables, views, indexes, triggers,...
2016-03-18 (first published: 2016-03-15)
4,615 reads
Different ways to get the size of the data , log files and Databases
Using CountersQuerying sysaltfiles & sys.databasesQuerying sys.master_files
SELECT instance_name AS DatabaseName,
[Data...
2016-03-10
1,097 reads
Problem Statement
The requirement is to backup individual database and after successful backup the script should retain the most recent file...
2016-03-09 (first published: 2016-02-29)
2,123 reads
Hey there!
This one is for those Exchange admins who think it is a sin to use hands for something that...
2016-03-06
741 reads
This post is based on the request to get failed SQL jobs in last 24 hours and output should be...
2016-03-02
655 reads
Database Level Permission
DECLARE@DBuser_sql VARCHAR(4000)DECLARE@DBuser_table TABLE(
DBName VARCHAR(200),
UserName VARCHAR(250),
LoginType VARCHAR(500),
AssociatedDatabaseRole VARCHAR(200))SET@DBuser_sql='
SELECT "[?]" AS DBName,a.name AS Name,
a.type_desc AS LoginType,
USER_NAME(b.role_principal_id) AS AssociatedDatabaseRole
FROM [?].sys.database_principals a
LEFT OUTER...
2016-02-24
623 reads
You can use db.getSiblingDB() method to access another database without switching the database.
To List Collections of PP database and query...
2016-01-14 (first published: 2016-01-07)
1,918 reads
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
This book was making its rounds on social media, and the concept seems interesting...
I am using the following sql to convert rows into columns for each pid,...
Comments posted to this topic are about the item Ingesting Data From REST API...
Comments posted to this topic are about the item Separate Reads
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers