Refactor Promises Functions into Async Await Functions

 With the release of Nodejs 8.10, we are now able to write asynchronous functions by using the async/await declarations.  This simplifies the use of promise chain in our code with a much simpler syntactic style.  To understand this better, let’s take a look at how asynchronous functions...

Improve App Performance with In-Memory Cache

In this presentation, we talk about API integration with SQL Server and the inherit problems with a disk-based database. We progressively enhance the system by adding web sockets and Redis as the in-memory cache. We close the session by discussing about a load balanced environment in which we publish...

Angular Serve Command Requires Angular Project

With the rapid updates on the JavaScript frameworks and CLIs, we often come across problems that can cause a project to stop running. In the case of Angular projects, we can often see this error: The serve command requires to be run in an Angular project, but a project definition could...

Enable a SharePoint REST API Post with RequestDigest Token

 SharePoint provides a very detailed set of RESTful API which allows us to interact with SharePoint data lists. When sending GET API calls, there is no need for additional security validation. When sending a PATCH (update) or POST (create), SharePoint requires that the request headers have an additional header with an authorization token. In this article, we take a look at getting this authorization...

Managing SSIS Catalog Database Space

SQL Server Integration Services (SSIS) is a great tool for building ETL processes.  On SQL Server, we can configure an integration services catalog to deploy and configure all the SSIS packages. When using this service, there is also a catalog database named SSISDB that needs to be maintained...