Critique Of Script 2 Essay Example | Topics and Well Written Essays - 500 words

Critique Of Script 2 - Essay Example The target audience who is in the American society will therefore identify with the story line with coercion. The story line is great and equally entertaining, however, the author does not employ a lot of descriptive language in the script. The story entails an eye witness giving an account of his observation. This does not meet the required threshold and as the script continues it becomes evident that the help of the eye witness was insignificant. It is understandable that they eye witness maybe affected by shock or may never relate the entire scenario as expected but the author does not effectively describe the eye witness as such and therefore leaves the audience guessing on the actual occurrence of the scene. However, the general description is satisfactory thereby earning him an above average score. The author performs exceptionally well in his selection of characters. The American society is constituted of various pressure groups some of which identify discrimination even before an author would possibly think of any. However, the author beats this by balancing his author composition effectively. One of the lead characters in the story, Laura is a woman (Marty 2). Additionally, there are a number of other women characters as the story progresses. This is an indication that the author gave adequate considerations to the gender balance. Additionally, there are other types of racial combination of the American population; the author considers this by using a number of African American characters alongside other marginalized community such as Asians alongside the American whites. This balance in demographic factors of population earns him a nine out of the all possible ten. This being a script, it is obvious of the type of style that the audience expects the author to use. He achieves this by making use of dialogues all in the present tense. This is a basic test that the experienced author easily passes.

Chapter 9 & 10 Assignment Example | Topics and Well Written Essays - 1500 words

Chapter 9 & 10 - Assignment Example Question # 2: P&G has now realized the importance of the social media and already shifted its advertisement budget towards social media. The company needs to increase its budget for social media such as face book, twitter as this media has great influence in the mind of people. P&G should also involve in social causes to attach customers emotionally towards it and to build strong brand images. For that purpose, It can offer scholarships to needy and meritorious people, and help needy people. Question # 3: The world is facing economical crises and the buying power of the consumer is reducing which can be worst in future. This is a significant situation which might affect P&G badly. Moreover, the R&D and marketing cost of P&G is increasing with the passage of time which can be problematic for the company as the world is now searching new techniques to reduce cost. In addition to that, increasing competition in FMCG industry is also the major risk which P&G can face in the future. Case 2: McDonald’s Question # 2: The core brand value of McDonald is its high quality food for customers with speed and convenience. Initially, McDonald was offering quality Hamburger but it expanded its menu with other dishes like Happy Meal, Big Mac, Egg, McMuffin etc. The company started expanding its business domestically as well as internationally due to its premium quality of food. However during 1990s company lost its direction i.e. high premium food. It focused to further expand its network of restaurants. It was not focusing to train employees properly and thus customer faced poor services and started losing the interest from the company. The company realized this situation and refocused its 5Ps and adopted the policy to offer different dishes for different region according to their culture and environment. Through this plan McDonald refocused on food and service quality. It also started offering healthy food due to the increasing concern of customers regarding obesity. I t also included ice-cream and coffee in its menu. Question # 2: McDonald should not change its strategy because the strategy worked well for it. It has refocused on its core values which it lost and had negative response from consumers. Therefore it will be a great risk for McDonald to change its strategies. McDonald has expanded its menu and added great varieties in it. Though its core product was Hamburger but it included new food to attract new segments of the market. Moreover, they have included healthier food in the menu and offer to health conscious people at a premium price. The strategy to offer different food for different markets according to their culture and environment has also worked in favor of McDonald. In addition to that, $1 menu was also the marvelous strategy of McDonald which targeted lower income people and teenagers. Question # 3: McDonalds might face several risks in the future. It is a multinational company which can face treasury risk due to the variation i n US Dollars against major currencies. Global instability in the economical crises might also affect McDonald’s business. Another greater risk that it might face is the entrance of new players in the market. The living standard of the people is increasing and they are going to more delicious and quality food. Therefore, the

Eco-Tourism Essay Example | Topics and Well Written Essays - 250 words

Eco-Tourism - Essay Example Major issues The article begins with the startling case of John Gray, a tour operator in Thailand, who discovered a number of tidal sea caves. His efforts to promote the location as an eco-tourism destination, albeit without upsetting the local fragile eco-system, proved ineffective over the years as he met with stiff competition, received threats from local gangs and eventually could not do anything to control the influx of tourists. In the end, the unabated activities of operators, tourists and the local government have severely distorted the delicate ecological balance existing in the area. The article also discusses the evolution of the concept of co-tourism as a way to protect fragile eco-systems and deliver some long-term benefits to the local populations. The power of marketing and the widespread acceptance of the concept have resulted in an explosive growth in the eco-tourism industry the world over. This has not only resulted in a severe harm to the environment due to the ac tivities of tourists (like cutting trees for campfires or collecting stalactite fragments as souvenirs), but has also displaced local tribes and natives. These people complain a lack of inclusion in the decision-making framework within any related initiatives.

Hyphenated American Position Paper Essay Example | Topics and Well Written Essays - 1000 words

Hyphenated American Position Paper - Essay Example In this way, the Irish-American has found a hyphenated identity through response to American perceptions of his (or her) Irishness. The grim nature of nineteenth- and early twentieth-century perceptions of Irish-Americans can be examined through a look at Nast's 1871 cartoon, reproduced below: Two particular signifiers of Irish-American stereotype are present in this picture. The character holds a bottle in one hand and a gun in the other. The bottle signifies Irish drunkenness, and the gun, violence. These stereotypes are so strongly ingrained that even a Korean-born man like myself can look at these signifiers and interpret them in the way intended by the artist. Further, the writing on the bottle - â€Å"Gun Powder, Uncle Sam's† - signifies that the Irish-Americans support their less than respectable habits with the resources of their new land. Nast also addressed Irish females in a series of cartoons about a servant named Brigid. The actual cartoons are difficult to locate , but a description can be found of her in Bronwen Walter's Outsiders Inside as a â€Å"clownish Irish maid.† (63) These characteristics were among America's first popular perceptions of the Irish-American. The Irish-American had much to contend with in building an identity. ... The narrator of the song applies for a job and is told, â€Å"No Irish need apply,† and the following occurs: I couldn't stand it longer, so a hoult [sic] of him I took, And I gave him such a welting as he'd get at Donnybrook. He hollered, Millia murther, and to get away did try, And swore he'd never write again, No Irish need apply. He made a big apology, I bid him thin [sic] good-bye, Saying: Whin [sic] next you want a bating [sic] write, No Irish need apply. (Poole, 1862) In this stanza, the narrator reclaims ownership of the violence stereotype, but turns it into an expression of pride. The final line signifies the narrator's willingness to stand up for his identity. In reclaiming this identity, he also reclaims the stereotype of the Irish-American as violent. He seems to intend an act of physical violence to be read as strength and pride instead of the byproduct of laziness associated with the trait in the Nast cartoons. This reclaiming continued long past the 1860s. Over a century later, Irish author Frank McCourt responded to these cartoons in his 1997 musical The Irish and How They Got That Way. His responses are not verbal but theatrical, as his actors perform â€Å"Brigid† jokes: WOMAN 1:Mrs. Van Wick said to Brigid, 'Look at the dust on this sideboard; I can write my name in it!' WOMAN 2: Lord above, Missus, isn't it a great thing to have an education! (McCourt, 1997) In performance, as viewable on the original cast recording, the actress portraying the mistress speaks in a high-class accent. The actress portraying â€Å"Brigid,† by contrast, speaks in a high-pitched brogue and rolls her eyes at the punchline. This action serves as a commentary on the ridiculousness of the joke

