(Ravi Kiran) Dependency Injection is an important feature in Angular to build scalable web applications. This tutorial will explore the API for DI in Angular that allows us to inject anything, thus making the code extensible and testable.
(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.
(Norvald H. Ryeng) One of the big features of MySQL 8.0 is geography support. MySQL now has a catalog of spatial reference systems (SRSs), of which almost 500 are geographic. Most functions also support geographic computations. What about indexes?
(Chris Webb) Back in March, with the publication of the Dynamics 365 Release Notes document (which you can download here, halfway down the page), we learned a lot about the roadmap of Power BI; my blog post here summarises the announcements.
(Kenneth Fisher) tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted into if there is an identity column involved.
(Thorben Janssen) Here’s a great look at the Adapter Pattern as we attempt to code our way to the perfectly brewed up of coffee through good coding practices.
(Craig S. Mullins) In parts 1 and 2 of this series we examined each of the six types of Db2 traces that you can start to get Db2 to record information about its activities. Be sure to check out those earlier blog posts to learn about what is available.
SoftBase, a Fresche Solutions brand, is proud to announce the general availability of the SoftBase Db2 Tools suite 1.1.0 (SDT110). The SoftBase Db2 Tools suite allows developers, DBAs, and performance analysts to focus on meeting their customer demands of developing and maintaining software code.
(Kathi Kellenberger) T-SQL window functions were introduced in 2005 with more functionality added in 2012. Many database professionals are not aware of these useful functions.
(Kim May) Gold Consultant and Z Systems Champion Frank Fillmore will deliver a free, hands-on IBM Db2 Analytics Accelerator/IDAA class on Monday and Tuesday, July 23rd and 24th, at the IBM Dublin Campus near Columbus, Ohio.