jbanana | Reading

http://questionablecontent.net/view.php?comic=3530

Ads by Project Wonderful! Your ad could be here, right now.

Alice Grove is finished. I'm going to take some time to just do QC for a while and then start another side project sometime in the fall. Patreon subscribers will get sneak peeks, advance previews, and other stuff as it develops. Thank you for reading my comics.

http://questionablecontent.net/view.php?comic=3530

kevins_concerts

I went down to Veteran's Park to see Copper Box. They play all over eastern Wisconsin. Festivals and such. They're a lot of fun. A guy plays keyboards, accordion, sousaphone, trumpet and sings. A girl plays guitar, tenor and baritone saxes, flute and sings. A guy plays bass and occasional ukulele and guitar. A guy plays drums. They play... rock, zydeco, polka, swing... ish. They did a sax and sousaphone version of Aerosmith's "Last Child." And a polka version of "Comfortably Numb."

Best band ever? No. A good way to spend an evening? Definitely.

basicinstructions_feed

Posted by Scott Meyer

http://www.basicinstructions.net/basic-instructions/2017/7/20/how-to-tell-someone-about-your-dreams

I seem to vaguely remember that I did have a dream about Tim Gunn building a submarine.

I do want to be thin, smart, successful, polite, well dressed, and dignified. I think, on good days, I manage to pull off polite.

As always, thanks for using my Amazon Affiliate links (US, UK, Canada).

http://www.basicinstructions.net/basic-instructions/2017/7/20/how-to-tell-someone-about-your-dreams

alicegrove_comic_feed

http://www.alicegrove.com/post/163216900934

Alice Grove ends tomorrow. If you’d like to see the ending early, I posted it for donors on my Patreon

http://www.alicegrove.com/post/163216900934

kissedmouth_feed

Posted by Kirsty Stonell Walker

http://fannycornforth.blogspot.com/2017/07/review-beauty-in-thorns-and-interview.html

I have been most fortunate this month because Kate Forsyth, author of Bitter Greens, let me have a read of her new novel Beauty in Thorns. I was very eager to read it because I have been talking to Kate for a while now about the lives and loves of Pre-Raphaelite muses and as the author of a novel about Pre-Raphaelite women I'm always delighted to find another book on the same subject. Kate has taken the familiar threads of the Pre-Raphaelite story and made a novel that spans the birth of the Brotherhood right to the end of the century, centering around the lives of the muses, wives and lovers of the artists.

This is a monumental piece of work. Spanning fifty years and almost five hundred pages, Beauty in Thorns covers some familiar ground but in a way that will make you question everything you thought you knew about the Pre-Raphaelite women. Predominantly following the lives of Elizabeth Siddal, Jane Morris and Georgiana Burne-Jones, we trace them from childhood, through love and marriage (not necessarily with the same man), troubles, disillusionment and immortality.

Elizabeth Siddal, Asleep (1850s) Dante Gabriel Rossetti

It would be hard to see how a novelist could take scenes as ingrained in Pre-Raphaelite lore as Lizzie in the bath and make it new, but throughout her prose, Kate adds layers of character to these women, making them more than just the muses of their lovers, but as people with motivation, needs, desires and dreams.

Jane Morris (1873) Dante Gabriel Rossetti

Taking the recurring theme and image of sleeping beauty, not only in Edward Burne-Jones monumental murals but also the lives of the women, Kate reveals girls awaiting princes, women having to allow men the active role in romance, and the fortunes of women who rebel against these constraints. Not only are the women the unwilling heart of a passive fairytale, waiting in their bower for a prince, but also there is reflection on the other roles women take in such tales, cursing their own daughters to isolation through any transgressions of the mothers.

After reading Beauty in Thorns I was desperate to ask Kate about her journey from research to story, and I was lucky enough to ask her some questions...

Q. In Beauty in Thorns, both Ned Burne-Jones and Lizzie Siddal change their names on Rossetti's suggestion/demand. Why do you think they allowed him that power and why do you think he needed it?

