SQL Server Consultancy

I help people with their database needs and provide excellent SQL Server consultancy. My skills range from Performance tuning and High Availability to day to day tasks to ensure that your database remains efficient and available.

Latest Posts

  • Check For Non Running Distribution Agents (5/24/2015) - Today I am going to share with you a SQL Script that can help monitor the status on your distribution agents in a snapshot/transactional replication topology. Despite their being some built-in monitoring for replication agents in the Replication Monitor, one … Continue reading
  • Insert or Update Approaches in SQL Server (5/6/2015) - Recently I needed to write a stored procedure that would update a row if it existed in a queue table, and if it did not then to insert the row. Thinking from a pseudo code thought process, you’d run a … Continue reading
  • Finding Locks on Tables (4/30/2015) - Recently I needed to find a stored procedure that was creating a lock on a table and updating the table regularly. So my starting point was the table name, but I needed to find where the commad was coming from … Continue reading

Upcoming UK SQL Server User Group Events