Podcasts about bill not

In this episode, hosts Lois Houston and Nikita Abraham speak with Senior Principal Database & MySQL Instructor Bill Millar about the enhanced performance of Hybrid Columnar Compression, the different compression levels, and how to achieve the best compression for your tables. Then, they delve into Fast Ingest, what's new in Oracle Database 23ai, and the benefits of these improvements.   Oracle MyLearn: https://mylearn.oracle.com/ou/course/oracle-database-23ai-new-features-for-administrators/137192/207062   Oracle University Learning Community: https://education.oracle.com/ou-community   LinkedIn: https://www.linkedin.com/showcase/oracle-university/   X: https://twitter.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, and the OU Studio Team for helping us create this episode.   --------------------------------------------------------   Episode Transcript:   00:00 Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we'll bring you foundational training on the most popular Oracle technologies. Let's get started! 00:26 Lois: Hello and welcome to the Oracle University Podcast. I'm Lois Houston, Director of Innovation Programs with Oracle University, and with me is Nikita Abraham, Principal Technical Editor. Nikita: Hi everyone! In our last episode, we spoke about the 23ai improvements in time and data handling and data storage with Senior Principal Instructor Serge Moiseev. Today, we're going to discuss the enhancements that have been made to the performance of Hybrid Columnar Compression. We'll look at how Hybrid Columnar Compression was prior to 23ai, learn about the changes that have been made, talk about how to use this compression in 23ai, and look at some performance factors. After that, we'll move on to Fast Ingest, the improvements in 23ai, and how it is managed. 01:15 Lois: Yeah, this is a packed episode and to take us through all this, we have Bill Millar back on the podcast. Bill is a Senior Principal Database & MySQL Instructor with Oracle University. Hi Bill! Thanks for joining us. So, let's start with how Hybrid Columnar Compression was prior to 23ai. What can you tell us about it? Bill: We support all kinds of platforms from the Database Enterprise Edition on up to the high engineered systems for that and even the Exadata Cloud at the Customer. We have four different levels of compression. One is considered the warehouse compression where we do a COLUMN STORE COMPRESS FOR QUERY LOW and COLUMN STORE COMPRESS FOR QUERY HIGH. The COLUMN STORE COMPRESS FOR QUERY HIGH is the default, unless another compression level is specified. With the archive compression, we have the COLUMN STORE COMPRESSED FOR ARCHIVE LOW and also COLUMN STORE COMPRESS FOR ARCHIVE HIGH. With the Hybrid Columnar Compression warehouse and archive, the array inserts are compressed immediately. But, however, some conditions have to be met. It has to be a locally-- to use these, it has to be a locally managed tablespace, the automatic segment space management. And compatibility level, at least 12 too or higher when these values have been introduced. There are different compressors that are used for the compression hidden from the customer. It just depends on what is selected as to what is going to be the compression that's going to be used for--  notice that with the COLUMN STORE FOR QUERY HIGH and for ARCHIVE LOW, the zlib compression method is used, whereas if you select the ARCHIVE HIGH, the Bzip2. And in 19C, we added the Zstandard. And it's available for the MEMORY COMPRESS FOR CAPACITY HIGH.  03:30 Nikita: So, what's happened in 23ai? Bill: When in 23c, to take advantage of the changes in compression, the compatibility level has to be set at least to 23.0.0 or higher. When a table is created or altered with the hybrid column compression, the Zstandard will automatically be selected. So it doesn't matter which one of the four you select, that will be the one that is selected. It is internally set transparent to the user. There is no new SQL format that has to be used in order for the Zstandard compression to be applied. And the Database Compatibility Mode has to be at least at 23.0.0 or higher. Only then can the format of the Hybrid Column Compression storage use that Zstandard compression. If we already have compressed data blocks in existing tables, they're going to remain in their original format.  04:31 Lois: And are the objects regenerated? Bill: If the objects are-- they might be regenerated if they were deleted in another operation. If you want to completely take advantage of the new compression, all you have to do is alter table move. And that's going to go ahead and trigger the recompression of that, whereas any newly created tables that are created will use the Zstandard by default. 05:00 Nikita: What are the performance factors we need to think about, Bill? Bill: There are some performance factors that we do need to consider, the ratio, the amount of space reduction in storage that we're going to achieve, the time spent compressing the data, the CPU cost to compress that data, and also, is there any decompression rate, time spent decompressing the data when we're doing queries on it? 05:24 Lois: And not all tables are equal, are they? Bill: Not all tables are equal. Some might get better performance by different compression level than others for that. So how we can basically have to test our results, there is a compression advisor that's available, that you can use to give you a recommendation on what compression to use. But only through testing can we really see the availability, the benefits of using that compression for an application. So best compression, just as in previous versions, the higher the compression levels, the more CPU it's going to use. The higher the compression level, the more space savings that we're going to achieve for that as we are doing those direct path inserts. So there's always that cost. 06:20 Did you know that the Oracle University Learning Community regularly holds live events hosted by Oracle expert instructors. Find out how to prepare for your certification exams. Learn about the latest technology advances and features. Ask questions in real time and learn from an Oracle subject matter expert. From Ask Me Anything about certification to Ask the Instructor coaching sessions, you'll be able to achieve your learning goals for 2024 in no time. Join a live event today and witness firsthand the transformative power of the Oracle University Learning Community. Visit mylearn.oracle.com to get started.  07:01 Nikita: Welcome back! Let's now move on to the enhancements that have been made to fast ingest. We'll begin with an overview of fast ingest, how to use it, and the improvements and benefits. And then we'll look at some features for managing fast ingest. Bill, why don't you start by defining fast ingest for us?  Bill: Traditionally the fast ingest, also referred to as deferred inserts, is faster than processing a single row at a time. It can support high-volume transactions like from the Internet of Things applications, where you have hundreds of thousands of items coming in trying to write to the database. They are faster, because the inserts don't use the traditional buffer cache. They use a pool that will size out of the large pool. And then they're later written to disk using the SMCO, the space management coordinator. Instead of using the buffer cache, they're going to write into an area of the large pool. The space management coordinator, it has these helper threads, however many-- that's just a number for that-- that will buffer. And as buffer is filled based off size of that algorithm, it will then write those deferred inserts into the database itself. 08:24 Lois: So, do deferred inserts support constraints? Bill: Deferred writes do support constraints in index just as for regular inserts. However, performance benchmarks that have been done recommend that you disable constraints, if you're going to use the fast ingest. 08:41 Lois: Can you tell us a bit about the streaming and ingest mechanism?  Bill: We declare a table with the memoptimize for write. We can do that in the create table statement, or we can alter the table for that. The data is written to the large pool, unlike traditionally writing items to the buffer cache. It's going to write to the ingest buffer, the large pool. And it's going to be drained. It's going to be written from that area by using those background processes to write to the actual database itself. So the very high throughput, since drainers issues deferred writes in large batches. So we're not having to wait especially for the buffer cache. OK, I need space. OK, I need to write. I need to free up blocks. Very ideal for these streaming inserts, sensor readings, alarms, door locks. Those type of things. 09:33 Nikita: How does performance improve with this? Bill: With the benchmarks we have done, we have found that the performance can be up to 75% faster by going ahead and doing the fast ingest versus traditional inserts. The 23 million inserts per second on a single X6-2 server with the benchmarks that we have. 09:58 Nikita: Are there any considerations to keep in mind? Bill: With the fast ingest, some things to consider for that. The written data, you might need to validate to make sure it's there. So you might have input files that are writing to that that are loading it. You might want to hang on to those, before that data destroyed. Have some kind of mechanism to validate, yes, it was written. There is a possible loss of data. Why? Because unlike the buffer cache that has the recovery mechanism with the redo and the undo, there is none with that large pool. So that's why if the system crashes, and the buffers haven't been flushed yet, then it's possible loss of data. There's no queries from the large pool meaning that if I want to query the information that the fast ingest is loading into the table, it doesn't go and see what's sitting in the buffer in the large pool like it does with the buffer cache. Index and constraints are checked but only at flush time. And the memoptimize pool size is a fixed amount of space that we're going to allocate-- of memory that we're going to allocate to use for the memoptimize write. We can enable a table for the fast ingest, enable with the memoptimize for write. We can create a table and do it. We can also alter a table. We already have a table existing. All we have to do is alter it. And we want to use that, the fast ingest, for these tables. 11:21 Lois: Do we have options for the writing operation, Bill? Bill: You do have options for the writing operation. We have the parameters, the memoptimize write where we can turn that on. We can also use it in a hint. It is set at the root level, it. Is not modifiable at the PDB level. It's set at the root level, It is a static parameter. We can also do things in our session. We want to verify, OK, is the memoptimize write on? We can verify a table is enabled. So with the fast ingest, the data inserts, you can also use a hint. You can also set this at a session level.  If you decide there's something that you don't want to use the memoptimize write for, then you can disable it for a table.  12:11 Nikita: Bill, what are some of the benefits of the enhancements made in 23ai? Bill: With some of the enhancements-- so now, some table attributes are now supported-- we can now have common default values for a column. We can use transparent data encryption. We can also use the fast inserts, any inline LOBs, along with virtual columns. We've also added partitioning support. We can do subpartitioning and we can also do interval partitioning, along with auto list. So we've added some items that previously prevented us from doing the fast inserts. It does provide additional flexibility, especially with the enhancements and the restrictions that we have removed. It allows to use that fast insert, especially in a data warehouse-type environment. It can also use-- in the Cloud, it can use encrypted tablespaces, because remember, in the Cloud, we always encrypt, by default, users' data. So now, it also gives us the ability to use it in that Cloud environment because of that change. We have faster background flushing for the loads.  13:36 Lois: And how is it faster now?  Bill: Because we bypassed the traditional buffer cache. Faster ingest for those direct ingest. So again, bypassing the traditional inserts and using the buffer cache gives the ability to bulk load into large pool, then flush to the database so that way, we have access to that data for possible faster analytics of those internet of things, especially when it comes to the temperature of the temperature sensors. We need to know when a temperature of something is out of bounds very quickly. Or maybe it's sensors for security. We need to know when there's a problem with the security. 14:20 Nikita: How difficult is it to manage this? Bill: Management is fairly simple. We have the MEMOPTIMIZE_WRITE_AREA_SIZE parameter that we're going to say-- it is dynamic. It does not require a restart. However, all instances in a RAC environment must have the same value. So we have the write area. What are we going to set? And then the MEMOPTIMIZE_WRITE, by default, it uses a hint. Or we can go ahead and we can just set that to all. It is allocated from the large pool. You manually set it. And we can see how much is actually being allocated to the pool. We can go out and look at our alert log for that information.  There's also a view. The MEMOPTIMIZE_WRITE_AREA has some columns. What is the total memory allocated for the large pool? How much is currently used by the fast ingest? How much free space? As you're using it, you might want to go out and do a little checking, or do you have enough space? Are you not allocating enough space? Or have you allocated too much?  It'll also show the total number of writes, and also, the number-- the writers is currently the users that are using it.  And the container ID, what is the container within that container database? What's the pluggable or pluggables that's using the fast ingest? There is a subprogram, the DBMS_MEMOPTIMIZE that we have access to that we possibly can use. So there are some procedures. Here, we can return the rows of the low and high water mark of the sequence numbers. And the key here is across all the sessions. We can see the high water mark, sequence number of the rows written to the large pool for the current session. And we can also flush all the ingest data from the large pool to disk for the current session. 16:26 Lois: What if I want to flush them all for all sessions?  Bill: Well, that's where we have the WRITE_FLUSH procedure. So it's going to flush the fast ingest data of the Memoptimize Rowstore from the large pool for all the sessions. As a DBA, that's one that you most likely will want to be using, especially if it's going to be before I do a shutdown or something along that line. 16:49 Nikita: Ok! On that note, I think we can end this episode. Thank you so much for taking us through all that, Bill. Lois: Yes, thanks Bill. If you want to learn more about what we discussed today, visit mylearn.oracle.com and search for Oracle Database 23ai New Features for Administrators. Join us next week for a discussion on some more Oracle Database 23ai new features. Until then, this is Lois Houston… Nikita: And Nikita Abraham signing off! 17:21 That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

