Sql Archives

LINQ (Language Integrated Query)

Author - Webner
|
0 Comments
|

Introduction: LINQ is a uniform query syntax in C# to save and retrieve data from different sources. It is integrated into C# eliminating the impedance mismatch between programming languages and databases, as well as providing a single querying interface for different types of data sources.

For example, SQL Read more…

Advanced SQL – Indexes and Triggers

Author - Webner
|
0 Comments
|

Introduction

The SQL database provides a lot of commands and functions. With the help of them, we can manage a huge amount of data easily in the database. Following are some of the examples:

INDEX:

In the SQL database Index is like a schema object. It Read more…

Understanding Azure Functions with Example

Author - Varun Chopra

What are Azure functions? Example of Invoking Azure functions inside the Logic App.

Azure Functions

In General, functions are used to run the small pieces of code to make it reusable. Similarly, Azure functions are used to run the small pieces of code inside Read more…

PostgreSQL – Server doesn’t listen error

Author - Varun Chopra
|
0 Comments
|

How to fix PostgreSQL server doesn’t listen error

While trying to connect to Postgress you may face this error – Server doesn’t listen.

Error:

This is not an error exactly but an exception that occurs when we are running two or Read more…

PostgreSQL – Server doesn’t listen error

Author - Manoj Thakur
|
0 Comments
|

How to fix PostgreSQL server doesn’t listen error

While trying to connect to Postgress you may face this error – Server doesn’t listen.

Error:

This is not an error exactly but an exception that occurs when we are running two Read more…

Improve SQL query performance

Author - Banita Rani
|
0 Comments
|

Tips to improve SQL query performance

1. Avoid usage of multiple joins in a single query. Unnecessary joins degrade your query performance.

2. Creation of indexes on the table. Indexes are used for improving your queries. We need to create the indexes Read more…