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
532 reads
Prashanth Jayaram
MongoDB -Calculating Collection Size
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
686 reads
MongoDB – Calculating Document Size
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
541 reads
Simple Methods to Recover master.mdf File Password
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,936 reads
Different ways to find Data, log and DB Size
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,116 reads
PowerShell – Backup Individual database and delete all it’s respective files by keeping a recent file
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,143 reads
Get the Total Item Size for an Exchange database
Hey there!
This one is for those Exchange admins who think it is a sin to use hands for something that...
2016-03-06
799 reads
Find failed SQL Job in last 24 Hours using Powershell
This post is based on the request to get failed SQL jobs in last 24 hours and output should be...
2016-03-02
676 reads
SQL – List Server and DB Permsission
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
643 reads
MongoDB -Access different databases and Collections
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,938 reads
Blogs
A Front Door for the DBA Team – AgentDBA UI
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
Cleaning Up Azure MS Defender Billing
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
Installing and Configuring containerd as a Kubernetes Container Runtime
This post shows you how to install containerd as the container runtime for Kubernetes...
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers