Wednesday, 11 November 2020

Introduction to MongoDB

MongoDB is a No SQL database. It is an open-source, cross-platform, document-oriented database written in C++.
MongoDB is an open-source document database that provides high performance, high availability, and automatic scaling.

What is the purpose of building MongoDB?
All the modern applications require big data, fast features development, flexible deployment, and the older database systems not competent enough, so the MongoDB was needed.

The primary purpose of building MongoDB is:

Scalability
Performance
High Availability
Scaling from single server deployments to large, complex multi-site architectures.
Key points of MongoDB
Develop Faster
Deploy Easier
Scale Bigger

Friday, 9 October 2020

Apply a new sql server collation

 Sometimes we will get a requirement to change server collation post installations.

In such cases please follow these steps.

Execute the command below, a lot of information will appears and no user action is required, just close the prompt window after the execution ends. The parameter "-s" is only necessary if more than one sql instance exists on the target machine.


Sql server -m -T4022 -T3659 -s"SQLEXP2014" -Q"SQL_Latin1_General_CP1_CI_AI"