Today I am presenting one of my favorite sessions “When Database Corruption Strikes” remotely for the PASS Calgary SQL Server Users Group. This is the same session that I presented at Pass Summit 2016, with a few minor additions, including a slide with information on corruption with Hekaton (In Memory OLTP). This should be fun. Here are the downloads …
When Database Corruption Strikes – Calgary SQL Users Group Read more »
Special thanks to my friend Theresa Iserman for introducing me to Jos de Bruijn the Senior Program Manager for the In Memory OLTP (Hekaton) project to help get my questions answered at PASS Summit. So, the Hekaton – In Memory OLTP tables are perhaps one of the most amazing performance improvements to SQL OLTP in a long time. The way …
DBCC CheckDB and CheckTable doesn’t check In-Memory OLTP. Read more »
Today I had the pleasure presenting my session “When Database Corruption Strikes” as PASS Summit 2016. I want to thank PASS and the program committee for this great opportunity to present on a topic that I enjoy so much… Database Corruption and how to fix it. Here is a shot from my point of view about 10 minutes before …
It has been a great week at PASS Summit 2016. Tomorrow I will be presenting on Database Corruption. The session is called “When Database Corruption Strikes.” This session is at 3:30pm in Room 2AB, if you are interested in how to deal with database corruption, please come and see this presentation. Here is the session abstract: Your database is running fine …
When Database Corruption Strikes – PASS Summit 2016 Read more »
Next week I will be presenting on Database Corruption on Friday afternoon at Pass Summit. The session is called “When Database Corruption Strikes.” This session is on Friday afternoon, if you are interested in how to deal with database corruption, please come and see this presentation. The session is the last session of the week at 3:30 on Friday afternoon …
Database Corruption Overview: Database corruption is one of those things that you can only plan for by practicing your response plan. Out of all of the things that can happen to your SQL Server this is the one that you are most likely going to want to ask for help when you encounter it. What is Corruption? Database corruption refers …
The following Database Corruption Video is from the High Availability Disaster Recovery Virtual Chapter Presentation on September 13, 2016. Today I had the opportunity to present at the High Availability Disaster Recovery Virtual Chapter meeting on the topic of Database Corruption. Here is a recording of the presentation. Database Corruption Video If you liked this presentation, please come to my …
Please join Carlos and I for our first Database Corruption webcast on May 3rd. I have teamed up with Carlos and we will be presenting some thoughts on database corruption with an extended Q&A session. One important detail is we will be taking questions and answering them live on the webcast so this will be a great way to engage …
This Saturday, September 12th, 2015 I will be presenting at SQL Saturday Las Vegas. My presentation is on Database Corruption, here are the details. When Database Corruption Strikes – Will you be ready? Duration: 60 minutes Track: Enterprise Database Administration & Deployment You are working along month after month with no problems in your database. Suddenly someone reports that their …
So you are checking your database with DBCC CheckDB and of course if you are like me you use the WITH NO_INFOMSGS parameter. But it turns out that CheckDB is taking longer to run that you expected, and you want to check and see what table is currently being checked. Here is a quick SQL Script that I use to …