Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Other Discussions
  3. The Weird and The Wonderful
  4. My sides - they split!

My sides - they split!

Scheduled Pinned Locked Moved The Weird and The Wonderful
databasesql-serverdesignsysadmin
9 Posts 8 Posters 2 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    martin_hughes
    wrote on last edited by
    #1

    Just got off the blower to a colleague who is having a very bad day :) He got a call from a customer whose database seems to have disappeared; now my colleague isn't a technical guy, but I talked him through SQL Server Management Studio. Suprisingly, my collegaue confirmed that the database was present, as was it's entire structure - only all the tables were empty of data. I asked him the background to the call - as this isn't a system I know much about or deal with. Apparently this database back ends a VB6 application, and one of the features of this 'application' is that it allows users to import data from 'sattelite' Access databases. Like a lead balloon the penny dropped and I remembered why i stopped having anything to do with the system 2 - 2 1/2 years ago. I asked, "have you got a copy of the last Access database imported"? "Yeah sure," he said as I could feel the laughter rising. I opened Access, and sure enough the imported database was also completely empty ;) I advised to restore last night's backup, while I had a word with our VB *guru*. The conversation went a bit like this: Me: Remember 2 1/2 years ago I told you your import routine was cretinous? That blindly dropping tables and then recreating them from an unknown, untrusted source is possibly the worst bit of design I have ever encountered? That you are a complete Charlie? Him: Oh, yeah! Me: Well why didn't you fix it!!!!!! Him: Err... well... you see... I still thought it was the best way of doing it! BWHAHAHHAHAHHAHABBAHAHHAHAHHAHAHAHHAHAHAHHAHA!! HAHAHHAHAHAHHAHAHAHHA BWHWHWHWHWWHHWWHAHAHAHAHAHAHAHAHAHA HAHAHAHA! VB6 Chumps - they should all have their computers taken away from them and be given Etch-a-Sketchs instead!

    "On one of my cards it said I had to find temperatures lower than -8. The numbers I uncovered were -6 and -7 so I thought I had won, and so did the woman in the shop. But when she scanned the card the machine said I hadn't. "I phoned Camelot and they fobbed me off with some story that -6 is higher - not lower - than -8 but I'm not having it." -Tina Farrell, a 23 year old thicky from Levenshulme, Manchester.

    D P B C D 5 Replies Last reply
    0
    • M martin_hughes

      Just got off the blower to a colleague who is having a very bad day :) He got a call from a customer whose database seems to have disappeared; now my colleague isn't a technical guy, but I talked him through SQL Server Management Studio. Suprisingly, my collegaue confirmed that the database was present, as was it's entire structure - only all the tables were empty of data. I asked him the background to the call - as this isn't a system I know much about or deal with. Apparently this database back ends a VB6 application, and one of the features of this 'application' is that it allows users to import data from 'sattelite' Access databases. Like a lead balloon the penny dropped and I remembered why i stopped having anything to do with the system 2 - 2 1/2 years ago. I asked, "have you got a copy of the last Access database imported"? "Yeah sure," he said as I could feel the laughter rising. I opened Access, and sure enough the imported database was also completely empty ;) I advised to restore last night's backup, while I had a word with our VB *guru*. The conversation went a bit like this: Me: Remember 2 1/2 years ago I told you your import routine was cretinous? That blindly dropping tables and then recreating them from an unknown, untrusted source is possibly the worst bit of design I have ever encountered? That you are a complete Charlie? Him: Oh, yeah! Me: Well why didn't you fix it!!!!!! Him: Err... well... you see... I still thought it was the best way of doing it! BWHAHAHHAHAHHAHABBAHAHHAHAHHAHAHAHHAHAHAHHAHA!! HAHAHHAHAHAHHAHAHAHHA BWHWHWHWHWWHHWWHAHAHAHAHAHAHAHAHAHA HAHAHAHA! VB6 Chumps - they should all have their computers taken away from them and be given Etch-a-Sketchs instead!

      "On one of my cards it said I had to find temperatures lower than -8. The numbers I uncovered were -6 and -7 so I thought I had won, and so did the woman in the shop. But when she scanned the card the machine said I hadn't. "I phoned Camelot and they fobbed me off with some story that -6 is higher - not lower - than -8 but I'm not having it." -Tina Farrell, a 23 year old thicky from Levenshulme, Manchester.

      D Offline
      D Offline
      Dan Neely
      wrote on last edited by
      #2

      Obligatory Dilbert link. http://img507.imageshack.us/img507/9960/dilbertetch9uf.jpg[^]

      -- Help Stamp Out and Abolish Redundancy The preceding is courtesy of the Department of Unnecessarily Redundant Repetition Department.

      1 Reply Last reply
      0
      • M martin_hughes

        Just got off the blower to a colleague who is having a very bad day :) He got a call from a customer whose database seems to have disappeared; now my colleague isn't a technical guy, but I talked him through SQL Server Management Studio. Suprisingly, my collegaue confirmed that the database was present, as was it's entire structure - only all the tables were empty of data. I asked him the background to the call - as this isn't a system I know much about or deal with. Apparently this database back ends a VB6 application, and one of the features of this 'application' is that it allows users to import data from 'sattelite' Access databases. Like a lead balloon the penny dropped and I remembered why i stopped having anything to do with the system 2 - 2 1/2 years ago. I asked, "have you got a copy of the last Access database imported"? "Yeah sure," he said as I could feel the laughter rising. I opened Access, and sure enough the imported database was also completely empty ;) I advised to restore last night's backup, while I had a word with our VB *guru*. The conversation went a bit like this: Me: Remember 2 1/2 years ago I told you your import routine was cretinous? That blindly dropping tables and then recreating them from an unknown, untrusted source is possibly the worst bit of design I have ever encountered? That you are a complete Charlie? Him: Oh, yeah! Me: Well why didn't you fix it!!!!!! Him: Err... well... you see... I still thought it was the best way of doing it! BWHAHAHHAHAHHAHABBAHAHHAHAHHAHAHAHHAHAHAHHAHA!! HAHAHHAHAHAHHAHAHAHHA BWHWHWHWHWWHHWWHAHAHAHAHAHAHAHAHAHA HAHAHAHA! VB6 Chumps - they should all have their computers taken away from them and be given Etch-a-Sketchs instead!

        "On one of my cards it said I had to find temperatures lower than -8. The numbers I uncovered were -6 and -7 so I thought I had won, and so did the woman in the shop. But when she scanned the card the machine said I hadn't. "I phoned Camelot and they fobbed me off with some story that -6 is higher - not lower - than -8 but I'm not having it." -Tina Farrell, a 23 year old thicky from Levenshulme, Manchester.

        P Offline
        P Offline
        Pete OHanlon
        wrote on last edited by
        #3

        There you go. Classic schoolboy error there. VB Guru (isn't that an Oxymoron - or at lease a moronic Ox). Expecting them to think. Tie the two sentences together and you've got the makings of a Bruce Willis movie.

        Deja View - the feeling that you've seen this post before.

        My blog | My articles

        1 Reply Last reply
        0
        • M martin_hughes

          Just got off the blower to a colleague who is having a very bad day :) He got a call from a customer whose database seems to have disappeared; now my colleague isn't a technical guy, but I talked him through SQL Server Management Studio. Suprisingly, my collegaue confirmed that the database was present, as was it's entire structure - only all the tables were empty of data. I asked him the background to the call - as this isn't a system I know much about or deal with. Apparently this database back ends a VB6 application, and one of the features of this 'application' is that it allows users to import data from 'sattelite' Access databases. Like a lead balloon the penny dropped and I remembered why i stopped having anything to do with the system 2 - 2 1/2 years ago. I asked, "have you got a copy of the last Access database imported"? "Yeah sure," he said as I could feel the laughter rising. I opened Access, and sure enough the imported database was also completely empty ;) I advised to restore last night's backup, while I had a word with our VB *guru*. The conversation went a bit like this: Me: Remember 2 1/2 years ago I told you your import routine was cretinous? That blindly dropping tables and then recreating them from an unknown, untrusted source is possibly the worst bit of design I have ever encountered? That you are a complete Charlie? Him: Oh, yeah! Me: Well why didn't you fix it!!!!!! Him: Err... well... you see... I still thought it was the best way of doing it! BWHAHAHHAHAHHAHABBAHAHHAHAHHAHAHAHHAHAHAHHAHA!! HAHAHHAHAHAHHAHAHAHHA BWHWHWHWHWWHHWWHAHAHAHAHAHAHAHAHAHA HAHAHAHA! VB6 Chumps - they should all have their computers taken away from them and be given Etch-a-Sketchs instead!

          "On one of my cards it said I had to find temperatures lower than -8. The numbers I uncovered were -6 and -7 so I thought I had won, and so did the woman in the shop. But when she scanned the card the machine said I hadn't. "I phoned Camelot and they fobbed me off with some story that -6 is higher - not lower - than -8 but I'm not having it." -Tina Farrell, a 23 year old thicky from Levenshulme, Manchester.

          B Offline
          B Offline
          Brady Kelly
          wrote on last edited by
          #4

          martin_hughes wrote:

          Just got off the blower to a colleague who is having a very bad day :)

          I'm glad I'm not one of your colleagues whose suffering inspires much mirth in you.

          My head asplode!

          Calling all South African developers! Your participation in this local dev community will be mutually beneficial, to you and us.

          1 Reply Last reply
          0
          • M martin_hughes

            Just got off the blower to a colleague who is having a very bad day :) He got a call from a customer whose database seems to have disappeared; now my colleague isn't a technical guy, but I talked him through SQL Server Management Studio. Suprisingly, my collegaue confirmed that the database was present, as was it's entire structure - only all the tables were empty of data. I asked him the background to the call - as this isn't a system I know much about or deal with. Apparently this database back ends a VB6 application, and one of the features of this 'application' is that it allows users to import data from 'sattelite' Access databases. Like a lead balloon the penny dropped and I remembered why i stopped having anything to do with the system 2 - 2 1/2 years ago. I asked, "have you got a copy of the last Access database imported"? "Yeah sure," he said as I could feel the laughter rising. I opened Access, and sure enough the imported database was also completely empty ;) I advised to restore last night's backup, while I had a word with our VB *guru*. The conversation went a bit like this: Me: Remember 2 1/2 years ago I told you your import routine was cretinous? That blindly dropping tables and then recreating them from an unknown, untrusted source is possibly the worst bit of design I have ever encountered? That you are a complete Charlie? Him: Oh, yeah! Me: Well why didn't you fix it!!!!!! Him: Err... well... you see... I still thought it was the best way of doing it! BWHAHAHHAHAHHAHABBAHAHHAHAHHAHAHAHHAHAHAHHAHA!! HAHAHHAHAHAHHAHAHAHHA BWHWHWHWHWWHHWWHAHAHAHAHAHAHAHAHAHA HAHAHAHA! VB6 Chumps - they should all have their computers taken away from them and be given Etch-a-Sketchs instead!

            "On one of my cards it said I had to find temperatures lower than -8. The numbers I uncovered were -6 and -7 so I thought I had won, and so did the woman in the shop. But when she scanned the card the machine said I hadn't. "I phoned Camelot and they fobbed me off with some story that -6 is higher - not lower - than -8 but I'm not having it." -Tina Farrell, a 23 year old thicky from Levenshulme, Manchester.

            C Offline
            C Offline
            Curtis J
            wrote on last edited by
            #5

            Oh, no!... I have to admit to resembling that remark, however, as I am forced to use VB (usually VBA) on occasion.

            1 Reply Last reply
            0
            • M martin_hughes

              Just got off the blower to a colleague who is having a very bad day :) He got a call from a customer whose database seems to have disappeared; now my colleague isn't a technical guy, but I talked him through SQL Server Management Studio. Suprisingly, my collegaue confirmed that the database was present, as was it's entire structure - only all the tables were empty of data. I asked him the background to the call - as this isn't a system I know much about or deal with. Apparently this database back ends a VB6 application, and one of the features of this 'application' is that it allows users to import data from 'sattelite' Access databases. Like a lead balloon the penny dropped and I remembered why i stopped having anything to do with the system 2 - 2 1/2 years ago. I asked, "have you got a copy of the last Access database imported"? "Yeah sure," he said as I could feel the laughter rising. I opened Access, and sure enough the imported database was also completely empty ;) I advised to restore last night's backup, while I had a word with our VB *guru*. The conversation went a bit like this: Me: Remember 2 1/2 years ago I told you your import routine was cretinous? That blindly dropping tables and then recreating them from an unknown, untrusted source is possibly the worst bit of design I have ever encountered? That you are a complete Charlie? Him: Oh, yeah! Me: Well why didn't you fix it!!!!!! Him: Err... well... you see... I still thought it was the best way of doing it! BWHAHAHHAHAHHAHABBAHAHHAHAHHAHAHAHHAHAHAHHAHA!! HAHAHHAHAHAHHAHAHAHHA BWHWHWHWHWWHHWWHAHAHAHAHAHAHAHAHAHA HAHAHAHA! VB6 Chumps - they should all have their computers taken away from them and be given Etch-a-Sketchs instead!

              "On one of my cards it said I had to find temperatures lower than -8. The numbers I uncovered were -6 and -7 so I thought I had won, and so did the woman in the shop. But when she scanned the card the machine said I hadn't. "I phoned Camelot and they fobbed me off with some story that -6 is higher - not lower - than -8 but I'm not having it." -Tina Farrell, a 23 year old thicky from Levenshulme, Manchester.

              D Offline
              D Offline
              David Crow
              wrote on last edited by
              #6

              But couldn't this have happened with any programming language, not just VB?


              "Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman

              "To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

              M 1 Reply Last reply
              0
              • D David Crow

                But couldn't this have happened with any programming language, not just VB?


                "Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman

                "To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

                M Offline
                M Offline
                martin_hughes
                wrote on last edited by
                #7

                Yes, quite true, but it has been my experience of C++/Java/C# guys who claim to 10-15 years working with their chosen languages (as does our resident VB "Guru", apparently) that they approach software with a bit more thought :-)

                "On one of my cards it said I had to find temperatures lower than -8. The numbers I uncovered were -6 and -7 so I thought I had won, and so did the woman in the shop. But when she scanned the card the machine said I hadn't. "I phoned Camelot and they fobbed me off with some story that -6 is higher - not lower - than -8 but I'm not having it." -Tina Farrell, a 23 year old thicky from Levenshulme, Manchester.

                J 1 Reply Last reply
                0
                • M martin_hughes

                  Yes, quite true, but it has been my experience of C++/Java/C# guys who claim to 10-15 years working with their chosen languages (as does our resident VB "Guru", apparently) that they approach software with a bit more thought :-)

                  "On one of my cards it said I had to find temperatures lower than -8. The numbers I uncovered were -6 and -7 so I thought I had won, and so did the woman in the shop. But when she scanned the card the machine said I hadn't. "I phoned Camelot and they fobbed me off with some story that -6 is higher - not lower - than -8 but I'm not having it." -Tina Farrell, a 23 year old thicky from Levenshulme, Manchester.

                  J Offline
                  J Offline
                  Johann Gerell
                  wrote on last edited by
                  #8

                  I get your point, but...

                  martin_hughes wrote:

                  C++/Java/C# guys who claim to 10-15 years working with their chosen languages

                  ... would make me a bit hesitant about the trustworthiness of that C# guy. :cool:

                  -- Time you enjoy wasting is not wasted time - Bertrand Russel

                  J 1 Reply Last reply
                  0
                  • J Johann Gerell

                    I get your point, but...

                    martin_hughes wrote:

                    C++/Java/C# guys who claim to 10-15 years working with their chosen languages

                    ... would make me a bit hesitant about the trustworthiness of that C# guy. :cool:

                    -- Time you enjoy wasting is not wasted time - Bertrand Russel

                    J Offline
                    J Offline
                    Jim Crafton
                    wrote on last edited by
                    #9

                    Good catch - or the Java guy claiming 15 years :)

                    ¡El diablo está en mis pantalones! ¡Mire, mire! Real Mentats use only 100% pure, unfooled around with Sapho Juice(tm)! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! VCF Blog

                    1 Reply Last reply
                    0
                    Reply
                    • Reply as topic
                    Log in to reply
                    • Oldest to Newest
                    • Newest to Oldest
                    • Most Votes


                    • Login

                    • Don't have an account? Register

                    • Login or register to search.
                    • First post
                      Last post
                    0
                    • Categories
                    • Recent
                    • Tags
                    • Popular
                    • World
                    • Users
                    • Groups