text:
Approach and services
How we work with companies
How we work with civil society
How we work with governments
Artisanal and Small Scale Mining
Land Access and Resettlement
Community Investment and Partnerships
Local Government and Development
Conflict and Grievances
Local Supplier Development
Human Rights and Security
Sustainable Livelihoods and Skills Building
Water and Communities
In Their Own Words: Stephanny Arroyo Arce & Belen CastueraValerie Prassi2019-03-14T16:35:29+00:00
In Their Own Words: Stephanny Arroyo Arce & Belen Castuera
Stephanny Arroyo Arce is a jaguar scientist who works in Costa Rica for the conservation organization Panthera. At the 2018 Sustainability Exchange, she spoke with Belen Castuera of IFC about balancing biodiversity and development.
Belen Castuera: Stephanny. When people ask what you do for a living, what do you say? Because when I'm asked, I say I'm a banker. The conversation is over. End of story. But in your case you work with jaguars, with a tracker dog… I find it so interesting.
Stephanny Arroyo Arce: Yes, sometimes it's a bit complicated. I tell them I'm a biologist. And then 'what do you do'? And I say 'well, I go on field trips throughout Costa Rica looking for feline feces.' And they ask 'what do you mean?' So I explain that it's a genetic tracking project, that I work with a Labrador retriever. And people become very interested in the work.
Belen: When did you realize that things like jaguars, Reventazon, and Costa Rica's hydropower generation were connected?
Stephanny: Reventazon is the largest hydropower project in Central America – so it is going to have a potential impact on biodiversity. It is in an area that is very important for the conservation of jaguars. Panthera started monitoring activities to understand what the area was like before construction started so that the impact of the project on biodiversity could be understood and so that mitigation measures could be put in place to avoid cutting off this route for the jaguars.
Stephanie Arroyo Arce trains her dog, Tigre to track the excrements of Jaguars, and other wild cats, in Guacimo, Costa Rica. Photo © Dominic Chavez / IFC
A jaguar at the Centro de Rescate Las Pumas in Canas, Costa Rica.
Photo © Dominic Chavez / IFC
Belen: You are doing work that is at the forefront of the conservation of jaguars.  And it is important to us at IFC that we can support renewable energy and also demonstrably protect biodiversity in this way. Revantazon has helped Costa Rica become a country that runs on nearly 100% renewable energy.  There are so many different aspects that make this really special.
Stephanny: It is great to see how different organizations with perhaps different interests are working together to identify the impact of such a project on jaguars and all the other wildlife species in the area.
Belen: What is your favorite story?
"It is important to us at IFC that we can support renewable energy and also demonstrably protect biodiversity. " – Belen Castuera
Stephanny: It's meaningful to work with communities, so they can protect the animals living near them. In Tortuguero, a national park in Costa Rica, sometimes we had situations where people wanted to get close to a jaguar when they saw one, and that worried us. Then we started to give presentations to explain the importance of not disturbing the jaguars and their habitat. We have seen that over time that people behave differently – respecting the jaguar when they see one, not wanting to go near it or take a picture of it, and even passing me the data when they are aware of a jaguar's presence. I get messages on WhatsApp saying 'Stephanny, I saw this jaguar at night, at this time.' Or when they see footprints on the beach they say 'Stephanny, I saw this in case the data is useful.'
Belen: Technology is amazing. A few years ago receiving a WhatsApp of a photo of a jaguar footprint would be unthinkable, really.
Stephanny: It has helped us a lot and it's very gratifying to see the improved trust between communities and wild cats living around them. They are neighbors after all.
Stephanie Arroyo Arce and her dog, Tigre near La Esmeralda, Costa Rica.
Employees of ICE, working to maintain and produce electricity at the Reventazon power station in Siquerres, Costa Rica. Photo © Dominic Chavez / IFC
Belen: What is the greatest lesson you think you have learned in your work?
Stephanny: When I started college I only wanted to work with animals, I did not want to work with people. But I realized over time that this is not possible – if you want to do conservation you have to reach people first because at the end of the day they are the ones who take the decisions. On the one hand I need to be in the field and collect and publish data. But I always need to ensure that the data makes sense to people in government, in municipalities, and in communities, because that's how they will want to protect these animals.
With support from StoryCorps, a U.S. nonprofit whose mission is to preserve and share humanity's stories in order to build connections between people and create a more just and compassionate world.
About IFC
IFC—a sister organization of the World Bank and member of the World Bank Group—is the largest global development institution focused on the private sector in emerging markets. We work with more than 2,000 businesses worldwide, using our capital, expertise, and influence to create markets and opportunities in the toughest areas of the world. For more information, visit www.ifc.org
Tweets from https://twitter.com/vnyhanjones/lists/tweets
WE APPRECIATE YOUR FEEDBACK
Fill out our short survey here.
» IFC
» IFC Financial Valuation Tool
» IFC Oil, Gas and Mining
» IFC Performance Standards
» IFC Sustainability
» World Bank Extractive Industries
» GOXI Sharing in Governance of Extractive Industries
» Extractive Industries Transparency Initiative (EITI)
Privacy Policy | Copyright Statement | Terms of Use


