I was chatting with a customer recently and they wanted to know which host was sending in queries that were causing problems in real time. This post looks at where you can find the hostname for running queries, which is in two places.This is part of a series of posts on Redgate Monitor. Click to see the other posts.The Server OverviewThere are two places where you can see the host name. From the server overview, you can go to the current activity, or the new Query Executions tab in preview.Current ActivityIn the server overview, there is a lot of data,…
Author: drweb
I heard someone say recently that you can’t change a primary key value in a row. That’s not the case, so I decided to show a quick proof of that.Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.The ScenarioLet’s set up a simple table with some data.CREATE TABLE PKChangeTest (ImportantNumber VARCHAR(20) NOT NULL CONSTRAINT PKChangeTestPK PRIMARY KEY, CustomerName VARCHAR(50), StatusValue INT)GOINSERT dbo.PKChangeTest (ImportantNumber, CustomerName, StatusValue)VALUES (‘1234567’, ‘Steve’, 1), (‘2345678’, ‘Andy’, 1), (‘3456789’, ‘Brian’, 1), (‘1235667’, ‘Leon’, 1), (‘1265567’, ‘Dave’, 1), (‘9914567’, ‘Bill’, 1)GOIf I look at this table,…
So, you’ve just installed Ubuntu 25.04 “Plucky Puffin” on your computer—congrats! I recently did the same, and let me tell you, this release feels fresh, fast, and packed with cool features, but as with any new system, there are a few things I always do right after installation to make my setup smoother and more enjoyable. Here’s my step-by-step guide, based on what worked for me. 1. First Things First: Update Everything Even though Ubuntu 25.04 is brand new, there are always some updates waiting, so it’s a good idea to take care of them right away. I opened the…
Photo by Lucian Alexe on Unsplashpg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database as an extension. It allows you to schedule PostgreSQL commands directly from your database, similar to using cron jobs at the operating system level. pg_cron on PG Flex is pretty easy to use, making it easy to schedule regular database maintenance and processing tasks directly from within PostgreSQL.Enabling pg_cronNavigate to your Azure Database for PostgreSQL Flexible Server in the Azure portalGo to “Server parameters” under Settings in the left navigation panelSearch for the parameter “azure.extensions”Add “pg_cron” to the list of extensions…
Artificial intelligence (AI) is becoming pivotal across industries and the app development market is no exception. Every app in the world is on track to be reinvented with AI. Even the most basic, single-purpose apps in Windows, such as Notepad and Paint, are now infused with AI to enhance productivity. These longtime staples, once just for quick notes and basic image editing, are evolving with intelligent features that help users work faster and smarter than ever before. This surge of AI is not only manifesting in consumer-facing app features but is also being integrated into every aspect of software development. This…
Quines for PHP A quine is a piece of code that executes to produce itself. This is a self displaying code. The execution of the code outputs the same source code, before it was executed. No changes happened, and one may run it again, to the same result. While this code curiosity has rare direct applications, the challenge leads to interesting cases and manipulations. Here are a few of them. Quine with print() The $code variable contains the source code as a string, with %s as a placeholder for where $codewill be inserted. The printf() function uses %s to format…
Endor Labs today added a set of artificial intelligence (AI) agents to its platform, specifically trained to identify security defects in applications and suggest remediations.Fresh off raising an additional $93 million in funding, Endor Labs founder and CEO Varun Badhwar said going beyond simply identifying vulnerabilities in code, these AI agents are trained to assess the architecture of an application for security flaws, along with suggestions for improving security.Those AI agents have been trained using both the data that Endor Labs collects from its code scanning tools and the software engineering expertise provided by its internal research and development teams,…
Debian GNU/Linux is the backbone of several popular Linux distributions like Knoppix, Kali, Ubuntu, Mint, and more. One of its strongest features is its robust package management system, which makes installing, removing, and managing software a breeze. Debian and its derivatives use a variety of package managers such as dpkg, apt, apt-get, aptitude, synaptic, tasksel, dselect, dpkg-deb, and dpkg-split. each serving a different purpose. Let’s quickly go over the most common ones before diving deeper into the dpkg command. Common Debian-Based Package Managers Command Description apt apt, short for Advanced Package Tool, is used in Debian-based systems to install, remove,…
Ever feel like you’re drowning in AI news? One day ChatGPT is the hottest thing, the next day it’s Claude or Gemini or whatever shiny new model just dropped. Meanwhile, you’re still trying to figure out how to actually use these tools to get more done in less time.Here’s the thing most people miss: AI isn’t about keeping up with the latest models.👉 It’s about finding small, practical ways to improve your workflow every single day.Think about it. If you could improve your productivity by just 1% each day, what would that look like over a year? Thanks to the…
Cycode, this week, added multiple artificial intelligence (AI) agents to its application security posture management (ASPM) capable of monitoring code and offering remediation suggestions.In addition, the company is adding an ability to, in real-time, monitor continuous integration processes running in memory. That capability makes it possible to thwart, for example, recent attacks that exploited tj-actions files to compromise continuous integration/continuous delivery (CI/CD) infrastructure and developer credentials.Amir Kazemi, director of product marketing for Cycode, said collectively these capabilities will enable DevSecOps teams to streamline DevSecOps workflows in a way that reduces the friction and chaos many of these teams currently encounter.The…