Hi, my name is James Anderson. I’m a freelancer who specialises in SQL Server, but I enjoy working with all sorts of other data stores too.
I’m the director of The SQL People.
We love to see T-SQL code run faster.
Given half a chance, I’ll talk about it for hours.
Making real changes to companies with changes to code.
To save companies time and money, I focus on performance in three key areas:
- Loading data
- Extracting data
- Archiving data
These are the basic needs of any company database.
- Load data from customers, suppliers, devices, etc.
- Extract data for reporting, integration with 3rd parties, etc.
- Archive data for performance, compliance, etc.
Improving the code in these areas always increases efficiency and productivity.
I’m also interested in the process of deploying changes to applications in production environments, especially if these involve database changes. I’ve written a series of posts on this topic called SQL Server & Continuous Integration.
I’m always amazed by the levels of complexity involved in something that sounds so simple. I often hear (or mutter to myself) something along the lines of:
All I want to do is store my data on disk and get it when I want it, why is this so hard?
The answer is that the question is an over simplification. We don’t just want to dump our data and read it back later. We want to alter, constrain, index, backup, archive and sort our data instantly and in parallel with multiple sessions. This is difficult and I admire the technology that has been created to deal with it.
When I’m not working to improve companies data systems, I love to travel. My top 5 destinations so far are:
If I’m not working or travelling, I can be found at home with my wife Sarah and the cats Ted and Frank.
If you have any questions or requests then please get in touch.