service broker

izaya orihara character analysis

a study in human character, mental illness and socially percieved sanity [revised version]

“I succumb to the illusion that I’m God when I look at it like this, which feels pretty good, you know.” – Izaya Orihara

EARLY YEARS

From what we’re acquainted with in the series, Izaya seems to have been born human. His early years are supposedly normal, his parents loving him and his sisters as parents should. The relationship between the Orihara siblings isn’t a typical one though – ranging from the incestuous obsession on one side (Mairu and Kururi), to a cold, heartless relationship (the twins and Izaya), in which the two would not mind sending their brother to death for the chance of seeing their idol.

“While Mairu and Kururi are inseparable, their feelings on the elder brother are not as clear-alternately stating that they still consider him family, but also saying they wouldn’t mind killing him and throwing his dead body in the garbage to meet their idol: “Hanejima Yuuhei”, Shizuo’s younger brother.” – drrr!! wiki

Keep reading

enigmatic-elegance  asked:

Random writing prompt! You don't need to do it, but might be fun: Give us a look into Lilly setting down her blades and picking up a trade. Could be any trade, and maybe she never would! Still, I'm interested to see what she would do and how!

(Alright, well been thinking of how this’d go all day, entirely distracted me from work, but now I’m home and could write)

Almost two decades since Lilly had taken a rather serious injury to the base of her spine. Medicine and healing magics have done what they could, and the woman had made quite a bit of progress, but who was she to kid herself? She wouldn’t have been able to fight like this, so she’d given up the operative side of crime, and now runs a tattoo parlor, which is a front for a fencing service and information brokering. She didn’t quite feel shame for it, more just a feeling of disappointment in herself, after all of the big talk of her youth she was just as breakable as everybody else.

Early in the morning, the heavily tattooed, white haired woman woke, turning her head to the left, noting an empty half of the bed. Her partner who had stayed last night seems to have gone. Even pushing her late forties now, she still looked just as young as she did in her early twenties, though, some key differences seem to be evident. Her body, while still in shape, seems to have lost a lot of its muscle tone, it looks like she hasn’t worked out rigorously, or on a regular schedule for years. Her shortly cut white hair has been grown out to that of a normal woman’s, and is now dyed a light brown. Her right eye, while still blinded, doesn’t seem to be as severely scarred now, the mark simply having faded almost entirely away, and her facial tattoo covering most of it, the areas that were torn up have since been covered over. The woman sits up in her bed and glances around, reaching out to her nightstand and picking up a single contact case, and proceeding to put one on her good eye, this was not a visual aid though it changed made the color of her iris brown, as opposed to the usual shining silver. Looking closer at the body of the woman, one would see that she was tattooed from neck to ankle, every possible inch that would have markings in it was covered. and none of her skin tone below the neck was visible. The woman pulled her hair back and tied it off into a tasteful ponytail and went to a nearby closet

Opening it up and looking inside, Lilliana’s usual dark leather clothes, or any of the things she’d usually be seen wearing, aside from her keepsake scarf, were all gone, replaced with dresses, pants, shirts, and other much less intimidating clothing. She grabbed her clothes for the day and dressed herself in what seemed to be a pair of brown pants and a white shirt, which only revealed the very top of her chest keeping much of her cleavage (if she had any to begin with) hidden, wrapping the scarf around her neck and pulling the ponytail out from underneath it. Next she looked at the piercings, it had been a long time since she wore every last one of them, not so long that the holes have closed, but long enough that one would notice. Today she picked some that were quite simple, simply one steel ring on either earlobe, and after going to the washroom to do the next basic hygiene things, and she finally left her room. Walking out into her normal house, she would bang harshly on the door to her left, “Erick! I need to go to work early, so you’ll be on your own this morning!” She called into the room, to which a younger masculine voice, maybe fifteen or so just responded with a few tired groans, the woman rolled her eyes and left, not eating breakfast, not preparing anything, just making her way downstairs, rousing a sleeping dog that was in the main room, “Come on Lizzy.” She said to a very excited looking dog, clearly a full grown husky dog, who followed her out the door, and to her tattoo parlor on the other side of town.

