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. AnonymousFebruary 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

Run T-SQL Script Files Using Command Line

Most of the time when we need to execute a SQL script or statement, then we go for SQL Server Management Studio to execute our T-SQL scripts. But the same result we can achieve using Command Prompt. This is very simple way to do that just a matter of write a command and pass few arguments. You can see the process status like as in when you execute a query in Management studio. Use-case : There may be having some situations you won't be able to execute T-SQL script using Management Studio. Most of the time when doing data population. In my case, I had a situation I needed to populate a Database without using backup/restore. Once I generated script with all the schemas and related data it took around 400+Mb sql file.  SQL Server Management Studio will not allow you to run the script unless you execute the query in high-end box. Because, when the file loaded to the memory it will too hard to cater our requirement. You may probably get  memory ...
Post a Comment
Read more

How to Create a Date Table in Few Steps Using Power BI

Calendar Dimension or Calendar Table is one of the crucial table in a Power BI model. I never have seen any data warehouse data model which does not have a Calendar table so far in my development. Because, when it comes to data warehousing or dimension modeling you may storing various business processes or events as Facts. So those events anyway occur in particular date or time. So simply there wouldn’t be a Power BI data model without a date table. In this post, I’m going to share with you how to create a date table within few steps. Actually, there are two DAX measures which we can use to create a date table. Calendar(DAX) and CalendarAuto(Auto). Calendar(DAX) = You can pass start date and End date as parameters you need to create date table. CalendarAuto(DAX) = You can use this function without passing any parameter. Then it will generate the dates based on your data model dates.  You can simply copy the below DAX code and paste in your Power BI Desktop DAX e...
7 comments
Read more

Value Encoding in Vertipaq Engine

If you can remember my last blog post regarding Vertipaq engine inside SSAS Tabular , I’ve discussed three algorithms which are in use when process the model. Processing in the sense perform data loading from the relational source and load into the tabular structure. In here data compression is taken place in order to save the memory footprint. It is really important because all the data we had in the data warehouse or source relational database after processed the model load into the memory. So by the compression save the huge amount of memory space and it will utilize your hardware optimum way while faster scans because the data model is smaller than the original. These are the steps taking place when we process the tabular model from SSDT or via SQL Server Management Studio.  Read the data from the source database and transform into columnar structure or vertipaq data structure while data encoding and compression occurs. Creating of dictionaries and indexes for eac...
Post a Comment
Read more