Simon has worked with data for all his career enabling companies to make the most of the data they have .
He works with companies to help them
1. Understand and define a cloud data platform strategy.
2. Optimise their data platform, including performance, scalability, security and certification
3. Improve their data development practices including implementation of agile methodologies and continuous integration.
Education of teams is at the heart of everything Simon does.
The passion for education led Simon to found SQLBits, the largest SQL conference in Europe. He is also a SQL Microsoft Certified Master and has been Microsoft MVP since 2005
You can follow him @simon_sabin or read his blog http://sqlblogcasts.com/blogs/simons
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.
A indepth insight into performance tuning database applications.
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 Features
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.
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.
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
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.
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
If you are eager to get office 2016, I would there are some really nice features, you might be wondering how. There is no automated update (that’s coming next year) and if you go to Office 365 and download software you will just get 2013 (the latest ...(read more)
I recently upgrade to Excel 2016 ( read this on how to get it with Office 365 ) and couldn’t for the life of me find PowerView. Power View is included as an add in for excel 2016 and so i assumed like power query that its menu had been consumed into another...(read more)
My heart was filled with a little joy today because someone, somewhere in the world updated an item on uservoice. I voted on this uservoice item sometime ago, and today it was updated to say it was started. https://support.powerbi.com/forums/265200-power...(read more)
I've got an opportunity for a SQL Developer for a project based in London but with most being done at home. If you've got the drive to work independently with some input from me and have core skills in SSDT and SSIS then this could be for you...(read more)
I started off learning Oracle many moons ago and laughed at this SQL Server thing when I attended a training course and found it didn't do this and that. But the one thing that stood out was tooling. For the Oracle world everything was command line...(read more)