Welcome to the start of the shortly awaited season 3!! In this episode Bill (Not a Watch Snob) and myself (Dean - One to Watch) discuss: what we've been up to this summer, The Orville and Star Trek. And watch stuff too: new watches we have, the MoonSwatch situation - unavailable to buy online, but you can stop one of their cars and buy one!! Also there are fake MoonSwatches around! The Bulova Lunar Pilot - a MoonSwatch alternative! Sit back and enjoy the chat, with lots of good clean humour!! Dean's YouTube channel: https://www.youtube.com/channel/UCRJ6vhj1ak9Qk9p_Kq86Gyg Bill's YouTube channel: https://www.youtube.com/channel/UCWeOnYCMVKYJnLMGeF609mw

Episode Notes:Today's guest is Joanna Chiu, a long-time journalist covering China from both inside and outside the country, co-founder and chair of the editorial collective 'NüVoices 女性之音', and the author of the new book "China Unbound." She now covers Canada-China issues for the Toronto Star. Joanna, welcome to the podcast.4:20 on Huawei, Meng Wanzhou and the two Michaels - when the whole Huawei, Meng Wanzhou saga was unfolding, I got so many questions from not just Canadian journalists, but media around the world about what was going on. I think it's surprising to us because we've been in the China-watching bubble, but more broadly, what happened was very shocking for a lot of people all over the world23:20 people like me and my family aren't fully accepted as Canadians or as Australians or as Americans, it's always like a hyphen, like Chinese-Canadian, Chinese-American. That just plays into what Beijing wants. When people of Chinese descent are taken as political prisoners or get calls from Chinese police saying, "Stop supporting Hong Kong on social media or stop doing this," these people get less attention. They're not taken seriously when they try to report what's happening because unfortunately a lot of people in the West have accepted the CCP's myth that we're still essentially Chinese36:20 on Canada-China relations - in Canada, the mood after the Michaels returned and the Meng case was resolved is that they really want to go back to business as usual. To not have any kind of plan in place on how to prevent Canadian hostages from being taken in the future. The Prime Ministers office really steering this even though other parts of government was like, "We need some sort of plan, we need some sort of update to foreign policy in general." There's very little political will.Links: China Unbound on Amazon. Joanna Chiu’s websiteNüVoices 女性之音Transcript:Bill:Hi everyone, today's guest is Joanna Chiu, a long-time journalist covering China from both inside and outside the country, co-founder and chair of the editorial collective 'NüVoices', and the author of the new book "China Unbound." She now covers Canada-China issues for the Toronto Star. Joanna, welcome to the podcast.Joanna:Thank you Bill, thanks for having me on your new podcast, very exciting.Bill:Thanks, yeah you are the second guest, and so I'm really happy to have this opportunity to speak with you. Before we dig into your book, could you tell us a little bit about yourself and how you ended up where you are and doing what you do?Joanna:Okay. I guess my bio is that my family is one of the many who left Hong Kong after the 1989 Tiananmen Square protests because my parents were worried about what would happen going forward. So growing up in Canada, I felt that China was actually part of my whole family story because what happened led to my family uprooting themselves. So I was always really interested in China and studied Chinese history and wanted to return to be a reporter to chronicle what was happening in the country, which I was so fascinated by.Joanna:So I started reporting on the ground in Hong Kong in 2012, covering all the things that happened there including the Occupy to pro-democracy movement in Hong Kong. I moved to Beijing in 2014 and that's where I started covering basically everything in the whole country for European media outlets, including German, Deutsche Presse-Agentur, and AFP (Agence France-Presse). And I guess my career was a bit unique in that I also free-lanced for several stints. So I got to kind of get a sense of what many different jurisdictions and countries wanted to know about China in my time there writing for all sorts of outlets.Bill:Interesting and so I was there until 2015 and I think we overlapped for just about a year. When did you actually leave China to go back to Canada?Joanna:Yeah, I left China in late 2018. I wanted to stay for longer because even seven years on the ground I felt I barely got to scratch the surface of all the things that I could write about in China. Especially because I had such a broad remit where I was a front-line reporter for all of these major events but also could do basically any feature story I wanted. So it was just totally open and I could have stayed there for decades, but I had to go back to Canada. I got asthma from the smog and I think my Canadian lungs just couldn't handle air. I was just like really allergic to Beijing as soon as I landed and I stuck it out for four years. But back in Canada, I felt I would have to move on from my passion and interest in China, but a couple of months after I returned, Meng Wanzhou, a Huawei executive was detained in the Vancouver International Airport. And just over a week later, two Michaels were detained. So definitely I think that was the biggest China story at the time, and it continued to be very impactful around the world.Joanna:So I started covering that and it just led to basically being a reporter for the Toronto Star, focusing on China. And that's what I've been doing since then. I have also been working on my book since early 2019. So not my plan, but definitely the past decade has been very China focused, including my last few years.Bill:It's great, I've always been a fan of your work, and I will say, it's very interesting how many foreign correspondents used to live in China have left the country. Some willingly, some not willingly, but how it turns out how most of them have found jobs covering how China's impacting the world wherever they're now based.Joanna:Mm-hmm (affirmative).Bill:I think that's a good segue into talking about your book because it really is true that the China story is everywhere now. And that's something, I think, you try and capture in "China Unbound." So tell us who you wrote it for, why you wrote it, and what do you hope that the readers take away from it?Joanna:Mm-hmm (affirmative). So when the whole Huawei, Meng Wanzhou saga was unfolding, I got so many questions from not just Canadian journalists, but media around the world about what was going on. I think it's surprising to us because we've been in the China-watching bubble, but more broadly, what happened was very shocking for a lot of people all over the world. They didn't know the context of Beijing's political system and its increasing ... how its authoritarianism translates also into its foreign policy and its stances towards different countries and diaspora groups all over the world. But these things were not just stories I covered, but stories that were close to my life. Because growing up, my father worked for a Chinese-Canadian radio station and people were talking already then about pressure to self-censor, pressure from the Chinese embassy on Canadian media outlets. This was happening in the 90s and people of Chinese descent around the world were trying to have discussions about this, but basically not really getting much traction or broader public attention.Joanna:It did seem ... I will ask you if this is what you felt, but it took two white men from Canada being taken hostage over this high-profile executive's arrest in Canada for a lot of people in the world to be like, "Wait, what's going on? How will Beijing's political system and authoritarianism possibly impact me and my family or my country or my business?" So I wrote this book for basically everyone, targeting the general reader because I really try to be as immediate as possible in my writing. Most of the reporting is eyewitness reporting from myself in collaboration with journalists around the world and looking at how we got to this point. Western countries and China, how we got to this point where it seems like a lot of obstacles that seem insurmountable. All of these tensions, all of these worries.Joanna:I wanted for people to start with this book and then I provided this long reading list at the end so they can continue to be engaging with these issues. Because I feel that we might not have really noticed, but a lot of the narratives around China in the mainstream public have been very very simplified. And that is a disservice to all countries. And especially to the people who end up being targets and whose lives end up being affected by some of these big conflicts going on.Bill:What you said earlier about it really taking two white men, Michael Spavor and Michael Kovrig to get people's attention. It's interesting because these pressures have existed, as you said talking about your father and his experience, but these pressures on the diaspora have existed for decades. They've certainly intensified, and you have multiple instances of ethnic Chinese who are jailed in China, American, Australian, where it didn't seem to kind of capture the national attention the way that the detention of the two Michaels did. And that's unfortunate, but it does feel like the conversation and awareness now has shifted and so there's a lot more awareness that these kind of pressures are existing across all sorts of communities. You can tell me I'm wrong, but the Chinese government has also shifted its approach, hasn't it? Sort of widened its net in terms of how they pressure?Joanna:Yeah, so in the past, you know the united front, a lot of that work of foreign influence in both intimidation and providing carrots and sticks. Flattering global politicians and global members of the elite among the diaspora have been going on, but the most harsh efforts of influence in the past I think were mostly directed at people of Asian descent. It was only in more recent years where the really harsh tactic, the detentions, have been applied to foreign nationals who are not of Asian descent. It seems like that is a deliberate shift in tactics, would you agree?Bill:No, I would. And I think it's interesting when you look at sort of who they've targeted, especially around the Meng Wanzhou case. Two Canadians were very quickly arrested, a third Canadian who had been convicted of dealing drugs had a re-sentence to death. There's still no word about Schellenberg's fate in the wake of the Meng Wanzhou deal. But I think that one thing that's interesting is they've yet to target Caucasian Americans. And so far, certainly what I was fearing in the Meng Wanzhou incident was that ... someone had told me that they had put together lists who they might target but they held back because part of the messaging is they're at least today not quite ready to go toe-to-toe with the U.S.. But willing to penalize countries and the citizens of the countries that are seen as effectively being U.S. allies or lackeys depending on who you're speaking with. Does that make sense?Joanna:Mm-hmm (affirmative). Yeah, that makes sense. And my book, people have said that because I'm Canadian and I spotlight countries and experiences like Australia, Italy, Greece, Turkey. So so-called middle powers, that middle-power perspective, whereas many books out of the U.S. and China have it from the U.S. perspective.Bill:Right, right.Joanna:And I think that's important context for Americans to understand because in America, it seems like a lot of it is about this almost glorious competition with China where the U.S. has to win. I have been kind of mortified that people commenting on my book have said things like, "We need to read this so that we can win and not let China win." Things like that. But if they had actually read it, they would have probably seen that that's not right. I criticize the Western nations' handling and attitudes towards China as much as I criticize Beijing's actions. So I would also point out that Australian journalists who are white were affecting. Bill Birtles and Michael Smith spent days holed up in their Australian embassies in China. Basically fleeing because they got tipped off that otherwise they might get detained. Related to Australia's more aggressive critical stance towards China as of late.Bill:And also-Joanna:It does seem-Bill:Sorry, was it also related to the detention of Australian Chinese ... Australian journalist Cheng Lei who was originally Chinese then naturalized into Australian citizenship. And she's disappeared into the system in China, right?Joanna:Yeah, so Cheng Lei ... Again, while she's not a global household name like the two Michaels, she is actually detained. Her case ... we know very little about it, but it seems very clear it's related to the political situation between the two countries. And also Bloomberg journal Haze Fan ... and I think actually Haze's case might be as close as China has gotten so far to targeting Americans because even though a Chinese national, she worked for Bloomberg. She was a prominent journalist for Bloomberg. So it's interesting because writing this book, I'm trying to provide this nuance and context for the public but under so much pressure because of global contexts. Things are so tense that it could get worse at any moment and you don't know. You're hearing from your sources about a list that they were preparing of Americans they could possibly target. The stakes are so high.Joanna:Both of us, these are people we know. I don't know if you knew Kovrig, but it's a relief that he's back.Bill:Not well, but I did know a little bit.Joanna:For the more than 1,000 days he was in detention, I was writing this book and that was always on my mind. It's so immediate and it's so urgent for more people to understand what's going on rather than I think fanning the flames or making things worse or not using the opportunities there are to engage more productively with China. But we see the dialogue on China becoming so toxic right now, where it's almost as if there's two camps. The more extreme on both sides seem to get more airtime and interest. And people want those nuggets of talking points on China that really signify this is how we fight back. Rather than the people who are trying to provide a lot more context. It's not as easy as doing this or that to resolve everything or get what you want.Bill:Well with what you said earlier about sort of "we have to win," I have yet to see a clear definition of the theory of victory and what it is. The other thing I'd say, and this will lead into my next question is, we talk about in many ways how toxic the discourse has gotten in the West. It's also incredibly toxic inside China in very worrisome ways. And in many ways, sort of state-supported and state-encouraged ways. One of the questions I want to ask you is how we ... So first question is as you talk about in the book and you've talked about in other places, this whole discussion around Chinese Communist Party influence or interference in other countries ... Whether it's through the United Front or other means or vectors ... How do we differentiate what we should actually, "we" being the countries that are targeted ... How should you differentiate what actually matters that people should be concerned with versus that's the normal thing that a foreign government would do to try and improve other countries' perceptions of that country and advance their interests in those countries.Bill:And related, as this discourse does get more toxic, how do we talk about these things without tipping into racism? In the U.S. certainly, we have a really long and nasty history of anti-Asian and specifically anti-Chinese racism. And there are a lot of reasons to be very worried about going too far where we're back in a very dark place in terms of how people of Asian and Chinese descent are treated in this country. But at the same time, there are real issues and potential threats coming from some of these PRC activities. So how do we talk about that in a way that effectively deals with the problems but also makes sure that people are safe and able to enjoy the rights that they deserve and have?Joanna:Yeah and that's why I try to provide a lot of that history concisely within each chapter of the book because we need to know what happened before to know to be a lot more careful with our language and our actions now. Because definitely it just seems like history is repeating itself during the McCarthy era. Chinese-Americans' loyalties are constantly questioned, they lost their jobs. And now former President Trump has said that he thinks basically all students are possibly Chinese spies. We've seen these prosecutions of certain Chinese national scientist professors in America that were basically pretty embarrassing.Bill:Yes.Joanna:It seemed a lot of the suspicions were unfounded and it was almost like a witch-hunt which is really difficult. When things seemed politicized and politically motivated and you put a blanket suspicion on all these people, it's exactly what happened in the past.Bill:Mm-hmm (affirmative)Joanna:And it's not just America. It was in Canada, Australia, Europe. In Canada, we had internment of Japanese Canadians during World War II. And people know that this is in the background. And even before things got more tense when a lot of the approach among Western countries towards China was that the goal was to expand trade ties and economic ties as much as possible, there was still a lot of racism. Walking down the street, I got called slurs like the c-word in downtown Vancouver multiple times.Bill:Recently?Joanna:Throughout my life living in Canada. In Vancouver, particularly, there was a long-standing stereotype of the crazy rich Asian that was ruining the city with our Maseratis and condo buying.Bill:Wasn't there a reality show that was based on rich Chinese in Vancouver, I think?Joanna:Yeah, there was that and there's a lot of scapegoating against East Asians for lots of problems with COVID-19 and all this with the two Michaels in Huawei. This just really spiked particularly in countries like Canada, U.S., Australia with the large Chinese diaspora in many places. People who weren't even Chinese, like an indigenous woman in Canada, she was punched in the face. Things like that. And its not like we can throw up our hands and be like, "People are just going to be racist, this is just going to happen." I think a lot of people in positions of influence and politicians need to take responsibility for what they've done to stoke this behavior and not condone it. So talking to certain politicians in Canada in the conservative party, they tell me that there's been a shift in strategy to talk about China as the Chinese Communist Party, the communist regime, to deliberately stir up a red scare. In the U.S. definitely, the FBI in an announcement about one of its investigations into a Chinese American scientist said the words "Chinese Communist regime" or "Chinese Communist government" five times.Bill:That was the announcement about the MIT professor, was it Chen Gang, I think?Joanna:Yeah, I think so.Bill:The prosecutor or the FBI folks up in Boston, I believe.Joanna:Right. Yeah, that was the one. And it's just not necessary. You don't need to ... My argument is that the facts about what Beijing is doing are urgent and sobering enough. You don't really need to embellish it with this language of trying to get people scared of this Communist entity. But perhaps it's more to do with domestic politics in each place. Someone explained it to me in the U.S. where pretty much everyone is critical of China. You don't get more attention by just being moderately critical, you have to be really more extreme. It's as if it's like a competition to be as hawkish as possible to get that acclaim and public support.Bill:And as you said, it's unnecessary because as you just said, the facts can speak for themselves in many areas. And it again, it goes back to how do we have rational discussion about what the problems and challenges are without tipping over into something that's really nasty and scary. It's something I struggle with, obviously in my newsletter, I have ... It's funny when you write about China, I have people who think I'm a CCP apologist and people who think I'm way too hawkish. You sort of can't win, it's such a fraught topic that it is something I struggle with. Because you certainly don't want to be in a position where you're stirring things up, but at the same time you can't just throw up your hands and say, "Well we're not going to deal with this because it's too dangerous." I mean, it's too dangerous the other way too, right? But it's really difficult, and the question I have is, do you think the powers in Beijing understand this? Is this something they try to use or leverage?Joanna:Oh yeah, I think so. I think it plays right into what Beijing wants. Because the myth it has been promoting for years is that China is the center of Chinese civilization even if your family has been away from China for generations, you're still Chinese. And since you're still Chinese, your de-facto leader is still the CCP. It's a legitimate power for all Chinese people. Because people like me and my family aren't fully accepted as Canadians or as Australians or as Americans, it's always like a hyphen, like Chinese-Canadian, Chinese-American. That just plays into what Beijing wants. When people of Chinese descent are taken as political prisoners or get calls from Chinese police saying, "Stop supporting Hong Kong on social media or stop doing this," these people get less attention. They're not taken seriously when they try to report what's happening because unfortunately a lot of people in the West have accepted the CCP's myth that we're still essentially Chinese. It's in the law, if there's dual-nationality, they don't accept the second nationality.Joanna:But even more than that, I still worry that ... it's happened to people like me. I actually gave up my Hong Kong citizenship, I'm only Canadian. But just because of my Chinese blood, I'm at greater risk of whatever repercussions. I've definitely been singled out when I was a foreign correspondent in Beijing for writing too much about human rights. And they did not say the same things about other people in my office. So by not listening to people in the diaspora and still treating them as they're still outsiders, we're with this connection to China whether we agree or not, that's really playing into it. And also when there's this racism, Chinese media, Chinese embassies, they've been really up front about condemning this and using it as a way to shore up loyalty among overseas Chinese, especially people who are more recent immigrants to get that support. There's so many of these China Friendship associations around the world. It's tough to understand their impact because it's all basically legal. They are these groups that openly support Beijing's policies all around the world. And they have, in my reporting, taken part in basically trying to make friends with politicians around the world and using those interviews, events, photographs to turn into propaganda to say, "We got support from this politician." There were groups that have offered money for people to vote for certain candidates in other countries' elections.Joanna:So it's complicated because when these groups are alienated, when they still feel that ... On a pragmatic level, it makes better sense for them to have good relations with Beijing. These groups are going to increase and proliferate and it's hard to understand what they're doing because you don't want to villainize it. In a way it's very natural for people, say, with business ties in China to try to hob-nob with Chinese embassies and try to support them. When I do report on some of these activities like the potential vote buying and interfering in elections, people use it as an excuse to say, "Oh, everyone's like that. All recent immigrants are working for the CCP." And that just puts a lot of reporters and researchers in these really tricky situations where you want to report on what's going on, but because discourse just fails to be nuanced enough, people just kind of take it as a reason to be more hostile and to not really open up their minds that there's a diversity of opinions among Chinese people and the Chinese diaspora.Bill:And it's also hard I think because so much of it happens in Mandarin or other Chinese dialects, so most people who don't speak the language have no idea what's going on.Joanna:Mm-hmm (affirmative). But it's been such a rich field of potential reporting for me, going back to Canada. It's really, really resitting. I have been able to read all of these reports. I've been able to translate these posts into English for audiences who found it really interesting. But I would argue that it's not actually that hard because there are so many Chinese speakers all over the world. It's not like it's a niche population, like a small population. In these stories where Steve Bannon and Miles Kwok's like cultish group was protesting outside a Canadian journalist's house accusing him of being a Chinese spy, when he was actually critical of Beijing. There were death threats.Bill:They did that to a bunch of people in America too. They had a whole program of targeting people.Joanna:Yeah, New Jersey.Bill:Yeah.Joanna:Yeah, so in that case. In Texas, with Pastor Bob Fu, he was one of the targets. And the FBI came in, the bomb squad, they put him and his family in a safe house. But in Canada, police monitored it, checked in once in a while. I actually sent them videos, like this looks like a death threat. And I actually ... Me and my colleagues, we translated some of this information and we posted it on YouTube to explain what was going on. But then it took three months later, this going on in Canada ... Two of these protestors just savagely beat one of the target's friends. And the police were responding to questions of why didn't you step in earlier, there were death threats? They admitted that they were slow with the investigation because they didn't have Chinese language resources. And that doesn't make sense really, in Vancouver, when there are so many people of Chinese descent. It's not hard to find someone to look at something and translate it to understand it.Joanna:In the conclusion of my book, one of the points I make is that information in Chinese language is treated like a secret code that can't be cracked. Instead, people like Newt Gingrich and other kind of just make things up. In his book, Newt Gingrich ... I don't quite remember but he just provided nonsensical translations of Chinese words and then extrapolated a whole bunch of theories about China based on that. Which is insulting to all of the people, not just of Chinese descent, but people like you who have taken the time to learn Mandarin and to understand China.Bill:There's a lot of that here in the U.S., I don't know how much it exists in other countries. But certainly the taking stuff out of context or just crappy language skills. And then, like you said, extrapolating something much bigger and darker and nefarious than in many cases it actually is, for sure.Joanna:Yeah. In the U.S. people tell me that they do have Chinese speakers, but lower down in the chain who provide reports and information. But going up the chain, the politicians and the pundits, they pick and choose information to support what they believe already. So these researchers feel like they're not even being heard because politicians are just grabbing what they want anyways. In many cases, people of Chinese descent are worried about even going to China or talking about their family in China because they're not going to get promoted to more influential positions. They're not going to get security clearance because the assumption is that if you have any sort of China ties that you might be compromised. And that's a very prejudicious trend in D.C.Bill:When I moved back to D.C. after ten years, I had no interest in working for the government, but I had a funny conversation with someone who does have security clearance. He says, "Don't even bother to apply, you'll never get a security clearance because you lived in China for too long."Joanna:That's crazy.Bill:That's fine, but there are reasons for governments to be concerned with ties to other foreign governments, but certainly for folks of Chinese descent it's much more pernicious. And it does seem like in many places the assumption is that you're potentially at risk of compromise. One of the problems is how people's families are being leveraged back in China. You see it in the way the persecutions of the Uyghurs and Tibetans. But you see it also in Han Chinese, people who are doing things that are considered controversial or anti-China outside of China. It's a very common tactic, right, to harass, hassle, otherwise make difficult for family members back in China, right?Joanna:Yeah, and that is a major ... There's no solution to that. I tried to spotlight a lot of these voices in the book. I spoke with people like Vicky Xu, the campaign against her has just been ridiculous. People made fake porn of her, thousands of accounts were basically attacking her, doxxing her.Bill:I feel like that story didn't get as much attention as maybe it should have. She was just so brutally targeted by very obviously state-backed campaigns.Joanna:Yeah. Very personal and they started with her family. She's been open about that, how her family and parents have been pressured. But she didn't stop her work, so they went further. They sent thousands of accounts and they made fake pornography about her so that when people search in Chinese, that's what comes up. And trying to completely smear her character. But that story did not get that much attention.Bill:This is because of her work at the ASPI down in Australia, right? Specifically around XinjiangJoanna:Xinjiang, yeah. I think she's one of the main researchers in Australia that focused on Xinjiang. The bigger issues looking at supply chains, looking at forced labor, and where internment camps are. Recently she found a trove of police documents about the repression. And because of her fluent Chinese and her networks, she was able to find this and provide this information. So people like her, I think, Beijing wants the most to silence and has the means and leverage to try to do so. I think she's unique in that she continues to do this work. We're not sure for how long because you have to wonder how long someone can take this.Bill:Right.Joanna:More people that I know of are either operating anonymously, they're really providing subtle advising roles to governments in a very very anonymous manner. Because they're worried about their families. Or they're writing under pseudonyms and they don't get a lot of attention because no one knows who they are. They're worried about ... not even access. I think a lot of researchers worry about being able to go back to China. At different levels, people who are worried about the safety of themselves and their family members.Bill:So just given the trajectory of China under Xi Jinping, is there any reason to think this is going to get better? Or are we sort of more close to the beginning of where this trajectory goes?Joanna:Mm-hmm (affirmative) I think we're kind of at a pivotal point. A lot of it isn't waiting for what Beijing does, but there's a responsibly on Western countries to at least be smarter about China and to have proper expertise in places of governments to try to even have some well thought out policy on these issues. In the U.S. Cabinet, very little China experience. And like we talked about, the people with experience ... They have trouble having influence. And in Canada, the mood after the Michaels returned and the Meng case was resolved is that they really want to go back to business as usual. To not have any kind of plan in place on how to prevent Canadian hostages from being taken in the future. The Prime Ministers office really steering this even though other parts of government was like, "We need some sort of plan, we need some sort of update to foreign policy in general." There's very little political will. I think the amount of criticism in different countries' media doesn't reflect the lack of political will of governments to even put the basic structures in place to understand China better. To be able to translate basic things from Chinese into English to be aware of.Bill:And in Canada, why do you thing that is? Especially given the diversity of Canada and the number of people of Chinese descent in the country. But also what just happened over the last close to three years. Why wouldn't the government have had a bit more of a shift in views of how the relationship in China should go?Joanna:Mm-hmm (affirmative) I think it's related partly to what we were talking about before where politicians are worried about stoking racism, losing support from Canadians of Chinese descent. Partly an election issue, and I think traditionally in Canada, the main government advisors on China have been people in the business world who do have a vested interest in making sure that tensions are as low as possible to facilitate smoother business interactions. But that's also not even the case where if you ... I think the idea in the West has been reformed through trade. Through interactions, economically, China will naturally liberalize, become more democratic. But in recent years, we've seen political tensions move over to economic coercion, economic retaliation. Not just from China but back and forth, with America, Australia, other countries have also did tit-for-tat trade tariffs. Different ways where the political situation can impact the economic relationships. So it's not even necessarily the case that just by focusing on business, everything will be all good. I think a lot of politicians are trying to put their head in the sands about that and not trying to understand the really complex situation unfolding. And Canadians on the whole, surveys show, pretty frustrated about the situation in action and just passiveness that they see from Ottawa.Bill:I guess the Huawei decision will be interesting, whether or not Huawei is allowed into the Canadian 5G network construction. Certainly here in D.C., there's all the factors you talked about and there's a lot of opportunity for lobbyists from various industries and companies to sort of shift Biden administration and Capitol thinking to policies that are more likely to make money dealing with China. And that certainly has an impact on the policies. So just shifting gears quickly because we're almost out of time and this has been a really great conversation. One of the things we were talking about was lifting up and getting more diversity of voices. Can you tell the listeners about NüVoices and what you helped create there? I found that to be a really wonderful and useful project that's been up for a couple years now? Or has it been three years? Time just sort of blended away with the pandemic, right?Joanna:So actually we were founded in 2017.Bill:Oh my gosh, okay.Joanna:In Beijing, so it's almost under five years. It's been like a daily kind of passion project in the community for me. We kind of wanted to create a more open and accepting China space, both in person with events and chapters around the world and also virtually. And it started in reaction with panels and book deals. The people who get platformed on China are often white male experts. No offense to yourself.Bill:People like me. No, no, I get it. I get it.Joanna:You're one of our longtime supporters and our patrons and we've spoken about how this helps to create a better world for your kids, for your daughters. Because we want to remove any excuses that people have for not even having one woman on their panel. Five years ago, people just kept saying to us and our co-founders, "We tried to find a female expert, but we couldn't find one." Or "We couldn't find a woman on this topic." Which is ridiculous because looking around, actually people we know, I see more women than men entering these fields. Definitely being a journalist in China, there's more women than men. And women who can speak Chinese and doing great work. So we created this open-source directory. Now it has more than 600 people all around the world who are women or non-binary on all sorts of topics. And speaking all sorts of languages in all sorts of time zones. I think just that project alone helped to remove those excuses. Any time someone makes an excuse that they couldn't find a woman, someone just has to send that person the link to this directory. No more excuses.Joanna:And on top of that we have a twice monthly podcast which I co-host sometimes and events all around the world. And basically social groups and networks and it's a platform so that people can benefit from this supportive atmosphere. We really try and celebrate diverse voices on China, experts on China. I find that women tend to ... because they're facing so much discrimination, women experts often have to fight harder to provide unique insights and reporting. So the kind of good quality you get just reaching out to any female expert in China, its a pretty good bet on fresh and interesting perspectives. And definitely I found that the case with my book. Because you know I tried to practice what I preach and most of my sources are coming from diverse backgrounds, women and minorities ... I shouldn't even use the word "minorities", people who aren't white basically.Bill:Mm-hmm (affirmative) right.Joanna:In each country, and I think that provides a different layer than people who enjoy positions of more power in those countries, who might not see some of the more uglier sides or the more complicated sides because that's not their experience. They're not getting the five star treatment when they go to China that a lot people in power do.Bill:It's definitely one of the things I enjoy about your book, it does have these different perspectives that are so important as we are all sort of trying to figure out what's going on and start thinking about what we can do. Specifically, NüVoices, I was looking at the directory last week. I think it's like 620 entries or something, I'm certainly planning to mine it for guests for the podcast because it's a really tremendous resource. And I will put a link to it in the show notes when we publish the podcast. Well thank you so much, is there anything else you'd like to add or say to the audience? Other than buy your book, "China Unbound", it's a great book. Please go ahead and go buy it and read it. It's a great book.Joanna:Just asking yourself, being based in the U.S., what are the best avenues for a more productive conversations on China? Instead of going to people who are more simplistic, what are some more resources you'd recommend? Including, of course your newsletter and that community. But who's doing the work to make up more well-informed approaches?Bill:That's a great question, and I'm not actually sure I have a good answer. I'm struggling with that and part of it is maybe that I'm based in D.C. where it is quite ... It's difficult to be in D.C. and to be not hawkish about China if you want to get ahead in certain parts of the government here. And so, I'm not actually sure. I know that there's China Twitter ... I mean Twitter in general is just kind of a cesspool and China Twitter is not a productive or constructive place for discourse about anything. I don't know, I wish I had a better answer for you, I need to think about it more.Joanna:Mm-hmm (affirmative)Bill:Do you have any guesses or any suggestions?Joanna:I was expecting a more simplified reaction to my book, but actually all the events I've been doing so far are conversations with academics and fellow reporters have been really nuanced. And it seems like there's a hunger for people who want to admit there are no simple solutions and to talk about that. But it doesn't' seem like here's a particular space or a think tank that has that approach. It seems-Bill:The think tanks probably are the place. I mean there are other ... The folks at SupChina are trying to do that. I don't know if you've talked to them. Kaiser's got his podcast and they do their conference. I think their conference ... We're recording on the 1st of November so they're I think next week. But in general, I don't know, it's also ... Like anything, it's hard to have a more textured or kind of deeper discussion in these 30 minute chunks or when you're sitting on a panel. It's just putting in the time and having ... Like you're doing, talking to me and you're talking to lots of people for your book. And this is a topic that has probably come up in most of your conversations and it's just something we're going to have to keep talking about. I know over the next few months there are at least two more books that are coming out about China's influence in the world. And so it'll be interesting to see where those goes in terms of how they impact or move the discourse and how those get played. And again, I think it's like I said, me struggling with how do you address these issues that are very real and influence interference without going overboard and over-exaggerating and destroying innocent people's lives. Which I think has already happened and continues to be a big risk.Joanna:I do think simple answers that people need to pay better attention and not just to get a shallow understanding, but to really understand the nitty-gritty and try to untangle complexities. And support the people who are trying to do this work. A lot of their names are in my book. If you don't want to buy it, flip to the back of the notes and you'll get their names and look up those articles. People like Yangyang Cheng, Helen Gao. People who are straddling both worlds, Chinese and Western. Because of those real lived experiences, their perspectives are just naturally very nuanced and insightful, I think. So people are doing this work, its just they're not the ones on CNN and getting book deals because of structures power. So support NüVoices.Bill:Absolutely. Like you said, I'm a supporter of NüVoices, I'm very happy to put a link to that as well. Support you through Patreon, right? We should move you over to Substack, but that's a different discussion. That's my bias. Well look, thank you so much. It's really been a pleasure to speak with you and I hope that many of you listeners will go out and buy the book. It's really a worthwhile read and Joanna really has great reporting, great perspectives. And this book is really important contribution to the conversation we all need to be having about China and the future and China's role in the world. So thank you and hope to talk to you again soon.Joanna:Thank you so much for all of your work, really platforming those more quality, well-informed sources on China. You've run the newsletter for a long time, so I think that makes a big difference as well because you use your expertise to point people to credible, good sources. So I'll also subscribe to your newsletter.Bill:Thank you. Get full access to Sinocism at sinocism.com/subscribe

