As Kimberly blogged about earlier this year, 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. One [&]

The post SQLskills SQL101: Log shipping performance problems appeared first on Paul S. Randal.

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

Wow! We had 22 entries for our competition (writing a post is a high bar so I was expecting 20-30) to win a free seat in either our IEPTO1 or IEPTO2 training classes in Chicago in October. That was a lot of reading to get through to pick the winners, but we made it. A bunch [&]

The post So why do you want to come to our training? And the winners are… appeared first on Paul S. Randal.

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

We’re really excited about the classes we’ve got coming up in Chicago and to say ‘thank you’ to the SQL community for all your support of SQLskills.com over the years, we’re running a competition. Its been a while since we ran a competition so were giving away TWO prizes this time! The Prize There are [&]

The post Competition: win a free seat in our classes in October! appeared first on Paul S. Randal.

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

As Kimberly blogged about earlier this year, 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. Often [&]

The post SQLskills SQL101: REBUILD vs. REORGANIZE appeared first on Paul S. Randal.

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

We’ve just published a new Pluralsight course! This is Glenn’s latest course – SQL Server: Upgrading and Migrating to SQL Server 2016 – and is just over two hours long. Its a must for anyone working on a production upgrade/migration. The modules are: Introduction Upgrade Planning Upgrade Testing Migration Planning Migration Testing Production Migration Check it out here. We [&]

The post New course: Upgrading and Migrating to SQL Server 2016 appeared first on Paul S. Randal.

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

As Kimberly blogged about earlier this year, 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. An [&]

The post SQLskills SQL101: Why DBCC CHECKDB can miss memory corruption appeared first on Paul S. Randal.

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

As we head towards our 10th SQLintersection in October, 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 Fall 2017 appeared first on Paul S. Randal.

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

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

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

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

Due to popular demand, weve added another class this October (9th-11th) in Chicago: Immersion Event on PowerShell for SQL Server DBAs. We debuted this class in May in Chicago and it was very popular! Note: the US$2,195 early-bird price expires on August 4th! It’s a 3-day class, taught by MVP, MCM, and industry expert Ben Miller, and [&]

The post New class added to October lineup: IEPS on PowerShell appeared first on Paul S. Randal.

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

As Kimberly blogged about earlier this year, 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, [&]

The post SQLskills SQL101: Practicing disaster recovery appeared first on Paul S. Randal.

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

A few months ago while I was teaching wait statistics, I was asked whether there’s any expected differences with waits stats when SQL Server is running in a virtual machine. My answer was yes – there’s a possibility of seeing longer wait times if something prevents the VM from running, as the wait times are [&]

The post Increased SOS_SCHEDULER_YIELD waits on virtual machines appeared first on Paul S. Randal.

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

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: How can a SELECT cause a database to change? appeared first on Paul S. Randal.

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

We have a third exciting new class debuting this October in Chicago: Immersion Event on Clustering and Availability Groups. It’s a 2-day class, taught by Jonathan Kehayias, our resident expert on all things AlwaysOn. We’ve seen a huge surge in clients using FCIs and AGs, so this class will be really useful to many organizations, [&]

The post New class: Immersion Event on Clustering and Availability Groups appeared first on Paul S. Randal.

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

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: Why is restore slower than backup appeared first on Paul S. Randal.

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

A few years ago I realized that there was a huge gap in knowledge in the SQL Server community  what do all the various wait types mean?  so I started a labor-of-love project to document all wait types and latch classes that have existed from SQL Server 2005 onward. In May 2016, I released [&]

The post Waits library now has infographics from SentryOne monitored instances appeared first on Paul S. Randal.

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

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: Query plans based on whats in memory appeared first on Paul S. Randal.

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

An interesting question came up in class yesterday: how is a default column value stored, and what if some rows exist when a column is added and then the default value changes? An example scenario is this: Step 1: Create a table with two columns Step 2: Add 10 rows Step 3: Add a third column to the [&]

The post How are default column values stored? appeared first on Paul S. Randal.

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

Ive just released our final set of 2017 classes for registration, including the new two-day class on Azure and the new three-day class on upgrading and migrating. Our classes in October will be in Chicago, IL: IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 October 2-6 IESSIS1: Immersion Event on Learning SQL Server [&]

The post October 2017 classes in Chicago open for registration appeared first on Paul S. Randal.

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

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: Restoring to an earlier version appeared first on Paul S. Randal.

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

And to coincide with our new training class on Azure, weve just published a new Pluralsight course on Azure too! Tim’s latest Pluralsight course – SQL Server: Understanding and Using Azure SQL Database – and is just under two hours long and is based on his very popular user group and conference session. The modules are: Introduction Understanding Azure SQL Database [&]

The post New course: Understanding and Using Azure SQL Database appeared first on Paul S. Randal.

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