How do I encode and decode a string with base64 in Angular using typescript?
You can encode the string to ASCII and decode it back to the string in Angular using Typescript. Let’s find out how to perform the encoding and decoding of t...
Posts by Tag
- Angular 11
- C# 9
- Typescript 8
- Jira 8
- Groovy 7
- Web API 6
- JiraServer 6
- IIS 5
- IDE 4
- ScriptRunner 4
- Listener 4
- .NET Core 4
- Windows Server 3
- .NET Core 3.1 3
- Domain 3
- Visual Studio 3
- jQuery 3
- .NET 3
- GoDaddy 2
- Blogger 2
- MS SQL Server 2
- Jira Server 2
- MS SQL Server, T-SQL 2
- Data structure 2
- Swagger 2
- Angular Upgrade 1
- Visual studio 1
- Google Adsense 1
- SSL 1
- MVC 1
- NPM 1
- Selenium 1
- XPath 1
- Visual studio IDE 1
- Excel 1
- Formula 1
- Replace 1
- Firebase 1
- Promise 1
- SQL Server 1
- RxJS 1
- Observable 1
- Subscription 1
- Observer 1
- Arrays 1
- HttpContext 1
- Dependency injection 1
- Static files 1
- wwwroot 1
- Visual Studio IDE 1
- SSMS 1
- Github 1
- Powershell 1
- CodeSpaces 1
- Azure 1
Angular
What is observables in Angular?
We will first understand the RxJS library before going to the observables in Angular.
ERROR in ./src/\(_lazy_route_resource lazy namespace object Module not found. Cant resolve .module.ngfactory.js in\)_lazy_route_resource
Are you facing the below error? I’ve tried various solutions from different forums and no solution worked for me. Finally, I tried deleting the node modules,...
What is Promise.all() in Typescript?
The Promise.all() function accepts a collection of promises as input and returns an array of results when all of the provided Promises resolve, or rejected w...
How do I detect a browser or tab closing using router deactivate in Angular?
There is no built-in way to detect when the browser or tab is closed in Angular, but you can use the window object’s ‘beforeunload’ event to trigger an event...
How do I detect a browser or tab closing using hostlistener in Angular?
There is no built-in way to detect when the browser or tab is closed in Angular, but you can use the window object’s ‘beforeunload’ event to trigger an event...
How to merge two arrays in angular and typescript?
We will see how to merge one or more arrays using TypeScript. The concat() method returns a new array by concatenating two or more arrays, while the spread o...
Error: Uncaught (in promise): TypeError: Cannot read property ‘push’ of undefined TypeError: Cannot read property ‘push’ of undefined
Cannot read property ‘push’ of undefined? let fareConfigList: FareConfig[]; Solution: Initialize the array with ‘[]’ let fareConfigList: FareConfig[] = [];
npm is not recognized as internal or external command, operable program or batch file
Add the Nodejs path in your environment variables.
Angular 9 - Now Available. Features and How to update to Angular version 9?
This release switches you to the new Ivy compiler and run time by default. This is one of the biggest updates to Angular in the past 3 years. It’s recommende...
Angular & Typescript - How to get unique items or remove duplicates from array?
In Typescript, there is no built-in function to retrieve the unique items from Array. The below code is a custom function that uses contains (in typescript i...
C#
Encrypt and decrypt strings in ASP.NET Core using Data Protection.
1. Introduction The ASP.NET Core data protection provides the cryptographic API to encrypt and decrypt the string with a purpose key that includes key manage...
IHeaderDictionary does not contain a definition for Referrer and no accessible extension method Referrer accepting a first argument of type IHeaderDictionary could be found (are you missing a using directive or an assembly reference
1. Problem statement ‘IHeaderDictionary’ does not contain a definition for ‘Referrer’ and no accessible extension method ‘Referrer’ accepting a first argumen...
Using static files in ASP.NET Core
INDEX Context Static files WWWroot folder Enable the static files in the ASP.NET Core project Reading static files
How to Access the HttpContext in a Class Library in ASP.NET Core?
INDEX Context Using the IHttpContextAccessor Accessing HttpContext via Dependency Injection Accessing HttpContext via Dependency Injection in a stat...
Recursion in C#
INDEX What is a recursion? Simple recursion Example: Power Example: Factorial Download samples
Multidimensional array in C#
INDEX What is an array? What is a multidimensional array? 2d and 3d arrays Examples
Setup a default route in ASP.NET Core 3.1 MVC
ASP.NET Core Creating a new ASP.NET Core Web Application on choosing an empty template will leave you with the empty configuration in the startup class fi...
The type or namespace name ‘Task<>’ could not be found (are you missing a using directive or an assembly reference?)
If you are getting the below error when try to use the Task<>, The type or namespace name ‘Task<>’ could not be found (are you missing a using di...
System.Collections.Generic.IEnumerable does not contain any definition for ToList
You might be getting this error when trying to convert the Enumerable to List using ToList. It means the namespace to import the LINQ has been missed in your...
Typescript
How do I encode and decode a string with base64 in Angular using typescript?
You can encode the string to ASCII and decode it back to the string in Angular using Typescript. Let’s find out how to perform the encoding and decoding of t...
What is observables in Angular?
We will first understand the RxJS library before going to the observables in Angular.
ERROR in ./src/\(_lazy_route_resource lazy namespace object Module not found. Cant resolve .module.ngfactory.js in\)_lazy_route_resource
Are you facing the below error? I’ve tried various solutions from different forums and no solution worked for me. Finally, I tried deleting the node modules,...
What is Promise.all() in Typescript?
The Promise.all() function accepts a collection of promises as input and returns an array of results when all of the provided Promises resolve, or rejected w...
How to merge two arrays in angular and typescript?
We will see how to merge one or more arrays using TypeScript. The concat() method returns a new array by concatenating two or more arrays, while the spread o...
Error: Uncaught (in promise): TypeError: Cannot read property ‘push’ of undefined TypeError: Cannot read property ‘push’ of undefined
Cannot read property ‘push’ of undefined? let fareConfigList: FareConfig[]; Solution: Initialize the array with ‘[]’ let fareConfigList: FareConfig[] = [];
Angular 9 - Now Available. Features and How to update to Angular version 9?
This release switches you to the new Ivy compiler and run time by default. This is one of the biggest updates to Angular in the past 3 years. It’s recommende...
Angular & Typescript - How to get unique items or remove duplicates from array?
In Typescript, there is no built-in function to retrieve the unique items from Array. The below code is a custom function that uses contains (in typescript i...
Jira
How to update the Jira issue description field using the custom listener and grovvy script?
Are you looking to update the Jira issue description field in an automated manner? If yes, the below script will help you update the description field. If th...
How to use a JIRA custom listener to copy comments from the parent issue to subtasks and vice versa?
You can copy the comment added in the parent issue to all the associated sub tasks and also copy the comment entered in the subtask to the parent issue using...
How to use a JIRA custom listener to copy comments from the parent issue to all sub tasks?
You can copy the comment added in the parent issue to all the associated sub tasks using the JIRA custom listener and grovvy script. All you need to do is to...
How do I use a JIRA custom listener to copy comments from the subtask to the parent issue?
You can copy the comment added in the sub task to it’s parent issue using the JIRA custom listener and grovvy script. All you need to do is to setup the cust...
How to assign the subtask to the reporter after it is closed?
Usecase: The jira admin creates a subtask in the parent issue and assigns it to the ‘developer 1’. The subtask needs to be automatically assigned back to the...
How to prevent closing the parent issue before closing all sub tasks in Jira script runner using Groovy script?
The developers sometimes forget to close their sub tasks, and someone closes the parent issue without checking the sub task status. You can prevent closing t...
Making custom fields is required in a workflow transition in Jira (ScriptRunner)
This post describes what to make a custom field requires during a work flow transition. If you are using Script Runner for Jira, you can use the Field(s) req...
JIRA - How to set custom field value in script runner using groovy script?
Jira allows you to create a custom field and the value can be set during the transition, so when you view or edit the issue, then the custom value will be di...
Groovy
How to update the Jira issue description field using the custom listener and grovvy script?
Are you looking to update the Jira issue description field in an automated manner? If yes, the below script will help you update the description field. If th...
How to use a JIRA custom listener to copy comments from the parent issue to subtasks and vice versa?
You can copy the comment added in the parent issue to all the associated sub tasks and also copy the comment entered in the subtask to the parent issue using...
How to use a JIRA custom listener to copy comments from the parent issue to all sub tasks?
You can copy the comment added in the parent issue to all the associated sub tasks using the JIRA custom listener and grovvy script. All you need to do is to...
How do I use a JIRA custom listener to copy comments from the subtask to the parent issue?
You can copy the comment added in the sub task to it’s parent issue using the JIRA custom listener and grovvy script. All you need to do is to setup the cust...
How to assign the subtask to the reporter after it is closed?
Usecase: The jira admin creates a subtask in the parent issue and assigns it to the ‘developer 1’. The subtask needs to be automatically assigned back to the...
How to prevent closing the parent issue before closing all sub tasks in Jira script runner using Groovy script?
The developers sometimes forget to close their sub tasks, and someone closes the parent issue without checking the sub task status. You can prevent closing t...
JIRA - How to set custom field value in script runner using groovy script?
Jira allows you to create a custom field and the value can be set during the transition, so when you view or edit the issue, then the custom value will be di...
Web API
Failed to load API definition error in Swagger for ASP.NET Core
There are various reasons cause the swagger to fail to load the API definition and you will get the error shared in the below screenshot. Below are the possi...
Adding Swagger to ASP.NET Core Web API Project
1. What is swagger? Swagger is an open-source set of rules and specifications. It is used for API documentation and testing the API endpoints. Swagger UI gen...
Encrypt and decrypt strings in ASP.NET Core using Data Protection.
1. Introduction The ASP.NET Core data protection provides the cryptographic API to encrypt and decrypt the string with a purpose key that includes key manage...
IHeaderDictionary does not contain a definition for Referrer and no accessible extension method Referrer accepting a first argument of type IHeaderDictionary could be found (are you missing a using directive or an assembly reference
1. Problem statement ‘IHeaderDictionary’ does not contain a definition for ‘Referrer’ and no accessible extension method ‘Referrer’ accepting a first argumen...
How to enable or disable the windows and anonymous authentication in Microsoft Visual Studio 2019?
To enable or disable Windows and anonymous authentication in Visual Studio 2019, you need to modify the properties from the project property window or from t...
HTTP 415 unsupported media type error when calling Web API 2 endpoint
You have to send the header to accept the content type.
JiraServer
How to update the Jira issue description field using the custom listener and grovvy script?
Are you looking to update the Jira issue description field in an automated manner? If yes, the below script will help you update the description field. If th...
How to use a JIRA custom listener to copy comments from the parent issue to subtasks and vice versa?
You can copy the comment added in the parent issue to all the associated sub tasks and also copy the comment entered in the subtask to the parent issue using...
How to use a JIRA custom listener to copy comments from the parent issue to all sub tasks?
You can copy the comment added in the parent issue to all the associated sub tasks using the JIRA custom listener and grovvy script. All you need to do is to...
How do I use a JIRA custom listener to copy comments from the subtask to the parent issue?
You can copy the comment added in the sub task to it’s parent issue using the JIRA custom listener and grovvy script. All you need to do is to setup the cust...
How to assign the subtask to the reporter after it is closed?
Usecase: The jira admin creates a subtask in the parent issue and assigns it to the ‘developer 1’. The subtask needs to be automatically assigned back to the...
How to prevent closing the parent issue before closing all sub tasks in Jira script runner using Groovy script?
The developers sometimes forget to close their sub tasks, and someone closes the parent issue without checking the sub task status. You can prevent closing t...
IIS
The action cannot be completed because the file is open in w3wp.exe
Are you unable to delete the files because w3wp.exe prevents you from deleting the files from the Windows server?
How to enable or disable the windows and anonymous authentication in Microsoft Visual Studio 2019?
To enable or disable Windows and anonymous authentication in Visual Studio 2019, you need to modify the properties from the project property window or from t...
HTTP Error 500.19 - Internal Server Error
Error: HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid.
IIS - Cannot Start Application Pool
Error: Cannot Start Application Pool. There was an error while performing this operation.
How to delete all the websites hosted in IIS?
You will end up in the situation to delete one or more website instances hosted in the IIS server. I know it’s a frustrating task to delete the sites one by ...
IDE
How to enable or disable the windows and anonymous authentication in Microsoft Visual Studio 2019?
To enable or disable Windows and anonymous authentication in Visual Studio 2019, you need to modify the properties from the project property window or from t...
How to clear the immediate window in Visual Studio 2019?
What is the use of an immediate window? It is used to debug and evaluate expressions, execute statements, and print variable values.
How to disable Https or SSL in Visual Studio 2019 for web project?
You can disable the SSL or HTTPS in Visual Studio 2019 for your local project execution. Below are the steps,
.NET Core 3.1 not showing in visual studio?
Visual studio 2019 professional or community edition is not showing the framework “.NET Core 3.1”?
ScriptRunner
How to assign the subtask to the reporter after it is closed?
Usecase: The jira admin creates a subtask in the parent issue and assigns it to the ‘developer 1’. The subtask needs to be automatically assigned back to the...
How to prevent closing the parent issue before closing all sub tasks in Jira script runner using Groovy script?
The developers sometimes forget to close their sub tasks, and someone closes the parent issue without checking the sub task status. You can prevent closing t...
Making custom fields is required in a workflow transition in Jira (ScriptRunner)
This post describes what to make a custom field requires during a work flow transition. If you are using Script Runner for Jira, you can use the Field(s) req...
JIRA - How to set custom field value in script runner using groovy script?
Jira allows you to create a custom field and the value can be set during the transition, so when you view or edit the issue, then the custom value will be di...
Listener
How to update the Jira issue description field using the custom listener and grovvy script?
Are you looking to update the Jira issue description field in an automated manner? If yes, the below script will help you update the description field. If th...
How to use a JIRA custom listener to copy comments from the parent issue to subtasks and vice versa?
You can copy the comment added in the parent issue to all the associated sub tasks and also copy the comment entered in the subtask to the parent issue using...
How to use a JIRA custom listener to copy comments from the parent issue to all sub tasks?
You can copy the comment added in the parent issue to all the associated sub tasks using the JIRA custom listener and grovvy script. All you need to do is to...
How do I use a JIRA custom listener to copy comments from the subtask to the parent issue?
You can copy the comment added in the sub task to it’s parent issue using the JIRA custom listener and grovvy script. All you need to do is to setup the cust...
.NET Core
Encrypt and decrypt strings in ASP.NET Core using Data Protection.
1. Introduction The ASP.NET Core data protection provides the cryptographic API to encrypt and decrypt the string with a purpose key that includes key manage...
IHeaderDictionary does not contain a definition for Referrer and no accessible extension method Referrer accepting a first argument of type IHeaderDictionary could be found (are you missing a using directive or an assembly reference
1. Problem statement ‘IHeaderDictionary’ does not contain a definition for ‘Referrer’ and no accessible extension method ‘Referrer’ accepting a first argumen...
Using static files in ASP.NET Core
INDEX Context Static files WWWroot folder Enable the static files in the ASP.NET Core project Reading static files
How to Access the HttpContext in a Class Library in ASP.NET Core?
INDEX Context Using the IHttpContextAccessor Accessing HttpContext via Dependency Injection Accessing HttpContext via Dependency Injection in a stat...
Windows Server
HTTP Error 500.19 - Internal Server Error
Error: HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid.
IIS - Cannot Start Application Pool
Error: Cannot Start Application Pool. There was an error while performing this operation.
How to delete all the websites hosted in IIS?
You will end up in the situation to delete one or more website instances hosted in the IIS server. I know it’s a frustrating task to delete the sites one by ...
.NET Core 3.1
Setup a default route in ASP.NET Core 3.1 MVC
ASP.NET Core Creating a new ASP.NET Core Web Application on choosing an empty template will leave you with the empty configuration in the startup class fi...
HTTP 415 unsupported media type error when calling Web API 2 endpoint
You have to send the header to accept the content type.
.NET Core 3.1 not showing in visual studio?
Visual studio 2019 professional or community edition is not showing the framework “.NET Core 3.1”?
Domain
Adsense: URL must be a valid top-level domain
If you’re getting this error “URL must be a valid top-level domain” in the Adsense account while adding a new site like, http://www.sample.com Screenshot ...
Custom domain not working without WWW in Blogger
The issue fix is pretty straightforward. The problem is with the ‘A record’ which you have added under the DNS Management in the control panel.
How to setup a custom domain on blogger with GoDaddy?
You can purchase a new domain from GoDaddy, BigRock, or any other domain provider and follow the below steps to configure the custom domain in the Blogger pl...
Visual Studio
The visual Studio component cache is out of date, please restart Visual Studio.
I’ve faced an issue while opening Visual Studio 2022/2019, and SSMS (MS SQL Server Management Studio) states that, The Visual Studio component cache is ou...
How to clear the immediate window in Visual Studio 2019?
What is the use of an immediate window? It is used to debug and evaluate expressions, execute statements, and print variable values.
How to disable Https or SSL in Visual Studio 2019 for web project?
You can disable the SSL or HTTPS in Visual Studio 2019 for your local project execution. Below are the steps,
jQuery
How to get the value of textarea in jQuery?
You can get the value of the <textarea> control in jQuery using the below code snippet.
How to add or remove multiple classes in jQuery?
You can add or remove multiple classes from div/span/any tag in jQuery using the below code snippet,
How to add or remove the class of the div using jQuery?
You can add or remove the class of the div in jQuery using the below code snippet,
.NET
Failed to load API definition error in Swagger for ASP.NET Core
There are various reasons cause the swagger to fail to load the API definition and you will get the error shared in the below screenshot. Below are the possi...
Adding Swagger to ASP.NET Core Web API Project
1. What is swagger? Swagger is an open-source set of rules and specifications. It is used for API documentation and testing the API endpoints. Swagger UI gen...
Encrypt and decrypt strings in ASP.NET Core using Data Protection.
1. Introduction The ASP.NET Core data protection provides the cryptographic API to encrypt and decrypt the string with a purpose key that includes key manage...
GoDaddy
Custom domain not working without WWW in Blogger
The issue fix is pretty straightforward. The problem is with the ‘A record’ which you have added under the DNS Management in the control panel.
How to setup a custom domain on blogger with GoDaddy?
You can purchase a new domain from GoDaddy, BigRock, or any other domain provider and follow the below steps to configure the custom domain in the Blogger pl...
Blogger
Custom domain not working without WWW in Blogger
The issue fix is pretty straightforward. The problem is with the ‘A record’ which you have added under the DNS Management in the control panel.
How to setup a custom domain on blogger with GoDaddy?
You can purchase a new domain from GoDaddy, BigRock, or any other domain provider and follow the below steps to configure the custom domain in the Blogger pl...
MS SQL Server
How to find locked tables and kill the session in Microsoft SQLServer?
Open SQL Server Management Studio (SSMS). Connect to the SQL Server instance. Open a new query window. Execute the following query to find the sessi...
How to get the number of rows affected in SQL Server (Transact-SQL)?
You can retrieve the no of affected rows using the system variable - ‘@@ROWCOUNT’
Jira Server
Making custom fields is required in a workflow transition in Jira (ScriptRunner)
This post describes what to make a custom field requires during a work flow transition. If you are using Script Runner for Jira, you can use the Field(s) req...
JIRA - How to set custom field value in script runner using groovy script?
Jira allows you to create a custom field and the value can be set during the transition, so when you view or edit the issue, then the custom value will be di...
MS SQL Server, T-SQL
How to check if a temporary table exists and delete it if it does before creating a temporary table?
You can check if the previously created temporary table exists before creating the same table again in your stored procedure. Drop them if they exist.
How to search for text in a SQL Server stored procedure, function, or view?
You can use the following T-SQL query to search for text in a SQL Server stored procedure, function, or view.
Data structure
Recursion in C#
INDEX What is a recursion? Simple recursion Example: Power Example: Factorial Download samples
Multidimensional array in C#
INDEX What is an array? What is a multidimensional array? 2d and 3d arrays Examples
Swagger
Failed to load API definition error in Swagger for ASP.NET Core
There are various reasons cause the swagger to fail to load the API definition and you will get the error shared in the below screenshot. Below are the possi...
Adding Swagger to ASP.NET Core Web API Project
1. What is swagger? Swagger is an open-source set of rules and specifications. It is used for API documentation and testing the API endpoints. Swagger UI gen...
Angular Upgrade
Angular 9 - Now Available. Features and How to update to Angular version 9?
This release switches you to the new Ivy compiler and run time by default. This is one of the biggest updates to Angular in the past 3 years. It’s recommende...
Visual studio
.NET Core 3.1 not showing in visual studio?
Visual studio 2019 professional or community edition is not showing the framework “.NET Core 3.1”?
Google Adsense
Adsense: URL must be a valid top-level domain
If you’re getting this error “URL must be a valid top-level domain” in the Adsense account while adding a new site like, http://www.sample.com Screenshot ...
SSL
How to disable Https or SSL in Visual Studio 2019 for web project?
You can disable the SSL or HTTPS in Visual Studio 2019 for your local project execution. Below are the steps,
MVC
Setup a default route in ASP.NET Core 3.1 MVC
ASP.NET Core Creating a new ASP.NET Core Web Application on choosing an empty template will leave you with the empty configuration in the startup class fi...
NPM
npm is not recognized as internal or external command, operable program or batch file
Add the Nodejs path in your environment variables.
Selenium
How can we locate the anchor element using their text in XPath?
Below code, snippets help you to find the anchor element using its text in XPath and the sample code to use it in the selenium.
XPath
How can we locate the anchor element using their text in XPath?
Below code, snippets help you to find the anchor element using its text in XPath and the sample code to use it in the selenium.
Visual studio IDE
How to enable or disable the windows and anonymous authentication in Microsoft Visual Studio 2019?
To enable or disable Windows and anonymous authentication in Visual Studio 2019, you need to modify the properties from the project property window or from t...
Excel
How to replace the last or first character of the string in excel?
There are various use cases to remove the tail end character, like replacing the alias name, ex: 16 seconds or 16s to 16. It can be trimmed using the excel i...
Formula
How to replace the last or first character of the string in excel?
There are various use cases to remove the tail end character, like replacing the alias name, ex: 16 seconds or 16s to 16. It can be trimmed using the excel i...
Replace
How to replace the last or first character of the string in excel?
There are various use cases to remove the tail end character, like replacing the alias name, ex: 16 seconds or 16s to 16. It can be trimmed using the excel i...
Firebase
npm i -g firebase-tools leads to …firebase.ps1 cannot be loaded because running scripts is disabled on this system
The error is due to Windows blocking access to run the firebase.ps1 powershell scripts. You can try the below commands to solve the issue,
Promise
What is Promise.all() in Typescript?
The Promise.all() function accepts a collection of promises as input and returns an array of results when all of the provided Promises resolve, or rejected w...
SQL Server
The visual Studio component cache is out of date, please restart Visual Studio.
I’ve faced an issue while opening Visual Studio 2022/2019, and SSMS (MS SQL Server Management Studio) states that, The Visual Studio component cache is ou...
RxJS
What is observables in Angular?
We will first understand the RxJS library before going to the observables in Angular.
Observable
What is observables in Angular?
We will first understand the RxJS library before going to the observables in Angular.
Subscription
What is observables in Angular?
We will first understand the RxJS library before going to the observables in Angular.
Observer
What is observables in Angular?
We will first understand the RxJS library before going to the observables in Angular.
Arrays
Multidimensional array in C#
INDEX What is an array? What is a multidimensional array? 2d and 3d arrays Examples
HttpContext
How to Access the HttpContext in a Class Library in ASP.NET Core?
INDEX Context Using the IHttpContextAccessor Accessing HttpContext via Dependency Injection Accessing HttpContext via Dependency Injection in a stat...
Dependency injection
How to Access the HttpContext in a Class Library in ASP.NET Core?
INDEX Context Using the IHttpContextAccessor Accessing HttpContext via Dependency Injection Accessing HttpContext via Dependency Injection in a stat...
Static files
Using static files in ASP.NET Core
INDEX Context Static files WWWroot folder Enable the static files in the ASP.NET Core project Reading static files
wwwroot
Using static files in ASP.NET Core
INDEX Context Static files WWWroot folder Enable the static files in the ASP.NET Core project Reading static files
Visual Studio IDE
Back to top ↑SSMS
Back to top ↑Github
How to enable PowerShell in Github Codespaces?
Are you the one stuck with the below issue?
Powershell
How to enable PowerShell in Github Codespaces?
Are you the one stuck with the below issue?
CodeSpaces
How to enable PowerShell in Github Codespaces?
Are you the one stuck with the below issue?
Azure
mssql An error occurred while creating a new firewall rule Value cannot be null. (Parameter serverName)
You are receiving the following error message because your IP address (client or local) has not been added to the Azure firewall on the Azure SQL Server. Er...