text:
What makes a good journalist? Empathy as a resource in journalistic work practice
Antje Glück
Empathy performs a central role in regulating social relations. This applies equally to journalistic work routines. To explore the concept of empathy in the understanding of journalists, 46 interviews were conducted using a cross-cultural approach between the United Kingdom and India. It became clear that empathy occupies a central place in news production, fulfilling multiple roles. It serves to achieve a comprehensive access to information and to news protagonists at the interpersonal level. Without this "invisible" mode of communication, qualitative and ethical news journalism cannot be achieved; and the authenticity and emotionality of news packages would be diminished. Empathy varies on the individual level, but especially in sensitive journalistic work fields it represents a "naturally present" core skill for journalists. A final empathic dimension is found in the imaginary empathy towards the audience which provides essential guidance for journalistic news products. Cultural differences between India and the United Kingdom are apparent in this study, but results also indicate considerable similarities in the role of empathy in different journalism cultures.
Journalism Studies
https://doi.org/10.1080/1461670X.2016.1175315Licence: Unspecified
Fingerprint Dive into the research topics of 'What makes a good journalist? Empathy as a resource in journalistic work practice'. Together they form a unique fingerprint.
empathy Social Sciences
journalist Social Sciences
news Social Sciences
Communication Engineering & Materials Science
resources Social Sciences
journalism Social Sciences
India Social Sciences
emotionality Social Sciences
Glück, A. (2016). What makes a good journalist? Empathy as a resource in journalistic work practice. Journalism Studies, 17(7), 893-903. https://doi.org/10.1080/1461670X.2016.1175315
Glück, Antje. / What makes a good journalist? Empathy as a resource in journalistic work practice. In: Journalism Studies. 2016 ; Vol. 17, No. 7. pp. 893-903.
@article{b932193d653e443fa27c24407a78cb8a,
title = "What makes a good journalist?: Empathy as a resource in journalistic work practice",
abstract = "Empathy performs a central role in regulating social relations. This applies equally to journalistic work routines. To explore the concept of empathy in the understanding of journalists, 46 interviews were conducted using a cross-cultural approach between the United Kingdom and India. It became clear that empathy occupies a central place in news production, fulfilling multiple roles. It serves to achieve a comprehensive access to information and to news protagonists at the interpersonal level. Without this "invisible" mode of communication, qualitative and ethical news journalism cannot be achieved; and the authenticity and emotionality of news packages would be diminished. Empathy varies on the individual level, but especially in sensitive journalistic work fields it represents a "naturally present" core skill for journalists. A final empathic dimension is found in the imaginary empathy towards the audience which provides essential guidance for journalistic news products. Cultural differences between India and the United Kingdom are apparent in this study, but results also indicate considerable similarities in the role of empathy in different journalism cultures.",
author = "Antje Gl{\"u}ck",
journal = "Journalism Studies",
Glück, A 2016, 'What makes a good journalist? Empathy as a resource in journalistic work practice', Journalism Studies, vol. 17, no. 7, pp. 893-903. <https://doi.org/10.1080/1461670X.2016.1175315>
What makes a good journalist? Empathy as a resource in journalistic work practice. / Glück, Antje.
In: Journalism Studies, Vol. 17, No. 7, 03.05.2016, p. 893-903.
T1 - What makes a good journalist?
T2 - Empathy as a resource in journalistic work practice
AU - Glück, Antje
N2 - Empathy performs a central role in regulating social relations. This applies equally to journalistic work routines. To explore the concept of empathy in the understanding of journalists, 46 interviews were conducted using a cross-cultural approach between the United Kingdom and India. It became clear that empathy occupies a central place in news production, fulfilling multiple roles. It serves to achieve a comprehensive access to information and to news protagonists at the interpersonal level. Without this "invisible" mode of communication, qualitative and ethical news journalism cannot be achieved; and the authenticity and emotionality of news packages would be diminished. Empathy varies on the individual level, but especially in sensitive journalistic work fields it represents a "naturally present" core skill for journalists. A final empathic dimension is found in the imaginary empathy towards the audience which provides essential guidance for journalistic news products. Cultural differences between India and the United Kingdom are apparent in this study, but results also indicate considerable similarities in the role of empathy in different journalism cultures.
AB - Empathy performs a central role in regulating social relations. This applies equally to journalistic work routines. To explore the concept of empathy in the understanding of journalists, 46 interviews were conducted using a cross-cultural approach between the United Kingdom and India. It became clear that empathy occupies a central place in news production, fulfilling multiple roles. It serves to achieve a comprehensive access to information and to news protagonists at the interpersonal level. Without this "invisible" mode of communication, qualitative and ethical news journalism cannot be achieved; and the authenticity and emotionality of news packages would be diminished. Empathy varies on the individual level, but especially in sensitive journalistic work fields it represents a "naturally present" core skill for journalists. A final empathic dimension is found in the imaginary empathy towards the audience which provides essential guidance for journalistic news products. Cultural differences between India and the United Kingdom are apparent in this study, but results also indicate considerable similarities in the role of empathy in different journalism cultures.
JO - Journalism Studies
JF - Journalism Studies
Glück A. What makes a good journalist? Empathy as a resource in journalistic work practice. Journalism Studies. 2016 May 3;17(7):893-903.

redpajama_set_name: RedPajamaCommonCrawl


text:
Robert Knox ( - ) fue un médico, naturalista y viajero británico, sobre todo conocido por su implicación en la compra de cadáveres, en Edimburgo, de víctimas de los asesinos en serie William Burke y William Hare.

El caso del robo de cadáveres (e incluso el asesinato para luego recuperar los cadáveres y su posterior uso en las clases de anatomía) se popularizó a partir del cuento El ladrón de cadáveres, escrito por Robert Louis Stevenson. En este relato, Robert Knox es mencionado como "el doctor K".

El cine también se interesó varias veces en esta singular historia. Entre otros títulos: El recuperador de cadáveres (1945, en inglés The Body Snatcher, en francés Le Récupérateur de cadavres), The Greed of William Hart (1948), The Anatomist (1961), Burke and Hare, de Vernon Sewell (1972), The Doctor and the Devils (1985) y Burke and Hare.

Según numerosos antropólogos modernos, la principal característica de Robert Knox era su racismo virulento, y por ello admitía comprar cadáveres (cosa por otro lado bastante frecuente en aquella época), y además obviamente ello eclipsó algunos de sus descubrimientos.

Otros datos
Sobre el destino de este médico se ha señalado: "...Al cirujano Robert Knox nadie le creyó en sus protestas de desconocer la verdadera procedencia de los cadáveres y de haberlos comprado en beneficio del progreso de la medicina. Aun cuando consiguió eludir la aplicación de cargos penales, quedó sumamente desprestigiado. Una colérica multitud atacó a pedradas su residencia, y la policía lo salvó por poco del linchamiento. Meses más tarde se vio obligado a huir deshonrado de la ciudad, y pasó a ejercer su profesión oscuramente en la localidad de Hackney, donde falleció en el correr del año 1862...".

Referencias

Enlaces externos

Zoólogos de Escocia del siglo XIX
Cirujanos de Escocia del siglo XIX
Anatomistas
Anatomistas de Escocia
Etnólogos de Escocia
Curadores de Escocia
Ensayistas de Escocia
Escritores de Escocia del siglo XIX
Asesinatos en Escocia
Miembros de la Royal Society of Edinburgh
Alumnado de la Universidad de Edimburgo
Alumnado de la Universidad de París
Científicos del siglo XIX
Médicos militares del Reino Unido
Miembros de la Academia Nacional de Medicina de Francia
Nacidos en Edimburgo
Fallecidos en Londres
Ensayistas del Reino Unido del siglo XIX

redpajama_set_name: RedPajamaWikipedia


It has been two years to this date since I've used any drugs. I spent the day in steady reflection of the past. I went into a medically induced coma the day Donald Trump was elected President and slept for a couple months while the world around me changed. Imagine waking up in a different world, a new permutation of everything you had known, a parallel timeline. What happened is that I had a serious case of pneumonia and was asphyxiating from vomiting blood. I had gone in to complete a detox and instead everything changed. I had to learn to walk and talk again, right alongside my newborn daughter who witnessed much more than a baby ever needed to see. My family nearly had to plan a funeral, extrapolating that there was a very grim chance of survival. If it weren't for my newborn, perhaps the cord would've been pulled from my vegetative state. With gratitude and luck, I'm happy to have survived. Today I work in recovery helping others get better. What my experience of addiction and my perspective of Beautiful Boy have shown me is that this is a powerful family disease.
That's the crux of this film. Drugs never impact one person. There is a powerful reaction chain behind anyone who uses them for very long. Stemming from their supply across the boarders to the loved ones whom are greatly impacted by their use, it has become the national epidemic of the youth. We're reminded of Steven Soderbergh's Traffic (2000) which shows every step of the drug problem: from trafficking to the war on humanity (we now have too much information to naively believe in any drug war). This is a more personal story, exclusively about the fallout of drug addiction as it relates to family. Beautiful Boy operates more directly, sourcing the drama around the relationship of father (Steve Carrell) and son (Timothée Chalamet).
The film is based on two books about addiction: David Sheff's Beautiful Boy: A Father's Journey through His Son's Addiction (2008) and his son Nic Sheff's concurrent Tweak: Growing up on Methamphetamines (2008). They are both biographical tales of great sorrow and missed connection. When the bond between parents and their children is torn, both sides spiral into helpless disarray. This is what Beautiful Boy handily accomplishes that so few films ever get right about addiction. Wherever there is an addict, there is a sick, suffering family.
A decade ago, I did my first stint of rehab around the time their books were released. I left home for the mountains of Taos, New Mexico for a year. Deep in the desert of the state's northern territory, I made an earnest attempt at sobriety, where we divided time between helping around the ranch and attending meetings. I eventually built up enough sobriety to get back to society and took up work at the Taos Public Library for a while, where I would find their books.
Sitting outside the town's pueblo, I became entrenched in their stories in a very personal way. At night the mountains hummed, as though imbued with the energy of a higher spiritual matter. I read inside the dirt adobes that populated every street, the mountains famously imagined in The Hills Have Eyes (2006) usurping the landscape of dirt, everything the same material, consistently withholding the beauty of earth. The sky would always brighten at night in a way the city never did, a paradise for spiritual growth, perhaps proven by the abnormally large percentage of artists whom lived there.
These works connected me to something larger than myself. On family visits, their truth resounded with powerful precision. We'd sit in a dirt office and discuss the ways we have impacted our families. I had caused enough pain in my addiction and could start to see that spelled out on the faces of the people I loved. Crucially to the point, that was never enough to put an end to using.
That's where Beautiful Boy sits, a great combined memoir of a family that has lost control. Suitably, both lead actors are great, and everyone else is complimentary to their goals. It is a film about the fractured relationship these books have cataloged, where there is no such thing as enough love or tough love enough to save someone.
The thing about addiction is that we stop when we are done. It has to go badly enough that we are willing to see the other side. In my case, I had to effectively die and be physically returned to find anything like absolution.
The important thing about Beautiful Boy is not whether it is a very good film. It's certainly all right. The thing about Beautiful Boy is that it's going to help people. It had been a life-changing book for so many. I cannot say that it personally changed me in any sense, but it helped. This is going to help anyone who sees it who is struggling.
There have been moments where I've faded away from life almost completely. My mind inside a coma went to the darkest recesses of my innermost thoughts. I dreamed a great voyage, a Heart of Darkness (1899) of the mind. A boat carried me across a shore of all the people I had loved. I waved and they could not respond back. They were trapped inside the glue of deathly imagination. The boat careened along all of the places that I had valued. I sailed by the Ocean, through the black-and-white streets of the 1920s I always so dreamed to live within, through Casablanca, improbably along an upward stream across the mountains of New Mexico, traveling the rivers of my internal poetry and sense of place. It was within this darkness that I found enough courage to return to my family, at the end of the cruise, the reaper with a blade to my neck, did I want to come back. Yes, I had to live for my daughter.
Two years removed from my out-of-body spiritual journey of another domain and my family is reconnected. I have renewed my relationships with my parents. My daughter is my world and I'm living with her and her mother, the love of my life. Life has unfolded with all of the potential that went missing while the light was out. This film left me in shambles, unable to really keep it in, and needing to express my gratitude for its willingness to help. I think it's going to help so many people. If you're ever wondering if it is too late, it never is. Whatever side of addiction you are on, there is help. Beautiful Boy is a good beginning resource to discover what is truly out there.
Beautiful boy makes me cry, partially because it is so relatable to me and my family. Thank you for posting this important story.
Thank you, this truly makes the writing worthwhile.


We offer a great selection of gloves and mitts for snowboarding. From basic thin pipe gloves to a full insulated mitt for the coldest conditions. Wrist guards are also available to fit under gloves to help prevent broken wrists.
Super warm and breathable! What more do you need in a mitt! Touchscreen technology? We got you covered!
A year by year best selling glove by Celtek, this glove can be used all year long and is guaranteed to handle any situation with ease, not to mention it has a cool Artwork by Don Pendleton.
Featuring a DK Dry Membrane the Fillmore Mitt is a highly waterproof and durable construction with enough insulation to see you through a vast range of conditions!
Our best selling and most affordable GoreTex Snowboard/ Ski glove only as a Mitt! Same tech, same warmth, same outstanding performance!
The Maverick Gloves from Dakine are a top level leather and Gore-Tex glove perfect for ski and snowboarding and keeping warm and dry in the mountains.
Lightweight and low profile, the Dakine Sienna Snowboard Glove provides warmth in a huge range of conditions throughout the mountain while keeping you dry 24. 7!
Featuring a DK Dry Membrane the Fleetwood Mitt is a highly waterproof and durable construction with enough insulation to see you through a vast range of conditions!
Celtek Trippin Pipe Spaced Out Mitt are out of this world, literally! Their super comfortable, warm & the only snowboard glove you should consider riding.
Good styling along with a good number of great features to offer, The Dakine Omega Gloves in Carbon offer amazing style and value.
These discrete snowboarding wrist guards from Dakine offer a slimline, underglove wrist guard for using in domes or the mountain. They feature a flexible neoprene design.


Tip: Click on the Wakabayashi Toshiya's 4-koma Collection 35 manga image to go to the next page. You can use left and right keyboard keys to browse between pages.
Wakabayashi Toshiya's 4-koma Collection 35 released! You are now reading Wakabayashi Toshiya's 4-koma Collection 35 online. If you are bored from Wakabayashi Toshiya's 4-koma Collection manga, you can try surprise me link at top of page or select another manga like Wakabayashi Toshiya's 4-koma Collection 35 from our huge manga list.
Wakabayashi Toshiya's 4-koma Collection 35 released in manga panda fastest, recommend your friends to read Wakabayashi Toshiya's 4-koma Collection 35 now!


text:
Q: Stored procedure to update rows if exists I have a stored procedure that I am running to insert values if they don't exist and update if they do.  I have a table where the data is coming from
Table1
Name (nvarchar)
Data (int)
Timestamp (datetime)

The data looks like this
Name1       5       2016-11-16 09:46:40.490
Name2       10      2016-11-16 09:48:35.240
Name1       7       2016-11-16 09:35:24.350
Name2       8       2016-11-15 02:27:44.670

I am trying to insert the names into a new table, average out the integers, and group by day.  Here is the second table
Table2
Name (nvarchar)
Data (int)
Timestamp (date)

The data looks like this.  Name1 was same day so it was averaged.  Name2 was different days so they were not averaged.
Name1      6       2016-11-16 00:00:00.000
Name2      10      2016-11-16 00:00:00.000
Name2      8       2016-11-15 00:00:00.000

I converted the timestamp to date so it would be easier to combine on day.  My stored procedure looks like this
IF NOT EXISTS (SELECT t.Name, t.Timestamp
    FROM Table2 t
    JOIN Table1 a
    ON t.Name = a.Name AND t.Timestamp = CONVERT(date, a.Timestamp)
    GROUP BY t.Name, t.Timestamp)

INSERT INTO Table2 (Name, Timestamp, Data)
SELECT
    Name,
    CAST(Timestamp AS DATE) as Date,
    AVG(Data) as Average_Data
FROM Table1
GROUP BY CAST(Timestamp AS DATE), Name

ELSE
UPDATE Table1
SET
WHERE

So I first time it runs, there is no issue.  The values are added and grouped correctly.  However, the second time it runs, it always inserts.
My update statement had looked something like this before I deleted it
SET Name = Name, Timestamp = Timestamp, Data = Date
WHERE Name = Name, Timestamp = Timestamp

I know this is not right but it never seems to even hit the Update as the Insert always runs.  If I run the Select in the If Not Exists, I see data and it should see it as exists.
I guess I need help cleaning up the If Not Exists and creating a working Update statement.
EDIT:
Updated code below
IF EXISTS(SELECT Name, Timestamp FROM Table2)
UPDATE
    Table2
SET
    Name = a.Name,
    Timestamp = CONVERT(date, a.Timestamp),
    Data = AVG(a.Data)
FROM
    Table2 t
INNER JOIN
    Table1 a
ON t.Name = a.Name
WHERE t.Name = a.Name AND t.Timestamp = CONVERT(date, a.Timestamp)

ELSE
    INSERT INTO Table2 (Name, Timestamp, Data)
        SELECT
            Name,
            CAST(Timestamp AS DATE) as Date,
            AVG(Data) as Average_Data
        FROM Table1
        GROUP BY CAST(Timestamp AS DATE), Name
END

A: I like to use the MERGE statement instead of consecutive UPDATE and INSERT.
Because of the aggregation, in my answer below, I use a CTE with the MERGE.
-- CREATE AND INSERT TABLES
DROP TABLE TABLE1
CREATE TABLE
TABLE1
   (    Name nvarchar(5)
    ,   Data int
    ,   Timestamp date
    )
INSERT INTO TABLE1  VALUES  ('Name1',5  ,'2016-11-16')
                    ,       ('Name2',10 ,'2016-11-16')
                    ,       ('Name1',7  ,'2016-11-16')
                    ,       ('Name2',8  ,'2016-11-15')
                    ,       ('Name3',8  ,'2016-11-15')
                    ,       ('Name3',10 ,'2016-11-15')
                    ,       ('Name3',9  ,'2016-11-16')
                    ,       ('Name3',11 ,'2016-11-16')

DROP TABLE TABLE2
CREATE TABLE
TABLE2
   (    Name nvarchar(5)
    ,   Data int
    ,   Timestamp datetime
    )
INSERT INTO TABLE2 VALUES  ('Name1',0 ,'2016-11-16')
                          ,('Name2',0 ,'2016-11-16')
                          ,('Name2',0 ,'2016-11-15')

    SELECT * FROM TABLE2 -- SHOW TABLE2 BEFORE MERGE

BEGIN TRANSACTION
--  HERE IS WHERE THE CODE THAT REPLACES YOUR QUERY ACTUALLY BEGINS
   ;WITH    CTE_AVG_DATA_TABLE1
        AS (SELECT      Name
            ,           Timestamp
            ,           AVG(Data) AS [AVG(Data)]
            FROM        TABLE1
            GROUP BY    Name
            ,           Timestamp
            )

        MERGE   Table2              AS TARGET
        USING   CTE_AVG_DATA_TABLE1 AS SOURCE
            ON      TARGET.Name = SOURCE.Name
                AND TARGET.TIMESTAMP = SOURCE.TIMESTAMP
        WHEN MATCHED THEN
            UPDATE
            SET     TARGET.Name         = SOURCE.Name
            ,       TARGET.Timestamp    = CONVERT(date, SOURCE.Timestamp)
            ,       TARGET.Data         = SOURCE.[AVG(Data)]
        WHEN NOT MATCHED THEN
            INSERT (Name, Timestamp, Data)
            VALUES (SOURCE.NAME, SOURCE.TIMESTAMP, SOURCE.[AVG(Data)])
        ;

    SELECT * FROM TABLE2 -- SHOW TABLE2 AFTER MERGE
ROLLBACK /*ALLOWS THIS TEST CODE TO BE RUN OVER AND OVER
           ADDING ROWS TO INSERT STATEMENTS ABOVE TO SHOW THAT IT WORKS
         */

A: I personally prefer to use the older style technique for what is commonly known as an "upsert". MERGE works well but is a real pain to debug problems because it does everything in one shot.
Here is the type of approach I prefer because it separates the insert and the update which provides more flexibility and is easier to debug issues. You can also switch the left join in the insert to use a NOT EXISTS with a correlated subquery but most of the time the performance difference is pretty negligible.
UPDATE t
SET
    Name = a.Name,
    Timestamp = CONVERT(date, a.Timestamp),
    Data = AVG(a.Data)
FROM
    Table2 t
INNER JOIN
    Table1 a
ON t.Name = a.Name
WHERE t.Name = a.Name AND t.Timestamp = CONVERT(date, a.Timestamp)

INSERT INTO Table2 (Name, Timestamp, Data)
SELECT
    Name,
    CAST(Timestamp AS DATE) as Date,
    AVG(Data) as Average_Data
FROM Table1 a
left join Table2 t on a.Name = t.Name
where t.Name is null
GROUP BY Name, CAST(Timestamp AS DATE)
    , Name

-- EDIT--
I didn't even notice the aggregate in your update when I posted. You can circumvent this easily with a cte.
with cte as
(
    select Name = a.Name
        , Timestamp = CONVERT(date, a.Timestamp)
        , AverageData = AVG(a.Data)
    FROM
        Table2 t
    INNER JOIN
        Table1 a
    ON t.Name = a.Name
    WHERE t.Name = a.Name AND t.Timestamp = CONVERT(date, a.Timestamp)
    GROUP BY Name, CAST(Timestamp AS DATE)
)

update t
set Name = c.Name
    , Timestamp = c.Timestamp
    , Date = c.AverageData
from Table2 t
join cte c on c.Name = t.Name
    and c.Timestamp = t.Timestamp

redpajama_set_name: RedPajamaStackExchange


Spring is here and that means rain, in our neck of the woods. I have to make sure to have plenty of simple and fun activities on hand for my little ones, or they will be bouncing off the walls. That's why I love using playdough mats. These Spring themed Playdough Mats are perfect for sneaking in a little bit of learning with a whole lot of fun!
If you're looking for some great readers to use while celebrating Spring, check out these great titles. Many are probably available at your local library, or you could get a Kindle version for most of them on Amazon. I love using my Kindle Reader app to read with my kids. I have so many titles at the tip of my fingers in just minutes!


Winterland Inc. rope lights are versatile, affordable, and easy to install. You have the option of different links and a variety of colors. When using rope lights, you have unlimited possibilities. Let your imagination guide your holiday decoration dreams.


The Rev. David Beckmann is one of the foremost U.S. advocates for the hungry and poor.
Under his leadership, Bread members' persistent, bipartisan advocacy has helped push the U.S. government to triple funding for programs aiding developing countries in Africa, Asia, and Latin America. Bread has also worked to double funding for U.S. nutrition programs, assisting millions of families in the United States who struggle to feed their children.
Prior to joining Bread, Beckmann worked at the World Bank for 15 years, overseeing large development projects and driving innovations to make the bank more effective in reducing poverty. He holds degrees from Yale, Christ Seminary, and the London School of Economics. His latest book is Exodus from Hunger: We Are Called to Change the Politics of Hunger (2010). Learn more on Bread's national site.


Sean Hannity–the self-described "registered conservative", on-again, off-again journalist and leading Republican apologist, has a huge audience in the millions who hears him on radio and television daily repeating the same lists ad nauseum (which are accurate) concerning the economy, food stamps, unemployment, etc. as a critique on the Obama administration, the growth of government and liberalism in general.
Despite him proclaiming his "conservatism" and being a leading voice on the airways, I would like to suggest to you that Mr. Hannity is not a conservative, in fact, he really has no core.
He is an entertainer and a businessman that follows the ratings and the R (Republican) is of utmost importance, no matter how unconservative, unconstitutional that particular R may be.
It's all about the R.
George W. Bush represented some of the worst in constitutional conservatism in modern history and he and a Republican Congress, which he had for six of his eight years, exploded government unlike anything since LBJ.
Hannity loves to attack Mr. Obama's horrible policies that has led to a doubling of our national debt and for good reason.
The debt went from just over $10.6 trillion when Obama took office to some $19.5 trillion today, clearly an issue that none of the government seems prepared to deal with.
However, Mr Hannity declines to say that the debt also doubled under Mr. Bush. When Bush's term started Jan. 20, 2001, the gross federal debt was $5.73 trillion. At the end of his term, Jan. 20, 2009, the gross federal debt was $10.63 trillion.
Hannity neglected to critique the former President not only for this, but for a long litany of big government, unconstitutional federal programs.
Let's take a look–No Child Left Behind (greater federal spending and intrusion with nothing to show for it), the Medicare prescription-drug benefit, the largest entitlement program created since LBJ, a massive expansion of the regulatory state, an unconstitutional war in Iraq, an addition executive department which includes a bumbling Transportation Security Administration and the biggest trampling of the Fourth Amendment ever in the Patriot Act.
How about Mr Bush's TARP or his executive order that created the ultra secret Cheney Energy Task Force?
According to data published in a Mises Wire earlier this year, Mr Hannity's previous two biggest idols, Ronald Reagan and George W. Bush were the worst offenders of federal spending.
What about all the executive orders issued by President Bush or his appointment of Czars? Bupkis.
During the Bush years and the horrible, unconstitutional policies that occurred, not once did Sean Hannity ever critique any of it. In fact, he promoted several of them.
Did Hannity take on No Child Left Behind–as a journalist or a commentator? Crickets.
If Mr Hannity was concerned about adhering to the restraints of the Constitution and true limited government, not once did he make this known while Mr Bush was in office.
When the Tea Party movement appeared on the scene roughly in 2007 with the Ron Paul movement, prior to Barack Obama taking office, the grassroots movement hated what Republicans did during the GWB years and the incredible spending and government intrusion.
The people at neocon, establishment Fox News initially kept the Tea Party at a distance, sometimes mocking the people and not really getting or understanding the principles being espoused.
However, after a period, the movement grew and grew fast and couldn't be ignored anymore by the likes of Glenn Beck (who launched the 9/12 project in 2009) and the exploitive Sean Hannity.
Hannity clearly saw this as the direction to move as his idol George Bush lost favor with many in this movement. Being the businessman and entertainer, Hannity was on board.
This fit in well with Hannity's schtick to blast (deservingly so) the big government policies of the new President, Barack Obama.
In his hijacking of the Tea Party, Hannity hosted a number of events, got close to Tea Party leaders and criticized every move of Barack Obama. The use of the Constitution became a mainstay of Hannity's new found rhetoric.
The Tea Party, for Mr Hannity, was all about the R.
Move over George W Bush and the Tea Party is not much more than rubble and Hannity has moved on– Sean is now a Trump apologist.
The Constitution is rarely mentioned these days and the populist, Make America Great Again is now the mantra.
Mr Hannity doesn't question anything about what Donald Trump says or about his policies, despite having the Republican nominee on his radio and television programs frequently, sometimes for an hour at a time, and no serious questioning ever happens ( Just check the transcripts for yourselves).
Did Sean Hannity ever ask him, Under what authority can you do this? Of course not.
You'd think waterboarding would be a serious issue for Sean as he has gone seven years since being challenged and accepting to have it performed on him.
Did Hannity ever question the viability of his plans for tariffs?
Mr Trump once said, "First of all, you never have to default because you print the money. I hate to tell you. So there's never a default." Did Hannity ever discuss the issues of inflation and hyperinflation? Nah.
What about Mr Trump's unconstitutional positions of ignoring the Fifth Amendment and its protections for property rights? If that was Mr Obama or Mrs Clinton, Hannity would be all over it.
Times like this I wish I knew if Hannity considered himself a journalist or not.
Mr Trump's positions on a "total and complete shutdown" of Muslims entering the United States and the government having the power to close mosques? This offends multiple constitutional principles. Did it offend Mr Hannity?
If any of these things were proposed by a Democrat, Hannity would be all over it, and rightfully so.
Is this how a "registered conservative" acts?
No questioning concerning federal subsidies for child care. Trump has said the government should be able to censor parts of the Internet. Where is Hannity's outrage?
In December, Trump said one of the first things he'd do if elected is sign an executive order mandating the death penalty for cop killers. Did Hannity ever ask him again under what authority considering this would be a state function?
This gives a good glimpse of the dangers of executive orders coming out of a Trump White House, something a "registered conservative journalist?" like Hannity should fight against.
Related: What do I want from the President?
Mr Hannity frequently gives a list of things Mr Trump will do, including Supreme Court appointments.
But how can we be sure about anything he says, including Hannity. Trumps spent decades as a big government liberal and has supported position such as government run health care and horrendous partial-birth abortion.
Has Hannity ever got a real good fundamental explanation for his position changes. It's great if Trump changed these positions, but why did he?
Doesn't matter, It's all about the R.
Sean Hannity rightfully critiqued President Obama using a Constitutional argument many times.
Where was Hannity to dissect this scary statement?
The list could go on and on. No matter how atrocious or questionable the policies and philosophies of Mr Trump are, Hannity is on board 100%.
Hillary Clinton is also a horrible candidate and the damage she'll do is immeasurable. However, Trump may be just as bad so just because he has an R or because he's a good friend, does that make it acceptable? If you lack a solid constitutional, conservative core, the answer is yes.
I've read in the comment sections of numerous articles about Sean Hannity over the years and many Hannity-haters would call him a whore.
I am too much of a gentleman to call him that; however, it is abundantly clear that Sean Hannity has no core.
What makes this so sad is millions listen to him and follow his words to mind and heart, confusing Constitutionalism in a terrible way.
I agree with what you are saying but you really need to work on your writing, grammar and verbiage. Wow.


This WWII US Army Medical Nurse T Shirt is a reproduction of an original WWII PT shirt from my collection.
This is a WWII US Army Medical Nurse Reproduction T shirt.
This shirt is a reproduction of an original WWII design from my collection. These PT shirts would have been worn by both Medics and Nurses. During WWII, athletic style t shirts were available for purchase at the PX and were commonly used in training and athletic situations. T shirts with a variety of different unit logos are well documented in many WWII photographs.
Just like the original t shirts, this reproduction is 100% cotton with a period correct narrow 5/8″ neck, shorter sleeves and a slim/snug fit. These WWII Reproductions are true to size. This WWII Army Medical t-shirt comes in women's sizes.
The Ladies shirts have a feminine tapered fit that is close to the body. These shirts have a Junior fit and are very snug for our Misses customers. Most of our customers wear at least a size larger than their normal size. Our Plus size customers are usually more comfortable with the Mens sized shirts.


text:
Shell is proud to partner some of the top motorsport teams in the world's most competitive championship series. From Innovation Partner to Scuderia Ferrari, Technical Partner to Ducati Corse in MotoGP and BMW in Motorsport, to Co-Title Sponsor to the Hyundai Shell Mobis World Rally Team, the racing we have access to is second to none. This portfolio is further enhanced in 2019, with Shell partnering with Nissan in the world's fastest developing motorsport, Formula E.
Our partnerships are the ultimate test bed for our products, challenging them to perform in some of the most extreme conditions and ensuring our customers are getting the very best.
Shell's Innovation Partnership with Scuderia Ferrari is one of the longest and most succesful in motorsport. Learn about its history, peek behind the pit lane and see how the extreme conditions of Formula 1® help develop products for your car.
See how our partnership within the electric racing series Formula E allows Shell and Nissan to combine their e-mobility innovation and R&D resources to help EV customers around the world.
Our Technical Partnership with Ducati Corse has grown into one of the most successful collaborations in motorsport. Working shoulder-to-shoulder with the Ducati team, what we learn from our extreme testing environment on the racetrack is used to provide bikers all over the world with high performing products such as Shell V-Power road fuel and Shell Advance oil.
The Shell Technical Partnership with BMW Motorsport is the latest chapter in Shell's many decades of history in DTM and touring car racing.
For Shell all of our motorsport partnerships play a vital role, but our partnership with Hyundai Motorsport offers us something totally different to traditional circuit racing. Both the car and our products face every environment possible during the World Rally Championship season, allowing us to collaborate in technology leadership through extreme performance, with a focus on developing future engine technology and the best performing engine oils.
Follow us for more Shell Motorsport news!
DISCOVER MORE ON SHELL FOR MOTORISTS
When you fill up with Shell fuel, you can relax in the knowledge that our scientists have spent decades researching ways to help you get more out of every drop.
Designed to meet your needs – whatever your driving challenges. Discover the full product range.
Shell and Scuderia Ferrari
More in Motorists


text:
MARTINEZ RECOGNIZES DANGER MAN
Wigan manager Roberto Martinez has identified David Silva as the danger man ahead of Manchester City clash. The Spaniard hasn't enjoyed a good start in England since his £24 million move from Valencia, but his goal against Salzburg in the Europa League on Thursday has prompted Martinez to warn his players that the goal could turn around his compatriot's season.
"David Silva , when he understands the Premier League, can become a massive player because he plays between the lines like nobody else." Martinez told the Daily Mail.
Read more about MARTINEZ RECOGNIZES DANGER MAN
SILVA NEEDS TIME
Submitted by isport on Sun, 09/26/2010 - 12:39
Roberto Mancini has admitted that David Silva will need more time to settle at Manchester City. The Spaniard was part of the City side which sealed its place in the group stages of the Champions League with a comfortable win over FC Timisoara. But Mancini admits that the winger still needs more time to become a regular Premier League performer.
"Silva needs time. He's a fantastic player, but playing in the Premier League is different to La Liga," the Italian told his club's official website.
Read more about SILVA NEEDS TIME
Silva wary of Torres
Submitted by isport on Wed, 09/08/2010 - 21:10
Manchester City midfielder David Silva has spoken of his concern about the damage Fernando Torres could do when they face Liverpool.
The top four rivals do battle on Monday at Eastlands, with a result either way bound to give belief to both sides that they can mount a challenge for the Premier League title.
Torres came off the bench in the Reds' Europa League victory over Trabzonspor on Thursday, and looked a threat immediately to demonstrate that he may be ready to start after returning to fitness.
Read more about Silva wary of Torres
Manchester City manager Roberto Mancini has acknowledged that new siging David Silva has not yet adjusted to English football.
The Spaniard was part of the City side which sealed its place in the group stages of the Champions League with a comfortable win over FC Timisoara. But Mancini admits that the winger still needs more time to become a regular Premier League performer.
Silva Hits the Big-Time
The first thing that strikes you, other than – no kidding – the darkest eyes you have ever seen, is how small he is, almost Lilliputian. When Roberto Mancini paraded his first four summer signings at a press conference last week he said he had brought in Yaya Touré, Aleksandar Kolarov and Jérôme Boateng, in part, because of their power and size. Then he turned to David Silva, sitting to his right, put his arm around him and gave him a reassuring squeeze. "Maybe not David," he said, "but this a fantastic footballer. You know, I wanted to sign this guy five years ago for Internazionale. He has kept me waiting."
The strange thing is that, as yet, Silva's arrival in England has not fired the public's imagination as might have been anticipated. Perhaps it is a legacy of the World Cup, where he started only the first match for Spain. Or maybe it was that the signing was agreed in the final week of June, when everyone was fixated on the events in South Africa.
Read more about Silva Hits the Big-Time
We LOVE David Silva
Read more about David Silva


How is Learning Latin in School?
Many feel the same regret and many wish that there was a Latin option when they were in secondary school. This brings us to the question, how are ancient languages, especially Latin, taught nowadays in UK schools?
There have been many education reforms throughout the years and many have completely cut ancient languages from the curriculum and replaced them with other languages such as French and Spanish.
Latin was the language of the ancient Roman people and the lingua franca of the European elite until the 17th century and since many view it as "outdated", the teaching of this "dead language" has fallen out of favour all over Europe and especially the United Kingdom. It is not viewed anymore as an important beacon to better understand French and the other Latin-based languages such as Italian, Spanish, Portuguese and Romanian.
Many students all across the UK are interested in learning Latin but in recent years have found that GCSE Latin is extremely hard work and if given the option to choose between learning German or another year of Latin they would opt for German.
With this being said, there has been much debate, recently, about the benefits and overall use of teaching Latin in secondary state schools. Many view ancient Languages as a symbol for the social elite to show off their skills and talents and that it is no longer needed in our modern world. Whereas others think that, although difficult to learn, is an essential bridge to learn more about languages that have strong Latin roots.
Superprof has decided to take part in this lively debate and let everyone know how learning Latin happens in schools today.
Learning Latin is not a new trend. This ancient language has been valued and taught for several centuries.
In the 16th century, Latin was extremely utilized being the dominant language of commerce, education, religion and government in most parts of Europe. However, during the start of the 17th century, Latin was losing popularity and the study of languages such as French, Italian and English became more important. Near the end of the 17th century, Latin diminished from being studied as a living language to a mere subject in the school curriculum. Throughout the 18th and 19th century, Latin was no longer considered as important as the study of modern, spoken languages.
Along with mathematics, the sciences and English, Latin was a core subject taught in a variety of schools during the first half of the 20th century across the United Kingdom.
However, after the Modern Language General Certificate of Secondary Education in the 1980's, Latin was slowly replaced by other languages that were ruled more important in many schools.
A fantastic article published by Cambridge titled, The 20th Century Transformation of Latin Teaching in the UK gives us insight into how Latin was previously taught in schools before the reform in the 1960's and 70's.
Latin classes were only offered to the intellectually gifted and this left out many students from the modern secondary school system and this created a sense of elitism among the students.
This way of teaching Latin was unattractive to students and teachers alike and lead to an exodus of Latin in secondary schools. Many, given the choice, would opt out of Latin classes.
Because of the student's disinterest, the reform took drastic measures and cut traditional Latin classes from many state schools and only left them for those attending a very select few private schools.
This left many schools without the Latin option and the ability to learn more about ancient languages.
Find out how you can learn Latin online!
Students, parents and educators alike all believe that British pupils are prejudiced towards Latin because of the archaic way it was taught in the past.
This is completely understandable; nobody wants to put a diligent effort forward if they feel it is something they will never use in their lives. Also, how boring is it to recite and copy Latin grammar from an ancient textbook?
A more satisfying study of ancient Roman history.
There is good news: Latin is making a comeback! In recent years, the education board and government officials alike have realized the importance of implementing Latin classes back into state schools.
Latin is coming to a classroom near you! Reports have shown that the number of non-selective state schools across the UK offering the subject has risen by more than six times in the past decade.
Now comes the question of many concerned parents, how will my 10-year old learn Latin and will he enjoy it?
Students, especially younger ones, need to be taught in a stimulating and engaging way. Education World states that anything that stimulates a pupil's mind will encourage them to take an interest and thus learn about the subject. This advice is applicable for all subjects taught in school, Latin included.
Sitting at a desk all day reciting Latin proverbs is not the way to go! Student's needs to get up, move around, play games in order to stay permanently interested.
If the student is not interested in the subject they are being taught and they do not feel stimulated then learning will not take place.
Another key factor is the teacher. If the teacher is unenthusiastic and bored with teaching the Latin verbs, grammar and the six cases, the student will feel the same and not learn anything useful. The best teachers are the ones who inspire and say, Carpe Diem!
Games are always recommended when teaching student's about grammar and vocabulary. Latin can prove to be very difficult and if the students feel that what they are learning is not useful they will get discouraged and their interest in the subject will fade. Therefore, games need to be played!
VINCO (like BINGO but with a V and a C).
Latin classes should be taught in an interactive and entertaining way. These Superprof suggestions are not just for Latin teachers based in the UK but for educators all around the world who want to revive the lingua latina in style!
What are the best apps for learning Latin?
In order to train ourselves to read classical Latin texts or try to speak the language of Julius Caesar we need to have a mastery of our own mother tongue.
English grammar classes during primary and secondary school are of the utmost importance and should be taken seriously. It is our mother tongue after all! Latin should be viewed equally because it is an essential bridge to learning more about latin-based languages.
In 1988 the GSCEs were introduced in order to establish a national qualification for those who decided to leave school at age 16. The British government has initiated many reforms since the GSCEs first appeared in the 80's but the core subjects have remained the same.
All four of the classical subjects are appropriate and available for students to study at both primary and secondary levels. That means that students from Key Stage 1 to Key Stage 4 have these options at their disposal. The "Classics" come highly recommended if given the option to study them. There are many exam boards who have done a great job creating a Latin curriculum that is fun and educational.
Follow these 5 tips to learn Latin faster!
The GSCE Latin option is available in various schools and exam boards across the UK. The numbers have been rising in recent years due to renewed interest like we mentioned before.
The OCR exam board offers a very interesting GCSE qualification with Latin (9-1). It is taught at a GCSE level and is designed to help students develop their knowledge and understanding of the grammar, vocabulary and syntax of the Latin language. The pupil is also taught to read ancient literature and determine the values and morals of the Roman society through the study of original texts.
Language (section 1): compulsory and worth a total of 100 marks or 50% of the grade. During this component, students build their knowledge of vocabulary and linguistic structures. The student should be familiarized with the DVL (defined vocabulary list) and RGL (restricted grammar list).
Prose literature and verse literature (sections 2-5): pupils study a set text or group of texts that is between 110-120 lines in length and changes every two years. The first set text for 2018, based on the OCR exam board, is titled Family Life and Relationships.
Literature and culture: an optional but very interesting and useful section. During this component, students are given ancient source materials that cover two themes of civilization and culture.
By taking GCSE Latin you improve your culture and your knowledge of ancient history. While taking this option you will read texts from Roman authors and poets such as Ovid, Pliny (the Elder and the Younger), Virgil and Catullus.
Also learning about the Roman empire and the emperor's who made it glorious is so much more rewarding and satisfying when you are learning the language Cicero and Julius Caesar spoke. The GCSE option is so great because it combines ancient history and Latin vocabulary in a very harmonious way.
There will always be much controversy and debate as to whether teaching Latin in school is necessary. Some are even against the well structured GCSE Latin option at a secondary level because it is the hardest. It is at least two levels harder than the average subjects. Parent's want their children to succeed (completely understandable!) and they may persuade them to take an easier option where they are guaranteed success.
However, remember a challenge can reap great results and make you feel more fulfilled. If you feel that you are having difficulties passing the Latin option hire a private tutor from Superprof to give you the extra remedial help you need!
The lingua latina can be learnt and the benefits are worth way more than the sacrifices!


This stylus pen with special design will help you avoid pressing the wrong keys; whenever you write an email, browse the internet or text messages. The soft; touch tip provides precise touch and control, while protecting your touch screen.
This is crafted of special material specifically designed for the iPad, iPhone; and iPod touch.


It's a handy reference to keep around for colleagues, students, etc.
Charles Ross covers a range of topics typically taught over the course of several lectures, so don't be surprised if it takes a while to get through the entire article. If you need to understand the topic, this is worth printing out and studying.


text:
Q: Single operation to get latest on the master branch and merge to my feature branch? A lot of the time, I just want to make sure I have merged the latest code before I start coding for the day. The steps typically include:

*

*Stash and undo my changes on my current dev/feature branch

*Check out master branch

*Get the latest code on master

*Switch back to my branch

*Merge from master onto my branch

I do this before I code daily to avoid conflicts for when I will ultimately have to merge to master. Is there a simple one button operation for this so I can save time?

A: I found out this is called re-basing.

A: From your feature branch :
git stash
git fetch
git merge origin/master
git stash pop

Or more conveniently with an alias :
git config --global alias.up '!git stash && git fetch && git merge origin/master && git stash pop'

# then each time you need it, from your feature branch :

git up

A: Very simple. Understand git rebase. URL


Country music fans, it's time to come together for a night full of Southern drawls and line dancing. This Friday, Legends is featuring Jerrod Niemann in concert, and since I know we are a minority, we need to show all the support we can.
In case you are unaware, Niemann is signed to a record label co-owned by the country heartthrob Brad Paisley and has appeared in the top 40 country music charts for three of his songs. Appearing on radio stations and playing shows all over the country, notably at Nashville's Grand Ole Opry, Niemann is following the footsteps of some serious stars. This is our opportunity to show off our country music pride by singing along with this upcoming star, so here's your chance to get a head start on learning those lyrics.
Part of Niemann's appeal is the fact that his music resembles that of Garth Brooks, one of my absolute favorite country music artists. In fact, Niemann and Brooks have collaborated in the past, co-writing songs like "Good Ride Cowboy" and "Midnight Sun." The songs are catchy without being poppy and mainstream, and they all have their unique rhythm unlike some country stars these days (I'm looking at you, Taylor Swift). His most popular song, "Lover, Lover," could even be mistaken for a Zac Brown Band number, only by a country music rookie of course, because of its simplistic layers and natural, nearly-a capella vocals. The stripped-down yet catchy song shows off Niemann's natural talent as well as featuring subtle yet impressive guitar picking.
Another hit, "Down in Mexico," has a very Jimmy Buffet-esque vibe, with tambourines, ukuleles and lyrics about girls, drinking and beaches. It's the perfect song for the anticipation of summer, and Niemann will put you in a happy mood, even if just temporary, while you picture warm beaches and summer sun.
In the past, Niemann has toured with Love Like Crazy singer Lee Brice and country megastar Miranda Lambert. His concert at Notre Dame is just one stop on a summer-long tour, sandwiched between shows in New York and Fort Wayne, Ind.
With the intimate setting of Legends, you will be able to experience Jerrod Niemann up-close and personal without having to pay ridiculous venue prices or deal with obnoxious 40-year-old country music fans drunkenly attempting to sing along (if you've ever been to a Rascal Flatts concert, you know what I'm talking about).
Come out to Legends this Friday at 10 p.m. for a guaranteed good time, surrounded by country music lovers – all you haters, just stay home or at least keep your mouth shut if you decide to come. It's about time Legends gave us a well-known country artist to sing along to lyrics about drinking (try Niemann's "One More Drinking Song"), beaches and the country.
Directly following the concert, Legends goes country, equipped with not only non-stop country music but also a mechanical bull. If that doesn't convince you, I don't know what will. So grab your cowboy boots, throw on some "jorts" and a plaid shirt, don that dusty cowboy hat and grab a partner to take to country night at Legends, y'all.
author and not necessarily those of The Observer.


I first contemplated the call to religious life when I was in seventh grade. Despite the fact that my school was a Catholic girls' school and well known in Kumasi, a city in Ghana, West Africa, where I was born, there were no Catholic sisters at the school. The only glimpses I had of religious sisters was when I attended Mass on Sundays at Saint Peter's Cathedral, my home parish, where the sisters from St. Louis Training College sometimes attended the children's Mass.
I was born into a staunch Catholic family, the fifth child and third girl among 10 children. My family and teachers nurtured in me my love for God and the joy of being a Catholic. My father was strict with us about attending Sunday Mass and my parents never missed 5:30 a.m. Mass during the weekdays. Mother had a strong faith in Our Lady and wanted us to share in this faith. She always enticed us with stories about what Mary did for those who visited her shrine. Mother succeeded, and we all were eager to accompany her to the grotto to pray to Our Lady, especially during vacations and feast days. I learned to pray the rosary from these visits and also developed other devotions to Mary.
One morning at school, the bell summoned all pupils from grades 7 to 10 to the assembly grounds. A diocesan priest was waiting to talk to us about religious vocations. At the end of his talk, he invited those interested to see the cathedral administrator for application forms to Saint Hubert's Seminary. This was the first time that I, now a seventh-grader, had heard how to become a religious. Call it love at first sight or curiosity, but his talk touched the core of my being and, there and then, I decided to be a sister — without fully understanding what it meant. Before the end of the academic school year, I was accepted into the seminary.
During the five years that I spent in the school, my interactions with the male students challenged me. Both boys and girls were treated equally even though only 5 percent of the student population was female. However, the boys' attitude was to surpass the girls in every activity. This was contrary to what my parents taught me about boys not being better than girls, so I was determined to excel. With determination and hard work I rose to par with them. At the end of the five years, I decided that I still wanted to be a sister because I felt like doing something special for God.
After school I entered another congregation. I still look back fondly on those years in my former community and am grateful to God for all the gifts he gave me. My stay with them was a hallmark in my life, renewing the conviction that God needs me. I worked as a nurse midwife in Brong Ahafo and the Volta regions of Ghana where I got to know many of the Brothers of Holy Cross. I heard about the Holy Cross sisters from them. Later, when I left my former community, I thought about contacting these sisters.
I was in school doing my undergraduate coursework when I met Sister Jane Chantal Method, who welcomed me and told me a lot about the Sisters of the Holy Cross. I was attracted to the fact that the Holy Cross family has sisters, brothers and priests. From then on I started communicating with the sisters until my graduate courses were completed. I applied formally to the community and began the candidacy program in 2003. I made my initial profession in 2006 and my perpetual profession in 2012.
Being in the Holy Cross community has offered me the chance to interact with children and youth. I have been given the opportunity to teach children in the Holy Cross Family Centre and to minister to the sick. Currently, I teach at the Nursing & Midwifery Training College in Sekondi. These have been grace-filled moments for me. Holy Cross has given me the opportunity to deepen my prayer life, reassess my relationship with God, and be hope-filled.
I thank God for all he has given me, for the parents who gave me life and love, bringing me up in the Catholic faith and providing me with all the advantages that a Catholic education and life offer. For all the spiritual opportunities that the community has given me, I am deeply grateful, and I pray that all people may continue to support one another as we continue our journey to God.


text:
"Geeta Kapur Was Really Strict With Me During The Shoot Of Chaiyya Chaiyya"- Reveals Malaika Arora On India's Best Dancer
By Team Bollyy	 On Feb 22, 2020
The much awaited dance reality show from Sony Entertainment Television – India's Best Dancer promises to showcase the best talent from across the country. The soon to be aired show will be judged by Malaika Arora, Geeta Kapur and Terence Lewis. While we recently heard that Malaika and Terence go back a long way where Malaika learnt dancing from Terence, turns out that Malaika and Geeta also have a connection! Interestingly, during one the recently shot audition episode, Malaika shared an interesting anecdote from her first day of shoot for the song, Chaiyya Chaiyya. Malaika revealed that she was nervous and choreographer Geeta Kapoor's strictness made her even more anxious!
Sharing her experience Malaika said, "I was really scared as it was my first song, and also my first time on a film set. My lifestyle and upbringing was very different. I was never ever exposed to anything like this (film set) before. Doing the song for the first time in the presence of so many people, listening to (the director say) action, cut, sound, music… I was not used to it and to top it up, I met Geeta ma'am who was very strict. She was like a teacher which made me even more nervous, so I was more scared. (laughs)"
Apparently Geeta was also under a lot of pressure! Since the song was entirely shot on a moving train in Ooty, there was only limited time at hand. The train had operating hours and the sequence was shot between one station to the other, post which the train had to come back and they would start shoot again. The entire song had to be covered within that distance and in limited time.
Geeta Kapur further added, "My boss had given me a dictate to prepare Malaika well (laughs). She explained to me that this is not Malaika's forte and we need to present her in a manner that makes this song iconic! I was working with a very clear vision. The song was made by AR Rahman, Shahrukh Khan was in the movie, Mani Ratnam directed it… so the pressure was anyway there (Laughs). Considering all of this, I had only one thought that by the time Malaika reaches Ooty, she has to be well prepared and ready. And she was! She probably just panicked for the first 5 secs on the train and then she was a pro! From the entire shoot, the tunnel part was the most difficult one. There were different things happening – the lights kept changing, the smoke effect had to happen on time and the movement of the train coming out of the tunnel accounting the lights had to be timed well… leading to the step of taveez bana ke pehnu tujhe…. Which couldn't go wrong. I was just hoping that this go well. And honestly Malaika took all the pressure off me. Once we reached Ooty, I dint get the time to rehearse with her and Malaika was confident that she will rehearse herself and give the take."
On Terence's request, all three judges danced to the tunes of Chaiya Chaiya reminiscing the iconic step. What a story and such nostalgia! The camaraderie between all three judges is quite visible and the audience will get to experience the same soon.
Truly Malaika Arora and Geeta Kapur are pure examples of the show's tagline, 'Jab tak best nahi tab tak rest nahi'.
Tags: Bollywood, Bollywood News, Bollywood Updates, Television, Telly News, Geeta Kapur, Chaiyya Chaiyya, Malaika Arora, India's Best Dancer
Bollywoodbollywood newsBollywood updatesChaiyya Chaiyyageeta kapurIndia's Best Dancermalaika aroratelevision
Dadasaheb Phalke International Film Festival Awards 2020
"Republik Of Musik"- One Stop Solution For Music In India". Brainchild Of Varun Gupta


There is some Progress with the Multi level car parking at Bapat Galli. A highlevel team from KUIDFC was here to inspect the place and they would send their report to Ministry of Urban development and later Karnataka urban infrastructure development and finance corporation (kuidfc) will float the tenders. As of now only one multi level car park is planned said Corp Commissioner Ms.Francis.
EOI were invited and sources have told us that a few applications have come in and they will be scrutinized. Right from 2006 the Bapat Galli Car parking space was talked to be converted into a multi level car parking.
If all goes well construction could start in 12 months.
Please do it fast… It is the need of the hour with traffic increasing and less parking space in the city.


An IWW leaflet produced in Seattle during the General Strike. Records - Industrial Workers of the World, Acc. 544, Box 3, UW Libraries. For a larger version of this image click here.The rise of the Washington State Communist Party is part of the story of American Communism. In 1919 the Socialist Party of America split apart and gave birth to not one but two communist parties. Inspired by the Bolshevik revolution and determined to affiliate with the new international Communist movement, one group of leftwing Socialists bolted and established the Communist Party of America (CPA), while another group of Reds tried to take over the Socialist Party, only to fail and be expelled. In September 1919 they established the Communist Labor Party (CLP). The new parties remained separate for almost two years. CPA, led by Charles E. Ruthenberg, was largely comprised of what had been the foreign-language sections of the old Socialist Party. The rival Communist Labor Party, led by John Reed and Benjamin Gitlow, attracted English-speaking radicals. Under pressure from the Communist International (Comintern), the parties merged in 1921, becoming the Communist Party USA (CPUSA), with Ruthenberg as leader.
The Pacific Northwest seemed like fertile ground for the new movement. The region had long been recognized as a center of labor radicalism. The Socialist Party of Washington (SPW) had formed in 1901, and by 1912 was strong enough to elect city officials in a number of cities, including Seattle. The Industrial Workers of the World (IWW) also flourished in the cities and timber camps of the region and succeeded in pushing the rest of the labor movement and many Socialists to the left. Most of those who joined the SPW after 1912 allied with the "Red" (revolutionary) faction. That was especially the case among the Finns and other immigrant groups who maintained their own Socialist locals. Events of 1919 further demonstrated the region's radical potential. In February of that year the city of Seattle was shut down by a general strike that began in the shipyards and soon involved 60,000 workers. As the year progressed, other dramatic strikes spread across the country (e.g., Boston police strike, massive coal and steel industry strikes), creating a revolutionary romantic atmosphere that seemed to bode well for the new movement.
Henry P. "Heine" Huff joined the Wobblies (IWW) in 1917. He saw and learned from the Centralia conspiracy struggle while working as a railroad switchman, and eventually joined the Communist Party on January 1, 1920 as a Charter Member (courtesy CPUSA online)Both these emotions are useful, but not too much of either. We are undertaking the most tremendous move ever made by LABOR in this country, a move which will lead-NO ONE KNOWS WHERE!
Anna Louise Strong left Seattle before the Communist Party even got a chance to take hold of labor politics. In 1921 she sailed to Europe and made her way to the Soviet Union, following her friend Lincoln Steffens' advice that she witness the revolution at first hand. Her departure was due also to her pessimism about the state of the labor movement and was a loss for the Party in Washington State. She could have been had a powerful ally who understood the plight of labor.
Some of those who joined the two Communist Parties in the early 1920s were former Wobblies. Indeed, the Communists hoped to replace the IWW as the militant voice of the Left and worked hard to recruit in the lumber camps and skid-roads where the IWW had been strong. Henry "Heine" Huff, one of the new recruits, was a railroad switchman who joined the CLP in early 1920 and stayed a Communist for the next forty years. In the 1940s he became District Organizer, the top leadership position for the Party in the Northwest, and in 1953 he was among the eight Washington State Party leaders indicted under the Smith Act.
The Party picked up where many of the dissolved radical groups left off in trying to become a powerful independent force, at the same time joining up with other labor organizations to influence them. Following along the lines of the old Socialist Party, the main goal of the Communists, particularly in Washington State, was to influence and dominate the labor unions and other organizations, hoping to eventually move the broader labor movement toward Communism through education and inside politics. One of the first targets was the Union Record, owned by the Seattle Central Labor Council and the only labor-owned English-language daily newspaper in America. Joining with IWWs and other Reds, Communists attacked the editor, Henry B. Ault, as a "labor capitalist." Ault fought back, supported by most of the SCLC. "We will fight to the ultimate limit every attempt to turn this paper to either the IWW or the Communist Party," he editorialized.[viii] The radicals then formed a sixteen-member "Committee of 100"to rally radical support against Ault and labor-capitalists. They set up a weekly newsletter called Save the Record wherein they attacked the Record leadership, mailing editions to AFL members. The Union Record published its own newsletter to discredit the radicals.[ix] In the end, the radicals lost, but the fight had taken a toll on the labor movement as a whole. In a sense it was a small victory for the Left since it showed that Communists could have some leverage.
And the days when Communists could openly participate in such coalitions were drawing to a close. From the onset, the WP had no direct control over any labor council nor was its membership in the councils large enough in numbers or in key positions to significantly change policy. It must also be emphasized that the majority of radical labor activity was not conducted by the Party alone but by unofficial communists, sympathizers, fellow-travelers and by other radical organizations like the IWW that shared certain leftwing beliefs with the Party.
Still, the 1920s had laid the groundwork for what was to come. Even before the Great Depression struck, the Party was showing signs of renewed energy in the Pacific Northwest. A new group of organizers had emerged, including Noral, who would become District Organizer in 1931, and Fred Walker, assigned to breathe life into the District's Young Communist League (YCL) As 1929 dawned, Communists were once again active. Organizers were trying to build a new union of timber workers in camps and mill towns near Grays Harbor. Soap-boxers were appearing nightly on the streets of Seattle's skid-road, their meetings inevitably broken up by police. And on the campus of the University of Washington a small YCL group had reformed and were putting out a sprightly little newsletter called The Spark.
[i]Jonathan Dembo, Unions and Politics in Washington State 1885-1935 (New York: Garland Publishing, 1983), 92.
[v] Harvey Klehr, The Secret World of American Communism. (New Haven: Yale University Press, 1995), 7-9.
[vi]Albert F Gunns, Civil Liberties and Crisis: The Status of Civil Liberties in the Pacific Northwest, 1917-1940. (Ph.D. dissertation, University of Washington, 1971), 95. See also copy in Litchman Collection, Box 1/7 and William M. Short, History of Activities of Seattle Labor Movement and Conspiracy of Employers to Destroy It and Attempted Suppression of Labor's Daily Newspaper, the Seattle Union Record (Seattle, n.d.); Xerox copy in William M. Short Collection, Special Collections, UW.
[vii]Red Suspects Jailed on Orders of Mayor Edwards,."Seattle Times, 12 November 1929.
[x]Ibid., 345. See also Cravens, 160; Union Record 4 May 1922; Litchman to Slater, 25 May 1922, Litchman Papers.
[xi]Washington Secretary of State, Abstract of Votes 1922; Dembo, , 346-347.
[xiii]Daily Worker 17 Feb. 1925; Paul Mohr Trial Transcript. 1925; G.W. Roberge to C.W. Doyle, 3 Feb. 1925, Box 6; J.N. Belanger, et al. to Building Trades Council, 13 Feb. 1925, KCCLC Records, Box 6..
[xv]Minutes, 4, 11, 18-25 Feb., 4, 18 March 25, Box 8; Freen to C.W. Doyle, 6 Feb. 1925; Report of Strike and Grievance Committee of the Trials of Delegate Price, Hansen, Carlson, Mohr, Havel, and Jones, 18 March 1925, KCCLC Records, Box 6..
[xviii]Minutes, 1 April 1925, KCCLC Records, Box 8. Minutes, 8, 15 April, 13 May, 8 July, 12 Aug. 1925; 12, 26 Jan., 27 July, 17 Aug. 1927; 2 Aug. 1933, Box 8; Resolution, 15 Jan. 1929, KCCLC Records, Box 6.
[xix]Washington State Labor News 1925 Yearbook.


