Thom Andrews

"Database Administrator" for a small Insurance Broker in England.

I use the quotes as, being a small business, although my role is called Database Administrator, you often need to be a jack of all trades for small companies. As a result I have exposure to Network Administration, Web Development, and some server maintenance (mainly the Ubuntu servers at the office); so although I'm not trained I've had to assist enough times to know what I'm looking for or at (which greatly helps when a problem isn't SQL Server based).

SQL Server enthusiast, however, little to no experience on with any other RDBMS. Linux and Windows user, with VB.Net experience, and enjoy to dabble in PoSH and Bash. I can read C#, it is a .Net language after all, but I'm hopeless at writing it; for some reason it's always escaped my grasp. I can't even blame it on the compulsory semi-colons as (one day) they'll be compulsory in T-SQL too (bring it on SQL Server 2037!).

Blogs

Keeping Redshift System Table History Past 7 Days with S3 Tables

By

Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...

Updating the Data API Builder

By

I was updating my session for the Data API Builder (DAB) recently, mostly to...

T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget

By

I am excited to host T-SQL Tuesday for the first time. I want to...

Read the latest Blogs

Forums

Practical Ways to Approach SQL Server Problems and Case Studies

By academicexpertt

Working with SQL Server can involve more than just writing queries. Understanding database design,...

Measuring Productivity

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Measuring Productivity

Importing Excel files into SQL Server using DuckDB and Python

By Cláudio Tereso

Comments posted to this topic are about the item Importing Excel files into SQL...

Visit the forum

Question of the Day

Tracking All the Queries

I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?

See possible answers