Simon Sabin

Simon runs a Data Consultancy Sabin.io enabling companies to make the most of the data they have by implementing a Dev Ops strategy. He is passionate about the importance of the community and learning. He founded and continues to run SQLBits, the largest SQL Server Conference outside of North America, has been awarded as a Microsoft MVP since 2005 and is a Microsoft Regional Director . He has worked with data for all his career and worked with companies across all industry sectors including online retail, insurance, finance, motor sport. He works with companies to help them 1. Improve their data development practices including implementation of Dev Ops, agile methodologies and continuous integration. 2. Understand and define a cloud data platform strategy. 3. Optimise their data platform, including performance, scalability, security and certification

Simon Sabin's Sessions

Tips for handling large data volumesSQLBits 2011

Ever tried deleting 100 million records. If you have you will know your transaction log will likely blow up, you will block access and it will generally be painful. In this session we will look techniques I use to help me these situation

Performance tuning from the fieldSQLBits 2011

In this session we will look at some common practices I have seen in the field that cause performance problems. We will diagnose the cause of the problem and the resolution to the problem.

High performance functionsSQLBits 2010

Encapsulating common code in fucntions is one of the first things you learn as a programmer. However with SQL Server functions can be very bad for performance. In this session we will examine scalar functions in both TSQL and in .Net. You will come away from this session understanding the pitfalls of TSQL functions and how you can make them run 100 times faster.

10 things you should never do with SQL ServerSQLBits 2010

In this session we will look at some of the practices that you shouldn't follow when developing a SQL Server database. We will cover items such as query design, table design, indexes, constraints and more. After this session you will have some practices that you know you should avoid in your SQL Server database if you want the best performance. If you have them you will know what you need to do to resolve them.

Performance Tuning your TSQLSQLBits 2009

A indepth insight into performance tuning database applications.

When a query plan goes wrongSQLBits 2009

This session looks at some of the common scenarios when query plans can go wrong leading to your performnce suddenly hitting the wall. We will talk through what happens, why it happens and ways in which you can avoid it happening.

SQL 2008 Development FeaturesSQLBits 2009

SQL 2008 Development Features

Where do you live? Intro to spatial indexingSQLBits 2008

Where do you live? Intro to spatial indexing

SQL Server 2008 for DevelopersSQLBits 2008

SQL Server 2008 for Developers

77 SQL Server MythsSQLBits 2007

Recently the SQL MVPs put together their list of myths about SQL Server. If you think you know everything about SQL then come along and see if you're right.

Maximising everyone's super powers - Panel discussionSQLBits 2022

In this panel we will discuss approaches with leaders in the field who have first hand experience of managing neurodiversity in the work place. Welcome questions from the audience as to how everyone can maximise their and their teams super powers

Achieving PCI with SQL Server - Don't be the next SonySQLBits 2014

This session covers all aspects of what you need to do, to enable the storage of card details in SQL Server and achieve PCI certification. We will deep dive into the solutions for storing the data securely using SQL Servers encryption functionality

Performance tuning from the fieldSQLBits 2011

In this session we will look at some common practices I have seen in the field that cause performance problems. We will diagnose the cause of the problem and the resolution to the problem.

10 things you should never do with SQL ServerSQLBits 2010

In this session we will look at some of the practices that you shouldn't follow when developing a SQL Server database. We will cover items such as query design, table design, indexes, constraints and more. After this session you will have some practices that you know you should avoid in your SQL Server database if you want the best performance. If you have them you will know what you need to do to resolve them.