avatar𝐂𝐡𝐫𝐢𝐬𝐭𝐨𝐩𝐡𝐞𝐫 𝐀𝐤𝐢𝐧𝐥𝐚𝐝𝐞

Free AI web copilot to create summaries, insights and extended knowledge, download it at here

3413

Abstract

zations-for-columnstore-compression">here</a>.</p><p id="fc40">An example of over-configured workload management is when resources are reserved for a workload group even when there are no active requests in it. When setting up a workload group, you can define the minimum % of resources that are always reserved for the group. This is very useful in cases when you have to ensure that SLAs are met, but it should always be done with caution. If such strict isolation of resources is not required, it’s better to use a shared resource pool in combination with different workload importances.</p><h2 id="3041">3. Using clustered columnstore index for staging</h2><p id="23d4">By default, dedicated SQL pool will set up tables using clustered columnstore indexes. These are highly compressed, column-based data structures optimized for analytical workloads on large tables, but they can be expensive to build.</p><p id="5dbe">When loading data into a clustered columnstore index, the rows are first split into row groups (batches) which then are separated into column segments before each of these segments get compressed.</p><figure id="c79e"><img src="https://cdn-images-1.readmedium.com/v2/resize:fit:800/1*NUSN2jBohgHVlSGhjbgToA.png"><figcaption><a href="https://learn.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-data-loading-guidance?view=sql-server-ver16">Source</a></figcaption></figure><p id="0b0b">Because building a clustered columnstore index is a resource intensive process, using them for temporary staging tables creates an unnecessary overhead without providing any benefits. When comparing the throughput of bulk loading processes for clustered columnstore indexes and heap tables, a 2–3x difference can be observed (<a href="https://techcommunity.microsoft.com/t5/sql-server-blog/data-loading-performance-considerations-with-clustered/ba-p/305223">link</a>).</p><p id="1bcf">While avoiding the aforementioned 3 mistakes when working with a Synapse dedicated SQL pool can help you save cost by utilizing your resources more efficiently, finding the right combination of tools for your business needs can be challenging. We at Starschema can help you identify the technologies that will best serve your use cases and fine-tune them for optimal performance. <a href="https://starschema.com/contact">Reach out</a> — we’d love to talk.</p><p id="ed30">To learn how Synapse fares against Databricks, Snowflake, Redshift and BigQuery fare and scale in terms of query performance, cost per performance and differentiating feature value, see the results of our extensive testing in this white paper:</p><div id="2298" class="link-block"> <a href="https://starschema.com/kb/cloud-data-warehouse-benchmark-2023"> <div> <div> <h2>Cloud Data Warehouse Benchmark 2023</h2> <div><h3>As cloud data warehouse providers race to improve the scalability, performance and cost-effectiveness of their…</h3></div> <div><p>starschema.com</p></div> </div> <div> <div style="background-image: url(https://miro.readmedium.com/v2/resize:fit:320/0*QBnOLQvJ3CUAhQ_C)"></div> </div> </div> </a> </div><p id="28bd"><b>About the author</b></p><p id="a1e9"><i>Marton is a highly skilled data professional with experience in commerci

Options

al aviation and electronics manufacturing. He holds a Master’s degree in data science from Tilburg University and previously worked as a data scientist with the top management of a major European airline, where his transformational work helped save millions of euros for the company. In his current work as a data engineer at Starschema, he helps Fortune 500 companies build data platforms to unlock greater value from their data. Connect with Marton on <a href="http://www.linkedin.com/in/martonmesz">LinkedIn</a>.</i></p><p id="272c"><b>REACH OUT TO STARSCHEMA <a href="https://starschema.com/contact">HERE</a>:</b></p><div id="2f2e" class="link-block"> <a href="https://starschema.com/contact"> <div> <div> <h2>Let’s talk | Starschema</h2> <div><h3>We help your organization become data-driven</h3></div> <div><p>starschema.com</p></div> </div> <div> <div style="background-image: url(https://miro.readmedium.com/v2/resize:fit:320/0*JnBf22UiwDSON2-d)"></div> </div> </div> </a> </div><p id="742c"><b>READ MORE STORIES FROM STARSCHEMA:</b></p><div id="4934" class="link-block"> <a href="https://readmedium.com/find-the-balance-between-cloud-cost-and-efficiency-889958c39908"> <div> <div> <h2>Find the Balance between Cloud Cost and Efficiency</h2> <div><h3>Learn how to measure the ROI of a cloud migration and get clarity on the opportunities and challenges inherent in…</h3></div> <div><p>medium.com</p></div> </div> <div> <div style="background-image: url(https://miro.readmedium.com/v2/resize:fit:320/0*3onHo1F--Lp3oe9M)"></div> </div> </div> </a> </div><div id="a8c0" class="link-block"> <a href="https://readmedium.com/data-fabric-vs-data-mesh-find-the-right-fit-for-your-organization-40b37f4efba"> <div> <div> <h2>Data Fabric vs Data Mesh: Find the Right Fit for Your Organization</h2> <div><h3>Learn the differences between data mesh and data fabric architectures and find the right one for your data governance…</h3></div> <div><p>medium.com</p></div> </div> <div> <div style="background-image: url(https://miro.readmedium.com/v2/resize:fit:320/0*uR7nzrNVrfSbaH6x)"></div> </div> </div> </a> </div><div id="5263" class="link-block"> <a href="https://readmedium.com/from-guesswork-to-genius-how-to-get-maximum-value-from-marketing-data-and-automation-b7600346dee7"> <div> <div> <h2>From Guesswork to Genius: How to Get Maximum Value from Marketing Data and Automation</h2> <div><h3>See how one company used marketing data to learn more about their audience and run more effective campaigns — and how…</h3></div> <div><p>medium.com</p></div> </div> <div> <div style="background-image: url(https://miro.readmedium.com/v2/resize:fit:320/1*nJFWer2IZmGd2KJAGBR-3g.jpeg)"></div> </div> </div> </a> </div></article></body>