Elizabeth Siddal(l) (c.1860)

I think both Lizzie Siddal and Ned Burne-Jones admired Rossetti, and looked up to him. Rossetti was very aware of the importance of names in both shaping one’s sense of self-worth and in creating a persona for public consumption. He had changed his own name from Gabriel Charles Rossetti to Dante Gabriel Rossetti only a few years earlier.

Q. I think some readers will be shocked by how brutal Jane Morris' origins are portrayed - why did you give her such an unromantic back story?

Jane Morris, 1865

I think it is my job to be as truthful as possible about the lives of my characters, not to romanticise them.

Janey Burden was a slum girl. Her father worked as a groom in the stables of a busy inn in Oxford. Her mother was a laundress (when she could get work) and illiterate. Janey lived with her parents and brother and sister in a single room not much larger than one of the horses’ stalls. Her eldest sister died of tuberculosis when only a child.

It is known her father could be violent, as he was charged with assault on a neighbour. It is known they were destitute, because her father was unable to pay the parish poor rate. It is also known her mother and father’s relationship was troubled because her parents separated after Robbie Burden refused to pay for his wife’s debts.

Janey would, most probably, have gone to the local parish school till she was twelve, and then it is likely she would have worked as a laundress, seamstress, or scullery-maid. We don’t know, because she never spoke about her childhood.

La Belle Iseult (1858) William Morris

When John Mackail was writing his biography of her husband, William Morris, he wished to talk about Jane’s background. She refused to tell him anything or let him include a drawing of where she had once lived.

Mackail wrote angrily, ‘If Mrs. Morris feels ashamed of having lived in a little house among surroundings of extreme beauty before she married, all I can say is that such a feeling is to me unintelligible.’

Of course it was. He was a man, university educated, and born in a respectable middle-class family. He had no idea what it would be like to be a girl growing up in a rookery.

Victorian slums are notorious for their squalid living conditions. Janey lived in St Helen’s Passage for quite some time. In 1848, the passage was described in the following terms: ‘There are several very unwholesome dirt heaps, an exceedingly bad surface drain … a deep pit partly filled with solid matters and covered with a wooden trap door is situated close to a house, the inhabitant of which complained much of the smell arising from it.’

In the 1850s, the investigative journalist Henry Mayhew described similar slums in London as ‘wretched dens of infamy, brutality and vice’. Sexual exploitation, child labour, dirt, disease and drunkenness were all sides effects of such abject poverty, and Janey would have seen it all – and quite likely suffered it too.

One of the few things that is known about Janey’s childhood is that she gathered violets in the meadows and woods outside Oxford, most probably to sell on street corners.

Later, after she became engaged to William Morris, she was sent away to learn how to be a lady. She was taught how to enunciate properly and how to play the piano and embroider.

It is believed that Janey was the inspiration for the character of Anne Brown in Vernon Lee’s 1884 novel Miss Brown, which in its turn inspired George Bernard Shaw’s 1914 play Pygmalion, in which the flower seller Eliza Doolittle is plucked from the streets and taught how to speak and act, just as Jane Burden was by William Morris. Interestingly, Shaw was very close to the Morris family, living for some years in a ménage-a-trois with May Morris and her husband.

Rather than romanticising Jane Burden’s childhood, I felt it was important to show just what a tough and brutal life she must have had. The way that she transformed herself – teaching herself to speak Italian, reading widely, and creating beautiful pieces of textile art – is such a testament to her intelligence and strength of character.

A key source for me in imagining Janey’s childhood and adolescence was the essay, ‘Where Janey Used to Live’ by Margaret Fleming, published in The Journal of William Morris Studies (Winter 1981). Also useful was Jan Marsh’s dual biography Jane and May Morris: A Biographical Story 1839-1938 (1986), Jane Morris: The Burden of History by Wendy Parkins (2013) and London Labour and the London Poor: A Cyclopædia of the Condition and Earnings of Those That Will Work, Those That Cannot Work, and Those That Will Not Work, by Henry Mayhew (1862).

