Author: drweb

SQL

Last week I spent a few days in Cambridge, UK for the Redgate Company Kickoff. I landed at 1130a Monday and flew away at 1215p Thursday. I wish I could say it was my shortest trip to the UK, but I think it’s the 4th or 5th shortest.Almost the entire company converged in the UK for the event. We haven’t done this in the past, with separate kickoffs in different regions in the past. This time I saw friends and colleagues from Australia, the Netherlands, Germany, UK, the US, and likely somewhere else.In fact we split this into two days.…

Read More

👉 Important: See the disclaimers at the end of this page. This is a rapidly changing field and information may be wrong or outdated on this page/book.⭐⭐⭐ VERY IMPORTANT: Be on the right side of change by joining 130k AI enthusiasts our free AI email newsletter.Introduction: The Rise of AI AgentsArtificial intelligence is undergoing a tectonic shift. We’ve gone from chatbots that spit back canned answers to fully fledged agents that can perceive, reason and act on our behalf. Large language models (LLMs) like Claude and GPT have ignited imaginations and created a gold rush of startups, yet the most…

Read More

Making the Most of Your Docker Hardened Images Enterprise Trial – Part 2 In Part 1 of this series, we migrated a Node.js service to Docker Hardened Images (DHI) and measured impressive results. But how do you verify these claims independently? This post walks through the verification process: signature validation, provenance analysis, compliance evidence examination, and SBOM analysis.

Read More
SQL

Recently I had someone internally ask about whether SQL Source Control supports Git Hooks. Since it was after UK work hours, I decided to run a quick test. One problem, I haven’t setup a Git hook in a few years.Could AI help me? See what I did.This is part of a series of experiments with AI systems.Asking for HelpClaude is my go-to AI. I don’t have a good reason why I don’t lean on Copilot or ChatGPT or anything else, but I’ve become more comfortable with how Claude works and responds to me. When I have something that doesn’t have…

Read More

Syntax: numpy.arange([start, ]stop, [step, ]dtype=None) Example: import numpy as np # Create array from 0 to 9 arr = np.arange(10) print(arr) # Output: [0 1 2 3 4 5 6 7 8 9] The np.arange() function generates arrays with evenly spaced values within a specified interval. This NumPy function returns a one-dimensional ndarray containing sequential values based on the parameters you provide. Understanding np.arange parameters The np.arange() method accepts up to four parameters that control how your array gets generated. The start parameter defines where the sequence begins, defaulting to 0 if you don’t specify it. The stop parameter marks…

Read More

Making the Most of Your Docker Hardened Images Enterprise Trial – Part 2 In Part 1 of this series, we migrated a Node.js service to Docker Hardened Images (DHI) and measured impressive results. But how do you verify these claims independently? This post walks through the verification process: signature validation, provenance analysis, compliance evidence examination, and SBOM analysis.

Read More

from datetime import datetime # Get current date and time now = datetime.now() print(now) # 2026-01-25 14:30:45.123456 # Create a specific datetime object specific_date = datetime(2026, 1, 25, 14, 30, 45) print(specific_date) # 2026-01-25 14:30:45 Python’s datetime module handles date and time operations through five core classes. The datetime.datetime class represents a specific point in time with year, month, day, hour, minute, second, and microsecond precision. The date class stores calendar dates without time information. The time class holds time values independent of dates. The timedelta class measures durations between two points in time. The tzinfo class provides timezone information…

Read More

import pandas as pd df = pd.DataFrame({ ‘product’: [‘Laptop’, ‘Mouse’, ‘Laptop’, ‘Keyboard’, ‘Mouse’], ‘region’: [‘North’, ‘North’, ‘South’, ‘North’, ‘South’], ‘sales’: [1200, 150, 1400, 220, 180], ‘units’: [3, 15, 4, 8, 12] }) grouped = df.groupby(‘region’)[‘sales’].sum() print(grouped) # Output: # region # North 1570 # South 1580 # Name: sales, dtype: int64 The pandas groupby method implements the split-apply-combine pattern, a fundamental data analysis technique that divides your dataset into groups, applies functions to each group independently, and merges the results into a unified output. This approach mirrors SQL’s GROUP BY functionality but extends beyond simple aggregation to support complex transformations,…

Read More