-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server 2019

I have written about 2017 here, Last month at Microsoft Ignite FL on September 2018, Microsoft announce they are going to release 2019 early next  year at , same as Oracle 2019. I would be writing more on it in future. … Continue reading

Read more

0 comments, 178 reads

Posted in Vinay Thakur on 20 October 2018

MongoDB-CHICAGO .Local

Continue to my interest on MongoDB Blog lastly on MongoDB 4.02, I attended MongoDB CHICOGO .local Sep 12 and learned so much about MongoDB so would like to blog more about what I learned. MongoDB has 3 Managers: MongoDB Atlas Atlas … Continue reading

Read more

0 comments, 141 reads

Posted in Vinay Thakur on 6 October 2018

MySQL 8.0 and NDB 7.6

Oracle announced MySQL ndb Cluster 7.6 : in June 2018. Oracle Announces General Availability of MySQL Cluster 7.6 – June 2018 Oracle also announced MySQL 8.0 latest version of MySQL in Oracle Announces General Availability of MySQL 8.0 – April 19, 2018. … Continue reading

Read more

0 comments, 162 reads

Posted in Vinay Thakur on 6 September 2018

Apache Hadoop Release 3.1.1 available

Last month Apache Hadoop also release its latest Stable release version Apache Hadoop 3.1.1 which has major improvement in Hadoop system.   http://hadoop.apache.org/docs/r3.1.1/index.html

Read more

0 comments, 306 reads

Posted in Vinay Thakur on 5 September 2018

MongoDB 4.0.2 release

As i was discussing about MongoDB in my earlier blog, on NOSQL ACID stands for Atomic, Consistent, Isolation, and Durable we generally call this for RDBMS systems BASE, which is typical for NoSQL systems, stands for Basically Available, Soft State, … Continue reading

Read more

0 comments, 156 reads

Posted in Vinay Thakur on 4 September 2018

Oracle Atonomous

Last month Oracle – (Larry Ellison, CTO and Executive Chairman) has introduced Oracle Autonomous database for OLTP system Oracle has already introduced Autonomous on OLAP system in early this year. This way it is shows that Oracle on Cloud can … Continue reading

Read more

0 comments, 211 reads

Posted in Vinay Thakur on 3 September 2018

What is MemSQL

yeah, MemSQL for me its a combination of RDBMS and NOSQL and more of flexibility of both per our choice, most of the RDBMS going with such concept. NOSQL is compromise with ACID property and flexible for developers it has … Continue reading

Read more

0 comments, 783 reads

Posted in Vinay Thakur on 3 September 2018

New – News on Database System

This month i will try to write whats new going on in the market, as i could see many new things are coming, new releases new concepts. things are change with respective with data and database technologies. its getting interesting … Continue reading

Read more

0 comments, 162 reads

Posted in Vinay Thakur on 2 September 2018

Fog Computing

Its been introduced by CISCO On November 19, 2015, system which helps cloud computing to reduce the response time from cloud computing to send-receive the information. i think as it is more like a product/Concept might be the reason not … Continue reading

Read more

0 comments, 199 reads

Posted in Vinay Thakur on 2 September 2018

Apache Hadoop Ozone+HDDs and Kubernetes

As Hadoop is already a great on BIG Data, now as you know hadoop has addition stuff in it with concept called “Ozone” works with HDFS Datanode plugin and HDDs. “Ozone is designed to scale to tens of billions of … Continue reading

Read more

0 comments, 289 reads

Posted in Vinay Thakur on 9 July 2018

Kubernetes

Have you heard the name Kubernetes, it is another open source in the market by Google and works one Containers, like Docker on Cloud. Kubernetes v1.0 was released on July 21, 2015 by Cloud Native Computing Foundation (CNCF). Future is … Continue reading

Read more

0 comments, 199 reads

Posted in Vinay Thakur on 6 July 2018

Microsoft Acquire GitHub after Linkedin

Microsoft acquires GitHub is a very big news after LinkedIn… that way now Microsoft will grow like anything as considering the information it has at GitHub, it will have a great help of open source information at GitHub will provide … Continue reading

Read more

0 comments, 302 reads

Posted in Vinay Thakur on 6 July 2018

Day 25 Optimization

Locking is depends upon Isolation level and Storage Engine. MySQL uses table level locking (instead of page, row, or column locking) for all storage engines except InnoDB, which uses row level locking locking system in MySQL: Implicit Locking: To maintain the … Continue reading

Read more

0 comments, 204 reads

Posted in Vinay Thakur on 25 May 2018

Day 24 Replication Setup

Today we will discuss how setup a replication: Master – Slave Replication: Requirement: 2 (Linux) System (MasterServer and SlaveServer) MySQL Installed Connection to both servers are accessible. On Master Server: Edit my.cnf with following information: [mysqld] Log-Bin =MySQL_Binlog Server_ID=1 Create … Continue reading

Read more

0 comments, 221 reads

Posted in Vinay Thakur on 24 May 2018

Day 23 Replication

Replication means making copy of the objects and moving transaction from primary server to secondary/standby/Slave server. There are two type of Replication Master-Master Replication Master-Slave Replication Like other RDBMS MySQL works replication on Transactions. The pre requisite of replication is … Continue reading

Read more

0 comments, 188 reads

Posted in Vinay Thakur on 23 May 2018

Day 22 Other Storage Engines

So far we have discussed InnoDB, MyIASM and NDB Storage engine which are most standard/common and important storage engine MySQL has, there are some other Storage engine which are specific to the business requirement and used only for their special … Continue reading

Read more

0 comments, 154 reads

Posted in Vinay Thakur on 21 May 2018

Day 21 NDB Storage Engine (Cluster)

MySQL also support High Availability, NDB Storage engine provides high availability- shared-nothing system, NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (which stands for “Network DataBase” NDB Cluster required 3 Nodes required complete the setup: Management node(mgmd): … Continue reading

Read more

0 comments, 189 reads

Posted in Vinay Thakur on 21 May 2018

Day 20 Innodb Storage engine

InnoDB is the major Storage engine and is default Storage engine after MySQL 5.5 version. As standard RDBMS requires ACID properties and to make the Enterprise level of the system requires Transaction management. Before this MySQL was known to be … Continue reading

Read more

0 comments, 153 reads

Posted in Vinay Thakur on 21 May 2018

Day 19 MyIASM Storage engine

MyIASM storage engine is available from the early stage of MySQL this engine is developed from IASM language and it is used for Read intensive operations. As described in yesterday this Engine was default till MySQL 5.5 and is widely … Continue reading

Read more

0 comments, 168 reads

Posted in Vinay Thakur on 19 May 2018

Day 18 Storage engine

MySQL is special compare to all the other RDBMs System because of its special architecture, the STORAGE Engine. MySQL has many storage engine as per the developer/application requirements. With this good part is that MySQL can work multiple storage engine … Continue reading

Read more

0 comments, 178 reads

Posted in Vinay Thakur on 18 May 2018

Older posts