(Martin) 100% of our studio audience learned something!Terry covered how the Db2 optimizer is changing to incorporate machine learning features.
Community
Capturing an Image from a Webcam Using .NET
(Tapas Pal) Webcams are an easy and cost-effective way to take images from a video stream. In this modern era of smartphones, everyone has a camera which could be used by Web applications to capture live pictures.
Building Single Page Applications (SPA) with Angular Router
(V Keerti Kotaru) Routing is an important aspect of building a SPA (Single Page Application). In this two-part Basic to Advanced tutorial on Angular Routing, we will discuss all the important components required to implement routing in your applications.
Temporary tables are now allowed in transactions when GTIDs are enabled
(Daogang Qu) There has been a recurring request from our users to remove a limit when using global transaction identifiers (GTIDs) and temporary tables together.
Partitioning — 11 : Composite Partitioning
(Hemant K Chitale) Oracle allows Composite Partitioning where a Partition can, itself, be Sub-Partitioned.
DBID Problem @ ODA – or Count von Count (Sesame Street) calculates DBIDs
(Robert Crames) I did some more investigations to get an explanation for that problem with the extra long DBIDs and the resulting problems when creating new databases on an ODA …
Interval versus Range partitions
(Connor McDonald) One of the nice things about partitioning in the database is that partition pruning can quickly eliminate the requirement to read large amounts of data when the partitioning key(s) are appropriately provided in your queries (and DML).
Monitor Database Offline Events
(Jason Brimhall) The other day, I shared an article showing how to audit database offline events via the default trace.
Graph database implementation with Azure Cosmos DB using the API
(Prashanth Jayaram) In my previous article, I’ve discussed a lot about the Graph database implementation with SQL Server 2017. In this case, we’ll see a walk-through of Graph API integration with Azure Cosmos DB.
SQL SERVER – Steps to Change IP Address of SQL Server Failover Cluster Instance
(Pinal Dave) There have been many questions in my mailbox asking about exact steps to change the windows cluster and SQL failover cluster IP address to the new VLAN.