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.

All authors

All authors

Blogs

Daily Coping 17 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Read the latest Blogs

Forums

All the Tools in Your Toolbox

By Kathi Kellenberger

Comments posted to this topic are about the item All the Tools in Your...

All the Tools in Your T-SQL Toolbox

By Kathi Kellenberger

Comments posted to this topic are about the item All the Tools in Your...

Get value of rows based on condition

By IdealPR

Hello, I have the table with data as bellow : create table tbl_Fact( IdCmd...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Getting the JSON Index

See possible answers