All posts tagged “language

comment 0

SQL Cheat Sheet

You can get the latest version of this SQL cheat sheet here: https://gist.github.com/janikvonrotz/6e27788f662fcdbba3fb

SQL languages

DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.

DML is short name of Data Manipulation Language which deals with data manipulation, and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in database.

DCL is short name of Data Control Language which includes commands such as GRANT, and mostly concerned with rights, permissions and other controls of the database system.
Read More

comment 0

Manage your SharePoint default settings with PowerShell

This post is part of my PowerShell PowerUp project.

The only way to deploy SharePoint default settings for site collections and sites manually is using predefined site templates or an ugly third party tool.
And in case you’ll do that with site templates it’ll cost a lot of the time to update settings which were already set.

However with PowerShell it’s possible to deploy SharePoint default settings automatically and it’s a lot easier than you might think.
Read More