DotNet Mirror
  DNM facebook   DNM Google+   DNM Twitter   
Total Count : 6
Resources Publish New Article  
Difference between count(*) and count(column_name)
Ashok Nalam
We might assume that count(*) and count(column_name) will return same result count. But NO, in case of column holds any null values.

Count (*) – returns all values (including nulls and duplicates)
Count (Column_Name) – returns all Non-NULL values(including duplicates)

In the below script we will see how it works. So that it will be easy for us to understand.
create table #tempTable(Name char(1))
insert into #tempTable values("A")
insert into #tempTable values("B")
insert into #tempTable values(Null)
insert into #tempTable values("C")
insert into #tempTable values(Null)
insert into #tempTable values("C")
select COUNT(*) from #tempTable
select COUNT(Name) from #tempTable
drop table #tempTable
Output: 6 and 4
The table #temptable has total 6 rows. Count(*) returns all the rows including null/duplicates but where as count(name) returns only 4 rows which includes duplicates("C") but not null values.

If you want to remove the duplicates from count(Name) then use distinct keyword in it.
select COUNT(distinct Name) from #tempTable –-returns 3
By: Ashok Nalam | 28 Dec 2012 | SQL Server | Views: 10961 | Comments: 0 | Tags:difference  tsql 
What is managed and unmanaged code in .NET
Ashok Nalam
Manged Code - code which is executed under Common Language Runtime (CLR). Due to this, the code has  many benefits like memory management, support of version control, type safety and security. The code which targets CLR and written in .NET framework is a managed code. E.g: C#,VB.NET

Unmanaged code : code which is not executed under .NET runtime (CLR). CLR is does not have control over execution of code.memory management, security and type safety should be taken care by developer.  
E.g: VB6, C,C++. 

managed code typically compiled to Intermediate Language(IL) code where as unmanged code directly compiles to native code.
By: Ashok Nalam | 30 Dec 2012 | .NET Framework | Views: 11055 | Comments: 2 | Tags:.NET  difference 
VB.NET/C# program to convert Fahrenheit to Celsius and Celsius to Fahrenheit
Ashok Nalam
This program(VB.NET/C# versions) converts temperature from Fahrenheit to Celsius and Celsius to Fahrenheit.
By: Ashok Nalam | 28 Jun 2013 | VB.NET | Views: 83858 | Comments: 0 | Tags:.NET  C#  conversion  difference  number 
Difference between string.IsNullOrWhiteSpace and string.IsNullOrEmpty
Ashok Nalam
The snippet covers difference between string.IsNullOrWhiteSpace and string.IsNullOrEmpty using an example.
By: Ashok Nalam | 19 Nov 2013 | C# | Views: 13215 | Comments: 0 | Tags:.NET  difference  string 
What are the differences between Azure functions and Azure logic apps
Ashok Nalam
Azure function and Azure logic apps both are serverless workloads. Let's look at a few differences below.

Azure FunctionsAzure logic Apps
Execute event-driven serverless code functions with an end-to-end development experienceAutomate the access and use of data across clouds
serverless compute servicesServerless workflows
Code first approached - imperativeDesign first - declarative
Uses App Insights for monitoringUses Azure Monitor logs and Azure Portal
Managed with Rest API and Visual studioManaged with Azure Portal, Rest API, Visual studio and PowerShell
Execute locally or in cloudRun any where
Lot of binding types and extend your own bindingsLot of connectors or build your own
We can call Azure logic apps from FunctionsWe can call Functions from logic app
Write code for each activity to executeIn built read made actions(app connectors) available to integrate from the collection 

Based on above comparisons and your requirement factors you can choose any of the service. 
By: Ashok Nalam | 06 Mar 2023 | Microsoft Azure | Views: 1120 | Comments: 3 | Tags:azure functions  azure logic apps  difference 
What are the different hosting plans for Azure functions
Ashok Nalam
While creating Azure Functions, we must choose a hosting plan for the App. There are 3 basic plans named App Service Plan(dedicated), Consumption, and Premium plans and all these plans are available in Windows and Linux VM’s.

Let's look at what plan provides which features and based on these features and your needs you can select the right plan. 

ScalingAutomatically based on incoming requestsAutomatically with pre-warmed instances so that no delaysPredictive scaling or Manual
Scale Out Max# instancesWindows - 200
Linux - 100

Windows - 100
Linux - 20-100
Cold startWith Idle scenario, scale goes to 0 and we have latency to scaleWith Pre-warming feature there is no latencyNA - function app runs continuously 
Default PlanYes NoNo
VNET connectivityNoYes Yes
App timeout(Min)5 mins30 mins30 mins
App time out(Max)10 minsunlimitedunlimited
BillingPay only for the time when App runsPay as per runs plus pre warmsPay as per App Service Plan
When to consider
  • Scale automatically
  • Pay only when you run

  • App requires continuous run
  • You need more CPU, memory and high GB seconds than consumption plan
  • More execution time than consumption plan
  • VNET connectivity
  • Want to re-use existing App Service Plan
  • Predictive scaling and cost requirements

Other than these 3 basic plans, we have App Service Environment(ASE) and Kubernetes isolation plans, do refer Microsoft documentation. 
By: Ashok Nalam | 08 Mar 2023 | Microsoft Azure | Views: 1104 | Comments: 6 | Tags:azure  azure functions  difference 
cheap jordans|wholesale air max|wholesale jordans|wholesale jewelry|wholesale jerseys