Once there she set up her things fairly quickly, hanging up her coat and scarf on the hanger, the woman sitting down on the chair next to the tattoo table, and waited. Not long after a client would arrive and flash a silver compass at her, offering a silent nod Lilly got up and went behind the counter, getting a few files out from under it and handing them over to the visitor, “Care to stay for a bit of ink? I still have a few hours until I actually open.” She inquired, one would see in her eye that she wanted more conversation, but the stranger would simply shake his head and walk out the door with a soft sigh Lilly looked down, wondering what life would have been like if she hadn’t fucked up all those years ago.

MORGAN STANLEY: There's one company pulling ahead in blockchain tech

Major Wall Street banks have been investing in blockchain technology for years now, but few products have yet to actually reach the market. That’s because we’re still in a “proof of concept” phase, according to new Morgan Stanley research published this week. 

“Whilst Blockchain, or distributed ledger technology, has been around for a number of years, it has only really begun to gain traction in the mainstream in the last 12 months,” write analysts at the bank.

(Morgan Stanley Research)

One company that’s leading the way? BNY Mellon.

Morgan Stanley says the custody giant has created a parallel infrastructure using blockchain technology. BDS360 (short for Broker Dealer Services 360) monitors the custodial bank’s ledger simultaneously and creates a second, redundant ledger that serves as a backup record. It’s been up and running since March 2016. 

Here’s how it works:

(Illustrative structure of BNY Mellon’s BDS360 in relation to existing infrastructure BDC.Morgan Stanley Research)

It "provides a cost-effective way of adding extra layers of resiliency to the current platform,“ the bank said in a note. 

BSD360 is the closest thing to a market-ready product, says Morgan Stanley. All that’s left is to roll out is client-facing portions, which comes with its own set of challenges. 

"There is still work to be done to figure out the specifics of client interface,” says Morgan Stanley. “BNY Mellon would also need to engage in regulatory dialogues, and establish necessary standards and protocols. We think BNY Mellon is well positioned to take on those challenges, with ~85% market share in the [bond] space.”

Since it’s only internal, and merely duplicates the current settlement processes, it’s not a cost-save move by BNY Mellon. Rather, it’s a cheap way to add another layer of resiliency, according to Morgan Stanley. 

Other examples of blockchain experiments include the Australian Securities Exchange, Monetary Authority of Singapore, and Ripple, a blockchain startup that wants to break SWIFT’s stranglehold on intra-bank messaging.   

These proofs of concept are paving the way for cost-saving innovations, but there’s still a long way to go. 

“Adoption of some form of Blockchain technology by incumbents is likely,” writes Morgan Stanley. “Given the amount of collaboration required, we expect it could take several years to replace existing back office functions.”

NOW WATCH: A $16B hedge fund CIO explains what it takes to work at a hedge fund today



More From Business Insider
Ice Queen

Author’s Note:  A one-shot that jumped into my head after an idle conversation and wouldn’t leave until I wrote it. My other stories that need to be updated are so angry at me, you wouldn’t believe it.

(*)

Ice Queen

(*)

Junior’s, Weiss decided immediately, was not her kind of place. 

Though she certainly didn’t live like one anymore, at heart she was still an aristocrat.  Given the choice of places to spend her free time, she preferred a venue that suited that upbringing.  Classical music, fine wines, waltzing beneath crystal chandeliers.  She rarely mentioned this to her co-workers at Beacon, of course (like she needed to give them more reason to call her a princess!) but she could hardly deny it was the truth.  A nightclub with lights flashing in random patterns and bass cranked up so high her teeth rattled was not her idea of a good time. 

Try telling Yang that, though. 

Keep reading

anonymous asked:

Y'all actin' like Trump is a tyrant. If Congress doesn't agree with his EOs they can repeal them. All he's done so far is improve the country. I don't even like the guy (Rand Paul for life), but he hasn't done anything bad yet.

Uhhh that temporary blanket ban he placed on people from Muslim majority countries. (I know Obama set part of the groundwork for this, but that’s a different story)

His ban suspends people with visas and green cards, non-citizens that have legally resided in the U.S for years. Non-citizens with dual citizenship to one of the countries on the banned list are stopped from entering the U.S. So if you’re a British citizen with dual citizenship who has lived in the U.S for several years, but traveled outside of the country, you’re not allowed back in for that 90 day period (see Mo Farah). It’s a big slap in the face to due process and it violates the establishment cause. With refugees, I understand halting the process before employing vetting measures, but all of this is ridiculous. And then there’s the fact that countries like Turkey are kept out of the banned list, even though Trump has expressed concerns about attacks by Islamic terrorists there. The State department even issued a warning for Americans traveling to turkey because of the increase of anti-American rhetoric that could inspire people to carry out acts of violence against U.S citizens. But he’s not going ahead with the ban because he has business ties to them. 

And his 20% increase on Mexican imports (which was suggested after the Mexican president canceled their meeting). The catch is that those taxes aren’t being paid by the companies selling their goods from other countries (Mexico) but by the companies where the goods are being imported to which eventually is passed onto consumers. So the taxpayer will be footing a good portion of the bill. Even if Trump tried forcing Mexico to pay those import taxes, those companies – within Mexico – would raise their prices to make up for the extra cost on imports. To be quite honest, I think the wall itself a huge waste of money and resources.

According to the U.S Custom’s and Border Protection: The importer is ultimately responsible for paying any duty (the import tax) owed on an import. Determining duty can be very complicated, and while shipping services will often give an estimate for what the duty rate on an item might be, only CBP can make a final determination about what is owed. You should not be misled into thinking your purchase price includes duty because the seller cannot say with absolute certainty what the duty will be. As a rule, a purchase price that includes shipping and handling does not include duty or any costs associated with clearing the goods through CBP. First time importers are often surprised by bills they receive for duty, U.S. Customs and Border Protection merchandise processing fee, and something referred to as “customs fees,” which are actually charges for the services of the broker who cleared your goods through CBP.

His nomination for secretary of education. She sounds like she has next to no experience when it comes to public education and her senate hearing was painful to watch. Also her/her family has a history of being huge donors to Republican candidates and PACS. That’s something to be skeptical about; it seems like she’s using her wealth to get to where she is.

If Congress doesn’t agree with his EOs they can repeal them.

It’s really not that easy. It takes a considerable amount of time before congress can repeal (or rather pass a bill to nullify) his EO’s, by then they could have done extensive damage.

I’m all for honest criticism of Trump, but to say he hasn’t done anything bad yet is a huge stretch.  

Centralized Auditing, Data Aggregation, Deployment Processing

I have been experimenting with SERVICE BROKER, XML, XPATH, & MERGE  for a way to transfer data across untrusted domains. We have  many uses for a reliable and standardized way to move data, look-up data and trigger events. One example is a nightly config checker and health evaluation job that runs on well over 100 servers. This job populates about 8 tables in our DBA DB, such as DBA_DBServerInfo, DBA_DBInfo, DBA_DBDiskInfo…. I want this data aggregated at a central HUB SQL Server for look-ups, reporting, and alerting. I also want this system to be usable for other data gathering, data auditing, DDL auditing, data pushing, and deployment processing projects. 

SSB was fairly simple to set up other than it is not very GUI centric. I was able to create certificates on the servers to authenticate with so that I can get past the Domain and sql login issues and simply open a single port between all SQL Servers to perform all DBA Processing messages. After I was sure I could get Service Broker to do what I wanted, the next step is to create code the reliable takes a table to XML and back to a table again. 

The first hurdle was to encoding the data into XML in a way that was generic, contained all of the information of where it came from and how to turn it back into a table to put back into a table. “SELECT * FROM TABLE FOR XML RAW” gave me the data as XML but I found it extremely difficult to put it back into a table. I finally did come up with a great process now that works well and I also came up with a way that works with single tables or a collection of tables in a single XML Doc.

I added XMLSCHEMA to the query and it gave me all of the schema I needed to query the data back out of the XML to Merge it into the destination table. The next trick was to figure out how to get what I wanted out of the XSD portion of the XML so I could query the data portion back into the exact formats it came from.

This was my first experiment with merge and I also found it to be fairly handy. I was able to dynamically generate a merge statement that looks at the PK of the destination table and uses those columns to determine between an insert or an update.

There really isnt much information or examples (that work) out there for xpath queries so it took quite a while to get something that works. I am sure someone out here can tell me how bad I did and how much better it could be. which is exactly what I want.

