By popular demand, weve added Tims reporting class to our Spring line-up in Chicago! It’s a two-day class called IEReporting: Immersion Event on Using and Administering SSRS and Power BI and includes Power BI Report Server as well. Note: there’s a US$100 discount for registering before 1/25/20! The modules are as follows: Module 1: Administration and Infrastructure Reporting [&]

The post New class: Immersion Event on Using and Administering SSRS and Power BI appeared first on Paul S. Randal.

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

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) I had an [&]

The post The Curious Case of… a truncated log file after a revert from snapshot appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/QroO3ugx-q8/

The last post of the year! It’s been a really excellent year all round and time for my traditional post counting down some of the numbers and showing some of the photos that have been my (and our) life this year. 1,069,463: my lifetime total butt-in-seat miles on United, making me a Million-Mile Flyer 61,027: [&]

The post 2019 review: the year by the numbers appeared first on Paul S. Randal.

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

Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018) and people have been enjoying it, so here I present the 2019 end-of-year post. I set a moderate goal of 50 books this year but after reading [&]

The post 2019: the year in books appeared first on Paul S. Randal.

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

Were coming to SQLBits finally! Both Kimberly and I will be there for the first time in London in March/April  at long last the dates work for us  plus Erin will be there again too. The training day schedule for the conference has been announced, and I will be presenting a full-day preconference workshop [&]

The post Wait statistics workshop at SQLBits in London 2020  finally! appeared first on Paul S. Randal.

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

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 2019! We’d love to present remotely for your user group in 2020, 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 2020! appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/aNlkx5--Fe8/

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) This time the [&]

The post The Curious Case of& the failing SQL Server 2019 install appeared first on Paul S. Randal.

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

Jonathans latest Pluralsight course has been published: SQL Server: Using SentryOne Plan Explorer. It’s almost 3 hours long, and from the course description: Query plan analysis is both a science and an art, and the best tool for the job is SentryOne Plan Explorer. In this course, SQL Server: Using SentryOne Plan Explorer, you will learn how to [&]

The post New Pluralsight course: SQL Server: Using SentryOne Plan Explorer appeared first on Paul S. Randal.

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

I realized that Id fixed an issue with my sys.dm_os_waiting_tasks script to correctly parse out the parallelism nodeId from the resource_description column (as newer versions include more info after the nodeId=X info) but I never blogged the update. Here it is for your use(and all other references have been updated to point to this post). Enjoy! [&]

The post Updated sys.dm_os_waiting_tasks script to correctly parse nodeId appeared first on Paul S. Randal.

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

Tim’s latest Pluralsight course has been published: SQL Server: Understanding Database Fundamentals (98-364). It’s just over 2 hours long, and from the course description: It is very common for databases to be part of a companys I.T. infrastructure. In this course, SQL Server: Understanding Database Fundamentals (98-364), you will learn the information and skills necessary to pass the [&]

The post New Pluralsight exam prep course: SQL Server: Understanding Database Fundamentals (98-364) appeared first on Paul S. Randal.

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

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) I had a [&]

The post The Curious Case of& emergency-mode repair appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/9xUrpEshIkY/

Ive just released our Spring 2020 in-person classes in Chicago for registration! They will be at our main event hotel as usual in Oakbrook Terrace, and all classes have an early-bird price that expires on 1/1/2020, with an extra $100 discount for past attendees. After 2019 ends, past attendees can register at the early-bird price. The [&]

The post Spring 2020 classes in Chicago, early-bird through end of 2019 appeared first on Paul S. Randal.

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

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) I had a [&]

The post The Curious Case of… why a minimally-logged operation doesnt make a log backup smaller appeared first on Paul S. Randal.

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

We have two live, online classes coming up in October and November that round out our training schedule for 2019. These class will be delivered live via WebEx 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 recordings following the end of [&]

The post A month till our next live, online classes! appeared first on Paul S. Randal.

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

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) I had an [&]

The post The Curious Case of… too few log records for an offline index rebuild appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/5bTq6xovVFI/

As we head towards our SQLintersection Fall 2019 in November (our 14th show), I’m excited to say that it’s once again our most diverse, complete, and information-packed show yet! One of the pieces of feedback we hear over and over is that attendees love SQLintersection because it’s a smaller, laid-back show, where you get to actually [&]

The post SQLintersection Fall 2019 appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/A-K2GI5M1as/

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

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

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

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) On Twitter today [&]

The post The Curious Case of… what is the wait resource (0:0:0)? appeared first on Paul S. Randal.

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

Due to the popularity of our live, online classes this year, were presenting three more in October and November! Each class will be delivered live via WebEx 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 video recordings following the end of [&]

The post Three new October/November live online classes open for registration! appeared first on Paul S. Randal.

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

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) And its an [&]

The post The Curious Case of& why the transaction log has to be zero-initialized appeared first on Paul S. Randal.

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