The Bellingham SQL Server Users Group will be having its next meeting on May 20th at 6:00pm. This is free event for the local SQL Server community. What is the Bellingham SQL Server Users Group? PASS Chapters are local user groups that meet regularly in communities around the world to share their passion and knowledge about Microsoft SQL Server and …
The following are current abstracts that I have prepared for presenting at SQL Server users groups, SQL Saturdays, or other SQL events. When Database Corruption Strikes You are working along month after month with no problems in your database. Suddenly someone reports that their query won’t run. They get an error stating “SQL Server detected a logical consistency-based I/O error“, …
You have a need to keep track of all insert, update and delete actions on a table, or multiple tables. As you consider solutions, you might think about using a trigger, however triggers have their own baggage. You consider using the OUTPUT clause to log to a changes table, but then realize that the output clause cant be enforced. Then the …
Each week this page will be updated to show the current score total in the Database Corruption Challenge. This list has been updated as of July 20th, 2015 at 4:00pm (pacific time). Rob Farley in a solid lead with 25 points after earning 6 points by being the first to solve week 10. André Kamman just moved into second place moving …
The full backup file, 3 log files, and the .ldf file that was left in the data directory. All of these files were created using SQL Server 2005, and they should work on SQL Server 2008, 2008R2, 2012 and 2014. Download the zip containing these 5 files. Download Here: CorruptionChallenge3.zip See Also: Updated Scoring Details Week 3 Corruption Challenge Week 2 …
The database name is [CorruptionChallenge3], it was created and backed up on SQL Server 2005. I used SQL 2005 to accommodate those challenge participants who don’t have the latest version of SQL Server. Here is the timeline as things occurred At 2:53pm a full backup was performed. After that full backup, users continued to do work and the database …
Week 2 Challenge: You can download a zip file with multiple backup files created on SQL Server 2008 that can be restored and used on SQL 2008, SQL Server 2008R2, SQL Server 2012 or SQL Server 2014. The story… A backup was run yesterday, after that backup several changes were made to the database, inserts deletes, updates, and more. Sometime …
The zip file contains 2 backups. See the challenge details for a description. Note, even though it stats that one is a two day ago backup, the time stamps on the file don’t exactly show that. It is just simulating an older backup. Here is the zip file with the corrupt database: CorruptionChallenge2.zip Back to Corruption Challenge 2. Related …
Most DBAs know the usual difference between TRUNCATE and DELETE FROM, however one not so obvious difference between the two is how things are handled if the table is corrupt. For instance, if you look at the corrupt database from the Database Corruption Challenge Week 1, you see the following If you want to clear out the corrupt Revenue table, …
Difference Between TRUNCATE TABLE and DELETE FROM Table Read more »
With all the interest in the Database Corruption Challenge, and the hundreds of email message I have exchanged with people over the last 3 days relating to the Database Corruption Challenge, I have decided to set up a newsletter mailing list to use to notify people of the upcoming Database Corruption Challenges, and other interesting tidbits. Sign up for the newsletter …