Software Trainer - .Net, Blockchain

19/02/2022

Learn Basics of Blockchain Development and way to find free resources. 6 Hours workshop will cover basics of Blockchain, Solidity, Ethereum and Hyperledger.

Pay through UPI. Contact soon. Hotel facility at Amritsar available.

08/01/2021

We are announcing new Workshop for Kids on Artificial intelligence.

Artificial intelligence Workshop of Kids

11/03/2019

Job Opportunity for BTech or MCA students only.

If your studying self funding or want to do commissioned based marketing job.

Location: Inside your college campus
Time required: Weekend 2 to 3 hours
Commission: upto 25000.
Education Ongoing MCA and BTech. Good in communication skills

Send your CV and reason to do job at [email protected]

17/02/2019

First workshop at Amritsar to open your path towards Artificial Intelligence and Machine Learning on 3 March near Hindu College, Amritsar.

28/12/2018

17/10/2015

Widows Azure

A Windows approach towards cloud computing.

Azure supports IaaS, SaaS PaaS of Cloud.

We can install multiple OS at Virtual disk and use the storage for textual or multimedia data.

SQL Server in Azure also good to support cloud platform.

24/06/2015

Entity Framework Code First and Database Trigger support

We can also write triggers using EF Code first, but in Up method.

Example:

public partial class Example : DbMigration
{
public override void Up()
{
Sql("CREATE OR REPLACE TRIGGER [name] BEFORE UPDATE ON myTable ...");
}

public override void Down()
{
Sql("DROP TRIGGER [name]");
}
}

Using Sql(), you can write any Slq/T-SQL statement.

24/06/2015

If you want to learn Entity Framework. Then it is a good source:

https://msdn.microsoft.com/en-us/data/ee712907.aspx

Learn how to use Microsoft ADO.NET Entity Framework to perform data access in your .NET applications. Learn about the Code First and the EF Designer for Visual Studio, which supports Database First and Model First.

24/06/2015

Interview question: What is merge statement in SQL server?
tement that can do insert, update and delete on a table based on condition.

http://blog.sqlauthority.com/2010/06/08/sql-server-merge-operations-insert-update-delete-in-single-execution/

This blog post is written in response to T-SQL Tuesday hosted by Jorge Segarra (aka SQLChicken). I have been very active using these Merge operations in my development. However, I have found out from my consultancy work and friends that these amazing operations are not utilized by them most of the t…

17/06/2015

.Net Enumerations

The one of the most used value types are Enumerations. The datatype is best suited for the situation when we want to chose a single value from list of values.

The main advantage of using Enumerations is that it simplified all code as stored as value types.

Entity Framework supports enumerations too. In real scenario I used it in almost every project. I love to use it.

Instead of storing string value for known cities, gender, options, courses, I love to use enumerations. It defines a check constraint on list of values.

In C/C++, enum is used to store int values, first value is by default and next is incremented by 1. But in Java/C #, role of enum is defined to solve a purpose to store and retrieve single value from list of values.

In C #, I use:

enum City {Delhi, Mumbai, Chennai, Banglore, Kolkata, Hyderabad};

Now we can use this in a class like this:

class Joinee{
string Name;
public City PostingLocation{get;set;};
}

Now we can assign value to enum variable as:

Joinee joinee=new Joinee();
PostingLocation=City.Delhi;


Here we see that we assign value as {Enumeration Name}.{ListOption}

We can also make City as string. We use enumeration instead of string, we have limited options, as a list and choose a single value from the list.


The datatype of values is int by default, but we define any of numeric value like byte, long.

enum Games:byte {Cricket, Hockey, Tennis}

Remember values must not contain whitespace within.

If you want to go in depth of enumerations, this page will help you better:

https://msdn.microsoft.com/en-us/library/cc138362(v=vs.140).aspx

An enumeration type (also named an enumeration or an enum) provides an efficient way to define a set of named integral constants that may be assigned to a variable. For example, assume that you have to define a variable whose value will represent a day of the week. There are only seven meaningful va…

