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 (2018-09-09)
Automatic intelligent insights to optimize performance with SQL Data Warehouse With no additional costs, Azure SQL DW delivers you best practice recommendations in terms of data skew and suboptimal table
){kind=link}
Last Week Reading (2019-07-21)
Another week passed. Look what did I find during that time. Press British Airways faces record £183m fine for data breach The penalty imposed on BA is the first one
Last week reading (2018-01-14)
The top 7 business benefits of establishing DevOps in your organization No comments, find and understand the benefits. Columnstore Indexes – part 116 (“Partitioning Specifics”) What do you need to
0 Comments
No Comments Yet!
You can be first to comment this post!