SQLskills.com

New Blog Post: Calling all data “wranglers” / developers – and those that want to know more about SQL Server!

Want a plan to help advance your career? Check out all of these great FALL resources (some FREE / some PAID). Lots of options!

https://www.sqlskills.com/blogs/kimberly/calling-all-data-wrangers_learn-more_advance-your-career/

New post discussing scripts you can use for troubleshooting performance issues in Azure!

Troubleshooting Performance in Azure SQL - Erin Stellato At some point, whether you’re a DBA, developer, or application administrator, you’re going to find yourself troubleshooting performance in Azure. Within the Azure Portal you have the capability to look at performance for an Azure SQL via the Performance overview and Query Performance insight pag...

Do you need a specific database compatibility level to use Query Store? Check out my latest blog post to find out:
https://sqlskills.com/blogs/erin/database-compatibility-level-and-query-store/

We're coming to SQLBits! For those of you across the pond who can travel to London, we will be there in March/April of this year and would love to see you. Check out the SQLBits page for costs and details (prices go up this Friday) and more information about the THREE workshops we will be presenting:

Tuesday, March 31, 2020:
Paul - Performance Troubleshooting using Waits and Latches
https://sqlbits.com/information/event20/Performance_Troubleshooting_using_Waits_and_Latches/trainingdetails

Wednesday, April 1, 2020:
Erin - Performance Tuning with Query Store in SQL Server and Azure
https://sqlbits.com/information/event20/Performance_Tuning_with_Query_Store_in_SQL_Server_and_Azure/trainingdetails

Kimberly - Statistics4Performance: Internals, Analysis, Problem Solving
https://sqlbits.com/information/event20/Statistics_for_Performance_Internals_Analysis_and_Problem/trainingdetails

Let us know if you have questions, we hope to see you there!

https://sqlbits.com/information/pricing

Pricing - SQLBits 2020 - 31 Mar 2020 - 4 Apr 2020 - London SQLBits 2020 - 31st March - 4th April 2020 - ExCeL London -

Don't miss tomorrow where Glenn, Erin, and Jonathan will each be presenting one hour sessions on . There’s still time to sign up!

24 Hours of PASS: Summit Preview 2019 Join us on September 10-11 for the 24 Hours of PASS: Summit Preview 2019 webinar series.

Have you heard? Erin is coming to Portugal for SQLSaturday in Lisbon and presenting a full day of Query Store training! More details here:

Query Store Training - Portugal - Erin Stellato I'm thrilled to announce a full day of Query Store Training in September in advance of SQLSaturday Portugal

I bet you've always wanted to know...

What is the FCB_REPLICA_SYNC spinlock? - Paul S. Randal A question came up on the Data Platform MVP email list last night asking what the FCB_REPLICA_SYNC spinlock is. I answered the question and then promised to do a quick blog post, as there’s no information online about it that I could find. Explanation In a nutshell, this spinlock is used to synchr...

New live online training class in October: Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems - Paul S. Randal Continuing our series of live, online classes, Erin, Jonathan, and Kimberly will be delivering their new IEQUERY: Immersion Event on Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems in October! The class will be delivered live via WebEx on October 23-25 (roughly 12-13 hours of....

New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning - Paul S. Randal Continuing our series of live, online classes, Kimberly will be delivering her new IETLB: Immersion Event on Transactions, Locking, Blocking, Isolation, and Versioning in October! The class will be delivered live via WebEx on October 9-11 (roughly 12-13 hours of content including Q&As; about the sam...

New live online training class in August: Planning and Implementing an Upgrade/Migration to SQL Server 2017 - Paul S. Randal Continuing our series of live, online classes, Glenn will be delivering his new IEPUM2017: Immersion Event on Planning and Implementing an Upgrade/Migration to SQL Server 2017 in August! The class will be delivered live via WebEx on August 28-30 (roughly 12-13 hours of content including Q&As; about....

CXCONSUMER wait type - history and what you need to know - Paul S. Randal I’m a little bit overdue to blog about this new wait type, but I wanted to wait until SQL Server 2016 SP2 was released for a bit and people started seeing this new wait type. History Back in September 2016 I created a Connect item (3102145) to split the CXPACKET wait into benign and actionable …

SQLskills SQL101: Why do some wait types need to be ignored? - Paul S. Randal SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see done incorrectly, technologies used the wrong way, or where there are many misunderstandings that lead to serious problems. If you want to find all of our...