Matt finds a hero in Liz Cheney ... Should Democrats praise Cheney? ... How Biden missteps could provide an opening for Trump ... Are we about to enter a prolonged period of inflation? ... Elise Stefanik has some competition ... Bill: Not all Republicans are insurrectionists ... Finding middle ground on infrastructure spending ...

Matt finds a hero in Liz Cheney ... Should Democrats praise Cheney? ... How Biden missteps could provide an opening for Trump ... Are we about to enter a prolonged period of inflation? ... Elise Stefanik has some competition ... Bill: Not all Republicans are insurrectionists ... Finding middle ground on infrastructure spending ...

Both Joseph Smith and James Strang died in a hail of bullets.  In our next conversation with historian Bill Shepard, we will learn more about the martyrdom of James Strang. GT: So he’s on Beaver Island. He creates a lot of political enemies and I guess religious as well. Bill: Not only that, there’s Alexander […] The post Martyrdom of James Strang (Part 4 of 6) appeared first on Gospel Tangents.

This is a basic conversation about the weekend. First, you'll hear it at a normal speed, then at a slower speed. Next, you'll hear some practice drills. Finally, you'll hear the conversation again at a normal speed. Robert: Good morning, Bill. How are you today? Bill: Good morning, Robert. I'm all right. How are you? Robert: Pretty good. Did you have a nice weekend? Bill: Not bad. I went to the movies on Saturday night. Robert: Oh yeah? What did you see? Bill: I saw the new Harry Potter movie. Robert: Did you like it? Bill: Yes, it was excellent! Practice A: I went to the movies. B: Oh yeah? What did you see? A: I went to a new restaurant. B: Oh yeah? What did you eat? A: I went shopping. B: Oh yeah? What did you buy? A: I went for a drive. B: Oh yeah? Where did you go?

