SQL Archives - Page 200 of 519 - SQL Authority with Pinal Dave

Big Data – Data Mining with Hive – What is Hive? – What is HiveQL (HQL)? – Day 15 of 21

October 21, 2013

Big Data, SQL, SQL Server, SQL Tips and Tricks

In yesterday’s blog post we learned the importance of the operational database in Big Data Story. In this article we will understand what is Hive and HQL in Big Data Story. Yahoo started working on PIG (we will understand that in the next blog post) for their application deployment on Hadoop.…

Professional Development – Difference Between Bio, CV and Resume

October 20, 2013

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Professional Development

Applying for work can be very stressful – you want to put your best foot forward, and it can be very hard to sell yourself to a potential employer while highlighting your best characteristics and answering questions. On top of that, some jobs require different application materials – a biography…

Big Data – Operational Databases Supporting Big Data – Columnar, Graph and Spatial Database – Day 14 of 21

October 18, 2013

Pinal Dave

Big Data, SQL, SQL Server, SQL Tips and Tricks

In yesterday’s blog post we learned the importance of the Key-Value Pair Databases and Document Databases in the Big Data Story. In this article we will understand the role of Columnar, Graph and Spatial Database supporting Big Data Story. Now we will see a few of the examples of the operational databases.…

Big Data – Operational Databases Supporting Big Data – Key-Value Pair Databases and Document Databases – Day 13 of 21

October 17, 2013

Pinal Dave

Big Data, SQL, SQL Server, SQL Tips and Tricks

In yesterday’s blog post we learned the importance of the Relational Database and NoSQL database in the Big Data Story. In this article we will understand the role of Key-Value Pair Databases and Document Databases Supporting Big Data Story. Now we will see a few of the examples of the operational databases. Relational…

Big Data – Operational Databases Supporting Big Data – RDBMS and NoSQL – Day 12 of 21

October 16, 2013

Pinal Dave

Big Data, SQL, SQL Server, SQL Tips and Tricks

In yesterday’s blog post we learned the importance of the Cloud in the Big Data Story. In this article we will understand the role of Operational Databases Supporting Big Data Story. Even though we keep on talking about Big Data architecture, it is extremely crucial to understand that Big Data system can’t…

SQL SERVER – How to easily work with Database Diagrams

October 15, 2013

Pinal Dave

SQL

Devart

The right methodology of designing a database is based on the foundations of data normalization, according to which we should first define database’s key elements – entities. Afterwards the attributes of entities and relations between them are determined. Let us learn in this blog post how to work with database diagrams.

Big Data – Buzz Words: What is NewSQL – Day 10 of 21

October 14, 2013

Pinal Dave

Big Data, SQL, SQL Server, SQL Tips and Tricks

In yesterday’s blog post we learned the importance of the relational database. In this article we will take a quick look at the what is NewSQL. What is NewSQL? NewSQL stands for new scalable and high performance SQL Database vendors. The products sold by NewSQL vendors are horizontally scalable. NewSQL…