(Peter Vogel) An official, production-ready version of Blazor dropped on Sept. 23 … with two “gotchas” from previous versions (to be fair, these issues were in the final two releases before the 23rd: Preview 9 and RC1).
Community
MySQL 8 and MySQL 5.7 Memory Consumption on Small Devices
(Peter Zaitsev) While we often run MySQL on larger scale systems in Production for Test and Dev, sometimes we want to run MySQL on the tiniest cloud instances possible or just run it on our laptops.
Statistics on Load
(Connor McDonald) One of the talks I gave recently on the Groundbreaker Yatra tour was on the changes that arrive with the optimizer when you move to 12c and above.
Truncate Partition Operation
(Jagruti Jasleniya) Just like we do truncate operation on table , we can truncate partition too.
Basic Replication — 6 : COMPLETE and ATOMIC_REFRESH
(Hemant K Chitale) Till 9i, if you did a COMPLETE Refresh of a Single Materialized View, Oracle would do a TRUNCATE followed by an INSERT.
SQL Server Stored Procedure Input Parameter, Output Parameter and Return Value
(Rick Dobson) As a beginning SQL Server Developer DBA, I recently became comfortable placing T-SQL scripts into a stored procedure template to make the code from a script easily re-usable.
Web Based Game Using JavaScript
(Bidyasagar Mishra) In this tutorial, I will discuss how we can create a web-based small game using HTML, CSS, and JavaScript.
How to troubleshoot Alter Database Failed SQLSTATE 42000 Error 3023
(Jack Vamvas) Question: I received an alert for a regular backup failure . A closer inspection of the sql server agent error logs displayed this error message:
TSQL history
(Daniel Calbimonte) In this article, we’ll take a look at a brief TSQL history and a few examples of loops, conditionals, and stored procedures
The Power of Data Masking for Data Protection
(Craig S. Mullins) Data privacy regulations and the desire to protect sensitive data requires methods to mask production data for test purposes.