How to setup SqlServer to access via Internet – sql authentication

How to setup SqlServer to access via Internet – sql authentication

There three main parts in setting up sql server to be accessed on the internet. Configure your SqlServer Setup Sql ports run Sql configuration manager goto sql server network configuration enabled tcp goto sql server service restart the sql service instance goto back to sql server network configuration click on tcp properties under port put 1433 or […]

Read More

Consuming Rest Api using Httpclient from dotnet

Recently I had to consume a external rest api using httpclient from .Net, after reading this two articles I have kind change the way i use using { }. Accessing httpclient wrong with using {    }   Dispose Httpclient or have a static instance  Snippet how access the http client is below   public class OrderController : […]

Read More

Dictionary in C#

Dictionary is a collection of key, value pairs. Why is it important? Let look at one application? In a city, many buildings are found. To find a structure we can search the entire city, street by street. But this becomes slow. With a dictionary, we can map a building to a location. We can map “park” […]

Read More

Sql Cursor in TSQL

In SQL Server the cursor is a tool that is used to iterate over a result set, or to loop through each row of a result set one row at a time. It may not be the best way to work with a set of data, but if you need to loop row by agonizing row (RBAR) […]

Read More

Meetup – Intro to Redux

Intro to Redux was meetup that was held on August 9 at Centrality Redux is a predictable state container for JS Apps which can be used with other JS libraries such as React. Building complex React Native apps requires manipulating state and Redux makes state easier to manage. Dates state changes is not a pure function cause […]

Read More

Stored Procedure and Functions to speed up Backend Query

Easy way to create stored procedure:- Open SQL Management Studio. Goto Database and click on Programmability. Do a right click on Stored Procedure choose stored procedure. You should see template stored procedure You notice <Procedure_Name, sysname, ProcedureName> this where u need to change as the name of stored procedure. It should be something like this dbo.NameofStoredProcedure […]

Read More

Spatial Data (geography) not automatically added in Edmx

I had to add geography data type in one of my stored procedure and pull this in visual studio using entity framework (EF). Unfortunately this was not add automatically. For normal datatype like string, date, integer this not a problem. To manually add this in visual studio. Click on edmx files. Do a right click […]

Read More

Meetup – .Net Rock with Richard Campbell

This meetup was held at Grid AkL on 31 July 2017. The meetup was divided into sections: Saving the World One App at a Time – The Humanitarian Toolbox Richard Campbell tells his story of software, hardware and charity that ultimately has led him to the Humanitarian Toolbox (htbox.org). The Humanitarian Toolbox is an open source […]

Read More

Meetup – Dev/Test Labs in Azure

Attend a meetup on 5th July 2017 on “Dev/Test Labs in Azure” presented  by Brendan Ross –  Microsoft Cloud Consultant Main points of meetup – You can create a container in azure for testing web application. Pretty much everything from new pre installed windows machines, with various application like microsoft sql as well placing the web application on different […]

Read More

“No Access-Control-Allow-Origin” Error – Cors Plugin

I have been developing a reactjs application that calls a spotify-api that return some information on music artist. I got this error “No Access-Control-Allow-Origin Error” as below After doing some research I found out that Javascript is limited when making ajax / fetch requests outside of the current domain. Ex 1: your domain is example.com and you […]

Read More

Design Patterns – Software development

Design patterns are reusable solution that solve software design. The 23 Gang of Four (GoF) patterns are generally considered the foundation for all other patterns. They are categorized in three groups: Creational, Structural, and Behavioral – Reference links – http://www.dofactory.com/net/design-patterns Creational Patterns   Abstract Factory Creates an instance of several families of classes   Builder Separates object […]

Read More

Meetup – Intro to Reactjs

When to a meetup on reactjs this was hosted at  – Xero, Level 1, The Textile Centre on 5th of July 2017. Meet up with some new friends and learnt some new things about react. Below are some photos of the meetup.   Slides – This was taken by jishaal http://slides.com/jishaal/react-intro-react-native#/ React Docs – read it all because […]

Read More

Documentation using draw.io

One interesting and free tool that can be used for documentation of flowcharts, mockup is draw.io   It also integrates with Google.docs as extensions. You can install this by clicking the Add-Ons to install draw.io in google docs. To update just click on the Add-On, Update selected diagram.

Read More

Ninject with Windows Service

Lately, I had to develop a Window services that had to use ninject dependency injection from another project. Although I follow this blog from Martin, there were items I had to change. Step 1: After u build your windows services, import the dll from the project that contains your dependency injection file and add to the references of your window services. […]

Read More

My First Take on SignalR

Below are some of my notes and reference on SignalR Reference: https://docs.microsoft.com/en-us/aspnet/signalr/overview/getting-started/introduction-to-signalr What is SignalR? ASP.NET SignalR is a library for ASP.NET developers that simplifies the process of adding real-time web functionality to applications. Real-time web functionality is the ability to have server code push content to connected clients instantly as it becomes available, rather than […]

Read More

Retrieving/Activating Google Map GeoFence with Database Design

Frontend Google Map GeoFence – Drawing a circle and rectangle Reference for Google Map Documentation – https://developers.google.com/maps/documentation/javascript/reference // create map on document map Id map = new google.maps.Map(document.getElementById(‘map’), { center: { lat: defaultLocation.lat, lng: defaultLocation.lng }, zoom: defaultZoom }); marker = new google.maps.Marker({ map: map }); //add controls on map map.controls[google.maps.ControlPosition.RIGHT_BOTTOM].push(mapCustomControl.locationButton()); //add circle with getBounds which contains […]

Read More

JavaScript Prototypes – Purpose and When to Use it ?

These are two important ways the prototype is used in JavaScript: Prototype Property: Prototype-based Inheritance Prototype is important in JavaScript because JavaScript does not have classical inheritance based on Classes (as most object oriented languages do), and therefore all inheritance in JavaScript is made possible through the prototype property. JavaScript has a prototype-based inheritance mechanism.Inheritance […]

Read More

S.O.L.I.D – Five Principle of Object Oriented Design

S.O.L.I.D is an acronym for the first five object-oriented design(OOD). Why? These principles, when combined together, make it easy for a programmer to develop software that are easy to maintain and extend. They also make it easy for developers to avoid code smells, easily refactor code, and are also a part of the agile or […]

Read More

Jquery/Javascript Deferred and Promise – Handling Asynchronous Execution

As of Jquery 1.5 there is a new ways of handling asynchronous execution. Firstly what is Asynchronous or Synchronous execution? It simply terms when you execute something synchronously, you wait for it to finish before moving on to another task. When you execute something asynchronously, you can move on to another task before it finishes. […]

Read More

Reflection in C# purpose

Reflection is the process by which a computer program can observe and modify its own structure and behaviour. being able to examine and change information about your application during runtime, offers huge potential read its own metadata for the purpose of finding assemblies, modules and type information at runtime By using Reflection in C#, one […]

Read More