Q. Traditional narratives have Rossetti and Lizzie's relationship as sexless but that isn't the case here. What made you interpret them that way?

Early biographers of Dante Gabriel Rossetti did indeed argue that he and Lizzie Siddal never consummated their love before marriage, despite eleven years of close association including periods when Lizzie was essentially living with Gabriel in his lodgings. One of those biographers was his brother William Rossetti who was doing whatever he could to save Rossetti’s reputation from accusations he was a seducer and a philanderer.

Elizabeth Siddal as Delia (c.1860-2) Dante Gabriel Rossetti

These same biographers named Lizzie ‘frigid’, ‘wan’, ‘passive, ‘sluggish’, ‘inert’, ‘a melancholy doll’, ‘depressive’, ‘manipulative’ and ‘a hypochondriac.’ The best that was said of her was said she was ‘frail and sensitive’.

I utterly refute those readings of her character. You only need to look at her behaviour to see they are both untrue and unkind.

Right from the very beginning of her association with the Pre-Raphaelites, Lizzie showed her willingness to transcend rules. She agreed to model in the first place, despite the common assumption that artists’ models were all prostitutes. She posed with legs bared, in boys’ clothes, for Walter Deverell’s painting of ‘Twelfth Night’. She modelled for Rossetti in suggestive poses, her hair loose, dressed only in her chemise. She defied convention and moved out of her parents’ home, which was almost unheard of at the time. William Bell Scott caught her and Gabriel alone, reading poetry together, in the twilight, something which no good Victorian maiden would ever do. She slept at Gabriel’s apartment, and invited him into her hotel room. She wanted to be an artist herself, and drew and painted and wrote poetry in defiance of society’s strictures on such activities being unladylike.

Indeed, William Rossetti – the primary apologist of his brother - wrote: ‘He was an unconventional man, and she, if not so originally, became an unconventional woman ...’

Rossetti sitting for Elizabeth Siddal (1853) D G Rossetti

Most contemporary biographers of Dante Gabriel Rossetti and Lizzie Siddal – including Lucinda Hawksley, Henrietta Garnett & Franny Moyle – agree with me. Hawksley (2004) says ‘I dispute that Lizzie continued to refuse him and believe they did have a sexual relationship before marriage.’ Moyle writes, in 2009, ‘he was undoubtedly her lover.’ Garnett, writing in 2012, says: ‘Most of their acquaintance took them to be lovers.’

Jan Marsh, one of the foremost Pre-Raphaelite scholars, is not so sure. She writes: ‘It has often been asserted, without evidence, that Gabriel and Lizzie were sexually intimate during the years of their ‘engagement’, or conversely, that Lizzie refused all physical relations until a wedding ring was on her finger. Neither seems to have been the case.’

She is absolutely right in that there is no concrete evidence one way or another. I would, however, point to Gabriel’s myriad drawings of Lizzie sleeping, reading, drawing and sewing, her hair loose on her shoulders, in déshabillé, to show the level of intimacy between them.

Not to mention his poetry. Gabriel’s sonnet ‘Known in Vain’ – written in the mid-1850s, soon after he met Lizzie – reads:

‘As two whose love, first foolish, widening scope,
Knows suddenly, to music high and soft,
The Holy of holies …’

Q. You offer a bravely visceral depiction of Lizzie's eating disorder. Why was it important to show that side of her character so graphically?

Elizabeth Siddal (1854)

One of the difficulties of writing biographical fiction is that the author cannot sit on the sidelines, and say, ‘it is believed that …’ or ‘it is possible …’ A novelist needs to try and find the explanation that seems most likely, and then bring it to life on the page.

The possibility that Lizzie might have had an eating disorder was first suggested by Elaine Shafer in a 1985 essay, ‘The Bird in the Cage’.

