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!).

All authors

All authors

Blogs

What’s New at AWS re:Invent 2025 – Day2 Highlights

By

Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote...

Quantum Computing and SQL Server Article Is Up

By

In parallel with the presentation I gave at the PASS Data Community Summit on...

SQL Server – What To Do When Disaster Strikes (5-Point Survival Guide)

By

 SQL Server – What To Do When Disaster Strikes (5-Point Survival Guide)Chill, coffee first.When...

Read the latest Blogs

Forums

Improving update statistics process for 6 big tables

By jellybean

Recently I was asked to investigate the update statistics process on a particular database....

Adding a Lot of Seconds

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding a Lot of Seconds

SQL Server Licensing is Simple

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Licensing is Simple,...

Visit the forum

Question of the Day

Adding a Lot of Seconds

When does this code work and when does it fail? 

DECLARE @BaseDate DATETIME = '1900-01-01';

SELECT DATEADD(SECOND, 2147483648, @BaseDate) AS [MaxIntSecondsAdded];

See possible answers