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....
Thursday, 17 November 2016
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...
Visual studio for mac is released

Very Nice Move from microsoft and cheers for Mac Users. Microsoft launched Visual studio preview for Mac .you can enjoy using dotnet development on mac platform now. Microsoft released Visual Studio for Mac it is currently in preview and still work is in progress for several...
Tuesday, 8 November 2016
No assembly found containing an OwinStartupAttribute
The Common scenario that one of student got was during creating signalr project from empty web project. so i would like to spread it online with others. you may have see Error Screen as shown in below Screenshots -
Error : No assembly found containing an OwinStartupAttribute.
...
₹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...
Subscribe to:
Posts (Atom)
Followers
Popular Posts
-
Sqlite Database is the best way of providing portability...
-
Necessity is the advent of everything today while doing...
-
Quick Sort is a Sorting Algorithm based on Divide And...