However, it has never been closely examined as a probable cause for her troubling illnesses. Lucinda Hawksley, in 2004, writes: ‘Much of Lizzie’s ill health originated in her mind, stemming from her desire to receive attention and love.’

Lucinda Hawksley acknowledges that Lizzie may have had some kind of eating disorder, but then says that ‘it became common for her to emotionally blackmail (Gabriel) by refusing to eat.’

Anorexia nervosa and other eating disorders are mental illnesses with devastating physical consequences. They have the highest mortality rate of any psychiatric disorder. Eating disorders cannot, and must not, be dismissed as a form of emotional blackmail (even though they are commonly misunderstood in such a way).

The more I researched Lizzie’s life, the more convinced I became that she did have an eating disorder. Descriptions of her thinness and her inability to eat are constant in the letters and diaries of the PRB. A few examples:

In 1854, Ford Madox Brown writes in his diary that Lizzie was ‘thinner and more deathlike and more beautiful and more ragged than ever’.

In 1857, Gabriel wrote that she is ‘not better in health or eating anything to speak of’. This was the same year in which Lizzie refused to touch food for two weeks, resulting in her admission to the health spa in Matlock.

In 1861, he refers to her ‘unfortunate lack of appetite which keeps her mostly fasting and prevents her from gaining much strength.’

Then, at the inquest into her death in 1862, he told the court ‘she could not sleep at times nor take food’ (insomnia is a common side effect of anorexia).

Most striking is the visual evidence of Gabriel’s drawings and paintings which show her physically dwindling.

Nowadays, when we see a young woman wasting away, refusing food, or vomiting after meals, we would suspect anorexia nervosa or bulimia nervosa. However, in the mid-19^thcentury such pronounced emaciation was normally attributed to tuberculosis, commonly called ‘consumption’ because it seemed to consume the sufferer.

The first medical identification of eating disorders was made in 1868 (six years after Lizzie’s death), when Sir William Gull, the Queen’s physician, delivered a paper describing a digestive disorder with no known cause, which he called ‘hysteric apepsia’ (apepsia means ‘without digestion’). In 1873 (eleven years after Lizzie’s death), Ernest-Charles Lasègue, a French physician, published a paper entitled De l’Anorexie Histerique which was the first real examination of the idea that the wasting away of these young women could be caused by self-starvation. It was not understood as a mental illness, however, but as a ‘maladie imaginaire’. Sir William Gull consequently undertook further investigation and coined the term ‘anorexia nervosa’.

If Lizzie was an anorectic, she and her family and friends would have had absolutely no idea what was wrong with her. Any ‘curious perversions of appetite’, as Lasègue named them, such as binge eating, secret eating, hoarding of food, purging, refusal of food, or food-related rituals, would have seemed, at best, a hysterical demand for attention.

It is my job, as a novelist, to bring Lizzie’s inner world to life. I have to show what it would have felt like, smelt like. I have to show the revulsion and confusion of those who loved her, and I have to show Lizzie’s own self-loathing and shame. Those scenes were difficult to write, and yet I feel passionately that they explain so much of the difficult emotional dynamic between Gabriel and Lizzie and others who knew her.

I think it utterly fascinating that Christina Rossetti wrote, on 24 December 1856 (in the midst of Gabriel and Lizzie’s early passion):

He feeds upon her face by day and night,
And she with true kind eyes looks back on him
Fair as the moon and joyful as the light:
Not wan with waiting, not with sorrow dim;
Not as she is, but was when hope shone bright;
Not as she is, but as she fills his dream.

