Microsoft Transact SQL Reference


sql azure

Microsoft TSQL Reference Online:

A little more official than just random search on web and stackoverflow.

Reminder to self on select usage in SQL:

  1. SELECT statements are written with the following clauses: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.
  2. The query engine processes the clauses in this order: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.


Conversion Functions (cast, convert, parse):

Working with NULL:


I am doing an Edx & Microsft refresher on SQL here, so come join me in the learning journey:

I figure this is a good idea, as I learned most of my SQL via trial and error on a work project.

Course Source Code on Github:

Tutorial: Intro To React

Capture React Tic Tac

React web walk-through here:

Final Result Demo on Codepen for a Tic-Tac-Toe game:

More Examples:

Medium article on the difference between React JS and React Native:

When I catch up and learn more in this area, I will post and share.


Microsoft Project Web App Essential Training

Capture Lynda PWA

Here is some training around Project Web App:

You can use Project Web App to status your stakeholders using Power BI on web, and via the mobile app.

Some related training:

  1. Microsoft Project 2016 Essential Training:
  2. SharePoint Online Essential Training:
  3. Microsoft SharePoint 2013 Essential Training:

If you are a Seattle resident, get your free access to via the Seattle Public Library: