text:
NYT: Two-thirds of NATO countries ran out of weapons for Ukraine
Small NATO members are no longer able to provide Ukraine with weaponry, a source told The New York Times.
NATO North Atlantic Treaty Organization
He claimed that while the stockpiles of 20 of the alliance's 30 member countries are "nearly at zero," the remaining 10 can still produce further weapons. France, Germany, Italy, and the Netherlands are a few among them.
The NYT claims that NATO has already sent Ukraine weaponry worth a total of $40 billion, which is equal to France's annual defense spending. The publication reported that 18 Caesar howitzers, or nearly 20% of Paris' own artillery, had been sent to Kiev.
Germany previously declared that it has virtually reached the limits of what it can do to help Ukraine. According to Guido Crosetto, the defense minister, Italy has no plans to receive any fresh shipments.
This week, NATO Secretary General Jens Stoltenberg urged member states of the alliance to enhance weapon manufacturing in support of Ukraine because the majority of NATO's arsenals of weapons and ammunition had been used up. According to him, each state should increase defense spending to 2% of GDP by 2024 for this reason.
source: nytimes.com


A monosaccharide, sometimes known as blood sugar.
a simple sugar which is the chief carbohydrate fuel in food. In the dextrose form isomer, it is the chief product of photosynthesis in plants.
a variety of glucose. Glucose, like many biochemicals comes in different isomers. In biological tissues throughout the earth, only the dexter form is produced and used.
(C6H12O6) A simple six-carbon sugar. A sweet, colorless sugar that is the most common sugar in nature and the sugar most commonly fermented to ethanol.
(sugar) Fuel that the body needs to produce energy. Glucose comes from carbohydrate-containing foods such as breads, cereals, fruit and milk.
a simple form of sugar that is created when the body's digestive processes break down the food we eat. Glucose is the body's main source of energy.
A simple sugar (monosaccharide), chemical formula C6H12O6. Glucose is readily fermentable by all brewers yeast. Also referred to as dextrose. Corn sugar consists of primarily glucose.
A simple sugar that is the main source of energy for the body.
a simple sugar that is the primary product of photosynthesis. It is polymerized to make cellulose and chitin.
A simple sugar which is a major source of energy in the human body.


Why has Mark Mickelson gotten away with teaching contrary to the UCG List of Beliefs for so long? Why has the Chairman and President only now come out against Mark's teaching, that the God known to Israel was exclusively God the Father?
Note: I previously wrote that Mark's teachings were similar to Ken Westby's "One God" Movement, which movement teaches that Jesus did not exist before his human birth: Which is pure Unitarian Rabbinic Judaism.
Mark does not teach that Jesus did not exist before his human birth, but he does focus on teaching the evangelical position that the God known to Israel was God the Father, and not the one who became Jesus Christ.
Both Mark Mickelson and Ken Westby and friends, teach that God the Father was the God of Israel and the Mosaic Covenant, but Mark allows that Jesus preexisted his human birth.
Now we come to the power struggle going on in UCG.
Mark is teaching the evangelical position that it was God the Father who was the LORD of Hosts and therefore gave Israel the entire Mosaic law from Sinai.
This teaching is the essential foundation on which they can place the concept that since the Mosaic Covenant is ended, a New Being in Jesus Christ gave a NEW New Covenant which requires ONLY the Ten Commandments and that we become full of an emotional feeling of love for others.
Mark is teaching evangelical beliefs that are believed by many leaders in UCG, who have allowed Mark to get away with teaching this.
However some in the leadership have awakened to what is really going on and are demanding that this evangelical teaching be stopped; using the UCG List of Fundamental Beliefs and older teachings on the subject to back up their demands.
Mark Mickelson is the front man for the evangelical leaders in UCG, helping to prepare the way for the coming new position on Grace being prepared for unveiling after next year's GCE Conference when there will be important changes on the CoE. Several supporters of past teachings like Scott Ashley are due to be replaced in May 2018.
It has been taught for years by Gary Antion at ABC that "we do not have to obey God's Mosaic laws. We do so because we want to".
This false evangelical teaching that the UCG youth have been indoctrinated with at ABC, fits right in with the idea that Jesus established a New Covenant in which God's laws other than the Ten Commandments are optional and not Salvationally Obligatory.
The next step is to claim that Jesus Christ came to nullify the Mosaic Laws at Sinai and replace it with a New Covenant of "Grace" where ONLY the Ten Commandments and love are required, making such things as the annual Festivals optional.
Some elders have remembered how this same change was orchestrated by these same leaders in the WCG, leaders who are now in control of UCG; and they have taken a stand: Forcing leaders Ward and Kubik to enforce the official Statement of Beliefs against their own personal positions.
The mission of Mark Mickelson was to lead the way in indoctrinating the brethren into the evangelical false teaching of a loving Christ replacing the laws that were given to Moses. Which is why the evangelically oriented leaders winked at his teaching contrary to their official beliefs until now.
The next step is to issue a new teaching on "grace," after the May 2018 GCE Conference, reinterpreting UCG's position on "Grace" without changing anything on the List of Fundamental Beliefs.
The GCE vote on the majority's needed to change the List of Beliefs was to be used as a deception to reassure the brethren that nothing was being changed, they were only clarifying a belief [Remember Joe Tkach and his team, who were these same people leading UCG today?].
This is all about subverting the brethren through deception and some leaders have seen what is going on and taken a stand. Now Ward and Kubik have been forced to come out against Mickelson.
There is a major power struggle going on in UCG and the big question now is: How long can this divided house stand?
At present the majority of the elders are on board with the changes desired by the evangelically minded leaders.
Right now maybe 10% of the elders are resisting and another 5-10% are still asleep and in denial, and the vast majority of the brethren are sound asleep and in denial.
At some point this situation is going to burst on the UCG brethren like 1995.
Then when they do introduce subtle changes through clarifications no one will notice! Mark is expendable to accomplish this as he has prostate cancer and may retire soon anyway.
For years they have already been teaching in ABC that we do not need to obey the law "we do it because we want to"!
Which means that keeping the law that God gave to Moses is not salvational and is optional; being up to our own choice. This is the damnable heresy warned to come in the end time by Jude, which they want to bring in through clarifications on "Grace".
Jude 4 For there are certain men crept in unawares, who were before of old ordained to this condemnation, ungodly men, turning the grace of our God into lasciviousness [permission to break the law God gave to Moses], and denying the only Lord God [by teaching that he need not be obeyed], and our Lord Jesus Christ [rejecting the teaching of Christ that we are to live by every Word of God the Father Mat 4:4].
Brethren, almost one half of the book on the Biblical Sabbath and Calendar is about the Covenants and the sovereignty of God, and was written to fight this very evil. It is available for Free Download here.
I have been working day and night to present the sound doctrine of every Word of God. I expect to complete the entire Bible except Job by the end of October, and to turn to a substantial series on doctrines before doing Job just before Passover.
Next summer the plan is to concentrate on any remaining doctrine and on discussing the Prophets as world events mature.
Your contributions are needed to fight the good fight as exhorted by Jude, please remember to support this effort to provide a place for the brethren to go for sound doctrine as things progress in the various organizations and in the world. Help us fight the good fight as admonished by Jude. help us to earnestly contend for the sound doctrine of Holy Scripture!
James, would you please elaborate on a couple of comments you made in the NOTE area?
I am not sure if the "double negatives" using the word "not" make things confusing or not, but aren't you and Mark in agreement on this point?
Aren't you also allowing that too, or am I misunderstanding something?
Mark allows that Jesus preexisted his human birth but insists that God the Father was exclusively the LORD of Hosts and that God the Father was exclusively YHVH. Both positipons being absolutely wrong.
Seems so much like the corrupt governments of this world.


text:
Injured from fall, tested positive for weed: Does she get workers' comp?
by Fred Hosier
Judges split 2-1 on whether an employee who was injured at work should receive workers' comp benefits after testing positive for weed. Which side prevailed?
Bonita Brinson was an employee of Hospital Housekeeping Services LLC. As the name of the company implies, Brinson was placed at a hospital as a housekeeper.
One day at work, Brinson rushed to alert the nurse's station that a patient had coded and wasn't breathing. She slipped and fell, dislocating her shoulder. A post-injury drug test was positive for marijuana metabolites.
Brinson had signed her employer's policy stating that "all employees that are injured are subject to a drug test."
Because of the positive test, Brinson's workers' comp claim was denied. A Judge of Compensation Claims (JCC) also denied her benefits request. Recently, a Florida appeals court heard her case.
Court: She didn't make her case
Florida's workers' comp law "presumes that the injury was occasioned primarily by the influence of the drug upon the employee" when an injured employee tests positive for drugs after an incident.
The law allows the injured employee to rebut the presumption by presenting convincing evidence that drugs didn't contribute to the injury.
In this case, the majority ruled Brinson attempted a rebuttal, but failed. The court listed two strategies that it said "might have rebutted" the presumption:
Establish an external cause for her injury (example given by the court: she was "pushed by an unruly patient"), or
Show the marijuana in her system was just inactive residue of fairly recent usage.
Brinson's rebuttal consisted of testimony from two medical experts who said the drug tests showed only the presence of metabolites, but don't show drugs active in the bloodstream caused impairment. Both doctors also said they had no opinion on whether the drugs in Brinson's body contributed to her injury.
The majority also noted that Brinson acknowledged her employer "had a drug-free policy."
For those reasons, the court upheld the JCC's ruling that Brinson shouldn't receive workers' comp benefits.
The dissenting judge quoted Florida law which says an employer may require a drug test from an injured employee only "if the employer has reason to suspect that the injury was occasioned primarily by the use of any drug." The judge said, given the facts in Brinson's case, there was no evidence that there was reason to suspect Brinson was impaired by drugs. Therefore, testing Brinson was unauthorized.
(OSHA's electronic recordkeeping rule contains a provision against drug-testing any time an employee is injured.)
The dissent also notes that Brinson's employer hadn't adopted a statutorily defined drug-free workplace program. If it had, it would have had latitude to drug test injured employees. "But the employer here jettisoned its attempt to establish a drug-free workplace program," the dissent notes.
The final paragraph written by the dissenting judge is worth noting, because it sums up the status of workplace drug-testing today amidst state marijuana laws:
"All this said, marijuana intoxication is a serious matter of public health and a workplace safety concern that employers face daily. The confluence of lawful marijuana use (medical in Florida, medical/recreational elsewhere), the lack of scientific standards or chemical tests for marijuana impairment, and the interplay of federal enforcement policy make the future application of workplace drug tests challenging, to say the least."
(Bonita Brinson v. Hospital Housekeeping Services LLC, First Dist. Crt. of Appeal of Florida, No. 1D17-505, 6/22/18)
Fred Hosier
Fred Hosier is the editor of Safety News Alert and has spent more than 20 years covering safety. He's been in the communications business since 1985, including 11 years in radio.

redpajama_set_name: RedPajamaCommonCrawl


I have never seen a tie with such beauty and elegance before! Perfect gift for any male with a passion for music, It's long-lasting and affordable, I would convince anyone to purchase this tie, Trust me you won't regret !
Click the button below to add the Tie-Trumpet Shape to your wish list.


A migraine is an intense, debilitating, and chronic headache that causes attacks on more than 15 days monthly. This type of headache produces severe pain on one side of the head, and some sufferers may even experience aura. Natural treatment is always an ideal approach, and this is where yoga for migraine relief can help.
In general, exercises like yoga can help prevent migraine attacks by lowering stress levels, reducing inflammation, improving sleep quality, and more.
Major migraine symptoms also include difficulty speaking, nausea, vomiting, tingling or numbness, and sensitivity to sound and light.
Most migraine headaches last about four hours; however, if they are not treated or you don't respond well to treatment, they can last anywhere from 72 hours to a week.
Conventional migraine treatment will depend on a number of factors, including your age, how long they last, and how often you have them. Often, migraine medications include NSAIDs (non-steroidal anti-inflammatory drugs) and other pain relievers like acetaminophen ("Tylenol").
How Does Yoga Help Relieve a Migraine?
How can you use yoga for migraine headaches?
Some migraine patients complain that exercise triggers their headaches, so they avoid exercising and become less active in general. However, yoga involves slow, mindful movements that help alleviate stress, enhance mood, and reduce episodes of migraines and chronic tension headaches.
It isn't clear how yoga does this, but some experts suspect the parasympathetic nervous system (PNS) plays a role. This is because the PNS can lower blood pressure and slow one's heart rate during yoga practice. As a result, the body is able to recover after stressful events, especially migraine attacks.
A study published in the International Journal of Yoga in 2014 found that headache frequency and intensity was decreased in those who added yoga to their regular treatment. There was also an improvement in vagal tone, which is the effect produced on the heart when parasympathetic nerve fibers control heart rate.
The researchers also found that yoga improved cardiac autonomic balance. Migraines are associated with disturbances in the autonomic nervous system (ANS) and circulatory system. When balance to these systems is restored, this is likely to reduce the risk of a migraine headache.
There are specific yoga postures for migraine relief that help target stress and tension, which may be key contributors to your migraines. Certain poses can help improve blood flow to the brain and boost overall circulation. As a result, you may experience less of the pain and throbbing associated with migraines.
Lotus position is a cross-legged yoga pose that calms the mind and reportedly alleviates health problems such as migraine headaches. It may also reduce muscular tension and control blood pressure.
How do you perform the lotus posture?
You will start by sitting on a yoga mat or the floor with your legs stretched out in front of you, while also keeping your spine erect.
Next, bend the right knee and place it on your left thigh, and make sure the sole of your foot points upward and the heel is close to your abdomen. Repeat this step with your left leg.
Both legs are now crossed with feet placed on the opposite thigh. You will want your hands on your knees in the mudra position—this is where the tips of the thumb and the index finger touch.
Keep your head and spine straight, and continue to hold. Breathe in and out with long, gentle breaths.
Pranayama is an ancient breathing exercise that involves consciously controlling your breath. It is beneficial for stress-related disorders, and could therefore help reduce your risk of migraine headaches.
How do you perform this type of breathing exercise? You will start by breathing in deeply through your nostrils. You will feel your diaphragm move down, and this allows your lungs to expand while forcing the abdomen out. You'll then feel your chest expand, with the collarbone rising last.
Next, you will breathe out quickly through your nostrils. You will feel your collarbone dropping, and as your lungs collapse, your chest deflates and abdomen shrinks. When this is done correctly, your chest will expand when you breathe in and deflate when you breathe out. Repeat this continuously for five minutes.
There is another beneficial breathing exercise for migraines called anulom vilom pranayama, or the alternate nostril breath.
To start, close your eyes and focus your attention on breathing. Close your right nostril with your right thumb by simply pressing your thumb against your nostril.
Next, you will inhale slowly through your left nostril. Remove your thumb from your right nostril, and use your ring and middle fingers to close your left nostril.
Exhale slowly and completely with the right nostril, and then inhale through the right nostril. You will then close the right nostril and open the left nostril.
Finally, breathe out slowly through the left nostril. Continue this breathing technique for 15 minutes.
Kapalbhati pranayama is a more advanced breathing technique that helps reduce stress, and consequently reduces your risk of migraines.
For this breathing technique, start by inhaling slowly through your nostrils until your lungs are full. You will then exhale through both nostrils forcefully. The contraction of your stomach muscles helps push air out of your body.
Repeat this breathing technique for a 15-minute period.
Standing forward bend is another beneficial yoga posture for migraine relief.
For this pose, start by standing with your hands on your hips. Exhale and bend forward from the hip. You will want to lengthen your front torso as you move more fully into the posture.
Next, with your knees straight, bring your fingertips to the floor. If this isn't possible, cross your forearms and hold your elbows. Press your heels into the floor and lift your sitting bones toward the ceiling.
With each inhalation, lift and lengthen your front torso, and when you exhale, release further into the forward bend and let your head hang. Stay in the pose for 30 seconds to a minute.
To come up, bring your hands to your hips and press your tailbone down on the inhalation.
Child's pose is another yoga pose for migraine headaches that helps reduce pain and calm the nervous system.
With this position, you start by kneeling on the floor while keeping your toes together and spreading your knees as wide as you can. Next, lower your buttocks onto your heels, and sit up straight.
After exhalation, lean forward so your head and chest rest between your thighs, and allow your forehead to rest on the floor. Your arms should remain extended with your palms facing down.
Hold this position for a minute or more, and release tension from your neck and shoulder. When you come out of the pose, push yourself up with your hands.
Cat stretch is another useful yoga pose for migraine headaches. For this posture, come on all fours and form a table—with your back being the tabletop and your hands and feet forming the table's legs.
Keep your arms perpendicular to the floor, and look straight ahead. As you inhale, you will raise your chin and tilt your head back, while also pushing your navel downward and raising your tailbone. Hold this cat position and take deep breaths.
As you exhale, drop your chin to your chest and arch your back, and relax your buttocks. Hold this posture for a few seconds before returning to the initial tabletop position.
Continue for five to six rounds of inhales and exhales, and then come out of this posture.
Seated forward bend may also help to relieve migraines. To begin this yoga posture, stretch your legs out in front of you while in a seated position. Also, keep your spine erect and toes flexed.
Breathe in, raise both arms above your head, and stretch out. As you breathe out, bend forward from the hip, and have your chin move toward your toes. Place your hands on your legs and, if you can, take hold of your toes.
When you breathe in, lift your head and lengthen the spine. While breathing out, gently move the navel toward your knees. Repeat this movement two to three times.
Drop your head down, and breathe deeply for about a minute. Stretch your arms out. Finally, when you breathe in, come back to the sitting position, and when you breathe out lower your arms.
Bridge pose will open your heart, chest, and shoulders. This posture reduces anxiety that may be related to your migraine headache.
To start bridge pose, lie on the floor. Your knees should be bent with your feet flat on the floor. Next, extend your arms with your palms flat on the floor. You will then lift your pelvic region upward. Your head and shoulders will remain on the floor.
To release the pose, drop your torso and pelvic region down slowly to the floor. Allow your knees to sink down until you're lying flat on the floor.
Downward-facing dog is a great yoga posture for increasing circulation to your brain, and this can help reduce your migraine risk.
For this posture, begin downward dog on your hands and knees, and align your knees under your hips and your wrists under shoulders. Next, stretch your elbows and relax your upper back.
Spread your fingers and press down, and gently lift your knees off the floor. Then straighten your legs, lift your pelvis, and lengthen your spine. You will hold this posture for about two minutes.
Gently bend your knees and return to your hands and knees to come out of this posture.
Corpse pose is also called savasana, and it is a great posture for relaxation. In this pose, you simply lie on the floor with your back on the ground. Spread your legs slightly apart, and place your arms to your sides with your palms facing up. Hold corpse pose for at least five minutes and as long as 30 minutes.
Practicing yoga for migraine headaches can help relieve painful symptoms of the intense and debilitating health problem. In this article, we explained yoga postures for migraine relief, which include lotus position, breathing exercises like pranayama and kapalbhati pranayama, standing forward bend, child's pose, cat pose, seated forward bend, bridge pose, downward-facing dog, and corpse pose.
Although these individual postures can help during a migraine, you may find it more helpful to add a full yoga practice to your daily routine. Just remember that while some people may find relief from yoga, others may not.
In addition to yoga, you can try other natural migraine treatments geared toward getting enough sleep; managing stress; limiting screen time exposure; and eating a healthy, anti-inflammatory diet.
Ginger for Migraine: Is this Natural Treatment Better than Drugs?
Kisan, R., et al., "Effect of Yoga on migraine: A comprehensive study using clinical profile and cardiac autonomic functions," International Journal of Yoga, July to Dec. 2014; 7(2): 126-132, doi: 10.4103/0973-6131.133891.
"Padmasana – Lotus Position – Steps and Benefits," The Art of Living; https://www.artofliving.org/in-en/yoga/yoga-poses/lotus-pose-padmasana, last accessed August 3, 2018.
John, P., et al., "Effectiveness of Yoga Therapy in the Treatment of Migraine Without Aura: A Randomized Controlled Trial," Headache, 2007, ISSN 0017-8748, doi: 10.1111/j.1526-4610.2007.00789.x.


German percussionist Matthias Kaul certainly knows how to be noticed. This CD arrives packaged in a pouch made from painter Wolfgang Kahle's Silence, an acrylic paint and Chinese ink canvas cut into 1,000 individual pieces for this project.
Not that Kaul really need gimmicks to be noticed. A spectacular percussionist, he creates sound on surfaces you can hardly imagine and produces beats and rhythms way beyond the norm.
Let's set parameters before going any further though. This may be a solo percussion session, but it won't appeal to many who think of themselves as drum fanatics. If you're someone who gets off on the JATP battles between Buddy Rich and Gene Krupa, someone who hymns Max Roach's solo work, or takes up cudgels for Elvin Jones, Joey Baron, Han Bennink or even Sunny Murray, you may be in for a shock.
Kaul is the sort of percussionist for those who think of Eddie Prévost, percussionist with British free music band AMM, as a good mainstream, drummer. Usually working on the New music side if the fence, Kaul is a solo specialist who has recorded music written by the likes of aleatory, minimalist and atonal composers such as John Cage, Vinko Globokar and James Tenney.
As the title says, these five tunes are all his own improvisations and honor different figures. They are sequentially: American-Canadian violin improviser Malcolm Goldstein, who has played and recorded with Kaul; Amadeu Antonio Kiowa, an Angolan immigrant who was beaten to death by German skinheads in 1990; poet Ingeborg Bachmann; Elvis Presley, who, as they say, needs no introduction; and author Yoko Tawada.
What you hear on this CD are sounds that are primitive and futuristic at same time. Looking over the laundry list of percussion implements Kaul uses on each track, you'll see that the elements of a conventional European orchestra are just the beginning. His kit is amplified with ethnic instruments, self-invented percussion and children's toys. But even that isn't the whole story. He adapts these ethnic instruments by taking them out of their geographical context. He transmutes the sounds so that they take on a different meaning than they would have in an indigenous culture — and that includes the role percussion plays in the musical culture of Northern Europe.
Furthermore he doesn't acknowledging the hierarchy that's supposed to exist between high — European, World ethnic — music and so-called lower forms such as play-party folk, children's and made-up improvisations. Additionally, like John Cage, as a composer, or Thelonious Monk, as a composer/performer, he doesn't play his drums and percussion properly, that is according to accepted societal norms. Instead he mixes and matches according to his own ideas and designs.
Longtime followers of The King, for instance, may never be able to reconcile what appears on the title track with their memories of Presley. Let's just say that even at the beginning of his fabled career neither Presley, nor guitarist Scotty Moore, bassist Bill Black or (especially) drummer J.D. Fontana ever used drum skins, microphones, mallets or sticks in this way. With the egg timer-like beat of castanets supposedly replicating Presley's finger snaps, Kaul's rubbed temple bells, frame drum rolls, shrill whistles and consistent drone keep augmenting to such an extent that after a while he come up with a foot-tapping cadence. Should you wonder how Elvis's found sounds could have fit together with those of Karlheinz Stockhausen, this provides one clue.
Elsewhere the loud and clearly identifiable pounding on a military-style drum — 50 times — is used to suggest ethnic violence at the beginning of "Amadeu Antonio Kiowa". The Angolan was attacked by at least 50 Nazi skinheads in Berlin in 1990 while police looked on and did nothing. Later on, the harsh tones of the European instruments are succeeded by a panoply of South American, African and Middle Eastern instruments sounded in different keys, pitches and combinations. Alternating particular pulses and silences, the result not only suggests the sort of Third World dance measures favored by Westerns, even in Germany, but reminds people that musical miscegenation such as this ensures that fascists' attempts at ethnic cleansing are doomed.
Although the percussionist doesn't consider this composition, honoring the first victim of racial violence to be murdered after the fall of the Berlin Wall, to be "political in a general sense", he is altruistically encouraging other percussionists to perform it as well. That's because all proceeds are pledged to a Berlin foundation bearing the victim's name, which assists victims of xenophobia and neo-Nazi horrors.
Throughout the almost 55½ minutes of the CD Kaul demonstrates that such primitive or everyday items as a mouth organ, a glass harp, Tibetan temple bells and a toy piano can communicate the same emotions as complex instruments. Vocal tones, both reciting a phrase and slowed down to gibberish can work just as well as any certified orchestral designation.
Thought and inventions behind the arms, hands, muscles and sinew create exceptional performances, Kaul knows, unlike many traditional, academic composer/performers. Despite the packaging of this CD he didn't have to paint a picture for the listener to appreciate his ideas.


Store essential documents in this Realspace vertical mobile file cabinet with caster kit that measures 18". It provides plenty of space for paperwork and rolls away for a discreet look to keep your office tidy and productive.
Drawers lock for privacy and feature a glide suspension for easy opening and closing.
Realspace 2-drawer file cabinet in stone offers additional mobility for your files. Note: The file height with casters is 26 1/2".


Short Handed Play – Dave Tarbet Short handed play is very different from a full table and you must alter your style of play accordingly. Many players do not like short handed games as they cannot grasp the difference in playing style needed to win at a short handed table.
Odds and Outs – Dave Tarbet A bit of a maths lesson for you this week as we look at calculating your outs and pot odds, but please no calculators! The number of outs you have are the remaining cards in the deck with which you can win the hand.


text:
Blair Underwood Returns To 'Marvel's Agents Of S.H.I.E.L.D.'
Outsiders - July 31, 2015
Last year fans met Agent May's ex-husband Andrew Garner, played by two-time Golden Globe Award nominee Blair Underwood, and with a new season under way you'll get to see even more of their dynamic as the star returns to "Marvel's Agents of S.H.I.E.L.D." Underwood will return for multiple episodes in the series' third season.
Season 3 of "Marvel's Agents of S.H.I.E.L.D." premieres Tuesday, September 29 at 9:00 PM ET on ABC.
In the aftermath of S.H.I.E.L.D.'s battle with Jiaying and the Inhumans, Director Coulson will search the world for more powered people and will face threats unlike the world has ever seen. However, the Agents of S.H.I.E.L.D. will soon find out they're not the only ones tracking down these new Inhumans.
Shop For Marvel Television On Ebay!
More Television News
New Falcon And The Winter Soldier Set Image Gives Us A Glimpse At Sebastian Stan's New Look
Stan Lee Primetime Special Coming To ABC On December 20
Marvel's Runaways - Season 3 Official Trailer and Posters For Final Season


DEFINITION: Time to resolve insolvency (years). Time to resolve insolvency is the number of years from the filing for insolvency in court until the resolution of distressed assets.
"Countries Compared by Government > Red tape > Time to resolve insolvency > Years. International Statistics at NationMaster.com, World Bank, Doing Business project (http://www.doingbusiness.org/). Aggregates compiled by NationMaster." 2003-2013. <http://www.nationmaster.com/country-info/stats/Government/Red-tape/Time-to-resolve-insolvency/Years>.
"Countries Compared by Government > Red tape > Time to resolve insolvency > Years. International Statistics at NationMaster.com", World Bank, Doing Business project (http://www.doingbusiness.org/). Aggregates compiled by NationMaster. [Internet]. 2003-2013. Avaliable from: <http://www.nationmaster.com/country-info/stats/Government/Red-tape/Time-to-resolve-insolvency/Years>.
"Countries Compared by Government > Red tape > Time to resolve insolvency > Years. International Statistics at NationMaster.com", World Bank, Doing Business project (http://www.doingbusiness.org/). Aggregates compiled by NationMaster. Avaliable at: nationmaster.com. Assessed 2003-2013.


text:
Music Biz Headlines, May 10, 2021
The Damn Truth (pictured) get a glowing hometown review, Skye Sweetnam has gone from pop to metal, and Jerry Levitan teams up with Sean Ono Lennon. Others in the headlines include Michel Louvain, The Tenors, Ronnie Williams, Spotify, Live Nation, RCM, WMG, Ledo, Broadway, Tencent, Kurt Cobain, Daniel Ek, and Childish Gambino.
Music Biz Headlines, July 18, 2018
Down Under Kate Bush fans celebrate, Radiohead in full flight on tour, and major labels are unhappy with Spotify. Also in the headlines are Zac Brown Band, cannabis sponsorship, Harry Styles, Elora festival, Nancy Sinatra, Jessie Reyez, Courtney Barnett, Iskwe, Childish Gambino, Lindsay Ell, retro rap, Hillside, and The Pretenders.
Small Faces' 'Ogdens' Nut Gone Flake' turns 50: Phil Collen, Peter Frampton, Linda Thompson & more pay tribute. Under the recording guidance of the great Glyn Johns -- who had also spent '68...
Post Malone, Childish Gambino Have This Week's No. 1s
Rap, hip-hop and French pop acts rock this week's streaming songs and albums charts.
Childish Gambino Bending The Rules In 'This Is America'
by External Source
Great art is supposed to make us uncomfortable in the moment because there is no growth inside comfort zones and safe spaces. You can't push the conversation forward if you're dancing around it (Hence Glover's dancing metaphor for distractions in "This Is America").


text:
San Francisco Chronicle on Off Season
"James Sturm's graphic novel 'Off Season' makes political divide personal" / San Francisco Chronicle / Brandon Yu / March 21, 2019
Like many artists, James Sturm saw his work shift after the 2016 presidential election — though for him, the change was particularly literal and swift.
In the fall leading to the election between Donald Trump and Hillary Clinton, the cartoonist had been creating a kind of real-time comic strip, published weekly on Slate, that followed the dissipation of a marriage while its blue-voting dog-headed characters were experiencing the same election season. On election night, Sturm had his latest strip finished ahead of time.
"Like many Americans, I was pretty confident in a Clinton win, based on the polls," Sturm says. "So I did that strip. I had it all done by early evening, and then realized with horror that I couldn't use it."
Panels that showed Mark — a father of two who had recently split up with his Clinton-volunteering wife, Lisa — calling his former partner to congratulate her were redrawn into ones depicting instead a bleak voice message offering condolences. In the strip's final panel, Mark, after a silence, offers an "I love you," a terse message that is perhaps a show of comfort in light of the results, but also a desperate way of holding onto a fading companionship.
That parallel between personal and national politics runs through Sturm's comics — awash in a somber blue-gray and populated by anthropomorphic dogs — in his affecting new graphic novel, "Off Season" (Drawn and Quarterly; 216 pages; $24.95), a collection of these weekly strips. Sturm, though, began working on the series a year earlier, focusing solely on the relationship between his protagonists.
"I see it more as a love story and about a couple that's really trying to cross a divide and return to one another," Sturm says. "Then, of course, the 2016 (election) season really showed how great a divide there is in this country. So it seemed like those things on top of one another made sense."
Yet, it's the knowledge of what happens after, the shock and devastation of the next morning, that permeates the wistful pall covering the book's 13 chapters.
"I was just coming off my own difficult year. I had been preyed on by a con man myself, a contractor. I had kind of woken up and realized, 'What the hell just happened?' I wasn't paying attention," Sturm says. A similar character, a contractor conning Mark, appears in the book.
"And then, when the country woke up: 'Wait, what just happened?' Now a con man is in the White House. It was a little familiar."
Sturm has never considered himself to be a political cartoonist, but politics suddenly seemed to infuse everything. His characters seemed to take on heightened, political resonance — the contractor as a Trumpian figure, the class differences, and bitterness in turn, between Mark and Lisa.
Now, 2½ years removed from that moment, the topical politics may read somewhat differently, as shock may have grown into a new normal, Sturm acknowledges.
"Originally the dog's heads were kind of just meant to be almost like placeholders until I figured out how to represent the characters," Sturm says. "And the longer I worked with the dogs, the more normal they seemed. Anything, after a while, just kind of feels normal."
Yet, the heart of the book, the humanism of the relationships and their aura of palpable hopelessness and also of lingering hope, rings with a gut-wrenching consistency.
"It's very much about a time and place," Sturm says, "very much infused with this kind of midlife melancholy — the challenges of being in life's rush hour where you're dealing with kids, dealing with aging parents. You're dealing with economic pressures. How do you hold that together? Even in the best of circumstances, that's really hard."
But Sturm expresses a kind of tempered optimism in the face of these harsh realities, for his characters and for the nation.
"I feel like both characters have this immense connection, deep connection and share a life together, especially after raising kids together. I don't think it's over," he says. "And then just as a country too, we all live in this geographically defined land on top of one another. We have a stake in how it comes out."
GQ Magazine recommends The Making Of
The Washington post spotlights Clyde Fans and Hot Comb
The Atlanta Journal Constitution reviews The Hard Tomorrow
NPR's WBEZ Chicago hosts Lynda Barry
Youth Services Book Review Features Little Lulu
Gosh comics lists This Woman's Work, The River at Night, and The Hard Tomorrow as best comics of 2019
The Boston Globe recommends The Hard Tomorrow
Sagittarian Matters hosts Lynda Barry
Sara Quin Lists Sabrina in 10 Favourite Books
Broken Frontier reviews Making Comics
The AV Club lists Hark! A Vagrant as one of the best comics of the decade
Black Girl Nerds reviews Making Comics
Jason Lutes wins Vermont Book Award!
Kate Beaton Drew Today's Google Doodle!
Huzzah! Canada's Google Doodle today celebrates the 165th birthday of Henrietta Edwards, an…
Art Spiegelman talks his career with Metro News
Art Spiegelman likes telling long stories. He's the creator of Maus, the only graphic novel…
Tofugu rates Showa 9/10!
Shigeru Mizuki is probably the most famous manga author that's almost unknown in the English-…
Herald Scotland's Thoughts On Moomin
1 The Art of the Comic Strip This is, you may have noticed, the centenary of Tove Jansson's…
Brian Ralph at Atomic Books, SPX 2011
September 15, 2011. Brian Ralph introduces his new book Daybreak, talks about...
Joe Sacco: Graphic Journalism and Palestine
Grand Valley State University (GVSU) hosted Comic Journalist oe Sacco at the UICA for a...
University Arts London: Raymond Briggs
Illustrator and author Raymond Briggs talks to George Blacklock about his experience at...
Julia Pohl-Miranda Talks about Summer Reads at the Librairie D+Q
Our Van Houtte blogger Na'eem needed a collection of summer readings and got a great...
Tom Gauld talks to Alex Fitch
April 8, 2012. Continuing our month of shows all about British Comics, Alex Fitch interviews…
Lynda Barry Talks to Matthew Rothschild
The Progressive's guest this week is cartoonist and creativity teacher Lynda Barry.
Kate Beaton Talks to Julie Klausner
The delightful Kate Beaton, cartoonist and author of Hark! A Vagrant , on her views about…
Bad at Sports Episode 324: Anders Nilsen
This week: Richard and Duncan talk with Anders Nilsen.


How should a tall skinny man feel after he's easily lifted overhead by a short fat woman who far outweighs him while he towers way over her?
When you are talking to a guy in a well-lit room and his pupils are dilated what does that mean? If a guy really like a girl would he tell his friends? Wife is smoking meth, where do meth heads hide their dope and pipes in and around the house? What should I do tonight? Why would a guy always ask his girlfriend "wyd" every time when he text her?


I think I only belatedly realised that I *was* a designer long after I was already doing it. I drifted into a design role from an unconventional background. I was a English / History of Art graduate and my very first job, way back in the late 90s, was as a database application developer and I moved gradually into nascent web-based roles, from webmaster all-rounder to dedicated designer.
Reading Jeffrey Veen's seminal The Art and Science of Web Design was probably the moment that crystallised for me a thing I unconsciously knew to be true: that I was a designer.
I'm not a formally trained designer. I got into designing for the web in its kind of punk 'indie web' phase, where anyone prepared to learn HTML/CSS and enough JS to get by could do it. Our equivalent of 3 chords. I'm of the Zeldman, Webmonkey, Pixelsurgeon, K10K generation and acutely aware of just how fortunate I was to learn from that generation of pioneering designers.
The biggest hurdle is related to exactly this: imposter syndrome. Precisely because I'm not formally trained, I continue to doubt my 'right' to call myself a designer. Over time I've learned to try and see the upside in this: I think it makes me question certainties, to want to continually learn and unlearn, and to avoid getting too attached to any one way of doing things.
I've consciously tried to mix my career: working client side and agency side, within the private sector and public sector, as a freelancer and as an employee. That's a deliberate attempt to never forget what it's like to be a client, what it's like to be in an agency. So, I haven't always been in the business of getting clients.
I'm going to answer this by saying that the very best decision I made in my career was to quit a really good job and go freelance. I have Leisa Reichelt to thank for that, for me giving me the confidence and the belief.
In recent years, I've largely worked in-house, mainly in government. That's in part about how I like to work: agile, multi-disciplinary teams focused on user needs and working on stuff that (to me) really matters; taking a product or service from 'discovery' to 'live' and beyond.
But much of what applies in-house is relevant to agency-side too: to be humble about your role as a designer and to see what you do as facilitating a design process, not owning it; to be open about how you work and to let others in; and, most importantly of all, to use research to see your product through the eyes of its users.
I've been lucky to have only experienced that once, ironically on the last freelance contract I took. I had to involve lawyers to resolve that. I lost a lot of money, but got back just enough of what I was owed to make it worthwhile. Just. That's my only tip: get a lawyer.
These days, I manage teams of designers. I've been incredibly fortunate, at HMRC, Co-op and elsewhere, to get to lead some incredibly talented people. My role isn't as their creative director but, in essence, to create the space to allow those designers to do their best work. That means putting good people around them, trying to find opportunities for people to work on what matters most to them, making sure design and research is happening in the right way. That means lots of meetings, lots of conversations, and too much time spent in email and Slack.
The best bit of any day is listening to designers talk about their work. Sometimes that's because they've hit a block on something. The greatest moments of satisfaction I get as a designer now is sometimes having just enough distance from the problem at hand to be able to help the designer work through it, that lets a designer unlock a problem all for themselves.
In the end, design is about communication. Being a good communicator will make you a better designer. Read widely, attend events that are on the periphery of your discipline. Write often, even if you never hit 'publish'. Treat words as the most important material you have to design with. Keep an open mind.
Andrew Travers is head of digital design at Co-op. He has held a number of senior design positions, including as head of design at HMRC and as an interaction design director at Method. He wrote a pocket guide to 'Interviewing for research' with independent imprint FiveSimpleSteps.


text:
National Speed Limits
Hawaii Speed Limits – National Speed Limits in Hawaii
In Hawaii the maximum speed limit is posted at 60 mph (97 km/h) on Interstate H-1 between Kapolei and Waipahu, Interstate H-3 between the Tetsuo Harano Tunnels and the junction with H-1, and on Saddle Road. All other freeways, including Interstate H-2, have a maximum speed limit of 55 mph (89 km/h), with the speed limit dropping to 45 mph (72 km/h) in central Honolulu. Other highways generally have speed limits of 55 (89 km/h) mph and in many cases much less.
Hawaii has a minimum speed along much of Interstate H-1 of 10 mph (16 km/h) below the speed limit. The minimum speed is usually 45 mph (72 km/h) when the speed limit is 55 mph (89 km/h), and 40 mph (64 km/h) when the speed limit is 50 mph (97 km/h).
North Carolina Speed Limits – National Speed Limits in North Carolina
Tennessee Speed Limits – National Speed Limits in Tennessee
Arizona Speed Limits – National Speed Limits in Arizona
South Carolina Speed Limits – National Speed Limits in South Carolina
Missouri Speed Limits – National Speed Limits in Missouri
Virginia Speed Limits – National Speed Limits in Virginia
New York Speed Limits – National Speed Limits in New York
Maine Speed Limits – National Speed Limits in Maine
Maryland Speed Limits – National Speed Limits in Maryland
National Speed Limits © 2020. Like Us on Facebook


text:
Illinois Commencement 2022
Congratulations, Illinois graduates
Commencement is one of the proudest days of the year at Illinois. Join the livestream on May 14 at 9:30 am CT to help congratulate our amazing Illinois graduates.
Honors, Graduates and Candidates
The list of graduates is as accurate as possible. However, because of production deadlines, names of some degree recipients may not appear, while names of degree candidates may appear even though they have not completed their degree requirements. The University's official registry for conferral of degrees is the Office of the Registrar, 901 West Illinois Street, Urbana, IL 61801.
It appears you don't have a PDF plugin for this browser to view the list of graduates on the page. You can download the list to view it instead.
To view past graduation programs, please choose from the following years.
2020 Commencement Program2021 Commencement Program
"When you bring the brightest minds together, everything changes."
This photo of the Class of 2022 was taken in August 2018. Can you spot your graduate?
Experience Campus
Explore some of the famous campus landmarks that will be waiting for you when you return as alumni.
Lincoln's Bust in Lincoln Hall
Lincoln's nose is shiny bright from the thousands of students who have reached out for good luck before exams.
The university's South Farms encompass more than 1,000 acres of land used for research, teaching and outreach.
Altgeld Chimes
You know you're on campus when you hear the stately ring of "Hail to the Orange" from the Altgeld Hall chimes.
Krannert Center for the Performing Arts
Krannert Center is recognized as the nation's premier university-based performing arts center.
Our library is one of the largest public university libraries in the world, housing more than 14 million volumes and 24 million items.
Standing tall on the north side of Altgeld Hall, the iconic sculpture depicts a woman in academic robes flanked by two figures representing the university's motto, "Learning and Labor."
Hallene Gateway
The Hallene Gateway greets visitors at the east entrance of campus.
Morrow Plots
The Morrow Plots are the oldest continuous agricultural field in the Western Hemisphere.
Eternal Flame
Located on the Main Quad, the former oil lamp promises eternal love after kissing your significant other beneath it.
Illini Union
Generations of students have enjoyed the Union's programs, services and resources since the student center first opened its doors in 1941.
Foellinger Auditorium
One of the most iconic buildings on campus, Foellinger Auditorium hosts classes, public lectures, concerts and student performances.
Alma Cam
Say hello to a familiar face and watch live from the Alma Mater statue.
The university is always here to welcome you back with open arms.
Sounds like home. Experience the familiar ring of the Altgeld Chimes.
"You are Illinois graduates. And Illinois graduates change the world."
No matter where you are, don't forget to turn your tassel
The tassel is worn on the right side and moved to the left when students earn their diplomas.
Share your #illinois2022 story
There are certain days in life that you never forget. This is one of them. Share your day with us on social media using #ILLINOIS2022.
As you take your next steps, remember the familiar Illinois orange and blue is never far away.


text:
Snow showers this evening. Breaks in the overcast later. Low 23F. Winds W at 10 to 20 mph. Chance of snow 80%..
Snow showers this evening. Breaks in the overcast later. Low 23F. Winds W at 10 to 20 mph. Chance of snow 80%.
Senior captain thriving at Emmanuel College: Incredible work ethic the key for Ciampa's court success
By MIKE IPPOLITO Sports Correspondent sports@yourtowncrier.com
BOSTON – Fans of the Tewksbury High Boys Basketball team will no doubt remember Giovanni Ciampa very fondly. After all, the 2018 TMHS graduate put together a tremendous career for the Redmen, as a two-year captain and a three-year starter, twice being selected for the All-MVC team and winnin…
By JAMIE POTE Sports Editor jamiepote@hotmail.com
It's been a while since I have found the time to put together one of these All-Time teams and for that I apologize. The fall season, and then the month of December is always extremely busy. So below I have put together the All-Time Tewksbury Memorial High School Baseball team. I still have s…
Boys split their four meets, continue to improve
BOSTON – Just like the girls' team, the Tewksbury Memorial High School Boys' Indoor Track-and-Field team competed for the first time in 15 days, and they finished 2-2 against Merrimack Valley Conference Small School foes, including wins over Lawrence (44-38) and Dracut (46-24), while falling…
On the Track, Tewksbury Girls defeat three of four league opponents
BOSTON – Competing for the first time in over two weeks, the Tewksbury Memorial High School Girls' Indoor Track-and-Field team went 3-1 in the second round of the Merrimack Valley Conference Dual Meets, putting the team's record to 5-3 overall.
Shawsheen Wrestling team continues to make big strides
CHELMSFORD – One of their biggest tests of the season still lies ahead, but this past week was a very productive one for the Shawsheen Tech Wrestling team, who not only picked up a big dual meet win over CAC rival Greater Lowell last Wednesday, but also put on a very good performance on Satu…
Grapplers compete against three MVC teams, now 5-2-1
METHUEN - It has long ago been established that the Merrimack Valley Conference schedule that the Tewksbury High Wrestling team faces every season is among the toughest in the state, offering the Redmen a stiff challenge every time they take to the mat.
Record not indicative of play by the Red Rangers
SHREWSBURY – Team records can certainly be deceiving at times and that's certainly the case for the Tewksbury/Methuen Co-Op Girls Hockey team.
Redmen remain scorching hot; take care of LS and Lowell to improve to 6-0
TEWKSBURY – And the domination continues!
Both high school basketball teams defeated by NA
TEWKSBURY – Before the season began, it was clearly evident that the Tewksbury Memorial High School Boys' Basketball team would take its lumps, since after all the entire starting line-up was brand new and the players who were returning had limited varsity experience.
AYER/TEWKSBURY – For the past 14 years starting from the Monday after Thanksgiving and lasting to the middle of March, Mike Hayes would make the drive to Tewksbury from either his old residence in Leominster or his current one in Ayer. The drive never bothered him, neither did volunteering h…
Chelmsford overtakes Tewksbury in Tournament Final; Boys fall to Methuen
TEWKSBURY – Going up against a much bigger and physical team, that also happens to be unbeaten, is certainly a tall task (pun intended).
Red Rangers score three goals in third period to tie Framingham
METHUEN – In their first three games, it was really difficult to gather a full report on the Tewksbury/Methuen Co-Op Girls' Hockey team. The Red Rangers had played two of the top three teams in the area, had players in and out of the line-up, and it's the first few weeks of the season, so th…
Remembering Tewksbury Football fanatic, former player, Emmet Millett
This story on Emmet Millett first appeared in the Town Crier back in the January 13, 2016 edition. Millett, a former TMHS Football player and proud town historian, passed away this past week.
Also at Lowell Holidays, Shawsheen takes 11th place
LOWELL – In many ways this season is somewhat of a rebuilding year for the Shawsheen Tech Wrestling team, with a roster filled with many wrestlers new to high school wrestling, or at least new to holding a starting role with the team.
Wrestling team competes at prestigious Lowell Holiday Tournament
LOWELL – Off to a terrific start to their dual meet season, with a 4-1 record to this point, the Tewksbury High Wrestling team faced a different sort of challenge last Monday and Tuesday when they made their way to the Tsongas Center in Lowell for the 2021 George Bossi Lowell Holiday Tournam…
Gymnastics team defeats Lowell
On Tuesday night, the TMHS Gymnastics team defeated Lowell, 129.35-127.60 to improve to 2-2 on the season.
Shawsheen Wrestling team takes 11th place at Lowell Holiday Tournament
Tewksbury Sports Round-Up: Redmen Girls Basketball dominates in semi-finals of Tony Romano Christmas Tournament
TEWKSBURY – The last time the Tewksbury High Girls Basketball team had faced Lowell High School the Redmen had come away with a dramatic 43-42 win when Sam Ryan had knocked down the game winning three pointer at the buzzer last Tuesday night in Lowell.
Shawsheen Tech Sports Round-Up: Shawsheen boys hockey continues great start to season
BILLERICA – The Shawsheen Tech Boys Hockey team continued their strong start to the season this past week, with a big win over non-league rival Rockport, downing their former Commonwealth Athletic Conference rivals by a score of 5-1 last Thursday night at the Hallenborg Ice Pavilion.
Former Wilmington High star helps lead Lenoir-Rhyne to Final Four: Figueiredo overcomes injury to have great career at Lenoir-Rhyne
By DAN ZIMMERMAN Sports Correspondent
Wilmington – When Covid-19 first reached American shores in early 2020, the lockdowns and restrictions put in place by government health officials in hopes of slowing the spread of the virus led to the interruption of organized athletics at all levels, from youth sports to professional. T…
Boys Track team picks up a couple of wins in first MVC Dual Meet
BOSTON – The Tewksbury Memorial High School Boys Indoor Track-and-Field team opened its season on Tuesday afternoon at the Reggie Lewis Center. The scoring format placed Tewksbury against four other Merrimack Valley Conference Division 2 teams, with all of the athletes competing at once, and…
First defeated by Central before topping Methuen: Gymnastics team opens season, splits first two league meets
TEWKSBURY – Over the last handful of years, the Tewksbury Memorial High School Gymnastics team has made major strides, whether it's been historical team scores or huge wins, or individual league champions, this program has come a long way over the past half-dozen years or so.
Tewksbury Town Crier's 27th annual: Male Athlete of the Year — Jason Cooke
TEWKSBURY – In the previous 26 years that the Town Crier has named a Tewksbury Male Athlete of the Year, there's been a handful of top-rate, first-class young men. Certainly this year's choice, Jason Cooke, ranks right up at the top of that list.
Redmen too physical and powerful for Concord-Carlisle
TEWKSBURY – The Tewksbury Memorial High School Boys Hockey team opened the season last Wednesday night at home against Concord-Carlisle. From the second the puck was dropped to start the game, it was painfully obvious how much superior in every aspect of the game, that the Redmen were over t…
Boys Hoop team right with first three opponents
TEWKSBURY – Before meeting up with the Goliaths of the Merrimack Valley Conference, the Tewksbury Memorial High School Boys basketball team opened their season up against two Cape Ann League teams, first Masconomet last week and then Georgetown at home this past Thursday night. In both cases…
Callahan and Wilson come away with tournament titles
WILMINGTON – After finishing in fourth place at the Wilmington Sons of Italy Wrestling tournament back during the 2019-'20 season, then Tewksbury Memorial High School coach – and current assistant – Steve O'Keefe knew that the program had something special with Jack Callahan, who was a fresh…
Ryan drains three-pointer with seconds left to lift Redmen past Lowell
LOWELL – The old saying is "it's not how you start, it's how you finish" and that certainly applies to the Tewksbury Memorial High School Girls' Basketball team on Tuesday night.
Red Rangers split first two games; Driscoll nets 50th career goal
WESTFORD – The Tewksbury/Methuen Co-Op Girls' Hockey team opened the season this past week with two league games, losing a heartbreaker to Acton-Boxboro 1-0 before beating Westford Academy – no longer coached by TMHS Hall of Famer Bob Ware – by a 5-1 score.
Wrestling team places 15th at 30th annual SOI Tournament
WILMINGTON – On Saturday, the 30th annual Wilmington Sons of Italy Wrestling tournament was held at the Shriner's Auditorium. All three of our local teams – Wilmington, Tewksbury and Shawsheen Tech – did well, with five combined wrestlers in the finals, and three coming away with championshi…
Shawsheen Tech Sports Round-Up: Swimmers split first two meets; Boys Hoop off to 2-1 start
BILLERICA – It was a mixed bag of results for the Shawsheen Tech Swim team in their opening week of the season, as the Rams picked up a big win in their season opener, winning in comfortable fashion over CAC rival Greater Lawrence in the season opener at home last Wednesday by a score of 83-…
Tewksbury Town Crier's 27th annual: Female Athlete of the Year — Carrina Barron
TEWKSBURY – In the previous 26 years of the Town Crier's Female Athlete of the Year – excluding last year as there wasn't one due to COVID – there's only two people on the list who were chosen during their underclassmen years, Kelly Boyle was a three-time overall winner who was chosen as a s…
On the court, Redmen looking to keep tradition going
TEWKSBURY – You have to go back to what's believed to be the 2005-'06 season the last time the Tewksbury Memorial High School Girls' Basketball team did not qualify for the state tournament – excluding this past COVID-19 abbreviated season.
TMHS Boys Hockey Preview: Depth, size and experience, Redmen have it all
TEWKSBURY – Tewksbury Memorial High School Boys Hockey coach Derek Doherty was asked a pretty easy question, "how does the team look"? With a dead serious look on his face, he replied, "They're here to win. You can tell by their faces."
Work ethic, attitudes, to hopefully lead boys hoop team to success
TEWKSBURY – After losing its starting five players and then a talented player off the bench to a transfer, the Tewksbury Memorial High School Boys' Basketball team will begin this season with basically a brand new team, all under the direction of Steve Boudreau, who officially takes over as …
With almost entire team back, Red Rangers have bigger goals
METHUEN/TEWKSBURY – Usually it takes teams a few weeks before they can get into the X's and O's because you hold tryouts, you get everyone situated, and you have new players who need to learn the tricks of the trade.
Coach Donovan always in everyone's hearts: Emotional season lies ahead for Rams Wrestling team
BILLERICA – This season will be a challenging one in many ways for the Shawsheen Tech Wrestling team. First of all, they wrestlers and coaches must deal with the emotions of heading into a season as they continue to mourn the loss of their legendary coach Mark Donovan, who passed away in Oct…
Longtime assistant Pratt takes over in an interim role
BILLERICA – Shawsheen Tech Athletic Director Al Costabile faced what seemed like an almost impossible task heading into the winter sports season, as he sought to find a new wrestling coach to take over for the legendary Mark Donovan, who had tragically died of cancer back in October the age of 55.
Despite lower numbers Girls Track team should be in the mix
TEWKSBURY – This past March and April, the 'Indoor Track season' was actually held outdoors due to COVID. It was held during the Fall-2 time, so athletes could squeeze in the indoor track season around their other normal winter sports seasons.
TMHS Wrestling Preview: Two-time league champions hungry for more
By JAMIE POTE Sports Correspondent jamiepote@hotmail.com
TEWKSBURY – Coming off back-to-back Merrimack Valley Conference Division 2 league championship seasons, including crowning a New England Champion two years ago, you would think that the well would be pretty dried up this season for the Tewksbury Memorial High School Wrestling team. On paper,…
Tewksbury Legendary Coaches Series: No legend bigger than 'Lefty'
This week we will conclude our long lasting series on 'Legendary Coaches' and it's pretty easy to put Bob "Lefty" Aylward into that category. This story on Aylward originally appeared in the June 27, 2007 edition.
New coach, same direction for Track Team — forward
TEWKSBURY – If you want to be a successful coach, no matter the level, your athletes must "buy-in". You can check off the first box of that for Tewksbury Memorial High School first-year boys indoor track coach Lauren Polimeno.
Four-time league champs have a goal to make it five in a row
BILLERICA – With all of the changes to high school hockey last season, the Shawsheen Tech Boys Hockey team made sure that at least one thing remained consistent, namely the Rams winning another CAC championship, or at least a share of it, splitting the league title with Essex Tech, for their…
Accolades continue to pour in for fall collegiate athletes
The accolades continue to come for a number of our local fall collegiate athletes. Over the last few weeks, the Town Crier has written about various awards that individuals have received, but the hardware keeps coming in for a small group of them.
Shawsheen Tech Boys Basketball Preview: On the court, talented squad gearing up for a big season
BILLERICA – Heading into last season, Shawsheen Tech Basketball coach Joe Gore and his staff knew they had a talented team on their hands, one they felt could certainly compete in a challenging Commonwealth Athletic Conference. But they also figured that perhaps they were about a year away f…
Reigning league champs, shooting for another title
BILLERICA – Over the past couple of seasons, many players and coaches have missed out on a lot due to the COVID-19 pandemic. One of those most affected this past basketball season was Shawsheen Tech Girls Basketball coach Kate Marshall, who was forced to miss the Rams season, a season which …
In the pool, Rams hoping to remain dominant
BILLERICA – The Shawsheen Tech Co-Ed Swim team has built an incredible winning tradition over the past decade, with the girls team winning 11 consecutive state vocational titles from 2011-2020, while the boys won four titles of their own, including three in a row from 2018-2020. They did thi…
On the ice, Rams striving for improvement and better results
BILLERICA – Last season was a unique one in many ways for the Shawsheen Tech/Bedford Girls Hockey team. First of all, of course, it was unique in the same way it was for every other team, with an abbreviated season, as well as some other rule changes due to the COVID-19 pandemic.
Former star player O'Shea, named new head coach
BILLERICA – When Kate O'Shea was a player for the Shawsheen Tech Girls Hockey team, putting together a fantastic four-year career which saw her score 107 career points before graduating in 2015, she left an indelible mark on the history of the Rams program, which has often struggled over the…
Shane Aylward, Lamothe honored again
Tewksbury Legendary Coach Series concludes: It all started with this legend — Charlie Hazel
By RICK COOKE & JAMIE POTE sports@yourtowncrier.com
TEWKSBURY – Over the past year or so, the Town Crier has been running a "legendary coaches" series here in Tewksbury. There were 14 previous coaches chosen for this series, which concludes this week with the final two, Bob Aylward (see story in this section) and below Charlie Hazel.
Kylie Jenner 'secures restraining order against obsessed fan'
Sinaloa Cartel operatives sentenced to prison in Southern District of California
From the Archives: Plane crashed down on South Border Road
What 'Valhalla's Heroes Have in Common With Ragnar Lothbrok of 'Vikings'
USDC on TRON Now Supported for Trading on Binance Exchange (1)


text:
When the first methane gas detector was launched in 2011, it was hailed as a milestone in the field of fossil detection.However, as the gas was detected, it revealed nothing about its origins or origin of origin.But now, with the detection of methane in the air, the story is...
Smoke detectors work by emitting a low-frequency sound called an acoustical wave.The sound can be heard from miles away, but it can also be detected by a detector in your house.But some detectors don't have enough power to see the sound from your own house, so you need to...
The Washington Metropolitan Area Transit Authority is testing a new technology to detect videos that are being played back on a mobile device.A system that uses a camera embedded in the device to detect video plays back video on a display that displays the time and duration of the...
The best home security solutions and smart home systems are available to help protect your home from the worst dangers, including harmful radon, according to the National Institute of Standards and Technology.But the best solutions come at a price: They require the purchase of expensive or highly specialized equipment,...
You can now buy a Free Photoshop detector in the United States.The company is offering the detector for $15.99 at the company's website.The Free Photoshot detector has a built-in light sensor that's capable of detecting up to 100 different colors of light, which is used by many different manufacturers.It...
'We need to put up with it': Resistance thermometers to replace gas detectors
In the aftermath of Hurricane Harvey, a large-scale, multi-national project called the National Resistance Temperature Detector Project (NRTDDP) has begun to operate.Its aim is to use thermometers in homes and buildings to identify whether someone is exposed to the heat of a given room.It also aims to provide information...
How to replace smoke detectors in your house
A new bill that would mandate smoke detectors for the entire country's homes passed the Senate on Wednesday, giving lawmakers a major boost to their efforts to tackle a national epidemic.The Smoke Detector Safety and Insurance Act, which was introduced by Sen. Bill Cassidy (R-La.), would force manufacturers of...
The Best Places to Watch Porn in America
PornHub is the king of porn, with millions of users watching videos of themselves, as well as their friends, family, and coworkers.And now, it has unveiled its biggest porn library yet, which includes over 70 million videos.It's also offering up a subscription option that lets you watch a total...
How to install a motion detector in your home
A motion detector, or motion tracker, is a device that tracks an object's motion using motion detectors.You can install one on your front door or anywhere else where you might want to keep track of an animal or other animal.You may be able to buy one from a store...
"I'm just a normal guy." -A man who got hit by a truck while using a new, non-Smoke Detection Smoke Detection (SDS) device
"I got hit in the head with a truck!" he told Vice News in the video."And then I had to be taken to the hospital.I got to see a doctor who was a little scared.She said, 'That guy is crazy.What is wrong with him?'I was like, 'He just hit...


text:
Direct from G20
It was a mindnumbingly early start this morning – I don't often get up at 5.45! I made it to the hotel on time, and then was whisked to the ExCel in the official convoy. The morning was crazy, as we got our bearings and did some recceing for the afternoon's press activities. The Commission President did two interviews before the summit started which was a really good idea, as he was one of the few. Mandelson was working the media section like the old hand he is, and between him and Geldof the whole place was all a-flutter for most of the morning. By ten o'clock it felt like it should have been hours later. It calmed down once we'd sorted everything like how many microphones to have in the press conference room (oh the glamour!) and so since then it's been occasional briefings, wandering round the media centre talking to people and catching up with e-mails etc from the office. I've been at Councils before, but not the big European Councils or a summit like and it has been really interesting to see the dynamic of an event like this. I worked at a G8 summit years ago when I was at college, but as that entailed sitting in a nice hotel in Knightsbridge and eating chocolate, I don't think it's a comparable experience!
We're all waiting for it to finish and then it'll be a whirl of press conferences and interviews, before heading off out in the convoy again. A day spent in a bubble – I don't even know what the weather is like outside!


text:
Seniors Hooked on Prescription Painkillers
Home | Health News
Tags: Diabetes | method | cooking | diabetes | risk
Can Method of Cooking Affect Diabetes Risk?
(Copyright iStock)
Friday, 02 September 2016 11:55 AM
Changing the way you cook could help reduce your risk of getting type 2 diabetes, a new study suggests.
Boiling, steaming and poaching look like the safest way to go, researchers say.
When you fry, grill or bake foods -- also called dry-heat cooking -- foods produce substances called advanced glycation end products (AGEs).
Higher levels of AGEs have been linked to insulin resistance, stress on the body's cells and inflammation, according to the study authors. These are troublemakers in terms of diabetes risk.
Insulin is a hormone that helps blood sugar from food get into cells for energy. Without insulin, or with insulin resistance, too much sugar remains in the blood. This can lead to serious problems for the heart, eyes, kidneys and other organs.
"When you look at people with chronic diseases like type 2 diabetes or dementia put on a high-AGE diet or a low one, those on the low-AGE diet show signs of decreasing inflammation," said the study's lead author, Dr. Jaime Uribarri. He's a professor of medicine at the Icahn School of Medicine at Mount Sinai in New York City.
For this study, however, the researchers wanted to see if a low-AGE diet could offer protection to people already at risk of developing type 2 diabetes. Conversely, the researchers believed that a regular Western diet, which is generally high in AGEs, might contribute to the risk of type 2 diabetes.
The researchers randomly assigned study participants to one of two diet groups. The regular-AGE diet group included 49 people; the low-AGE diet group had 51.
All were at least 50 years old. And they had at least two of the following five health concerns (or were on medications for these problems): a large waist circumference (40 inches for men, 35 for women); high blood pressure; low HDL (good) cholesterol; high triglycerides (another type of blood fat); or elevated fasting blood sugar levels.
Those in the low-AGE group were given instructions on how to lower the AGE content in their foods. They were told to avoid frying, baking or grilling foods. Instead, they were encouraged to boil, steam, stew or poach their meals -- in other words, cook with water.
Some examples of the changes made included substituting boiled eggs for fried eggs, poached chicken instead of grilled chicken, or beef stew instead of grilled steak, according to the study.
The study volunteers completed a three-day food record so the researchers could take into account the types of foods they ate. The researchers specifically asked that the participants not change the types of foods they ate, just the preparation of those foods. They also were instructed to try to eat the same amount of calories a day.
A dietitian checked in with the low-AGE group twice a week, and met with each person every three months to review their cooking methods and to encourage low-AGE cooking.
The regular-AGE group was instructed to continue cooking as they already did. The study lasted one year.
In the low-AGE group, "all the parameters in stress and inflammation we tested for improved. And we showed that insulin resistance came down," Uribarri said. "These findings are highly suggestive of a cause-and-effect relationship, but our study needs to be demonstrated again in a larger study with different sites, different populations and different habits."
Body weight dropped slightly in the low-AGE group, and no side effects were seen, the authors said.
"We imagine the more you [cook with low-AGE methods], the better. We think it will be proportionate," Uribarri said.
But one specialist thinks just switching cooking techniques isn't enough to curb diabetes risk.
"We know that we have AGEs that are increased by cooking, but many foods themselves are also high in AGEs. So, in addition to changing how we cook, we also want to change what we're eating," said Samantha Heller. She's a senior clinical nutritionist at New York University Langone Medical Center in New York City.
"I think it's more important to focus on the quality of your food choices. Vegetables and other plant foods aren't as high in AGEs," she noted.
But, Heller added, nutrition experts often emphasize making small changes. And switching to lower-AGE cooking methods for at least some of your meals may be one way to start making small, healthy changes.
Study results were recently published in Diabetologia.
© HealthDay
Changing the way you cook could help reduce your risk of getting type 2 diabetes, a new study suggests.Boiling, steaming and poaching look like the safest way to go, researchers say.When you fry, grill or bake foods -- also called dry-heat cooking -- foods produce...
method, cooking, diabetes, risk
The information presented on this website is not intended as specific medical advice and is not a substitute for professional medical treatment or diagnosis. Read Newsmax Terms and Conditions of Service.
Contact | Advertise | Shop | RSS | Archives | Links | Careers Privacy Policy | Terms & Conditions


text:
------------------------------------------------------------------------------------------
-- Task 1. Create a database with two tables: Persons(Id(PK), FirstName, LastName, SSN)	--
-- and Accounts(Id(PK), PersonId(FK), Balance). Insert few records for testing.			--
-- Write a stored procedure that selects the full names of all persons.					--
------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------
-- Create table																			--
------------------------------------------------------------------------------------------

USE [master]
GO
CREATE DATABASE [PersonsAccounts]
 CONTAINMENT = NONE
GO
ALTER DATABASE [PersonsAccounts] SET COMPATIBILITY_LEVEL = 120
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [PersonsAccounts].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [PersonsAccounts] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [PersonsAccounts] SET ANSI_NULLS OFF
GO
ALTER DATABASE [PersonsAccounts] SET ANSI_PADDING OFF
GO
ALTER DATABASE [PersonsAccounts] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [PersonsAccounts] SET ARITHABORT OFF
GO
ALTER DATABASE [PersonsAccounts] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [PersonsAccounts] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [PersonsAccounts] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [PersonsAccounts] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [PersonsAccounts] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [PersonsAccounts] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [PersonsAccounts] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [PersonsAccounts] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [PersonsAccounts] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [PersonsAccounts] SET  DISABLE_BROKER
GO
ALTER DATABASE [PersonsAccounts] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [PersonsAccounts] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [PersonsAccounts] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [PersonsAccounts] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [PersonsAccounts] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [PersonsAccounts] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [PersonsAccounts] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [PersonsAccounts] SET RECOVERY FULL
GO
ALTER DATABASE [PersonsAccounts] SET  MULTI_USER
GO
ALTER DATABASE [PersonsAccounts] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [PersonsAccounts] SET DB_CHAINING OFF
GO
ALTER DATABASE [PersonsAccounts] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [PersonsAccounts] SET TARGET_RECOVERY_TIME = 0 SECONDS
GO
ALTER DATABASE [PersonsAccounts] SET DELAYED_DURABILITY = DISABLED
GO
EXEC sys.sp_db_vardecimal_storage_format N'PersonsAccounts', N'ON'
GO
USE [PersonsAccounts]
GO
/****** Object:  Table [dbo].[Accounts]    Script Date: 21.8.2014 ã. 15:00:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Accounts](
	[AccountID] [int] IDENTITY(1,1) NOT NULL,
	[Balance] [money] NOT NULL,
	[PersonID] [int] NOT NULL,
 CONSTRAINT [PK_Accounts] PRIMARY KEY CLUSTERED
(
	[AccountID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Persons]    Script Date: 21.8.2014 ã. 15:00:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Persons](
	[PersonID] [int] IDENTITY(1,1) NOT NULL,
	[FirstName] [nvarchar](50) NOT NULL,
	[LastName] [nvarchar](50) NOT NULL,
	[SSN] [nvarchar](9) NOT NULL,
 CONSTRAINT [PK_Persons] PRIMARY KEY CLUSTERED
(
	[PersonID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET IDENTITY_INSERT [dbo].[Accounts] ON

GO
INSERT [dbo].[Accounts] ([AccountID], [balance], [PersonID]) VALUES (1, CAST(123 AS Decimal(18, 0)), 1)
GO
INSERT [dbo].[Accounts] ([AccountID], [balance], [PersonID]) VALUES (2, CAST(0 AS Decimal(18, 0)), 2)
GO
INSERT [dbo].[Accounts] ([AccountID], [balance], [PersonID]) VALUES (3, CAST(1000 AS Decimal(18, 0)), 3)
GO
SET IDENTITY_INSERT [dbo].[Accounts] OFF
GO
SET IDENTITY_INSERT [dbo].[Persons] ON

GO
INSERT [dbo].[Persons] ([PersonID], [FirstName], [LastName], [SSN]) VALUES (1, N'John', N'Doe', N'123456789')
GO
INSERT [dbo].[Persons] ([PersonID], [FirstName], [LastName], [SSN]) VALUES (2, N'Peter', N'Griffin', N'000000000')
GO
INSERT [dbo].[Persons] ([PersonID], [FirstName], [LastName], [SSN]) VALUES (3, N'Aeryn', N'Sun', N'344522345')
GO
SET IDENTITY_INSERT [dbo].[Persons] OFF
GO
ALTER TABLE [dbo].[Accounts]  WITH CHECK ADD  CONSTRAINT [FK_Accounts_Persons] FOREIGN KEY([PersonID])
REFERENCES [dbo].[Persons] ([PersonID])
GO
ALTER TABLE [dbo].[Accounts] CHECK CONSTRAINT [FK_Accounts_Persons]
GO

------------------------------------------------------------------------------------------
-- Create procedure																		--
------------------------------------------------------------------------------------------
use [PersonsAccounts]
GO

CREATE PROC dbo.ups_SelectPersonsFullName
AS
	SELECT FirstName +' '+ LastName as FullName
	FROM Persons
GO

EXEC dbo.ups_SelectPersonsFullName
GO

------------------------------------------------------------------------------------------
-- Task 2. Create a stored procedure that accepts a number as a parameter and returns	--
-- all persons who have more money in their accounts than the supplied number.			--
------------------------------------------------------------------------------------------
use [PersonsAccounts]
GO

CREATE PROC dbo.ups_SelectPersonsWithMoneyMoreThan(@money int = 0)
AS
	SELECT p.PersonID, a.TotalBalance as money
	FROM Persons p INNER JOIN
	(SELECT acc.PersonID, SUM (acc.Balance) as TotalBalance
	FROM Accounts acc
	GROUP BY acc.PersonID
	) as a on p.PersonID=a.PersonID
	where a.TotalBalance >= @money
GO

EXEC dbo.ups_SelectPersonsWithMoneyMoreThan 100
GO

------------------------------------------------------------------------------------------
-- Task 3. Create a function that accepts as parameters – sum, yearly interest rate		--
-- and number of months. It should calculate and return the new sum. Write a SELECT to	--
-- test whether the function works as expected.											--
------------------------------------------------------------------------------------------
use [PersonsAccounts]
GO

CREATE FUNCTION [dbo].ufn_CalcInterest(@sum money, @interestRate decimal, @months decimal)
  RETURNS money
AS
BEGIN
  RETURN @sum + @sum*((@interestRate*@months/12)/100)
END
GO

SELECT dbo.ufn_CalcInterest(100, 30, 6) as NewSum
GO

------------------------------------------------------------------------------------------
-- Task 4. Create a stored procedure that uses the function from the previous example	--
-- to give an interest to a person's account for one month. It should take the AccountId--
-- and the interest rate as parameters.													--
------------------------------------------------------------------------------------------
use [PersonsAccounts]
GO

CREATE PROC dbo.ups_OneMonthInterest(@AccountID int, @interestRate decimal)
AS
	UPDATE Accounts
	SET Balance = dbo.ufn_CalcInterest(Balance, @interestRate, 1)
	WHERE AccountID=@AccountID
GO

EXEC dbo.ups_OneMonthInterest 1, 20.00;
GO

------------------------------------------------------------------------------------------
-- Task 5. Add two more stored procedures WithdrawMoney( AccountId, money) and			--
-- DepositMoney (AccountId, money) that operate in transactions.						--
------------------------------------------------------------------------------------------
use [PersonsAccounts]
GO

CREATE PROC dbo.ups_WithdrawMoney(@AccountID int, @money decimal)
AS
	BEGIN TRAN
	DECLARE @newBalance money

	IF NOT EXISTS(SELECT 1 FROM Accounts WHERE AccountID = @AccountID)
		BEGIN
			ROLLBACK TRAN
			RAISERROR('Incorrect AccountID', 16, 1)
		END
	ELSE
		BEGIN
		SELECT @newBalance = Balance - @money
		FROM Accounts
		WHERE AccountID=@AccountID
		IF(@newBalance<0)
			BEGIN
				ROLLBACK TRAN
				RAISERROR('Not enough money in account', 16, 1)
			END
		ELSE
			BEGIN
				UPDATE Accounts
				SET Balance = @newBalance
				WHERE AccountID=@AccountID
				COMMIT
			END
		END
GO

CREATE PROC dbo.ups_DepositMoney(@AccountID int, @money decimal)
AS
	BEGIN TRAN
	DECLARE @newBalance money

	IF NOT EXISTS(SELECT 1 FROM Accounts WHERE AccountID = @AccountID)
		BEGIN
			ROLLBACK TRAN
			RAISERROR('Incorrect AccountID', 16, 1)
		END
	ELSE
		BEGIN
		SELECT @newBalance = Balance + @money
		FROM Accounts
		WHERE AccountID=@AccountID
			UPDATE Accounts
			SET Balance = @newBalance
			WHERE AccountID=@AccountID
			COMMIT
		END
GO

-- This statment producess error
/*
EXEC dbo.ups_WithdrawMoney 12, 100.00;
GO
*/

EXEC dbo.ups_WithdrawMoney 1, 100.00;
GO

-- This statment producess error
/*
EXEC dbo.ups_WithdrawMoney 1, 200.00;
GO
*/

EXEC dbo.ups_DepositMoney 1, 100.00;
GO

------------------------------------------------------------------------------------------
-- Task 6. Create another table – Logs(LogID, AccountID, OldSum, NewSum).				--
-- Add a trigger to the Accounts table that enters a new entry into the Logs table every--
-- time the sum on an account changes.													--
------------------------------------------------------------------------------------------
use [PersonsAccounts]
GO

CREATE TABLE Logs
(
  LogID int IDENTITY,
  AccountID int NOT NULL,
  OldSum money,
  NewSum money,
  ChangeDate datetime,
  CONSTRAINT PK_LogID PRIMARY KEY(LogID)
)
GO

ALTER TABLE [dbo].[Logs]  WITH CHECK ADD  CONSTRAINT [FK_Logs_Accounts] FOREIGN KEY([AccountID])
REFERENCES [dbo].[Accounts] ([AccountID])
GO

CREATE TRIGGER tr_AccountsUpdate ON Accounts FOR UPDATE
AS
  INSERT INTO Logs (AccountID, OldSum, NewSum, ChangeDate)
  SELECT d.AccountID, d.Balance, i.Balance, GETDATE()
  FROM deleted d INNER JOIN inserted i on d.AccountID = i.AccountID
GO

CREATE TRIGGER tr_AccountsInsert ON Accounts FOR INSERT
AS
  INSERT INTO Logs (AccountID, OldSum, NewSum, ChangeDate)
  SELECT i.AccountID, NULL, i.Balance, GETDATE()
  FROM inserted i
GO

CREATE TRIGGER tr_AccountsDelete ON Accounts FOR DELETE
AS
  INSERT INTO Logs (AccountID, OldSum, NewSum, ChangeDate)
  SELECT d.AccountID, d.Balance, NULL, GETDATE()
  FROM deleted d
GO

-- Test account update
EXEC dbo.ups_DepositMoney 3, 100.00;
GO

-- Test account insert
INSERT INTO Accounts
VALUES (2000, 1)
GO

-- Test account delete. It doesn't work because of the FK constraint for logs.
-- It should be done with deletedFlag in accounts and using insted of Trigger
/*
DELETE FROM Accounts
WHERE AccountID =
(SELECT AccountID FROM Logs
WHERE ChangeDate =
(SELECT MAX(ChangeDate) FROM Logs))
GO
*/

------------------------------------------------------------------------------------------
-- Task 7. Define a function in the database TelerikAcademy that returns all Employee's	--
-- names (first or middle or last name) and all town's names that are comprised of		--
-- given set of letters. Example 'oistmiahf' will return 'Sofia', 'Smith',				--
-- … but not 'Rob' and 'Guy'.															--
------------------------------------------------------------------------------------------

USE [TelerikAcademy]
GO

-- Using helper function that finds if a string consists of other string

IF OBJECT_ID('dbo.ufn_StringComprisedOf') IS NOT NULL DROP FUNCTION ufn_StringComprisedOf
GO

CREATE FUNCTION [dbo].ufn_StringComprisedOf(@inputString nvarchar(50), @letterSet nvarchar(100))
  RETURNS BIT
AS
  BEGIN
	DECLARE @inputStringLenght int
	DECLARE @currentIndex int
	DECLARE @input nvarchar(50)
	DECLARE @pattern nvarchar(100)
	SET @inputStringLenght = LEN(@inputString)
	SET @currentIndex = 1
	SET @input = LOWER(@inputString)
	SET @pattern = LOWER(@letterSet)

	WHILE @currentIndex <= @inputStringLenght
	  BEGIN
		IF(CHARINDEX(SUBSTRING(@input,@currentindex,1),@pattern)=0)
		  BEGIN
			RETURN 0
		  END
		SET @currentIndex = @currentIndex +1
	  END
	RETURN 1
  END
GO

IF OBJECT_ID('dbo.ufn_EmployeesAndTownsNameComprisedOf') IS NOT NULL DROP FUNCTION ufn_EmployeesAndTownsNameComprisedOf
GO

CREATE FUNCTION [dbo].ufn_EmployeesAndTownsNameComprisedOf(@letterSet nvarchar(100))
  RETURNS @reulst_table TABLE (name nvarchar(50))
AS
BEGIN

DECLARE empCursor CURSOR READ_ONLY FOR
  SELECT Name FROM (
  SELECT FirstName AS Name FROM Employees
  UNION
  SELECT MiddleName AS Name FROM Employees
  UNION
  SELECT LastName AS Name FROM Employees
  UNION
  SELECT Name AS Name FROM Towns
  ) AS Names
  WHERE Name IS NOT NULL

OPEN empCursor
DECLARE @name nvarchar(50)
FETCH NEXT FROM empCursor INTO @name

DECLARE @nameLen int, @currentIndex int

WHILE @@FETCH_STATUS = 0
  BEGIN
	IF(dbo.ufn_StringComprisedOf(@name,@letterSet)=1)
	  BEGIN
	    INSERT INTO @reulst_table
		VALUES (@name)
	  END
    FETCH NEXT FROM empCursor
    INTO @name
  END

CLOSE empCursor
DEALLOCATE empCursor
  RETURN
END
GO

SELECT * FROM [dbo].ufn_EmployeesAndTownsNameComprisedOf('oistmiahf')
GO

------------------------------------------------------------------------------------------
-- Task 8. Using database cursor write a T-SQL script that scans all employees and		--
-- their addresses and prints all pairs of employees that live in the same town.		--
------------------------------------------------------------------------------------------

USE [TelerikAcademy]
GO

SELECT e.EmployeeID ,e.FirstName + ISNULL(' '+ e.MiddleName, '') + ' ' + e.LastName AS EmployeeName, t.TownID, t.Name as TownName
INTO #TempEmployeesWithTowns
FROM Employees e INNER JOIN Addresses a on e.AddressID = a.AddressID
INNER JOIN Towns t on a.TownID = t.TownID
CREATE UNIQUE CLUSTERED INDEX Idx_TemEmp ON #TempEmployeesWithTowns(EmployeeID)

DECLARE empCursor CURSOR READ_ONLY FOR
SELECT EmployeeID, EmployeeName, TownID,TownName
FROM #TempEmployeesWithTowns

OPEN empCursor
DECLARE @employeeID int, @employeeName varchar(150), @townID int,  @townName varchar(50)
FETCH NEXT FROM empCursor INTO @employeeID, @employeeName, @townID, @townName

CREATE TABLE #TempEmployeeFromSameTownPairs (FirstEmployeeName varchar(150), SecondEmployeeName varchar(150), TownName varchar(50))
WHILE @@FETCH_STATUS = 0
  BEGIN
	INSERT INTO #TempEmployeeFromSameTownPairs (FirstEmployeeName, SecondEmployeeName, TownName)
	SELECT @employeeName, EmployeeName, @townName FROM #TempEmployeesWithTowns e
	WHERE e.TownID = @townID AND e.EmployeeID <> @employeeID
    FETCH NEXT FROM empCursor INTO @employeeID, @employeeName, @townID, @townName
  END
CLOSE empCursor
DEALLOCATE empCursor

SELECT TownName, FirstEmployeeName, SecondEmployeeName FROM #TempEmployeeFromSameTownPairs
ORDER BY TownName, FirstEmployeeName, SecondEmployeeName
DROP TABLE #TempEmployeeFromSameTownPairs
DROP TABLE #TempEmployeesWithTowns
GO

-- This is the outer join way to do it without a db cursor

SELECT t1.Name, e1.FirstName + ISNULL(' '+ e1.MiddleName, '') + ' ' + e1.LastName AS FirstEmployeeName,
e2.FirstName + ISNULL(' '+ e2.MiddleName, '') + ' ' + e2.LastName AS SecondEmployeeName
FROM Employees e1 JOIN Addresses a1 ON e1.AddressID = a1.AddressID
JOIN Towns t1 ON a1.TownID = t1.TownID,
Employees e2 JOIN Addresses a2 ON e2.AddressID = a2.AddressID
JOIN Towns t2 ON a2.TownID = t2.TownID
WHERE t1.Name = t2.Name
AND e1.EmployeeID <> e2.EmployeeID
ORDER BY t1.Name, FirstEmployeeName, SecondEmployeeName

------------------------------------------------------------------------------------------
-- Task 9. Write a T-SQL script that shows for each town a list of all employees		--
-- that live in it. Sample output: Sofia -> Svetlin Nakov, Martin Kulov, George Denchev	--
-- Ottawa -> Jose Saraiva																--
------------------------------------------------------------------------------------------

-- Solution with nested Cursors. Prints in Messages Window

USE [TelerikAcademy]
GO

SELECT e.FirstName + ISNULL(' '+ e.MiddleName, '') + ' ' + e.LastName AS EmployeeName, t.TownID
INTO #TempEmployeesWithTowns
FROM Employees e INNER JOIN Addresses a on e.AddressID = a.AddressID
INNER JOIN Towns t on a.TownID = t.TownID
CREATE INDEX Idx_TemTown ON #TempEmployeesWithTowns(TownID)

DECLARE townCursor CURSOR READ_ONLY FOR
SELECT TownID, Name FROM Towns
OPEN townCursor
DECLARE @townID int, @townName varchar(50)
FETCH NEXT FROM townCursor INTO @townID, @townName
WHILE @@FETCH_STATUS = 0
  BEGIN
    DECLARE empCursor CURSOR READ_ONLY FOR
	SELECT EmployeeName FROM #TempEmployeesWithTowns
	WHERE TownID = @townID

	OPEN empCursor
	DECLARE @employeeName varchar(150), @employeesList varchar(MAX)
	SET @employeesList = ''
	FETCH NEXT FROM empCursor INTO @employeeName

	WHILE @@FETCH_STATUS = 0
	  BEGIN
		SET @employeesList = CONCAT(@employeesList, @employeeName, ', ')
		FETCH NEXT FROM empCursor INTO @employeeName
	  END
	CLOSE empCursor
	DEALLOCATE empCursor
	SET @employeesList = LEFT(@employeesList, LEN(@employeesList) - 1)
	PRINT @townName + ' -> ' + @employeesList
	FETCH NEXT FROM townCursor INTO @townID, @townName
  END
CLOSE townCursor
DEALLOCATE townCursor
DROP TABLE #TempEmployeesWithTowns
GO

------------------------------------------------------------------------------------------
-- Task 10. Define a .NET aggregate function StrConcat that takes as input a sequence of--
-- strings and return a single string that consists of the input strings separated by	--
-- ','. For example the following SQL statement should return a single string:			--
-- SELECT StrConcat(FirstName + ' ' + LastName) FROM Employees							--
------------------------------------------------------------------------------------------

USE [TelerikAcademy]
GO

IF OBJECT_ID('dbo.StrConcat') IS NOT NULL DROP Aggregate StrConcat
GO

IF EXISTS (SELECT * FROM sys.assemblies WHERE name = 'concat_assembly')
       DROP assembly concat_assembly;
GO

DECLARE @path nvarchar(256)
-- You must change this path to the folder where the .dll with the CLR function is.
SET @path = 'C:\PathToFile'

CREATE Assembly concat_assembly
   AUTHORIZATION dbo
   FROM @path+'\ConcatAggregateSqlFunction.dll'
   WITH PERMISSION_SET = SAFE;
GO

CREATE AGGREGATE dbo.StrConcat (

    @Value NVARCHAR(MAX),
	@Delimiter NVARCHAR(4000)

) RETURNS NVARCHAR(MAX)
EXTERNAL Name concat_assembly.Concat;
GO

-- Enable execution of CLR code
sp_configure 'clr enabled',1
GO
RECONFIGURE
GO
--sp_configure 'clr enabled'  -- make sure it took
--GO

SELECT [dbo].StrConcat(FirstName + ' ' + LastName, ', ') as Names
FROM Employees

------------------------------------------------------------------------------------------
-- Solution to Task 9 with StrConcat from Task10										--
------------------------------------------------------------------------------------------

USE [TelerikAcademy]
GO

SELECT t.Name AS Town, [dbo].StrConcat(FirstName + ' ' + LastName, ', ') AS Employees
FROM Employees e INNER JOIN Addresses a ON e.AddressID = a.AddressID
INNER JOIN Towns t ON t.TownID = a.TownID
GROUP BY t.Name
ORDER BY t.Name

-- You might want to disable CLR execution afterwords
/*
sp_configure 'clr enabled',0
GO
RECONFIGURE
GO
sp_configure 'clr enabled'  -- make sure it took
GO
*/

redpajama_set_name: RedPajamaGithub


Join the CAWV and BrickStreet Insurance for a Trenching and Excavation Safety Seminar on Friday, February 1, from 8:00 a.m. to 12:00 p.m. at BrickStreet headquarters. This training is for business owners, safety managers, equipment operators, employees and anyone who needs to learn how to prevent the loss of life around excavation sites and avoid OSHA fines. This seminar fulfills one of the CAWV/BrickStreet Safety Program seminar requirements. The fee is $35 for CAWV members and $50 for future members. A registration form is attached to this week's newsletter. Contact Pat McDonald at (304) 342-1166, or email pmcdonald@cawv.org, for more information.