Jonathan Kehayias is a Principal Consultant with SQLskills. He is the youngest person ever to achieve the Microsoft Certified Master - SQL Server 2008 certification and has been a SQL Server MVP for many years. Click here for a full bio.
Jonathan Kehayias shares insight about new UDF information in showplan, and shows that only some tools will show it (SSMS 17+ & SentryOne Plan Explorer).
Jonathan Kehayias (@SQLPoolBoy) takes a closer look at a new trace flag that allows you to process multiple concurrent statistics updates on the same table.
Jonathan Kehayias (@SQLPoolBoy) of SQLskills uses practical examples to show multiple ways to monitor Availability Group replica synchronization in your environment.
Jonathan Kehayias (@SQLPoolBoy) of SQLskills discusses predicates in Extended Events, and demonstrates why you need to list state-related predicates last.
Jonathan Kehayias (@SQLPoolBoy) continues his Service Broker series; in this post, he demonstrates asynchronous functionality by walking through a simple configuration and example.
Jonathan Kehayias (@SQLPoolBoy) of SQLskills kicks off an interesting series on configuring and using Service Broker to accomplish asynchronous processing in SQL Server.
Jonathan Kehayias (@SQLPoolBoy) of SQLskills.com takes a look at snapshot performance, with some surprising observations about what happens if you have more than one concurrent snapshot.
