(Jeeva Subburaj) This article explains how to create generic parser API to parse video feeds from various sites that supports RSS/Atom feed or scraping the content from DOM element and return the custom XML / JSON output based on requested streaming box supported format.
Other News
IBM Db2 Analytics Accelerator can now be deployed on IBM Z
(Sowmya Kameswaran) Yes! The IBM Db2 Analytics Accelerator for z/OS V7.1 (IDAA) now deploys directly on IBM Z.
SQL SERVER – Install Error: Microsoft Cluster Service (MSCS) Cluster Verification Errors – Part 2
(Pinal Dave) In recent past, I was assisting a client in installing SQL Server clustered instance in a Windows Cluster. There were many errors encountered and I learned a lot from this experience. In this blog, we would learn about Microsoft Cluster Service (MSCS) cluster verification errors which m
Visual Studio Toolbox: Getting started with Windows IoT Episode #3
(Robert Green) In the third episode of this series, Dmitry and Suz introduce a smart home device prototype designed to integrate several devices and Azure services together. This smart home device makes use of a proximity sensor, temperature sensor, webcam, and a small HDMI screen. The Azure service
Tips for using table hints in SQL Server 2017
Tips for using table hints in SQL Server 2017 If you want to set any table hints, do not remember to test the query with hint and without the hint and compare results. Because SQL Server 2017 query optimizer usually proposes the best execution plan, you should test the query with table hint and use this hint only when it...
Db2Night Show #z88: Db2 Security Best Practices Volume II
(Martin) 100% of our studio audience learned something!Dave discussed the latest Db2 security methods, procedures and techniques for fortifying DB2 systems, databases and applications. A must-see!
How to use React (and Redux) with your crufty old CMS
(James Sinclair) Getting your JavaScript to run well on a CMS can be difficult at the best of times. But the difficulty grows exponentially when you add something like React and Redux. And this isn’t the fault of the CMS.
How to enable SQL Server Service Broker
(Jack Vamvas) 1) SQL Server Service Broker is enabled per database , so If you need to enable Service Broker on multiple databases , some sort of dynamic level sql is required , as there is no Server level command to activate all databases .
SQL Tips – Issues with BCP when you have two SQL Server instances
(Manoj) I observed one thing here with BCP (Bulk Copy Program), when you have 2 versions of SQL Server installed on you PC or Server. I had SQL Server 2014 & 2016 installed on one of my DEV server.
Azure SQL DW Performance: CTAS/Partition Switching VS UPDATE/DELETE
(Tim Salch) DML operations can be resource intensive and harmful to CCI indexes in Azure SQL Data Warehouse. The main performance benefit comes from UPDATE & DELETE operations being fully logged and CTAS is minimally logged.