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-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
Last Week Reading (2020-06-28)
Press ExpandString in Powershell This function can do much more than you think. Pester – using -should -throw Useful example when you want to filter output by ExceptionType or ErrorId. ADF:
Last Week Reading (2019-03-03)
Hey everyone! I was very busy at the SQLBits conference last week, but it did not stop me to prepare some materials for you. Press Data Never Rests Video from
0 Comments
No Comments Yet!
You can be first to comment this post!