Jon Gurgul's Blog

Category: SQL Server

  • SQL Server Locks

    —

    by

    Jon Gurgul
    in

    Here is a simple script to get some more detailed information about locking, which I have added to over the last few years.

  • Database Corruption Week 7 Solution

    —

    by

    Jon Gurgul
    in

    Database Corruption Week 7 Solution http://stevestedman.com/server-health/database-corruption-challenge/week-7-database-corruption-challenge/week-7-challenge-details/

  • Database Corruption Week 6 Solution

    —

    by

    Jon Gurgul
    in

    Database Corruption Week 6 Solution http://stevestedman.com/server-health/database-corruption-challenge/week-6-database-corruption-challenge/week-6-challenge-details/ Check for corruption in the database, isolate to non clustered index. Keep changes that will be lost when repairing damage. In this case there are 2 row first name values that “look” to be incorrect in the cluster. Write two simple updates to be run following disable and rebuild of…

  • Database Corruption Week 5

    —

    by

    Jon Gurgul
    in

    Database Corruption Week 5 This week I managed to achieve the goal, however it was not very elegant. Plus the only way I could achieve it was to use a hex editor. Basically I copied page 9 from the backup, and replaced it in the live version with an editor, which then enabled access to the…

  • Database Corruption Week 4 Solution

    —

    by

    Jon Gurgul
    in

    Database Corruption Week 4 Solution Here is my late solution for week four. Blame the UK Bank Holiday. The original database and details for this can be found here: http://stevestedman.com/server-health/database-corruption-challenge/week-4-database-corruption-challenge/week-4-challenge-details/ This week was harder, but easier with the clue provided pointing you towards the right area.

  • Database Corruption Week 3 Solution

    —

    by

    Jon Gurgul
    in

    Database Corruption Week 3 Solution Here is the solution for week three. The original database and details for this can be found here: http://stevestedman.com/server-health/database-corruption-challenge/week-3-database-corruption-challenge/week-3-challenge-details/ This week was kind of easy as all that is needed is to backup the transaction log with NO_TRUNCATE, and then follow a standard restore. If for some reason the database had been…

  • Database Corruption Week 2 Solution

    —

    by

    Jon Gurgul
    in

    Database Corruption Week 2 Solution Unfortunately I missed week 2 submissions, but here is my solution for week two. The original database and details for this can be found here: http://stevestedman.com/server-health/database-corruption-challenge/week-2-database-corruption-challenge/week-2-challenge-details/   The data corruption is confined to a single page. Page 244. There is a non clustered index available meaning that the only columns that are…

  • Database Corruption Week 1 Solution

    —

    by

    Jon Gurgul
    in

    Database Corruption Week 1 Solution Here is my solution for week one. The original database and details for this can be found here: http://stevestedman.com/2015/04/introducing-the-database-corruption-challenge-dbcc-week-1-challenge/    

  • SQLBits XIV – 4 – 7 Mar 2015

    —

    by

    Jon Gurgul
    in ,

    So who is going to be at SQLBits XIV this coming week? Add me if you are about @JonGurgul The ExCeL, Royal Victoria Dock, 1 Western Gateway, London E16 1XL https://sqlbits.com/

  • Help, I have lost a SQL data file and I have no backup

    —

    by

    Jon Gurgul
    in

    This week I stumbled across a post on the forum that was quite interesting in terms of recovery in dire situations. The op basically had lost a SQL data file and was in a situation where they had no backups. The question asked could they rebuild the missing data file, which unfortunately is not possible…