Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

SQL

VIDEO – Cloud migration of JS todo CRUD to Azure & Office 365 (part 2 of 2)

Live walk through of hosting “Todo List” CRUD application on the Microsoft cloud.   Continued from the first video where we coded a full local application, this video migrates the application front/back end to the cloud.   HTTPS Breeze WebAPI endpoint hosted on Azure for the backend with HTTPS Office 365 SharePoint Content Editor Web Part for the frontend GUI end user experience.

Custom HTTP header was added for extra security as an application “client secret” which is required for the WebAPI middle tier to respond to HTTP traffic.  Missing HTTP header will respond with “null” and not execute any Dot Net code.

Enjoy!

shades_smile

 

 

Diagram

breezejs-sharepoint-architecture

 

Video

 

References

VIDEO – code JS todo CRUD on Breeze & SQL Express (part 1 of 2)

Live coding walk through of a locally hosted “Todo List” CRUD application with Breeze WebAPI 2.2 middle tier and SQL Express relational database storage.  This baseline allows developers to be more productive locally with fast feedback loops.   Iterate code changes, reload test, and repeat.   This technology stack can create sophist acted business application with input validation, advanced data schema, workflows, and more bringing in the latest web innovations from NPM and NodeJS.  

Custom HTTP header was added for extra security as an application “client secret” which is required for the WebAPI middle tier to respond to HTTP traffic.  Missing HTTP header will respond with “null” and not execute any Dot Net code.

In this video I used several components and want to share links for each:

 

 

In a future video, I’ll show how this application can then be deployed to Office 365 and SQL Azure to leverage Microsoft’s cloud hosting.

Enjoy! 

shades_smile

 

 

Diagram

 

Video

Live code JS todo CRUD on Breeze & SQL Express from Jeff Jones on Vimeo.

 

References

NEW – Microsoft Technical Guides

Last week many great technical guides were released on the MS Download Center.  They describe the business benefits of new technology and technical steps to implement.   Below are links with description and download for each (ZIP/PDF/PPT/DOC).

Fantastic visuals here quickly communicate the benefits of Azure, Dev Ops, and modern IT design.

Check it out.  Enjoy! 

shades_smile

 

Guides

  1. Hybrid IaaS technical guides – These documents provide a technical overview of Hybrid Infrastructure as a Service solutions.
  2. Analytics technical guides – This zipped folder provides technical guidance for analytics on Azure.
  3. Application dev/test business documentation – This zipped folder contains documents that provide an overview of application dev/test offerings for partners.
  4. IoT technical documentation – This document provides technical guidance on deploying cloud services for IoT.
  5. Power BI technical guides – This zipped folder provides technical guidance for deploying Power BI, creating dashboards, and other technical details of managed services.
  6. Application dev/test technical guides – These documents provide a technical overview of application development and testing.
  7. SQL Backup to Azure GTM materials – This zipped folder contains campaigns, sample service offers, and templates for SQL backup to Azure.
  8. Analytics business documentation – This zipped folder includes an overview of Analytics on Azure, including the Analytics vision and data platform scenarios.
  9. Azure SQL DB technical documentation – This zipped folder contains best practices and deployment documentation for Azure SQL database.
  10. SQL in Azure VMs technical documentation – This zipped folder contains best practices and deployment documentation for SQL running in Azure VMs.
  11. Backup and Disaster Recovery business documentation – This zipped folder contains documents that provides an overview of backup and disaster recovery offerings for partners.
  12. Getting started on CSP for Azure – This FAQ style document is a “Getting Started guide” for Microsoft Azure services in the CSP program.
  13. SQL Backup to Azure business documentation – This presentation provides guidance on SQL Backup to Azure – business discussions.
  14. SQL Backup to Azure technical documentation – Technical deployment kit with deployment guidance of SQL backup to Azure.
  15. Azure SQL DB business documentation – This zipped folder contains presentations that provide guidance on Azure SQL database – business discussions.
  16. DevOps on Azure business documentation – This zipped folder provides an overview of DevOps on Azure.
  17. Overview of CSP in Azure – This presentation provides an overview of the Azure in CSP program.
  18. Disaster Recovery for SQL technical documentation – This zipped folder contains technical documentation for disaster recovery for SQL, along with a SQL 2014 hybrid kit.
  19. Disaster Recovery for SQL business documentation – This zipped folder contains presentations that provide guidance on disaster recovery for SQL – business discussions.
  20. Power BI business documentation – This presentation provides guidance on incorporating Power BI into your managed services practice through CSP.
  21. SQL in Azure VMs business documentation – This zipped folder contains presentations that provide guidance on SQL in Azure VMs – business discussions.
  22. How partners can make money with Azure IaaS – This presentation provides an overview of how partners can make money with Azure IaaS.

 

Thumbnails

image

 

 

Screenshots

 

image
image
image
image
image
image
image

 

image

 

image

 

Download PPT (200MB)

SQL Server 2012 Service Pack 2

Today I noticed a bunch of new Microsoft Downloads posted on that RSS feed for various components within SQL Server 2012.   Service Pack 2 is now out and each component has a new download available.   These can be helpful for anyone working on Business Intelligence projects with SharePoint 2013.  Links below.  Enjoy! 

Smile

 

SQL Server 2012 SP2 = 11.00.5058.0

Microsoft® SQL Server® 2012 Service Pack 2 (SP2)

Microsoft® SQL Server® 2012 SP2 Report Builder

Microsoft® SQL Server® 2012 SP2 Reporting Services Add-in for Microsoft® SharePoint®

Microsoft® SQL Server® 2012 SP2 PowerPivot® for Microsoft SharePoint 2013®

Microsoft® SQL Server® 2012 Service Pack 2 (SP2) Master Data Services Add-in For Microsoft® Excel®

Microsoft® SQL Server® 2012 SP2 PowerPivot for Microsoft Excel® 2010

Microsoft® SQL Server® 2012 SP2 Semantic Language Statistics

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