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. but here are some key features it has:

  • Integrated High Availability and support for multiple Database technologies like  Big Data , NoSQL and other RDBMS together (extended version of Polybase).
  • Extended support to Java with machine learning (R and Phyton).
  • support for kubernetes for containers.
  • Improved in performance on adoptive query processing – Intelligent query processing.
  • Replication with other OS.

and many more

 

Reference:

https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-ver15?view=sqlallproducts-allversions

 

 

 

Advertisements
Posted in Others, SQL Server 2019, Whats New | Tagged , | Leave a comment

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 provides MongoDB as a service from the people who build MongoDB.

MongoDB Cloud Manager

Cloud Manager is a hosted platform for managing MongoDB on the infrastructure of your choice.

MongoDB Ops Manager

Ops Manager is a comprehensive application that helps you manage MongoDB safely and reliably in your own data center

ATLAS: MongoDB database can be supported/ managed by MongoDB company and they will take care of the system for you and they charge per on cloud, this concept is called ATLAS.
Atlas is Secure per standard and supported on major provided like – AWS, Azure and Google.

Stitch:  for atlas for development purpose.

BI : ATLAS also provides support to BI tools like Micro strategy/Ta-blue , chart  for analysis purpose.

at keynote – Eliot Horowitz has shared a great information and future of MongoDB:

Inter cloud replication in future MongoDB will be planning to support that, it would be a great thing which will come

MongoDB 4.02+ would be great and would be future ready System.

Would write more about it later.

Reference:

https://explore.mongodb.com/mongodb-local-chicago?utm_campaign=Int_PAE_MongoDB.local%20Chicago_09_18_AM_Presentations&utm_me

https://docs.mongodb.com/?_ga=2.97942555.529442568.1538862857-1764059967.1535865498dium=email&utm_source=Eloqua

Posted in Cloud, Future DBA, NoSQL, Others | Tagged , , , | Leave a comment

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.

This version of MySQL is latest and having almost all the latest functionality and stability. Oracle has performed great investment on it and had grand events for its release all across the world specially ASIA, Europe and America.

The important of this Version is that from ver 8.0 on it would be more specific to Oracle and oracle Cloud integration. due to this MySQL would be more like a Enterprise system and some of the things are not open for Open source team. Oracle has made major changes in the Engine more compatible with Cloud.

MySQL 8.0 and ndb 7.6 are more stable and enterprise related and fixed most of the BUGs on earlier version of Engine.

Following are some of the features:

  • Cloud Ready Database.
  • Performance – Up to 2x faster than MySQL 5.7
  • spatial datatypes,
  • NoSQL – Document Store
  • JSON – Extended syntax,
  • Security

This will make MySQL more like a Dedicated Oracle Product — I guess.

Reference:

https://www.mysql.com/news-and-events/

 

 

Posted in Database System, MySQL, News, Others, What I learned today, Whats New | Tagged , , , | Leave a comment

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

Posted in Database System, Others | Tagged , | Leave a comment

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, and Eventually Consistent. Eventual consistency is faster on writes because the application doesn’t have to wait to see if the write persisted. As soon as the data store captured the write, but before it is persisted to disk or to another machine, it could tell the application the write was successful and the application could move on to the next operation. So you gain a performance advantage but at the risk of not seeing the data you just wrote, or the data might be lost altogether in an error condition. — refer from Rick Negrin blog.

now like other Database system, MongoDB also expanded its area and explore more options :

Supports ACID property – Multi-document ACID transactions.

Snapshot Read Concern -Isolation/ Better read

Non-Blocking Secondary Reads – live reads

Extensions to Change Streams – real time data change

Data Type Conversions – for better ETL

Improved Migrations Throughput – for better migration

Improved Sharding Operations – better sharding

Slow Query Logging on mongos – better for troubleshooting

This definitely shows that future MongoDB will be considered to be database system and future proof compare to other RDBMS and database system. the value add to this is its a FREE and open Source. 

Reference:

https://docs.mongodb.com/manual/release-notes/4.0/

https://www.linkedin.com/pulse/mongodb-40-new-features-nutshell-jerwin-roy/

 

Posted in Future DBA, NoSQL, Others, RDBMS | Tagged , | Leave a comment

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 perform everything by its own(autonomous) automatically and no human intervention required, includes:

Dynamic resource Resource management

Pay as you use.

Auto Performance

Auto Maintenance – Online

Auto Patching  security Compliance/ Security thread management

Dynamic database creation

Dynamic HA  & Redundancy

99.995% up-time (2.5 Minutes Per Month)

& Many More…

Their would be Oracle 19c which will be released mostly by Jan 2019. which has more features on autonomous system.

If it works what all asked it could be possible that Oracle would be getting more market at cloud as well from Amazon. but we have to wait for it. the very important point here is the $$$$, as this days investing on the infrastructure is reduced drastically due to Open system/ Free ware market is increased and for every system we have open source system.

Future of Database system would be more and more of and automation system, similar kind of concept is getting introduced by almost all the Database system includes MSSQL Server, MongoDB , IBM, Google, AWS and others as well. so we have to see how Database management system will see in future.

Increasing the Data growth and Analytic system. database system will be things to see…. time will tell us.

 

https://www.oracle.com/database/autonomous-database/feature.html

 

 

Posted in Cloud, Future DBA, News, oracle, Others, RDBMS, Whats New | Tagged , , , , | Leave a comment

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 its own feature and good stuff and purpose.

MemSQL can be setup per our requirement like can save data on Memory and can be committed later(in-memory), can have redundancy and HA as cluster and replication. it can be used for Analytics as BI. more of an another RDBMS.

I am not a great fever for MemSQL but i am writing this just to be aware that MemSQL existing like other RDBMS.

But Some take it more then this like : Rick Negrin

Reference:

https://en.wikipedia.org/wiki/MemSQL

https://www.memsql.com/

 

Posted in Future DBA, NoSQL, Others, RDBMS, What I learned today, Whats New | Tagged , , , | Leave a comment

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 that everyone wanted to show that they can do better and do anything what other can do and would wanted to be in RACE for future database system… these database i am avoiding to specify RDBMS/NOSQL and other terms and things are getting complicated on those terms as all can do everything – i guess.

will try to write some blogs on this … Happy Learning as always :).

 

Thanx,

Vinay

Posted in Database System, News, Others, What I learned today, Whats New | Tagged , , | Leave a comment

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 so known. I am just writing this to make sure we understand the concept.

if cloud computing has faster response for send and received information. we may not required to have it.

This is my understanding.

Reference:

https://en.wikipedia.org/wiki/Fog_computing

Posted in Cloud, Computers and Internet, Future DBA, General, Others | Tagged , , , | Leave a comment

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 files and blocks and, in the future, even more.
Small files or huge number of datanodes are no longer a limitation”

So now Hadoop has gone futher Biggerrrrr. with this. it stores the information of named node in “Blocks” and can save trillions of data and unlimited data nodes.

with the of Kubernetes it can be feasible to use the system for efficient for distribution of the system.

Reference:

http://ozone.hadoop.apache.org/

Posted in BIGDATA, Others, Whats New | Tagged , | Leave a comment