SQL – DEVELOPPARADISE

DEVELOPPARADISE

What Can JSON Do For You in SQL Server Database?

What Can JSON Do For You in SQL Server Database?

SQL Server Database Engine is a general-purpose multi-model Database Engine that enables you to combine the classic relational concepts with NoSQL concepts such as JSON documents. In this article, you will see some use cases how to combine JSON with relational data and when to use it.

SQL Server Part 1

SQL Server Part 1

If you move in the Past, you’ll get to know that in the early 1980s. You’ll see the applications running on PCs that access the local data files. This creates a problem because multiple users won’t able to share the data. As things evolved, databases installed to be on Servers this enable the multiple users to share the data on the network. And we need something to manage the data this was the relational database system come into play. They do so with the Structure Query Language (SQL). In this simple text, they get passed to the server from the client application. The DBMS on turns take care of all the file known necessary to perform the operation the users requested which could be inserted, update, delete, retrieve, read, modify data etc.

THE KEY DIFFERENCES BETWEEN MYSQL AND MS SQL SERVER

THE KEY DIFFERENCES BETWEEN MYSQL AND MS SQL SERVER

The MySQL and MS SQL are the two of the most widely used database systems in the world. The first thing that you will note about these two database systems is how they are availed to users. MySQL is open source software. This means that the use of MySQL comes from the pooled knowledge of different people from different corners of the world. This can be arguably be the biggest plus for MySQL as users through the open source platform can continually improve the general program. MS SQL on the other hand uses a closed source development approach. By this, the development of the program is done in-house and all that the consumers get is a program that they are supposed to use.

Duplicate songs detector via audio fingerprinting

Duplicate songs detector via audio fingerprinting

As a software engineer, I was always interested in how a computer can be taught to behave intelligently, at least on some simple tasks that we can easily solve within frames of seconds. One of them applies to audio recognition, which in recent years has been analyzed thoroughly. For this reason, in this article, you will be introduced to one of the complex tasks which arose in the field of computer science: the efficient comparison and recognition of analog signals in digital format. As an example, consider an audio signal Ψ1, which you would like to compare to another Ψ2 in order to see if they both are coming from the same song or audio object. Any person could cope with this assignment with no problem at all, but computers unfortunately are not that intuitively “smart”. The difficulty lies in the fact that each of the signals might have distinct digitized formats, thus making their binary signatures totally opposite (resulting in an obsolete byte-by-byte comparison). The dissimilarity may also result because of the combination of variant internal characteristics of the same audio format (bit rate, sampling rate, number of channels (mono, stereo, etc.)). Even if you proceed with the conversion of the files to some predefined specifications (e.g., 44100 Hz, stereo, WAVE PCM format), you still might bump into the problem of having different binary representations because of the possible time misalignment, noise, distortion, or “loudness levels” for the same song (“loudness” technically defined as amplitude level).

Logging and Exception handling, Versioning in ASP.NET WEB API

Logging and Exception handling, Versioning in ASP.NET WEB API

In this article, we are going to learn how to log each request and response of an API such that it helps to maintain logs, next we are going to handle all API exception such that if an error occurs, we can store errors and fix it as soon as possible, and last part is versioning of the API.

Continuous Integration and Delivery for Beginners (DevOps)

Continuous Integration and Delivery for Beginners (DevOps)

DevOps is a combination of software development and operation (Dev & Ops) which strongly advocate automation at all steps in software development process. This will enable faster delivery, more stable operating environment with minimum human errors, less maintain cost and many more advantages for software development team.

SqlBinder Library

SqlBinder Library

SqlBinder is a free, open-source library that helps you transform a given SQL template and a set of conditions into any number of valid SQL statements along with their associated parameters.

ASP.Net Core2.0, Angular6 – SPA

ASP.Net Core2.0, Angular6 – SPA

In this post, we are going to explore how a Single Page Application (SPA) sample can be put together using ASP.Net Core & Angular from scratch.

Custom Tokenization Database First

Custom Tokenization Database First

This custom database first approach token authentication will enable you to apply token-based authentication in your application in a simple way with no hassle.

SQL TVP Made Easy

SQL TVP Made Easy

I walk you through how to make use Table-valued parameters with one value

Azure Functions Tutorial – SQL Database

Azure Functions Tutorial – SQL Database

Often a service is required to connect to a database to perform some operations. In this post, we are going to look at having an Azure Function connect and insert a record in database table. We will showcase the usage on nuget packages and usage in Azure Function to automate package management.

©2018 devepar.com