MongoDB -Get Size, RowCount, CollectionSize

There are two different ways of getting the desired result
The first method is iterating through each collection using for loop...

SSC Editorial: Would You Move for a Job?

I won’t say never, but it’s unlikely I’d move for a job – my roots are here in Orlando and I...

Announcement: Backup(n.) vs Back Up(v.)

Let it be known that the word “backup” is a noun (it refers to a thing), and “back up” is a verb (it...

FIND OBJECTS BEING REFERRED BY SSRS REPORT

Hi Everyone

In the daily team meeting today, we had a requirement to find out the stored procedure used/referenced by SSRS...

All about Searching - Full-Text Indexes

SQL server has the capability to store text-based data in the form of char, varchar, nchar, nvarchar, text, ntext, image,...

Cloud Backup - Directly to Azure

Backup is one of the major task for DBAs, it has many different options and ways for each companies to...

Quick Encryption with Always Encrypted

What do you need to do in order to access data in a SQL Server that’s encrypted with Always Encrypted?...

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...

SSMS Preview Plan Comparison Tool and Plan Viewer Optimizations

With the February release of the SQL Server Management Studio (SSMS) Preview Microsoft introduced a nice new tool inside SSMS,...

Ben Miller Speaking to oPASS & MagicPASS on April 19, 2016

Register to attend this joint chapter meeting at https://www.eventbrite.com/e/opassmagicpass-joint-april-meeting-w-ben-miller-tickets-24457339561.
OPASS and MagicPASS are proud to present a special joint meeting with Ben...