Quakers Case Essay Example for Free

Quakers Case Essay This research paper will argue that the evangelicals were embraced mostly by blacks not only because it’s the nearest imitation of their African nature rituals but because they have given support to the abolition of slavery in the United States. Quakers were known to be the most vocal concerning their opposition to slavery; there were also other denominations that did not favor slavery. George Fox, founder of the Quaker group Society of Friends, preached against slavery in the late 16oo’s, but never really took action against it. Even though Fox, a major Quaker leader, was opposed to slavery, other Quaker leaders owned slaves. This was because they interpreted the doctrines of their religion to exclude slaves. The institution of slavery became a divided issue among Quakers in the Society. Benjamin Lay, for example, was against slavery. Methodists, Baptists, and Presbyterians were very vocal concerning their dissatisfaction with slavery. (1) However, the main concern was that large amounts of the population were not being exposed to God. They had to resolve whether the larger concern was to end slavery and thus allow many â€Å"unchristian people to go to hell after death, or to evangelize the slaves while letting the issue of slavery slide under the carpet. Subsequently, Methodists and Baptists also became the two denominations to achieve the earliest successes in proselytizing slaves (Lane 184). The first third of the nineteenth century was a significant time for antislavery. Haitian slaves had risen up and freed themselves from French rule in 1803. In England, decades of antislavery agitation led Parliament to abolish slavery in the British Empire by 1834 In the United States, sectional friction related to slavery began in earnest with the Missouri crisis of 1820. Nor were black voices silent. Free African American ministers sermonized against slavery’s cruelties. Periodic fears of slave violence came to a head in 1822 with the discovery of Denmark Vesey’s planned slave uprising (2). As the conflict over slavery heated up, and as news of the Vesey conspiracy broke in 1822, and word spread about the rebellion of Nat Turner in 1831, a great fear enveloped whites (5).   All these factors caused a few whites to begin to renew the spiritual struggle against slavery. The Reverend George Bourne, an Englishman who headed a Presbyterian congregation in Virginia, refused communion to slaveholders and excoriated slaveholding ministers. Way back 1784 Methodists were so bold as to say that they promised to excommunicate all Methodists not freeing their slaves within two years (5). Opposing racism is definitely amongst the strongest reasons for the abolition of slavery. This argument seems quite feasible, considering the fact that only Negroes were slaves. That is to say, skin color was the most deciding factor in whether somebody was a slave or a slaveholder (1). Catherine Meeks, professor of African American studies at Mercer University in Macon, Georgia, says, It was the white control of the worship [on slave-holding plantations], the inability to accept blacks as equals, and the negation of black personhood that led to the separation of the black church from the white church and to the emergence of a black religious community. (4) Independent black churches—most of them Baptist or Methodist—were not separating themselves from whites because they held a different doctrinal view of Christianity, notes James H. Cone of Union Theological Seminary. Without exception, blacks used the same articles of faith and polity for their churches as the white denominations from which they separated. Separation, for blacks, meant that, they were rejecting racism that was based on the assumption that God created blacks inferior to whites. (5) Even though white Protestant denominations in the 1840s split over the issue of slavery, the congregations of northern Protestants remained just as closed to blacks who moved north. Given the increasing racial proscription in the mid-1800s, (9) Many Black preachers developed a significant following across the South among both whites and blacks. John Jasper of Virginia was one such man. Slaves would defer funeral ceremonies for as long as necessary to bring him to the plantation for the service. And Jasper was equally popular among whites. During the Civil War, Jasper won a warm response from the Confederate wounded to whom he preached and offered solace (9). A long history of antislavery and political activity among Northern black Protestants had convinced them that they could play a major role in the adjustment of the four million freed slaves to American life. In a massive missionary effort, Northern black leaders such as Daniel A. Payne and Theophilus Gould Steward established missions to their Southern counterparts, resulting in the dynamic growth of independent black churches in the Southern states between 1865 and 1900 (10). Predominantly white denominations, such as the Presbyterian, Congregational, and Episcopal churches, also sponsored missions, opened schools for freed slaves, and aided the general welfare of Southern blacks, but the majority of African-Americans chose to join the independent black denominations founded in the Northern states during the antebellum era. Within a decade the African Methodist Episcopal (AME) and the African Methodist Episcopal Zion (AMEZ) churches claimed Southern membership in the hundreds of thousands, far outstripping that of any other organizations. They were quickly joined in 1870 by a new Southern-based denomination, the Colored (now Christian) Methodist Episcopal Church, founded by indigenous Southern black leaders (11). The relentless evangelist figures were catalysts of the constitutional abolision of the slaves. They fought for the freedom through the exposure to God’s theoretical equality. Emancipation from slavery in 1863 posed distinctive religious challenges for African Americans in the South. When the Civil War finally brought freedom to previously enslaved peoples, the task of organizing religious communities was only one element of the larger need to create new livesto reunite families, to find jobs, and to figure out what it would mean to live in the United States as citizens rather than property. Melville J. Herskovits has advanced the thesis that the success of Baptists in attracting blacks was rooted in the appeal of immersion which suggests a connection in the slaves mind with the river spirits in West African religions. Others have attacked this position including, the black scholar E. Franklin Frazier who argues that enslavement largely destroyed the social basis of religion among blacks, and that the appeal of Baptists to blacks concerns the emotional content of their worship. Stanley Elkins (whose views were heavily influenced by what took place in the concentration camps of World War II Europe), has arguedlike Frazierthat slavery was so demeaning that blacks (like the Jews in the camps) were eventually stripped of every shred of dignity and humanity, including their faith. John Blassingame, on the other hand, has provided a significant body of evidence that blacks hung on to their religion as a form of resistance (11). African-American religion dealt with life as blacks lived it. It was about pain and sorrow, sin and shortcoming, pardon and joy, praise and thanksgiving, grace and hope. This version of Evangelicalism provided a wonderful benefit; it was able to accomplish great things in their lives that were frequently shouted about. This transition coincided with the period of intense religious revivalism known as awakenings. In the Southern states beginning in the 1770s, increasing numbers of slaves converted to evangelical religions such as the Methodist and Baptist faiths. Many clergy within these denominations actively promoted the idea that all Christians were equal in the sight of God, a message that provided hope and sustenance to the slaves (12). Slave Spirituals became the creative group expression of these aspirations. The Ring Shout was the most distinctive expression of religious worship in the praise service, with African-derived dancing and body movement emphasized. The invisible religion of the slave quarters also included conjure, a system of spiritual influence that combined herbal medicine with magic and sometimes gave surprising authority to slave practitioners who believed they could affect whites as well as blacks (6). They also encouraged worship in ways that many Africans found to be similar, or at least adaptable, to African worship patterns, with enthusiastic singing, clapping, dancing, and even spirit-possession. It was here that the spirituals, with their double meanings of religious salvation and freedom from slavery, developed and flourished; and here, too, that black preachers, those who believed that God had called them to speak his Word, polished their chanted sermons, or rhythmic, intoned style of extemporaneous preaching. The closest replication of their religious belief was the evangelicals’ approach. African Americans, often termed as ‘blacks’, was so closely intertwined with their total life experience that the starting point in understanding the meaning of that religious life must be the total life experience. For them, before they were forced to become unwilling participants in one of the most oppressive systems of slavery that the world had witnessed, the ancestors of the African Americans in Africa were very much a religious people. In their native land the totality of their lives was informed by what in western Europe was defined as religion, but what, to them meant as a basic and integral part of life (Jones 1991).Thus, they brought that religion with them. Blacks responded to the evangelical message, though, for different reasons than those advanced by slave owner-sanctioned preachers. The potential for spiritual equality, and even the hope for earthly liberty, could be taken from evangelicalism, and that was a powerful appeal to slaves. (8) Evangelicalism’s informal, spirit-driven style of worship could evoke remembrances of the religious ecstasies of African dance religions, another reason to embrace the faith. Nowhere else in southern society did African Americans find the status that they could achieve as in churches. Some African Americans worshipped in separate black churches, but black Baptists and Methodists had shaped evolving Evangelicalism in general since the earliest revivals. Most slave worship was in biracial churches. Evangelicalism took root among African-Americans. Large numbers underwent conversion, baptism, instruction, worship, and lived the life of Christian even in face of oppression. Although, the development of their own religious institutions would await Emancipation and the wars end, there were many thousands of Negro Baptists and Methodists by 1850. Emancipation brought many tangible rewards. Among the most obvious was a significant increase in personal freedom that came with no longer being someone elses property: whatever hardships they faced, free blacks could not be forcibly sold away from their loved ones. But emancipation did not bring full equality, and many of the most striking gains of Reconstruction — including the substantial political power that African Americans were briefly able to exercise — were soon lost. In the decades after Reconstruction African Americans experienced continued poverty and exploitation and a rising tide of violence at the hands of whites determined to re-impose black subordination. They also experienced new forms of discrimination, spearheaded by a variety of state laws that instituted rigid racial segregation in virtually all areas of life and that (in violation of the 14th and 15th Amendments) effectively disfranchised black voters. The struggle to overcome the bitter legacy of slavery would be long and arduous. Many abolitionists belonged to the African Methodist Episcopal Zion (AMEZ). AMEZ became a platform for preaching against slavery. The ministry was by far the most common occupation of the black leaders in the abolitionist movement (Sorin 101). AMEZ enabled people like Denmark Vesey to plan revolts. Pennington traveled as far as Europe to preach against slavery. He wrote, If the New Testament sanctions slavery, it authorizes the enslavement of whites as well as us (Voices of Triumph 127). Ward was born into a slave family that escaped in 1820. He lived in upstate New York and was an agent for the American Anti-slavery Society. Ward actively protested the Fugitive Slave Law of 1850. He was also an assistant to fugitive slaves (Voices of Triumph 145) (9). Over one hundred and thirty years after Nat Turner was hanged, black theology emerged as a formal discipline. Beginning with the black power movement in 1966, black clergy in many major denominations began to reassess the relationship of the Christian church to the black community. Black caucuses developed in the Catholic, Presbyterian, and Episcopal churches. The central thrust of these new groups was to redefine the meaning and role of the church and religion in the lives of black people. Out of this reexamination has come what some have called a Black Theology’. (10) The secret meetings of praise† of the former slaves was later institutionalized and these assemblies gave rise to independent churches. The first religious institution primarily controlled and administered by blacks was established at Silver Bluff, South Carolina in the 1770s.The Free African Society of Philadelphia, established in 1778 by two former slaves, Richard Allen and Absalom Jones was an example of one of the earliest formal organizational activity- more frequent among the free blacks in the urban North (Woodson 1922). Most of such groups were quasi-religious bodies and churches frequently came into existence from the membership of these societies. The Free African Society of Philadelphia, that newly created independent body, was the mother of two African Amertican churches- St. Thomas African Episcopal Church (later named the St. Thomas Protestant Episcopal Church) established in 1794, and the Bethel African Church (later becoming an independent organization known as the African Methodist Episcopal Church), which was the first black congregation in the Philadelphia Methodist Conference. In 1894 black Baptists formed the National Baptist Convention, an organization that is currently the largest black religious organization in the United States. There may be several reasons that evangelist were able to convert slaves, some would argue that this may be attributed to the verity that the slaves saw religion as the nearest observable fact to freedom. Still, it is quite notable that the evangelist were able to gather members not only because the African- Americans see their way of teaching as the nearest to their old rituals but also because of the evangelists’ unerring efforts to abolish slavery in the United States.

