(Hemant K Chitale) A Materialized View is actually also a physical Table (by the same name) that is created and maintained to store the rows that the MV query is supposed to present.
Community
SQL Server User Defined Function Overview
(Rick Dobson) What are the different types of SQL Server user-defined functions? What are special syntax rules for creating and invoking each major type of SQL Server user-defined function?
ReactJS Form Validation
(Prashant Rewatkar) In this article, we are going to learn about how to implement form validation in ReactJS with a simple example.
Passwords = A Good Thing
(Grant Fritchey) Those my friends are, in my opinion, one of the single most wonderful things on earth, white chocolate macadamia nut cookies.
TechTip: Streamline Authority Collection with IBM Db2 Web Query, Part 1
(Bill Vientos) Are you using IBM’s Authority Collection tool to find possible security exposures? If not, you should be! Now you can use IBM Db2 Web Query to quickly and easily analyze the large amount of collection detail.
Ineffective Java
(Ashley Frieze) Perhaps I can be replaced by a robot for code review. There are some bits of feedback I find myself giving over and over again. Here are some of my least favourites:
Dynamically Loading Assemblies at Runtime in RazorPages
(Rick Strahl) I’ve been working on some standalone tools that are generically serving static content as well as ASP.NET Core content from an arbitrary folder.
CRUD Using GRPC, EF Core, And ASP.NET Core (Part – 2)
(Bipin Joshi) In Part -1 of this article you created EmployeeCRUD service definition using Protocol Buffer language. The EmployeeCRUD.proto file and EF Core model is now ready.
Safe Navigation Operator Works In Comparison Expression Even When NULL In Lucee CFML 5.3.3.62
(Ben Nadel) While there is a version of the Lucee CFML syntax that treats null as a first-class citizen, null has, historically, been a tricky value to work with in the ColdFusion world.
Save Space on MySQL data with Column Compression
(Aakash Muthuramalingam) Recently, One of our client reached our Remote DBA team with a requirement to reduce the size of the table as it is having many text columns with huge number of records.