23/02/2014

Cloud Computing

Cloud computing is branch of computing where infrastructure, software, development platform and data is provided as service to end users over the network on ‘pay as use’ basis.

Everything is service here. Providers can provide infrastructure like servers, processors, RAM etc over the internet; development platform as Visual Studio, Eclipse, other DLL files or SDKs over the internet.

Cloud Computing provide services using concept of virtualization. Providers provide Servers like Windows Server or Linux etc over their own hardware, we can install our softwares on that VM. Developers can use visual studio over the network.

Now think of the situation: A company has 1000 employees over the world and provided system to each user. Now they want to use Windows 7, as Windows XP is going to retire. There is need to update RAM as well if not supported by new system. It is too much cost and overhead for IT department to update all systems. Some software stop working as some machines need updated hardware or updated softwares to support for Windows 7.
Now think of cloud computing environment. The Windows and needed software are over the virtualization. Developers have their systems with just their Windows and internet connection on it. In this situation, developers get all tools over the internet from virtualized server. So, all updates need to be on this single server of Distributed servers. For this, company just raise request to provider company to use newer software. That’s it. No headache to development company and its employees.

Provider company needs to update the developer company account with better hardware or software by just changing configuration settings. This is cloud computing at all. RAM, Processers, Cores, Software etc everything is provided over the internet concurrently.

Cloud computing has three componants:
1. Infrastructure as a Service [IaaS]
2. Platform as a Service [Paas]
3. Software as a Service [SaaS]

IaaS is provided by service providers. Providers provide processors, cores, RAM, HDD over the internet. Eg. You create account with Windows Azure. Create Virtual Machine, install Windows or other Servers using image files. Assign RAM to it. You can have as many Virtual Machines as you can. So it provide dynamic scaling of hardware resources with saving hardware and labor costs to handle that new hardware. Development company should concentrate on development only, no hardware team needed as it would be handled by service providers.

PaaS provide development tools to developers in a company as service over the network. Developers can use visual studio over the network with windowsazure.com account. You must need an account with provide to access services.

Account -> Services [IaaS, PaaS, SaaS]

Saas are softwares provided to end users. Developers develop software using Platform provided as service. Those software are provided to end users as Software as a service.

Database like SQL server are also provided as service to work on. So developers can develop software on visual studio online using sql service online and save project in skydrive online. So, everything is over the internet. Developers are now not depending on their machines and their machine configuration. Now they can access their project anytime and anywhere over the world with their account. This is cloud computing.

Azure uses file system as BLOB.

There are 3 different types of storage mechanisms in Azure: BLOB, Table and Queue.

Blob contains tons of unstructured data in file system. Blob data stored as Page Blob and Block Blob. Each blob has unique blob number. Block blob can have upto 200 GB of data. Blob data can be sent in chunks of 4 MB each. Page blob can be upto 1 TB of data. Page blob is organized into 512 bytes per page.

Tables contain lots of structured but un-relational data over No-SQL. Each table consist of multiple entities. Every has a partition key and a row key that uniquely identifies a row. The partition key divides tables logically into partitions. Within a partition each row in uniquely identifiable by row key. All entities must have two properties: PartiionKey and RowKey. To ensure this, each entity class must inherit from TableEntity. You can add single entity or batch up to 100 entities at a time into table.Tables support OData’s JSON format.

Queues are used to transport messages between applications. Queue messages can be up to 8KB only. It is only meant to transport messages.

Windows Azure also support metrics data in hourly and minutes intervals. Metrics are used to monitor errors, service availability and other things to improve performance.

Each type storage access need connection string. The storage connection string is DefaultEndpointsProtocol=http;AccountName=myAccount;AccountKey=myKey;
You will get primary and secondary key when you create Azure account.

The main goal of cloud is to provide services when and where needed. Micorosoft Azure, Amazon Web Services and IBM OpenStack are important cloud computing tools available.