A while back I was involved in an email thread where people were wondering about some ‘weird’ behavior from SQL Server. The problem was occurring on SQL Server 2016 and used the default isolation level of read committed. The scenario was as follows: Create a table with a few columns Batch 1: In one SSMS window, [&]

The post Read committed doesnt guarantee much& appeared first on Paul S. Randal.

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

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. Whenever Im teaching and recovering from corruption, [&]

The post SQLskills SQL101: Why does repair invalidate replication subscriptions? appeared first on Paul S. Randal.

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

Continuing our series of live, online classes, Erin will be delivering her new IEQS: Immersion Event on Solving Common Performance Problems with Query Store in May! The class will be delivered live via WebEx on May 22-23 (roughly 12-13 hours of content including Q&As; about the same as two full workshop days!) and the recording will be available to attendees for six [&]

The post New live online training class on using Query Store in May! appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/yfA3z-GBCbs/

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 of the concepts I find people [&]

The post SQLskills SQL101: Is the recovery interval guaranteed? appeared first on Paul S. Randal.

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

We’ve been finalizing our schedule for the remainder of 2018 and wanted to let everyone know that we will not have any Immersion Events in the U.S. this Fall. While we typically have several weeks of in-person classes in Chicago in October or November, we have several events and engagements already scheduled, including multiple Immersion [&]

The post No Fall U.S. classes in 2018 appeared first on Paul S. Randal.

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

Jonathans latest Pluralsight course has been published – SQL Server: Building Multi-instance Asynchronous Applications. It’s 2.5 hours long, and from the course description: The Service Broker feature of SQL Server is transforming the way developers think about processing requests within the database and open new opportunities for scalable applications. This course builds on the basic concepts introduced [&]

The post New Pluralsight course: Building Multi-instance Asynchronous Applications appeared first on Paul S. Randal.

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

Glenn’s latest Pluralsight course has been published – SQL Server: Understanding, Configuring and Troubleshooting Database Mirroring. It’s 2.5 hours long, and from the course description: SQL Server database mirroring is a very useful technology for high availability and disaster recovery, as well as for general purpose database movement, migration, and upgrades. In this course, SQL Server: Understanding, [&]

The post New Pluralsight course: Understanding, Configuring, and Troubleshooting Database Mirroring appeared first on Paul S. Randal.

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

One of the things I always recommend in the first newsletter of each year is to try to get a mentor. On the flip side of that is that one of the most rewarding things you can do in your professional life is to *be* a mentor to one or more people. I mentored more than [&]

The post Setting mentoring ground rules appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/52vuV11BSmI/

Due to the popularity of Kimberlys delivery of her new IEVLT: Immersion Event on Very Large Tables: Optimizing Performance and Availability through Partitioning in January, and the fact that many of you told us that you didnt have a chance to attend, were running it again in March! The class will be delivered live via WebEx on March [&]

The post More live online training from Kimberly in March! appeared first on Paul S. Randal.

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

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. Heres a question Im often asked (paraphrasing): [&]

The post SQLskills SQL101: Why does my heap have a bunch of empty pages? appeared first on Paul S. Randal.

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

By the end of December, we at SQLskills had presented remotely (and a few in-person) to more than 100 user groups and PASS virtual chapters around the world in 2017, and we already have 45 user group sessions scheduled in 2018! We’d love to present remotely for your user group in 2018, anywhere in the world. It’s not feasible [&]

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

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

As we head towards our 11th SQLintersection in March, 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 2018 appeared first on Paul S. Randal.

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

Erin’s latest Pluralsight course has been published – SQL Server: Automatic Tuning in SQL Server 2017 and Azure SQL Database. It’s 90 minutes long, and from the course description: Theres a whole new world of automated features in SQL Server, based on data, that are designed to make life easier for the data professional, and its time to [&]

The post New Pluralsight course: Automatic Tuning in SQL Server 2017 and Azure SQL Database appeared first on Paul S. Randal.

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

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 that have been my life this year. 106,914: the number of miles I flew on United this year (plus 8,504 miles on other airlines around Indonesia) 34,827: my current [&]

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

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

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) and people have been enjoying it, so here I present the 2017 end-of-year post. I set a moderate goal of 50 books this year but I only managed 48 as [&]

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

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

Weve been considering doing some live, online training classes for a while now, and with the demand for Kimberly to teach an Immersion Event on partitioning, weve decided to take the plunge and present our first live, online class in January! Kimberly will be teaching our new IEVLT: Immersion Event on Very Large Tables: Optimizing Performance [&]

The post Live online training from Kimberly in early January! appeared first on Paul S. Randal.

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

We’ve added a third brand-new class to our Spring line-up in Chicago: Immersion Event on Practical Machine Learning. It’s a combination 2-day class plus 3-day class, taught by industry expert Rafal Lukawiecki, presented on May 7-8 and 9-11, 2018. This course has two parts. You start with the 2-day Part 1: Introduction to Machine Learning, AI & Data Science with [&]

The post New class: Practical Machine Learning appeared first on Paul S. Randal.

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

We’ve added a third brand-new class to our Spring line-up in Chicago: Immersion Event on Practical Machine Learning. It’s a combination 2-day class plus 3-day class, taught by industry expert Rafal Lukawiecki, presented on May 7-8 and 9-11, 2018. This course has two parts. You start with the 2-day Part 1: Introduction to Machine Learning, AI & Data Science with [&]

The post New class: Practical Machine Learning appeared first on Paul S. Randal.

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

Tims latest Pluralsight course has been published  SQL Server: Implementing a Hybrid Cloud Solution in Azure. It’s 2.5 hours long, and from the course description: Have you been wondering what Azure Virtual Machines or Azure SQL Databases are and what they mean for you as a production DBA or developer? The Azure platform has become an Enterprise-worthy [&]

The post New Pluralsight course: Implementing a Hybrid Cloud Solution in Azure appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/LR4eWMFah-0/

Over the years Ive discussed log space reservation, which is when SQL Server automatically reserves some free space in the transaction log so that in-flight transactions can always be rolled back without the log having to grow. This is because rolling back a transaction requires generating more log records, and so there needs to be guaranteed space [&]

The post 2012/2014 bug that can cause database or server to go offline appeared first on Paul S. Randal.

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