Project Management Lessons from the Manhattan Project

Lessons on taking risks and being decisive in the face uncertainties and limited information.

Photo by Gene Devine on Unsplash

Dear Reader,

Kindly stay for AT LEAST 30 SECONDS. Don’t kill the writers’ reader ratio.

Non-Medium subscribers, read this story here — FREE.

My curiosity about the Manhattan Project started in my college days. I had my first introduction lectures on Physics over 35 years ago. Now, as an engineer, I’m always keen on the history of science, technology and applied engineering. I read this book in December 2015 while travelling to Abuja for my PMI® Project Management Professional certification examination.

The duo of the late General Leslie Groves (1922–1970) and Robert J. Oppenheimer (1904–1967) were the midwives of the first atomic bomb and the nuclear age. My interest was on how the scientific, technical and project management challenges were confronted and overcame. For project managers and business leaders, the lessons from how this feat was pulled off are still as relevant today as when the book was first written.

General Leslie Groves as one of the main actors of those times penned a book that is unbeatably interesting and highly educating. As a project manager, I found the story riveting from the first to the last page

Unparalleled leadership and management efforts were needed to guide this monumental project to success — in terms of its aims. Many of the theoretical concepts needed for this task were as at then still nascent and unproved. Moving from concepts to practical reality took a relatively short time.

This is not a belated celebration of the unquantifiable material and physical damages and the wasting away of millions of invaluable lives resulting from World War II (or any war for that matter). But this feat was and still is a testament to American ingenuity that a bomb that was decisively important towards winning and ending the war was not yet completely assembled or tested just about three weeks before it was first deployed in the war-front. And yet, it worked at first try.

As stated by the author, the first gun-type atomic bomb was dropped in combat without a prior test to ascertain if it will work, “Nevertheless, the indications for success were strong enough so that no one urged us to change our plans of dropping the first gun-type bomb in combat without prior test.”

From the book, it is clearly evident that, it was World War II that made the development of atomic bomb and atomic energy possible. It would have been very difficult for any nation (America included) to contemplate and commit to such a costly project (about $23 billion in 2019) in the time of peace. Realizing that feat in peace time in a relatively short time would have been more daunting.

In spite of present day challenges, I agree with the author that the world is a better place today and is still what it is because America was the first nation to create the atomic bomb and also developed and master nuclear energy. One can only imagine what would have happened if such powers has fallen first, into the hands of Adolf Hitler and Nazi Germany, or to Josef Stalin in the hey days of the Soviet Empire.

The bombing of the World Trade Centre in New York on September 11, 2001, the Paris massacres of November 2015, the bombings in Brussels of March, 2016 and many others were unimaginably evil. Heinous as they were, these atrocities would have paled to mere children-plays in comparison to what these terrorists and their at times state backed sponsors would have done if they ever get access to these weapons of calamitous destruction first before any other nation.

Why do I think this book still matters today? The reasons as adduced by the author are as practical now as when the book was first written over 60 years ago. These same reasons if followed through will greatly increase the odds for success for every person, individuals or organizations involved in projects.

Here are the key takeaways.

  1. At the bedrock of any successful project is a clearly defined, unmistakable specific objective. As a project leader, manager or frontline worker, you must tailor your actions towards the accomplishment of your project.
  2. Every part of your project must have a specific task carefully allocated and supervised. This will result in unprecedented unmatched operational efficiencies for you and the entire organization.
  3. As the leader, you should provide positive, clear cut, unquestioned leadership and direction at all project levels. Any ambiguity of focus will fritter away your much needed resources.
  4. Project managers should make maximum use of already existing agencies, facilities and services — governmental, industrial and academic. With a finite and well defined objective, project organizational resources can and must not be designed to operate in perpetuity.
  5. Full backing of the organizational leadership is a must for the success of your project. The Manhattan project enjoyed the full backing of the American government. Combining this with the nearly infinite potential of American science, engineering and industry coupled with the almost unlimited supply of people endowed with ingenuity and determination was what made this feat possible..

Notable Quotes

  • …nothing would be more fatal to success than to try to arrive at a perfect plan before taking any important step.
  • “I suggested that the time was fast approaching when we should begin to make plans for the bombing operation itself, even though we still had no assurance that the bomb would be effective.”
  • “…a nuclear war could never be fought on this earth without bringing disaster to all mankind.”
  • “… if we played it safe, we could never hope to win; chances had to be taken.”
  • “When man is willing to make the effort, he is capable of accomplishing virtually anything.”

Published here with modifications from my post.

SOURCE Copyright 1962 by ©General Leslie Groves, Now It Can Be Told — The Story of The Manhattan Project, Da Capo Press, Inc.

Leadership
Project Management
Decision Making
Risk Management
Book Review
Recommended from ReadMedium