We have a second exciting new class debuting this October in Chicago: Immersion Event on Upgrading SQL Server. It’s a 3-day class, taught by Glenn Berry and Tim Radney. Weve seen a huge surge in clients upgrading from out-of-support versions of SQL Server, so this class will be really useful to many organizations. The modules are [&]

The post New class: Immersion Event on Upgrading SQL Server appeared first on Paul S. Randal.

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

We have a really cool new class debuting this October in Chicago: Immersion Event on Azure SQL Database and Azure VMs. It’s a 2-day class, taught by Tim Radney. Azure is getting more and more popular, and were seeing many clients using it. The modules are as follows: Azure Virtual Machines Migrating to Azure Virtual Machines Azure SQL [&]

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

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

As Kimberly blogged about recently, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be 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 [&]

The post SQLskills SQL101: Switching recovery models appeared first on Paul S. Randal.

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

You may not know this, but for the last six years Ive been producing a bi-weekly newsletter for everyone signed up for our mailing list (which we only use for the newsletter). Its a bit of a labor of love, and a way for me to post opinions and other information that doesnt really fit [&]

The post Do you get our bi-weekly newsletter? appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/bscx85HRa-s/

As Kimberly blogged about recently, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be 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 [&]

The post SQLskills SQL101: Temporary table misuse appeared first on Paul S. Randal.

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

As we head towards our 9th SQLintersection in May, Im excited to say that its 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 its a smaller, laid-back show, where you get to actually spend time talking [&]

The post SQLintersection Spring 2017 appeared first on Paul S. Randal.

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

With the publication of our most recent Pluralsight course last month, we now have a whopping 50 online training courses available through Pluralsight, totally more than 150 hours of content. If youre unable to come to one of our in-person Immersion Events in the US this year, these courses are a great way to learn [&]

The post 50 online SQL Server training courses and a free trial appeared first on Paul S. Randal.

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

Last week there was a short discussion on Twitter about why PFS pages cant be repaired (prompted by a #sqlhelp question about why they cant be single-page restored, like other per-database allocation bitmaps). Just for the record, they cant be fixed by automatic page repair in a mirror or AG either. PFS pages occur every [&]

The post Why PFS pages cannot be repaired appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/kWveqB-1LDQ/

As Kimberly mentioned last week, SQLskills is embarking on a new initiative to blog about basic topics, which were calling SQL101. Well all be 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 [&]

The post SQLskills SQL101: Dealing with SQL Server corruption appeared first on Paul S. Randal.

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

In Mondays newsletter I discussed an email question Id been sent and promised to blog about it. The question was how can latch waits for ACCESS_METHODS_DATASET_PARENT occur when the instance MAXDOP is set to 1? This shouldnt happen, as that latch is only used for coordination between threads performing a parallel table/index scan. However, just [&]

The post Who is overriding MAXDOP 1 on the instance? appeared first on Paul S. Randal.

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

In Mondays newsletter I discussed an email question Id been sent and promised to blog about it. The question was how can latch waits for ACCESS_METHODS_DATASET_PARENT occur when the instance MAXDOP is set to 1? This shouldnt happen, as that latch is only used for coordination between threads performing a parallel table/index scan. However, just [&]

The post Who is overriding MAXDOP 1 on the instance? appeared first on Paul S. Randal.

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

  Although we wont be presenting any Immersion Events in Europe in 2017, Kimberly and I will both be presenting workshops and sessions at SQLSaturday Dublin in June  our first SQLSaturday ever!   My workshop details: Performance Troubleshooting Using Waits and Latches One of the first things you should check when investigating performance issues [&]

The post Presenting at SQLSaturday Dublin in June appeared first on Paul S. Randal.

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

  Although we wont be presenting any Immersion Events in Europe in 2017, Kimberly and I will both be presenting workshops and sessions at SQLSaturday Dublin in June  our first SQLSaturday ever!   My workshop details: Performance Troubleshooting Using Waits and Latches One of the first things you should check when investigating performance issues [&]

The post Presenting at SQLSaturday Dublin in June appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/rAON-uKRci8/

We have a really cool new class debuting this May in Chicago: Immersion Event on PowerShell for SQL Server DBAs. Its a 3-day class, taught by MVP, MCM, and industry expert Ben Miller, and no prior PowerShell experience is necessary. PowerShell is getting more and more popular, and by the end of the class youll have [&]

The post New class: Immersion Event on PowerShell for SQL Server DBAs appeared first on Paul S. Randal.

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

We have a really cool new class debuting this May in Chicago: Immersion Event on PowerShell for SQL Server DBAs. Its a 3-day class, taught by MVP, MCM, and industry expert Ben Miller, and no prior PowerShell experience is necessary. PowerShell is getting more and more popular, and by the end of the class youll have [&]

The post New class: Immersion Event on PowerShell for SQL Server DBAs appeared first on Paul S. Randal.

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

Our first new course of the year, and our 50th online training course with Pluralsight!! Erin’s latest Pluralsight course has been published – SQL Server: Introduction to Query Store – and is just over three hours long. Its based on her very popular user group and conference session, but much expanded with lots of cool demos. The modules are: Introduction [&]

The post New course: Introduction to Query Store appeared first on Paul S. Randal.

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

Our first new course of the year, and our 50th online training course with Pluralsight!! Erin’s latest Pluralsight course has been published – SQL Server: Introduction to Query Store – and is just over three hours long. Its based on her very popular user group and conference session, but much expanded with lots of cool demos. The modules are: Introduction [&]

The post New course: Introduction to Query Store appeared first on Paul S. Randal.

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

Our first new course of the year, and our 50th online training course with Pluralsight!! Erin’s latest Pluralsight course has been published – SQL Server: Introduction to Query Store – and is just over three hours long. Its based on her very popular user group and conference session, but much expanded with lots of cool demos. The modules are: Introduction [&]

The post New course: Introduction to Query Store appeared first on Paul S. Randal.

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

Last week I was sent an email question about the cause of LOGMGR_RESERVE_APPEND waits, and in Mondays Insider newsletter I wrote a short explanation. Its a very unusual wait to see as the highest wait on a server, and in fact its very unusual to see it at all. It happens when a thread is [&]

The post What are LOGMGR_RESERVE_APPEND waits? appeared first on Paul S. Randal.

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

Last week I was sent an email question about the cause of LOGMGR_RESERVE_APPEND waits, and in Mondays Insider newsletter I wrote a short explanation. Its a very unusual wait to see as the highest wait on a server, and in fact its very unusual to see it at all. It happens when a thread is [&]

The post What are LOGMGR_RESERVE_APPEND waits? appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/sO9UH-bFdM8/