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
600 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,625 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 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Dipping my toes into the waters of Azure and of course before I get...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers