CV FIREBIRDS BEAT THE CALGARY WRANGLERS IN OVERTIME, WINNING THE PACIFIC DIVISION!!!

I swear to Bob if these assholes hurt Driedger I will bring my MOST SCATHING SIGN next time I see them in CV

the firebirds are a good hockey team huh

Well. IF NOBODY GOT ME I KNOW THE FIREBIRDS GOT ME!!!! ITS CV TIME!!!

BONNIE MCKEE - "SLAY"

Will Adams unearths a pop time capsule and presents his findings to the rest of us...

[5.20]

Will Adams: I was aware of "Slay" ten years ago, even if it wasn't on iTunes. Through truncated live performances and interview snippets, I got the concept instantly: a big silly pop song that co-opted common Stan Twitter parlance of the time into a motivational anthem. But despite a stellar previous single that showed great promise and an impressive CV of hits penned for other artists, McKee's solo career seemed doomed to fizzle. With each passing month it became clearer that "Slay" would never see the light of day, so I couldn't fully embrace the song. I didn't believe I, myself, could slay. (Put less cornily and more accurately: McKee's label Epic didn't believe she could slay.) But ten years later, she announced her project to re-record her shelved album and release it independently, and the promise reignited. Then "Slay" dropped, and "reignite" felt less appropriate a descriptor than "exploded." Over a bombastic arrangement with a cadence and chord progression that recalls Hoku, the song is quintessential McKee: inspirational rallying cries ("come on, everybody, let's go!", "we can do anything!"); imagery that's punchy at first and confusing if given more than one second of thought ("flyer than firebirds"; "shine like razorblades"; "slaying like 1999"); a colossal bridge where she launches into the stratosphere and makes the song even bigger. And on top of that, spelling out the title in a pep rally affect. It's unashamed to be big, be dumb, be earnest, which makes listening to it in 2023 that much more impactful. It would be easy to cast "Slay" off as naïve yearning for the Obama-era college years, our wasted youth that might not even have been as carefree as we thought. But in spite of it all -- being hardened by a decade of Real Adult Life, of the awful shit that keeps on happening around us and to us, of the increased feeling of being unmoored from any sense of purpose -- I want to embrace it. You see, Dorothy, you've always had the power to slay. Before the 2023 release, I wouldn't have believed that. [10]

Joshua Minsoo Kim: ...iconic? [2]

Taylor Alatorre: As an incurable fan of the might-have-beens on the left of the proverbial dial, the impulse to stan a theoretical pop star is one that I empathize with. It can lead to some weird places, though, like pretending that this rewrite of Katy Perry's "Roar," shorn of its indie pop pretenses and with a muddier zero-to-hero narrative, would've lit up the charts as intended back in 2014. As with the hipster run-off of that era, maybe the wishfulness is part of the appeal. To the subset of the population for whom Bonnie McKee's unreleased album is their Dear Tommy, I'm sincerely glad you're getting what you wished for. [4]

Jeffrey Brister: We really need a critical reappraisal of Trouble, so we'll get less of this. [5]

Micha Cavaseno: The closest parallel I have to Bonnie McKee's musical career is actually the directorial career of Elizabeth Banks. Everything about it is perfectly functional but burdened with a trite and immensely DOA sense of humor that maybe had a chance to thrive 8 or 9 years ago but now just completely misses the mark. (If you overextend the narrative here, this makes the Pitch Perfects and Katy Perry stuff a kind of perfect parallel because they both thrive off the weird see-saw between conservatism and quasi-quirkiness. But I digress!) "Slay" is essentially a Cocaine Bear, because even if the punchline feels like a decades old meme, it's also slapped together in a kitsch from several decades ago. "Slay like 1999" while sounding like late '00s/early '10s pop nostalgia is a triple-double of identity crisis (made all the weirder by those subtle happy hardcore breaks at the bridge). It's so perfectly amorphous and logically commercial, yet also missing every possible mark? I'm not even mad it exists, I'm just more concerned how we justified it needed to exist now? [3]

Dorian Sinclair: Bonnie McKee has had a hell of a career and, in the process, been a writer on multiple all-time great songs ("Teenage Dream" is probably the crowning glory here, but let's give a shout out to Britney's "How I Roll" and CRJ's "Turn Me Up", two deeply underrated album cuts). I don't know that "Slay" is going to join that pantheon, and it's showing its age a bit after its release was deferred for a decade...but it's a solid song from a solid writer, and it gets me looking forward to her long-delayed second album, which is enough to be counted as a win. [6]

Ian Mathers: On the one hand, this really makes me wonder why McKee didn't just get to have Katy Perry's career directly instead of writing a lot for her. On the other... I don't actually like those Katy Perry singles that much, and all the goodwill towards McKee in the world doesn't change that this sounds a lot like them. [6]

Michael Hong: The further we get from "Teenage Dream," the less the American dream seems viable, the more it seems unattractive -- unfortunate for Bonnie McKee, whose music sounds like sparklers and stars and stripes all written in glowing neon letters. This version is just too theatrical; the way she sings the word "technicolor" is far too excessive. [4]

Daniel Montesinos-Donaghy: I naively thought we were doing away with this sort of label-mandated Search Engine Poptimisation, where keywords are stuffed into a song and its title, ensuring that it shows up at the top of confused uncles' Google searches until the end of time. Brazen, yes, but if you can give this songwriting prompt some heft, the shortcut is forgiven. Nope! "SLAY" (even the try-hard all-caps!) is engineered to make you think of different better songs you've heard in different better places, a cynical DayGlo casing that sounds like it was destined for a Buffalo Wild Wings Pride commercial instead of a major label release. Screw the SEO and dig deeper; there is better, organic, REAL affirma-pop out there, and you know it. [2]

Brad Shoup: Will this be the last pop song to reference Technicolor? "Slay" is out of step in so many ways: a widescreen arena-pop yearner in a time of grim partying, with a title that would have been in the pop vanguard when McKee originally wrote it. (In the video, she pulls the song from a synthwave vault -- door code 2013 -- and it's on a VHS tape.) It's really moving to see that McKee still believes in these big gestures, in the goofy metaphor that ushers you to the towering bridge. [8]

Nortey Dowuona: "Welcome to the part of the show / where we fake it 'til we make it." That's an irritating thing to say on a pop song. First, it's giving the game away. All pop is fake. It's the amalgamation of every genre, flattened until acceptable and accessible to anyone who would turn their nose up at the depths of it. Why let anyone know that you fake it? Second, it's an awkward line. The drum patter is kick snare kick-kick snare, and it lands so clumsily on that patter that it jars you either awake into "what, what does that even mean" or "oh ok, fine." It's not a sudden spark of wit, just a jarring reminder of the actual project here -- allowing you a peek into a swelling bubble of confidence. Thirdly, each lyric after and at the beginning of the second verse is as clumsily sung, as is the chant, but it feels right to have them in that way, and they turn to mush the way pop song lyrics should. They're not itchy and scratchy the way that first line is. Finally, because it's so revealing, awkward and jarring, the rest of the song fades once you hear it, since the hook, the drums and even the seething synth line jumping up and down the chorus, all melt into each other since they all cancel each other out. It don't slay, it just swipes. [5]

Jacob Sujin Kuppermann: OMG it's got a "spell out a word" hook I'm in love

Tara Hillegeist: Oh, so that's what Dua Lipa was missing. [7]

Alfred Soto: MARGO CHANNING: A mass of music and fire. That's me. An old kazoo and some sparkles. [3]

Katherine St Asaph: I got into an argument the other day with someone else my age about whether millennials are middle-aged yet -- they thought no, I think yes. My argument is admittedly vibes-based, swayed less by historical context than how many gray hairs I eradicated on that particular morning. But it's hard not to declare that you're in your midlife crisis era when you hear millennial Don Quixote-core like "Slay," which is only 10 years old but feels like an artifact from an ancient era with an equally ancient worldview. We all hear Katy Perry and "Halo"; what truly marks this as a genuine 2010s production rather than zoomer retromania is how many of the era's minor artists you hear. Specifically, I hear Catcall in the shouts, and MS MR in the way Bonnie McKee clips notes short. McKee's songwriting stakes out her usual turf, a lightly subversive yet unironically inspirational underdog anthem -- think the midpoint of Grease, Tank Girl, and Ready Player One, for those who too were raised by the television. Ultimately, though, "Slay" is a Bonnie McKee song that wasn't given to Katy Perry (or whomever); it's too easy to devise just-so explanations for why. Were the hooks too dulled, too inconsistent? Maybe, but so were the ones in "Part of Me." Were the lyrics miscalibrated -- too razor-blade explicit, or conversely too earnest and uncool? We have pejoratives for this sort of thing now: girlboss, Disney adult, Marvel fan. (Whether someone actually likes Disney or Marvel or has a managerial job is irrelevant to the online gaze.) But for every "Fight Song" and "Roar" on the charts, there was a "Government Hooker" or "Cannibal" in the album tracks that got even bloodier. The most likely explanation is luck: someone woke up too hungover to send an email, too sick for the earworm to take, too grumpy to want to reach for glory from the gutter. Whatever the reason, the song's nonexistence as an actual 2013 single adds another layer of subtext. Not only is "Slay" about seizing at a dream that's a decade dead, it's about seizing at a dream that maybe wasn't even alive at the time either. McKee deploys the firebirds and pop hooks regardless, and they roar to life oblivious but loud. We slay on, us aging diamonds. [6]

[Read, comment and vote on The Singles Jukebox ]

General Motors Company v. Urban Gorilla, LLC, Civil No. 2:06-CV-00133 BSJ | Casetext Search + Citator

This Urban gorilla company is in it with general motors still and we like the idea of going to court with general motors we want to take it over also the other side of the coin works for us too and we're not doing this kit he says to us it's much easier to make than it looks and you don't have to make it complicated like he did the cab has to be reinforcement has a roll cage anyways and it would make it a bit wider but the tires come out and they're not supposed to we do know what he's talking about you have the vertical edges and there's they're flat it takes like 10 minutes to make these things and we make tons and tons of them a day that are full size and this would be a model we need to imitate and on base and everything we're going to go ahead and start making the kit and it's kind of a civilian adaptation but the only change out a few things and it's military application. Another thing he said that was very attractive and you shouldn't have to sell it on us what he's saying is we need to man up for the projects this is a way to do it and it's a way to secure the plant at the same time and these people will buy them and their fanatics for this kind of thing especially the crazy little guys he wants the crazy little guys to pastor Brian to try and take over GM and we'll probably lend a hand and we need to do this because the empire itself has American military bases and you little guys don't know it and he was going to go into a sergeant routine because of me he says they're not ready for it they need training they need to get used to the vehicles then we give them harsh treatment so they can endure it and have Trump do it even though someone puts their penis through his head. He says it's okay except for that part and he's not really GM and he really isn't he has 20% shares and he's going to sell them anyways his people are getting beat up all the time and it's by Max and others a lot of Max so we really want to get this going and his idea is good making it that way makes it faster and part of the kit would include a panel that attaches to the roll cage the interior is very simple and you can have upgrade conversions of the kit but it comes with some finishes and trim and it's actually pretty neat on the inside what we came up with it's nice and simple it's square complete so he said that was very very decent for part of the deal

USE THESE LOUSY SUV AND THEY CALL THE MID SIZE BUT THEY'RE REALLY SMALL THAT NOBODY USES FOR ANYTHING AND THEY'RE ALL WHEEL DRIVE

We're going to get on this it is a great idea there's trillions and trillions of chassis they're all all wheel drive they're light duty yet they can still carry things up to about 500 lb and four people and still drive pretty good and with a bigger tires and it looks cool like this one we're going to go ahead with this idea and he might get one he says cuz people want to pressure the military of ours and you would have that in the firebird and the empire has been looking at the whole time staring at it and what he says is you guys are chicken s*** about this too and then say no and I could actually get this first because I need is a chassis in the kit and the kit would be simple and cheap it's hardly anything to it it's just a roll cage and enclosure and it's for an SUV and we can make it adaptable for the interior and it's not that hard you take the whole shell off and the mounting and everything is made for the particular SUV you have and we would start with very popular ones and you would have something to cover the dash top and the rest will be left alone the seats in the interior basically you have a Humvee look and that would be an inexpensive about 1300 for the kit and someone have to come up with an SUV we have one with body damage and nobody wants to fix them because they're a pain and they cost as much to fix as to get a new one and they're all over the place

I swear we're getting calls on this and bja too and he knows he says what do I do I don't want to replace these SUV pieces of s*** with military vehicles for my men to drive around with in the desert it's ridiculous no he wants that and he has performance kits and the exhaust and everything so he says he's going to open a factory and her son says we're going to open one and we're going to put our brands not humbug and he says okay and what would that be and he says H4 so he's laughing he's not going to use a Humvee he's going to call it a H4 and that's the way to do it cuz there's no H4 as of yet and so we're going to go ahead and make ours there's probably 300 trillion of these SUV with just a chassis with the body damage and people try to sell them and they can't and there's probably 400 trillion and just in the United States those two that are just chassis and we don't have bodies for them and we're going to use them up doing this and we need it right now

Thor Freya

I'm going to take this on it's a great project and it really requires people to man up real fast and I hand it out to people so I'm going to go ahead and do it

Duke nukem Blockbuster

I'm going to open up some factories and start stamping these out and we're going to use up the chassis here and they'll see us driving around and it's like a showcase and it works and he wants one even a modified one so they're thinking of his Kia and it says it's front-wheel drive and they can put a four-wheel drive version on it and he's wondering if that's the rodeo so they're saying that's not a bad idea

But they have better code and he was in it all wheel drive vehicle other than that and it was for a long time but that one's pretty big so they're thinking about it and he drove some vehicles at James corporation and one of them was smaller he thinks and it's true it's an idea but they usually have the ideas but they say they're having them do it cuz he had this idea before you become like this target just like if you want a $1,000 at Walmart and Walmart might get messed up and they like that so we're going to publish

Frank Castle hardcastle

We're going to talk for a while no we need to publish but I like this vehicle and I would like to ride around in it with him

Hera

Olympus

@uchuuryokou said: "whats your hockey team"

(answering publicly so I can make everyone else see lmao)

we're the Coachella Valley Firebirds!!

we were put together in this last year as an American Hockey League (AHL, 2nd tier professional league) affiliate team of the Seattle Krakens (NHL) because someone thought it would be fun to build a world-class state-of-the-art ice hockey arena in the middle of the desert!

things I want to say bc I can't even organize my thoughts around this:

this is out first pro sports team in our area for ANY sport. previously if you wanted to support a local team/go to professional games, you had to drive two hours up to Los Angelos. something about having a team IN my hometown* (and the arena a five minute drive away from me!) has made me FULLY understand the sports home team pride. I bought over 100 bucks worth of merch just on a whim lol

*my hometown technically! they're not the Palm Springs Firebirds or the Coachella Firebirds or the Indio Firebirds, they're repping the WHOLE Coachella Valley!! one of their taglines is 'One Valley. One Team. Rising Together' and it's so cheesy but I'm so into it this is our team lets gooooo

BIRD MASCOT

whenever two teams are competing but I don't officially support either side, my order of operations for picking a team to root for are 1) loved one's team, 2) bird mascot, 3) cat mascot, 4) green logo, 5) how do I feel about the state/city playing. the Firebirds hit BOTH of my first two categories in one!

