Due to the popularity of our live, online classes this year, were presenting six more in the first three months of 2019! Each class will be delivered live via WebEx or GoToMeeting over three days (roughly 12-13 hours of content including Q&As; about the same as two full workshop days!) and the attendees will have lifetime access to the [&]

The post Six new 2019 Q1 live online classes open for registration! appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/1ef3H72LtIQ/

Continuing our series of live, online classes, Jonathan will be delivering his new IECS: Immersion Event on Columnstore Indexes in March! The class will be delivered live via WebEx or GoToMeeting on March 26-28 (roughly 12-13 hours of content including Q&As; about the same as two full workshop days!) and the attendees will have lifetime access to the recordings following the end [&]

The post New live online training class in March: Columnstore Indexes appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/y4KnOnDKBA4/

Tims been working closely with the development team on Azure Managed Instance, presented with them at Ignite recently, and has been presenting internally at Microsoft field offices to their clients, as well as working with our own clients extensively on Azure and Azure migrations. With all this Azure experience, and by popular demand, Tims updated [&]

The post New class: Immersion Event on Azure SQL Database, Azure VMs, and Azure Managed Instance appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/XYJjEvWjSPw/

By the end of December, we at SQLskills will have presented remotely (and a few in-person) to more than 100 user groups and PASS virtual chapters around the world in 2018! We’d love to present remotely for your user group in 2019, anywhere in the world, as long as the time/timezone works reasonably. It’s not feasible for us [&]

The post Calling all user group leaders! We want to present for you in 2019! appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/ueKoJY8y1SA/

 Earlier this year I was sent an interesting question about why the person was seeing lots of VLFs in the log with status = 2 (which means active) after clearing (also known as truncating) the log and log_reuse_wait_desc showed NOTHING. I did some digging around and all I could find was an old blog post from 2013 [&]

The post Lazy log truncation or why VLFs might stay at status 2 after log clearing appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/_aq8L-YV_-g/

I’ve just released our first set of 2019 classes for registration! Well be adding new classes in Chicago over the coming weeks, including a new class on PowerBI and an expanded IEAzure. All classes have discounts for registering before the end of 2018! (details on the individual class web pages&) Our classes in April/May will be in Chicago, IL: [&]

The post Spring 2019 classes in Chicago open for registration appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/t-kV3pflpdo/

Im seeing reports from a few people of DBCC CHECKDB reporting PFS corruption after an upgrade from SQL Server 2014 to SQL Server 2016 or later. The symptoms are that you run DBCC CHECKDB after the upgrade and get output similar to this: Ive discussed with the SQL Server team and this is a known [&]

The post PFS corruption after upgrading from SQL Server 2014 appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/7QrwWEjt3LM/

At least since I started working on the SQL Server team (just after 7.0 shipped) and since then there have only been two VLF status codes: 0 = the VLF is not active (i.e. it can be (re)activated and overwritten) (1 = not used and no-one seems to remember what it used to mean) 2 [&]

The post New VLF status value appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/mX1C27aIINM/

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 content including Q&As; about the same as two full workshop days!) and the attendees will have lifetime access to [&]

The post New live online training class in October: Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/Kk1efp7yIDw/

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 same as two full workshop days!) and the attendees will have lifetime access to the recordings following the end [&]

The post New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/8KXpRPFGuuM/

Weve been doing a huge amount of work this year with Microsoft field offices and customers on upgrades and Azure (especially around Azure Managed Instance) and its apparent that certain customers can be reluctant to engage with you unless you can answer Yes! to Are you a Gold Partner? We already had all the qualifications so we decided [&]

The post SQLskills is now a Microsoft Gold Data Platform Partner appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/zeRMu1GH_Hk/

As we head towards our 12th SQLintersection in December, Im excited to say that its once again our most diverse, complete, and information-packed show yet! For the first time in 4 years we have a new hotel contract that doesnt have our show landing on the same week as the PASS Summit, so now you [&]

The post SQLintersection Fall 2018 (no clash with PASS this year!) appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/boJxU-5Q4VM/

Glenn’s latest Pluralsight course has been published: SQL Server 2017: Diagnosing Configuration Issues with DMVs. It’s just under 2 hours long, and from the course description: It is very common for SQL Server instances to be configured incorrectly in one or more ways, and this often has a detrimental effect on workload performance and stability. In this course, [&]

The post New Pluralsight course: SQL Server 2017: Diagnosing Configuration Issues with DMVs appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/NM-I8RID9qo/

So far this year, we at SQLskills have presented remotely (and a few in-person) to 59 user groups and PASS virtual chapters around the world, and we have 17 more scheduled! Now we’re into the second half of 2018, we’d like to schedule some more presentations through the rest of the year. We’d love to present [&]

The post Calling all user group leaders! We want to present for you again in 2018! appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/gVldlECLZ24/

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 theres no information online about it that I could find. Explanation In a nutshell, this spinlock is used to synchronize access to [&]

The post What is the FCB_REPLICA_SYNC spinlock? appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/uZqhAaKX820/

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 content including Q&As; about the same as two full workshop days!) and the attendees will have lifetime access to [&]

The post New live online training class in October: Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/gWROnHbTsMI/

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 same as two full workshop days!) and the attendees will have lifetime access to the recordings following the end [&]

The post New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/EowuK6KWuHk/

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 the same as two full workshop days!) and the attendees will have lifetime access to the [&]

The post New live online training class in August: Planning and Implementing an Upgrade/Migration to SQL Server 2017 appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/GwCm4AF3NZk/

Im 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 [&]

The post CXCONSUMER wait type  history and what you need to know appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/oYoR0qDdE2M/

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 SQLskills SQL101 blog posts, check out SQLskills.com/help/SQL101. Wait statistics analysis is one of my [&]

The post SQLskills SQL101: Why do some wait types need to be ignored? appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/Mt5kx6h3Zfc/