Starting of month, reminds me about providing a single post for Azure updates on previous month. This blog, we will be covering up June month updates from Azure. Each update on this blog is not an exhaustive list of all the monthly updates. I would like to call out most specific updates from Infrastructure technologies (compute, storage, networking, identity,…
During Azure certification preparation and based on my project experience of the Azure Kubernetes Service (AKS), I wish to share several best practices for AKS deployment. In this post, I will walk you through the selection of appropriate options within AKS. Networking models AKS supports two networking models: Kubenet networking – Azure manages the virtual network resources as the cluster…
What is it? Microsoft Azure offers a feature called “Forced Tunneling”, which allows you better manage and control your outbound internet traffic from resources within your Azure virtual networks through your Organisation’s on-premise firewall via an established VPN connection or an ExpressRoute circuit. Why do I need it? Resources deployed in an Azure VNET needing to access the Internet…
This blog, we will be covering up monthly updates from Azure. Each update on this blog isn’t an exhaustive list of all the monthly updates. I would like to call out most specific updates from Infrastructure technologies (compute, storage, networking, identity, containers and security. please feel free to reach out using the contact link of this blog. The list…
If you have been working with Azure Infrastructure services, then you would have come across Core Network offerings such as Azure Traffic manager, Azure Load balancers & Application Gateways. These network services provide solutions for applications that require high availability, security & scalability, but they also come with their own limitations. One such limitation is that they primarily exist…
Hello Friends, in this article i am going to share some of my dashboard samples i have created using NSW public transport, School and Property median value data available online. My dashboard shows how the property median value of each suburb differs from the availability of school and transport accordingly. The above image illustrates the Property median value by…
In this article, we are going to see how to calculate Geo-distance between two points using SQL server. You can calculate geo distance using spatial types – geography datatype in SQL server. This type represents data in a round-earth coordinate system, You can find out detailed information at Spatial type: Geography The default syntax for to convert Latitude and Longitude into Geography…
As businesses generate and accumulate large amounts of data, it becomes a herculean task to remove unwanted or inaccurate data. While modifying such data sets requires effort, identifying and removing them are not easy either. Data cleaning identifies incorrect data and modifies it according to requirements. Data that is cleaned will then need to be transformed into a standard…
In PowerBI there is a nifty trick where you can pivot or unpivot your data in the Query Editor. This saves you from having to do this in SQL or which ever source you are using for your data. There are just 4 simple clicks to pivot your data! First you need to select the column you want to…
SQL Scalar functions UCASE() – Converts a field to upper case LCASE() – Converts a field to lower case MID() – Extract characters from a text field LEN() – Returns the length of a text field ROUND() – Rounds a numeric field to the number of decimals specified NOW() – Returns the current system date and time FORMAT() –…
