SQLskills.com

09/29/2021

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/

05/04/2020

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

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...

01/17/2020

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/

01/08/2020

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

SQLBits 2020 - 31st March - 4th April 2020 - ExCeL London -

09/10/2019

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

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

08/30/2018

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

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

06/28/2018

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

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...

06/11/2018

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....

06/11/2018

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...

06/11/2018

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....

06/05/2018

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 …

05/23/2018

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...