USE master
EXEC sp_configure ‘show advanced options’, 1
RECONFIGURE WITH OVERRIDE
EXEC sp_configure ‘max server memory (MB)’, 4096
RECONFIGURE WITH OVERRIDE
EXEC sp_configure ‘show advanced options’, 0
RECONFIGURE WITH OVERRIDE
Month: February 2018
Create MS SQL database backup
CREATE DATABASE my_backup_db ON ( NAME = my_db, FILENAME = 'c:\mybakup.bak' ) AS SNAPSHOT OF my_production_db
No SQL data modeling
If you are getting started with No SQL, you should read this article on MSDN.
It gives as good introduction to document data modeling.
https://docs.microsoft.com/en-us/azure/cosmos-db/modeling-data