Thursday, 17 November 2016

what are CTE? When and Why To Use CTE in SQL ?

What are CTE in SQL ? CTE are Common Table Expressions first introduced in Sql Server 2005. It is basically a result set or result holder or separate plugin / extension that can hold some complex query separately from main query and supply the named result set or result holder name in place of that complex query in main query. It really improves complexity of complex queries....

Table Valued Functions in Sql

What are Table Valued Functions in Sql ? There are two types of “User Defined” fucntions in sql server scalar function ( that returns single value in response to function call )      2. inline table valued ( that returns function result in tabulated form but query can single lined e.g.      3. return (select * from table_name). 1. Inline...

Wednesday, 16 November 2016

Google Joined .NET Foundation

Its great news by microsoft that google joined .net foundation. Recently Samsung also joined .Net foundation for Tizen platform. Apart from everything its great that all tech companies are working collectively to make good environment for innovation. This Move of Big companies...

SQL Server Public Preview available on Ubuntu

Microsoft has just announced its public preview of the next release of SQL Server, and Canonical is delighted to announce that this preview is available for Ubuntu. Moreover, with SQL Server on Ubuntu, there are significant cost savings, performance improvements, and the...

Tuesday, 8 November 2016

₹500 and ₹100 Notes Banned In India : 25 Points You need to know

NDA Government has implemented smart move as slap to Black Money holders. Money of Black Money Holders will be of no cost if they kept it in their safe lockers. GPS chip based notes will be out in market soon and old notes must need to be deposited in banks as announced by Government of India. Black money holders must need to take their money out in banks otherwise they will...

Tuesday, 1 November 2016

What are Instead of Triggers

Instead of triggers are used to reverse the default action of the query same as the word ‘insted of’ denotes. For example if we are going to execute query to delete record in Empoyee table and we want to first check whether id of employee passed Exist in database or not then we can place a “Insted of Trigger” in database on Delete Operation for that particular table and we will...

Thursday, 6 October 2016

Webhooks Vs WebSockets

WebSockets Can be used to exchange event notifications but it requires a constact network connection . Signalr is best example of Websockets that can be used within an Asp.net application Whereas WebHooks are for event notification across other web applications and other external services. It is similar to b2b communication. Example  You can receive a WebHook when someone...

What are Webhooks and Webhooks vs WebAPI ?

 If you ever used API’s then you know they follow request - response mechanism . Every Request is followed by a Relevant API Response Example 1 -  if we need to fetch our emails we will make a Reques to API with required credentials like Emailid, MessageCount and userid and API will give our Emails in Response to Source From where Request Came Whereas As Webhooks...

What are Webhooks and Webhooks vs WebAPI ?

 If you ever used API’s then you know they follow request - response mechanism . Every Request is followed by a Relevant API Response Example 1 -  if we need to fetch our emails we will make a Reques to API with required credentials like Emailid, MessageCount and userid and API will give our Emails in Response to Source From where Request Came Whereas As Webhooks...

Tuesday, 4 October 2016

Gitless version control system

Gitless is an experimental version control system built on top of Git. Many people complain that Git is hard to use. We think the problem lies deeper than the user interface, in the concepts underlying Git. Gitless is an experiment to see what happens if you put a simple veneer on an app that changes the underlying concepts. Because Gitless is implemented on top of Git (could...