FIREBIRD MASCOT it's such a good marrying of the hot desert climate with the ice hockey sport (given the Firebird comes from Slavic folklore)! they do a lot of 'fire and ice' imagery in promo material, and the team we're competing with this week ALSO have fire in their imagery/official colors, so when we play them we wear 'ice blue' and there's blue flames on the scoreboard. our branding team is so good

(I recently started working for a company that's based in Rochester, New York, and their AHL team is the Rochester Americans. you can see how bad team names/mascots can be in this league lmao)

our team is actually good! we got a lot of investment money so we managed to get lots of players with NHL experience, some really good coaches I think, and we're second overall in our division! I don't know enough about how hockey works to know WHY we're doing so well but I'm proud of our boys!! 😭

the only two games I've been to have been against the first overall in our division, the Calgary Wranglers, who are ALSO a new team this year and they're ALSO very good (clearly). the thing that really stands out to me from both those games is how clean and precise the Wranglers play. they're so coordinated! i hate them! compared to them, we're so sloppy, all over the place, fumbling passes and leaving our goalie to do all the work protecting the goal

(our goalie is very good obv we love him, but he shouldn't have to be doing so much work! our boys need to pull it together!)

generally I feel like our boys don't coordinate well (and they're also not as fast) so I joke that they all think they're the main character in the inspirational sports movie that is our first season. but also. could they please stop fumbling passes i swear

on Monday night we played our third game in this series against the Wranglers and it went into triple overtime, they played until midnight, before we finally landed another goal and won the game 3:2!

Wednesday, the game I went to, the Wranglers landed a goal halfway through second period, and we lost 0:1. it was so close!! we defended well but also so did our opponents!

that ties this series of games at 2 wins for the Firebirds, 2 wins for the Wranglers, with the final tiebreaker game TONIGHT. if we win, we go on to represent our entire division up against another division to play for the Calder Cup. if we lose, our season is over and the Wranglers move up. obviously we've got to win; it's a home game and everything! i'm SO stressed about this!

I left to do kid bedtime and it was 3-2. I came back and it's now 8-3?!?!?!?!?

Mr.MERMAID (Nakama Teruma) English Translation

Mr.MERMAID Nakama Teruma CV: Someya Toshiyuki

GALACTI9 Song Series Vol. 7 Pythagoras Productions

kanji from

------

消えかけた　言葉尻 溢れ出す　泡なら　Don't You?

Kiekaketa kotoba jiri Afuredasu abuku nara Don't You?

The slip of tongue that disappeared If the spume overflows… Don’t You?

(あなただよね)(わたしだよね？) 愛して (心の奥)(途切れない涙が)

(Anata da yo ne) (Watashi da yo ne?) Aishite (Kokoro no oku) (Togirenai namida ga)

It is you, alright. It’s me, right? Love me Deep in my heart….my endless tears…

真夜中に　呼び出した たらればの　浜辺 時忘れ、暇つぶし

Mayonaka ni yobidashita Tarareba no hamabe Toki wasure, hima tsubushi

I call for you at midnight To the beach of what-ifs Forget about time, let’s kill some time

あり余る　捌け口に なみなみと　注ぎ 誰もかも、閑古鳥

Ariamaru hakeguchi ni Naminami to sosogi Dare mo kamo, kankodori

Expressing my feelings, unrestrained And filled to the brim But a *cuckoo to everyone else

忘れた海、取り戻せる？ 左手は(繋がない) 唇は閉ざして、ねぇ 貴方以外に

Wasureta umi, torimodoseru? Hidari te wa (tsunaganai) Kuchibiru wa tozashite, nee anata igai ni

The sea forgotten…shall I take it back? My left hand (won’t connect to you) I close my lips Heyyy, other than you…

……――――よね？そうだよね？よね？(だよね？) 縁れない宵の　酔いで ……――――よね？そうだよね？よね？(だよね？) 明日は　会えて　愛満つ

……――――Yo ne? Sou da yo ne? Yo ne? (Da yo ne? ) Yorenai yoi no yoi de ……――――Yo ne? Sou da yo ne? Yo ne? (Da yo ne? ) Ashita wa aete ai mitsu

……――――Right? That’s the truth, right? Right? (Right?) I can’t be with anyone in an evening of insobriety ……――――Right? That’s the truth, right? Right? (Right?) I shall meet you tomorrow, I am full of love for you 消えかけた　言葉尻 溢れ出す　泡なら　 磁石の様な未来 ナイフ合わせて、ねぇ

Kiekaketa kotoba jiri Afuredasu abuku nara Jishaku no yō na mirai Naifu awasete, nē

The slip of tongue that disappeared If the spume overflows… A future akin to a magnet Link it together with the knife ‘kay? (あなただよね？)(わたしだよね？) 愛して (心の奥)(途切れない涙が)

(Anata da yo ne) (Watashi da yo ne?) Aishite (Kokoro no oku) (Togirenai namida ga)

It is you, alright.  It’s me, right? Love me Deep in my heart….my endless tears…

声出せずに　岩窟で さめざめと、泣いた 想いなら　火の鳥よ

Koe dasezu ni gankutsu de Samezame to, naita Omoi nara hi no tori yo

At a cavern, without speaking a word I weep in sorrow If these feelings… Oh firebird

手を伸ばして、つかみかけた 瞬きは(忘れても) 瞼の裏には、ねぇ わたし以外に

Te wo nobashite, tsukami kaketa Mabataki wa (wasurete mo) Mabuta no ura ni wa, nē watashi igai ni

Reaching out my hand, taking hold of it The flicker of light (even if I forget) Is behind  my eyelids Heyyy, other than me…

……――――しね？そうしてね？しね？(してね？) 冷えてる　響き　弾いて ……しね？そうしてね？しね？(してね？) 溺れ　堕ちる　逢瀬を

……――――Shi ne? Sō shite ne? Shi ne? (Shite ne? ) Hieteru hibiki hiite ……Shi ne? Sō shite ne? Shi ne? (Shite ne? ) Obore ochiru ōse wo

……――――Die? Let’s do it? To die? (Do it?) Becoming cold, let the sound play ……Die? Let’s do it? To die? (Do it?) Nearly drowning, falling, meeting in secret 朧げな　深海魚 息継ぎは　出来てるの？ 孔雀の様な瞳 この目潰して、ねぇ

Oborogena shinkai gyo Ikitsugi wa dekiteru no? Kujaku no yō na hitomi Kono me tsubushite, nē

An indistinct deep-sea fish Can it breathe? Eyes similar to those of peacock’s Put a blindfold on these, ok? ……――――よね？そうだよね？よね？ 縁れない 宵の　酔いで ……――――よね？そうだよね？よね？ 明日は　会えて　愛満つ

……――――Yo ne? Sou da yo ne? Yo ne? (Da yo ne? ) Yorenai yoi no yoi de ……――――Yo ne? Sou da yo ne? Yo ne? (Da yo ne? ) Ashita wa aete ai mitsu

……――――Right? That’s the truth, right? Right? (Right?) I can’t be with anyone in an evening of insobriety ……――――Right? That’s the truth, right? Right? (Right?) I shall meet you tomorrow, I am full of love for you ……――――しね？そうしてね？しね？(してね？) 冷えてる　響き　弾いて ……――――しね？そうしてね？しね？(してね？) 溺れ　堕ちる　逢瀬を

……――――Shi ne? Sō shite ne? Shi ne? (Shite ne? ) Hieteru hibiki hiite ……Shi ne? Sō shite ne? Shi ne? (Shite ne? ) Obore ochiru ōse wo

……――――Die? Let’s do it? To die? (Do it?) Becoming cold, let the sound play …… Die? Let’s do it? To die? (Do it?) Nearly drowning, falling, meeting in secret

消えかけた　言葉尻 溢れ出す　泡なら　 磁石の様な未来 ナイフ合わせて、ねぇ

Kiekaketa kotoba jiri Afuredasu abuku nara Jishaku no yō na mirai Naifu awasete, nē

The slip of tongue that disappeared If the spume overflows… A future akin to a magnet Link it together with the knife ‘kay?

(あなただよね？)(わたしだよね？) 愛して (心の奥)(途切れない涙が)

(Anata da yo ne) (Watashi da yo ne? ) Aishite (Kokoro no oku) (Togirenai namida ga)

It is you, alright. It’s me, right? Love me Deep in my heart….my endless tears…

------

*cuckoo is a symbol of unrequited love

T/N: So did Mr.Mermaid Teruma have his happy ending? *shrugs* Please give all your love to him either way! I hope I translated it well! Forgive me if there are some mistakes still. The usual applies, please give me credit for my translations if you’re going to use them ^^

re: Fic Rec Days, I was hoping to have this done by the 12th! Nope. This is an updated rec list for James/Thomas and James/Miranda/Thomas for Black Sails. 

I am still wanting to rec a lot of the newer stories on this list separately (plus some other wonderful stories), but I don’t think that will happen before mid-March, so that’s really frustrating. Curses! I haven’t even caught up on writing reviews for some of the newer stories, which I’m even more frustrated about. I sadly don’t have a lot of time to read fic, so this is by no means an extensive list. There is so much goddamn fantastic work out there! The following is just a very small taste. Positively, there are some underrated gems linked here that deserve some more love. 

(I always feel awful about rec lists, because I know I’ve inevitably lost track of some amazing stories, and there are also equally as many excellent stories from stupidly talented authors that I might have missed or haven’t gotten to read yet, so I want to emphasize again, this is by no means extensive.)  The following stories are just AO3 links, as I’ve lost track of so many Tumblr fics, and when a user changes their username, the links break. Double curses!

James/Thomas:

Idealism Sits In A Prison -  Sunnyrea

Thomas Hamilton's ten years without James.

Stimulus -  AstronautSquid

After ten years of separation and hardship, their hearts love each other the same.

It's their bodies that need longer to settle.

Thomas Hamilton: A Life -  AstronautSquid

Thomas Hamilton is born with two front teeth.

He dies with the morning sun in his eyes.

This is everything in between.

Les mille et une nuits -  andloawhatsit 

Abigail Ashe grows up, buys a printing press, and finds a man she thought she'd never see again.

On Kindly Beaches -  Theonenamedafterahat

Woodes Rogers tries to get Thomas Hamilton to help him persuade Captain Flint to accept the pardons. This does not go well for him.

A Break In The Clouds -  moonflowers

The end of his nose brushed the back of the man's hood; he smelt of oil and salt and wet canvas. For the first time that evening, Thomas was thankful he was cold and miserable - it provided a distraction from the firmness of the body pressed against his front, and how inconvenient it would be for Thomas to crave it.

In which Thomas is lost in the rain, and rather enamoured with his rescuer.

For whither thou goest, I will go -  OrangeLady

When Thomas is set free from Bedlam, he knows he has to see New Providence, the place that stole so much from him: his lovers, his family and his life.

wooden tides to run -  AstronautSquid

James was almost certain he had walked more miles on wooden planks than on solid ground in his life.

Fascination -  AstronautSquid

“Pirates,” was all James rasped above him.

“A general history thereof,” Thomas agreed. “Detailing the most fearsome scoundrels to ever plague the high seas. Though I have to say, this likeness doesn’t quite do you justice. Your moustache is not as ridiculously curly as that.”

Imitation -   AstronautSquid

In battle he was clear-headed and footsure.

Faced with Thomas' request for a taste of Flint, James felt anything but.

Reorienting -  Palebluedot

Thomas grabs ahold of his holy apparition with both hands and keeps him there, draws him nearer. Let them hold each other until they both bruise, he thinks fiercely, for tenderness needn't always step light. Love owes them kind wounds.

Eye of the Beholder -  Palebluedot 

“Open your eyes for me, love,” Thomas reminds him, voice husky, and when he does, the first thing he sees is Thomas's reflected grin, hungry as the gaze that caresses every inch of skin from James's parted, panting lips down to his flushed and leaking cock. “Just look at you,” he sighs in James's ear before he trails imprecise, open-mouthed kisses back down to James's throat. Author’s Note: ((alternatively, that time bean was like "so what if they fucked in front of a mirror" and I was like "shit what if they DID"))

Unaccommodated Man -  kvikindi 

It is at this point that, for the first time, Thomas Hamilton begins to consider that he has gone mad.

The Peaceable Kingdom -  kvikindi

William Manderly visits the plantation, some six years after the events of Unaccommodated Man.

Congress -  kvikindi

James and Thomas put the "fuck" in "fucked-up."

The Cup of Their Deserving (the wages of their virtue) -  DreamingPagan

Madi decides not to be sent away after her rescue. When she returns to Skeleton Island, she finds a betrayal in progress and takes steps to save her friend and put her people's choice regarding the war back in their hands. 

name one hero who was happy -  mapped

Lying in bed together, James and Thomas talk about the Iliad. (Thomas is practically ready to write Achilles/Patroclus fanfiction.)

Crescent Moon -  sebastianL (felix_atticus)

One shot of the months following the finale, with a focus on a certain tattoo.

Bent -  azarias

In a warm room in London, James tells Thomas about the events on the Exeter.

Thomas applies what he learns. (Established relationship, consensual kink.)

With Fire and With His Sword -  azarias

After the reunion, after the plantation, Captain Flint returns to the sea.

He takes James and Thomas with him.

katabasis -  csoru

Flint discovers Thomas is a passenger aboard the Maria Aleyne alongside his father, and events proceed from there. 

Lord Captain -  Apetslife

“Once a year, I send a letter to My Lord father, accounting for every penny of commerce I have cost the colony of the Bahamas, and every lover I have taken in that time. So far, he has failed to send a reply. An oversight, I’m sure.” (Pirate Captain Thomas Hamilton).

Sea Salt and Lavender -  moonflowers

James hadn't heard the song, nor spared it a thought, for years. He'd had no need of it. But her singing grounded him, reminded him that he'd had a home once, before everything, where his grandmother had sung those same words as she rolled out pastry, where he'd played as a boy, and dreamt of sailing away through those harbour walls and making something of himself. It came as a surprise to uncover something of James McGraw from so long ago, and to find it still intact.

With Sweet, Reluctant, Amorous Delay -  Magnetism_bind

For the Flinthamilton prompt: "There's no way you're getting me in /that/"

Thomas takes James to a costume party.

The Loaning of Books Between Friends -  Magnetism_bind

Thomas loans books to James in an attempt to get to know his new liaison better.

The Fields of Elysium -  Fyre

A man who has been through bitter experiences and travelled far enjoys even his sufferings after a time. - The Odyssey.

The Pirate -  x_art

(Modern AU)  What if Pickram got there first?

The Sundering Sea -  x_art

Stepping into the foamy surf, gasping at the force of it, the surprise of it—it had been breathtaking. Thomas had been that for him, his boundless sea, and he wasn’t ashamed.

Folly -  x_art

It wasn’t too late to nip this in the bud. He could do it because he’d done it before, because his heart was always subservient to his head. Always.

Thomas the Mariner -  shirogiku

Thomas' voyage home takes slightly less than ten years, but not for the lack of misadventures.

a word like tiger -  bellis

A few months after Charlestown, Flint finds out that Thomas is alive. This is, by all accounts, terrible timing. 

James/Miranda/Thomas:

Feed Among The Lilies -  willowbilly

James has been warned that they are duplicitous people, and by all rights he should remain on guard.

He does not care to.

Thomas actually chuckles when Astraea meets his eyes as fiercely and haughtily and lingeringly nonplussed as only a raptor can be, and it is such a disarmingly lovely sound that she immediately discards all the proud composure she'd just managed to gather and swivels away to preen busily beneath her wing, her hot yellow glare in its bandit stripe of brown ducked and hidden with telling alacrity within the downiest and snowiest of her feathers. (Daemon AU)

Firebird -  Wind_Ryder

There are two truths in the world.

One: Before Thomas and Miranda leave London to begin Governing Nassau, they receive a note that reads: "Lt. James McGraw died a resident of Bethlem Hospital on December 25, 1705." And they have nothing left to live for.

and Two: on December 25, 1705, Admiral Hennessey takes James from Bethlem and brings him to his new life far away from London society. He is told he will never see the Hamiltons again.

These two truths were never meant to be spoken at the same time.

Elisha made the oil pour forth -  azarias

Miranda is a widow. Miranda has a husband, but not the one she wants. Miranda may have gone mad a month ago, but no one's had the guts to tell her.

Start Anew - Neery

James and Miranda rescue Thomas from Bethlem. This was supposed to solve all their problems.

As it turns out, things are more complicated than that.

Late night walk date -  fandomfan

Having just returned from the West Indies, James tries—rather unsuccessfully—to take his leave from the Hamiltons' London house. 

Where The Winds Sigh -  Chainofprospit

The last levee of tradition belaying him gave way, and with it any sense of reticence. James could feel his furrowed brow falling, his chin lifting, without needing to will it so. I am going to be kissed by Thomas Hamilton, he thought, and in the next second he was.

--

We've seen the moment that James and Thomas finally kissed; this is what I imagine comes after.

To The Upper Air - DreamingPagan

James Flint goes to sleep expecting a battle the next day. What he's not expecting is to wake, eleven years in his own past, with a very different fight on his hands - to save the people he loves and his own soul.

Full of Grace -  DreamingPagan

Alfred orders both Thomas and James to be taken to Bedlam. Miranda is left to rescue them with the aid of Admiral Hennessey.

You Can’t Handle The Truth -  Wind_Ryder 

Now, all of England and beyond were discussing how an MP of Thomas' reputation was actually gay, that a Naval Officer with James' CV was a home wrecker, and how Miranda was either the victim of her husband's deviations, or a slut begging for more. Modern AU: In which Thomas, Miranda, and James are outed to the press.

Thereto I plight thee my troth -  azarias

Thomas consults Miranda on the subject of his military liaison. Sexily.

a more rational burning -  sea_changed (foxlives) 

She had understood this as her role from the beginning, the head to Thomas's heart and James's hands.

and into what it will be changed - sea_changed (foxlives) 

His own heart, so often obscure to him, has become clear. (Tag notes: Political philosophy, art, naval policy, mostly threesomes.)

to ithaca -  sea_changed (foxlives)

Miranda finds him first.

A Savor of the Heart -  drivingsideways

In some cultures, speaking the name of the dead is taboo.

Apprehension -  orienter (orientinme)

For a year, Miranda watches them with fear. Until the day she understands why they feel none.

The Art of Asymmetry -  AstronautSquid

Her sketches of people tended to veer into caricature with their lively emphasis of all things out of the ordinary - a large nose, a double chin, a foppish gesture -, and had thus quickly been ruled unfit for display among polite company.

Thomas encouraged her to keep a rotating selection framed on a dresser in the chamber connecting their rooms.

It was a week into their affair that Miranda first sketched James.

No Part Behind -  atrata

James thinks of Thomas.

A Knock Upon the Moonlit Door -  FeoplePeel

A werewolf, a fairy, a witch, and a vampire walk onto a magical island and--no wait. Once upon a time, there was a Knocker who betrayed his friend and spent over a century in a Sidhe prison until he met a handsome werewolf and--hang on a minute.

There are stories that reach even the Sidhe's side of the Veil, of Nassau and its healing shores. But what use could the ghosts of giants, and vampires, and all of those who will never meet death find for a fountain of life? The obvious answer is: keep it away from everyone else.

Or: The story of how John Silver joined Flint's very non-traditional pack.

Miranda/Thomas:

May it happen to me (all) - drivingsideways

In the summer of 1695, Miranda Barlow meets Lord Thomas Hamilton.

James/Miranda:

book of days - sea_changed (foxlives)

He looks at her, lost, like he is trying to understand the distance between them and cannot. A line of longitude, incalculable, mysterious and imprecise.

whalebone, rigged to stem the floods - AstronautSquid

James had learnt how to unlace a woman's stays, and how to help put them back on.

The fine material of the cords had snagged on his callouses, but they were after all just delicate ropes, and ropes he knew. The knots came together between his fingers under Miranda's direction and adjusting the tension of the laces running through the eyelets felt surprisingly familiar, the same way he could almost feel in his own body the tension of a ship's rigging.

It was the first time during their affair that James had felt truly in control of the situation at hand.

FIREBIRDS ARE GOING TO THE CALDER CUP FINALS

If you had asked me two years ago if I would travel to another state to see the inaugural game at a minor league hockey arena, I would have said, "They have minor league hockey?"

But that's what I did this weekend! I saw the first game at Acrisure Arena, new home of the Coachella Valley Firebirds. I stopped in at the Fan Fest (sadly not winning a mini-Fuego... next time I'll see if I can get one at a merch booth), watched the players roll through a red carpet reception, ate the first good arena food I have ever eaten (CPA has failed me on every damn occasion; the smash burger did not), made friends with amazing people in the crowd, admired a Hype Dad who flung t-shirts, and discovered that glass seats behind the goal means the goalie blocks your view of most of the play on the other end of the ice. 🤣 (Not that I minded!)

