Skip to main content
Home
skip the agency

Main navigation

  • Home
  • AI Diagnostic
  • Approach
  • Capabilities
  • Federal Readiness
  • Proof
  • Code
  • Talk

Convert a MSSQL (or Sitecore) database into MYSQL using DATAGRIP

Submitted by Catherine Henry on Sun, 03/10/2024 - 15:29

Things you will need:

1) MSSQL (or Sitecore) database file

2) JetBrains DataGrip

3) Docker

 

Sitecore
Migration
Drupal 10
  • Read more about Convert a MSSQL (or Sitecore) database into MYSQL using DATAGRIP

Alias not set in node creation

Submitted by Catherine Henry on Fri, 12/15/2023 - 13:32

If you are programmatically creating a node, and setting the alias is not working, make sure you have turned off the "Generate automatic URL alias" setting:

 

Nodes
  • Read more about Alias not set in node creation

Add tag to query with hook_query_TAG_alter and filter for moderation state

Submitted by Catherine Henry on Mon, 10/23/2023 - 21:49

EntityTypeManager does not allow for filtering through moderation states, although it is in the works for Drupal 11: https://www.drupal.org/project/drupal/issues/3025164#comment-13221005.&nbsp

Database queries
Drupal 8
Nodes
  • Read more about Add tag to query with hook_query_TAG_alter and filter for moderation state

Add sections, components and blocks to Layout Builder programmatically

Submitted by Catherine Henry on Mon, 10/16/2023 - 12:41

In the case that you have a field on a node that you have some data in, and you wish to add this to the layout builder of the page programmatically, here is how to do so, with a landing page type n

Layout Builder
Drupal 10
  • Read more about Add sections, components and blocks to Layout Builder programmatically

Migrating from Sitecore to Drupal

Submitted by Catherine Henry on Fri, 08/25/2023 - 13:11

If you have been tasked with migrating a site from Sitecore to Drupal, you might have run into the same problem I did -- a complete lack of all documentation on the subject.

Migration
Drupal 10
Sitecore
  • Read more about Migrating from Sitecore to Drupal

D10 Upgrades Common Problems and Solutions

Submitted by Catherine Henry on Wed, 08/23/2023 - 16:26

D10 Upgrades from Drupal 9 can be tricky! There are usually unforeseen issues. Here are some commonly seen problems and solutions. 

Drupal 8
Drupal 10
Drupal Upgrades
Migration
Deprecated
  • Read more about D10 Upgrades Common Problems and Solutions

Create a Paragraph or Nested Paragraph and Add to Node

Submitted by Catherine Henry on Wed, 08/23/2023 - 16:12

Create a paragraph

Nodes
Drupal 8
Paragraphs
  • Read more about Create a Paragraph or Nested Paragraph and Add to Node

OOP - Abstract vs. Static Classes

Submitted by Catherine Henry on Tue, 08/22/2023 - 23:24

Abstract classes may have implemented methods, whereas interfaces have no implementation in themselves.

Drupal 8
Drupal 10
Object Oriented Programming
  • Read more about OOP - Abstract vs. Static Classes

file_save_data deprecated - replace with

Submitted by Catherine Henry on Tue, 08/22/2023 - 23:18
replace

:$filesaved = file_save_data($file, $destination, FileSystemInterface::EXISTS_REPLACE);

With:

$fileRepository = \Drupal::service('file.repository');
$filesaved = $fileRepository->w
Drupal 8
Deprecated
  • Read more about file_save_data deprecated - replace with

Set date field of node to current time

Submitted by Catherine Henry on Tue, 08/22/2023 - 23:08
// Set the current date and time.
$node = Node::load(1);
$node->set('field_date', date('Y-m-d', time()));
$node->set('field_datetime', date('Y-m-d\TH:i:s', time()));
$node->set('created
Nodes
Drupal 8
Datetime
  • Read more about Set date field of node to current time

Pagination

  • Current page 1
  • Page 2
  • Page 3
  • Next page Next ›
  • Last page Last »
Subscribe to
Henry Tech

Secure Drupal modernization, AWS hosting, accessibility, and user-centered delivery for mission-critical public sector platforms.

Built for compliant digital services, resilient infrastructure, and confident agency ownership.

Start the conversation Explore AI Diagnostic

Henry Tech

  • Approach
  • AI Diagnostic
  • Contact

Capabilities

  • Digital Platform Capabilities
  • Drupal Modernization
  • AWS Hosting & Operations
  • Accessibility

Federal Readiness

  • Federal Readiness
  • Security & Compliance
  • Accessibility Approach
  • Training & Transition

Proof

  • Proof of Capability
  • Delivery Model
  • DevOps & CI/CD
  • Results
Why Henry Tech

Senior engineers. Lean execution. Federal-grade delivery.

We design for secure operations, editor usability, accessibility compliance, and long-term maintainability from day one.

AWS + Drupal platform approach Secure digital identity integration Accessibility and governance model AI-powered self-service tools Analytics, performance, and reporting focus Training, cutover, and ongoing support

© 2026 Henry Tech LLC. Secure, accessible, cloud-ready digital platforms.

Privacy Security Accessibility Terms-of-Service Data Retention Compliance Contact