Sibeesh Passion

Category: SQL

Understand the Internal Structure of SQL Database File

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         You must have thought how to store data in SQL Server? SQL Server is the platform, which provides a proper management of database. There is no doubt that it follows a strategy for the storage of all the files. All the users of SQL are aware with the fact that database objects are stored in […]

Read More

SQL Server CRUD Actions Using Node JS

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this post we will see how we can perform CRUD application in our SQL database using Node JS. As you all know Node JS is a run time environment built on Chrome’s V8 JavaScript engine for server side and networking application. And it is an open source which supports cross platforms. Node JS applications […]

Read More

Working With Test Client In Asp Net Web API Help Page

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this article we are going to see how we test our API with the help of a package called WebApiTestClient. As you all know, if you create a sample API project you will get a folder HelpPage in Areas. This is for adding the XML description to each controller and actions we use in […]

Read More

Encrypt And Decrypt ConnectionString In Web.Config File

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this article we are going to see how we can encrypt and secure our connection string in our web config file. As you all know the connection string is the pillar of our data. I mean, without a connection string you just can’t create an application which does some database actions like retrieving the […]

Read More

Keyboard Query Shortcuts In SQL Server Management Studio

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this article we are going to see some shortcuts that may be useful to you when you work with SQL Server Management Studio. You can always uses some custom queries too as query shortcuts in SSMS. Here I am going to show some most used the queries shortcuts. I hope you will like this. […]

Read More

Working with API help page controller action description in Web API

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this article we are going to see how we can enable the API descriptions for the better understanding of how our API controller works and what exactly it is supposed to do. It is recommended that to give the summary and parameter lists and a bit introduction to the service whenever you write any […]

Read More

Web API With HttpClient Or Consume Web API From Console Application

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this article we are going to learn how we can call Web API using HttpClient. Normally we call a Web API either from a jQuery Ajax or from Angular JS right? Recently I came across a need of calling our Web API from server side itself. Here I am going to use two Visual […]

Read More

Rule “Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase” failed

  • 8
  • 2
  •  
  • 1
  •  
  •  
  •  
  •  
  •  
    11
    Shares

82 1     11SharesIn this article we will are going to see how we can fix the error Rule “Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase” failed. You may get this error when you try to install SQL Server. I wast trying to install SQL Server 2016 Release Candidate 1, and I got […]

Read More

Caching In Web API

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this article we will are going to learn how we can use caching in Web API. Normally caching is the process of storing data somewhere for the future requests, in our case we can avoid the unwanted hit to database to get the data if we cache the data somewhere, this way we can […]

Read More

Angular JS AutoComplete In MVC With Web API

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this article we will learn how we can create Angular JS autoComplete text box with the data from SQL Server database. We use MVC architecture with Web API and Angular JS to fetch the data and do all the manipulations. I am creating this application in Visual Studio 2015. You can always get the […]

Read More
Footer With Address And Phones