The Oracle optimizer often changes the query to get better performance. In this article, Jonathan Lewis explains two more optimizations involving subqueries.… Read more
You can find memory leaks in Python code with tracemalloc. In this article, Priyanka Nawalramka demonstrates how to use tracemalloc to find the leaks.… Read more
Successfully implanting change in an organization requires buy-in from leadership. Rohan Kapoor explains what’s needed to get leadership alignment.… Read more
SQL Server has many features to keep the database secure, but you must implement them to benefit. In this article, Priyanka Chouhan describes how to do a vulnerability assessment of SQL Server.… Read more
Firebase is a SaaS platform that provides developers with many services to improve productivity and reduce build time. In this article, Goodness Woke demonstrates working with Firebase Version 9 and React Typescript.… Read more
Back when it was more difficult to work from home due to bandwidth, I would often head into the office to work for several hours on some weekends and bank holidays like President’s Day. I was a database administrator and was always involved with many projects, but what would make me give up my well-deserved … Read more
MySQL stored procedures are objects containing one or more SQL statements for reuse. They often contain business logic. Robert Sheldon demonstrates how to create and call stored procedures.… Read more
Clustering data gives quick insights into large unstructured data. In this article, Naveed Janvekar explains clustering and provides a quick demo.… Read more
Topic modeling can be used to find more detailed insights into text than a word cloud can provide. Sanil Mhatre walks you through an example using Python.… Read more
Part 1: What is testable code, why is it important, and first glimpses on practices that can help Anyone familiar with PL/SQL, the procedural language extension to Oracle SQL, knows that the code they are touching is usually business-critical, likely to be around for a long time, and may undergo many revisions in the future. … Read more
Almost five years ago, one of my local SQL Server community friends sent me a text message about an opening at Redgate, editor of Simple Talk. I applied for the position within the hour and told my family that “No one is more qualified than I am to be editor of Simple Talk!” After a … Read more
There are several common challenges when creating paginated reports from Power BI datasets. In this article, Adam Aspin explains how to work around several of these issues.… Read more
In this article, Jonathan Lewis discusses why you might want to stop the optimizer from unnesting some subqueries and how to control where the optimizer positions each subquery.… Read more