This is my basic encode - decode - merge of a single table…

SET NOCOUNT ON

IF OBJECT_ID(‘tempdb..#XMLSCHEMA’) IS NOT NULL DROP TABLE #XMLSCHEMA

IF OBJECT_ID('tempdb..##Source’) IS NOT NULL DROP TABLE ##Source

DECLARE @XML XML

,@XSL XML

,@TSQL nVarChar(4000)

,@TableName sysname

CREATE TABLE #XMLSCHEMA

([name] sysname NULL

,[use] sysname NULL

,[type] sysname NULL

,[base] sysname NULL

,[value1] sysname NULL

,[value2] sysname NULL)

————————————————————————

————————————————————————

– GENERATE A XML CHUNK TO PLAY WITH

————————————————————————

————————————————————————

SET @XML =  

(SELECT * From dbaadmin.dbo.DBA_DBInfo FOR XML AUTO,XMLSCHEMA,ROOT('Table’))

SELECT @XML

————————————————————————

————————————————————————

–GET ONLY THE TOP XDS PORTION OF THE XML CHUNK

————————————————————————

————————————————————————

SELECT @XSL = x.query(’.’) 

FROM @XML.nodes(’/Table/*[1]’) a(x)

– COULD NOT USE REPLACE FUNCTION AS IT DOES NOT 

– WORK FOR LARGE TABLES WHERE XML IS LARGER THAN 8000

– EVEN THOUGH REPLACE DOES ACCEPT VARCHAR(MAX)

– WOULD LIKE TO FIND XQUERY VERSION OF REPLACE

– SELECT @XML = CAST(REPLACE(CAST(@XML AS VarChar(max)),CAST(@XSL AS VarChar(max)),“) AS XML)

SELECT @XML = (

SELECT CAST(STUFF (

CAST(@XML.query(’*[1]/*’) AS VarChar(max))

,1

,CHARINDEX (

’</xsd:schema>’

,CAST(@XML.query(’*[1]/*’) AS VarChar(max))

)+12

,”

) AS XML)

FOR XML RAW ('Table’)

)

————————————————————————

————————————————————————

– GET THE TABLE NAME

————————————————————————

————————————————————————

SELECT @TableName = a.x.value(’*[2]/@name’,'sysname’)

FROM @XSL.nodes(’*’) a(x)

SELECT @TableName [TableName]

————————————————————————

————————————————————————

– POPULATE THE XMLSCHEMA TEMP TABLE

————————————————————————

————————————————————————

INSERT INTO #XMLSCHEMA

SELECT a.x.value(’@name’,'sysname’) [name]

,a.x.value(’@use’,'sysname’) [use] – use=“required” for PK of Source

,a.x.value(’@type’,'sysname’) [type]

,a.x.value(’*[1]/*[1]/@base’,'sysname’) [base]

,a.x.value(’*[1]/*[1]/*[1]/@value’,'sysname’) [value1]

,a.x.value(’*[1]/*[1]/*[2]/@value’,'sysname’) [value2]

FROM @XSL.nodes(’/*/*/*/*’) a(x)

————————————————————————

————————————————————————

– CREATE THE DYNAMIC SQL TO CREATE THE SOURCE TEMP TABLE FROM THE XSD

————————————————————————

————————————————————————

SET @TSQL = 'SELECT ’

SELECT @TSQL = @TSQL – START BUILDING NEXT LINE OF QUERY

+ 'a.x.value(“@’+[name]+”’,“’

+REPLACE(COALESCE([type],[base]+’(’+value1+COALESCE(’,’+nullif(value2,”)+’)’,’)’)),'sqltypes:’,“)+”’) ' 

+ QUOTENAME([name])

+ CHAR(13) + CHAR(10) + ’ ,' 

FROM #XMLSCHEMA ColumnData

SET @TSQL = REPLACE (

@TSQL+’||’ –APPEND DOUBLE PIPE TO END SO I CAN IDENTIFY LAST COMMA 

,’ ,||’ – REPLACE LINE WITH LAST COMMA WITH NEXT VALUE

,'INTO ##Source’+CHAR(13) + CHAR(10)+'FROM @XML.nodes(“/Table/*”) a(x)’

)

————————————————————————

————————————————————————

– CREATE THE SOURCE TEMP TABLE FROM THE XSD

————————————————————————

————————————————————————

EXEC sp_Executesql @TSQL,N’@XML XML’,@XML

————————————————————————

————————————————————————

– SHOW THE SOURCE DATA AFTER INSERTED INTO THE TEMP TABLE

————————————————————————

————————————————————————

SELECT * FROM ##Source

————————————————————————

————————————————————————

– CREATE THE DYNAMIC SQL TO GENERATE THE MERGE STATEMENT

————————————————————————

————————————————————————

– CREATE DESTINATION IF IT DOES NOT ALREADY EXIST

————————————————————————

————————————————————————

– CREATE THE DYNAMIC SQL TO GENERATE THE MERGE STATEMENT

————————————————————————

————————————————————————

– ONLY DO MERGE IF DESTINATION HAS A PRIMARY KEY

IF EXISTS (

SELECT SIK.colid 

FROM sysindexkeys SIK 

JOIN sysobjects SO 

ON SIK.[id] = SO.[id]  

WHERE SIK.indid = 1

AND SO.ID = OBJECT_ID(@TableName)

)

BEGIN

SET @TSQL = 'MERGE INTO ’+@TableName+’ as Target’ + CHAR(13) + CHAR(10) 

+ 'USING ##Source as Source’ + CHAR(13) + CHAR(10)

+ 'ON’ + CHAR(9)

SELECT @TSQL = @TSQL + 'Target.[’+[name]+’] = Source.[’+[name]+’]’+CHAR(13)+CHAR(10)+'AND’+CHAR(9)

FROM syscolumns 

WHERE [id] = OBJECT_ID(@TableName)

AND colid IN (

SELECT SIK.colid 

FROM sysindexkeys SIK 

JOIN sysobjects SO 

ON SIK.[id] = SO.[id]  

WHERE SIK.indid = 1

AND SO.ID = OBJECT_ID(@TableName)

)

SET @TSQL = REPLACE(@TSQL+’||’,'AND’+CHAR(9)+’||’,CHAR(13)+CHAR(10)+'when matched then update set’+CHAR(13)+CHAR(10)+'Target.’)

SELECT @TSQL = @TSQL + ’[’+[name]+’]=Source.[’+[name]+’]’+CHAR(13)+CHAR(10)+’,Target.’

FROM #XMLSCHEMA ColumnData

SET @TSQL = REPLACE(@TSQL+’||’,’,Target.||’,CHAR(13)+CHAR(10)+'when not matched then insert’+CHAR(13)+CHAR(10)+’(’)

SELECT @TSQL = @TSQL + ’[’+[name]+’]’+CHAR(13)+CHAR(10)+’,’

FROM #XMLSCHEMA ColumnData

SET @TSQL = REPLACE(@TSQL+’||’,CHAR(13)+CHAR(10)+’,||’,’)’+CHAR(13)+CHAR(10)+'values’+CHAR(13)+CHAR(10)+’(Source.’)

SELECT @TSQL = @TSQL + ’[’+[name]+’]’+CHAR(13)+CHAR(10)+’,Source.’

FROM #XMLSCHEMA ColumnData

SET @TSQL = REPLACE(@TSQL+’||’,CHAR(13)+CHAR(10)+’,Source.||’,’);’)

————————————————————————

————————————————————————

– SHOW THE MERGE STATEMENT

————————————————————————

————————————————————————

PRINT (@TSQL)

————————————————————————

————————————————————————

– RUN THE MERGE

————————————————————————

————————————————————————

EXEC (@TSQL)

END

————————————————————————

————————————————————————

– CLEAN UP TEMP TABLES

————————————————————————

————————————————————————

IF OBJECT_ID('tempdb..#XMLSCHEMA’) IS NOT NULL DROP TABLE #XMLSCHEMA

IF OBJECT_ID('tempdb..##Source’) IS NOT NULL DROP TABLE ##Source

chthonicvindicator liked this for a starter;

“I suppose you have the information I requested?”

The blue eyed male calmly inquired, his glance travelling from the old book in his hands towards the new presence led by the bodyguard in his office. It was somewhat rare for the Kafka leader to request the services of an information broker, but sometimes it was better to cover his agents.