SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help
A look back at the week and things happening in the industry, and some things to think about with your SQL Server and other data platform systems....
Control of Data Redundancy Ideally, the database approach stores each piece of data in a place in the database. In certain cases, there is still data redundancy to increase system performance. However, this redundancy is controlled as well as minimized through application programming by introducing the least amount of redundancy as much as possible in the database design. Data sharing...
(Kenneth Igiri) Very recently, a colleague of mine came to me in desperation owning up that he had issued an update statement without a WHERE clause on a key application table.
(Anghel Leonard) This article is a brief introduction of the JDK 12 Teeing collector.
(Michael Shpilt) One of the reasons modern computers are so fast is because of multi-core processors. New CPUs can execute many instructions in parallel. How many? As many as the number of logical CPU cores. This allows us, programmers, to run code in parallel using Threads.
(Hannes DuPreez) Protecting your work is difficult protecting, especially if you’re a relatively small start-up, trying to generate an income and there is no affordable way to protect your applications from being pirated.
(Peter Vogel) When you need to integrate authorizing the user to perform some activity (or just want to retrieve information about the current user), you need to work with the ClaimsPrincipal’s Claims objects. Here’s everything you might want to do.
(Mark Callaghan) The Learned Indexes paper opened a new area of research for storage engines. The idea is to use the distribution of the data to make searches faster and/or reduce the size of search structures.
(stewashton) LISTAGG() can be used as an analytic function, but cannot be cumulative. What does that mean, and is there a workaround?
(Neil Chandler) V. Quick post for me really: Some SQL to tell me all of the Table Prefs for any specific table (All Oracle 19 prefs)