Welcome at edition 2 of my Data News selection of the past week. I’ve tried to capture as many links as possible. Some are brand new (like the #meltdownattach and #spectre ones), others are older but I found them this week. Take yourself some time and enjoy the reading…
PS: I am not sure if next weeks edition will be a very full one – Next week is #SQLSatVienna 2018 week and I think my upcoming week is filled with preparation work!
Security News (Meltdown, Spectre)
- Understanding the performance impact of Spectre and Meltdown mitigations on Windows Systems by Terry Myerson (https://cloudblogs.microsoft.com/microsoftsecure/2018/01/09/understanding-the-performance-impact-of-spectre-and-meltdown-mitigations-on-windows-systems/)
- Collected List of security informations from different vendors (hardware, software); page is german, but points to (mainly) english pages (https://www.heise.de/newsticker/meldung/Meltdown-und-Spectre-Die-Sicherheitshinweise-und-Updates-von-Hardware-und-Software-Herstellern-3936141.html)
- German: Meltdown und Spectre erklärt (heise) https://www.heise.de/newsticker/meldung/Analyse-zur-Prozessorluecke-Meltdown-und-Spectre-sind-ein-Security-Supergau-3935124.html
- Update for Surface Devices [2018-01-09] (https://blogs.technet.microsoft.com/surface/2018/01/10/updates-for-surface-devices-09-january-2018/)
Documentation / Best Practices / References / Learning
- A Plethora of Microsoft Training Options on AI, Machine Learning & Data Science, including MOOCs (https://blogs.technet.microsoft.com/machinelearning/2017/01/25/a-plethora-of-microsoft-training-options-on-ai-machine-learning-data-science-including-moocs/)
- Collection of 27 free data mining books by Data Science Central (https://www.datasciencecentral.com/profiles/blogs/27-free-data-mining-books)
SQL Server / Azure SQL Database / Azure Databases
- Cumulative Update #3 forSQL Server 2017 RTM (https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-3-for-sql-server-2017-rtm/)
- Compatibility Level 140 is now the default for Azure SQL Database (https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/01/10/compatibility-level-140-is-now-the-default-for-azure-sql-database/)
- Azure SQL Datawarehouse, the cost benefits of an on-demand data warehousing (https://azure.microsoft.com/en-us/blog/azure-sqldw-the-cost-benefits-of-an-on-demand-data-warehousing/)
Power BI / Business Intelligence / AI / Azure & SSAS / Azure / Machine Learning / IoT
- Everyday AI – The story of AI at Microsoft by Harry Shum (https://www.linkedin.com/pulse/everyday-ai-harry-shum/)
- Recent AI Platform Updates [ONNX, Deep Learning, Video Indexer & more] (https://blogs.technet.microsoft.com/machinelearning/2017/12/22/icymi-recent-microsoft-ai-platform-updates-including-deep-learning-onnx-video-indexer/)
- Is the traditional data warehouse dead? by James Serra *highly recommended* (http://www.jamesserra.com/archive/2017/12/is-the-traditional-data-warehouse-dead/)
- How to Run Large-Scale Educational Workshops in Deep Learning & Data Science (https://blogs.technet.microsoft.com/machinelearning/2018/01/10/running-large-scale-educational-workshops-in-deep-learning-data-science/)
- 10 IoT predictions for 2018 (https://iot-analytics.com/iot-predictions-2018/)
- Power BI and PowerApps Integration (PowerApps Visual)
- Adding Comments & Sending Emails in Power BI using PowerApps by SQLJason (http://sqljason.com/2018/01/adding-comments-sending-emails-in-power-bi-using-powerapps.html)
- Power BI Writeback by Teo Lachev (http://prologika.com/power-bi-writeback/)
- Time Series Insights – new developer tools announced (https://azure.microsoft.com/en-us/blog/build-richer-apps-with-your-time-series-data/)
- Expanded options for accessing Cloud Shell (https://azure.microsoft.com/en-us/updates/expanded-options-for-accessing-cloud-shell/)
- Azure Analysis Services (Christian Wade) as guest at Azure Friday Channel 9 show (https://channel9.msdn.com/Shows/Azure-Friday/Azure-Analysis-Services-Scale-Out-Diagnostics)
Tools
- SQL Operations Studio December 2017 release https://blogs.technet.microsoft.com/dataplatforminsider/2017/12/19/the-december-release-of-sql-operations-studio-is-now-available/
- MSSQL-CLI – a new command line tool for SQL Server https://blogs.technet.microsoft.com/dataplatforminsider/2017/12/12/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server/
Thanks,
Wolfgang