Bill: Do you want a cup of coffee? Robert: Yeah, sure. So, what have you been up to? Bill: Well, I've been really busy trying to finish this project on time. Robert: Are you having a hard time? Bill: Yes, but I haven't had enough time to really concentrate on it. Robert: I know what you mean. Bill: Not only that, but I've been feeling a little under the weather lately. Robert: Did you catch a cold? Bill: I don't know, I think I'm coming down with something. Robert: Maybe you should see a doctor. Bill: I think I'll go tomorrow. Robert: Good idea. Let's practice: A: So, what have you been up to? B: Well, I've been studying hard for exams. A: So, what have you been up to? B: I've been busy working every day. A: So, what have you been up to? B: Nothing. I've been really bored lately. A: So, what have you been up to? B: I got a new job. I've been trying get along with everybody at work. A: So, what have you been up to? B: I started guitar lessons. www.eltpodcast.com

First, you'll hear this a basic conversation at a normal speed, then at a slower speed. Next, you'll hear some practice drills. Finally, you'll hear the conversation again at a normal speed. Robert: Hi Bill. What's happening? Bill: Not much. How about you, Robert? Robert: Well, actually, I want to go to the art museum this afternoon, but I don't know where it is. Do you know where it is? Bill: Which one? There are a few art museums in Fukuoka. Robert: I want to see the Napoleon exhibit. Have you heard about it? Bill: Ah, sure. That's the Fukuoka Municipal Art Museum. It's in Ohori Park. Robert: So, how do I get there? Bill: That's easy. Just take the subway to the Ohori Park station. Walk through the park, and it's there. You can't miss it! Robert: Do you mean that I have to walk to the other side of the park to get to the musem? Bill: Yes, that's right. It doesn't take long. About ten minutes or so. Robert: OK, I think I understand. Thanks. Bill: You're welcome. Let's Practice: A: I want to buy a suit, but I don't know where to shop. Do you know a good shop? B: Yes, I like to buy suits at Fukuyama. You should go there. A: I want to bake a cake, but I don't know how. Can you help me? B: Sorry, I don't know how. You should buy a cook book. A: I want to see a dentist, but I don't know who to see. Do you know a good dentist? B: Yes, my dentist is good. I'll give you his number. Find more at www.eltpodcast.com