Skip to content

Notes on science, software and the craft of support

Martin EvansNotes and resources

Technical notes

Technical notes

Forty five working notes on databases, cloud platforms, data, office software and the web. Filter by topic or search by title.

Databases

Hibernate and object relational mapping

Hibernate is an open source framework that persists Java objects in a relational database and gives developers a portable way to work with stored data.

Technical noteRead
Databases

The Java Persistence API explained

The Java Persistence API gives enterprise applications an object oriented route to persistent data, with entities mapped to tables, documents or other stores.

Technical noteRead
Web

Yahoo as search engine and portal

Yahoo grew from a student search project into a media company with email, news and a directory of the web, while its search results are now powered by Bing.

Technical noteRead
Software

Google Sheets for shared spreadsheets

Google Sheets is a free cloud spreadsheet application for creating, storing and sharing work online, with formulas, charts and live collaboration.

Technical noteRead
Databases

MySQL as an open source database

MySQL is an open source relational database used by web developers and businesses around the world, known for reliability, flexibility and ease of use.

Technical noteRead
Software

Windows 10 and the Start Menu

Windows 10 arrived in 2015 as the successor to Windows 8.1, bringing back a familiar Start Menu and adding Live Tiles, Cortana and stronger security.

Technical noteRead
Cloud

Snowflake and cloud data warehousing

Snowflake is a managed cloud data warehouse that separates storage from compute, so organisations can scale analysis without running their own infrastructure.

Technical noteRead
Data

What a data warehouse does

A data warehouse brings information from many sources into one place so that reporting, analysis and business intelligence can work from a trusted view.

Technical noteRead
Databases

Database management systems explained

A database management system is the software layer between users and stored data, handling creation, updates, access control, queries and reporting.

Technical noteRead
Software

Microsoft Word for document work

Microsoft Word has been the standard word processor for decades, covering document creation, formatting, tables, review tools and live collaboration.

Technical noteRead
Databases

Why teams choose NoSQL

NoSQL databases trade the fixed table model for flexible data models, which helps teams scale quickly and adapt when requirements change.

Technical noteRead
Data

Data mining in plain terms

Data mining turns raw data into useful information by finding patterns and trends that support decisions, predictions and better operations.

Technical noteRead
Software

Microsoft Excel for spreadsheets

Excel is the most widely used spreadsheet program in the world, built around worksheets, cells and formulas, with tools for analysis and automation.

Technical noteRead
Databases

MongoDB and document databases

MongoDB is a document oriented NoSQL database that stores flexible JSON like documents and scales across many servers.

Technical noteRead
Databases

NoSQL databases in practice

NoSQL covers a family of non relational databases built for large, fast and often unstructured data, with flexible schemas and distributed designs.

Technical noteRead
Databases

Alternatives to SQL databases

Big data and cloud computing have pushed interest in alternatives to SQL, from NoSQL stores and graph databases to warehouses and object stores.

Technical noteRead
Databases

The main types of database

From relational tables and NoSQL documents to object stores, graphs and cloud databases, each database type fits a different job.

Technical noteRead
Databases

What SQL can do

SQL queries, modifies and protects data, with joins, subqueries, transactions, triggers, views and stored procedures under one language.

Technical noteRead
Databases

Oracle Database in the enterprise

Oracle Database is a leading relational platform for small applications and mission critical enterprise systems, with strong security and availability tools.

Technical noteRead
Software

Working at the command line

The command line prompt lets users control a computer by typing commands, and it remains a fast route to files, programs and system tasks.

Technical noteRead
Cloud

Cloud computing for business

Cloud computing delivers servers, storage, databases and software over the internet, with pay for use pricing and room to scale as needs change.

Technical noteRead
Software

Windows 7 in review

Windows 7 arrived in 2009 with better performance, touch and handwriting support and a familiar interface, and stayed popular long after support ended.

Technical noteRead
Software

Windows 10 and its features

Windows 10 was built to bridge PCs and mobile devices, with a new Start menu, Cortana, virtual desktops, Windows Hello and regular security updates.

Technical noteRead
Software

Informatics technology and its uses

Informatics combines computing, mathematics and engineering to build systems that process information, automate tasks and support communication.

Technical noteRead
Data

Teradata for data analytics

Teradata is an enterprise data warehouse platform built to manage very large data sets and deliver high performance analytics for decision making.

Technical noteRead
Databases

Microsoft Access for small databases

Microsoft Access combines a relational engine with a graphical interface, so teams can build small databases, forms and reports without a server.

Technical noteRead
Databases

Oracle Database: platform and editions

Oracle Database supports mission critical workloads with high availability, security, analytics and several editions for different sizes of organisation.

Technical noteRead
Software

Hotmail and web email

Hotmail has been a web email service since 1996, with browser and mobile access, spam filtering, Microsoft integration and generous storage options.

Technical noteRead
Databases

Apache Cassandra for large data

Cassandra is a distributed open source NoSQL database built for high availability and fault tolerance across many commodity servers.

Technical noteRead
Databases

SQL joins explained

Joins combine rows from two or more tables into one result, with inner, left, right and full outer joins covering the common cases.

Technical noteRead
Cloud

Cloud storage and remote data

Cloud storage keeps files on remote servers, so people and teams can reach data from any device, share it and scale without buying drives.

Technical noteRead
Data

Data analytics for better decisions

Data analytics finds trends and relationships in raw data, helping organisations understand customers, cut waste and make informed decisions.

Technical noteRead
Data

Data science as a discipline

Data science combines mathematics, statistics, computing and domain knowledge to extract meaning from data and build predictive models.

Technical noteRead
Databases

SQL unions explained

A union combines the results of two or more SELECT statements into one result set, with rules about column count, types and order.

Technical noteRead
Software

The Microsoft Office suite

Microsoft Office brings Word, Excel, PowerPoint, Outlook, OneNote and Teams together, with cloud storage and collaboration across devices.

Technical noteRead
Web

SQL injection and how to prevent it

SQL injection lets attackers insert malicious code through weak input handling, which can expose, change or delete data in an application database.

Technical noteRead
Data

Data analysis and its uses

Data analysis looks for patterns, relationships and outliers in data, then turns them into conclusions that support decisions and forecasts.

Technical noteRead
Software

Microsoft Teams for collaboration

Microsoft Teams brings chat, video meetings, file storage and app integration into one workspace that fits the Microsoft 365 suite.

Technical noteRead
Databases

Microsoft SQL Server in business

SQL Server is an enterprise relational database from Microsoft, built for web applications and large data volumes with strong security and scale.

Technical noteRead
Databases

SQL as a standard language

SQL is the standard declarative language for relational databases, used to define, query and protect data across many products.

Technical noteRead