Course Materials for “Implementing a Data Warehouse with SQL Server 2014”

Thank you very much for attending my training “Implementing a Data Warehouse with SQL Server 2014”. I hope you gained something and will spread the word on the cool things about SQL Server. As always, feel free to contact me with questions and feedback (ervinloh@yahoo.com).

As agreed, I am sharing the course materials in this post. My sincere apologies for the long wait.

Presentation Slides:
Module 00
Module 01
Module 02
Module 03

Hands-on labs:
implementing-a-data-warehouse-with-sql-server-2014

Lab Files:
https://1drv.ms/u/s!AnF65DzzmC06kD3G4uzlf24rg6n_

Advertisements

Presentation Slides for “Application Performance Monitoring and Diagnostics with Application Insights”

Thank you very much for attending my session “Application Performance Monitoring and Diagnostics with Application Insights” at “First Class in the Air”. I hope you gained something and will spread the word on the cool things about Visual Studio. As always, feel free to contact me with questions and feedback (ervinloh@yahoo.com).

Session Synopsis:
Regardless if you are in development or production, Application Insights delivers a set of services to provide in depth and actionable insight into your application. The services includes global availability and performance, customer usage and deep internal diagnostic information. In this session, you will see how to set up Application Insights in connected scenarios where it will proactively detect issues through email and webhook alerts, perform root cause analysis with ad-hoc queries and full-text search, and integrate with DevOps processes using Visual Studio Team Services.

Presentation Slides:
Application Performance Monitoring and Diagnostics with Application Insights

Presentation Slides for “Build Fundamentals and Continuous Integration”

Thank you very much for attending my session “Build Fundamentals and Continuous Integration” at “First Class in the Air”. I hope you gained something and will spread the word on the cool things about Visual Studio. As always, feel free to contact me with questions and feedback (ervinloh@yahoo.com).

Session Synopsis:
Explore the benefits of handling changes systematically so that your systems maintain integrity over time with Continuous Integration. In this session, you will learn about the benefits of merging all working copies of developers’ code with a shared mainline, producing a new build upon code check-in. Lastly, this session demonstrates and discusses the benefits of running load, integration, and unit tests automatically attached to continuous integration.

Presentation Slides:
Build Fundamentals and Continuous Integration

 

How to interactively simplify polygon and polyline datasets?

Recently, I need simplify a couple of shapefile maps so that they can be loaded into  mobile reports for SQL Server 2016 Reporting Services.

Mapshaper’s web interface comes to the rescue. The latest version of the web interface is online at http://www.mapshaper.org. Mapshaper works in recent versions of Chrome, Firefox, Internet Explorer and Opera. If you encounter out-of-memory errors while editing a large file, try Firefox, which has been used successfully with Shapefiles larger than 1GB.

I am surprised that maps of over 50MB can sometimes be reduced to less than 1MB. It is therefore very useful for creating lighter weight maps suitable for online publishing (for example, for web-based interactive maps). MapShaper also has options for repairing intersections and preventing shape removal.

Simplification recommendations:
I would like to recommend the Visvalingam simplification with a custom weighting for making maps because it generally does a better job of removing details that are too small to be displayed clearly.

Presentation Slides for Hybrid Apps: Azure Mobile Engagement and the App Economy

Thank you very much for attending my session “Hybrid Apps: Azure Mobile Engagement and the App Economy” at DevUnited.  I hope you gained something and will spread the word on the cool things about Visual Studio. As always, feel free to contact me with questions and feedback (ervinloh@yahoo.com).

Session Synopsis:
Retention is the name of the game. In this session, you will see how Azure Mobile Engagement helps you improve your key metrics such as collecting real-time analytics which highlights users’ behavior, measuring and acting on analytics using a single dashboard, and sending personalized out-of-app notifications, polls, and in-app notifications with rich HTML.

Source Codes:

https://1drv.ms/u/s!AsVdVASpNN_Rh2OcHo49sbz0l_pc

Presentation Slides:

Hybrid Apps Azure Mobile Engagement and the App Economy (New Template)

Presentation Slides for Integrating Hybrid Apps with Line of Business Apps

Thank you very much for attending my session “Integrating Hybrid Apps with Line of Business Apps” at DevUnited.  I hope you gained something and will spread the word on the cool things about Visual Studio. As always, feel free to contact me with questions and feedback (ervinloh@yahoo.com).

Session Synopsis:
Current mobile apps require tighter integration than ever before, specifically in the services and the data aspect which mobile apps consumes. Many enterprise mobile apps will not be seen on consumer app stores. It focuses on surfacing internal enterprise data from legacy CRM and ERP systems to promote user action on this information. In this session, you will see how to quickly integrate line-of-business apps that manages line of business relationships: Vendors, Distributors, Partners, and Customers as well as being able to track all interactions across these relationships on hybrid apps.

Source Codes:

https://1drv.ms/u/s!AsVdVASpNN_Rh2Lfo8aBBeVmu1vO

Presentation Slides:

Integrating Hybrid Apps with Line of Business Apps (New Template)

Presentation Slides for Multi-Device Hybrid Apps: What, Why, and When to Use Hybrid Development Option

Thank you very much for attending my session “Multi-Device Hybrid Apps: What, Why, and When to Use Hybrid Development Option” at DevUnited.  I hope you gained something and will spread the word on the cool things about Visual Studio. As always, feel free to contact me with questions and feedback (ervinloh@yahoo.com).

Session Synopsis:
Hybrid development combines the best (or worst) of both native and HTML5 worlds. Hybrid app is a web app, primarily built using HTML5, CSS, and JavaScript, which is then wrapped inside a thin native container that provides access to native platform features. In this session, you will see how you can use Visual Studio to build highly interactive iOS, Android, and Windows apps with HTML5, CSS, and JavaScript that promises near-total code sharing across iOS, Android, and Windows.

Source Codes:

https://1drv.ms/u/s!AsVdVASpNN_Rh2GvxKp8Ke65A9UI

https://1drv.ms/u/s!AsVdVASpNN_Rh2DgRsih0zOkn4Gw

Presentation Slides:

Multi-Device Hybrid Apps What, Why, and When to Use Hybrid Development Option (New Template)