
Show 45 - Managing the New York Stock Exchange with Lior King
04/21/16 • 35 min
In this show, we talk to Lior King, DBA Team Manager at Intercontinental Exchange (ICE), the company who manages the New York Stock Exchange.
Lior has many years of experience working with SQL Server, Oracle, .NET, MongoDB, Cassandra, and much more. We discuss the challenges and the MANY database systems that ICE works with.
Among other topics, we talk to Lior about:
- What happens under the hood when someone buys a stock
- How Lior's team integrates the many data systems for providing a full solution
- How ICE use SQL Server Replication for synchronizing data around the world
- What Lior is looking for in SQL Server 2016
Lior King is carrying more than 25 years of experience in the IT world.
His main expertise is database systems (SQL Server and Oracle), database programming, data access layers using .NET and NoSQL solutions (MongoDB, Cassandra and Hadoop).
He started as a developer in the army (MAMRAM graduate) then a DBA, a team leader, a software architect and consulting group manager.
He's always seeking to improve my skills as a technology professional as well as my managerial and business skills.
His specialties are SQL Server and Oracle database administration, architecture and programming, Dot Net framework programming, software infrastructure design, the Hadoop platform and NoSQL solutions.
In this show, we talk to Lior King, DBA Team Manager at Intercontinental Exchange (ICE), the company who manages the New York Stock Exchange.
Lior has many years of experience working with SQL Server, Oracle, .NET, MongoDB, Cassandra, and much more. We discuss the challenges and the MANY database systems that ICE works with.
Among other topics, we talk to Lior about:
- What happens under the hood when someone buys a stock
- How Lior's team integrates the many data systems for providing a full solution
- How ICE use SQL Server Replication for synchronizing data around the world
- What Lior is looking for in SQL Server 2016
Lior King is carrying more than 25 years of experience in the IT world.
His main expertise is database systems (SQL Server and Oracle), database programming, data access layers using .NET and NoSQL solutions (MongoDB, Cassandra and Hadoop).
He started as a developer in the army (MAMRAM graduate) then a DBA, a team leader, a software architect and consulting group manager.
He's always seeking to improve my skills as a technology professional as well as my managerial and business skills.
His specialties are SQL Server and Oracle database administration, architecture and programming, Dot Net framework programming, software infrastructure design, the Hadoop platform and NoSQL solutions.
Previous Episode

Show 44 - SSMS Can Beep
Did you know SSMS can make sounds? We start the show with some interesting things you might do with it.
In addition, we talk about:
- SQL Server on Linux
- Hadoop fundamentals
- SQL Server 2016 eBook
- Changes to auto update statistics in SQL Server 2016
- New SQL Server 2016 database level configurations
- Distributed Availability Groups - what is it and use cases
- How AWS storage works
Items mentioned in the show:
- Guy Glantser - Hadoop Fundamentals
- Denny Cherry - How to make SSMS beep when a query is done?
- Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2
- Erik Darling - Changes to auto update stats thresholds in SQL Server 2016
- Brent Ozar - SQL Server 2016: The Death of the Trace Flag
- Distributed Availability Groups
Next Episode

Show 46 - Big Mistakes with Brent Ozar
If you like this episode you’ll love
Episode Comments
Generate a badge
Get a badge for your website that links back to this episode
<a href="https://goodpods.com/podcasts/sql-server-radio-165092/show-45-managing-the-new-york-stock-exchange-with-lior-king-8981392"> <img src="https://storage.googleapis.com/goodpods-images-bucket/badges/generic-badge-1.svg" alt="listen to show 45 - managing the new york stock exchange with lior king on goodpods" style="width: 225px" /> </a>
Copy