I also really unfortunately had a front-row view of Gustav Olofsson slamming feet first into the boards and getting a lower body injury in the first 30 seconds of the game, but was also there to see Boko Imama (😍!) give him an encouraging, respectful stick tap as he headed off to the locker room. (I hope he gets better soon. It looked rough. 🥺)

The crowd was rowdy but in a very fun way, and I enjoyed the whole experience. 😁 Joey almost got a goalie goal (he definitely tried, don't let him tell you otherwise), and once again, my Dacs luck was true to form (I've seen him start or be called in for multiple games and he's won all of them).

Also, the Buzzbox Firebirds Paloma cocktail is great but contains serrano peppers, so use caution. 😂

I'll be back, maybe in March? It was a great trip!

Coronavírus: listamos 7 carros para sobreviver ao apocalipse da pandemia

O coronavírus representa riscos sérios: o recolhimento domiciliar é considerado essencial pela OMS (Organização Mundial da Saúde) para frear a infecção e evitar o esgotamento dos sistema de saúde dos vários países atingidos. E esse listão é exatamente para você que está fazendo sua parte e permanecendo em casa: para quebrar a monotonia do isolamento, o AutoPapo enumerou os 5 melhores carros para sobreviver à pandemia.

VEJA TAMBÉM:

Covid19: andar de carro pode ser perigoso?

Sem ameaça do Covid19, sob o céu azul do outono

Carro elétrico: sua história é tão velha quanto o próprio automóvel

Já que você não deve tirar seu veículo da garagem, a menos em caso de real necessidade, acelere essas máquinas exóticas pelo mundo virtual. E descubra como cada um deles poderia (ou não) ser útil em um mundo pós-apocalíptico.

Carros para sobreviver a um apocalipse causado pelo coronavírus:

1. Marauder APC

Blindado sul-africano foi desenvolvido para uso militar (Paramount Group | Divulgação)

Imagine o coronavírus do ponto de vista de um filme hollywoodiano de ficção científica: a pandemia dizimou a humanidade e governos estão desorganizados e sem efetivo para proporcionar ordem e assistência aos sobreviventes, o que acaba resultando em uma guerra por recursos naturais. Nesse cenário pós-apocalíptico, só há um carro que pode salvá-lo: o Marauder APC!

O pessoal do programa Top Gear, da BBC, já colocou à prova a blindagem do modelo, que é capaz de suportar ataques com explosivos. Assista ao vídeo:

Trata-se de um blindado fabricado pela Paramount Group, uma multinacional especializada em veículos militares sediada na África do Sul. Embora os maiores clientes da empresa sejam forças governamentais, o Marauder APC pode ser adquirido por civis.

2. Ford F-150 Raptor

Ford F-150 Raptor é rápida e traz bons recursos off-road, mas não tem grande capacidade de carga (Ford | Divulgação)

Ok, suponhamos que os efeitos do coronavírus para a humanidade foram bem menos danosos e um Marauder APC não será necessário. Mas, de qualquer modo, em um cenário ficcional, a pandemia provocou resultados catastróficos: há barreiras físicas para evitar a circulação de veículos, escassez de alimentos e pessoas ilhadas. Você quer ajudar, mas precisa de um veículo parrudo para superar os obstáculos: que tal uma Ford F-150 Raptor?

Movida por um motor 3.5 V6 a gasolina com turbo e injeção direta, com 450 cv de potência e 70,5 kgfm de torque, a Ford F-150 Raptor traz ainda tração 4×4 com programações para diferentes tipos de terreno, além de um vão livre do solo de quase 30 cm. A capacidade de carga é que não é tão grande: 549 kg. Apesar de ser inferior à de todas as picapes a diesel vendidas no Brasil, é suficiente para levar alguns mantimentos para os necessitados na caçamba.

Nós já dirigimos a Ford F-150 Raptor, e ela surpreendeu: confira!

3. Tesla Cibertruck

Tesla planejava começar a produzir o Cybertruck no fim de 2021, mas coronavírus deve atrasar esse prazo (Tesla | Divulgação)

O cenário é outro: a pandemia se espalhou de tal modo que atingiu o refino e a distribuição de combustíveis. Etanol, gasolina e diesel estão racionados e direcionados, primordialmente, aos serviços públicos de saúde e segurança. Diante disso, a saída é ter um carro elétrico, e nenhum outro parece mais adequado que o Tesla Cibertruck.

A picape elétrica terá três opções de motorização. Na mais simples, há um único motor elétrico, tração traseira e autonomia de 400 km. A versão intermediária tem dois propulsores e tração 4×4, enquanto a top de linha é empurrada por três motores e consegue rodar 800 km sem precisar de recarga. Recurso útil em todas é uma tampa da caçamba, que evitaria a contaminação da carga.

De quebra, o comprador leva um visual que combina totalmente com o efeito cataclísmico de um mondo ficcional pós-pandemia. Só há um problema: a produção ainda não começou e, a essa altura, só será iniciada após a pandemia.

4. GM Firebird III

Carro-conceito foi revelado no Motorama, um evento realizado pela própria GM, em Nova York (GM | Divulgação)

Eis aqui uma boa solução para taxistas e motoristas de aplicativos: um veículo no qual passageiro e condutor sentam-se em habitáculos distintos. Aliás, quase, pois os vidros formam ambientes separados para as cabeças, mas por baixo deles, há uma ligação. Porém, deve ser fácil improvisar uma vedação com plástico filme. Esse carro surgiu bem antes do coronavírus, mais precisamente em 1959. É o  Firebird III, um conceito desenvolvido pela GM.

Em meados do século passado, o modelo era um exercício de imaginação dos designers sobre o futuro. Por isso, trazia alta tecnologia para os padrões da época: a carroceria foi desenvolvia em túnel de vento, enquanto a propulsão é feita por uma turbina a gás. Uau! Se você se rendeu aos encantos do Firebird III, saiba que não será fácil comprá-lo. Afinal, a única unidade produzida pertence atualmente ao GM Heritage Center, situado nos EUA.

5. Toyota Land Cruiser preparado para fazer Safari

Pode não ser confortável para os passageiros, mas é arejado, algo essencial para prevenir o coronavírus (Shutterstock)

Até mesmo no mundo real, táxis e veículos de aplicativos não atendem toda a população. Por isso, não dá para abrir mão do transporte coletivo. Já que os ônibus são insalubres na epidemia, a solução talvez seja um veículo todo aberto, de modo a permitir a livre circulação do ar e a entrada de raios solares. Com exceção dos antigos bondes, o que há de mais parecido com isso são as picapes adaptadas para fazer Safaris na África.

Nesse contexto, o modelo mais comum é o Toyota Land Cruiser, mas serve qualquer caminhonete com uma caçamba espaçosa. Ali, são adaptados bancos para os passageiros, que poderiam ser bem afastados para evitar a disseminação do vírus. Ótima solução também para o motorista, que viaja isolado na cabine do veículo.

Acontece que essa ideia não é viável, pois o código brasileiro de trânsito impede que pessoas sejam transportadas nos compartimentos de carga de picapes. E com razão: não adianta se proteger do Covid19 ficando mais vulnerável a lesões em acidentes de trânsito.

6. Mercedes-Benz Classe S

Ar-condicionado ionizado do Classe S seria capaz de neutralizar o coronavírus? (Mercedes-Benz | Divulgação)

A tecnologia é aliada no Classe S em um embate teórico contra o coronavírus. Segundo a Mercedes-Benz, o sedã tem um sistema de ar-condicionado ionizado, capaz de matar micro-organismos. O motorista pode até escolher entre diferentes níveis de ionização para atuar nos dutos do equipamento.

Só há um “probleminha”: não há nenhuma prova de que esse sistema poderia realmente neutralizar o Covid19. Aliás, várias características do novo vírus ainda são desconhecidas. Todavia, em todo caso, o comprador teria na garagem um dos sedãs mais luxuosos e sofisticados do mundo. E equipado com um ótimo sistema de ar-condicionado.

7. Superambulâncias de Tóquio

Superambulância pode ser extremamente útil contra o coronavírus (Twitter | Reprodução)

Com os extensores, interior dispõe de oito leitos (Wikipedia | Reprodução)

Já que é para radicalizar no carro contra o coronavírus, que tal adquirir logo uma das superambulâncias como as utilizadas em Tóquio? Elas são montadas em chassis de caminhões para funcionarem como hospitais móveis. Assim, têm toda a aparelhagem necessária para emergências, o que inclui respiradores. E, graças às laterais que podem ser expandidas quando o veículo está estacionado, oito pessoas podem ser atendidas simultaneamente.

As superambulâncias existem de verdade: o objetivo delas é atender vítimas de grandes desastres, como atentados terroristas. Porém, tudo indica que elas podem ser usadas, se necessário, contra a pandemia. Entre os veículos deste listão, esses aqui são os únicos que parecem ter utilidade real na luta contra o Covid19.

Acompanhe o AutoPapo também no YouTube!

O post Coronavírus: listamos 7 carros para sobreviver ao apocalipse da pandemia apareceu primeiro em AutoPapo.

https://autopapo.com.br/noticia/coronavirus-7-carros-apocalipse-pandemia/ encontrado originalmente em https://autopapo.com.br

300+ TOP FIREBIRD Interview Questions and Answers

Firebird Interview Questions for freshers experienced :-

1. Can I Concurrently Access A Firebird Database With Embedded And With Regular Server? If you mean it’s one database and two applications then: NO If you mean it’s two databases and one application then: YES 2. How To Activate All Indexes In Firebird? If you run Firebird 1.x which doesn’t have EXECUTE BLOCK, you can run the following query: select 'ALTER INDEX ‘||rdb$index_name|| ‘ ACTIVE:’ from rdb$indices where rdb$system_flag is not null and rdbSsystem_flag 0 3. How To Add Remove, Modify Users Using Sql? It is currently not possible. You need to use service API. Access to it is provided by most connectivity libraries (except ODBC). 4. How To Change Database Dialect? While you could simply change a flag in database file it isn’t recommended as there’s much more to it. Different dialects have different ways of handling numeric and date operations, which affects all object that are compiled into BLR (stored procedures, triggers, views, computed fields, etc.) Fixing all that on-the-fly would be very hard, so the recommended way is to create a new database and copy the data. You can easily extract the existing database structure using isql and then copy the data using some of the tools. 5. How To Configure Events With Firewall? If firewall is on client, you don’t have to do anything special. If firewall is on the server, you need to set RemoteAuxPort setting in Firebird,conf file and forward traffic from firewall to that port. 6. How Do Convert Or Display The Date Or Time As String? Simply use CAST to appropriate CHAR or VARCHAR data type (big enough). Example: CREATE TABLE t1 (t time, d date. ts timestamp); INSERT INTO t1 (t,d,ts) VALUES (‘14:59:23’, ‘2007-12-3 1’, ‘2007-12-31 14:59’); SELECT CAST(t as varchar(13)), CAST(d as varchar( 10)), CAST(ts as varchar(24)) FROM t1; Firebird would output times in HH:MM:SS.mmmm format (hours, minutes, seconds, milliseconds), and dates in YYYY-MM-DD (year, month, day) format. if you wish a different formatting you can either use SUBSTRING to extract the info from char column, or use EXTRACT to buld a different string: SELECT extract(day from d)||’.’||extract(month from d)||’.‘||extract(year from d) FROMt1; 7. How To Create A Database From My Program? Firebird doesn’t provide a way to create database using SQL You need to either use the Services API, or external tool. As API for database creation is often not available in libraries, you can call Firebird’s isql tool to do it for you. Let’s first do it manually. Run the isql, and then type: SQL>CREATE DATAB ASE ‘C :\dbases\database. Rib’ user ‘SYSDBA’ password ‘masterkey’; That’s it, Database is created. Type exit; to leave isql. To do it from program, you can either feed the text to execute to isql via stdin, or create a small file (ex. create sql) containing the CREATE DATABASE statement and then invoke isql with -i option: isql -i create.sql 8. How To Deactivate Triggers? You can use these SQL commands: ALTER TRIGGER trigger_name INACTIVE; ALTER TRIGGER trigger_name ACTIVE; Most tools have options to activate and deactivate all triggers for a table. For example, in Flame Robin, open the properties screen for a table, click on Triggers at top and then Activate or Deactivate All Triggers options at the bottom of the page. 9. How To Debug Stored Procedures? Firebird still doesn’t offer hooks for stored procedure debugging yet. Here are some common workarounds: You can log values of your variables and trace the execution via external tables. External tables are not a subject of transaction control, so the trace won’t be lost if transaction is rolled back. You can turn your non-selectable stored procedure into selectable and run it with ‘SELECT * FROM’ instead of ’EXECUTE PROCEDURE’ in order to trace the execution. Just make sure you fill in the variables and call SUSPEND often. It’s a common practice to replace regular variables with output columns of the same name - so that less code needs to be changed. Some commercial tools like IBExpert or Database Workbench parse the stored procedure body and execute statements one by one giving you the emulation of stored procedure run. While it does work properly most of the time, please note that the behaviour you might see in those tools might not be exactly the same as one seen with actual Firebird stored procedure - especially if you have uninitialized variables or other events where behavior is undefined. Make sure you file the bug reports to tool makers and not to Firebird development team if you run such ‘stored procedure debuggers’. Since Firebird 2.0 you can also use EXECUTE BLOCK to simulate stored procedures. EXECUTE BLOCK does not support input parameters, so you need to convert all of those to local variables (with DECLARE VARIABLE) 10. How To Detect Applications And Users That Hold Transactions Open Too Long? To do this, you need Firebird 2.1 or a higher version. First, run gstat tool (from your Firebird installation’s bin directory), and you’ll get an output like this: gstat -h faqs.gdb Database “faqs.gdb” Database header page information: Flags 0 Checksum 12345 Generation 919 Page size 4096 ODS version 11 .1 Oldest transaction 812 Oldest active 813 Oldest snapshot 813 Next transaction 814 Now, connect to that database and query the MON$TRANSACTTONS table to get the MON$ATTACHMENT_ID for that transaction, and then query the MONSATTACHMENTS table to get the user name, application name, 1P address and even PID on the client machine. We are looking for the oldest active transaction, so in this case, a query would look like: SELECT ma.* FROM MON$ATTACHMENTS ma join MON$TRANSACTIONS mt on ma.MON$ATTACHMENT ID - mt.MONSATTACHMENTID where mt.MONSTRANSACTION_ID = 813,

FIREBIRD Interview Questions 11. How To Detect The Server Version? You can get this via Firebird Service API. It does not work for Firebird Classic 1.0, so if you don’t get an answer you’ll know it’s Firebird Classic 1.0 or InterBase Classic 6.0. Otherwise it returns a string like this: LI-V2.0.0. 12748 Firebird 2.0 or... LI-V1 .5.3.4870 Firebird 1.5 The use of API depends on programming language and connectivity library you use. Some might even not provide it. Those that do, call the isc_info_svc_server_version API. If you use Firebird 2.1, you can also retrieve the engine version from a global context variable, like this: SELECT rdbSget_context(’SYSTEM’, ‘ENGINE VERSION’) from rdb$database ; 12. How To Determine Who Is And Change The Owner Of Database? Use the following query: SELECT DISTINCT RDB$OWNER_NAME AS DATABASE_OWNER FROM RDB$RELATIONS WHERE (RDB$SYSTEM_FLAG = 1 ); 13. How To Open The Database In Exclusive Mode? You need to shutdown the database (using gfix or some other tool). Firebird 2.0 offers various shutdown modes (single-user, single-connection, multiple connection, etc.). 14. How To Move A Multi-file Database? You are probably used to having a single-file database which you can move around as much as you want. But, your database has grown too big and now you need a multi-file database. Paths to the secondary files are absolute and stored in the header page of the first database file. If you need to move those files, it is recommended that you backup the database and restore at new location. However, if you really need to copy them around, you can use freeware tool G1ink by Ivan Prenosil: 15. How To Monitor Firebird Server Activity? Firebird 2.1 introduces server-side monitoring via special system tables. This way you can monitor your server directly from SQL Those system tables all have prefix MON$ in their name. To use them, you need to make sure your database file is created with Firebird 2.1 or higher (ODS version 11.1). If you have a database that is created with earlier versions, you need to do backup and subsequent restore with Firebird 2.1 to have those tables. 16. How To Migrate Paradox, Dbase Or Foxpro Database To Firebird? The easiest way is to download the freeware IBDataPump by CleverComponents. It will extract the metadata from Paradox/dBase/FoxPro database, create all the tables in a Firebird database and then copy all the data. You’ll probably have a ready-to-go Firebird database in less than one hour. 17. How To Load A File Into Database Column? While some other database systems might have an SQL function for this, with Firebird you need an application. Datatype that holds binary files is called BLOB, and you should use sub_type zero, as sub_type one is for text-only data. Let’s create a table to hold the file. We’ll have a filename column and a blob column containing the file itself: CREATE TABLE t1 ( file_name VARCHAR(200), file_data BLOB SUB_TYPE 0 ); The blobs are loaded via parametrized query: INSERT INTO t1 (file_name, file_data) VALUES (?,? ); 18. How To Extract Metadata For The Entire Database? It’s quite simple, use isql with -x or -a options. Please be careful and test if it works. Some commercial administration tools like to play with system tables directly, and isql isn’t always able to understand their hacks You can also extract DDL with FlameRobin Open the properties page for the database and select DDL option at the top. 19. How To Export Data From Database And Import Into Another? If your databases are on-line, i.e. visible to each other via network, then you can use some data pump tool like freeware lB Pump or some of advanced commercial administration tools which have this option integrated. If your databases are offline, you should first export the data and then import it on the other end. Most admin. tools can do export to CVS, XML or INSERT statements. If efficiency is important, or your have data with BLOB column, you can use the open source FBExport tool. If you are looking for a way to easily import CS\’ or XML data into Firebird, take a look at XML Wizard tool. You can also use it to import data from Microsoft Excel or OpenOffice by saving the sheet to .csv format and then importing via XML Wizard 20. How To Drop All Foreign Keys In Database? Deleting all foreign keys can be done by querying the system tables and droping them one by one. If you use Firebird 2 or higher, it can be done with a single SQL statement: set term!!; EXECUTE BLOCK RETURNS (stmt VARCHAR(1 000)) AS BEGIN FOR select ‘alter table ‘||r.rdb$relation_name ||’ drop constraint’|| ‘ r. rdb$constraint_name||’;’ from rdb$relation _constraints r where (r. rdb$constraint_type=’FORETGN KEY’) into :stmt DO begin suspend; execute statement :stmt; end END!! set term; !! If you use Firebird i .x, you can run the following query to get statements to execute and then copy/paste the result and execute: select ‘ALTER TABLE’ ||r. rdb$relat ion_name ||’DROP CONSTRAINT’|| r. rdb$constraint_name||’:’ from rdb$relation_constraints r where (r.rdb$constraint_type=’FORETGN KEY’) 21. How To Do Replication Of Firebird Databases? Firebird does not offer replication out-of-the-box, you need to use some 3rd party tools. Those external tools add specific triggers that log all the changes in database and replicate to other databases. 22. How To Disconnect The User Connection? Currently there is no easy way of doing it. You can bring database to some of shutdown modes, but it affects all users. If you use Classic you can (with some effort) find the users process by detecting the IP address and open database files of that process and simply kill that process. With Super Server it is not possible as the connection is run in a thread of’ multithreaded SuperServer process. There are plans for future versions of Firebird to address this. For example. version 2.1 introduces ability to cancel running queries (by deleting the relevant records from MON$STATEMENTS table). 23. How To Present Firebird.log File From Filling Up The Disk Partition? Here are some tips: a) create a scheduled task or cron job that will truncate or rotate the log file. By rotation, we mean renaming the flies in such way that you always have a number of previous logs available. Example. delete flrebird.log.5 rename firebird. iog.4 firebird. log. 5 rename flrebird.iog.3 firebird.log.4 rename flrebird.log.2 firebird.log.3 rename firebird.log.l f’irebird.iog,2 rename firebird.iog firebird.log.1 This way you’ll always have last five logs available, and those too old get deleted. You can also use zip, rar, bzip2 or some other packer to compress the old log files. Since they are plain text, they compress very well. b) redirect logging to void. For example, on Linux, you can do it by creating a symlink to /dev/null instead of the regular log file: # cd /opt/firebird # rm -f firebird log in -s /dev/null firebird.log 24. How To Pump The Data From One Database To Another? Many recommend IB Pump or IB Data Pump, but the problem is when you have complex relations between tables. In such cases, it is better to use tool like FB Copy which sorts the tables by dependencies (foreign keys, check constraints) into correct order 25. How To Recreate The Index On A Firebird Table? Recreating the index: ALTER INDEX indexName INACTIVE. ALTER INDEX indexName ACT1VE 26. How To Reorder The Table Columns (fields)? While the order should not matter to applications (you should always use explicit column names in queries), perhaps it’s easier for you when you work with tables in database administration tools. You can move a column to different location using the following SQL statement: ALTER TABLE table_name ALTER field name POSITION new_position: Positions are numbered from one. If you wish to exchange two fields, make sure you run the statement for both of them. It’s easy to run tools like Flame Robin to do this (Reorder Fields option at table’s properties screen). 27. How To Repair A Corrupt Firebird Database? Here’s a short step-by-step walkthrough. disconnect users and disable incoming connections to the database make a copy of database file (or two copies) and work on that use GFIX with -v option to validate the database file use GF1X with -v and -f to do full validation If problem is not too serious, you can try to backup the broken db and restore under a new name: use GF1X -mend to prepare corrupt database for backup use GBAK -b -g to backup the database. -g disables garbage collection use GBAK -c to restore backup to a new database. If you succeed, you have fixed the problem and have a functional database. If not, you can try to create an empty database with the same structure and pump the data to it. One of the reasons why backup or restore can fail is if some broken database triggers exist, and prevent connection to the database. For example, a database trigger might use some table which has a broken index, etc. To work around this, connect to database with isql tool using -nodbtriggers option and then disable those triggers. You can enable them later when you fix other problems and get a working database again. 28. How To Select A Random Record From A Table? There is no such feature in Firebird, but you can use some tricks. The following example requires that you have a unique integer column (primary key is usually used): SELECT.. field_list... FROM table t1 WHERE conditions ORDER BY (t1 .int_col + seed)*4294967291 -((tl .int_col + seed)*4294967291/49157)*49157; If you just need one random record, limit the result set using FIRST or ROWS clause. This query will give consistent records for the same seed. If you wish to be completely random, you need to change the seed. You could use the value of int_col from previous run, or simply fetch a new value from a generator (just make sure the same value for seed is used in both places in expression). 29. How To Specify Transaction Or Query Timeout? In order to keep the server low reasonable, you might want to limit the time a single query can consume. Firebird does not support this directly yet (there are plans for Firebird 3.0). However, you could periodically query the monitoring tables to detect and cancel long running queries. You can do: SELECT * FROM MON$STATEMENTS: Look for those having MON$STATE set to 1. 30. What Is A Staging Area? Do We Need It? What Is The Purpose Of A Staging Area? Data staging is actually a collection of processes used to prepare source system data for loading a data warehouse. Staging includes the following steps: Source data extraction, Data transformation (restructuring), Data transformation (data cleansing, value transformations), Surrogate key assignments. 31. How to select a random record from a table? There is no such feature in Firebird, but you can use some tricks. The following example requires that you have a unique integer column (primary key is usually used): SELECT ...field_list... FROM table t1 WHERE conditions ORDER BY (t1.int_col + seed)*4294967291-((t1.int_col + seed)*4294967291/49157)*49157; If you just need one random record, limit the result set using FIRST or ROWS clause. This query will give consistent records for the same seed. If you wish to be completely random, you need to change the seed. You could use the value of int_col from previous run, or simply fetch a new value from a generator (just make sure the same value for seed is used in both places in expression). 32. How to specify transaction or query timeout? In order to keep the server low reasonable, you might want to limit the time a single query can consume. Firebird does not support this directly yet (there are plans for Firebird 3.0). However, you could periodically query the monitoring tables (Firebird 2.1 and above) to detect and cancel long running queries. You can do: SELECT * FROM MON$STATEMENTS; Look for those having MON$STATE set to 1. Please note that your database needs to be at least ODS 11.1, i.e. created with Firebird 2.1 or above. Older databases won't show you these tables even if you use Firebird 2.1 to access them. To learn more about ODS and how to retrieve it. 33. How to stop SuperServer service on Linux using only Firebird tools? The server is started and stopped by 'fbmgr' executable from 'bin' directory of your Firebird installation. It is called 'ibmgr' in Firebird 1.0. To start the server type: /opt/firebird/bin/fbmgr -start To start the server with Guardian (Guardian watches the server and restarts it if it crashes) type: /opt/firebird/bin/fbmgr -start -forever To stop a running server, type: /opt/firebird/bin/fbmgr -shut -user SYSDBA -pass ***** To force a shutdown, type: /opt/firebird/bin/fbmgr -shut -force -user SYSDBA -pass ***** If you use Firebird 2 or higher, you can also use the regular 'kill' command to shutdown the server, as it handles the signals properly. Make sure you first kill the guardian and then the server (otherwise guardian would restart the server). 34. How to tell Firebird to only accept conections from XYZ host or network? This isn't really a thing you should be configuring in Firebird. There is a RemoteBindAddress setting in firebird.conf which configures on which interfaces/addresses the Firebird listens but that's all. You should really use your system's firewall to set this up. Beside firewall, if you use Classic on Linux, you can use xinetd or inetd access control files /etc/hosts.allow and /etc/hosts.deny. With xinetd you can also edit the xinetd configuration file for Firebird service, which is in /etc/xinetd.d/firebird and add a line like this: "only_from = 192.168.0.0/24" 35. How to use events with ZeBeDee, SSH or stunnel? You have to use SuperServer, set up RemoteAuxPort setting in firebird.conf and create two tunnels (one for data, other for events). 36. How to write UDF s in Delphi? It's quite simple, the only thing you need to remember is that you must always use ib_util_malloc() to allocate memory if your UDF returns string result. The UDF must be declared as FREE_IT, so that Firebird releases the memory after it reads the string. To use ib_util_malloc(), you need to import it from ib_util.dll into your program - and make sure you use it instead of regular memory alocating functions. Here's a simple example of Delphi UDF: function ib_util_malloc(l: integer): pointer; cdecl; external 'ib_util.dll'; function ChangeMyString(const p: PChar): PChar; cdecl; var s: string; begin s := DoSomething(string(p)); Result := ib_util_malloc(Length(s) + 1); StrPCopy(Result, s); end; Declaration in Firebird: DECLARE EXTERNAL FUNCTION ChangeMyString CString(255) RETURNS CString(255) FREE_IT ENTRY_POINT 'ChangeMyString' MODULE_NAME '......' 37. Is it possible to determine clients IP address? To get it from SQL, you need to use Firebird 2.0 (own address), or Firebird 2.1 (anyone's): If you use Firebird 2.0 or higher, use the GET_RDB$Context function with ('SYSTEM', 'CLIENT_ADDRESS') parameters. If you use Firebird 2.1 or higher, you can get address of any client by selecting from the monitoring tables. With Firebird 1.x you can try to get the information from TCP/IP stack, using netstat or lsof commands from the command-prompt. Just search for Firebird's port (3050 or gds_db). 38. Is there a way to automate SQL execution from the command-line, batch job or shell script? Yes. You can use isql for this. It is located in the 'bin' directory of your Firebird installation. If you wish to try it interactively, run isql and then type: isql localhost:my_database -user sysdba -pass ****** SQL> input my_script.sql; SQL> commit; SQL> To run it from a batch (.bat) file or a shell script, use -i switch: isql -i my_script.sql localhost:my_database -user sysdba -pass ****** If you have some DML statements in your script, make sure you put the COMMIT command at the end of the file. Also, make sure the file ends with a newline, as isql executes the commands on the line only after it gets the newline character. 39. Is there a way to detect whether fbclient.dll or fbembed.dll is loaded? There are some ways to detect it: check the size of DLL file if you are using different versions of Firebird (for example 1.5.4 and 2.0.1, you can query the server version via Services API) You should understand that fbembed can be used as a regular Firebird client. Checking whether embedded or fbclient is loaded for licensing or similar needs is really not useful. You could use the connection string as guide, but super server can establish direct local connections without localhost prefix. If you combine all this information, you could get some conclusions: if DLL size matches fbembed and connection string doesn't have hostname, you are using embedded if DLL size matches fbembed and connection string does have hostname, you are using either super server or classic if DDL size matches fbclient and connection string doesn't have hostname, you are using super server via local connection (IPC, XNET) if DLL size matches fbclient and connection string does have hostname, you are using either super server or classic 40. Is there an example how to configure ExternalFileAccess setting in firebird.conf? Firebird's config file (firebird.conf) does have descriptions inside that explain everything, but sometimes they are confusing and hard to understand what should you do exactly if you don't have examples. One of such settings is ExternalFileAccess. Some people are even tempted to put Full as it is much easier than trying to guess what's the correct format. Here are the basic settings ('None' to disallow external tables and 'Full' to allow them anywhere) which you probably understood yourself: ExternalFileAccess = None ExternalFileAccess = Full And here are those tricky Restrict settings: ExternalFileAccess = Restrict C:somedirectory For multiple directories, use something like this: ExternalFileAccess = Restrict C:somedirectory;C:someotherdirectory For Linux users: ExternalFileAccess = Restrict /some/directory 41. Is there an example how to configure UdfAccess setting in firebird.conf? Well, there's one right there in the firebird.conf, but perhaps it isn't obvious enough. Here are the basic settings ('None' to disallow UDFs completely and 'Full' to allow them anywhere) which you probably understood yourself: UdfAccess = None UdfAccess = Full And here is that tricky Restrict setting: UdfAccess = Restrict C:somedirectory For multiple directories, use something like this: UdfAccess = Restrict C:somedirectory;C:someotherdirectory For Linux users: UdfAccess = Restrict /some/directory In the default setting 'Restrict UDF', 'UDF' is a directory relative to root directory of Firebird installation. 42. Is there some bulk load or other way to import a lot of data fast? Currently there is only one way to quickly load a lot of data into database. That is by using external tables. You should read the manual for details, but here's a short explanation. You create a binary or textual file using the external table format and then hook it up in the database using a statement like this: CREATE TABLE ext1 EXTERNAL 'c:myfile.txt' ( field1 char(20), field2 smallint ); To do quick import into regular table, do something like this: INSERT INTO realtable1 (field1, field2) SELECT field1, field2 FROM ext1; This insert would still check constraints, foreign keys, fire triggers and build indexes. If you can, it is wise to deactivate indexes and triggers while loading and activate them when done. Make sure you drop the external table when done, in order to release the lock on the file. The main problem with external tables is handling of NULLs and BLOBs. If you need to deal with those, you're better off using some tool like FBExport. However, please note that external tables are much faster. 43. What is the best way to determine whether Firebird server is running? If you want to do it from an application, a simple try to connect should suffice. Otherwise you have various options: a) check if firebird server is in the list of running programs (use task manager on Windows, or 'ps ax' command on Linux). Please note that Classic won't be running until there is a connection established. b) check whether the port 3050 is open on the machine. First, you can check with netstat command, and if it is open, you can test whether it accepts connections by telnet-ing to the port. Just type: telnet 3050 Example: telnet localhost 3050 If you use Linux, you can also check the open port with 'lsof' command. It outputs a lot, so you might want to 'grep' for 3050 or gds_db strings: # lsof | grep gds_db # lsof | grep 3050 c) if all of this fails, perhaps you should check whether the remote server is reachable at all. You can use 'ping' command: ping Example: ping 192.168.0.22 Please note that ping can still give you 'host unreachable' message even if host is up. This is because the firewall software can drop the ICMP (ping) packets (it's done to prevent some viruses from spreading, or network scans). 44. What Is The Metadata Extension? Informatica allows end users and partners to extend the metadata stored in the repository by associating information with individual objects in the repository. For example, when you create a mapping, you can store your contact information with the mapping. You associate information with repository metadata using metadata extensions. Informatica Client applications can contain the following types of metadata extensions: Vendor-defined. Third-party application vendors create vendor-defined metadata extensions. You can view and change the values of vendor-defined metadata extensions, but you cannot create, delete, or redefine them. User-defined. You create user-defined metadata extensions using PowerCenter/PowerMart. You can create, edit, delete, and view user-defined metadata extensions. You can also change the values of user-defined extensions. 45. How Can We Use Mapping Variables In Informatica? Where Do We Use Them? Yes. we can use mapping variable in Informatica. The Informatica server saves the value of mapping variable to the repository at the end of session run and uses that value next time we run the session. 46. What Is Etl Process ?how Many Steps Etl Contains Explain With Example? ETL is extraction, transforming, loading process, you will extract data from the source and apply the business role on it then you will load it in the target the steps are : define the source(create the odbc and the connection to the source DB) define the target (create the odbc and the connection to the target DB) create the mapping ( you will apply the business role here by adding transformations , and define how the data flow will go from the source to the target ) create the session (its a set of instruction that run the mapping ) create the work flow (instruction that run the session) 47. Give Some Popular Tools? Popular Tools: IBM Web Sphere Information Integration (Accentual DataStage) Ab Initio Informatica Talend 48. Give Some Etl Tool Functionalities? While the selection of a database and a hardware platform is a must, the selection of an ETL tool is highly recommended, but it's not a must. When you evaluate ETL tools, it pays to look for the following characteristics: Functional capability: This includes both the 'transformation' piece and the 'cleansing' piece. In general, the typical ETL tools are either geared towards having strong transformation capabilities or having strong cleansing capabilities, but they are seldom very strong in both. As a result, if you know your data is going to be dirty coming in, make sure your ETL tool has strong cleansing capabilities. If you know there are going to be a lot of different data transformations, it then makes sense to pick a tool that is strong in transformation. Ability to read directly from your data source: For each organization, there is a different set of data sources. Make sure the ETL tool you select can connect directly to your source data. Metadata support: The ETL tool plays a key role in your metadata because it maps the source data to the destination, which is an important piece of the metadata. In fact, some organizations have come to rely on the documentation of their ETL tool as their metadata source. As a result, it is very important to select an ETL tool that works with your overall metadata strategy. 49. How Can I Edit The Xml Target, Are There Anyways Apart From The Editing The Xsd File. Can I Directly Edit The Xml Directly In Informatica Designer? No you cannot edit it from Informatica designer. But still you can change the precession of the ports if xml source is imported from DTD file. 50. Why does reading require write privileges on database file? In order to run the SELECT statmement, it still needs to start a transaction. If you wish to build a read-only database to place on some read-only media like CD or DVD ROM, you can do it with: gfix -mode read_only database.fdb ...or within your favorite administration tool. It is also available via ServicesAPI, so you may do it from your application as well. Please note that you can only make this change while preparing the database, because the read-only flag needs to be written in the database file. When the database becomes read-only, the only thing you can write to is the read_only flag (to reset it back to read-write). 51. Where Do We Use Connected And Un Connected Lookups? If return port only one then we can go for unconnected. More than one return port is not possible with Unconnected. If more than one return port then go for Connected. 52. What Are The Various Tools? - Name A Few. Abinitio DataStage Informatica Cognos Decision Stream Oracle Warehouse Builder Business Objects XI (Extreme Insight) SAP Business Warehouse SAS Enterprise ETL Server 53. What Are The Various Test Procedures Used To Check Whether The Data Is Loaded In The Backend, Performance Of The Mapping, And Quality Of The Data Loaded In Informatica? The best procedure to take a help of debugger where we monitor each and every process of mappings and how data is loading based on conditions breaks. 54. What Is The Difference Between Joiner And Lookup? joiner is used to join two or more tables to retrieve data from tables(just like joins in sql). Look up is used to check and compare source table and target table .(just like correlated sub-query in sql). 55. If A Flat File Contains 1000 Records How Can I Get First And Last Records Only? By using Aggregator transformation with first and last functions we can get first and last record. 56. How Do You Calculate Fact Table Granularity? Granularity, is the level of detail in which the fact table is describing, for example if we are making time analysis so the granularity maybe day based - month based or year based. 57. What Are The Different Versions Of Informatica? Here are some popular versions of Informatica. Informatica Powercenter 4.1, Informatica Powercenter 5.1, Powercenter Informatica 6.1.2, Informatica Powercenter 7.1.2, Informatica Powercenter 8.1, Informatica Powercenter 8.5, Informatica Powercenter 8.6. 58. Techniques Of Error Handling - Ignore , Rejecting Bad Records To A Flat File , Loading The Records And Reviewing Them (default Values)? Rejection of records either at the database due to constraint key violation or the informatica server when writing data into target table. These rejected records we can find in the bad files folder where a reject file will be created for a session. We can check why a record has been rejected. And this bad file contains first column a row indicator and second column a column indicator. These row indicators are of four types D-valid data, O-overflowed data, N-null data, T- Truncated data, And depending on these indicators we can changes to load data successfully to target. 59. What Is The Difference Between Power Center & Power Mart? PowerCenter - ability to organize repositories into a data mart domain and share metadata across repositories. PowerMart - only local repository can be created. 60. What Are Snapshots? What Are Materialized Views & Where Do We Use Them? What Is A Materialized View Log? Snapshots are read-only copies of a master table located on a remote node which is periodically refreshed to reflect changes made to the master table. Snapshots are mirror or replicas of tables. Views are built using the columns from one or more tables. The Single Table View can be updated but the view with multi table cannot be updated. A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible. Materialized view A pre-computed table comprising aggregated or joined data from fact and possibly dimension tables. Also known as a summary or aggregate table. 61. What Is Virtual Data Wearhousing? A virtual data warehouse provides a collective view of the completed data. It can be considered as a logical data model of the containing metadata. 62. What Is Active Data Wearhousing? An active data warehouse represents a single state of the business. It considers the analytic perspectives of customers and suppliers. It helps to deliver the updated data through reports. 63. What Is Data Modeling And Data Mining? Data Modeling is a technique used to define and analyze the requirements of data that supports organization’s business process. In simple terms, it is used for the analysis of data objects in order to identify the relationships among these data objects in any business. Data Mining is a technique used to analyze datasets to derive useful insights/information. It is mainly used in retail, consumer goods, telecommunication and financial organizations that have a strong consumer orientation in order to determine the impact on sales, customer satisfaction and profitability. 64. What Are Critical Success Factors? Key areas of activity in which favorable results are necessary for a company to obtain its goal. There are four basic types of CSFs which are: Industry CSFs Strategy CSFs Environmental CSFs Temporal CSFs 65. What Is Data Cube Technology Used For? Data cubes are commonly used for easy interpretation of data. It is used to represent data along with dimensions as some measures of business needs. Each dimension of the cube represents some attribute of the database. E.g profit per day, month or year. 66. What Is Data Cleaning? Data cleaning is also known as data scrubbing. Data cleaning is a process which ensures the set of data is correct and accurate. Data accuracy and consistency, data integration is checked during data cleaning. Data cleaning can be applied for a set of records or multiple sets of data which need to be merged. 67. Explain How To Mine An Olap Cube? An extension of data mining can be used for slicing the data the source cube in discovered data mining. The case table is dimensioned at the time of mining a cube. 68. What Are Different Stages Of Data Mining? A stage of data mining is a logical process for searching large amount information for finding important data. Stage 1: Exploration: One will want to explore and prepare data. The goal of the exploration stage is to find important variables and determine their nature. Stage 2: pattern identification: Searching for patterns and choosing the one which allows making best prediction, is the primary action in this stage. Stage 3: Deployment stage: Until consistent pattern is found in stage 2, which is highly predictive, this stage cannot be reached. The pattern found in stage 2, can be applied for the purpose to see whether the desired outcome is achieved or not. 69. What Are The Different Problems That Data Mining Can Slove? Data mining can be used in a variety of fields/industries like marketing of products and services, AI, government intelligence. The US FBI uses data mining for screening security and intelligence for identifying illegal and incriminating e-information distributed over internet. 70. What Is Data Purging? Deleting data from data warehouse is known as data purging. Usually junk data like rows with null values or spaces are cleaned up. Data purging is the process of cleaning this kind of junk values. 71. What Is Bus Schema? A BUS schema is to identify the common dimensions across business processes, like identifying conforming dimensions. It has conformed dimension and standardized definition of facts. 72. Define Non-additive Facts? Non additive facts are facts that cannot be summed up for any dimensions present in fact table. These columns cannot be added for producing any results. 73. What Is Conformed Fact? What Are Conformed Dimensions Used For? Conformed fact in a warehouse allows itself to have same name in separate tables. They can be compared and combined mathematically. Conformed dimensions can be used across multiple data marts. They have a static structure. Any dimension table that is used by multiple fact tables can be conformed dimensions. 74. What Is A Three Tier Data Warehouse? A data warehouse can be thought of as a three-tier system in which a middle system provides usable data in a secure way to end users. On either side of this middle system are the end users and the back-end data stores. 75. What Is The Difference Between Informatica 7.0&8.0? The only difference b/w informatica 7 & 8 is... 8 is a SOA (Service Oriented Architecture) whereas 7 is not. SOA in informatica is handled through different grid designed in server. 76. What Is Latest Version Of Power Center / Power Mart? The Latest Version is 7.2 77. What Are The Modules In Power Mart? PowerMart Designer Server Server Manager Repository Repository Manager 78. What Are Active Transformation / Passive Transformations? Active transformation can change the number of rows that pass through it. (Decrease or increase rows) Passive transformation cannot change the number of rows that pass through it. 79. What Are The Different Lookup Methods Used In Informatica? Connected lookup: Connected lookup will receive input from the pipeline and sends output to the pipeline and can return any number of values it does not contain return port. Unconnected lookup: Unconnected lookup can return only one column it contain return port. 80. How Do We Call Shell Scripts From Informatica? Specify the Full path of the Shell script the "Post session properties of session/workflow". 81. What Is Informatica Metadata And Where Is It Stored? Informatica Metadata is data about data which stores in Informatica repositories. 82. What Is A Mapping, Session, Worklet, Workflow, Mapplet? A mapping represents dataflow from sources to targets. A mapplet creates or configures a set of transformations. A workflow is a set of instructions that tell the Informatica server how to execute the tasks. A worklet is an object that represents a set of tasks. A session is a set of instructions that describe how and when to move data from sources to targets. 83. What Are Parameter Files? Where Do We Use Them? Parameter file defines the value for parameter and variable used in a workflow, worklet or session. 84. Can We Override A Native Sql Query Within Informatica? Where Do We Do It? How Do We Do It? Yes, we can override a native sql query in source qualifier and lookup transformation. In lookup transformation we can find "Sql override" in lookup properties. By using this option we can do this. 85. Can We Use Procedural Logic Inside Infromatica? If Yes How , If No How Can We Use External Procedural Logic In Informatica? Yes, you can use advanced external transformation, You can use c++ language on unix and c++, vb vc++ on windows server. 86. Do We Need An Etl Tool? When Do We Go For The Tools In The Market? ETL Tool: It is used to Extract(E) data from multiple source systems(like RDBMS, Flat files, Mainframes, SAP, XML etc) transform(T) then based on Business requirements and Load(L) in target locations.(like tables, files etc). Need of ETL Tool: An ETL tool is typically required when data scattered across different systems.(like RDBMS, Flat files, Mainframes, SAP, XML etc). 87. How To Determine What Records To Extract? When addressing a table some dimension key must reflect the need for a record to get extracted. Mostly it will be from time dimension (e.g. date >= 1st of current month) or a transaction flag (e.g. Order Invoiced Stat). Foolproof would be adding an archive flag to record which gets reset when record changes. 88. What Is Full Load & Incremental Or Refresh Load? Full Load: completely erasing the contents of one or more tables and reloading with fresh data. Incremental Load: applying ongoing changes to one or more tables based on a predefined schedule. 89. When Do We Analyze The Tables? How Do We Do It? The ANALYZE statement allows you to validate and compute statistics for an index, table, or cluster. These statistics are used by the cost-based optimizer when it calculates the most efficient plan for retrieval. In addition to its role in statement optimization, ANALYZE also helps in validating object structures and in managing space in your system. You can choose the following operations: COMPUTER, ESTIMATE, and DELETE. Early version of Oracle7 produced unpredictable results when the ESTIMATE operation was used. It is best to compute your statistics. EX: select OWNER, sum(decode(nvl(NUM_ROWS,9999), 9999,0,1)) analyzed, sum(decode(nvl(NUM_ROWS,9999), 9999,1,0)) not_analyzed, count(TABLE_NAME) total from dba_tables where OWNER not in ('SYS', 'SYSTEM') group by OWNER 90. Compare Etl & Manual Development? These are some differences b/w manual and ETL development. ETL The process of extracting data from multiple sources.(ex. flatfiles, XML, COBOL, SAP etc) is more simpler with the help of tools. High and clear visibility of logic. Contains Meta data and changes can be done easily. Error handling, log summary and load progress makes life easier for developer and maintainer. Can handle Historic data very well. Manual Loading the data other than flat files and oracle table need more effort. complex and not so user friendly visibility of logic. No Meta data concept and changes needs more effort. need maximum effort from maintenance point of view. as data grows the processing time degrades. 91. What Is Real Time Data-wearhousing? In real time data-warehousing, the warehouse is updated every time the system performs a transaction. It reflects the real time business data. This means that when the query is fired in the warehouse, the state of the business at that time will be returned. 92. Explain The Use Lookup Tables And Aggregate Tables? An aggregate table contains summarized view of data. Lookup tables, using the primary key of the target, allow updating of records based on the lookup condition. 93. Define Slowly Changing Dimensions (scd)? SCD are dimensions whose data changes very slowly. eg: city or an employee. This dimension will change very slowly. The row of this data in the dimension can be either replaced completely without any track of old record OR a new row can be inserted, OR the change can be tracked. 94. What Is Cube Grouping? A transformer built set of similar cubes is known as cube grouping. They are generally used in creating smaller cubes that are based on the data in the level of dimension. 95. What Is Data Wearhousing? A data warehouse can be considered as a storage area where relevant data is stored irrespective of the source. Data warehousing merges data from multiple sources into an easy and complete form. 96. Can Informatica Load Heterogeneous Targets From Heterogeneous Sources? No, In Informatica 5.2 and Yes, in Informatica 6.1 and later. FIREBIRD Questions and Answers pdf Download Read the full article

