Measuring the wrong things is worse than not measuring anything. In this article, Mallika Gunturu explains the right things to measure for agile.… Read more
I can’t move on from editing Simple Talk without one more editorial about Star Trek. There are over 600 hours of episodes and movies to watch, and despite being a fan, I don’t think I’ll ever catch up. Even worse, I haven’t watched most of what I’ve seen more than once. Lately, I just completed … Read more
There’s more to security in MySQL than user account privileges. In this article, Lukas Vileikis explains the other components of MySQL security.… Read more
During Build 2022, Microsoft announced a new feature, Datamarts for Power BI. MVP Dennes Torres explains this new feature and provides and example. … Read more
PostgreSQL database performance is critical for application performance. EzzEddin Abdullah shows how to get information about a query’s performance from the execution plan.… Read more
The VALUES clause makes inserting literal values into a table simple and easy. In this article, Joe Celko explains how to use the VALUES clause.… Read more
There are several tools available to keep a MySQL database secure. In this article Lukas Vileikis discuses access control and user privileges.… Read more
It’s easy to create a unique dataset using DISTINCT in SQL, however, it may be beneficial to do this in managed code instead. In this article, Camilo Reyes demonstrates several ways to create unique datasets with managed code.… Read more
The SSRS database contains a wealth of undocumented information that can help administrators. In this article, Edward Pollack explains how to get to the data and ways to use it.… Read more
Artificial intelligence applications are all around us, but what does it really mean? In this article, Kumar Abhishek explains the history and progress of artificial intelligence. … Read more
We recently ordered a tablet for our 8-year-old grandson. We ensured that it would support a decent-sized SSD card, 128 GB, for storing all the photos and videos he will likely take. He’ll mostly play games or watch videos on the tablet, and his favorite video is Dragon’s Doom. Purchasing this gift made me think … Read more
Kubernetes production clusters are typically run on cloud platforms. However, running and deploying Kubernetes applications on cloud platforms such as Google Kubernetes Engine is costly. These high costs can restrict the Kubernetes learning process for beginners. However, running Kubernetes clusters locally helps you efficiently test applications without disrupting the production environment or paying for cloud … Read more
Stored functions in MySQL return a scalar value and can be used in a SQL statement. In this article, Robert Sheldon explains how to create and use a MySQL stored function.… Read more
Using a change management system for database code is a new idea for many database administrators. Grant Fritchey explains the many benefits of database change control.… Read more
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
