Quite often I see questions about DBCC CHECKDB error messages along the lines of: Specifically, the part that confuses people is Object ID 0, index ID -1, partition ID 0. There isnt an object ID of 0 in the system, and how can an index have an ID of -1? This pattern means that DBCC couldnt [&]

The post Disaster recovery 101: Object ID 0, index ID -1, partition ID 0 appeared first on Paul S. Randal.

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

This post is about a disaster-recovery scenario I described in our bi-weekly newsletter a couple of weeks ago, and wanted to make sure its out on the web too for people to find and use. I was helping someone try to recover data from a corrupt database, from an online forum question. They did not have any up-to-date backups [&]

The post Disaster recovery 101: fixing a broken system table page appeared first on Paul S. Randal.

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

Due to popular demand, were coming back to London in 2018 and Ive just released our classes for registration! All classes have discounts for registering before the end of 2017! (details on the individual class web pages&) Our classes in September in London will be: IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 September [&]

The post Summer 2018 classes in London open for registration appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/6h57UVHjSHs/

Its been almost three years since I wrote a T-SQL Tuesday post (shame on me!), but this is one I definitely want to contribute to. Its hosted by Ewald Cress and is about the opportunity to give a shout-out to people (well-known or otherwise) who have made a meaningful contribution to your life in the world [&]

The post TSQL Tuesday #96: Folks Who Have Made a Difference appeared first on Paul S. Randal.

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

My latest Pluralsight course has been published – SQL Server: Understanding and Performing Backups. It’s 2.5 hours long, and from the course description: Its really impossible to escape the need for backups even if you have some sort of synchronous replica of your databases, disasters can still happen that require restoring from backups. This means its critical that [&]

The post New Pluralsight course: Understanding and Performing Backups appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/6QzDXWYCh7k/

My latest Pluralsight course has been published – SQL Server: Understanding and Performing Backups. It’s 2.5 hours long, and from the course description: Its really impossible to escape the need for backups even if you have some sort of synchronous replica of your databases, disasters can still happen that require restoring from backups. This means its critical that [&]

The post New Pluralsight course: Understanding and Performing Backups appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/6QzDXWYCh7k/

My latest Pluralsight course has been published – SQL Server: Understanding and Performing Backups. It’s 2.5 hours long, and from the course description: Its really impossible to escape the need for backups even if you have some sort of synchronous replica of your databases, disasters can still happen that require restoring from backups. This means its critical that [&]

The post New Pluralsight course: Understanding and Performing Backups appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/6QzDXWYCh7k/

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 2017! We’d love to present remotely for your user group in 2018, anywhere in the world. It’s not feasible for us to travel to user groups or SQL [&]

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/-NO48eEEOZI/

Glenns latest Pluralsight course has been published – SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping. It’s 90-minutes long, and from the course description: SQL Server log shipping is a very useful technology for high availability and disaster recovery, as well for general purpose database movement, migration, and upgrades. In this course, SQL Server: Understanding, Configuring, and [&]

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

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

We’ve added a second brand-new class to our Spring line-up in Chicago: Immersion Event on Securing Your BI Platform. It’s a 2-day class, taught by MVP and industry expert Stacia Varga, presented on May 3-4, 2018. By the end of this class, you’ll understand the relationship across the security settings not only in the BI tools, but also the back-end databases [&]

The post New class: IEBISec on Securing Your BI Platform appeared first on Paul S. Randal.

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

We’ve added a brand-new class to our Spring line-up in Chicago: Immersion Event on Developing a BI and Analytics Strategy. It’s a 3-day class, taught by MVP and industry expert Stacia Varga, presented on April 30  May 2, 2018. By the end of the class, you’ll have some new ideas and inspiration to get started with your own BI [&]

The post New class: IEBIStrat on Developing a BI and Analytics Strategy appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/U9jFrr4-vgQ/

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. Every [&]

The post SQLskills SQL101: How can corruptions disappear? appeared first on Paul S. Randal.

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

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: Should you kill that long-running transaction? appeared first on Paul S. Randal.

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

I’ve just released our first set of 2018 classes for registration! Well be adding new classes in Chicago over the coming weeks, including classes on security, data mining and AI, and BI, and Kimberlys long-awaited class on data warehousing/partitioning/very-large tables. Were also planning some classes in Europe, in London and/or Dublin (details before the end of [&]

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

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

Erins latest Pluralsight course has been published – SQL Server: Analyzing Query Performance for Developers. Its four hours long, and from the course description: Developers are sometimes charged with fixing performance issues, and they have no idea where to start. Theyve never seen a query plan, or when they look at one theyre not sure what it *really* [&]

The post New Pluralsight course: Analyzing Query Performance for Developers appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/pK-TqtH8d6A/

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. Were [&]

The post SQLskills SQL101: Running out of ints and bigints appeared first on Paul S. Randal.

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

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/BAAbzSt2GJU/

Its been a while coming but its worth the wait! Kimberlys latest Pluralsight course has been published  SQL Server: Indexing for Performance  and its a monster 7 hours long and full of extensive demos. The modules are: Introduction Row-based vs. Column-based Indexes Row-based Index Concepts Choosing the Clustering Key Clustered Index Internals Nonclustered Index Internals [&]

The post New Pluralsight course: Indexing for Performance appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/6Cl2KEgd80E/

&the second stage of my life ended, when I left Microsoft on August 31st, 2007. The first stage of my life was education, ending in June 1994, with a Batchelor of Engineering (Hons.) degree in Computer Science and Electrical Engineering from the University of Edinburgh. The second stage of my life was being an employee. The [&]

The post 10 years ago today& appeared first on Paul S. Randal.

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

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. Yesterday [&]

The post SQLskills SQL101: Readable secondary performance problems appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/4iCBGYLH43g/