Author: drweb

A global survey of 1,402 application developers, cybersecurity and IT operations professionals finds 71% work for organizations that, despite any potential vulnerabilities, still allow developers to download packages directly from the internet.Conducted by Atomik Research on behalf of JFrog, the survey also finds less than half of respondents (43%) indicating their organization is scanning at the source code and binary level, with 40% admitting they lack full visibility into the provenance of software running in production environments.Paul Davis, field CTO for JFrog, said that while a lot of progress has been made in terms of adopting best DevSecOps practices, the…

Read More
SQL

Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure Data Factory (or Synapse Pipelines). This can be done using a Web Activity, and most Fabric APIs now support service principals or managed identities. Let’s illustrate with an example. I’m going to call the REST API endpoint to create a new lakehouse. First, create a system-managed identity for Azure Data Factory in the Azure Portal:Next, add this managed identity to a security group in Azure Entra ID.This is important, as we cannot directly give permissions to a service principal (or managed identity) for the Fabric REST…

Read More

Textual is an excellent Python package for creating beautiful user interfaces in your terminal. By default, Textual will arrange your widgets starting at the top of the screen and appending them in a vertically oriented stack. Each GUI or TUI toolkit provides a way to lay out your widgets. Textual is no different in this respect. They use an object called a container. You can use containers to create the following types of layouts: Vertical layout Horizontal layout Grid layout and more! You will be learning how to use all three of these types of layouts. You will also learn how…

Read More
SQL

The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix.This comes off of the back of my last post looking at using a distributed availability group (DAG) to help facilitate a SQL server migration. SQL Server Migration Using a Distributed Availability GroupOne thing that I mentioned in that post was that, although SSMS gives us a nice dashboard to check the health of our regular AGs. There’s nothing there to look at the state that the DAGs are in. The only choice that we’ve got is to tap up and compare results from a couple of DMVs on…

Read More

When managing software packages on Debian/Ubuntu-based systems, it’s common to add external repositories or Personal Package Archives (PPAs) to install software that isn’t available in the default repositories. However, sometimes you might encounter an error like this: E: The repository ‘http://ppa.launchpad.net/xyz/ubuntu focal Release’ does not have a Release file. This error can prevent the apt command from installing or updating packages from that source. Why Does the ‘No Release File’ Error Occur? This error typically occurs when the repository: Does not support your current Ubuntu version. Has been removed or is no longer maintained. Uses an incorrect URL. Lacks a…

Read More
PHP

Speed up ksort() ksort()is the PHP native function that sorts an array by its keys, while maintaining the relationship with the values. It has been in the language since the beginning (last millenium!), and yet, sometimes, it is interesting to ask again some old questions: can I speed up ksort()? Let’s see. ksort(), sorting by keys To start with, let’s review what ksort() does. <?php $array = [2 => 'c', 5 => 'e', 3 => 'd', 1 => 'b', 0 => 'a']; ksort($array); //[0 => 'a', 1 => 'b', 2 => 'c', 3 => 'd', 5 => 'e', ]; ?>…

Read More

Amazon Web Services (AWS) today revealed it is streamlining IT incident management by adding generative artificial intelligence (AI) capabilities to the Amazon OpenSearch service.Widely used to troubleshoot IT incidents involving AWS cloud computing environments, the generative AI capabilities are being provided via integrations with Amazon Q Developer, a set of AI agents that automate a wide range of software engineering tasks.Mukul Karnik, general manager for search services for AWS, said DevOps and platform engineering teams will now be able to use natural language queries to create a summarization of an IT incident, including a list of probable root causes.The overall…

Read More
SQL

A customer asked if they needed to restore a database from backup to compare the schema in a database. They don’t and this post shows that.This is part of a series of posts on SQL Compare. Setting Up a ComparisonWhen I open SQL Compare, I see a screen that looks like what I’ve shown below, with a database to database comparison.At the top, to the left of “Source”, there is a drop down arrow. If I pick that I see these choices: database, backup, snapshow, scripts folder, SQL Source Control, SQL Change Automation, Flyway. Those last 3 are project types…

Read More

DevOps.com is now providing a weekly DevOps jobs report through which opportunities for DevOps professionals will be highlighted as part of an effort to better serve our audience.Our goal in these challenging economic times is to make it just that much easier for DevOps professionals to advance their careers.Of course, the pool of available DevOps talent is still relatively constrained, so when one DevOps professional takes on a new role, it tends to create opportunities for others.The five job postings shared this week are selected based on the company looking to hire, the vertical industry segment and naturally, the pay…

Read More