checkmarkIT

Stephen Wild is the technical director for Checkmark IT. Stephen has more than 20 years of experience in the IT industry and is an HPE Master Accredited Solutions Expert (MASE).

Stephen began his career at a second-hand refurbished computer company, where he assisted with sales and fixing basic Windows issues while also rebuilding and repairing computer equipment before moving to account management and becoming a technical account manager.

Following four years in account management roles, he moved into a pre-sales role aligned to the company’s commercial division, focusing on storage - which became his area of specialism - particularly around 3PAR mid-range and high-end 10K and 20K systems.

One of the most significant projects Stephen has worked on during his career is the Transport for London 10K 3PAR system, designed to help measure passenger numbers during the London 2012 Olympic Games. During this project, he designed and scoped the array to address the business needs and capacity required by the customer, alongside HPE.

All authors

SQLServerCentral Article

All flash vs adaptive flash storage - which is right for my organisation?

Many data professionals might not worry about hardware, but someone needs to watch for changes and improvements in technology. Learn about how flash storage technology has changed and how this might be useful if you still need to build a fast database server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-06-25

2,861 reads

All authors

Blogs

Learning from Mistakes: T-SQL Tuesday #194

By

We’re a week late, once again my fault. I was still coming out of...

Stupid Things I Did With AI: ASCII Art

By

I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...

Simple Talks Podcasting in 2026

By

I’m in the UK today, having arrived this morning in London. Hopefully, by this...

Read the latest Blogs

Forums

Learning From Breakage

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Learning From Breakage

Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy

By sabyda

Comments posted to this topic are about the item Python in Action to Auto-Generate...

Adding and Dropping Columns I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding and Dropping Columns I

Visit the forum

Question of the Day

Adding and Dropping Columns I

I have this table in my SQL Server 2022 database: 

CREATE TABLE [dbo].[CityList]
(
[CityNameID] [int] NOT NULL IDENTITY(1, 1),
[CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
I decide to add two new columns for the StateProvince and Country. What code should I use?

See possible answers