PySpa統合思念体です。 某チャットで、「今時のOSSのプロジェクト管理とかのベストプラクティスが書いてある本ないかな、陳腐化早そうだしないか」みたいな話題が投入されました。その中で、エキスパートPythonプログラミングとか、Pythonプロフェッショナルプログラミングとかは思い出して紹介したけど、他の人からはShip It、Manage It、Release It三部作とか、達人プログラマーとかも出てきました。 このあたりの源流を辿ると、そういえば今流行ってる開発の源流としてはエクストリームプログラミングの開発系のプラクティスの遺伝子を受け継いでいるのが多いよな、そういば当時から見て今ってどう変わっているのかな、という話題に。せっかくなので20年前を思い出しつつ、当時と今でどういう風に変わってきたのか適当にまとめてみます。 20年前の状況 XP白本こと、eXtreme Programming Explainedが出版されて、みんなでワイワイ読んだりメーリングリストでワイワイ議論していた時代です。 Java: JDK 1.2 (HotSpot VMが初搭載） C++: C++98だけど、Visual C++ 6.0とかEGCSが統合されたGCC 2.95が出てた頃。C++ Builder 3とか、Borland C++ 5とか。 Python: 1.5 Ruby: 1.3 ブラウザ: Internet Explorer 5, Netscape Navigator 4.5。IEの方が安定していたかな？ 各領域ごとの変化 プログラミング デザインパターン 当時はGoFのデザインパターンがイケイケで、これを学ぶことは言語によらない設計能力を身に着けた証、みたいな中２感がありました。 ただ、リファクタリングのようにデザインパターンに近づけるための方法論として提唱されているものがあったり、◯◯パターンみたいなのは大量に発生して、他の領域に応用しようみたいなムーブメントが起きたりはしましたが、このプログラミングのコアの領域ではNullObjectパターンとか、fluentインタフェース、mvvm、最近になってflux、クリーンアーキテクチャとかオニオンアーキテクチャあたりが言葉として普及したぐらいで、デザインパターンそのものが大きく発展することはなかったように思います。 その一方で最近もてはやされているのが関数型プログラミングのエッセンスを取り入れるやつですね。forEach/map/filter/reduceあたりを備えている言語は多いです。これらは実際の処理部分は関数として受け付けるので、必然的に高階関数です。これらを使ってリスト処理をするとかもですね。あとは、状態を持たずにimmutableに処理をする（値を変更するのではなく、変更前の世界から、変更後の世界を別途作る）とかも広まっています。一方、プログラミング言語のサポートがないとできない末尾再帰とか、パターンマッチはまだまだ、という感じです。 型 当時は完全に二択でした。 型を書く：コンパイルでチェックされるがだるいしコンパイル遅い 型を書かない：コンパイルなくてこまめに実行できるが、チェックが何もないのでテストを余計に書かないといけない 今は型推論がいろいろな言語に入ってきて、型を書く回数を減らしつつチェックもされるというのが増えて便利になりました。開発環境もだいぶ賢くなってPCの性能向上とともにリアルタイムチェックも実用的になりました。 JavaScriptもTypeScript/flowtypeで型を使うブーム。Pythonもmypy導入。Rubyも導入を検討 JavaもC++も、右辺で型が決まるならvar/autoで省略できるようになってだいぶ楽に エコシステム 昔は依存ライブラリを一つずつダウンロードしてmakeしてインストールするとか、そういう感じだった気がするけど、パッケージリポジトリからまとめてダウンロードして一括で入れたりも楽になりました。アップロードもしやすく自由になりました。まあコレ自体はCTAN（TeX用）がリリースされ、その後CPAN（Perl用）がそれを真似して・・・みたいな感じで言語によっては20年前にはすでにありましたが、それがだいぶ他の言語にも普及しました。 その中で少しみられたのが、言語を選ぶ→エコシステムを選ぶ→言語を選ぶに揺り戻しが、という流れですね。言語がはやる→ライブラリが充実する→そのライブラリを使いたいけどその言語使いたくないからそのエコシステムを使う言語が作られる→元の言語が釣られて発展する→元の言語に収斂されていく・・・的な。 Javaが流行ったらJVM言語としてGroovyとか、Jython、JRubyとかいろいろ出てきたけど、Java本体がいろいろ取り込んで強くなったりして結局Javaでいいじゃん、サンプルも多いし、みたいな雰囲気を感じます。Kotlinは別の政治的なところがあるのでおいといて。JavaScriptも、JSX(DeNAの)とかCoffeeScriptから、JavaScript (+TypeScript）に。Silverlightみたいなプログラミングの自由よりはstack overflow-bilityというか、コピペビリティが勝った？ アプリケーションの形態 昔はデスクトップが多かったです。ウェブも出始めていたけども、CGIが中心だったのと、J2EEがこれから出ていくぞ、というタイミング。LAMPスタック（Linux、Apache、MySQL、PHP）という言葉も聞かれました。 今はほぼウェブ＋モバイルですね。デスクトップは昔のものがしぶとく残っているぐらい。 ユニットテスト 各フレームワークの使い勝手はだいぶ良くなったように感じるが、基本的にはそこまで変わっていない。 ビヘイビア駆動開発の流れを受けたフレームワークは増えた。RSpecとかJS系とかで特に。 外部I/Oのライブラリが自らモック用のクラスを準備してくれたりとか、ライブラリの補助は増えている。 テストの基本の書き方は特に変化はないが、テーブルベーステストがGoとかPythonとかJavaScriptとかいろいろ広がっているのを感じる。 プロパティベーステストが次の流れに乗れるかどうか。 当時はt-wadaさんはDBの人というイメージで、まだテストの人というイメージではなかった。 受入テスト(E2Eテスト) デスクトップが主体だった。 昔は話題に上がるのはFitnesse(Java)ぐらい QtはFrogLogic社のツールとかは昔からあったきがするけどめちゃ高かった 構造的にGUIのメッセージ処理とかに食い込む機構だったのでフレームワークごとに固有のツール。 とはいえ、このあたりの取り組みが今のRPAにつながっている気がしないでもない 今はウェブとモバイル Seleniumから出発し、Appiumとかいろいろある。 モバイルは最初からこのあたりに取り組む人が増えてきた Chrome自身もHeadlessとかCDPとかいろいろ装備してプログラマブルに利用することができるように 継続的結合（CI） 当時はHudson(Jenkins)とかbuildout。金がある、スポンサーがいるところはオンプレでサーバーをたくさんならべて、Windows/Linux/FreeBSD/Solaris/HP-UXとか並列ビルドしてかっこよかった 最近はSaaSのサービスがいろいろ出てきて敷居がだいぶ下がりました。OSS開発サポート無料プランも出て来て、多くの人にとって普通に使える選択肢になりました。 各言語が提供するビルドツールとかもだいぶ使い勝手が良くなってきました。 Dockerコンテナも出てきてブームに。アプリケーション作るだけではなく、Dockerfileビルド時間短縮芸とか、イメージサイズ縮小eスポーツが流行っています。 大規模インフラ構築はopenStackで新たな市場ができあがり、K8sが今後は普及の兆しだけど、今も昔も、みんな難しい・・・と言っている。 コード共同所有 ここが一番大きく変わったところな気がします。 当時主流はCVS・VSS。 VSSはWindowsのフォルダ共有で運用できたので敷居は低かったし、Visual Studioの有料版にはバンドルされていたので、新規投資なしで使えた（はず） OSSでは、SourceForge.net(日本ではなくて）にアカウントがあって、CVSを扱うのがステータス。 この時点ではまだ流行っていなかったのがSVN。2002年リリースのTortiseSVNは使いやすいしわかりやすい。変更の多いバイナリを扱う場合だと未だにGitよりも良いこともある。 ブランチなにそれ？ 今はGit一強。 GitHubとかGitLabとかSaaSサービスが大きく普及し、気軽に使えるように。GitHub採用なる言葉も 社内でもGitHub Enterprise ServerとかGitLab Communityを運用する会社も増えた ブランチを使った運用、Pull Requestを使った運用とか。当たり前のようにフォークして、Pull Requestを出して、それがGitHub上でCIが走ってチェックされて、diffをわかりやすい画面で見てブラウザでマージ。 GoとかNode.jsとかGit上のパッケージを直接取得してくる言語とかも後押し MercurialとBazaarにはもう少し頑張って欲しかった。 あと、コード共同所有に範疇かわからないけど、docker-compose.ymlファイルで開発環境一発起動とか、開発環境情報の共同所有みたいなのもだいぶ便利に。VMWare、openStack、Docker、Ansibleとかいろいろな取り組みのおかげでかなり便利。インフラがクラウドになって、IaaCで環境もコードになったり、べき等とか言われるようになったり。このあたりの形式もだいぶ変わりました。 今、アジャイルのプラクティスが作られるならこのインフラ周りの話は絶対入りそう。 リファクタリング もちろん本来はテストを書いてからがんばって実行しましょうなんだけど、モリッとやってくれるIDEの機能もだいぶ便利に。 デザインパターンの議論があまり行われなくなって、それにともなって新しいムーブメントがなくて寂しいと感じる。 コーディング標準 昔はコーディング規約を決めて、各自頑張ってそれを守ろう、という感じでした。 Eclipseみたいな気の利いたツールがフォーマッターを内臓しはじめました 今やフォーマットは自動で修正すべき、みたいになってきている。便利なツールが増えた（go fmt/prettier/black etc) コード共同所有＋SaaSのリポジトリの普及で、diffを見てPRをマージみたいなのが主流になってきたり、余計なdiffを減らして見やすくするという必然性が高まったのかもしれません。 ドキュメント JavaDocとかDoxygenを一生懸命書いてHTMLやらWindowsヘルプを生成みたいな感じでした。 JavaDocの普及により、ソースコード内に決まった文法で書いてドキュメント生成は市民権を得ました。 ウェブサイトに公開する目的では今もあるが、ローカルはエディタがポップアップで出してくれるのが多くて、手元でビルドして使う人はあまりいないのでは？ 当時はWikiブームみたいなのが少しきていた。文法は増え続け、収束することはなかった。n種類あるWiki文法を統一させよう！という意欲的なCreoleという文法が出てきたけど、n+1種類になっただけであった。 みんなMarkdown書くようになった。方言は増え続け、収束させようと努力する人はいるものの、収束する雰囲気はない。 モデル駆動開発とか、CASEツールとかは当時は夢があったけど最近は話をしている人はいない。Rational Rose欲しかったんだよな。昔。 UML！！UML！！という感じもなくなった。 ロギング DEBUG/INFO/WARN/ERROR/FATALみたいなのは変わっていない ウェブサービスの入り口では全部ログを出しておけ、Hadoopで分析だ、みたいなのはソシャゲブーム前後でだいぶ流行った。今はBigQueryとか集約側はSaaSとかがいろいろ便利に。いわゆるビッグデータブーム。 syslogとかでローカルに→fluentdとかのログコレクターを使う方法が一般化→それはコンテナのサイドカーでやるからアプリは標準出力に出しておけ、みたいな寄り戻しが来ている雰囲気。 これとは別に、オブザーバビリティ（分散トレースとかメトリックスのモニタリング）は当時はなかったが、最近は少しずつ名前を聞くようになってきた（個人的にはCouchDB使って分散トレースはやっていたけども）。 ビッグデータは運用改善とかA/Bテストとかお金の匂いがする感じであったけど、オブザーバビリティは純粋に開発とか運用改善みたいな雰囲気。オブザーバビリティは今後の基礎教養になりそう。 データベース 当時はRDBがコア。RDBの入出力をJavaなどで書くのがメイン。 OSSのDBはまだあまり第一線で使われることはなく、Oracle/DB2/SQL Server/Interbase(Firebird)などが広く使われていた。 Oracleも1コアならライセンス料が安い！ 最初はNoSQLという名前で話題になった非RDB群も、現在では用途別に少しずつ普及してきた。 memcached、Redisなど、特定用途特化のキャッシュとかランキングとかのKVSが使われるように 検索エンジンとしてElasticsearchを一緒に使うようになってきた 日本では流行ってないけど、リレーションまでは不要で親子関係でJSONで表現できる範囲（プレイヤーのアイテムプロパティにアイテムが3個入って・・・とか）であればMongoDBは海外では流行っている。 Dynamo, BigTableも用途によっては使われるが、消えたら困るようなメインのDBは日本ではまだまだRDBが強い。 NoSQLといっても、主キーで値をとってくる以上の機能を備えたものは独自の記述力の高いクエリー言語を持っていたり（MongoDBのJSONのクエリー、CassandraのCQL）するし、それをもうSQLにしちゃえばよくね？（Spanner、CockroachDB）みたいなのも出てきて、NoSQLという言葉自体が使われなくなってきてる？ クラウドパワーで、Kafkaをそのままストレージに使うLinkedInみたいな変態アーキテクチャも RDBもだいぶ世界が変わって来た 現在はOSSのRDBMS（というかPostgreSQLとMySQL）がかなり使われるようになってきた RDBもクラウドのパワーを得た MySQL/PostgreSQLのエンジンが切り替えられるクラウドサービスを各クラウドベンダーが提供 スケーラビリティが重視される場合はAurora、Spanner、CosmosDBなどの分散するRDBも人気 とはいえ、エクサデータは相変わらずすごい。札束ですべてが解決する。マネーイズパワー。 まとめ 基本的なベクトルは大きくは変わらないものの、ツールの使い勝手とかカバレッジが大幅に強まったのと、誰でも使いやすいように整備が極めて簡単になったりして、「エンジニアリングリソースが潤沢で儲かっているIBMとかMicrosoftとか一部の会社の事例を見て指をくわえていた」のが、気軽に使えるようになってきたところは大きく変わってきていますね。 あとはやはり分散リポジトリのGitの普及とその周辺エコシステムの変化は開発の体験が大きく変わったと感じます。

Top 10 Password Tools for Windows, Linux and Cracking Web Applications

Hacking has been the existence of more than a century. It all started when a group of young people wondered how the phone went to work, to make the right connections and direct calls to the right place. Originally, the cut was not even seen as a negative connotation with which they associate the term with the modern world in connection. The term "piracy" is an abbreviation that modifies completing the performance of a computer operating system that would take less time and improve. In recent years we have seen the development of technology in great shape with almost everything you can do online, such as banking, shopping, investments, etc., and more. All you need to do is identify the site you want to visit and create insurance with a strong password. The password is a secret word or phrase that is used for authentication, to prove identity or access permission to gain access to accounts and resources. A password protects our accounts or resources from unauthorized access. What Cracking Password? A password break is the process of guessing or restoring a stored password positions or outside the data transmission system. The purpose of password cracking, the user could help restore a forgotten or unjustified password easy to verify access to a system or as a preventative measure by system administrators of crack passwords ables. When the penetration test is used to check the security of an application. Passwords are a necessary evil in today's world. You need a unique and complex password for daily online activities, such as email, social media, etc. If your password is short or simple, you are always at risk of hacking. In recent years, computer programmers have been trying to create algorithms to break passwords in less time. Most password-breaking tools try to log in with all possible combinations of words. If the application is correct, it means that the password is found. But on the other hand, it can take hours or weeks or months to crack a password when strong enough with a combination of numbers, letters and special symbols. Some tools to crack passwords using a dictionary, what passwords have. But the success rate of these tools is less, because it totally depends on expanding dictionary. Developers in recent years have developed many tools for breaking passwords. Each tool has its own advantages and disadvantages. In this article, we introduce some of the most popular password-breaking tools.

Please note that this article is for educational purposes only and should not be used because it is illegal, and illegal in many countries. We are not responsible for the consequences . 1. Brutus  Released in October 2000, it is one of Brutus' popular online crack passwords tools. It says it's the fastest and most flexible password wrapping tool. This tool is free and is only available for Windows systems. Supports HTTP (Basic Authentication), HTTP (HTML / CGI Form) also create, FTP, POP3, SMB, Telnet and other species such as NNTP, IMAP, NetBus etc. You can create your own authentication types. This tool also supports multiple authentication engines and stages to be connected in a position of 60 simultaneous targets. It contains record and send options again. Therefore, you can pause the attack process at any time and then resume if you want to continue. While this tool has for many years not been updated, it can still be useful. 2. Cain and Abel  Cain and Abel is a password-breaking tool known by Microsoft operating systems. It allows easy retrieval of various types of passwords through network sniffing, decrypt encrypted passwords, restore wireless network key, encrypted password cracks dictionary, recording conversations in VoIP brute-force attacks and boxes revealing password Cryptanalysis, parsing protocols Routing and caching passwords. The program does not exploit software vulnerabilities or errors that could not be fixed with little effort. It includes some aspects / weaknesses in security protocol standards, authentication methods, and caching mechanisms. This tool is designed for network administrators, penetration testers, security experts and forensic personnel. Download here: http://ift.tt/1kpiaVf

3. RainbowCrack RainbowCrack cookies differs from traditional brute force because they were large pre-calculated tables used called rainbow tables, to reduce the time required considerably to break a password. It is a computer program that will break the rainbow tables using the generated password. Trade-off memory time is a calculation method in which all clear and hashed pairs are calculated using a hashed algorithm. The results are stored in the rainbow table after calculation. This process takes a long time. However, once the table is ready, you can break a password should be faster than the brute force tools. You also need rainbow tablets to generate by yourself. RainbowCrack developers also have LM rainbow tables, rainbow MD5 tables, NTLM rainbow tables and SHA1 rainbow tables generated. As RainbowCrack these tables are free. You can download these tables and use them for password-breaking processes. Download Rainbow tables here: http://ift.tt/yvmRhK 4. John the Ripper John the Ripper is a fast tool known and cracks open source tool that today many variants of Unix, Windows, DOS, BeOS and OpenVMS. Its main goal is to detect weak Unix passwords. In addition, the different types of crypt (3) password hashes are most commonly found on various Unix systems and are supported out of the box of Windows LM hashes, improved along with several other hashes and figures in the community version. Also available is a professional version of the tool that offers best features and native packages for target operating systems. You can also Openwall GNU / * / Linux download, comes with the John Ripper. Download John the Ripper here: http://ift.tt/yp4QcY 5. Wfuzz Wfuzz password wrench software tools are web applications for coercion. It can be used to find not connected (directories, servlets, scripts, etc.), parameter Brute Force (user / password), GET and POST parameters brute force various types of injections (SQL, XSS, LDAP for test, etc.). Fuzzing etc. 6. AirCrack NG The Aircrack is an 802.11 WEP and WPA-PSK cracking program, the keys can retrieve when packets have been captured data. Scans the encrypted wireless packets and then try to crack passwords by their crack algorithm. It implements the standard FMS attack along with some optimizations like korek attacks and the PTW attack, making the attack much faster compared to other WEP cracking tools. It is available for Windows and Linux systems. Aircrack a live CD is also available. Download AirCrack-NG here: http://ift.tt/xnExA3 7. THC Hydra THC Hydra is often the tool of choice when remote authentication brute force crack service is required. You can perform a fast dictionary attacks against more than 30 protocols, including TELNET, FTP, HTTP, HTTPS, SMB, multiple databases and more. It also shows you why it is faster than other similar tools. The new modules are easy on the tool to install. You can easily add modules and improved functionality. It is available for Windows, Linux, OS X, Solaris and BSD free. This tool supports multiple network protocols. Currently, it is compatible with Asterisk, AFP, Cisco AAA, Cisco auth, Cisco enabled, CVS, Firebird, FTP, HTTP FORM-GET, HTTP POST form, HTTP GET, HTTP HEAD, HTTP proxies, HTTPS and FORM -get, HTTPS FORM POST, HTTPS GET, HTTPS HEAD, HTTP proxy, ICQ, IMAP, IRC, LDAP, MS SQL, MySQL, NCP, NNTP, Oracle listener, Oracle SID, Oracle and PC. , SNMP, SOCKS5, SSH (v1 and v2), Subversion, TeamSpeak (TS2), Telnet, VMware Auth, VNC and XMPP. Download THC Hydra here: http://ift.tt/1hm2Ffm 8. Medusa Medusa is also a tool like THC Hydra to crack passwords. He claims to be a brute-force, modular, and quick-access instrument. It supports HTTP, FTP, CVS, AFP, IMAP, MS SQL, MySQL, NCP, NNTP, POP3, PostgreSQL, pcAnywhere, rlogin, SMB, rsh, SMTP, SNMP, SSH, SVN, VNC, Telnet and vmauthd. As long as the password, the username and password host can be flexible input attack plans when. Since Medusa a command-line tool, you need to learn commands before using the tool. The effectiveness of the tool, depending on the network connection. You can try 2,000 passwords per minute on a local system. You can also perform a parallel attack with this tool. For example, if you want the same range passwords for some email accounts, we can cite the list of usernames with password list. Download Medusa here: http://ift.tt/1kpibbE 9. L0phtCrack The L0phtCrack Cracking Tools password is an alternative to ophcrack. Try to break Windows password hashes. Use Windows workstations, primary domain controllers, network servers, and Active Directory to break passwords. It is also used to produce dictionary and brute force attack and guessing passwords. L0phtCrack is equipped with powerful features such as programming, 64-bit hash extraction versions of Windows, multi-processor algorithms and network monitoring and decoding. It was acquired by Symantec and later adjusted in 2006 to acquire the developers and L0phtCrack called L0pht back to life in 2009. It also comes with an audit feature programming routine. You can set daily weekly or monthly tests, and start scanning at the scheduled time. Download L0phtCrack: http://ift.tt/1kpidjE 10. OphCrack Ophcrack is a free Windows password cracker based on rainbow tables. It is a very efficient application of rainbow by the inventors of the method carried out in tables. It comes with a graphical user interface (GUI) and runs on multiple platforms. You can also use it on Linux and Mac systems. Rubbing the LM and NTLM hashes. To break Windows XP, Vista and Windows 7, rainbow tables are available for free. A Live CD Ophcrack is also for accelerating cracks, available. You can use Ophcrack LiveCD to crack Windows-based passwords. This tool is available for free. Download OphCrack here: http://ift.tt/y7NAAR

via Blogger http://ift.tt/2lwqBay