Peter Larsson has been an international consultant and lecturer since 1993. Peter is a SQL Server MVP (since 2009), a MCT (since 2011), leader and co-founder of the local PASS chapter Scania, and a mentor for SQLUG (the Swedish SQL Server User Group). He also does technical reviewing and editing for various publishing companies, including RedGate and Microsoft. Peter wrote chapter 25 in the book SQL Server MVP Deep Dives 2.
Peter’s key expertise is high-performance querying, and he’s well known for his unorthodox mindset when solving complex problem statements. It’s not unusual for Peter to refactor an algorithm or query and reduce the runtime from hours to just a few seconds or minutes. When not working, Peter spends his time with his wife and four kids.
Not only is the process of normalisation valuable for increasing data quality and simplifying the process of modifying data, but it actually makes the database perform much faster. To prove the point, Peter takes a large unnormalised database and subjects it to successive stages of normalisation.… Read more
"In this Comunity Book project, I will describe everything that I believe a developer, versed in the art of procedural programming, needs to understand in order to write fast, efficient SQL Code. Your feedback will help shape the book, and determine exactly what is covered, and in what depth!" - Peter Larsson.… Read more
Under the pseudonym of 'SwePeso', Peter Larsson is famous on SQL forums for the amazing performance he can get from SQL. How does he do it? In the first of a series of articles, Peter explains his secrets. … Read more