Teaching and Learning in Clinical Practice

Teaching and Learning in Clinical Practice The purpose of this essay is to outline the episode of teaching and learning in clinical practice that I have been involved. It will describe the significance of under penning theory of teaching, It will demonstrate knowledge and understanding teaching and learning methods relate with learning outcomes/objectives, assessment, and evaluation and quality assurance. It will also going to looking at the reflection that has been required to the teaching session based on the evaluation. I am going to use Gibbs (1988) Reflective Cycle. This model is a recognized framework for my reflection. Gibbs (1988) consists of six stages to complete one cycle which is able to improve my teaching practice continuously and learning from the experience for better practice in the future. Learning is the act or process by which behavioural change, knowledge, skills and attitudes are acquired Boyd, et al. (1980) therefore learning is not just attending a class or reading books it is all about changing behaviours and attitudes, reflecting what has been taught by practicing. There are three sets of learning theory generally used in educational circles these are behaviourist, humanistic, and cognitive. For my teaching session I have used Cognitive approach because the cognitive method is student-centred. In other words, as an adult learner, the students find out for themselves in a self-directed way Pritchard, A. (2008). According to Knowles, M.S. (2005) and Quinn, F.M Hughes, S (2007) cognitive learning is a great method that provides the means of knowledge, and goes well beyond simple imitation of others. Conditioning can never explain what you are learning from reading our web-site. This learning illustrates the importance of cognitive learning Conner, M. L. (2005).. Cognitive learning defined as the gaining of knowledge and skill by mental or cognitive processes. The procedures we have for manipulating information in our heads Cognitive processes include creating mental representations of physical objects and events, and other forms of information processing Thorners.L (2009). In cognitive learning, the individual learns by listening, watching, touching, reading, or experiencing and then processing and remembering the information. Cognitive learning might seem to be passive learning, because there is no motor movement. However, the learner is quite active, in a cognitive way, in processing and r emembering newly incoming information. One of the most useful descriptive models available of the adult learning process provided by Kolb (1984) suggesting that there are four stages in learning which follow from each other: Concrete Experience is followed by Reflection on that experience on a personal basis. This may then be followed by the derivation of general rules describing the experience, or the application of known theories to it Abstract Conceptualisation, and thus to the construction of ways of modifying the next occurrence of the experience Active Experimentation, leading in turn to the next Concrete Experience. All this may happen in a flash, or over days, weeks or months, depending on the topic, and there may be wheels within wheels process at the same time Muijs.D And Reynolds.D (2006),à ¢Ã¢â€š ¬Ã‚ ¦Ãƒ ¢Ã¢â€š ¬Ã‚ ¦Ãƒ ¢Ã¢â€š ¬Ã‚ ¦. According to Pritchard, A. (2008) the best way for a person to learn depends on the person, of course. It is well know that people have different leaning styles that work best for them. The best approach for a teacher to take is to address a variety of learning styles with their teaching plan. It is also helpful to encourage students to understand their preferred leaning style. Teachers should make students aware of the various learning styles and encourage them to consider their preferred style as they complete their studies. Wragg.E.C (2004) recommended that teachers should create an environment with lots of tools for developing an understanding of the topic. I have provided PowerPoint slide and image from the web so that the students can learn in both way from the slide and image. I have applied them by allowing the students to be active participants discussing on the topic, monitoring students progress and ask lots questions and answer. Teachers should provide use of visual and v erbal teaching methods as well as speak out loud student using technique. Student should think deeply and answer questions about the topic to further develop their understanding. Incorrect answer can be a good thing as it helps the student recognise that they need learn more to achieve purpose of the topic Conner, M. L. (2005). Cognitive learning strategies include case studies, research, discussions, self-assessment and presentations. As an adult learner, I used PowerPoint presentation with good font size and good background light as well as topic related image which can attracts the audience and grape their tension. The topic of the lesson I have prepared was based on the audience level and relevant for their future nursing career. According to NMC (2008) we have a duty to facilitate students of nursing, midwifery and specialist community public health nursing and others to develop their competence. I have a responsibility to teach based on current evidence, best practice and, where acceptable, validated research when it is available. According to Malcolm (2005) the Andragogical Model in adult learners has a self-concept of being responsible for their own decisions, for their own lives. Ones they arrived at that self-concept, they develop a deep psychological need to be seen by others and treated by other s as being capable of self-direction. This includes letting learners know how the topic is important to learn, showing learners how to direct themselves through information and relating the topic to their experiences. In addition, people will not learn until they are ready and motivated to learn. Often this requires helping them overcome inhibitions, behaviours, and beliefs about learning Conner, M. L. (2005). Lesson plan is one of the most important principles of good teaching so that the teacher can check that he/she keeping to time and actually what the content of her/his lesson is, as well as a framework for reflection and evaluation Pritchard, A. (2008) Thorners.L (2009) I have structured my lesson plan by asking myself about the title for the session, the type of expected learning, about teaching and learning methods, length of time available, location of teaching session, access computer, internet resources, etc. I also think about the audience the number of learners and their study level or stage in training, and how will I know if the students understand? This is by assessing student Informal and formal way, questioning techniques, feedback from learners Knowles, M.S. (2005), Muijs.D And Reynolds.D (2006) and Surgenor.P (2010) I have also set out the aim and objectives for my teaching session, that way the students know what to expect and also what they are expected to know by the end of the session. Surgenor.P (2010), Muijs.D And Reynolds.D (2006) explained that the goal of creating learning objectives is to provide a means of clarifying the purpose of teaching to ensure the lesson is successful and the objectives are achieved. Clearly identifying learning objectives improves the communication between the teacher and the learner. When the objectives of a teaching have been clearly identified and presented in an orderly progression, the desired learning outcomes will be attained. In this paragraph, I am going to reflect on the situation that taken place during my teaching session using Gibbs module which consist six stages. The cycle starts with a description of the situation, next is to analysis of the feelings, third is an evaluation of the experience, fourth stage is an analysis to make sense of the experience, fifth stage is a conclusion of what else could I have done and final stage is an action plan to prepare if the situation arose again NHS, (2006). Dunn.L, (2002) and Wragg.E.C (2004) gave some reasons why reflection is require in the reflective practice. They state that a reflect is to generate the practice knowledge, assist an ability to adapt new situations, develop self-esteem and satisfaction as well as to value, develop and professionalizing practice. However, Jasper M (2003) explain that reflection is about gaining self-confidence, identify when to improve, learning from own mistakes and behaviour, looking at other people perspectives, being se lf-aware and improving the future by learning the past. Description, I had a clinical teaching session PowerPoint presentation for my fellow students at London South Bank University in January 2011. It was a 20 minutes teaching session based on nursing related topic I left home early as I wanted to print my note. Unfortunately it was just a shame that I forgot my student card and couldnt print my work for this result I was panicking but I managed to teach using the PowerPoint slides. I thought the students will come up with lots questions which would challenge me. Feelings, I was feeling nervous just before I begin to talk and during the first  five minutes, and then things get much easier. Before I started to teach, I introduced myself and approached the students to build a good connection with them as I do not want them to feel bored as well as I myself was blank due to anxiety. My first approached was to ask them how much they know about the topic. The students were interested in the topic and they were quite knowledge about the topic. In this situation, I showed up my emphatic listening. According to Wold (2004) the emphatic listening is about the motivation to understand the other person not just judging the persons fact. Then, I start going through slides in detail each point and I ensured if the students could hear me as I was quite quickly spoken and coughing during talk due to mouth dryness. In the meantime I used non-verbal communication skills with them including using my body gesturers and facial expression. Body gesturers and fa cial expressions are referred as a non-verbal communication Surgenor.P (2010) and Jasper M (2003). As a result, the students gave a good collaboration and enjoyed the session until finished. Evaluating, I was pleased to see that the students did not disappoint with the session. I feel I make the right decision to accompany and assess student if they could hear me in order to get my point. Furthermore, I could develop my confident to teach/communicate more effectively. Although Pollard.A, (2008), would describe it as a task-centre communication as one of the element caused the lack communication among teachers. My worry was that during my preparation it was not considered how I could handle my anxieties and nerves which affect my communication by talking quick or may not clear enough. In my analysis, generally the session went well because I used cognitive approach correctly and used appropriate teaching method. Point out that Pritchard, A. (2008) cognitive theory is a great theory to follow when teaching. I was suffering with mouth dryness and talked quickly, it seemed because I was nerves, otherwise enjoyed good teaching. During my presentation it might have helped to have a print out note of my presentation so that I dont get blank and also I might have helped if it was considered how I will handle my own anxieties and nerves for example to have a bottle of water would have help to hydrate me. Study suggested that to practice my talk and keep a note of timings and any helpful stage direction as well as considering how to react under pressure. Study also shows that it is common to speak more quickly when nervous and therefore, it is useful to think of ways of slowing down at the beginning of your talk NHS (2006), Pollard.A, (2008), Skinner.D (2010). The students were satisfied to learn new thing from the topic that has no previously done and learnt the important point of the session. I was satisfied with engaging students by asking questions and answering, student discussion and that they appeared to be knowledgeable. According to West, Clark and Jasper (2007) provide students with best opportunity for success during the assessment process it is essential to ensure they have a feasible workload for their stage of education that can enable them to learn as well as to work therefore I was giving them every opportunities to ask question and to discuses on the topic by assessing what they learnt and by asking questions which help students to build up their confidence. Conclusion, after analysed the situation, I could conclude that I was able to know how important a good practice is valuing student respect them and treat them as an individual to deliver a good teaching. I also gain knowledge the skills for effective communication with the student weather I am nerves or anxious, I could communicate effectively with student such as approach the student, asking questions, be an active listening, show my understanding and support the encourage for further reading. There wasnt a lot I could have done in this situation; I did ask students as much as I could and I was able to answer their question as well which makes me feel good. However, I could have challenged the students by kept a little bit more if I had print out my note. The Gibbs reflective method has helped me to learn from experience and has given me an insight on what I would do differently if the situation happened again. In the future I believe that I will be able to demonstrate and work closely with both service users to support them, by assessing their needs, reviewing risks, policies and procedures that apply to them. Action plan, for the future I will be able to give the best teaching practice because now I have gain more knowledge about how to prepare teaching session and how to teach. I am also aware that by assisting patients in many ways for example, help patients to contain uncomfortable feelings, by assessing what my symptoms are, I need to learn how to hide these symptoms and pretend to be more confident. For example, if my hands were shaking I wouldnt hold my notes in my hands. If my mouth does dry, then I would keep a bottle of water along. According to Pollard.A, (2008), often by finding ways of controlling the symptoms, you will find that you are no longer feeling quite so anxious. During this essay I learnt the role of teaching and learning theory and I have developed skills and professional knowledge to work effectively with others. Also this essay helped me to develop my knowledge in teaching and learning and understand how the laws and policies are set up to give a better quality practice for teaching so I will use this for my future teaching in practice. I also learnt about individual needs in teaching and the important of approach to teach with student that promotes diversity and valuing differences, Self-esteem and positive group identity, fulfilment of individual potential, and, the full participation of all groups in society.

