category
Home / DeveloperSection / Category
MindStick 10 Best NoSQL Databases
There are so many types and options, from traditional relational databases (SQL databases) to NoSQL. Here are the best NoSQL databases.
Which is better Entity Framework or ADO.NET?
There are different tools for data access in the .net development like ado.net and Entity Framework. But which one is better. Let's see!
What is database normalization? Explain with example.
Database normalization is the process of structuring a relational database with a series of so-called normal forms in order to reduce data redundancy.
How executing SQL Queries in SQL Server Management Studio (SSMS) and Displaying Results?
SQL Server Management Studio (SSMS) is a powerful tool for executing SQL queries and displaying query results.
Connecting to a SQL Server Instance with SQL Server Management Studio: Step-by-Step Guide
SQL Server Management Studio (SSMS) is a powerful tool for working with SQL Server databases. To harness its capabilities.
WHAT ARE TRIGGERS?
A trigger is a set of SQL statements stored in the database structure. A Trigger is a database object that is attached with the table in SQL.A SQL trigger is fired whenever an event or function associated with a table occurs ....
What is Normalization In Database?
The structuring of Database is normalization, Normalization is the process of restructuring tables to eliminate design problems. This process removes redundant data, makes it possible to access data more easily.
Databases To Learn In 2017
PostgreSQL releases its two versions 9.5 and 9.6, this year. They launched the UPSERT functionality after a long time that we know from MySQL (aka ON DUPLICATE KEY UPDATE), better full text search and speed improvements.
Cursor in Sql server database
The Cursor is database object use for getting data and manipulating particular row at a time. It is associated with select query it processes each row returned by select query.