SQL Server Radio

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.

Two weeks have passed, and it’s time for our 4th show.

As always, we have a mix of interesting stuff covering performance, data architecture, new services, tips, tricks, and much more. Among other topics, we talk about:

• Why pulling from a Linked Server is A LOT faster than pushing
• The effect of new hardware on Writelog waits
• Ways to improve the throughput of your data loading processes
• The architecture of Transaction Replication
• A weird bug with sequence
• DocumentDB, Microsoft’s new NoSQL database service
• String search solutions in SQL Server
• Why you should wear the Database Architect hat from time to time
• How Paul Simon is related to SQL Server

Items mentioned in the show:

• Guy Glantser – Parameterization Series
• Linchi Shea – Linked servers and performance impact: Direction matters!
• Maria Zakourdaev – Choosing SEQUENCE instead of IDENTITY? Watch your step
• SQLBits Session Recordings
• Klaus Aschenbrenner – Latches, Spinlocks, and Lock Free Data Structures
• 24 Hours of Pass
• Denny Cherry – PASS Summit 2014 Speaker Idol Competition
• SQL Server Days
• Microsoft NoSQL database and full-text search service previews available on Azure
• Bob Beauchemin – New Azure services and evolution of the Service/SQL Server relationship
• Stuart Ainsworth – From DBA to Data Architect: Changing Your Game (zip file for download)

Guy and Eitan discuss the various High Availability and Disaster Recovery options available to us in Microsoft SQL Server, their main advantages, limitations, and when it's most suitable to use or not to use them.

Relevant links for further reading:

• AlwaysOn Basic Availability Groups / Database Mirroring
• AlwaysOn "Enterprize" Availability Groups
• Failover Cluster Instance
• Log Shipping
• Transactional Replication

Matan is really passionate about Azure Data Explorer. He presented a session about it in the last Data Platform Meetup in Israel. In this show, Matan introduces this powerful analytics platform.

Check it out: Azure Data Explorer