Ten Trends in Enterprise Database Technology

We might think that database technology is a matured technology and there are no trending prospects in the Database. Databases are more used to store data for the applications yet there are trending in the databases as well. 

1. Cloud Support for Databases

Cloud support for databases seems to be an undoubted trend for databases. If you look at the cloud databases, now cloud vendors are looking at supporting varieties of databases. AWS supports eleven databases which fall into seven types as shown below.

Detail at: https://aws.amazon.com/products/databases/?nc2=h_ql_prod_db

Microsoft Azure is putting up his hand to extend the different support for multiple databases as shown below. 

If you look at the Gartner Magic Quadrant  for Cloud Database Management Systems

you will see a lot of players are fighting with small margins. 

2. Time Series Databases

Though you can save data time column in a database, the database simply will not become a time series databases. There are databases such as InfluxDB which does more than storing date-time data. 

3. Graph Databases

Every data is not row-column format and you would like to represent data in graphical format using Graph DB. 

Go to this link for the other details of Trends in Database technology. 

Templates in Draw.IO

During a post around two months ago, we discussed that Draw.IO can be used to draw diagrams. Further to the discussed options, there are more than 100 templates that you can choose from Draw.io as shown below. 

Let us look at a few templates that you have in Draw.Io for Azure and AWS. 

The following figure is something that was designed using the Draw.IO using the native controls. 

 

Creating your First Azure SQL Database

As the cloud has become something that you cannot avoid in the current technology race, it is important to understand what are the options you have to create a database in the Azure platform. As shown in the below image, there are different architectural options.

If you are interested in only the Azure cloud option, then you have the following options. 

To elaborate on how to create an Azure SQL database, here is the latest article at sqlshack. 

https://www.sqlshack.com/creating-your-first-azure-sql-database/ 

Technology Initiatives

If someone asks what are the top three priorities what do you say? Is it Cloud, DevOps, Machine Learnings, IoT? The following is the survey done by Flexera for 303 respondents. 

Still, DevOps, Machine Learning, Big Data are not in the priorities list though many of us are taking on those topics. Digital transformation, Cybersecurity and Cloud migrations are in the top technology initiatives. 

  

Cloud and Insurance

When you design your system, in most of the cases, it seems like designers taking things to be granted that Cloud will solve you most of your fault tolerance headache. Though this is true for some extend, being a system architect, you need to evaluate features of different Cloud vendors before choosing. You need to evaluate features technically without falling into the marketing traps of vendors. Mind you there is something called vendor locking. After you choose (or marry) a vendor, it is very difficult to change your vendor locking. 

I see a similarity between the cloud vendors and the insurance industry. Both are unfortunately running heavily on marketing myths. 

If you look at, Sri Lankan society before around three decades, we were a society that was not much considered about fear. Fear is something you need to introduce if you want to be  success in the insurance industry. So what did they do? They brought fear into society by means of Teledramas. What we had in teledramas? Suddenly, your spouse dies from a Moter Bike accident. Then they introduced a new scheme of insurance for Motor Bike. I can tell many stories reference to these insurance marketing.  

 In Europe, they called soap operas as the prime idea of these operas were to market soap. So we can call our teledramas, Insurance Teledramas.

After Insurance companies expand over society, now it has become something we cannot ignore. Further, you know the hassle that you need to undergo when it comes to claiming. I have a feeling that the Cloud industry will take the leaf out from the book of insurance. 

Finally, I am not saying NO for clouds, but you need to be careful with the marketing slogans of Cloud vendors before we fall into the Vendor locking trap. 

Magic Quadrant for Data Management Solutions for Analytics

Microsoft was leading in the Gartner quarter for while and Oracle was not promising in this. However, with the 2017 results, landscape has changed.



You can read the details at https://www.gartner.com/doc/reprints?id=1-3T5J67S&ct=170209&st=sb

The Future of Managing Databases in a Hybrid IT World

When you work in information technology long enough, you get to see how people react when something new comes along. Some people embrace change, even to the point of being an early adopter. Others might use a wait-and-see approach. And then there is the group of people who are afraid of change in any form. 

Read more at http://sqlmag.com/sql-server/future-managing-databases-hybrid-it-world

Microsoft Offers Azure SQL Data Warehouse for Limited Preview

Microsoft is cracking the door to its cloud data warehouse. The Azure SQL Data Warehouse is now ready to accept data from customers in limited use cases.

Azure SQL Data Warehouse, Microsoft's cloud-based data repository offering, is available as a limited preview, the company announced yesterday.

Read more http://www.eweek.com/cloud/microsoft-offers-azure-sql-data-warehouse-for-limited-preview.html

Microsoft Introduces Azure SQL Data Warehouse

Microsoft today announced a new service in its Azure database lineup during its Build developer conference keynote today. The Azure SQL Data Warehouse, which will go into public preview in June, is meant to give businesses access to an elastic petabyte-scale, data warehouse-as-a-service offering that can scale according to their needs.

 

Read more at http://techcrunch.com/2015/04/29/microsoft-introduces-azure-sql-data-warehouse/#.rjdbv4:2K0T

Microsoft reveals new version of cloud-based Azure SQL database service

The new version of Azure SQL is faster, handles more data than ever, and comes with new capabilities that further reduce the gap between the cloud-based Azure SQL Database and on-premise SQL Server.

Read more at http://www.fiercecio.com/story/microsoft-reveals-new-version-cloud-based-azure-sql-database-service/2015-02-03

Get a SQL Server Environment in 5 minutes!

Do you need a cloud SQL Server Environment. CloudShare will provide you this.

One account will be active for two weeks. In case you need to connect from remote you nee to change the SQL Server port any of following port number list.

3389, 8000,  30015, 50013, 50014

Infrastructure as a Service for SQL Server

SQL Server Virtual images available for SQL 2008 R2 and SQL Server 2012 in 3 editions – Web, standard and enterprise.  If you have an existing SQL Server license with software assurance, as an additional benefit you can move your existing license to Windows Azure and simply pay for compute and storage.                 

Prices are determined based on

• Size of the database
  • Web Edition if size of database < 5 GB
  • Business Edition if size of database < 150 GB
  • Least unit for which prices are charged is a GB. Example: If a database is 2.4 GB,  charges will be levied for 3 GB

• Computing power required

• Version of License

your free trial contains

 

http://www.windowsazure.com/en-us/pricing/free-trial/

virtual machines & cloud services / 750 compute hours per month

• SQL server / 750 hours of web, standard, or enterprise
• web sites / 10 web sites
• mobile services / 10 mobile services
• relational database / 1 SQL database
• SQL reporting / 100 hours per month
• storage / 70 GB with 50,000,000 storage transactions
• backup / 20 GB
• data transfer / unlimited inbound & 25GB outbound
• media services encoding / 50 GB (input & output combined)
• cdn / 20 GB outbound with 500,000 transactions
• cache / 128 MB
• service bus / 1,500 relay hours and 500,000 messages

Top 10 Cloud Stories Of 2012

Here’s a list of the Cloud Computing Exchange’s 10 most-read stories in 2012: