text:
A Covelo man died January 29 after being hospitalized for injuries suffered during a fight at a Covelo market on January 20. The Mendocino County District Attorney's Office is currently reviewing the case to determine whether to file charges.
The deceased, Kevin Harlan, 46, was taken to an out-of-county hospital for treatment following the altercation. Harlan was "recovering in the hospital when he suffered another medical emergency and died as a result," according to a press release from the Mendocino County Sheriff's Office.
The incident began at the deli counter at Keith's Market in Covelo. Deputies determined that the two protagonists, Harlan and Samuel Franco, 36, of Covelo had a prior "unfriendly relationship." Both men were shopping at the market just after 2:30 p.m. January 20.
Franco was standing at the deli counter when Harlan walked up to him to stand very close. The two men exchanged a series of "unpleasant comments" leading Franco to extend the side of his arm to move Harlan away, says police. "This prompted Harlan to slap Franco in the head with a glancing blow."
The argument escalated and Franco allegedly "punched Harlan one time in the face with a closed fist. Harlan immediately fell to the ground and remained there for several minutes in an unresponsive state," says MCSO Lt. Greg Van Patten.
Covelo Fire Department and Ambulance Service arrived quickly to treat the unconscious Harlan. Once he regained consciousness, Harlan refused further medical treatment. Deputies were interviewing witnesses, and Franco filed a citizen's complaint against Harlan for battery.
Acting on Franco's complaint, deputies handcuffed Harlan and took him into custody. As Harlan was being placed into the back of the sheriff's vehicle he began showing further signs of medical distress, and was transferred to the care of Covelo medical personnel for transport to the hospital for treatment.
Anyone having further information about the incident is being asked to contact the sheriff's tip line at 234-2100.


text:
Work Shoes, Stl, Mn, 9-1/2, Walnut, PR
JOHN DEERE| Zoro #: G0185893| Mfr #: JD7323
Zoro #: G0185893Mfr. Part #: JD7323
$139.50 /pr
This item ships free. DetailsStandard ground shipping
Technical Specifications
|Zoro #: G0185893 Mfr #: JD7323
|Footwear Closure Type: Lace Up
|Metatarsal Guard: No
|Outsole Material: Polyurethane
|Liner Material: Moisture Wicking Nylon Mesh
|Item: Work Shoes
|Midsole Material: Polyurethane
|Toe Type: Steel
|Max. Heat Rating: Not Rated
|Standards: ASTM 175/C75
|Shank Material: steel
|Color: Brown
|Footwear Style: Dress/Casual Low
|Height: 3"
|Gender: Men's
|Footwear Sole Pattern: Cleated
|Insulated: No
|Waterproof: No
|Size: 9-1/2
|Footwear Width: M
|Country of Origin (subject to change): China
Product Description
This pair of work shoes from John Deere will help keep your feet dry, comfortable, and protected. These work shoes feature a steel-toe and a cleated sole pattern. They come in a walnut color, are size 9-1/2 and 3" tall. Standards include: ASTM 175/C75.

subset: commoncrawl


text:
NEW YORK ( TheStreet) -- Popular searches on the Internet include Starbucks ( SBUX) as the coffee shop retailer reported fiscal first-quarter profit that rose 13%, in line with analysts' estimates. The results were driven by sales increases in the Americas and a 6% rise in sales at stores around the world that have been open at least a year. Starbucks said it earned $432.2 million, or 57 cents a share, in the quarter, up from $382.1 million, or 50 cents a share, a year ago. Revenue rose 11% to $3.8 billion. Analysts had been looking for revenue of $3.85 billion and a profit of 57 cents a share. CEO Howard Schultz has been trying to boost sales and turn around the company where it has struggled. Starbucks has closed weak stores in the U.S., focused on accelerating growth overseas in countries like India and Vietnam, developed its own home brewer system, the Verismo, and expanded beyond coffee with juice and baked goods.
Vine is trending as Twitter has unveiled its new video-sharing application. Through Vine, users can record videos up to six seconds in length and then post and share them on Twitter. The videos will run on an endless loop similar to GIFs. Twitter hopes keeping the videos short will make them more conducive to sharing and originality. "Like tweets, the brevity of videos on Vine, 6 seconds or less, inspires creativity," said Michael Sippey, Twitter vice president of product. Vine is currently available on the Web and on iOS, thought Twitter said it is working toward bringing the service to other platforms. Users can download the app from the Apple App Store. Users don't have to have a Twitter account to use Vine.
Microsoft ( MSFT) is another popular search. The company reported second-quarter results that missed on revenue but topped analysts' earnings estimates. Microsoft attributed record sales numbers to the introduction of Windows 8, the revamped PC operating system that was introduced on Oct. 26, 2012. The company said its Windows division reported revenue that climbed 24% from a year ago to $5.88 billion.
- Log In
- Newsletters
Access insights and guidance from our Wall Street pros. Find the product that's right for you.
- Action Alerts PLUS
- Daily Swing Trade
- Income Seeker
- Quant Ratings
- Real Money
- Real Money Pro
- Stocks Under $10
- Top Stocks
- Trifecta Stocks
- Real Money Pro Portfolio
- Chairman's Club
- Compare All


text:
Will the Real Sean LandersSunday, July 4th, 2010
Is the impresario of Slacker art really a slacker?
The daisy chain of slackers in the Richard Linklater film are determined to withdraw, to sit it out, to pass. "Withdrawal in disgust is not the same as apathy," they chant.
The slackers in Slacker are immobilized by the repetition and interchangeability of themselves and the world around them, where they find only morbid indifference. Hence, the script swipes Joyce: "If he had smiled why would he have smiled? To reflect that each one who enters imagines himself to be the first to enter whereas he is always the last term of a preceding series even if the first term of a succeeding one, each imagining himself to be first, last, only and alone whereas he is neither first nor last nor only nor alone in a series originating in and repeated to infinity."
And when the world stirs from its icy disregard, it responds with hostility. In Slacker, society entails that men will traumatize women, women will "fuck you over," travel is dangerous, and war is so inevitable that activists can't keep up with their protest graffiti. Everyone else just trades in his soul for work in one assembly line or another, even just to make Subway sandwiches. "Every single commodity you produce is a piece of your own death," hisses the creepy chainsmoker straight out of prison.
"My original idea was to make conceptual art entertaining, sloppy, emotional, human and funny. Over the years I got so far out on this conceptual limb that I went around full circle until I was a traditional artist again. I tried to be ironic about it but eventually became sincere. Now I'm a happy victim of my own charade. I figure that it's better to be a sucker who makes something than a wise guy who is too cautious to make anything at all."
His world still hasn't acknowledged its greatest living artist, him. It is as frustrating as the bouncer not letting the rock star into the hotspot nightclub. Through his prolific output of paintings, drawings, writing, sculptures, and videos, Sean Landers has vented his rants, diatribes, and ramblings. The result is a cacophonous echo chamber of fanatic opprobrium. The razor-edged tool he uses to relay his chronic skepticism works more like a boomerang than a frisbee. He has devalued the world around him – "us" – for neglecting his genius, but then defames that same genius with the fervor of a chimp grooming Pigpen.
New Museum seems close, but maybe too close since Sean Landers bought his loft from the estate of Marcia Tucker, the museum's founder (who once curated a show on Bad Painting). Spiraling toward the heavens, the ramps of the Guggenheim would herald the advent of the self-identified greatest artist of all time, and the sense of infinitude when combing through his endless volumes of legal-pad works – while mimicking the downward spiral of too much introspection.
P.S. Another quote from Slacker: "Because I mean, like it's some sort of spiritual hell to parody yourself at the hight of your ridiculousness. So the guy's got to get up every day, get as fat as he was, and just make fun of himself all day long. isn't that a killer job – don't you think that's what all old people do…once they get over twenty-eight?"
Out soft while face much these I growth. This I http://pharmacyinca.com/ and that find, TO for ingredients and feels because Brazillian.


text:
Topic: Sorafenib Tosylate and Erlotinib Hydrochloride in Treating Patients Wi
cholangiocarcinoma.org :: Cholangiocarcinoma Foundation Discussion Board
a resource for patients, friends, caregivers and loved ones.
You are not logged in. Please login or register.
|La fundación de colangiocarcinoma (CCF) ahora ofrece servicios de traducción en Español.
Por favor publique sus preguntas en Español y un intérprete le va responder.
Join our new Mentoring Program
A new discussion board experience is coming this September!
After 10 years, we're upgrading our discussion board to a new modern system. The new forum will be easier to use, mobile-friendly and loaded with new features! We'll be taking all of the existing posts and users over to the new board, you won't have to do anything. If you have any questions, we've started a thread here to discuss.
Cholangiocarcinoma Foundation Discussion Board → Clinical Trials → Sorafenib Tosylate and Erlotinib Hydrochloride in Treating Patients Wi
Thanks so much for this info, Marion. Am having no luck getting through on either of the phone numbers...!
1. Basic question:
2. Can patients ever use these medications/drugs even if they are not participating in a trial? Meaning, what is the situation with off-label use of drugs? How can a patient get this?
In January, we did ask my mother's Sloan-Kettering oncologist about these two drugs (anti-angiogenetics, if I remember correctly??)- and numerous others, older chemos, new things, all found in our research- he seemed reluctant to recommend any for her due to "side effects"???
3. Last, any basic tips on how to get into a trial???
Thanks so much!!!!!!!
The trial contact information has not been activated. You might want to contact the Principal Investigator: Anthony B. El-Khoueiry, MD USC/Norris Comprehensive Cancer Center
Ph: 323-865-3967; 800-865-0102
Email: email@example.com.
This is a multicenter clinical trial therefore, I assume that you might be able to find a physician close to your Mom's home. That is of course, if your Mom's fits the criteria. Let me know if you need any help.
Regarding the off-label drug use: From what I understand, many cancer drugs are used off-label (if not most.) You might pose this question to another physician actively working with CC patients.
Good luck and please, keep us posted.
Best wishes coming your way,
Very helpful, Marion. The fact that it is not yet open is GOOD- gives us time to learn, apply, etc.
In Stage 2, do half the patients get nothing??
I have a feeling there is something wrong with USC-Norris' phone lines- I got through to his office from the USC-CARE number...
I have spoken to a number of people I have reached there- they are saying that my mother would have to see Dr El-Khoueiry... will hear back soon I hope, as the multi-site designation leads me to believe that may not be true.
Need to talk to him or the N-P about this.
Meanwhile, we plan to show this trial to my mother's current docs- maybe that will convince them to allow her to give one or both a try, if she wants that.
VERY HELPFUL, Marion, I cannot repeat enough.
Is there a good place for me to trace a story like this about investigating a clinical trial on the CC.org site so others can learn from this??
Why don't you send him an e-mail. Yes, you might have to see Dr. El-Khouery however, where are you located? This is a multicenter study, SWOG approved therefore, numerous other centers will participate in this clinical trial.
Absolutely, you should discuss this with your Mom's physician.
Everyone in this study will receive the same medications.
You might want to familiarize yourself with the clinical trial process. There are several links on our site or, you might want to go to the NCI site.
First and foremost, the criteria will be the deciding factor for your Mom's addmittance to this trial. Therefore, you will need to speak with a physician. You are doing just fine with your postings however, if you prefer you may just start another one please, feel free to do so. We are learning as we are going. Thank you for thinking of us.
Good luck,
This just came up. You might have already seen it however, here is the link. (just in case.)
http://www.cancer.gov/cancertopics/fact … cal-center
Hi Marion,
I have now talked to person at NCI hwo gave only very general help, and am still waiting to hear back from Dr El-Khoueiry's nurse-practitioner about the specifics of this trial.
Looking carefully over the eligibility requirements, one thing is looking very important- participants must not have had ADJUVANT or NEO-ADJUVANT chemo in last 6 months. I am not exactly sure what this means- my mother has been on chemo since Dec 24, 2009. It is her PRIMARY treatment.
Also, the many bone mets she has may make her cancer "UN-MEASURABLE."
And, obviously, her blood values could be off.
I am trying to pre-vet all this so we do not rile her up about all this for no reason. Her local oncologist is also a bit balky about things.
I think we may end up just trying to get access to these drugs off-label somehow... but it takes the right doctor to accomplish that. This is all so complicated.
[My mother refuses to travel around looking for help- it has to be a really good prospect to get her out the door and on the plane again... She and my father live in Florida; I live in SF CA. She has already been to Sloan Kettering (in Nov and Dec) to get the initial diagnosis confirmed and the first treatment plan. She is on gem-cis-- will hear if it is working soon.
My father seems think that Dana-Farber has some good promise.
I have had a hard time trying to distinguish among the cancer centers' relative expertise on very advanced cases of CC. Ideally she needs help with the bone mets...]
Anyway, I always feel as if we are going around in circles!!!!!
Thanks to you for all your help and to all the others who post and share so much.
God bless you all.
Final Chapter to the Clinical Trial story:
I reached a "trial nurse" at USC-Norris, LA about the upcoming CC trial led by Dr El-Khouiery ( presenting at the May conference, btw).
My mother is NOT eligible because she has had prior systemic treatment (chemo) to her metastic CC.
It was good to be able to reach someone who could help me decipher the eligibility requirements listed on the clinical trial abstract.
I also asked about research on the small (less frequent) cancers: she said that docs do it partially because it can yield interesting info about the larger cancers.
As to use of off- label drugs and therapies, she said it is legal, but that insurance does not usually cover it.
She suggested that I try to get a referral to a doc with good knowledge of cc nearer my mother (who is in Fla) from Dr El-Khoueiry, via the USC-Norris referral department (we shall see if the system works!!).
While this may seem like bad news, the conversation was supportive, helpful and informative. I feel much more "plugged in" and hopeful that here may be a way for my mother to access some other treatments.
Next Story will be: getting a referral to a Creative, Compassionate and Careful doc with lots of experience with stage IV CC for a second opinion... If this story ever happens, it will be in a different section.
sharpeilover....I agree with you. Knowledge is power. It enables us to make decisions based on facts.
BTW, Dr. El-Khoueiry has extensive knowedge of this cancer and has published numerous studies on Cholangiocarcinoma. He would know whom to refer your Mom to. I hope that you will receive an answer soon.
You are very proactive something your Mom must truly appreciate. I wish you luck with with all further searches. Please, keep us informed as your information sharing is much appreciated.
I live in the North Bay; not too far from you.
Best wishes,
Wondering if anyone is on this trial?
My mom has just been diagnosed with CC in the last month and this Trial is being suggested. It does not look like anyone has posted in a while and I wanted to see if anyone has participated or knows anything more about it other than what the doctors are telling us. I will go to the intro tab later to introduce myself. Does not appear to be much in the way of a cure. They told her 1 year with no treatment, is this typical? She has no physical symptoms yet?
Sidig...hello and welcome to our site. Hopefully, someone will come forward and answer your question regarding the above clinical trial. Although, you have been given a general time line, on this site, we continuously have seen people far surpass the physician's prognosis. Therefore, we stay optimistic and realistic. Have you consulted with another specialist also?
Please, tell us more. The members on this site are always ready to lend a hand.
All my best wishes,
Marions, thank you for the Welcome. She has has all her tests done with MD Anderson (Orlando) up till now. We have an appt. next week with Mayo (Jax) for a 2nd. We are supposed to find out if she qualifies for the trial tomorrow and anxious to start any kind of treatment. She was supposed to start chemo but then the trial talk started. Like many others the lack of treatment protocols is frustrating. we were told Chemo won't "treat" her just fight off anywhere else the cancer may be. I missed her last appt. and frustrated she did not ask what their actual recommended "treatment" will be outside of systemic focused Chemo. I'll intro on the introductions page and look forward to talking with others. I am trying to get my mom on here to share and learn from those bravely battling, but we will see. Blessings!
Hi Sidig,
My Dad is on this trial. Unfortunately, last week he had a bleeding ulcer, was hospitalized for 5 days and has stopped the medication. He is having a CT scan tomorrow and has an appointment next week with his oncologist. At the appointment, he'll see if he resumes the medication...maybe the dose will change? I like the idea of options! In December,while on this trial, my Dad had a scan and the doctors said the tumor shrank, a tad.
Please let your Mom know that my Dad had cc 15 years ago.
Thirdone, thank you for that very good to know. My mom starts the trial today in Orlando, fingers crossed and prayers for a positive outcome. Trying to keep her hopes up but difficult.
I noticed you put your Dad had CC 15 years ago. How was he treated then that he was able to keep it away for so long?
Hi Sidig,
My Dad met with the oncologist today. They are starting him back on the trial. The ulcer might have been caused from ibuprofen. Prayers for your Mom and please keep us updated.
Thanks, Thirdone
Thirdone, Great to hear your dad has started up again, "hopefully" the Ibuprofen was the culprit! My mom's spirits are up this week after starting the medication on Monday AND what I think is good news (and more importantly what she sees as good news) is...last week they had her re-take all the tests she had to diagnose the CC (PET Scan, bloodwork, etc. ) to establish the baseline for the Trial and she was told they did not see any percievable growth in the existing tumors!! Her attitude for now has really changed for the positive, so we are happy for this and starting treatment. Still good but told she probably would not start experiencing much in the way of side effects until the 2nd round of treatment.
How long has you dad been in the study? How long until he started experiencing any side effects? Do you know if they would allow him to take Vitamin D3 or would this be off limits while in the study. Mom is going all out to eat healthier (although I am encouraging her to eat MORE). I cant' say I agree with the limited food intake she is following but whatever make her feel better is good for me. She has many friends who care a great deal, sharing pos. experiences of other survivors and encouraging her to do supplements, teas, etc. and this worries me because I want her to trust the doctors until a time we need to try other alternatives. Any suggestions on how to work with her on this type of intervention?
Hi Sidig,
My Dad started the trial in October. He told me that he is on his 5th cycle. Two weeks after he began the trial, he had a pinpoint rash. (the rash never bothered him...located on his back and belly) Shortly after the rash began, the skin started to peel on his fingers & toes. Also, his heels were tender and at times, he felt cold. He has started and stopped the trial twice. Once, to have a stent put in and than two weeks ago, he had the bleeding ulcer. He does drink tea. He eats a regular diet, no alcohol.
As for the additional information from friends, the internet, etc...maybe your Mom could write down the ideas, and share them her doctor.
Glad to hear your Mom's spirits are up!
Great news! After the first 2 months of treatment on this trial we learned today there has been a 3% reduction. Mom is a "reserved" happy, she wanted it gone. Obviously that was not an option after 2 mos, but she is doing well and still only minor reactions (mainly just a rash on her hands). She is lucky enough to be continuing the trial for another 2 mos. Slow but sure is the course. Any reduction or no growth is a blessing!
Sidig....We have learned to appreciate the word "stable" and are thrilled to hear "reduction." It appears that your Mom is only experiencing minor side effects. May the good news continue.
All my best wishes,
Hi Sidig,
Thanks for sharing your mums great news with us, we love hearing news like this! Glad to hear that your mum is feeling well and has only minor reactions, and hopefully the next 2 months of the trial will go equally well and be successful also. And yes, any reduction or no growth is indeed a blessing.
My best wishes to you and your mum,
I have a question for anyone in this trial....my mom has been in this for about 8 months and happy to say she is holding her own, not much in the way of side effects although there have been some, (I would consider minor in regard to what chemo would bring). Her growth(s) have not been increasing and have possibly gotten a little smaller. Waiting on next scan as one did show some increase however with others "possibly" smaller they think it the scan may have been off a little bit and did not measure the exact "slice". Her Ca 9-19 number have been up or down....back in Dec.2010 when diagnosed it was around 48. Up and down since and up to 150 now. Most times up or down only 5 or 6 points. She is a little discouraged right now...probably more time to think about things after the 6 or 7 trips she has taken the last 9 mos however she asked me to write. I think this is minimal movement however the 100 point up since starting is freaking her out a little...is anyone experiencing Ca9-19 up and should this be any type of alarm.
Thank you in advance
Sidig....I have been told that variations of the CA 19-9 are to be expected. Five or six points don't mean much and easily could be dismissed. A consistent rising of these markers however, may (and I emphasize "may") indicate progressive disease only when substantiated by other test results. It is the trend (upward or downward) that the physician will look for. I so much understand your Mom
Marion, thank you for the clarification, you help is soo apprecatiate. It looks like they verified two of the tumors shrunk but the 3rd had increased a little and with the new blood test the increase in CA-19-9 is apparently to much....they are taking her out of the study and recommending the start of Chemo, mom is verifying what drugs but i think the standards I have seen hear are what they are moving forward with.
I have a question though....her doctors are saying SHE is "free" to find another study to try and how far she is willing to travel or come back in two weeks to start the Chemo. They said they do not have the time or resources to assist in finding anything else other than the Chemo....is this normal....no more use to the study so on to the standard route....is this typical?
The information expressed is not medical advice. The discussion boards are not intended to replace the services of a trained health professional or to be a substitute for the medical advice of physicians or other healthcare providers. Read the full disclaimer.


text:
Editor's Note: We want to thank Drew Lerner, Doane's weather consultant and President of World Weather Inc., for allowing us to share this version of a special report he sent to commercial clients last week regarding early frost risks.
Worry over the potential for early frost and freeze conditions in North America has started to rise significantly in the commodity trade this week and rightly so. With crops planted late and maturing late, there is potential for notable crop production cuts in a seasonably normal frost and freeze event, let alone one that is earlier than usual. It caught my attention as a meteorologist big-time when the low at Bismarck, ND sank to 39 degrees on July 26!
Weather patterns this summer have not allowed the Northern Hemisphere to warm up normally and reports from the arctic suggest ice accumulations are way ahead of recent years. A recent report from the polar region shows the number of above freezing days this summer was reduced by nearly half. These issues, along with the ten-day, 30-day and 18-year cycles all add merit to the mid-July CFS model prediction for a couple "threat periods" for early season frost and freezes in September. (But I must caution the CFS model "track record" for accurate temperature forecasts six weeks in advance is not very good.)
Other early warning signs: Low temperatures Aug. 14th in portions of Wisconsin and Minnesota slipped to the middle 30s, the day after similar lows occurred as far west as northeastern North Dakota. This cool period also followed some patchy soft frost reported in a few Saskatchewan, Canada locations a few days before that. It had been roughly three weeks since the last bout of unusually cold nighttime lows (18 to 19 days to be precise). Normally, when unusually cool weather patterns occur in late summer, observing the rhythm in which the cold bouts occur can sometimes be the best indicator of when the next bout of cold will arrive. If that is true in this case, the first days in September will need to be closely monitored for the next bout of coolness in Canada's Prairies and/or the northern U.S. Plains.
The 18- to 19-day interval between cold shots is also close to the second occurrence of the 10-day cycle, which fits well in the general timing of weather events in the atmosphere. But again, I must caution that predicting the first frost and freeze event of the year is one of the greatest challenges put to a meteorologist and/or climatologist since it requires predicting temperatures within two to three degrees of accuracy 6 to 8 weeks ahead. And the difference between a damaging frost or freeze event and one of only minor consequence to yields is often determined by a degree or two in temperature. But with that said, there are a number of issues that need to be discussed in this report that reinforce prospects of early season frost and freezes.
1974 Should Not Be Forgotten. Many parallels to past years are often tossed about when weather becomes extreme and one of the years of comparison for 2013 has been 1974. Much like this year, planting of many spring crops was late due to a cool and wet weather pattern. Crops were far behind in their development most of the growing season. And like this year, there was then a short term bout of warming and generally favorable mid-summer weather and crop conditions improved. But there was a Labor Day weekend freeze that was devastating. And this year the similarities to '74 don't stop with a wet spring and late planting. Summer 1974 turned drier than usual in the northern half of the Plains and in a part of the upper Midwest. Just like this year, the drier biased areas included the region from Kansas to North Dakota, including western Iowa. The driest areas this year were a little further to the east and north over those in 1974, but similar enough to be a valid analog. The key difference is that the cool weather in August 1974 was mostly in the Plains, Midwest, Delta and southeastern states, whereas this year the coolest area has been the upper Midwest, Great Lakes region and immediate neighboring areas.
World Weather, Inc. is not "predicting" a '74-like freeze. We're just noting that the atmosphere was in a cooling mode back then as it is now. The similarities are so strong we cannot write off the '74 freeze as a fluke. Even the solar cycle was trending in the same direction of reduced sunspot numbers similar to that we've seen in recent years. There have also been reports of earlier than usual ice accumulation in the higher latitudes in the polar region. Both of these observations reinforce the thought that 2013 warming in the higher latitudes failed to occur as normal, leaving the arctic with greater than usual amounts of cold air for so early in the coming cool season. That cooler-than-usual air in the arctic will be funneled to the lower latitudes, periodically when strong ridges of high pressure build up around the Northern Hemisphere at times - forcing the colder air southward into crop regions.
Atmospheric cycles also suggest early and late September may be the more favored periods for threatening cold. These two periods are identified in the 10-day cycle. The fact that mid-August cold occurred 18 to 19 days after that which occurred July 26 suggests that if the cycle repeats again, the first days of September will represent the next more threatening period of cold for Canada's Prairies and the northern Plains. Another 18 to 19 days after that puts another bout of potential threatening cold into the north-central United States after September 22.
Concluding Remarks: The research referenced here raises some evidence that the bias may be tilted toward an earlier than usual frost and freeze event. The evidence of this is not totally convincing, but high enough that we wanted to make sure our clients realize "potential" for damaging freeze is higher than usual and to plan accordingly.


text:
Moderators: Timko, Fritz, Solty, Booter, Blake_T, Frank Delicious
masterbeato wrote:...900 feet, everybody is happy.
masterbeato wrote:...900 feet, everybody is happy.
derfernerf wrote:Sean - Thanks man, Today is pay day, and I think I'm going to pick up a leopard or buzzz (Or both) on my way home from school, and see how that works.
JR - Thank you so much, so many helpful tips. I can't wait to get out and practice. I noticed the flat footed thing when I made the video, time to work on that! Just so I understand, your staying focus less on my reach back, and more on my finish/snap? Then when that comes, I can work on my reach back? That makes total sense! PS: The video you linked, where they are playing is my home course
Now I'm bummed it's going to be in the 30's this weekend Keep the tips coming, I'll try to make a video focusing on the tips I've gotten so far, as like a "Am I doing it right" video. Thanks again!
Users browsing this forum: No registered users and 2 guests


text:
Sara Bareilles Chats About Working With Jonah Hill, and What Scares Her
Sara Bareilles has come a long way since we first heard her anti-love song "Love Song." Not only did she release her sophomore album, "Kaleidoscopic Heart," last year, but she's also joined the judges' table on this season of NBC's "The Sing-Off." Keep clicking as we catch up with Sara and chat about getting Jonah Hill to direct her music video, giving constructive criticism on "The Sing-Off," and more.
Wonderwall: Congrats on the success of your album "Kaleidoscopic Heart." What's your favorite song on the album to perform?
Sara Bareilles: That's tough. "King of Anything" is pretty fun for me because it's a big audience participation moment in the show, and those are my favorite moments. But in terms of a more intimate moment, "Bluebird" is actually one of my favorites to perform. I really love that song, and it's really fun to get to sing it because I haven't sung it very many times.
WW: Jonah Hill directed the music video for the album's third single, "Gonna Get Over You." How did that come about?
SB: We have a lot of mutual friends, and I've known Jonah for a long time. He had expressed that he was excited about getting into music videos, and I definitely volunteered to be his guinea pig. It just, it worked out, and it's one of my favorite videos I've ever done. It was so fun to make. Jonah's brilliant. He brings a lot of just fun, animated energy to set. It was a lot of fun. I would do it again in a heartbeat.
WW: It was your first time dancing in a music video. Was that nerve-wracking?
SB: There were moments that were nerve-wracking. It was just sort of fast-paced. Like, I wasn't uncomfortable doing the moves, but it was a lot to learn in a short amount of time, so there were times where I was just thinking about it, and I wish I had one more day under my belt to just really get the moves into my body.
WW: We saw you were involved with Tone Skincare's Backstage Pass this summer and went through your photo album on Facebook. Did you ever end up driving the tour bus?
SB: I don't know if I ended up driving this bus, but my dad has a logging business on the side up in Eureka, Calif. I grew up driving heavy machinery, so driving a tour bus would be, like, no big deal.
WW: Wow, we never knew that about you! What else don't we know?
SB: There's probably a lot that people don't know about me. I auditioned for "The Mickey Mouse Club," and I didn't make it. That's another thing.
WW: You're currently a judge on "The Sing-Off." How are you liking it?
SB: It's been great. It's been an amazing learning experience for me. The world of television is brand new to me, so I feel like I was getting a crash course in how to be on TV. But it was really exciting. It's a totally new frontier for me, and the level of talent that they got for the show was just amazing. These groups blew me away, so I really felt like I was a part of something that was really special. And I love the other judges. I love getting to work with Ben [Folds] and Shawn [Stockman], and Nick [Lachey] is such a great person as well, so it was really a lot of good vibes on the set. People genuinely really like each other, so that's always fun to go to work then.
WW: Is it difficult for you to give constructive criticism?
SB: Constructive criticism is not as tricky as when you can't find something positive to say. But luckily on the show, I don't feel like I have that problem too much, where you're racing to figure out anything positive. I've been the recipient of [constructive criticism] from music directors and producers my entire career, and so you can see how effective it can be when someone delivers the message in the right way. Then, of course, it's just going to make you better. So I think that's the easier part. It's harder when you can't find something great to say.
WW: Between "The Sing-Off" and touring, you're always on the road. What do you bring with you to make you feel at home?
SB: I always bring my journal with me. I'm somebody who still keeps a diary. I don't have a lot of material things that I bring with me to make me feel like home. It's more about the people around me. My bandmates and my crew are some of my very best friends, so it sounds really cliche, but really they do make the road feel like home. I don't have a lot of my possessions that I carry with me, other than my journal, which I don't leave home without. I have about 10 journals over my lifetime.
WW: What do you do to wind down when you have time off?
SB: Exercise is a big thing for me. It's a wonderful de-stresser, kind of gets me in touch with feeling grounded, and feeling like I'm in my body and I'm not being too cerebral or overthinking things. And I love getting outside into nature, taking a hike or taking a run in the park or on the beach or something. That's all really, really important. Yoga class is always good, too. It's usually some sort of physical exercise that makes me feel de-stressed.
WW: You've performed for Michelle Obama a number of times. What was that like?
SB: It's amazing! It's a huge honor to have been invited in the first place. I could not have been more excited about being welcomed into the first family's favor. That was very exciting. It's definitely surreal to be in a political environment. The security is insane. There's a lot of very intense energy happening, but I will tell the stories to my grandkids. I'm just so, so excited that that's something that I've gotten to experience.
WW: Did you guys get a chance to sit down and chat?
SB: We had lunch when I did the G-20 Summit. We had lunch with all of the first ladies and the first man of all of the countries that are invited to that summit, and I sat next to the first lady. We had wonderful conversations. I mean, we're at a table of 10 women, and it's interesting to see how some of these political figures' spouses connect with each other, what they talk about. There are sometimes language barriers where everyone has an interpreter. It's really fascinating to see how it all kind of comes down.
WW: Thanksgiving is coming up. What are your plans? Do you have any special holiday traditions?
SB: It's really mostly about everyone making time to come together. I have a lot of friends who have the golf tournament or the football game or some sort of family tradition in that way. We really just eat a lot, and [I] see them all day long, for like three days, which I love. That will make me go home anytime. So I'm going to go up to the Bay Area, and spend time with family and see my grandpa that I haven't seen in a while, and we're going to have Thanksgiving at his house this year.
WW: Since 2011 is wrapping up, what New Year's resolutions do you think you'll make for 2012?
SB: I usually have to meditate on that for a little while and see what comes up for me. I think making time for myself is going to be an important one, but I don't know exactly how to implement that yet. Last year, I did "no buying anything" for the first six months of the year. So I didn't buy any clothes or any makeup or any personal items. It was actually really good for me; it got me out of the consumer mode. I made it through six months and then I had to go on tour, so I had to buy clothes for tour. I sort of fell off the wagon.


text:
This is what we need in the next 8 games to exceed our start of 37-15 last year, before the slump began.
@ Washington
LA Lakers
@ New York
@ Toronto
This team also has precious little left to prove. IMO, this is what we should shoot for as our remaining goals this season:
- 59 wins, exceeding the franchise-best record of 58-24
- beating the Lakers
- beating the Kings
And then, of course, a trip to the NBA Finals. And hopefully, a championship. :


text:
Cheese Crackers and Straws
Makes 60 or more
1 1/2 cups Jeanne's Gluten-Free All-Purpose Flour (see recipe)
1/4 teaspoon salt
1/8 teaspoon cayenne, optional
1/2 teaspoon dried thyme, rosemary or cumin, optional
6 tablespoons cold unsalted butter, in pieces
2 1/2 cups grated cheddar
1 cup grated Parmesan
1 extra-large egg
1/4 cup milk
1. Preheat oven to 400 degrees. Line two baking sheets with parchment paper.
2. In a food processor, combine flour, salt, cayenne and herbs; pulse a few times to mix. Add butter and cheeses and pulse until evenly mixed, about 1 minute. It should look like wet sand with pebbles. Add egg; pulse to incorporate. With motor running, pour in milk; blend until dough forms a ball. (Or mix the dough by hand, using a pastry cutter.) Divide dough into two equal portions.
3. For crackers, roll dough between sheets of wax paper to 1/8-inch thickness. Use a cookie cutter to cut 2-inch rounds; transfer to baking sheet, spacing at least 1/2 inch apart. Repeat until all the dough is used.
4. For cheese straws, pinch off a marble-sized piece of dough. Roll into a smooth cylinder about 5 1/2-inches long. Place on a prepared baking sheet, spacing them at least 1/2 inch apart.
5. Bake until crackers begin to brown around the edges, 15 to 20 minutes. Let cool in pan for a few minutes, then transfer them to a wire rack. Store in an airtight container at room temperature for up to 5 days.
— Jeanne Sauvage, "Gluten-Free Baking for the Holidays" (Chronicle, $24.95, 168 pages)


text:
Contact Us
1401 Charlestown Road
Phoenixville, PA 19460
800.432.8322 | 610.935.0450
1401 Charlestown Road | Phoenixville, PA 19460 | 610.935.0450
Explore the Bachelor's, Master's and Associate's Degree programs we offer.
Ready to begin the admissions process?
Not sure where to start? Navigating the Admissions Process
Need help figuring out the financial aid process?
Federal School Code:
Not sure where to start? Navigating the Financial Aid Process
Explore all the things to do and see on our sprawling suburban campus in Phoenixville, PA.
Explore the official website of the UVF Patriots to see sports schedules, up-to-date scores and headlines.
Get the latest news and happenings at the UVF news center.
see all news
see all events
Learn all about UVF from a parent's viewpoint.
Are you an alum of the University of Valley Forge? Our Alumni area is made just for you.
"Anyone can count the number of seeds in an apple but only God can count the number of apples in a seed."
Robert H. Schuller
In just a few weeks our grocery stores and garden shops will be filled with stacks of flower and vegetable seeds. Some ambitious gardeners will plant flats of plant possibilities and tenderly care for them inside long before the ground is willing to surrender to the blade.
I often stand in front of those packets of seeds with their pictures of limitless potential imagining what could be during this year's growing season. This may be the time to try growing watermelons or cucumbers or pumpkins.
A typical seed includes three basic parts: an embryo; a supply of nutrients for the embryo; and a seed coat. The embryo is an immature plant from which a new plant will grow under the proper conditions.
Seeds come in many different sizes. The dust-like orchid seeds are the smallest with about one million seeds per gram. The largest seed is produced by the Coco de Mer, or "double coconut" plant. The entire fruit may weigh up to 50 pounds and usually contains a single seed.
Unlike animals, seeds are limited in their ability to seek out favorable conditions for life and growth. A seed must "arrive" at a location and be there at a time favorable for germination and growth. When the fruits open and release their seeds in a regular way it is called dehiscent. When fruits do not open and release their seeds in a regular way they are called indehiscent.
When wind disperses seeds it is called anemochory. Maple and pine seeds have a wing that aids in wind dispersal. The dust-like seeds of the orchid are carried efficiently by the wind. Dandelion and milkweed have hairs that aid in wind dispersal.
When water disperses seeds it is called hydrochory. Some plants produce buoyant seeds termed sea-beans or drift seeds because they float in rivers to the oceans and wash up on beaches.
When animals disperse seeds it is called zoochory. Seed burrs with barbs or hooks attach to animal fur or feathers, and then drop off later. Seeds with fleshy coverings like apple or cherry are eaten by animals which then disperse these seeds in their droppings. Seeds in the form of nuts (acorns; walnuts; etc.) are an attractive long-term storage food resource for animals and some will escape uneaten because the animal forgets them. Myrmecochory is the dispersal of seeds by ants.
Of course, the gardener and the farmer must develop an acute acumen for dispersing or planting seeds. I can still smell the freshly prepared soil on our family farm as we loaded the grain drill and corn planter with just the right seeds to be dispensed with just the right fertilizer at just the right distance from each other.
One important function of most seeds is delaying germination, which allows time for dispersal and prevents germination of all seeds at one time. One of the most remarkable examples of protracted dormancy is a date palm which sprouted in 2005 from a seed recovered from Masada, near the Dead Sea in Israel. It is the oldest seed known to have been sprouted and is estimated to be about 2000 years old. The oldest documented seed to be grown previously was a 1300 year old lotus.
The economic importance of seeds is almost incalculable. Many seeds are edible and the majority of human calories come from seeds, especially from cereals, legumes, and nuts. The list is endless of the ways seeds are useful.
The Bible accurately says, "Whatever a man sows, that shall he also reap" (Galatians 6:7). In order to counter the law of sowing and reaping, I heard of some people who sow their wild oats all week and then go to church on Sunday to pray for a crop failure.
Yes, there is amazing power in seeds.
Think about it.
The University of Valley Forge is a private Christian University located in Chester County, Pennsylvania, 35 miles northwest of downtown Philadelphia. UVF offers on its sprawling park-like campus, as well as online, over 50 undergraduate and eight graduate degrees in the Arts, the Sciences and the Professions. The university's mission is to prepare individuals for a life of service and leadership in the church and in the world.
University of Valley Forge is a private Christian University located in Chester County, Pennsylvania, 35 miles northwest of downtown Philadelphia. UVF offers on its sprawling park-like campus, as well as online, over 50 undergraduate and eight graduate degrees in the Arts, the Sciences and the Professions. The university's mission is to prepare individuals for a life of service and leadership in the church and in the world.


text:
Departments that match this condition
Allergy and Immunology
Akron Children's offers diagnosis and treatment of allergic and immunological diseases for patients from birth through their teenage years. Our team conducts a variety of allergy tests other than skin testing. Therapy is based on your childs medical history and lab results.
Respiratory Center
Akron Children's Robert T. Stone, M.D., Respiratory Center provides services for patients with all types of respiratory illnesses, including allergies, asthma, cystic fibrosis, bronchopulmonary dysplasia, and chronic respiratory failure.


text:
Kid A (Special Collectors Edition)
US: 25 Aug 2009
UK: 31 Aug 2009
Amnesiac (Special Collectors Edition)
US: 25 Aug 2009
UK: 31 Aug 2009
Hail to the Thief (Special Collectors Edition)
US: 25 Aug 2009
UK: 31 Aug 2009
In 1997, Radiohead's OK Computer accomplished the seemingly irreconcilable twin tasks of lyrically addressing the alienation of a current youth generation (roughly those of us born in the 1980s), while sonically completing the guitar rock aspirations of a past generation (our parents). The overestimated association of OK Computer with Dark Side of the Moon speciously bridges this generational divide, but it also fails to address how much of a gulf that gap truly is. Although the interventions of punk, metal, rap, and electronic music suggest some continuum that links the youthful rebellion of the classic rock era to the way we live now, the cultural shift is too large to keep the relay running. Fittingly, the album's full-scale terrestrial panic is deathly but inviting as it bemoans the abyss and welcomes oblivion.
In the years directly following the rapturous reception of OK Computer, Radiohead wearied from the repetitive touring cycle, interviews and set lists. Grant Gee's documentary Meeting People is Easy, released in 1999, disproportionately featured this ennui and created a public image of disillusioned rock stars. Skewed personas aside, what becomes clear is that, as observers and interpreters of modern civilized society, the band (usually represented by front man Thom Yorke) seemed to have moved from a Douglas Coupland approach to that of Dr. Manhattan. Regarding new material, some of which appears in rough form in Gee's film, the band used most of its on-the-record comments to describe what the songs are not: They're not post-rock, not progressive rock, and not driven by concept or character. These various denials that built up around the band and its approach are frustrating because at some point the whole enterprise must be about something—after all, why keep making the music if there are no more aims and the returns have diminished to zero? What to do at a misanthropic low? Dr. Manhattan takes off for Mars, and Radiohead records Kid A.
Released in October 2000, Kid A is indeed the sound of beyond, of ascension, of a clean break with the conspicuously guitar driven mode the band perfected in the mid-to-late 1990s. There are endless millennial musings one could interpret, but the band's refusal to define (or even traditionally publicize) its new identity makes hot air of the analysis. Fundamentally, the band confronts the X, Y, and Z generations that it collected as followers in the last century with a year zero for their common musical era. This is a risk that resets expectations for what a rock album should be, and the risk is even more intense coming from possible heirs to the U2 big important rock throne. Additionally, while Kid A boldly refuses to capitalize on the success of OK Computer's accessible sound, the album does push the disturbed reactions to modern life in an even darker direction. So there is also the great potential for the album to be perceived as wallowing in the misery that Radiohead's detractors cite as the band's default mode.
Kid A marks the beginning of a reactionary period for the band. Confounded by reviews and unauthorized biographies that read more like hagiographies, Thom Yorke and multi-instrumentalist Jonny Greenwood, bass player Colin Greenwood, guitar player Ed O'Brien, drummer Phil Selway, and producer Nigel Godrich create, as Colin describes, an "acoustic-based record that has been digitally manipulated afterward". Much more could be written about the source of the sounds, but in the end that description suffices. Taking many listeners by surprise is the degree to which the band embraces what some might call the artifice of that manipulation. Godrich says, "we mainly used the Mac as an instrument to create new sounds or treat things to make new sounds rather than using it as a multitrack device."
In addition to an inventive use of Pro Tools and other hardware/software, another of Kid A's rich accomplishments is the band's utilization of instruments and inspirations that lie outside of rock's aesthetic and historical boundaries in order to create the sensation of newness. In some instances, such as the Ondes Martenot, even several-decades-old sounds are heralded as fresh. Also, though the overall worldview has not brightened, on Kid A Yorke concedes—owing debt to Dada—that words are often more effective as sounds rather than carriers of associative meanings. The execution of these elements could add up to something distant and overly intellectual if Radiohead didn't (despite itself?) retain a learned pop sensibility and unparalleled ear for beauty. Other exceptional deal-breaker albums like Lou Reed's angry Metal Machine Music or Sleep's exhausting Dopesmoker are magnificent in their uncompromised vision, but Kid A's synthesis of the unexpected fringe with traditional rhythmic and melodic points of entry is what ultimately elevates the album to the band's best and a true work of art.
An element that ties the far reaches of the album together is its intricate focus on cycles. Although the album does not have one overarching aesthetic, the repetition of lyrics and chopped up bits of recorded music (in addition to the yielding to digital processes) creates a convergence of meaning even when there is little traditional lyrical or musical development. "Everything in Its Right Place" is not a statement of purpose, but it accidentally becomes one. To look for deep revelations in Yorke's "yesterday I woke up sucking a lemon" and "there are two colours in my head" is to miss the point. The phrases sound like nonsense, and if the listener is not aware of the singer's sour mood following OK Computer, then the expressions are not connected to any concrete experience. Actual context isn't necessary, as the song's concluding, "What was that you tried to say? / Tried to say / Tried to say" expresses both the emotional paralysis of the songwriter and the confused reaction of the listener. At the risk of an abstruse interpretation herein, it seems that the rules for experiencing Kid A are so loose and varied it is not worthwhile to name them. Indeed, the enjoyment of each song deepens once the listener realizes that the woe is me alternative rock rulebook has been shredded.
Moving ahead with its unique manipulations, repetitions, and various cycles, the largely self-contained world of Kid A does benefit from occasionally touching upon associations that lead to what could be called a second tier of appreciation. The title track—a macabre lullaby/music box number with skittering percussion—drastically warps Yorke's voice in a way that compels the listener's close attention. The pairing of lyrics "we've got heads on sticks" with "you've got ventriloquists" is an inspired parallelism, and "rats and children follow me out of town" plays on the listener's remembrance of The Pied Piper of Hamelin. Structurally, the song adapts (in its third minute) a technique Yorke claims to admire in other electronic music—a break that mostly subtracts the song's beat and delays its return, to climactic effect.
In "The National Anthem", an unremitting eight-player brass section that forms around the bass riff is not so different from the guitars that swelled throughout earlier Radiohead releases. Falling even more within somewhat familiar territory is the luxuriant and mournful "How to Disappear Completely", on which strings weep and a bass line gently, reliably rises and falls. The ethereal quality of the song, and its satisfying crescendos, elevate what could have been just another song about how hard it is to be a touring musician. O'Brien's guitar on "Treefingers" takes on the character of a Brian Eno ambient work and provides an excellent comedown, as well as a segue to the album's second half.
Guitars are more recognizable on "Optimistic", another number that evokes the Radiohead of the past. Also, Selway finally has a chance to come to the fore. Not surprisingly, this is the album's highest-charting song on the Billboard modern rock chart. The song's structure is more traditional but festooned with experimental touches such as the Ondes Martenot and the brief but thrilling manipulation of Yorke's voice on "prison ship". The Shipping Forecast intro to "In Limbo" sets up a fantastic variation on the album's cycles, throwing the listener into the waves to be bashed about. While the repetitive guitar lines aren't violent in tone, they (along with Yorke's voice) eventually reach a maelstrom and wash away.
The one track on Kid A that guarantees to get the crowd moving is also one of its more poignant. "Idioteque" is a fantastic example of what Jonny Greenwood calls "making music with music". "Idioteque" resurrects two works—Arthur Kreiger's "Short Piece" and Paul Lansky's "Mild Und Leise"—from a mid-1970s LP called First Recordings - Electronic Music Winners. The sampling of small portions of those two pieces, particularly Lansky's four chords, leaves an ineradicable sweet spot in the listener's mind. A captivating contrast develops from the combination of a repeated, brief (in Lansky's piece, ephemeral) tonal section with a pronounced drum and bass pattern. Lyrically, the song could be about the end times or a natural or man made disaster, but again, the claustrophobic feeling they create is more important than their literal meaning. "Idioteque" forms a more direct connection with Kid A's violent landscape artwork than any other song on the album.
A domestic dissolution seems to inform "Morning Bell", in a far darker manner than the subject matter does on The Bends' "Black Star". Selway's drums are key to the song's propulsion, which is fitting since this is their last appearance on the album. Final track "Motion Picture Soundtrack" is perhaps the best evidence that Radiohead cannot resist indulging in the passionate and human, even on an album that was borne in part from a discomfort with emotional expression. Pro Tooling about with intricate beats and obfuscated vocals can manufacture feeling and meaning to groundbreaking effect, but there's no substitute for an organ, harps, and a heartfelt lead vocal. Although "Motion Picture Soundtrack" is in reality no more than the sum of its acoustic and digital means, it somehow feels more human than everything that precedes it. A song with finale written all over it, "Motion Picture Soundtrack" is a source of pathos and a vessel to the transcendence that has been hinted at throughout the album. Death is the song's focus, but the closing chorus of angels and final line "I will see you in the next life" indicates that this is not a depressing leave-taking. Something else is on the horizon. Life and death, too, form a cycle. Ambiguous in purpose, a "hidden" piece of music follows a long silence after the song's seeming final notes of resolution. The nothingness that precedes and follows this additional material it is in keeping with the album's impulse to retrain the listener's ear, even to the sounds of pure digital silence.
Rising Appalachia 'Alive' (album stream) (premiere) // Music
Lost Bayou Ramblers "Allons a Lafayette" (video) (premiere) // Music
Jean Caffeine "Winter of Hate" (video) (premiere) // Music
"No Dollars in Duende": On Making Uncompromising, Spirited Music
// Sound Affects
"On the elusive yet clearly existential sadness that adds layers and textures to music.READ the article


text:
201 N 29th Ave.
Monroe, WI 53566
View All »
M & D Truck and Equipment Sales, LLC is family owned and operated in Monroe, WI. Built from the ground up, brothers Mike and Dan Lambert opened their doors in 2001 specializing in resale of attachments and construction, farm, landscape and support equipment. It is our mission to provide a positive buying experience for your best value. Your satisfaction is our number one goal Learn more »
© 2012 M & D Equipment Sales, LLC.


text:
PERRYSBURG, Ohio (AP) -- Federal prosecutors say they've filed hate-crimes charges against an Indiana man suspected of starting a fire that damaged a landmark mosque in northwest Ohio.
They said Friday that charges filed in U.S. District Court in Toledo allege Randolph Linn of St. Joe intentionally damaged property because of its religious character and used fire and explosives to commit a felony.
Authorities say they found a plastic gas can in the middle of the prayer room damaged by the Sunday blaze at the Islamic Center of Greater Toledo.
They say a woman who identified the 52-year-old Linn on surveillance video told authorities he'd recently made anti-Muslim comments referencing an anti-Islam video and recent attacks on U.S. embassies.
The public defender for Linn's local court case wasn't available for comment Friday.


text:
THE SQL Server Blog Spot on the Web
Using a hammer to push in a screw isn't a good idea, no matter how good the hammer is. We all know that. and yet there are times when we get frustrated at the 'right tool' and opt for the one that will work. Unfortunately, there are plenty of examples in the IT space – the topic of which is this month's T-SQL Tuesday, hosted by Rick Krueger (@DataOgre).
There are many ways to use SQL. Having seen plenty of awful code over the years, and written plenty of it myself, I know that there are lots of ways to achieve the same thing, and there are ways to persuade the Query Optimizer to take one particular approach rather than another. These efforts might seem quite 'hacky' at first glance, but if there is good reason for them, then perhaps they belong.
For example, a couple of years ago (and then again a couple of weeks ago) I wrote about using views as a way of passing sets of values to a stored procedure (where the stored procedure is masquerading as an instead-of trigger). At the time, people told me it was quite hacky, and that they'd never use it. However, I've heard of other people (including Greg Low, who also blogs at sqlblog.com) using this same method for getting data into Azure using SSIS, because it just works, and it has a number of advantages over other methods.
Many look at string concatenation as another example of this, although some get attached to the wrong solution.
When concatenating strings stored across a single row, there is no issue – simply use the + operator, or a function like CONCAT().
It's when you need to consider data across multiple rows that you have more of a problem.
If there are a known number of rows in play, then performing a Pivot transformation can simplify the problem down to the single-line variety. I don't mind whether you prefer to use the PIVOT operator or not. Personally, I prefer not to. In this example, I take a simple set of unpivotted data, and do a basic pivot transform, using GROUP BY and CASE. These then form useful values for the CONCAT function.
Frustratingly, pivoting requires the values to be known, producing a known set of columns. Dynamic Pivot requires Dynamic SQL, but if this is being done, there's no problem to provide those values to a CONCAT function – though creating the Dynamic SQL probably requires a degree of concatenation in the first place!
There is a "Quirky Update" method for concatenation that has been touted a bit over the years, but I find myself completely unable to recommend it, based on the prerequisites listed to get reliable results. For me, I want the results of any query I write to be guaranteed, and to have a query which could end up producing the wrong results is simply too dangerous for my liking. I'd rather use a cursor than risk wrong-results, and that's saying something!
The method I like to use for string concatenation has its roots in a hack of sorts, and to explain why, I'll first describe the environment from which it has sprung – FOR XML PATH.
There are a few ways to generate XML from SQL. I find FOR XML PATH to be quite straight forward, although it can become overly complex when nesting comes into play (causing me to switch to one of the others). However, for simple examples, XML PATH is very effective.
The results of a simple query like this:
SELECT ProductID, Name, ListPrice FROM Production.Product ORDER BY ProductID;
can be turned into XML by simply adding a "FOR XML PATH" option at the end. Providing some additional parameters, we get results like the following:
You'll notice that the column names have appeared within XML tags. The interesting thing here is that we can manipulate this behaviour by changing the name of the columns, with aliases. For example, putting an @ in front of the column name causes the element to be treated as an attribute instead (I remember it as "@ for ATtribute").
Another trick with column names is that if there is none (or it's [*]), then the element tag disappears. Naturally this is way better than having "<>" appear in the resultant XML.
…but this behaviour of making the empty element disappear is part of the appeal.
I'm told that it was around the time of the development of this 'disappearing element' bit that the penny dropped and using it for string concatenation became an option.
Consider what happens if we only have the Name column now.
If we had no ROOT element, we wouldn't have legal XML…
…but if we used an empty string for the PATH element as well…
…now suddenly we have string concatenation (including the support for ordering), without having to resort to something which could fall apart at a moment's notice.
If we want commas included, that's easy, and if we want to convert it back into a string (instead of being XML, with XML-style quotes), then surrounding it with brackets (round ones, what Americans call parentheses) and putting .value('.','varchar(max)') at the end will do the trick.
Here, we've taken XML generation and turned it into a string concatenation operation in a very simple way. The SQL Product Group realised this potential quite early on, and this is widely regarded as the best way of doing concatenation from SQL Server 2005 on.
There are lots of other things that I've done over the years that might seem quite hacky, but are actually quite legitimate – but string concatenation is probably my favourite.
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
I have always done something like this below for quick string concatenation. Do you prefer the XML based approach upon performance or some other criteria?
FROM tempdb.dbo.sysobjects
WHERE ID = OBJECT_ID(N'tempdb..#source') )
DROP TABLE #source
CREATE TABLE #source (
col1 CHAR(1)
INSERT INTO #source
VALUES ('a')
, ('b')
, ('c')
, ('d')
, ('e')
, ('f')
, ('g')
String Concatenation
DECLARE @string VARCHAR(MAX)
SELECT @string = ISNULL(@string,'') + ',' + col1
FROM #source s
SELECT @string
Based on the fact that it's not supported.
Based on the fact that it can be affected by non-clustered indexes, parallelism, and other good things, giving 'incorrect' results.
Based on the fact that it's procedural and has no opportunity to be handled by the QO in a better way.
Based on the fact that you can't order the data how you like without risking the results.
If you must use code that moves through a result set in order like that, you should use a cursor. And that's saying something!!
I'm crazy and self-destructive, I guess. I know the performance advantages. I get the reasoning.
AND ... still I cringe when I see this XML concatenation trick. It's my childish idealism.
Still, great explanation of how to do it :-).
How do you handle it then, Merrill?
It is just AWESOME !!! I really enjoy it !!! Very smart the solution!!!
Thanks for the trick Rob.
I've used XML for string concat in SQL Server for a couple of years now, and it's always felt 'hacky' - but - yes, it really does the trick.
I rarely - however - put it into production code other than data migration or imports which aren't that time sensitive.
In other situations, I'd properly rather handle it with a combination of database/code logic as string concatenation often is connection to a business logic problem needing to be solved, more than an actual data problem.
Rob - I don't have to code much. We buy everything. If I had to code this I would probably cringe and write it as you show here. It's become sort of a best practice, but it's still not pretty :-).


text:
The back-to-nature movement has become mainstream in America, and nowhere is the desire for a more natural approach to living more prevalent than in our homes. From organically grown fruits and vegetables to VOC-free paint choices, the trend is toward fewer additives, synthetics and chemicals.
But for all the farmers' market food in the kitchen and goat's milk soaps in the bathroom, the quest for a more natural home has neglected the bedroom. However, it doesn't take much to make the bedroom more natural or green.
Following are three easy and effective tips.
Natural bedding
Down and feathers come from nature and are biodegradable and renewable. Consequently, they have the lowest carbon footprint of any bedding fill material. Thirty-six percent of U.S. adults use down and feather bedding because it is eco-friendly, according to a recently completed Harris Survey commissioned by the American Down and Feather Council.
A natural insulator, down helps regulate body heat for an optimal sleeping experience, which allows homeowners to turn down the thermostat at night and save on heating costs. The survey revealed that 55 percent of U.S. adults who use down and feather bedding have chosen it for its natural warmth.
Adding plants
Live plants act as natural air filters. Some plants – spider plants, Boston ferns, rubber plants and palm trees – are particularly effective absorbers of chemical pollutants emitted from carpets, furniture and electronic equipment. Adding fresh flowers and plants to the bedroom helps with the natural cycle of carbon dioxide and oxygen, improving the overall air quality.
Welcoming the sun
In the cold winter months, open blinds, draperies and shutters during the day to let solar energy warm and brighten the bedroom naturally.
In the hot summer months, be sure to do the opposite, closing window coverings to prevent the bedroom from overheating and causing air-conditioning units or fans to work harder, thus using more energy.


text:
Marketing Information
The Slim Cool is a 12 inch wide water-resistant and contaminant proof keyboard with tactile feedback keys. The sealed and rigid surface is ideal for industrial, marine, and medical use, as well as other applications where moisture, cleaning, and durability are a consideration. Because the Slim Cool is also quieter than "standard" keyboards, they are great for applications where noise generated from "key-clicks" is a problem. The Slim Cool is compatible with standard keyboard layouts and drivers are not needed. This keyboard can be equipped with our Magfix, SCOP and Backlit features.
General Information
|Product Type
|Manufacturer Part Number
|Manufacturer Website Address
|Man & Machine, Inc
|Product Model
|Slim Cool
|Product Name
|Slim Cool Keyboard
|Brand Name
|Man & Machine
|Keyboard/Keypad Connectivity Technology
|Keyswitch Technology
|Industrial Silicon Rubber
|Keyboard/Keypad Host Interface
Physical Characteristics
|Weight (Approximate)
|1.30 lb
|Keyboard/Keypad Height
|Keyboard/Keypad Width
|Keyboard/Keypad Depth
|Standard Warranty
|Lifetime Limited
This product is shipped only within Canada and Warranty valid for Canada only.
Computer Valley makes every effort to provide accurate specifications, descriptions, images and price on all products that are found on www.computervalley.ca
However for complete and updated descriptions, compatibilities, specifications and actual photo we recommend our clients to consult with manufacturer's websites or simply call us for proper clarifications. Computer Valley is not responsible and will not accept returns for items purchased that are not compatible with your system. Please ensure that you have verified compatibility and actual photo with your system by visiting the manufacturer's web site prior to purchase or give us a call to make sure what you are purchasing.
For more information, visit our Shipping and Return policy.
Computer Valley wants to provide you with the best and fastest possible service. We try to ship in stock orders placed before 2:00pm EST the same day. For in stock orders placed after 2:00pm EST they are usually shipped the next business day. However there are always exceptions. Please contact us prior to placing your order if you need your purchase by a certain date.
We ship by UPS, FEDEX, USPS, CANADA POST , PUROLATOR and LOOMIS from the nearest locations possible based on stock in hand.
Please note: Computer Valley reserves the rights to accept and cancel any order at anytime due to pricing error or any other reason. An email will be sent as a confirmation of the order status.
|Read Reviews Write Review


text:
The New York Rangers on Tuesday added physicality and (theoretical) scoring depth in the form of Ryane Clowe. They also got themselves another reason to worry about the salary cap.
The NHL trade deadline is 3 p.m. ET Wednesday.
— Jaromir Jagr: Best available player heads to Boston
Clowe, a two-time 20-goal scorer who, somehow, has none this season, cost New York a second- and third-rounder in 2013, plus another second-rounder in 2014 if they make the Eastern Conference finals or re-sign Clowe. If neither of those happens, the San Jose Sharks will receive a fifth-rounder.
At 6-2, 225 pounds, Clowe is big and tough. He also has a track record of success, but just 11 assists this season. He also carries a $3.625 million salary cap hit.
Putting aside Clowe's troubles, which have been exacerbated by horrific luck and injuries, he figures to help along a bottom six that never rebounded from losing Brandon Dubinsky, Artem Anisimov and Ruslan Fedotenko. New York, averaging a league-worst 2.26 goals per game, needs offense, and Clowe, counterintuitive as it may seem, helps in that area. New York somehow started Tuesday in the Eastern Conference's last playoff spot.
The trade also completes a nice run for Sharks GM Doug Wilson, who turned Clowe and third-pairing defenseman Douglas Murray into two guaranteed second-round picks, two potential second-round picks and a third-rounder. Both players are over 30, have struggled this season and are on track to become free agents.
Clowe waived his no-trade clause to join the Rangers and chose them over the Vancouver Canucks. Wilson, in a release announcing the move, called him a "tremendously respected player and teammate, and an individual of outstanding character," but noted that it was important to get value for a pending UFA.
If the Rangers do re-sign Clowe, it'll bring them closer to the 2013-14 salary cap, which drops from $70.2 million to $64.3 million. New York has more than $11 million in projected space at the moment, but they also need to work things out with RFAs Ryan McDonagh, Derek Stepan and Carl Hagelin in addition to dealing with Clowe. McDonagh in particular could seek a serious raise from his $1.3 million cap hit for 2013.
So, whether it's Wednesday or in the offseason, the Rangers have some choices to make—and they likely revolve around winger Marian Gaborik, who has one year left with a $7.5 million cap hit. After a 76-point 2011-12 season, he has nine goals and 10 assists in 2013 and was recently dropped to the fourth line, though he may have clicked with Mats Zuccarello on Monday night.
More immediately, adding Clowe means that the Rangers are likely to send Chris Kreider and/or JT Miller to the AHL.


text:
Manti Te'o is 1) a high-profile, naďve victim of catfishing or 2) a complicit puppet master in one of the best sports hoaxes since Rosie Ruiz attempted to win the 1980 Boston Marathon without breaking a sweat. That's what we've been led to believe.
He is neither of those things.
In a story that demands black and white, he wades in the gray margins. Te'o, until last week, symbolized what college football once was. He was the committed leader of the most storied team in the country. He stayed for his senior year to enjoy the college experience, to remain loyal to his teammates. A season for the ages followed.
Now, he symbolizes what big-time sports is: a reality show where there's no elasticity on excess. Like many, I have devoured stories about Te'o over the last few days, trying to get a better handle on how the man who nearly won the Heisman Trophy found himself knee-deep in one of the strangest stories in decades.
As someone who has watched "Catfish," the movie and the docudrama on MTV, it was easy to accept that Te'o was duped regarding the existence of his online girlfriend. Those who can cut and paste photos, are skilled at manipulation and starving for attention can pull off a scam like this. Sadly, it's not as difficult as it should be, and the laws don't really apply to this scheme.
Based on the Deadspin.com report, Ronaiah Tuiasosopo played Te'o for a fool, creating girlfriend Lennay Kekua with the help of others.
Te'o formed a relationship with her, based in spirituality and a lot of phone calls. He never met this loving girlfriend who seemed straight out of a Harlequin Romance. Never Skyped. Never FaceTimed. She would just show up as a blank black box on his iPhone, with the excuse that the problem must be on his end. There are preschoolers who would throw a friend out of a clique for not being able to FaceTime, one of many elements of this story that strain credulity.
He never questioned that his girlfriend, who said she graduated from Stanford and helped run a construction business, couldn't master simple technology. Or that after an horrific car wreck that threw here into a coma, she was diagnosed with leukemia.
I remember watching a Notre Dame game and listening to this story and thinking: Is he dating a cast member from "Revenge"? This story was straight out of a soap opera.
Te'o, who will speak on camera for the first time Thursday to Katie Couric, who shares the same agency as him, made a series of mistakes. Frankly, they are forgivable, if he would just come clean.
Te'o knew the nature of his relationship, and yet he admitted that he "tailored" stories to reporters. That doesn't mean he was behind the fraud. But it means he perpetuated it by not pumping the brakes. Tailoring is another way of saying lying. He's a college kid. And I am sure the attention was intoxicating and the idea of conceding he had been conned was hard to fathom. College kids get humiliated by a text message.
Still, he had told his father he had met Lennay in Hawaii. That led to his dad telling reporters, who, yes, deserve plenty of blame for not checking out the girl's death. Te' o said he regrets lying to his father but misled his dad because he didn't want to be given advice regarding the relationship.
Te'o is not a kid. But he's not a professional athlete with an army of advisers. He could have stopped this train from going down the tracks in December, which is when he now says he learned he was duped.
As a society, embarrassment is fleeting, even of this magnitude. Kim Kardashian survived a marriage that could have been timed by a parking meter. Snooki became a mom. Jonny Fairplay told contestants his grandmother had died as a strategy in "Survivor."
It's a sad reflection of our society that this ridiculousness has become so commonplace.
Had Te'o talked in December, told his story, fessed up to embellishments, he would be a lot easier to see as a sympathetic figure. But everything about this saga demands the suspension of belief, and that goes for Notre Dame, whose flimsy investigation comes off as amateurish and self-serving.
When Te'o sits down with Couric, the goal should be simple: Be honest.
It's easy to see how he got roped into this scam. However, he needs to admit that he gave this ride a two-handed push down the tracks.
If he does so, he will be forgiven. But not if he keeps playing the innocent victim.


text:
Asmara Baby Bodysuits are an Idakoos specialtiy! Idakoos has many things to offer. Whether you want to get a Asmara Baby Bodysuit for a special occasion, give a Asmara Infant Bodysuit as a present or need to represent with a funny Asmara Baby Romper during Holidays or Family and Friends get-togethers, Idakoos is sure to have the right Asmara Baby Bodysuit for you! Even if it turns out you can't find the right Asmara Baby Creeper with the perfect design for all those babies in your family and friends circle; Idakoos offers all of its children's Asmara Baby Bodysuits as Asmara Baby Bodysuits. Personalize any Asmara Baby Snapsuit the way you want to ensure the perfect gift.
Showing 1 - 24 of 35 Baby Bodysuit


text:
NetWellness is a global, community service providing quality, unbiased health information from our partner university faculty. NetWellness is commercial-free and does not accept advertising.
Monday, September 25, 2017
Erectile Dysfunction (ED)
Long term use of Paxil
Is long term use of paxil for premature ejaculation desirable? Is it neceassry to take Paxil daily or to be taken only only at the time of coitus.
Paxil appears to work best taken daily. There are no long term negative effects to my knowledge.
Allen D Seftel, MD
Formerly, Professor of Urology
School of Medicine
Case Western Reserve University


text:
Competition in the toy category is intense every holiday season, but it seems to have been ratcheted up a few notches this year, and Target was one of the companies doing the ratcheting. The company's aggressive pricing moves put it in close proximity to Walmart early in the season and more recently Target's toys were less expensive than Walmart's, according to a pricing survey conducted by Citigroup retail analyst Deb Weinswig.
"Target has promoted a consistent value message throughout the season and we believe the company has the lead as we approach Dec. 25," Weinswig wrote in a research report last week. "We performed our third toy pricing survey of the season and for the first time, Target was priced lower than Walmart on our basket of toys, even without including the 5% rewards discount!"
Weinswig noted that Target had narrowed and reversed the pricing gap with Walmart over the course of the holiday season to the point where Walmart's basket of toys is now 70 basis points more expensive than Target's compared to 180 basis points cheaper when the survey was first conducted on Oct. 21.
"Also, if you apply Target's 5% Rewards discount, the basket becomes 600 basis points more expensive at Walmart versus 340 basis points pricier in our 1st survey," according to Weinswig.
Walmart's toy pricing has been the subject of considerable scrutiny this season with Eric Johnson, director of the Center for Digital Strategies at Dartmouth's Tuck School of Business, calling the company a non-player in the toy category in a Bloomberg article.
"Most of their hot toys are out of stock and the stuff that is there is not low-priced," Johnson was quoted as saying in the Bloomberg article on price adjustments that took place at Walmart following Thanksgiving weekend.


text:
Release Date: Dec 03, 2012
December 1 – 30, 2012, every night from 11.57pm - midnight
Monthly Program is Organized and Supported by the Times Square Advertising Coalition
in Partnership with Times Square Arts
New York, NY- December 3, 2012 – A stunning visual message of peace will greet New Yorkers and visitors to the Crossroads of the World this holiday season as part of a synchronized program on over fifteen of the largest digital screens in Times Square. Yoko Ono's work, IMAGINE PEACE, will be featured nightly at 11:57 pm – midnight every night throughout December 30 as part of the Times Square Moment: A Digital Gallery, a presentation of the Times Square Advertising Coalition (TSAC) and Times Square Arts.
IMAGINE PEACE is artist Yoko Ono's worldwide initiative of anti-violence. In the film, "Imagine Peace" is written in 24 languages set over the tranquil imagery of a blue-sky background. The piece has now been transformed into a multi-channel work specifically for the Times Square Moment, and spreads the message of peace across Times Square's monumental screens simultaneously, filling the Crossroads of the World with 24 languages of the world. Yoko Ono said: "Every day for three minutes we will think of world peace together, watching this blue sky. I love you!"
Times Square Moment called upon the Art Production Fund, which specialize in bringing contemporary artists into our daily lives through installations throughout all our public spaces, to assist in the collaboration with Yoko Ono for the iconic digital billboards of Times Square. Each month the digital advertisers and the Alliance look towards the creative talent on tap in NYC to curate a new video.
Alan High, Chairman of the Times Square Advertising Coalition and President & General Manager: Spectacolor & Mall Divisions, said: "The Times Square advertising community is pleased to come together once again to give New Yorkers and visitors to the Square a reason to pause from the hustle and bustle and witness artistic creativity on the digital screens. It is a special honor to air IMAGINE PEACE and a fitting tribute to the holiday season and our hopes for the New Year."
Tim Tompkins, President of the Times Square Alliance, said: "John Lennon's 'Imagine' is the last song played on New Year's Eve just before 11:59 p.m., when the ball on 1 Times Square begins to descend. Yoko Ono's IMAGINE PEACE is undoubtedly a perfect match for the December Times Square Moment program as it taps into many people's hope for a better world, the sentiment of both the holidays and the New Year."
"Times Square Moment: A Digital Gallery" is the largest coordinated effort in history by the sign operators in Times Square to display synchronized, cutting-edge creative content on billboards throughout Times Square every night. The program, which premiered in May 2012, is organized and supported by the Times Square Advertising Coalition in partnership with Times Square Arts, the public art program for the Times Square Alliance, with additional partners of participating sign holders and artists. Creativity has always been at the forefront of the Times Square signs and their presence is now integral to the identity of this iconic public space. This level of sign holder commitment to synchronize their daily programs to feature cutting-edge art throughout the year is unparalleled.
Each night, Times Square becomes a digital art gallery through dazzling visuals on select billboards. Every show begins at 11:57pm with a "countdown" that signals the start of the 3 minute nightly presentation. Content changes monthly; selected works are announced in the weeks preceding the start of a new show as are the exact signs participating in that month's selection. Past artists featured in "Times Square Moment: A Digital Gallery" include Robert Wilson; Seoungho Cho; Vicki DaSilva, Surabhi Saraf, and Elly Cho; Erika Janunger; Takeshi Murata; and Bel Borba with Burt Sun and André Costantini. For more information on past projects, please visit http://www.timessquarenyc.org/times-square-arts/moment/index.aspx.
The following digital screens are participating in the December Times Square Moment: ABC Super Sign, American Eagle Times Square, Bank of America, CEMUSA, City Outdoor, Disney, JVC Screen, MTV 44 ½, NASDAQ, Spectacolor HD129 / Times Square Visitor Center Marquee, ClearChannel HD128, Spectacolor HD127 / CNN Screen, Times Square Visitor Center, Viacom North & South (SL Green Realty and Orange Barrel Media) Thomson Reuters, and 7TS (7 Times Square).
Guidelines for participation in future programs are located on the Times Square website. All inquiries relating to content should be directed to firstname.lastname@example.com and must include TIMES SQUARE MOMENT in the subject line of the email to receive updates.
Times Square Advertising Coalition (TSAC) is a trade association comprised of major advertisers, retailers, real estate firms, media companies and other businesses involved in the outdoor sign industry in Times Square, along with organizations representing Broadway and the community. Members of TSAC include: ABC Regional Sports & Entertainment Sales, Clear Channel Spectacolor, Daktronics, D3 LED, Digital Domination, Hines Management, Jamestown One Times Square, Lamar Advertising Company, Landmark Sign & Electric, Metro Media Technologies, Newmark Knight Frank, North Shore Neon, P.R.omotion!, Sherwood Outdoor, SL Green, The Times Square Alliance, The WOW Factor and Thomson Reuters. www.timessquareadcoalition.org
Times Square Arts, the public arts program of the Times Square Alliance, presents leading contemporary art and performances in multiple forms and media to more than 400,000 daily visitors to New York City's Times Square, making it one of the highest profile public arts programs in the United States. Since its inception, Times Square Arts has featured works by a diverse group of more than four dozen prominent and emerging artists. Working in partnership with cultural institutions and festivals, the program is further supported by Rockefeller Brothers Fund and Rockefeller Foundation's Cultural Innovation Fund, which works to spur and support cultural innovation in New York City's creative sector. Visit www.TimesSquareNYC.org/arts for more information. Follow us on Twitter: @TSqArts
About Art Production Fund:
Art Production Fund (APF) is a public art initiative dedicated to commissioning, producing and presenting ambitious art projects by emerging and established artists. APF is committed to engaging audiences in creative ways by realizing socially relevant projects, which push the field of public art in new directions. APF's unexpected and challenging projects are available to diverse audiences in locations that fall outside the realm of traditional art institutions. For more information call Prentice Art Communications 212-228-4048 email@example.com or firstname.lastname@example.com
About Yoko Ono:
Born 1933, Tokyo, Japan, Yoko Ono lives and works in New York. Ono is an influential artist who pushes the boundaries of the art, film, music and theatre media. The present time marks a renewed resurgence of interest and celebration of her work. She received the prestigious Golden Lion Award for Lifetime Achievement at the 2009 Venice Biennale and is currently on a world tour with PLASTIC ONO BAND.