September 3, 2014 at 8:35 am
Sean Lange (9/3/2014)
Gazareth (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions in this thread. 😛Like how to drop a database?
Crikey.
And what is up with that awful banner?!
That banner is almost as bad as the advice being offered. I particularly like the way the guys smug look will follow your cursor around his banner.
Yep, and I absolutely did not just spend a few therapeutic moments knocking his head against the side of my screen.
September 3, 2014 at 8:39 am
xsevensinzx (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions in this thread. 😛Like how to drop a database?
I'm going to apply this useful knowledge right now. I have a feeling I may be back with an update.
The blog post could be renamed 'How to handily backup your database to the recycling bin' 🙂
September 3, 2014 at 8:41 am
GilaMonster (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions in this thread. 😛Like how to drop a database?
"Drop doesn't do everything that I want"
I agree completely. It doesn't make coffee or hoover the floors.
drop database is supposed to drop all databases on an instance and then uninstall the instance.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 3, 2014 at 8:41 am
xsevensinzx (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions in this thread. 😛Like how to drop a database?
I'm going to apply this useful knowledge right now. I have a feeling I may be back with an update.
Don't forget to format the drive after you finish with those steps and set it on fire. That way, you'll be sure the data is really gone. :hehe:
September 3, 2014 at 8:45 am
Gazareth (9/3/2014)
Sean Lange (9/3/2014)
Gazareth (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions in this thread. 😛Like how to drop a database?
Crikey.
And what is up with that awful banner?!
That banner is almost as bad as the advice being offered. I particularly like the way the guys smug look will follow your cursor around his banner.
Yep, and I absolutely did not just spend a few therapeutic moments knocking his head against the side of my screen.
I like that idea. Maybe add a brick wall or something.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 3, 2014 at 8:47 am
Luis Cazares (9/3/2014)
xsevensinzx (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions in this thread. 😛Like how to drop a database?
I'm going to apply this useful knowledge right now. I have a feeling I may be back with an update.
Don't forget to format the drive after you finish with those steps and set it on fire. That way, you'll be sure the data is really gone. :hehe:
format, then low level format, then wipe via some tool that will write 0's to every sector (30 passes should suffice), then pass it through an electromagnet, then the industrial shredder. We should be good after that.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 3, 2014 at 8:57 am
SQLRNNR (9/3/2014)
Luis Cazares (9/3/2014)
xsevensinzx (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions in this thread. 😛Like how to drop a database?
I'm going to apply this useful knowledge right now. I have a feeling I may be back with an update.
Don't forget to format the drive after you finish with those steps and set it on fire. That way, you'll be sure the data is really gone. :hehe:
format, then low level format, then wipe via some tool that will write 0's to every sector (30 passes should suffice), then pass it through an electromagnet, then the industrial shredder. We should be good after that.
I don't think 30 passes would be enough in case it survives the fire.
September 3, 2014 at 9:02 am
Sean Lange (9/3/2014)
Gazareth (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions in this thread. 😛Like how to drop a database?
Crikey.
And what is up with that awful banner?!
That banner is almost as bad as the advice being offered. I particularly like the way the guys smug look will follow your cursor around his banner.
Oh god, that's an MSDN blog... <sigh>
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 3, 2014 at 9:04 am
SQLRNNR (9/3/2014)
Luis Cazares (9/3/2014)
xsevensinzx (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions in this thread. 😛Like how to drop a database?
I'm going to apply this useful knowledge right now. I have a feeling I may be back with an update.
Don't forget to format the drive after you finish with those steps and set it on fire. That way, you'll be sure the data is really gone. :hehe:
format, then low level format, then wipe via some tool that will write 0's to every sector (30 passes should suffice), then pass it through an electromagnet, then the industrial shredder. We should be good after that.
I can't believe you give out this kind of shoddy advice. You don't burn it before you shred it. You burn it after you shred it in order to melt the remains into slag. Sheesh. And I thought you were an MCM.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 3, 2014 at 9:10 am
Luis Cazares (9/3/2014)
xsevensinzx (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions in this thread. 😛Like how to drop a database?
I'm going to apply this useful knowledge right now. I have a feeling I may be back with an update.
Don't forget to format the drive after you finish with those steps and set it on fire. That way, you'll be sure the data is really gone. :hehe:
But before you format the drive it's a good idea to run "sdelete -a -p 42 -s * [drive letter]:\*" against the drive, just in case a good drive recovery program might find something after the cremation; and in fact it would be good also to run "sdelete -p 3 -z [drive letter]" against it after formatting and before burning, just in case, and put the remains through a decent crusher after burning. :laugh:
Tom
September 3, 2014 at 9:14 am
Grant Fritchey (9/3/2014)
SQLRNNR (9/3/2014)
Luis Cazares (9/3/2014)
xsevensinzx (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions in this thread. 😛Like how to drop a database?
I'm going to apply this useful knowledge right now. I have a feeling I may be back with an update.
Don't forget to format the drive after you finish with those steps and set it on fire. That way, you'll be sure the data is really gone. :hehe:
format, then low level format, then wipe via some tool that will write 0's to every sector (30 passes should suffice), then pass it through an electromagnet, then the industrial shredder. We should be good after that.
I can't believe you give out this kind of shoddy advice. You don't burn it before you shred it. You burn it after you shred it in order to melt the remains into slag. Sheesh. And I thought you were an MCM.
No no, I forgot the burning part. So burning would be added to the end of the process :w00t:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 3, 2014 at 9:15 am
SQLRNNR (9/3/2014)
Luis Cazares (9/3/2014)
xsevensinzx (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions in this thread. 😛Like how to drop a database?
I'm going to apply this useful knowledge right now. I have a feeling I may be back with an update.
Don't forget to format the drive after you finish with those steps and set it on fire. That way, you'll be sure the data is really gone. :hehe:
format, then low level format, then wipe via some tool that will write 0's to every sector (30 passes should suffice), then pass it through an electromagnet, then the industrial shredder. We should be good after that.
Melt the drive and use the resulting metal to make a new HDD, and then write zeroes to every sector on the new HDD. And then shred it again just to be safe.
September 3, 2014 at 9:19 am
cphite (9/3/2014)
SQLRNNR (9/3/2014)
Luis Cazares (9/3/2014)
xsevensinzx (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions in this thread. 😛Like how to drop a database?
I'm going to apply this useful knowledge right now. I have a feeling I may be back with an update.
Don't forget to format the drive after you finish with those steps and set it on fire. That way, you'll be sure the data is really gone. :hehe:
format, then low level format, then wipe via some tool that will write 0's to every sector (30 passes should suffice), then pass it through an electromagnet, then the industrial shredder. We should be good after that.
Melt the drive and use the resulting metal to make a new HDD, and then write zeroes to every sector on the new HDD. And then shred it again just to be safe.
One can never be too certain of the destruction of the drive.
Better do it five times.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 3, 2014 at 9:24 am
Luis Cazares (9/3/2014)
xsevensinzx (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions in this thread. 😛Like how to drop a database?
I'm going to apply this useful knowledge right now. I have a feeling I may be back with an update.
Don't forget to format the drive after you finish with those steps and set it on fire. That way, you'll be sure the data is really gone. :hehe:
But before you format the drive it's a good idea to run "sdelete -a -p 42 -s [drive letter]:\*" against the drive, just in case a good drive recovery program might find something after the cremation; and in fact it would be good also to run "sdelete -p 3 -z [drive letter]:" against it after formatting and before burning, just in case, and put the remains through a decent crusher after burning. :laugh:.
Although the randomised (42 times) then formatted then zeroised (3 times) then burnt then crushed drive should be very hard to read, some people would advocate putting the crushed ashes through a very strong varying magnetic field and then placing the result into a bath of aqua regis just in case. Personally I'm sure the final chemical attack on the data is just de trop :cool:.
Tom
September 3, 2014 at 9:55 am
SQLRNNR (9/3/2014)
Luis Cazares (9/3/2014)
xsevensinzx (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions in this thread. 😛Like how to drop a database?
I'm going to apply this useful knowledge right now. I have a feeling I may be back with an update.
Don't forget to format the drive after you finish with those steps and set it on fire. That way, you'll be sure the data is really gone. :hehe:
format, then low level format, then wipe via some tool that will write 0's to every sector (30 passes should suffice), then pass it through an electromagnet, then the industrial shredder. We should be good after that.
I haven't watched it myself, but they have shredders out here in Afghanistan that can shred an MRAP.
Viewing 15 posts - 45,436 through 45,450 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply