Insert and delete instructions on SQL Server

 Today we intend to familiarize you with Insert and Delete on SQL server. Sql server commands You know that the database is purely for storing data on the server and in order to be able to store and then manage the data you need commands like insert, delete and so on. You can manage In future sessions you will learn more from the SQL server Insert command in SQL server The insert in the SQL server is simply used to insert a record into a table. Each database has multiple tables created by the database…

Read More

Compare In-Memory Technology in Oracle, IBM and SQL Server – Part Three (Final)

By increasing the amount of data as well as the need for faster processing, database providers also have capabilities in their products. The In-Memory feature is one of these, and in the first and second parts of this series, we compared In-Memory to SQL Server and Oracle. In this article, which is the third part (final), we will examine this technology in IBM DB2 10.5 and compare it with SQL Server. Data Analysis with BLU Acceleration in IBM DB2 10.5 The IBM DB2 BLU Acceleration feature is available as an integrated In-Memory integration solution with IBM DB2 10.5 . This solution has several optimization processes, but…

Read More

Comparing In-Memory Technology in Oracle, IBM and SQL Server – Part II

comparison of In-Memory technology in a variety of databases examined the technology in Oracle’s databases and also compared it with SQL Server. Here are some other features we’ll look at. In-Memory Columnstore feature in Oracle 12c Oracle Corporation offers In-Memory Columnstore technology as an optional add-on with Oracle Database 12c for users. If this option is enabled for tables or table spaces, Oracle generates a copy of the subset of the data in the caching format as columnar storage. Thus, database administrators can only select the In-Memory data, which is very important in operational terms, and accelerate the analysis…

Read More

Comparison of In-Memory technology in Oracle, IBM and SQL Server – Part I

Currently, some organizations provide in-memory databases for a wide range of activities. This paper examines In-Memory technology in Oracle and IBM and SQL. The concept of In-Memory technology in the Oracle database In-Memory technology in the Oracle database is considered as a new option for the Oracle 12c database. In fact, this technology is considered as an Add-On option for the Oracle 12c database, and allows the company to provide its main interface software as an in-memory database. Oracle Database In-Memory can run on all platforms running on Oracle 12c. Oracle needs a separate product such as Oracle…

Read More

What is MongoDB? Introducing MongoDB Database

The MongoDB database is a robust, flexible and scalable database. This database has the ability to out-scale and many of the features of relational databases, such as indexing and query and storage domains. The MongoDB database has many of these features like built-in support for Map Reduce-style aggregation and Map Reduce-style aggregation. MongoDB was launched in 2007 by 10gen, and its first release was released in March 2010. This database actually stores data with a JSON structure and no specific Schema, rather than storing table data, such as relational or classical databases. This database is currently being used…

Read More

Introducing The CouchDB Database

  CouchDB is also a member of the NoSQL family, and it can be said that there are differences between families. CouchDB was first released in 2005, but it was owned by Apache in 2008. CouchDB, originally developed with the C ++ programming language, was later translated into Erlang in 2008. Like other members, this database is a documentary database that stores data in the document using the JSON format. This database began with the slogan “A database that accepts the concept of the Web”. You can read out the differences at a…

Read More

Concept and Review of Oracle NoSQL Database or ONDB – Part Two

In the first part of this article, the concept of Oracle NoSQL Database (or ONDB) and its architecture are explored. In this paper, the second part of this series of articles addresses some of the features of this technology, including Indexing and Table Data Model … we will pay. Table data model in ONDB The structure of the table data with the effect on the main concepts of the design of Schema, facilitates the process of modeling the data of the program. This model is at the forefront of the…

Read More

Concept and Review of Oracle NoSQL Database or ONDB – Part One

The Oracle NoSQL Database, or ONDB, provides a Distributed distribution of key / value storage with network access and latency or delay prediction. The data is stored in a flexible key-value format; Key contains a combination of large and small keys (provided in the form of a String) and its associated value (represented as JSON data or a vague set of bytes) ). With the ONDB operating in the field of Delete, Update, Read, Create, called the CRUD, with Adjustable Durability and Consistency Guarantee. Meanwhile, this technology delivers a powerful…

Read More

How to detach and attached databases

This article will cover one of the most common SQL Server Detach and Attach the database.  please make sure you have a recent backup for any case of data loss. If you are not used in computer administration and database administration.   Please go to Start >> Programs >>Microsoft SQL Server 2012 >> SQL Server Management Studio and open the application. Connect with Windows Authentication (You have Windows administration rights) or Connect with SQL Server Authentication (You have no Windows administration rights) Expand the folder Databases in the object explorer,…

Read More

How to create a User and SQL server authentication

SQL Server Authentication is a default mechanism to connect to MS SQL Server, but there are times that you need to use SQL Server Authentication to connect to the server, like when you have to connect to an MS SQL Server Database on a different network or when you have an SSPI problem. In order to use SQL Server Authentication, you need to create a SQL Server Authentication Login ID first. we will create a new SQL Server account. Run Microsoft SQL Server Management Studio. with local windows Authentication    Expand the Security folder,…

Read More