Photo via Best of the Musical World / docus / Opera and More.
Use discount code bhamnow7 to save $7.00 by Sunday, May 6th. You've heard of Smokey Joe's Café. Now you have a chance to see this famous Broadway musical in Birmingham. The talented actors of Red Mountain Theatre Company (RMTC) will light up the stage in this classic musical revue May 11-27. Keep reading to get a sneak peek into the show.
Smokey Joe's Café first premiered March 2, 1995, on Broadway. Since it's opening, it has become the longest-running revue in Broadway history, performing an incredible 2,036 times.
Keith Cromwell, Executive Director of the Red Mountain Theatre Company.
What makes it such a hit?
The show's longevity has been fueled by the legendary songs of Mike Stoller and Jerry Leiber, an idealized 1950's setting and toe-tapping tunes like "Hound Dog", "Love Potion #9", "On Broadway" and "Stand By Me".
But a musical revue is only as good as its director and choreographer, actors and, of course, music. So who's helping make the longest-running show on Broadway a success at the Red Mountain Theatre Company?
Meet Henry Scott, artist in residence at RMTC, director and choreographer of Smokey Joe's Café.
Henry Scott, artist in residence at RMTC. Photo via Red Mountain Theater Company's Facebook page.
Henry Scott has been in the performing arts since he was 16 years old, after auditioning for, and being cast in, The Robber Bridegroom at his high school.
Wise was right. For the next 20 years, Scott choreographed every show Wise directed at the community theatre.
Scott went on to study at Webster University Conservatory and, in 1991, he ventured to the Big Apple where he worked consistently for six years.
Scott's affiliation with Red Mountain Theatre Company started in 1995 (the RMTC was called Summerfest at the time) when he was asked to direct Peter Pan and choreograph Godspell. He later returned to RMTC in 2007 to direct, choreograph, and teach.
In the years that followed, he directed Shout!, Les Miserables, The Little Mermaid, Big Fish and Alabama Story; he choreographed 13 and The Color Purple.
Photo via Red Mountain Theatre Company.
Auditions for the production of Smokey Joe's Café wrapped up this past February. Now, with the cast in place, rehearsals are set to start on April 17.
Smokey Joe's Café has two acts, a total of 40 songs, and with only three-and-a-half weeks of rehearsals, all aspects of preparation must be handled quickly and diligently by everyone involved in the production.
Why will Birmingham locals enjoy the show?
Inside the RMTC's Cabaret Theatre. Photo via Red Mountain Theatre Company.
When can you catch the show?
Smokey Joe's Café will be hitting the stage of the Red Mountain Theatre May 11-27, 2018 located at 301 19th St. N., Birmingham, AL 35203.
Are you ready to discover for yourself why Smokey Joe's Café is such a long running Broadway hit? Then purchase your tickets now! Limited seats.