(stewashton) I just learned about these critters thanks to an ODC forum question: how to calculate the difference between two dates in calendar years and months, days, hours, minutes and seconds.
Community
Enterprise Manager – Advanced Backup Strategies
(Robert Crames) Oracle’s recommendation for an Enterprise Manager backup can be found in “Enterprise Manager Cloud Control Advanced Installation and Configuration Guide”, chapter “Backing Up and Recovering Enterprise Manager”.
‘Just One More…’
(David Fitzjarrell) Partitions can make DBA life easier; they allow faster access to data through partition pruning and they allow for easier archiving and removal of old data.
SQL SERVER – Dynamic SQL and Global Temporary Tables
(Pinal Dave) Recently I had a very interesting situation at my client where I had to visit in person for Comprehensive Database Performance Health Check. Most of my performance tuning engagements are online but there are clients who can’t share their application screen online and I have to visit in
Functional Programming In JavaScript By Example
(Akram El Assas) This article discusses functional programming in JavaScript through examples (jQuery, AngularJS, Underscore, JSCheck, Lazy.js, React, Immutable.js, ect.).
SSASDiag: A Tool To Help Diagnose Analysis Services Problems
(Chris Webb) There are a lot of great community-developed tools out there for Analysis Services developers to use (BI Developer Extensions, DAX Studio, Tabular Editor, Analysis Services Query Analyzer to name a few) and they have saved me vast amounts of time and effort over the years.
Deployment of SQL Server 2019 Always On Availability Groups on Azure AKS
(Marcin Policht) In the article Introduction to Running SQL Server 2019 on Kubernetes recently published on this forum, the core concepts and basic architecture of implementation of SQL Server 2019 Always On Availability Groups on a Kubernetes cluster are described.
Improved RUNSTATS performance in function level 505
(Kate Wheat and Koshy John) When the RUNSTATS utility gathers statistics, the utility can either do row sampling after all the rows for the table are read or page sampling wherein all the rows from select pages in the table space are read.
Easy Event Processing With Var, Lombok, and Fluxtion
(Greg Higgins) Event processing made easy with var, Lombok, and Fluxtion.
AJAX Posts In Razor Pages And HTTP 400 Errors
(Mike Brind) Every other day or so it seems, a new question is posted to one of the community forums that cover ASP.NET Core Razor Pages asking why an AJAX post doesn’t appear to work, or results in an HTTP 400 error.