(Andy Brown) This article shows how you can use the FILTER function to do something similar and explains the differences between the two approaches.
Other News
Blazor on the Server: The Good and the Unfortunate
(Peter Vogel) Blazor as “C# running on the client” has had its release date moved to “sometime after .NET Core 3.0.0.”
MySQL 8.0 all new Error Logging
MySQL error log contains diagnostics messages such as errors, warnings and notes that occur during MySQL startup, shutdown and while the server is running.
Database Development Life Cycle, Normalization, Errors and Security of Database – Part 1
DATABASE DEVELOPMENT LIFE CYCLE (DDLC) The Database Development Cycle (DDLC) is a process of planning, applying, as well as preserving a database system to meet the tactical or operative information necessities of an enterprise or organization like – • Enhanced customer support as well as customer fulfillment. • Enhanced production managing. • Enhanced inventory managing. • More precise sales predictions…....
Python development with Visual Studio
(Tyreke White) Visual Studio 2019 comes with a number of updates for Python developers. See how Visual Studio 2019 makes working with Python fun.
JavaScript Detect Async Function
(David Walsh) JavaScript async/await has changed the landscape of how we code. We’re no longer stuck in callback or then hell, and our code can feel more “top down” again.
Oracle RAC vs. SQL Server AG
(Kellyn Pot’Vin-Gorman) As I have seen the benefit for having a post on Oracle database vs. SQL Server architecture, let’s move onto the next frontier- High Availability…or what people think is high availability architecture in the two platforms.
19.1 and Real Time SQL Monitoring
(Jeff Smith) With some excellent feedback from our friends on the In-Memory and Real World Performance tuning groups here, we made the following improvements to the SQL Monitoring interface in SQL Developer:
Grouped Aggregate Pushdown
(Paul White) In SQL Server 2012, grouped (vector) aggregation was able to use parallel batch-mode execution, but only for the partial (per-thread) aggregate.
Working with Barcodes in Xamarin.Forms
(Gerald Versluis) This Xamarin tutorial discusses what barcodes are and how they can be used in an App. You will learn how to generate and scan barcodes in your own Xamarin apps. You will also learn to scan and generate barcodes that connect to a Wi-Fi connection.