Ssis Is An In Memory Pipeline Computer Science Essay

Ssis Is An In Memory Pipeline Computer Science Essay Since SSIS is an in-memory pipeline, one has to ensure that transactions occur in the memory for performance benefits. To check if your package is staying within memory limits, one should review the SSIS performance counter Buffers spooled. This has an initial value of 0. Any value above 0 is an indication that the engine has started disk-swapping activities. Capacity planning to understand resource utilization In order to understand resource utilization it is very important to monitor CPU, Memory, I/O and Network utilization of the SSIS package. CPU It is important to understand how much CPU is being utilized by SSIS and how much of CPU is being utilized by overall SQL Server while Integration Services is running. This latter point is very important, especially if you have SSIS and SQL Server on the same box, because if there is resource contention, SQL Server will surely win that will result into disk spilling from Integration Services resulting in slower transformation speed. The performance counter that should be monitored is Process / % Processor Time (Total). One should measure this counter for both sqlservr.exe and dtexec.exe. If SSIS is not close to 100% CPU load, then this indicates: Application contention For e.g. SQL Server takes more processor resources, makes it unavailable for SSIS Hardware contention Probably a suboptimal disk I/O or not enough memory to handled the amount of data to be processed Design limitation The SSIS design is not making use of parallelism, and/or the package has too many single-threaded tasks Network SSIS moves data as fast as your network is able to handle it. Hence, it is important to understand your network topology and ensure that the path between the source and destination have both low latency and high throughput. Following performance counters can help you tune the topology: Network Interface / Current Bandwidth Provides estimate of current bandwidth Network Interface / Bytes Total/Sec The rates at which bytes are sent and received on each network adapter Network Interface / Transfers/Sec How many network transfers per second are occurring. If the number is close to 40,000 IOPs, then get another NIC card and use teaming between the NIC cards Input / Output (I/O) A good SSIS package should hit the disk only when it reads from the sources and writes back to the target. But if the I/O is slow, reading and especially writing can create a bottleneck. So it is very important to understand that the I/O system is not only specified in size (like 1 TB, 2 TB) but also its sustainable speed (like 20,000 IOPs). Memory The key counters to monitor memory for SSIS and SQL Server are as follows: Process / Private Bytes (DTEXEC.EXE) amount of memory currently used by Integration Services that cannot be shared with other processes Process / Working Set (DTEXEC.EXE) amount of allocated memory by Integration Services SQL Server: Memory Manager / Total Server Memory amount of allocated memory for SQL Server. This counter is the best indicator of total memory used by SQL, because SQL Server has another way to allocate memory using the AWE API Memory / Page Reads/sec total memory pressure on the system. If this consistently goes above 500, it is an indication that the system is under memory pressure Baseline Source System Extract Speed It is important to understand the source system and the speed at which data can be extracted from it. Measure the speed of the source system by creating a simple package that reads data from some source with the destination that says Row Count Execute this package from the command line and measure the time it took for it to complete the task. Using Integration Services log output, you can measure the time taken. Formula to be used: Rows/Sec = RowCount / Time Based on the above value, you can judge the maximum number of rows per second that can be read from the source. To increase the Rows/Sec calculation, you can perform one of the following operations: Improve drivers and driver configurations: Ensure you are using the up-to-date driver configurations for the network, data source and disk I/O. Start multiple connections: To overcome limitations of drivers, you can start multiple connections to your data source. If the source is able to handle many concurrent connections, the throughput will increase if you start several extracts at once. If concurrency causes locking or blocking issues, consider partitioning the source having your packages read from different partitions to more evenly distribute the load Use multiple NIC cards: If network is the bottleneck and you have ensured you are using gigabit network cards and routers, then a potential solution is to use multiple NIC cards per server. Optimize SQL data source, Lookup transformations and Destination Here are some optimization tips that you can implement in your SSIS packages: Use NOLOCK or TABLOCK hints to remove locking overhead Refrain from using SELECT * in SQL queries. Mention each column name in the SELECT clause for which data needs to be retrieved If possible, perform datetime conversions at source or target databases In SQL Server 2008 Integration Services, there is a new feature of shared lookup cache. During the use of parallel pipelines, it provides high-speed, shared cache If Integration Services and SQL Server run on the same box, use SQL Server destination instead of OLE DB Commit size 0 is fastest on heap bulk targets. If you cannot use 0, use the highest possible value of commit size to reduce overhead of multiple-batch writing. Commit size = 0 is bad while inserting into BTree because all incoming rows must be sorted at once into the target BTree, and if the memory is limited, there is a likelihood of spill. Batchsize=0 is ideal for inserting into a heap. Please note that a commit size value of 0 might cause the running package to stop responding if the OLE DB destination and another data flow component are updating the same source table. To ensure that the package does not stop, set the maximum insert commit size option to 2147483647 Use a commit size of Heap inserts are typically faster than using a clustered index. This means it is recommended to drop and rebuild all the indexes if there is a large part of the destination table getting changed. Use partitions and partition SWITCH command. In other words load a work table that contains single partition and SWITCH it into the main table after the indexes are build and then put the constraints on Network tuning Packet size is the main property of the network that needs to be monitored / looked at in order to take decisions for Network tuning. By default this value is set to 4,096 bytes. As noted in SqlConnection.PacketSize property in .Net Framework Class Library, when the packet size is increased, it will improve performance because fewer network read and write operations are required to transfer a large data set. If your system is transactional in nature, lowering the value will improve the performance. Another network tuning technique is to use network affinity at the operating system level to increase the performance at high throughputs. Use Data Type wisely Following are some best practices related to usage of data types: Define data types as narrow as possible Do not perform excessing casting of data types. Match your data types to the source or destination and explicitly specify data type casting Take care of precision when using money, float and decimal data types. Money data type is always faster than decimal and has fewer precision considerations than float. Change the design Following are some best practices related to SSIS design: Do not SORT within Integration Services unless absolutely necessary. In order to sort the data Integration Services allocates memory space for the entire data set that needs to be transformed. Preferably, presort the data before hand. Another way to sort the data is by using ORDER BY clause to sort large data in the database. There are times where using Transact-SQL will be faster than processing the data in SSIS. Generally all set-based operations will perform faster in Transact-SQL because the problem can be transformed into a relational algebra formulation that SQL Server is optimized to resolve. Set-based UPDATE statements these are more efficient than row-by-row OLE DB calls Aggregation statements like GROUP BY and SUM are also calculated faster using T-SQL instead of in-memory calculations by a pipeline Delta detection is a technique where you change existing rows in the target table instead of reloading the table. To perform delta detection, one can change detection mechanism such as the new SQL Server 2008 Change Data Capture (CDC) functionality. As a rule of thumb, if the target table has changed > 10 %, it is often faster to simply reload than to perform the delta detection Partition the problem For ETL design, partition source data into smaller chunks of equal size. Here are some more partitioning tips: Use partitioning on your target table. Multiple versions of the same package can be executed in parallel to insert data into different partitions of the same table. The SWITCH statement should be used during partitioning. It not only increases parallel load speed, but also allows efficient transfer of data. As implied above, the package should have a parameter defined that specifies which partition should it work on. Minimize logged operations If possible, used minimal logged operations while inserting data into your target SQL Server database. When data is inserted into a database in fully logged mode, the size of the log grows quickly, because each row that is written in the database is also written to the log. Therefore, consider the following while designing SSIS packages: Try to perform data flows in bulk mode instead of row by row. This will help minimize the number of entries to the log file. This eventually results into less disk I/O hence improving the performance If for any reason you need to delete data, organize the data in such a way that you can use TRUNCATE instead of DELETE. The later places an entry of each row that is deleted into the log file. The former will delete all the data and just put one entry into the log file If for any reason partition need to be move around, use the SWITCH statement. This is a minimally logged operation If you use DML statements along with your INSERT statements, minimum logging is suppressed. Schedule and distribute it correctly Good way to handle execution is to create a priority queue for your package and then execute multiple instances of the same package (with different partition parameter values). This queue can be a simple SQL Server table. A simple loop in the control flow should be a part of each package to: Pick a relevant chunk from the queue Relevant means that is not already been processed and that all chunks it depends on have already executed Exit the package if no item is returned from the queue Perform work required on the chunk Mark the chunk as done in the queue Return to the start of the loop Picking an item from the queue and marking it as done can be implemented as a stored procedure. Once you have the queue in place, you can simple start multiple copies of DTEXEC to increase parallelism. Keep it simple Unnecessary use of components should be avoided. Here is one of the way to avoid it: Step 1: Declare the variable varServerDate Step 2: Use ExecuteSQLTask in the control flow to execute a SQL query to get the server datatime and store it in the variable Step 3: Use the dataflow task and insert/update database with the server datatime from the variable varServerDate This sequence is advisable only in cases where the time difference from Step 2 to Step 3 really matters. If that does not matter, then just use the getdate() command at Step 3 as shown below: Create table #Table1(t_ID int, t_date datetime) Insert into #Table1(t_ID, t_date) values(1, getdate()) Executing a child package multiple times from a parent with different parameter values While executing a child package from a master package, parameters that are passed from the master package should be configured in the child package. Use the Parent Package Configuration option in the child package to implement this feature. But for using this option, you need to specify the name of the Parent Package Variable that is passed to the child package. If there is a need to call the same child package multiple times (each time with a different parameter value), declare the parent package variables (with the same name as given in the child package) with a scope limited to Execute Package Tasks. SSIS allows declaring variables with the same name but the scope limited to different tasks all inside the same package. SQL Job with many atomic steps For the SQL job that calls the SSIS packages, create multiple steps, each performing small tasks rather than one step that performs all the tasks. Creating one big step, the transaction log grows too big and if a rollback takes place, it make take the full processing space of the server. Avoid unnecessary typecasts Avoid unnecessary typecasts. For e.g., flat file connection manager, be default, uses the string [DT-STR] data type for all columns. You will have to manually change it, if there is a need to use the actual data type. It is always a good option to change it at the source-level itself to avoid unnecessary type casting. Transactions Usually, ETL processes handle large volume of data. In such scenarios, do not attempt a transaction on the whole package logic. SSIS does support transactions, and it is advisable to use transactions. Distributed transaction that span across multiple tasks The control flow of an SSIS package threads together various control tasks. In SSIS it is possible to set a transaction that can span into multiple tasks using the same connection. To enable this, set value of the retainsameconnection property of the Connection Manager to true Limit the package name to maximum of 100 characters When a SSIS package with a package name exceeding 100 characters is deployed in SQL Server, it trims the package name to 100 characters, which may cause an execution failure. SELECT * FROM Do not pass any unnecessary columns from the source to the destination. With the OLEDB connection manager source, using the Table or View data access mode is equivalent to SELECT * FROM tablename, which will fetch all the columns. Use SQL Command to fetch only required columns and pass that to the destination. Excel source and 64-bit runtime Excel Source or Excel Connection manager works only with the 32-bit runtime. Whenever a package that uses Excel Source is enabled for 64-bit runtime (by default, this is enabled), it will fail on the production server using the 64-bit runtime. Go to solution property pages debugging and set Run64BitRuntime to FALSE. On failure of a component, stop / continue the execution with the next component When a component fails, the property failParentonFailure can be effectively used either to stop the package execution or continue with the next component execution in the sequence container. The constraint value connecting the components in the sequence should be set to Completion. Also the failParentonFailure property should be set to FALSE. Protection To avoid most of the package deployment error from one system to other, set the package protection level to DontSaveSensitive Copy pasting script component Once you copy-paste a script component and execute the package, it may fail. As a work-around, open the script editor of the pasted script component, save the script and then execute the package. Configuration filter Use as a filter As a best practice use the package name as the configuration filter for all the configuration items that are specific to a package. This is typically useful when there are so many packages with package specific configuration items. Use a generic name for configuration items that are general to many packages. Optimal use of configuration records Avoid using the same configuration item recorded under different filter / object name. For e.g. there should be only one configuration record created if two packages are using the same connection string. This can be achieved by using the same name for the connection manager in both the packages. This is quite useful at the time of porting from one environment to other (like UAT to Prod). Pulling High Volume data Process of pulling high volume is represented in the following flowchart: The recommendation is to consider dropping all indexes from the target tables if possible before inserting data especially when the volume inserts are high. Effect of OLEDB Destination Settings Certain settings with OLEDB destination will impact the performance of the data transfer. Lets look at some of them: Data Access Mode This setting provides fast load option, which internally uses BULK INSERT statement for uploading data into the destination table. Keep Identity By default this setting is unchecked which means the destination table (if it has an identity column) will create identity values on its own. On checking this setting, the dataflow engine will ensure that the source identity values are preserved and same value is inserted into the destination table. Keep NULLs By default this setting is unchecked which means default value will be inserted (if the default constraint is defined on the target column) during INSERT into the destination table if NULL value is coming from the source for that particular column. On checking this option, the default constraint on the destination tables column will be ignored and preserved NULL of the source column will be inserted into the destination column. Table Lock By default this setting is checked and the recommendation is to let it be checked unless the same table is being used by some other process at the same time. Check Constraints By default this setting is checked and recommendation is to have it unchecked if you are sure the incoming data is not going to violate constraints of the destination table. This setting indicates that the dataflow pipeline engine will validate the incoming data against the constraints of target table. Performance of data load can be improved by unchecking this option. Effects of Rows per Batch and Maximum Insert Commit Size settings Rows per batch The default value for this setting is -1 which means all incoming rows will be treated as a single batch. If required you can change this to a positive integer value to break all incoming rows into multiple batches. The positive integer value will represent the total number of rows in a batch Maximum insert commit size Default value for this setting is 2147483647 which means all incoming rows will be committed once on successful completion. If required, you can change this positive integer to any other positive integer number that would represent that the commit will be done for those specified number of records. This might put an overhead on the dataflow engine to commit several times, but on the other side it will release the pressure on the transaction log and save tempdb from growing tremendously especially during high volume data transfers. The above two settings are mainly focused on improving the performance of tempdb and transaction log. Avoid Synchronous/Asynchronous transformations While executing the package, SSIS runtime engine executes every task other than data flow task in defined sequence. On encountering a data flow task the execution of the data flow task is taken over by the data flow pipeline engine. The dataflow pipeline engine then breaks the execution of the data flow task into one ore more execution tree(s). It may also execute these trees in parallel to achieve high performance. To make things a bit clearly, here is what an Execution Tree means. An Execution tree starts at a source or an asynchronous transformation and ends at a destination or first asynchronous transformation in the hierarchy. Each tree has a set of allocated buffer and scope of these buffers is associated to this tree. Also in addition to this every tree is allocated an OS thread (worker-thread) and unlike buffers other execution tree may share this thread. Synchronous transformation gets a record, processes it and passes it to the other transformation or destination in the sequence. The processing of a record does not dependent on the other incoming rows. Since synchronous transformations output the same number of rows as the input, it does not require new buffers to be created and hence is faster in processing. For e.g., in the Derived column transformation, a new column gets added in each incoming row, without adding any additional records to the output. In case of asynchronous transformation, different number of rows can be created than the input requiring new buffers to be created. Since an output is dependent on one or more records it is called blocking transformation. It might be partial or full blocking. For e.g., the Sort Transformation is a fully blocking transformation as it requires all the incoming rows to arrive before processing. Since the asynchronous transformation requires additional buffers it performs slower than synchronous transformations. Hence asynchronous transformations must be avoided wherever possible. For e.g. instead of using Sort Transformation to get sorted results, use ORDER BY clause in the source itself. Implement Parallel Execution in SSIS Parallel execution in allowed by SQL Server Integration Services (SSIS) in two different ways by controlling two properties mentioned below: MaxConcurrentExecutables this property defines how many tasks (executable) can run simultaneously. This property defaults to -1, which is translated to the number of processors plus 2. In case, hyper-threading is turned on in your box, it is the logical processor rather than the physically present processor that is counted.  For e.g. we have a package with 3 Data Flow tasks where every task has 10 flows in the form of OLE DB Source -> SQL Server Destination. To execute all 3 Data Flow Tasks simultaneously, set the value of MaxConcurrentExecutables to 3. The second property named EngineThreads controls whether all 10 flows in each individual Data Flow Task get started concurrently. EngineThreads this property defines how many work threads the schedule will create and run in parallel. The default value for this property is 5. In the above example, if we set the EngineThreads to 10 on all 3 Data Flow Tasks, then all the 30 flows will start at the same time. One thing we want to be clear about EngineThreads is that it governs both source threads (for source components) and work threads (for transformation and destination components). Source and work threads are both engine threads created by the Data Flows scheduler. Looking back at the above example, setting a value of 10 for Engine Threads means up to 10 source and 10 work threads each. In SSIS, we dont affinitize the threads that we create to any of the processors. If the number of threads surpasses the number of available processors, it might hurt the throughput due to an excessive amount of context switches. Package restart without losing pipeline data SSIS has a cool feature called Checkpoint. This feature allows your package to start from the last point of failure on next execution. You can save a lot of time by enabling this feature to start the package execution from the task that failed in the last execution. To enable this feature for your package set values for three properties CheckpointFileName, CheckpointUsage and SaveCheckpoints. Apart from this you should also set FailPackageOnFailure property to TRUE for all tasks that you want to be considered in restarting. By doing this, on failure of that task, the package fails and the information is captured in the checkpoint file and on subsequent execution, the execution starts from that tasks. It is very important to note that you can enable a task to participate in checkpoint including data flow task but it does not apply inside the data flow task. Lets consider a scenario, where you have a data flow task for which you have set FailPackageOnFailure property to TRUE to participate in checkpoint. Lets assume that inside the data flow task there are five transformations in sequence and the execution fails at 5th transformation (assumption is that earlier 4 transformations complete successfully). On the following execution instance, the execution will start from the data flow task and the first 4 transformations will run again before coming to 5th one. It is worth noting below points. For loop and for each loop do not honor Checkpoint. Checkpoint is enabled at only control flow level and not at data level, so regardless of checkpoint the package will execute the control flow/data flow from the start in a case of restart. If package fails, checkpoint file, all server configurations and variables values are stored and also point of failure. So if package restarted, it takes all configuration values from checkpoint file. During failure you cannot change the configuration values. Best practices for logging Integration Services includes logging features that write log entries when run-time events occur and can also write custom messages. Logging, to help you in auditing and troubleshooting a package every time it is run, can capture run-time information about a package. For e.g., name of the operator who ran the package and the time the package began and finished can be captured in the log. Logging (or tracing the execution) is a great way of diagnosing the problem occurring during runtime. This is especially very useful when your code does not work as expected. Not only that, SSIS allows you to choose different events of a package and components of the packages to log as well as the location where the log information is to be written (text files, SQL Server, SQL Server Profiler, Windows Events, or XML files). The logging saves you from several hours of frustration that you might get while finding out the causes of problem if you are not using logging, but the story doesnt end here. Its true, it helps you in identifying the problem and its root cause, but at the same time its an overhead for SSIS that ultimately affects the performance as well, especially if you are excessively using logging. So the recommendation here is to use logging in a case of error (OnError event of package and containers) . Enable logging on other containers only if required, you can dynamically set the value of the LoggingMode property (of a package and its executables) to enable or disable logging without modifying the package. You can create your own custom logging which can be used for troubleshooting, package monitoring, ETL operations performance dashboard creation etc. However the best approach is to use the built-in SSIS logging where appropriate and augment it with your own custom logging. A normal custom logging can provide all the information you need as per requirement. Security audit and data audit is out of scope of this document. To help you understand which bulk load operations will be minimally logged and which will not, the following table lists the possible combinations. Table Indexes Rows in table Hints Without TF 610 With TF 610 Concurrent possible Heap Any TABLOCK Minimal Minimal Yes Heap Any None Full Full Yes Heap + Index Any TABLOCK Full Depends (3) No Cluster Empty TABLOCK, ORDER (1) Minimal Minimal No Cluster Empty None Full Minimal Yes (2) Cluster Any None Full Minimal Yes (2) Cluster Any TABLOCK Full Minimal No Cluster + Index Any None Full Depends (3) Yes (2) Cluster + Index Any TABLOCK Full Depends (3) No (1) It is not necessary to specify the ORDER hint, if you are using the INSERT à ¢Ã¢â€š ¬Ã‚ ¦ SELECT method, but the rows need to be in the same order as the clustered index. While using BULK INSERT it is necessary to use the ORDER hint. (2) Concurrent loads are only possible under certain conditions. Only rows those are written to newly allocated pages are minimally logged. (3) Based on the plan chosen by the optimizer, the non-clustered index on the table may either be fully- or minimally logged. Best practices for error handling There are two methods of extending the logging capability, Build a custom log provider Use event handlers We can extent SSISs event handler for error logging. We can capture error on OnError event of package and let package handle it gracefully. We can capture actual error using script task and log it in text file or in a SQL server tables. You can capture error details using system variables System::ErrorCode, System::ErrorDescription, System::SourceDescription etc. If you are using custom logging, log the error in same table. In some cases you may wish to ignore it or handle the error at container level or in some cases at task level. Event handlers can be attached to any container in the package and that event handler will catch all events raised by that container and any child containers of that container. Hence, by attaching an event handler to the package (which is parent container) we can catch all events raised of that event type by every container in the package. This is powerful because it saves us from building event handlers for each task in the package. A container has an option to opt out of having its events captured by an event handler. Lets say, you had a sequence container for which you didnt find it important to capture events, you can then simply switch them off using the sequence containers DisableEventHandlers property. If are looking to capture only certain events of that sequence task by an event handler, you could control this using the System::Propogate variable. We recommend you to use se