Tuesday, 21 March 2017

Getting Started with Azure SQL Data Warehouse - Part 3

Introduction


Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In my first article of the series, I talked about traditional ways of creating data a warehouse and the challenges with it in the current scenario, then discussed Azure SQL Data Warehouse, and how it helps in meeting the changing demands for the current business. In my second article of the series, I covered the architecture of Azure SQL Data Warehouse in detail and how you can scale up0 or down based on your need. In this article I am going to talk about the different types of tables we can create in SQL Data Warehouse, how they impact the performance and best practices around them. We will also get started with creating our first SQL Data Warehouse database, etc.

Wednesday, 15 March 2017

Getting Started with Azure SQL Data Warehouse - Part 2

Introduction


Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In my last article of the series, I discussed the traditional way of creating a data warehouse and the challenges associated with it in the current scenario. Then we talked about Azure SQL Data Warehouse, and how it helps meet the changing demands for current business. In this article, I will cover the architecture of Azure SQL Data Warehouse and how you can scale up or down, based on your need.

Wednesday, 8 March 2017

Getting Started with Azure SQL Data Warehouse - Part 1

Introduction


As the demand for data analytics grows so does the need for a technology or platform to process large amounts of different types of data in timely manner. A platform that can be easily scaled up or down, based on increased or decreased demand, has become an imminent need for all those organizations that want to do data analytics on a large scale of varied data.

Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just a few minutes. In this article series, we will dive deep into this data warehouse-as-a-service offering from Microsoft.

Friday, 3 March 2017

Oracle for Absolute Beginners: Users, Synonyms, Privileges, & Roles

I accidentally locked myself out of my house this evening, and so I had to climb up the wall like a burglar and clamber in through a bathroom window, while the neighbourhood kids all watched and giggled, probably taking secret photos to share on Snapchat or something.

Embarrassing, yes, but what’s it got to do with Oracle? Well, the point is this: no one called the police.

And that’s because it’s my house. And while having gifs on Instagram of my bum squeezing through a small window might be embarrassing, we all understand that I can do whatever I please with my property.