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

SQL

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

SQL Azure – How to connect SQL Management Studio and import Northwind database

Taking my cloud education further … I wanted to explore the SQL Server relational database offering.   The first trick was to create a new “server” from the Azure portal.  After that I opened the web based SQL Azure portal to confirm it was online and healthy.

I was surprised by how easy it was to create a connection.  Simply create a firewall exclusion to your current IP address … and boom … you can open the SQL Azure with SQL Management Studio locally.  Pretty cool! 

Hot

The Azure Management Portal is proving very capable.  It even has a handy popup dialog with connection strings for convenient copy/paste.  Here is the process I used to import sample Northwind data:

  • Open both instances with SQL Management Studio
  • Right click local tables to build “CREATE TABLE” statements.  Copy/paste those from local to Azure and execute.  This creates the schema.  There are some limitations of Azure so you may have to double check your TSQL syntax (http://www.tewari.info/2009/09/10/sql-azure-notes/)
  • Use the SQL Import wizard to migrate data.   For Azure be sure to select “.Net Framework Data Provider for SqlServer”  destination.
  • To resolve red errors, ignore [ntext] or [image] data types during migration.  SQL Azure does NOT support [ntext] or [image] so I just removed those columns.   Not sure of the best way to migrate this type of data yet.  [ntext] should probably cast to VARCHAR(8000) and truncate anything longer.  [image] should probably be saved to the filesystem (JPG/PNG/etc.) and then a URL string pointer to the image file kept in SQL.
  • Click next and finish. Congratulations!   You now now have sample data in SQL Azure.

 

image
image
image
image
image
image
image

 

image
image
image

 

image

 

image

 

image
image

 

image
image
image

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