(Andy Brown) This article shows how you can use the FILTER function to do something similar and explains the differences between the two approaches.
(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.
(Thomas LaRock) Last year I wrote a post comparing the data services offered by both AWS and Microsoft Azure. Well, there’s been some changes since, so it was time to provide an updated graphic and links.
(Tyreke White) Visual Studio 2019 comes with a number of updates for Python developers. See how Visual Studio 2019 makes working with Python fun.
(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.
(Peter Vogel) Blazor as “C# running on the client” has had its release date moved to “sometime after .NET Core 3.0.0.”
MySQL error log contains diagnostics messages such as errors, warnings and notes that occur during MySQL startup, shutdown and while the server is running.
(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.
(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: