Latest Blog Posts for IT Developers Zone

• Mutex Multithreading
  on Mar 20, 2014 in C# Multithreading Mutex
  In this post we will learn how to implement mutex multithreading. Let's take a case study to understand how and where to implement mutex and multi-threading at the same time.ScenarioSchedule an application which would run very fre...
• Except and Intersect in sql
  on Nov 9, 2013
  EXCEPT and INTERSECT operator works on two resultsets.Basic rules for combining two resultsetsNo. of columns in both resultset should be equalThe order of columns should be sameCorresponding data type of each column in each select should be...
• row_number in sql
  on Oct 14, 2013 in SQL Server 2005
  Row_Number feature was introduced in SQL Server 2005.Row_Number generates a run-time column in the result set which generates sequential number to each row according to the column used in order by clause.SyntaxRow_Number() over (order...
• Create End Point in SQL Server
  on Oct 7, 2013 in Sql Server
  In earlier article, we learn about EndPoint in SQL ServerIn this article, we would learn how to create an Endpoint in SQL ServerBefore creating an endpoint, we need to reserve an HTTP Namespace to expose the endpoint.EXEC sp_reserve_http_namespace N'...
• End Points in Sql Server
  on Oct 7, 2013 in Sql Server
  A SQL Server endpoint is the point of entry into SQL Server, or a way to connect to SQL Server instance.Endpoints in SQL Server are similar to Web Services that expose database access over HTTP.There are 5 system endpoints that are automatically crea...
• How to start or stop an endpoint in SQL Server
  on Oct 7, 2013 in Sql Server
  In this post, we would see how to start or stop a SQL End PointLet's first query sys.endpoints catalog view and see all the end points exists select * from sys.endpointsOUTPUTTo stop an endpoint:ALTER ENDPOINT endpoint_name STATE = STOPPEDT...
• SQL Server : Msg 6004, Level 16, State 12, Line 1 User does not have permission to perform this action.
  on Oct 7, 2013 in Sql Server
  You might get the following error while creating an end point in SQL ServerThis error is generated when a user is trying to create an endpoint but do not has the access.Resolution: Contact Server Administrator and ask him/her to grant the "Create End...
• Nested Transaction in Sql Server
  on Jul 24, 2013
  In previous article, we learnt about transaction.In this article we will see how nested transaction worksIn nested transaction, the variable @@TRANCOUNT can be used to check the count of level of nested transactions. The variable ...
• Transaction in Sql Server
  on Jul 23, 2013 in Sql Server
  In this article, I am sharing the concept of transaction in sql server and how it is implemented.Transactions run as a group of commands or queries as single execution unit. It ensures either all the commands or queries will be executed or none of th...
• jQuery Basic Interview Questions and Answers
  on Jul 21, 2013 in JQuery Interview Questions
  Question : What is jQuery?Answer   : jQuery is a light weight JavaScript library which provides fast and easy way of HTML DOM traversing and manipulation, event handling, and client side animations, etc. One of the greatest features of...

{pvComments::user_name}

{pvComments::date}

Delete 

{pvComments::comment}

Post a Comment