My name is James Anderson and I am a SQL Server production DBA in the south of the UK. I have been working with databases since 2008. The first RDBMS I worked on was Paradox and I never want to see it again. I quickly moved to using T-SQL in SQL Server 2005. I have worked on every version of the product since. I enjoy query tuning and server optimisation. I detest transactional replication.

Blogs

Choosing to not drive the Tesla

By

I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...

Advice I Like: Transactions and Relationships

By

Life gets better as you replace transactions with relationships. – from Excellent Advice for...

Free PostgreSQL Performance Monitoring with pgNow

By

I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...

Read the latest Blogs

Forums

Making Additions and Changes; Getting Error Preventing Them

By Ahr Aitch

MS SQL Server/SSMS are my tools. As my project evolves I find I need...

SSL Certificate Chain

By suchit.d@promantia.com

SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI I’m...

SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI

By suchit.d@promantia.com

I’m encountering an SSL certificate chain issue when trying to connect to my SQL...

Visit the forum

Question of the Day

Precision and Scale II

What is the precision, length, and scale for an int variable?

See possible answers