Skip to main content

Azure Synapse Analytics: Replacing Azure SQL Data Warehouse?

This month was a very busy month for Microsoft BI and Analytics space. Because two major events happened in last couple of weeks. Microsoft Ignite 2019 and PASS Summit. Whats interesting is both events have provided the opportunity to browse and watch on-demand sessions. In both events very special feature drew my attention. Which is called Microsoft Synapse Analytics.

Microsoft Synapse Analytics is the latest and greatest way of Implementing Data Warehouse at Scale in Azure. Interesting thing is its looks like the upgrade of formerly Azure SQL Data Warehouse.

You can lean more on Azure Synapse Analytics





However, I've added a video with Demo on Azure Synapse Analytics done at Microsoft Ignite Event. This explains querying Big Data live and comparison with Amazon Red Shift and Google Big Query. You also able to perform Machine Learning workload at the same environment.


Labels:

Comments

  1. Cognex TechnologyFebruary 20, 2020 at 2:35 AM

    Great piece of information. I found useful things here. For more details visit cognex technology for Microsoft azure course

    ReplyDelete
  2. UnknownFebruary 25, 2020 at 10:52 AM

    If you're trying to lose weight then you certainly need to jump on this brand new tailor-made keto plan.

    To create this service, certified nutritionists, personal trainers, and chefs united to develop keto meal plans that are powerful, decent, economically-efficient, and delicious.

    Since their first launch in early 2019, hundreds of people have already completely transformed their body and well-being with the benefits a professional keto plan can offer.

    Speaking of benefits: in this link, you'll discover 8 scientifically-tested ones given by the keto plan.

    ReplyDelete
  3. Carol HooperSeptember 2, 2020 at 3:44 AM

    If anyone of you wants to search for the reliable plan for transforming the unstructured data to useful and actionable, then you can click here to learn more about data warehouse services .

    ReplyDelete
  4. wnDecember 1, 2020 at 2:12 AM

    My spouse and I love your blog and find almost all of your posts to be just what I’m looking for. Appreciating the persistence you put into your blog and the detailed information you provide. I found another one blog like you Data Analytics .Actually I was looking for the same information on internet for Data Analytics Service and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete

Post a Comment

Popular posts from this blog

Step-by-Step Twitter Sentiment Analysis Using Power BI Streaming Dataset, Microsoft Flow and Azure Text API

Sentiment Analysis is known as Opinion mining or emotion AI which is a branch of Natural Language Processing and text analytics where systematically identify, extract, quantify, and study affective states and subjective information. This kind a analysis widely apply to analyse the product or service reviews, voice of the customer, survey responses from online and social media feeds to analyze the attitude of the customer. Basically from the sentiment analysis the output would be either Positive, Negative or Neutral.  There are various algorithms and methods to do a sentiment analysis out there. In this post here I'm doing a sentiment analysis for iPhone 8 product by analyzing twitter feeds. Because, I wanted to know what others are thinking about the latest phone released by Apple. In order to do this task I'm using,  Microsoft Azure cognitive services : Text Analytics (to run the sentiment analysis algorithms to get out the results)  Microsoft Flow ...
5 comments
Read more

How to Get Row Counts for all Tables in your SQL Database

This is the simplest method to get the row counts of all tables in your SQL Server database. Might be useful when you are doing the data testing over your BI project.     select   schema_name (tab.schema_id) , tab.name  as  [table],         sum (part.rows)  as  [rows]     from  sys.tables  as  tab          inner join  sys.partitions  as  part              on  tab.object_id  =  part.object_id where  part.index_id  IN  ( 1 ,  0 )  //   0 :  Table   without  PK,  1 :  table   with  PK and   schema_name (tab.schema_id)  =   'dbo'   group by   schema_name (tab.schema_id) , tab.name --order by sum(part.rows) desc  
Post a Comment
Read more

COVID-19 Situation in Sri Lanka: Real-time Dashboard using Power BI

[Updated on March 28, 2020] COVID-19  is a new strain that was discovered in late December, 2019 and by now it has been started to spread all over the world including 199 countries. There are around 26,000 people were died due to the virus and 580,000 confirmed cases at the moment I update this blog post. Though, the fatality rate is lower when compared to other viruses in similar strains like MERS and SARS . However, the biggest challenge most of the countries facing right now is to accommodate the patients with the growing numbers at every minute. The public was asked by the government to avoid nonessential gatherings as much as possible to stop spreading this deadly virus. Even though there were not many cases found in Sri Lanka, from March first week, they found the initial case a patient who works as a tourist. Now the situation is turning to worst after they found many cases especially tourists who are born Sri Lankans came down from Italy and European countries....
4 comments
Read more