Q. There is a distinct difference in the dynamic of Jane and Rossetti than has previously been portrayed (which I won't reveal here because of spoilers). How difficult is it getting to the truth of such a famous relationship?

Jane Morris (1873) D G Rossetti

Once again, I examined the psychology of the people involved and made decisions about what their background and behaviour revealed about their inner lives.

Jane Burden – like Lizzie Siddal – has been judged harshly by the male biographers of her famous husband. Wendy Parkins, in her fascinating feminist re-examination of her life, Jane Morris: The Burden of History (2013), believes she ‘has been burdened by a resilient stereotype attached to her name – the unfaithful wife, the melancholy invalid, the iconic siren – a limited characterisation.’

I agree with her. I found Janey Morris one of the most interesting women in the Pre-Raphaelite Sisterhood – fiercely intelligent, strong-willed, and free of conventional Victorian morality thanks to her wretched upbringing in the slums of Oxford.

I also believe that Dante Gabriel Rossetti has been unfairly cast as a libertine and a philanderer. Which is not to say that I believe him to be altogether free of sexual indiscretion; I simply do not believe he acted quite as carelessly and unkindly as many believe. He was clearly racked with guilt and remorse after Lizzie’s death, and he was, in his youth at least, idealistic and romantic.

Jan Marsh writes, in her dual biography of Janey and her daughter May, that the affair between Gabriel and the wife of one of his best friends ‘is less of a puzzle if it is admitted that Jane may herself have been ‘passionate, fascinating and determined’ rather than simply the object of another’s ardour. At the very least, she was eager and willing to develop the affair.’

Wendy Parkins also argues that the traditional view of Dante Gabriel Rossetti as seducer and Janey Morris as the seduced deprives her of any emotional agency. I believe this to be an untrue reading of the relationship between the two. Janey risked everything for her love for Gabriel, and I believe she did so joyously and determinedly.

Q. I love the way that certain situations echo the paintings, so I have to ask - do you have a favourite Pre-Raphaelite painting?

Oh, so many! It was so wonderful to spend such a long time scrutinising some of the most exquisite art ever created. My favourites include ‘Prosperina’ by Dante Gabriel Rossetti, where he painted Janey Morris as the goddess of spring, condemned to spend half of every year in the world of the dead; John Millais Everett’s painting of Lizzie Siddal as ‘Ophelia’; Rossetti’s painting of Lizzie as ‘Francesca da Rimini’ and ‘Beata Beatrix’; Edward Burne-Jones’s multitude of angels, and ‘Love in Ruins’ and ‘Merlin and Nimue’; and Jane Morris and her daughter May’s gorgeous embroideries. And – of course! The many ‘Sleeping Beauty’ drawings and paintings that Edward Burne-Jones painted over his lifetime, which give me the key narrative thread in Beauty in Thorns.

The Legend of Briar Rose (1885-90) Edward Burne-Jones

Many, many thanks to Kate for allowing me read an advance copy of her book and for answering my questions.

At present, Beauty in Thorns has only been released in Australia but until it has a worldwide release, it is possible to get a copy through The Book Depository.

http://fannycornforth.blogspot.com/2017/07/review-beauty-in-thorns-and-interview.html

sacredporn posting in

dailyprompt

Today's prompt is "leaving this place behind".

the_daily_wtf_feed

Posted by Remy Porter

https://thedailywtf.com/articles/finding-the-lowest-value

Max’s team moved into a new office, which brought with it the low-walled, “bee-hive” style cubicle partitions. Their project manager cheerfully explained that the new space “would optimize collaboration”, which in practice meant that every random conversation between any two developers turned into a work-stopping distraction for everyone else.

That, of course, wasn’t the only change their project manager instituted. The company had been around for a bit, and their original application architecture was a Java-based web application. At some point, someone added a little JavaScript to the front end. Then a bit more. This eventually segregated the team into two clear roles: back-end Java developers, and front-end JavaScript developers.

“Silos,” the project manager explained, “are against the ethos of collaboration. We’re all going to be full stack developers now.” Thus everyone’s job description and responsibilities changed overnight.

Add an overly ambitious release schedule and some unclear requirements, and the end result is a lot of underqualified developers rushing to hit targets with tools that they don’t fully understand, in an environment that isn’t conducive to concentration in the first place.

Max was doing his best to tune out the background noise, when Mariella stopped into Dalton’s cube. Dalton, sitting straight across from Max, was the resident “front-end expert”, or at least, he had been before everyone was now a full-stack developer. Mariella was a long-time backend JEE developer who hadn’t done much of the web portion of their application at all, and was doing her best to adapt to the new world.

“Dalton, what’s the easiest way to get the minimum value of an array of numbers in JavaScript?” Mariella asked.

Max did his best to ignore the conversation. He was right in the middle of a particularly tricky ORM-related bug, and was trying to figure out why one fetch operation was generating just awful SQL.

“Hrmmmm…” Dalton said, tapping at his desk and adding to the distraction while he thought. “That’s a tough one. Oh! You should use a filter!”

“A filter, what would I filter on?”

Max combed through the JPA annotations that controlled their data access, cursing the “magic” that generated SQL queries, but as he started to piece it together, Dalton and Mariella continued their “instructional” session.

“In the filter callback, you’d just check to see if each value is the lowest one, and if it is, return true, otherwise return false.” Dalton knocked out a little drum solo on his desk, to celebrate his cleverness.

“But… I wouldn’t know which value is the lowest one, yet,” Mariella said.

“Oh, yeah… I see what you mean. Yeah, this is a tricky one.”

Max traced through the code. Okay, so the @JoinColumn is CUST_ID, so why is it generating a LIKE comparison instead of an equals? Wait, I think I’ve-

“Ah ha!” Dalton said, chucking Max’s train of thought off the rails and through an HO-scale village. “You just sort the array and take the first value!” *Thumpa thumpa tadatada* went Dalton’s little desk drum solo.

“I guess that makes sense,” Mariella said.

At this point, Max couldn’t stay out of the conversation. “No! Don’t do that. Use reduce. Sorting’s an n(lg n) operation.”

“Hunh?” Dalton said. His fingers nervously hovered over his desk, ready to play his next drum solo once he had a vague clue what Max was talking about. “In logs in? We’re not doing logging…”

Max tried again, in simple English. “Sorting is slow. The computer does a lot of extra work to sort all the elements.”

“No it won’t,” Dalton said. “It’ll just take the first element.”

“Ahem.” Max turned to discover the project manager looming over his cube. “We want to encourage collaboration,” the PM said, sternly, “but right now, Max, you’re being disruptive. Please be quiet and let the people around you work.”

And that was how Dalton’s Minimum Finding Algorithm got implemented, and released as part of their production code base.

[Advertisement] Manage IT infrastructure as code across all environments with Puppet. Puppet Enterprise now offers more control and insight, with role-based access control, activity logging and all-new Puppet Apps. Start your free trial today!

https://thedailywtf.com/articles/finding-the-lowest-value

grandprix_dot_com_feed

http://www.grandprix.com/ns/ns36989.html

The controversial frontal protection concept called 'Halo' will make its mandatory debut on all formula one cars next year.

http://www.grandprix.com/ns/ns36989.html

grandprix_dot_com_feed

http://www.grandprix.com/ns/ns36988.html

F1 CEO Chase Carey says he wants more German carmakers to join the category.

http://www.grandprix.com/ns/ns36988.html

grandprix_dot_com_feed

http://www.grandprix.com/ns/ns36987.html

Robert Kubica says the idea of testing this year's Renault car does not faze him.

http://www.grandprix.com/ns/ns36987.html

grandprix_dot_com_feed

http://www.grandprix.com/ns/ns36986.html

Vijay Mallya says he would be happy if Force India lines up with the same drivers next year.

http://www.grandprix.com/ns/ns36986.html

questionable_content_feed

http://questionablecontent.net/view.php?comic=3529

Ads by Project Wonderful! Your ad could be here, right now.

Alice Grove is nearly at the end!

http://questionablecontent.net/view.php?comic=3529

alicegrove_comic_feed

http://www.alicegrove.com/post/163180718579

Making plans

http://www.alicegrove.com/post/163180718579

f1statblog_feed

Posted by JackStatMan

http://f1statblog.co.uk/2017/07/halo-come-2018/

http://f1statblog.co.uk/?p=5963

The FIA have now officially confirmed that the halo cockpit protection will be in use from 2018, and for some reason a lot of people are against this?

Now I admit, the halo isn’t the best looking thing around and the other suggested solutions are far more aesthetically pleasing, but it’s the most developed so far and that is why it is going to be used in 2018. What I’m hoping will happen is that the halo will simply be used as a stop-gap while better solutions (like the shield, pictured below) are developed further to the point where they can be used.

While the types of accidents where the halo would come in useful are very rare, the mere possibility that it may save a life is surely better than having no additional cockpit protection at all? Today (July 19^th) is the anniversary of Henry Surtees’ death, a man that was killed by a loose wheel that struck him on the head, exactly the type of accident that the halo would stop. Yes, it wouldn’t have helped the accident that caused Massa’s injury in 2009 or the horrific accident of Jules Bianchi (nothing would other than the crane not being there) but it is better than nothing and could potentially save somebody.

One thing that the FIA have said as well is that they will work with the teams to enhance the design of the halo, so by the time we see it on a 2018 car it may not even be as ugly as it is now. This protection issue isn’t simply an F1 thing, the FIA now need to work on putting similar sort of protection in all junior formulas as well, where it would be even more useful.

So the halo is here, and I am perfectly happy with that, though I do hope the FIA continue to research into the issue and further develop the shield concept as that can protect from more types of accidents.

If any fans are seriously going to stop watching the sport because of some additional safety measures then they are not proper fans and are foolish. Every now and then F1 cars are ugly, it happens, then you get used to it, they improve anyway, what’s the problem? Just off the top of my head I can name loads of ugly F1 cars; March 761, Ensign N179, Ligier JS5, Brabham BT34, every single car in 2012 and 2014. How many people do you know that stopped watching in 2012 or 2014 because of the horrific step noses or err “finger” noses?

Safety is more important than aesthetics, drivers’ lives are more important than aesthetics, the halo will not affect the quality of the racing, I see no point in wishing or petitioning for it to not come in for 2018. The halo is here, deal with it.

The post Halo to Come in For 2018 appeared first on The F1 Stat Blog.

http://f1statblog.co.uk/2017/07/halo-come-2018/

http://f1statblog.co.uk/?p=5963

the_daily_wtf_feed

Posted by Remy Porter

https://thedailywtf.com/articles/a-pre-packaged-date

Microsoft’s SQL Server Integration Services is an ETL tool that attempts to mix visual programming (for designing data flows) with the reality that at some point, you’re just going to need to write some code. Your typical SSIS package starts as a straightforward process that quickly turns into a sprawling mix of spaghetti-fied .NET code, T-SQL stored procedures, and developer tears.

TJ L. inherited an SSIS package. This particular package contained a step where a C# sub-module needed to pass a date (but not a date-time) to the database. Now, this could be done easily by using C#’s date-handling objects, or even in the database by simply using the DATE type, instead of the DATETIME type.

Instead, TJ’s predecessor took this route instead:

CREATE PROC [dbo].[SetAsOfDate]
        @Date datetime = NULL
AS
SELECT @Date = CASE WHEN YEAR(@DATE) < 1950 THEN GETDATE()
                                        WHEN @Date IS NULL THEN GETDATE()
                                        ELSE @Date
                                END;

SELECT CAST(FLOOR(CAST(@Date AS FLOAT)) AS DATETIME) AS CurrentDate

The good about this code is that it checks its input parameters. That’s defensive programming. The ugly is the less-than 1950 check, which I can only assume is a relic of some Y2K bugfixes. The bad is the `CAST(FLOOR(CAST(@Date AS FLOAT)) as DATETIME).