Editorials Kathi Kellenberger in Editorials Buying an SSD card for a grandchild We recently ordered a tablet for our 8-year-old grandson. We ensured that it would support a decent-sized SSD card, 128... 10 May 2022 3 min read
Containers and Virtualization Boemo Mmopelwa in Containers and Virtualization How to run Kubernetes clusters locally on Windows Kubernetes production clusters are typically run on cloud platforms. However, running and deploying Kubernetes applications on cloud platforms such as... 10 May 2022 10 min read
MySQL Robert Sheldon in MySQL Working with MySQL stored functions Stored functions in MySQL return a scalar value and can be used in a SQL statement. In this article, Robert... 09 May 2022 17 min read
Change Management Grant Fritchey in Change Management The benefits of database change management Using a change management system for database code is a new idea for many database administrators. Grant Fritchey explains the... 06 May 2022 6 min read
Theory and design Joe Celko in Theory and design Combinations, permutations, and derangements Joe Celko explains how several mathematical concepts, combinations, permutations, and derangements, relate to databases.… 03 May 2022 8 min read
MySQL Lukas Vileikis in MySQL Optimizing my.cnf for MySQL performance Database systems often need tuning for best performance. Lukas Vileikis explains to how to optimize my.cnf for MySQL performance.… 02 May 2022 13 min read
T-SQL Programming Edward Pollack in T-SQL Programming Getting results using less T-SQL There is usually more than one way to write a query. In this article, Edward Pollack explains a few ways... 27 April 2022 16 min read
Editorials Devyani Borade in Editorials Mighty Tester: Damned if you do, damned if you don’t … 27 April 2022 1 min read
Oracle Jonathan Lewis in Oracle Oracle optimizer removing or coalescing subqueries The Oracle optimizer often changes the query to get better performance. In this article, Jonathan Lewis explains two more optimizations... 27 April 2022 17 min read
Python Priyanka Nawalramka in Python Memory profiling in Python with tracemalloc You can find memory leaks in Python code with tracemalloc. In this article, Priyanka Nawalramka demonstrates how to use tracemalloc... 27 April 2022 8 min read
Change Management Rohan Kapoor in Change Management Change Management and Leadership Alignment Successfully implanting change in an organization requires buy-in from leadership. Rohan Kapoor explains what’s needed to get leadership alignment.… 26 April 2022 6 min read
Learn SQL Server Greg Larsen in Learn SQL Server The ins and outs of joining tables in SQL Server Most database queries require joining tables. In this article, Greg Larsen explains the ins and outs of joining tables in... 21 April 2022 11 min read
Security Priyanka Chouhan in Security SQL Server vulnerabilities and assessment SQL Server has many features to keep the database secure, but you must implement them to benefit. In this article,... 21 April 2022 11 min read
MySQL Lukas Vileikis in MySQL The nuances of MySQL indexes Indexes are critical for database performance. In this article, Lukas Vieikis explains the many types of indexes available with MySQL.… 21 April 2022 14 min read
MySQL Rajeshkumar Sasidharan in MySQL A MySQL story: Can system engineers solve database issues using system tools? A story about how a system engineer solved a MySQL performance issue written by Rajeshkumar Sasidharan.… 20 April 2022 14 min read
Development Goodness Woke in Development Working with Firebase Version 9 Modular SDK and React Typescript Firebase is a SaaS platform that provides developers with many services to improve productivity and reduce build time. In this... 20 April 2022 13 min read
Editorials Kathi Kellenberger in Editorials A day without meetings Back when it was more difficult to work from home due to bandwidth, I would often head into the office... 20 April 2022 3 min read
BI Dennes Torres in BI How to automate table level refresh in Power BI You can automate Power BI table refreshes using PowerShell, an Automation Account, and Runbook. Dennes Torres explains how in this... 18 April 2022 14 min read
MySQL Robert Sheldon in MySQL Working with MySQL Stored Procedures MySQL stored procedures are objects containing one or more SQL statements for reuse. They often contain business logic. Robert Sheldon... 15 April 2022 19 min read
Data Science Naveed Janvekar in Data Science Clustering data for insights Clustering data gives quick insights into large unstructured data. In this article, Naveed Janvekar explains clustering and provides a quick... 11 April 2022 6 min read
