(Vlad Mihalcea) While developing a Spring Boot application is rather easy, tuning the performance of a Spring Boot application is a more challenging task, as, not only it requires you to understand how the Spring framework works behind the scenes, but you have to know what is the best way to use the
Other News
Athena – SQL to get date of next Monday
(Anand) I was recently asked how to get date of next Monday irrespective of which day of the week sql is executed.
Always watching, always listening. Be careful with your data
(brendantierney) The saying ‘Big Brother is Watching’ has been around a long time and typically gets associated with government organisations. But over the past few years we have a few new Big Brothers appearing. These are in the form of Google and Facebook and a few others.
How Paging Works in ORDS
(Jeff Smith) REST APIs can be useful, and even fun to build.
SQL SERVER – APPROX_COUNT_DISTINCT – Not Always Efficient
(Pinal Dave) One thing I keep on telling my clients that it is not that always recommended to use the latest feature without proper testing. I was recently hired by clients to help them with tuning a query for SQL Server 2019 Comprehensive Database Performance Health Check.
How To Add Loader/Spinner In Angular 8 Application
(Sanwar Ranwa) In this article, we will learn how we can show the Loader in Angular 8 using Ngx spinner library. Ngx spinner is a library for loading spinner for Angular, which is meant to inform the user that data loading is in progress.
Some tips for using SQL Server 2019 triggers
Some tips for using SQL Server 2019 triggers Try to minimize the number of rows affected in a trigger. The more number of rows affected in a trigger, the more time a trigger takes to run. So, try to reduce the number of rows affected in a trigger. Consider disabling trigger’s recursion. Triggers are said to be recursive when a...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
When Too Much is Not a Good Thing
(Jason Brimhall) In my previous article, I demonstrated some fun ways of locking down access for certain users to ensure they did not have data access while at the same time allowing them to review the database schema.
Matching patterns with Java
(Sebastian Daschner) If you’re using Java, there’s a high chance you’ve seen its pattern matching before. The String#matches(String) method internally uses the Pattern type, which comprises more complex functionality:
Anomaly detection with SQL on Db2
(Javier Estrada Benavides) Anomaly detection is perhaps one of the hottest sub-topics in Analytics and Data Science. There are many ways to begin with these fields of study, and one of the first steps that both disciplines have in common is to know your data, and we can’t stress it enough.