Last week reading (2018-07-22)
Good day SQL folks!
Now and it is almost Tuesday morning, let me give you some things to read for the rest of the day!
Execute all SSIS packages in parallel with ADFV2 looup and foreach activities
Follow up from the SQL Saturday in Manchester where Paul Andrew demonstrated how to use ADF with expressions and parameteres.
Storage mode in Power BI Desktop (Preview)
In Power BI Desktop you can specify the storage mode of tables, providing you with control over whether table data is cached in-memory for reports.
Power Query gets simpler and better… For example you can extract data from PDF files and HTML pages. And lot more…
In SQL Server, when talking about table partitions, basically, SQL Server doesn’t directly support hash partitions. It has an own logically built function using persisted computed columns for distributing data across horizontal partitions called a Hash partition.
Don’t forget to hear to this great interview we did with Rob!
Cheers,
Damian
About author
You might also like
Last Week Reading (2019-01-13)
Good morning chaps! Bunch of news from the world of data freshly served. Press Office Hours 2019/1/2 (With Transcriptions) The last episode. Personally, I’m sad, but waiting for new ideas
Last Week Reading (2019-06-23)
Hello folks! Let’s take a look at a set of information from the field again. Press The best practices for performance comparison between Azure SQL Managed Instance and SQL Server
Last week reading (2018-08-05)
Microsoft Azure Data welcomes Data Platform Summit attendees Rohan Kumar [B|T] invites to have a look at today’s mobile-first, cloud-first world and what has been changed in the area by Azure





0 Comments
No Comments Yet!
You can be first to comment this post!