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
517 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
662 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
530 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,829 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,098 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,125 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
780 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
663 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
626 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,924 reads
Blogs
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Back at Small Data SF in 2025
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Forums
Large posts full of code not allowed anymore?
Several times now, I've seen a post asking for a solution. I've replied, and...
Data > Hype
Comments posted to this topic are about the item Data > Hype
Create and Read the Analysis Services Flight Recorder
Comments posted to this topic are about the item Create and Read the Analysis...
Question of the Day
Slipstream parameters
What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?
See possible answers