a repatriation recovery action between North Korea and United States, but it was stopped in 2005. So I think it's good that we're starting. And also having, simply having a project that United States and North Korea can do together, right? Over this very, you know, the issue will create, I think, sort of spirit, new spirit or atmosphere of cooperation, right? So you can imagine how those American, you know, the soldiers or the NGOs or government can go to North Korea and then work together. So there. And the one, the second important thing is about, yes, North Korea have just repatriated about 55. You know, it's just the beginning. It's just the beginning. This time North Korea did not have any precondition, did not ask for money. North Korea spent all its own financial resources to, you know, process. So it has to give, again, the credit to North Korea. But instead, what you're hearing from American media is all about, you know, no matter what North Korea does or even Trump does in this case, it is about the immediate criticism. And the third thing, again, I want to point out is that we are sort of in right now at a stalemate, right? At the Singapore summit. And a lot of Korean analysts arguing that this could be, this is time now, United States must have done something, you know, reciprocal, you know, action. So that's, I think, why the significance of this latest repatriation of U.S. soldiers missing in action. But this wasn't a reciprocal action on the part of the U.S. This was another one on the part of North Korea. So what do we see other than the U.S. halting the military exercises? Is there anything else that the U.S. is doing either positive or negative? United States, you know, I actually have kept the score where I share with some of our, you know, people in my group. And I kept the score where United States has done only two, that is, as you mentioned, canceling one U.S. and South Korea working. And North Korea has done about so far as of up to date, I'm skipping by 13 initiative, right? So unilateral proactive action. And so respond, in responding to your question, I would say United States has not really done much. United States has done, you know, again, still insisting on, one way or the other insisting on the complete denuclearization of North Korea. And the one sticking point that we all know, I hope that everybody has a clear understanding, is that North Korea would like to have a strongest possible security guarantee from the United States. So that will mean ending the current state of war. That's what North Korea wants. And I remember last time when Pompeo went to Pyongyang, and there was one North Korea was demanding this security guarantee, but which, you know, Pompeo was not willing to give before the complete denuclearization of North Korea. So that is main. And but if you going back to still about the United States has done only two actions, where North Korea has again and again, again, this long list of proactive action, what it means is that it's time. So what is the main issue here, our priority? The main issue is to end the, you know, the current state of war, start the process of signing a peace treaty. Right. So that I hope that we could have some, you know, have some priority. So I just want to let the listeners know who might have turned in late that we're speaking to Simone Chun, who is a professor, an analyst, a writer, and a an activist around peace in the Korean Peninsula. I'm Medea Benjamin with Code Pink. And we're talking now about what are some of the actions that the US and North Korea have taken. And Simone, you mentioned you said there were two. So one was that the US has halted the military exercises with South Korea. What's the other one that you are referring to? The other one will be the Singapore summit, right? Oh, the summit itself. So one meeting and the suspension of a one war game and one meeting. That's it. So on the negative side, it seems that you have put out something that hasn't been covered in the US press about US military exercises with Japan that are threatening North Korea. Can you explain what that is about? July 27th, that is on the anniversary of a signing of an armistice to halt, you know, halted Korean war. There was a report at this time, actually, Japan released the information a US-Japan joint militaries exercises, which involves, you know, B-52, which actually, you know, this came loaded with the nuclear capability. But in the report says that there was no nuclear weapons was not loaded. So the the reason they provide was to contain or to prepare for any North Korea provocation. Now, the timing is very significant. We're talking with a we are still in this process of repression month. You know, we're trying to have the diplomatic solution seeking diplomatic solution with the North Korea. And also after Singapore summit, but on and special on the day that marks the armistice, the fact that United States and Japan, you know, executed that joint military exercise, it really, I would say this is this is a clear violation of the Singapore's the spirit of Singapore summit, right? And also, as you call the and at the same time, also, while North Korea has, again, with productizing all this initiative, you know, to to for normalization with the United States, that United States not coming forthcoming and it's kind of, you know, responding to North Korea is really, I would say that really the creating a big obstacles. And as I the court here, very, you know, Korean professor, expert on the US, North Korea and Korean relationship. And USC, he said that North Korea is unlikely to move much farther without the US making a move first. So it's now right now it's time for United States to take a concrete action, which I think will should be ought to be a starting process to end this current state of war. And actually, we can talk more about later, though, you know, Pompeo will attending ASEAN foreign ministers meeting this Saturday. And there we can have that will be for the first time, since the Singapore summit, right? We will the three foreign ministers for United States, North Korea, South Korea will be in one place. So I think we should be this week, we should really, really, you know, raise an issue for the to start process ending this war. So when maybe this list that you have that shows all of these initiatives on the North Korean side and only two on the US is something we can put up on the Facebook afterwards. Absolutely. Yeah, I think that is certainly not what you read about in the US press. Yeah. So let me just go quickly go through like I would the list that I have a North Korea a contribute to successful Pyongyang Winter Olympics. Second, successfully held the first into Korean summit with the President Moon Jae-in, which are the historic palm and gem declaration. Third, released American prisoners. Fourth, implementing nuclear again, unilateral nuclear test moratorium. Fifth, implemented again, unilaterally missile test moratorium, close the Pyongyang nuclear test site, dismantled key satellite launching site as SOHA recommended or recommends the return of American troops killed during the Korean war celebrate the 65th of victory day, which was July 27. This time, there's no anti American propaganda banners, right? And finally, North Korea said in their North Korean Central News Agency, they said that they really recommend they really want declaration, swift declaration on the termination of war as the first and foremost process, the first step. So we have this. So North Korea, in other words, they are very concrete, constructive, achievable goal. I think we should pay attention to you. Wonderful. I think that would be a great thing to post for people to have. And now I want to move into another issue, which is, you know, as you well know, I've written and talked about this whole initiative is thanks to the people uprising in South Korea, the election of a president who was elected with a mandate to begin this process, President Moon. So could you talk about what is happening in terms of North and South relations? Have there been these same ups and downs, fits and starts? Or has it been a kind of steady process? Yeah, North and South relations, you know, we has been, there has been very steady. Just two days ago, there was a high level, second high level military talks between North and South Korea. Again, if you look at the Western media, American media, they say, oh, you know, they could not agree. And there was no agreement. So that was a bad.  So it's what I'm saying is that a lot of this is actually the most heavily militarized, you and I have been there, have militarized that place. I think when we went to the women cross the DMZ and during the last peace delegation is a Korean, our sisters, Korean sisters, the peace activists, they thought, you know, one dream that we had, well, you know, let's make, create a sort of a physical place like a park, a center or house where we thought, right, women can just, it's like permanently stationed there, right, create. So that was actually one initiative we came out. So I think that could be actually in the creating of the turning transform DMZ as sort of a true peace park, and in fact creating a transforming DMZ as a sort of a for the entire world, the symbol of a peace, right? So I'm not saying that the two Korea agreed on that, but I think there was talk about how transform demilitarized on truly demilitarized place. And that there's North and South Korea now we are there, they are going implementing the interKorean railroad connection, reconnecting the railroad that was disconnected. And there's all kinds of plans for the cultural arts cooperation. And August 11th, there's going to be the actual, the largest or the first, the largest actually correct North Korea is going to, you know, come to the number one, come to Seoul for the workers, what do you call North and South Korean workers soccer match, right? That's going to be really fun. That was also stopped for during this Park Geun-hae Young Park, you know, conserved administration. So this is the idea is that, you know, workers should lead the peace movement, right? So unification workers led unification. So there's all kinds of, you know, exciting news. But of course, the biggest news, you know, which we are coming is August 20, between August 20 and 26, there's going to be the reunion of a separated families. Oh, so that's starting in at the end of August? Yeah, over. So it is really, it's packed. And also, one more thing, August 15th, August 15th is the Korea's, for Korea is the liberation day liberated from 36 years of Buddha Japanese colonization, the end of World War II. Surrender, it depends, surrendering. And so Korea is going to mark this as a sort of North and South Croatia, one inch that is, we, you know, we were one nation, so we want to celebrate the liberation. So there's a lot of, you know, initiative and the, but one thing I would like to point out is that very important. North and South Korea want, I think pretty much majority of Koreans, I, you know, 80 million Korean support the current peace process. I'm confident. And most people in Asia, North and Asia appreciate the current process, probably the entire world appreciate the process. What is that something, one thing that is stopping that is concretely, no matter how much North and South Korea wants, you know, implement expert that accelerates this process, there's one thing that is that that is a sanctions, right, UN, US led and also South Korea is actually constrained to participating. So let's assume the family union to implement those families we need and gathering, you know, you need the, it's a logistic issue, right. And North Korea is a heavily thing. It's literally, if you read the report about the, came out from American Friends Service by, you know, then Jasper, who did the great job of, you know, producing that, creating that report. It's North Korea is currently like almost like economic embargo, it's harshest economic embargo. So, so there's all this this is really a fact that the current Korean, you know, any sort of a repression on and exchanges. So that's the one thing that we can, I think we really have to really address. Yeah, I mean, let's wait, I talked about the sanctions in a minute, but I just want to let listeners know who don't recall this that, that the Trump administration has put a travel ban on US citizens going to North Korea. And while there are supposed to be exceptions for humanitarian workers and a couple of other exemptions, as we saw in the American Friends Service Committee report, it has made any kind of humanitarian programs a lot more complicated. It takes a long time to get these exemptions. It's hard to get exemptions for some of the goods that are deemed to be, quote, dual use. And it's, it's just made the agricultural exchange programs much more difficult, the sending in of medical equipment. So, yes, that is something very concrete that we can push the Trump administration, because those sanctions, the travel ban does end at the end of August, right? And it would have to be renewed by the administration. So that's something concrete we could work towards. But much more important for the people of North Korea are the sanctions in general. And there have been some new reports by the UN that show the horrible situation in particularly in the countryside for children. And sanctions are really creating a situation of lack of food and medicines. And on that level, it seems that these very draconian sanctions are not being adhered to totally by the Chinese. And I wonder how it seems there have been some reports that talk about trade already being initiated or brought back with China. How does that happen when China has agreed through the UN to the sanctions? The China, actually, you're right. There are some report, many reports indicate that China has now renewed some of the economic activities in the border with North Korea. And in fact, China just released a couple of weeks ago, the major, major billions of dollars investment in building those infrastructure. But as you know, actually, what China is doing, and also Russia, as we will also see, there was some sort of a lessening of those sanctions from the Russia side. And China, as you recall, again, to go on back to the United States position, it is not really to really insisting on this maximum sanctions regime pressure does not really benefit anybody does not benefit even the interest, you know, does not even help the interests of the United States. What happened is that, you know, the more hard sanctions that you actually impose North Korea, you know, is North Korea has proven to, to, to survive, right? North Korea, there's this idea of North Korea, the people to North Korea is going to collapse and any, you know, any time soon. But that happened to be wrong. And North Korea has seen people have been in trouble. I mean, I'm sure they're very suffering, but it's very resilient. And there's a lot of also sort of what they develop was there's informal economies, right? North Korea, they develop incantation to survive. And yes, China is renewing its economic activities with North Korea. And I think for the United States, what will happen is, you know, it's really the sanctions regime will continuing, the sanctions will make North Korea more dependent on China. And some in South Korea think that this is all does not benefit North Korea. I mean, people in South Korea think that they want to, you know, help North Korea economically. And they actually want North Korea to depend on South Korea, right? So even if North Korea have less, it has to still maintain its nuclear weapon. If you're economically so interconnected, you're not going to be likely to, you know, use. And so that's, there's less incentive. And also the North Korea, if you look at it right now, from the North Korean side, because the United States still have not done really, that's still insist on the maximum sanctions regime. Many in Korea argued that South Koreans, NGOs, South Korea should be more proactive. And maybe returning to the level of what I would say the humanitarian assistance to North Korea before those, like eight years, before those, the Ingang-Bagyem Park administration, the neo-Kan right in government. So the important point of the importance of that is this, you know, many of those so-called humanitarian aid, even from great American groups, they do not necessarily reach to the most remote places in North Korea. So what South Korean NGOs, South Korean assistance in the past have done was to really help those people who were in the remote areas outside of Korea. So those are the ones that are hurting the most. So I think that at this point, we should really, as you pointed out, you know, one of our groups in the RPS delegation, you know, people who have been to North Korea, you know, about the sanctions regime affect the electricity, you know, this is a modern medicine, you know, we all need electricity, right? But you cannot do, North Korea is not under the heavily sanctions, they can't even operate very simple procedure, you know, the simple thing, penicillin, in the clean water, you know, the American Friends Service point out the report that, you know, people, you know, you can't even build well to have clean water because of all this, the sanctions, right? And one more thing I want to point out, though, is that when I visited those members of Congress, even Democrats, when it comes to maternity issues, they were actually, they were very, they did want to, they were, some of them were shocked about the still the sanctions affecting these, you know, women and children. And they were, and some of the members of Congress, they said, you know, they even never met any American who've been to North Korea. So one of our doctors who have been going to North Korea, and then when you're talking to this, you know, age to the members of Congress, she was, she was blown away, oh my, and at the end of the day, she said, I have never met anybody who've been to North Korea. I mean, and you claim to be, I don't want to be too negative, but the point being, of course, you've never met anybody from North Korea itself. Exactly. So that's why this, you know, how this advocacy work is very, very important. What I found was there's really, really, I would say, even the ignorance, lack of knowledge among people, the lawmakers, there's, they were literally making, writing laws about sanctions, right?  Well, can you say something about this legislation that was introduced to say that Donald Trump or couldn't remove U.S. troops from, from South Korea?  So there's now the bipartisan movement going on both House and Senate and preventing, you know, Donald Trump from making any sort of withdrawal of American troops. So the idea being that American troops will therefore eternity in South Korea. And it's, of course, at some point, one thing that I want to point out, a lot of people say when it comes to the truth, they say, well, what if it's going to, it means that basically North Korea wants the, you know, the withdrawal of American troops right away. But that is actually forced in all three North Korean leaders, Kim Il-sung, Kim Jung-in, Kim Jung-in, they all said that. And this is on the record, they said that, you know, American troops for some time, they, they could even after the, let's say, unification, they said they have a role to play, you know, they did not, they demanded that immediate withdrawal of American troops. And one thing or another thing to put their rationale is that if you look at South Korea, what is it? It's surrounded by the superpowers, right? So what they thought, I mean, well, also there's Russia and China, you know. So North Korea leaders position is that U.S. American troops, it may be somewhat idealistic, but it still has a play balancing role, all right, vis-à-vis those even the Russian China. So they never said, you know, peace treaty means that withdrawal of American troops right away. But American sort of propaganda system, even the lawmaker that I talked, they, the first thing they mentioned was, peace treaty means the rejoin of, you know, American troops, no, that is not true. And so, but having, but Congress having, you know, this bipartisan sort of mandate, it is, it is very disappointing. And especially in this time when they could, what I was hoping was more bipartisan, let's say resolution that supports the Singapore summit. Wouldn't that be so awesome? But instead, just every step of that way, they're creating these roadblocks so that Trump cannot move. So the many in Korean analysts saying that the biggest obstacle right now, I'm even reading the, I read the interview done by former unification minister of South Korea, he said that the, he said that the biggest obstacle right now is American media, the New York Times security analysts who are shaping this public, trying to shape the public opinion that this process is not going to work. Trump, it can be Trump, you can leave this precedent to Trump, et cetera. So I think they're really, really wanted to, they really want the American people to, you know, have a, you know, real story about the process and how Koreans are supporting this process. Well, thank you so much for updating us and for ending us on that note to say that the biggest obstacle to the peace process are people in this country who don't want to see it happen either because they are part of the military industrial complex that benefits financially from conflict, or they might be from within the Democratic Party itself that want to see this process fail to use it against Donald Trump. And so I think our job as peace activists, as people who want to support the people on both sides of the Korean Peninsula is to be educating our own media, our communities, and to be putting pressure on our elected officials that we want this peace process to move forward, that this is a positive thing, and ourselves to be very skeptical of things that we read in the media, especially when they quote anonymous sources to say how North Korea is violating an agreement that hasn't even been signed. So thank you so much for enlightening us. I think it will be great to get your list of the U.S. concessions versus those given by North Korea for people to understand that the North Koreans have actually moved forward quite a lot in this process, and what we have to do is to push our own government. Thank you. Thank you. Bye-bye, Simun. Bye.


Uchiwa mwanaume unaanza kwanziya kitovu Hadi bago tii Hi everybody, welcome to SPM Bars Welcome to Friends Vibe Podcast My name is Liz Jackson and I'm joined by Superhost Miss Kethingi My name is Ndanya Koni Grace mbeiwa chare Mi Grace ya, see Grace So guys, we are back again with another interesting topic and on today's episode So recently Jamia Mosk put out a tweet Pale on Twitter and what it post Rules that women should abide by And some of the rules were Showing hair in public Hair extensions Wearing tight clothes Using perfumes Doing heavy makeup Plaki Is asa wufa ikunyo haim bro Yes, and this sparked a lot of conversation pale online Boniface Mwangi was the first person to To react na kase masasa Nuka just showing e bimbooni And so many people were surprised Especially for me, the perfume one Yo ili nishanga zaka pisa Atami me I didn't know about perfume Because with the kind of What I know about muslims Is that they are always smelling nice Okay, there are some perfumes that you might not like But others are I mean they are always smelling nice So I didn't know about that one I was so surprised Plus I feel for muslims For me, muslima kipita utajuatu The perfumes are strong The scents are very strong And then we came to know easily It's just perfume business So I was very shocked By the way, the perfumes are quite strong Because I remember in high school Because I went to a school Where we had like three-quarter of muslims In our school So I remember we had a rule In our class specifically Hakuna kupaka perfume eni strong Because for us who are not Using those perfumes It was quite irritating So I remember it was a rule in our class If you apply those strong perfumes We are going to get you out of the class Yeah, it was a rule So I didn't know about those perfumes I found out then And I was like I think they are supposed to apply perfume at home At home You smell nice at home Oh, once you leave the house No perfume No perfume Because now you are going to attract men And you are not supposed to That's the reason to attract men I mean I feel like everything here Is in the letter fit na eni Wuki fani zivi tuzote We are talking about showing hair in public Hair extension na tokiweka sa sana You are not showing your hair We are in tight clothes We know that Using perfumes Doing heavy makeup What about makeup What do you guys think about makeup And villem muslim babes wana To test up ala Instagram Especially during weddings Apana shule Emu tu wa bie Ukiwa tu wa po Why not apply makeup na weddings They apply heavy makeup Those are very amazing No, but weddings they do heavy makeup Yeah, feel like Anytime you have foundation Lipstick Ume kontua Ume weka lashes That's heavy makeup Ata yo Nasi wana chora witu kubokubo A special uki kujiwa nyu ba nini ka Ai Kwa ni? Kwa evo kumanisha wana ko? See heavy makeup You see heavy Kwa ni? I think I want heavy makeup Especially during weddings Ina kwa ngaiko If that is not heavy then please ya It's okay Let it not heavy be done Because it's going to be a lot So ideally Wedding Unafakufa niya eyebrows peke No, na akuna eyebrow Aplaka eyebrows Ujiwa kaki mea apa Wezi katoa Iwa wana checka Uzi kwa na ila Eyebrows zina mea bila mupango Ata how do you like when doing makeup Ika evo zuri ii You know, lasimo shape I think that's why zina Wana kwa na eyebrow kubokubo But you see also I have a I wish we had a muslim over here But sule ndo ule pale Mko awili Thing is I mean heavy makeup Because you see makeup is supposed to enhance your beauty Ata uki pa kwa kidogo ime enhance Uki pa kwa mingi kwanza unanzaku kavi baya So, suju kama yo Uame kwa me factor in Kwa zami ni mall makeup is when you're going to look nice Yeah Well, I don't know I'd like to know Rules that are the other side now The men Yeah Kus they are there apparently There are also so many other rules for men Only that I think you know Jamia thought of reminding the women Labdanya Kido go Labdanya they are not following the rule The first one is You're not supposed to have You know You're not supposed to have Haircuts on your hair Like different haircuts Labdanya kama Zetun denya Apu if you're a man You're not supposed to have those haircuts Nabila you sufu kwa kwa kwa Kwa kwa kwa kwa kwa Kwa kwa kwa kwa kwa Kwa kwa kwa kwa Kwa kwa kwa kwa So nafa unye Afro Ite that you leave your hair Afro Amu unye unye Amu unye ute yani You know Nikama, North Korea Oh villain North Korea wana kwa gana But how at least okona 16 Allow the hairstyle Wana izini mbilia Afro ama kipara So bia na dini hangi kwa musilawu Dini hangi kwa Yeah, Rishki, yes strong Hala Na kudai nyele kignisule Apana ikubaliki Na wanyu wana da in devu Na, in devu Oh, nihina Hina basu nneza baka kwenyele Ah, in devu In devu tu Eh Eh, talking of devu As a muslim man aweki le masash Ne kiku amingi Nanyo ah Udesinu wanyo ah Eh Nanyo in game big money bana Nibiletu ni me sahahu What was the reason as to why you're not supposed to keep a master's Masash pa is the long story Of It's a historical thing as to why you're not supposed to keep a master's So, yes unneza kipugoti Yes, sata upigehinaya ko safi Wepigwenia ni? Hina safi Are you in guine? Goti Goti ni gani sasa Goti ni gani me Ia hapa, ia hapa Oh Yeah, that's the goti na kwangi mea choa pa Uno tuata aweki kuku the sign bans Lakin ni wana eka iika Unneza weka nupigehinaya ko safi Lakin ni hapa masash That's where Para You're not supposed to Yes The next rule for men That we didn't know Is actually that There's no wearing shorts Ia ni wuvae Keptura Uma ni kaptura Where? Wuvae shorts Ia ni unafofunike ma goti Ma goti hako ishi Magoti hako ishi konekana Siko shuambona ma goti ifei konekana Uchi Oh, uchi wa maname Ia ni kumanishasasa the next one Uchi wa maname unansapu Anzi ya kitovu Hadi ma goti So you're not supposed to Show anything In between kitovu na ma goti Uko yu usawa Yu ya kitovu usawa Lakin ni wana mkana e Head to toe Sindio Head to toe Aofu e kone shana Ya sasa utukena swimming Shaka nyanji Swimming unabasi They have but I As for swimming You cover up your whole body But you take a shika No, you should not Be tight clothes Sasa waswimu na kanzu Ui nwata e jaku shika Wana kwa nga na beri na Costumes isawa islam Jusa sata na ikiwa Tight ni shida Uchiwa na nastra kwa kwa swimming pool Na nastra komidian Na nastra komidian Akiwa kwa pool Anakwa nga na de Nani ni?  I don't I have not seen one That follows a hundred percent I don't think Ebu, lemi ask you guys Do Christians have Those rules come out Outfit, murely? They do They actually do I think we do In terms of outfit Unafa uvae Unafa kukwam decent Like you're not showing a lot of skin There's also one I'm not sure what doctor Nama what whatever does that You cover your hair As you go to church And I think You cover your hair And you know Nakabata women The acorina The women's gil Gil dama dubai Dama donini Ya, ataya But it's part of the Whatever The head wrap Ya, I think Akin na shusho So it's like Christians Waki tangu I remember My shusho Aki ombal Konafunikata kichu Ya Kuna They are quite a couple Oni that you know Now, Christians They don't follow the rules At pay And then also We have adopted More of the The gospel The success In itanguaji The Gospel yaku Saksid Ya So most of the preachers are only preaching The ministry of how you can Saksid They don't focus on Selling hope Ya Actually nili kwanataka On one of the These free Sundays I want to go and Kwa pastanganga ni Ni wa rekondiya Ya Like I just want to Kwa na ii mambu Inakwa nga ya ukueli na Kasimu kango apo But sasa ita bidi Tanda tumi With drought out Utenu na skia uko wezi Miya tanaka Miya tanu Mashi daza ko zotende Nya lafutunu na enda Miya tanu Nya numbi ii Personali Sia na mamumbi aken ni strong Kwa Mamumbi aken ni ni wote Ya So ita bidi uko na Bajote yo Kani sasa No Sete na kani Sete ni wekona Bajote Nilazima Una juo Una juo Una juo Una juo Una juo Una juo Una juo Una juo Nila noofh gwad So ukimpea miya tanu Akin niyer ju kuwe Iiunni pesa ni dogo sana ko Yea na niyo mazida ni ni ni Yay mas Contractor O mshiau ilo crowd Gal wa Bandy on ji Teru oni ngaaresim noto The crowd bii Now 여러분들 milita k Louis To ni yo nya una Click bandy o kos ytpe ko 1,000 WufaEduta Kigil Diz largely On tZi ya barnike Anda Ful smooth Ni wu church kundzey ko placingin e that lari bi na sangali pataje. Usi na kwa mesuame ambi wa bomo e church like two years ago and especially right no, wu kiangaliya kitamu li kuwadi na packing, sayi na packing kuna petrostation kando like the buildings ina buildi wa towards the church. So by there I wan't to see how it will end up. Yusasa mahaliyako, like kame finnili wa kabisana, na se mahali nuno anga 50 mili on yia land. Ya Na wujue kotao Wazi, there are some constitution there are some pieces of land you cannot own Land that has physical features Amma land i kotao yun ya gava wazi Nuna land itao Nga nga ni pasta Na jwa piyangu wea mungu ni kubu asana Wazi juwa Neza kwa tenei mefa niya miracle Nga efe nga nga very wise I think he's a comedian He's deep down I think he's a comedian You cannot preach Ati iwo kichekesha watu Iwa biote uda trend everyday Na uko tu iwiyo Ulazimu kuna piya gifting Nyota Nyota ya ke na ya comedy Ya na chachin Iwi ya kwa kwa hapa Alright guys that was it from us today Let us know what you think down on the comment section We're gonna see you guys next week My name is Liz Jackson and I was joined by Superhost Miss Kethingi The Gracious Host Ndenya Until next time Bye


Hi, welcome to Visual Studio Toolbox. I'm your host, Robert Grain, and joining me today is Eric Kang. Hey, Eric. Hi, Robert. How are you doing? Hey, good, pretty good. Eric's here to continue our series on data. You guys may have noticed that we're doing several episodes on data. I did an episode with Scott Klein a couple months ago to talk about what's new in data for developers. We focused on the Cloud stuff, a lot of what's going on in Azure, touched a little bit on SQL. We did an episode a little bit back with Dmitri and Kevin Kanane. Kanane. Kanane. See, I wasn't here to ask him how to pronounce his name. Kevin Kanane on the SQL Server Data Tools, which run inside Visual Studio. You're going to show us how you can do SQL Server from inside Visual Studio code. Yes. In a cross-platform manner. Exactly. Then we have another episode that we're going to do, and I'm not sure if this one's going to be before that one or that one's before this one. So don't hold me to the order. But we'll do another episode on, it's going to be SQL Server and Connectors, which is how you can talk to SQL Server from additional languages that you would be doing for inside Visual Studio or code like PHP, Node, etc. Yes. Node.js, JDBC, all that matter. So I want to actually show this one. So this is the one thing that you should remember as a developer aka.ms, a SQL Dev. All right. So this site actually has all the getting started and building your app with a SQL Server with Node.js, PHP, all that matter there. Right. Also it has the cross-links for the useful docs and then the tools site. Yeah. So this is the URL that you need to remember. There's just amazingly cool stuff going on in SQL Server. Some people might be back from the world from a few years back where you just talk to SQL Server, it's just sitting on some server somewhere, it was databases, you just put a connection to it, you had data in there, and you never really cared what version was running there, is it running on Windows, which version of server who cares, because you're just talking to SQL Server. But those days are long gone now. There's an awful lot more that's been going on, and the types of apps we're building are very different. We've got SQL Server running on Linux, we've got the ability to talk to SQL Server from multiple languages on multiple platforms from multiple tools. Right. And so we're trying to give everybody a really good grounding in that on this show. Yeah, exactly. Yeah, we are all on developer focus. So that's one thing. So with that, you can understand why we have a SQL Dev site. Yeah, right. We talk about those PHP, JDBC, Node.js. Now you can understand that we focus on the developers. Right. And we want them to develop their apps with a SQL Server. Cool. Yes. All right. So talk to us about Visual Studio Code. Okay. So let's switch to the slide that I prepared. Okay. So today's session, we are going to talk about the SQL Server Vnext. The Vnext runs on Linux, Mac OS with a Docker container, and Windows equally everywhere. Okay. And so when you say Vnext, do you mean it hasn't shipped yet? Oh, it hasn't shipped yet. Right now, in November 16th with a connect event, we released the CDP1 public page. Okay. All right. Yes. So that's the stage. Got it. And the SQL extension for Visual Studio Code is the main topic that we're going to talk about as a tooling perspective. Visual Studio Code, as you know, it is a light weight editor-based developer tool. Yeah. Which is very popular in the developer community. Right. And then another usage is like a full-featured ID perspective like a Visual Studio. Right. It's kind of a choice for the developer. Yeah, it's about the workflow. Some people and I'm in that group like a fully-featured workflow that happens all inside the IDE. I love wizards. I love things that write my code for me. I don't want to have to drop down to the command prompt and I don't even want to have to go out to, you know, outside of Visual Studio to be typing. That's just me. There are others who like more of a less integrated workflow. They do the exact same amount of work. Of course, talk to the exact same things, but do it more from a command-based mixing and matching various tools as a Visual Studio code as far. So one thing that I read from a blog on the internet, it is that excellent editor plus a great runtime to run your app is what developer needs, right? So that makes sense. So Visual Studio Code fits in that bucket very well. And when you build an application and there is the data for application, right? And you have a choice for storing the data and processing the data. SQL Server is one great choice that you can store your application data and do the data processing. And it's part of your application, basically. And when you build your application using a VS Code or Visual Studio, then you need to be able to have a equivalent solution for your database port. So MS SQL extension comes in that picture. Okay, and this is one of the Visual Studio Code extensions, available for a while. We released the preview version, public preview on November 16th. So November 16th was a big launching day. SQL Server VNX that runs on everywhere. And we released MS SQL extension that runs on VS Code, that runs on the Mac, Linux and Windows. And we also released the command line tools that you can use it to run the routine task in script like a batch script. Or you can automate it for the task. Or you can also SSH in like a terminal in to the machine that runs your server and run command, right? So that's basically kind of a whole portfolio and picture in tools perspective, how we can help developers and admins to, you know, use our tools to develop the apps and using it. Yeah, I hear that, and I go, well, why wouldn't I just use SQL Server Management Studio? Oh, that SQL Server Management Studio is also great. On same day, we released the SQL Server Management Studio version 17.0, we version bumped from 16.0 to 17. That distinguishes the, or signifies that that version starts supporting SQL Server vNext. Ah, okay. So key thing is that even though you're using Windows to manage or develop your application, it doesn't matter, independently you can run SQL Server on Mac, Linux and Windows, right? Right. So SSMS has the capability to connect and run your task on any SQL Server platform and version. That matter. So you equally SQL Server Data Tools that Kevin and Dimitri did a presentation in the previous session. That has also version 17.0 released. And it supports SQL Server vNext everywhere. Cool, yeah. All right. Okay. Okay, so just to quickly repeating, the focus of our team is we really want to help our user to develop with SQL Server, Azure SQL Database, and Azure SQL Data Warehouse anywhere, right? In a simple and very productive way. So whenever we design our product in tools side, the key thing is like it has to be simple and it has to be productive. That's a key principle that we always think in our team. So to do that, there is the two things, two important things to deliver. One is the SQL Server should run on Mac, Linux, and Windows, right? So that was one. And the other one is that as we just briefly talked about, the developer's tool should run on those multi OS independently from where your SQL Server is running. So the answer to the question on November 16 we released the SQL Tools portfolio with MS SQL extension and cross-platform support for those command line interfaces and all that. So now we have many choices as a developer, right? So I just to summarize it. And the way that we look at it here is like this.  I want to develop my application and database on let's say Linux and Mac. Oh, go use MS SQL extension of Visual Studio Code. That's your choice. It's great. It's lightweight, but it provides the must have features like a connect to SQL Server, right? It's called code with intelligence and beautiful language service there and execute and view result. Cool. That's the core. Let's see it. Yeah, so let's take a look at it and I'm going to go. So let's switch to the demo then the case, right? So for this demo I'm going to use the sample database that we have published in the GitHub SQL Server samples. This is the samples GitHub repository. You can go and the clone, just do copy and run a git clone and paste to this URL. They will pull down all the SQL Server samples to your Mac. Let's see. Okay. And once you do that and let's go to VS Code. The first step is that I already pulled down those projects which is called the Belgrade product catalog database. The main reason is Belgrade is that we have a team in Serbia, Belgrade, and the Jovan in the team actually made this application. What it does is that basically it is a ASP.NET core application with using jQuery to query the SQL Server. Okay. And it shows the new feature like a JSON data and function support. Nowadays all the data handling is JSON format. Now it's right. So SQL Server has a built-in feature to support JSON data and the processing feature. So it demonstrates that one and temporal table. Have you heard about the temporal table? I've heard it. Okay, great. The term that's just refresh. I see temporal is more like, for example, if you're working in like a ERP solution, that means a history of employee history, employee, right? That's very important. So that we can always look at, okay, the person was in this job position, but in next year, he got promoted. So he became like a CEO of the company. Then there is always history information for that. If you do like online the sales, online sales web application, then you have a product and you should have a list of product and history and you wanna see what has happened in your business and all that kind of stuff. So historical data is very important. And if you try to build that logic in your application, it can be pretty complex. But using SQL Server, temporal table is doing the vergening of your data automatically by simply just to set the system vergening flag on your table and link up to your main table and the system table. So it's a pretty cool feature. So the demo shows that one and the security features like dynamic data masking and the role level security. Those are also the features that if you want to build in your application using your app logic, pretty complex, but the SQL Server supports that feature just out of box. So this demo actually shows those one. So let's quickly take a look at the other app and then the jump into data side, right? So that if you don't do that, then the developers would feel like, oh, too much data. Yeah, as you say at the beginning. So I will just entertain you a little bit at the beginning.  So it is the .NET application, as I said. So you can do .NET restore and build and run. Then it will run your application. So it's that simple. I just did the .NET run because I already did the restore and build. And let's go to our website, which is this one. So let me make sure it's running. Yeah, it's running. So this is a simple application that shows all your products and the companies, right? And what it does is that, look at it. If I click this time slider, it shows you the data in the past, right? This is temporal tables usage, right? It's so nice, but it's so simple to implement using SQL Server.  So this is our demo and let's go back to our VS Code project. So to, okay, let me close it. To build and kind of work with SQL Server, you need two extensions in the Visual Studio Code. One is a C Shop extension and the other one is MS SQL extension. Right now we have over 9,500 downloads. We have released in the November 16. So thank you very much for everyone who downloaded and started using. Oh, it's our pop-up. We don't need to be reminded we're here. Exactly. So that's great. Our team is really excited that people are finding our tool useful for their day-to-day development work. So you keep going. SQL Scripts with IntelliSense. Ooh, that might, that would actually be faster and potentially more lightweight than using SQL Server Management Studio. If I just want to run some simple queries and see results. Yeah. That's what I'm saying. We are not recommending one or the other. Yeah. Now it is your choice. Now we have full power to see. If I just want to look at a C-Sharp file on the disk, I will load it in Visual Studio Code. Because I just want to look at the code, it comes up much faster. So even if you don't do your main development in Visual Studio Code, it's a really handy utility to have for times when you wanted to do things a bit faster. Actually, it can be anything. It can actually be used as a notepad. Yeah. So I don't. There's a markdown extension. So if you have to do markdown, I think it's your markdown editor of choice. Exactly. And then for anything like taking the text note, I use VS Code. Right. And for literally anything, I use VS Code nowadays. So it's great. Even our usual education team, who's producing the documentation, they use VS Code. Yeah. Cool. So that's great. It's simple. Just to go to search box in Visual Studio and type in msql. Then you will see that there are two extensions. VS Code-msql is deprecated. So this one is a Sanjay and Nagamagalam, is one of our PM in our team, and who actually made the prototype of msql extension. And we made the official version msql, which is the second one. So go install this one instead of VS Code-msql. We are going to unpublish VS Code-msql sometimes. So we just left it to have like a transition. Okay. All right. So those are two extensions that you need. Okay. So let's get to the real business, right? So if you go to the folder, Belgrade the product catalog demo, there is a set of scripts that you can help. So if you're application developer, you focus on the building, let's say the net core, sb.net coding and writing code for jQuery. But to test your application, you need to prepare your SQL Server instance and database all that kind of stuff. So these are the SQL scripts that set up your application database so that you can test it. Oh, one thing important is that as you see, I'm running everything on my Mac, right? One of the key, the user scenario that I want to point out before we continue is that there is a need for developers to do things all unlocally. For example, if you're using Mac, then you should be able to develop your application, develop your database and be able to test it. After that is all done, you can choose your production environment. It can be Azure SQL Database or any Cloud or Windows Linux, but you should be able to work your day-to-day job in Starbucks as well. So the key thing is that on Mac with the SQL Server, you can do that now. I'm running SQL Server Vnext on Docker container on Mac. So it's running. Right. So it's very easy. Let me go to docs.microsoft.com, and there's a SQL-Linux. Or you can just remember aka.ms, SQL Linux, if you type in, it will bring you to this page, and there is one nice icon that says Install. Just click it, and there are a bunch of getting started guides that we prepared before the November 16 release. One of the approaches is this one. So not only for the installation, it also has what you can do for development perspective, what you can do for management, what you can do for migration. If you already have let's say a database running on SQL Server on Windows, then you need to know how I can move the database from SQL Server on Windows to SQL Server on Linux. Right. So all those documents are done through like a step-by-step guide perspective, so it's really easy to follow. Okay. So same for the installation of SQL Server. We're on the Docker, that is the main topic that I want to do. To install SQL Server container, the image and the stored container, Docker container for SQL Server Linux, it's just running these two commands. So copy, paste, and write it in your terminal, then it will set you up. Only one thing that you need to remember is that, go to preference on the Docker, the preference page, and make sure the memory is at least four gigabytes. Okay. Because SQL Server container, Docker container requires minimum four gigabytes of memory. So this is something that you remember. I got this issue at the beginning and then Docker starts with the two gigabytes memory at the beginning. So Docker's got two. So this four gig is, that's not two for Docker plus four for SQL. So it's just a total, the Docker uses four gigabytes of memory for the container. If you're on your, say, Surface Pro 3 with eight gig of RAM, you've got four gigs left for whatever you're doing. Yeah. That's pretty optimized the solution. So I'm running this one. I'm also running parallel's VM stuff, and I never see any issue of performance of my Mac. Cool. Okay. So that's the initial setup. It's just a one-time setup, and now your MacBook is fully ready for your app and database development locally. You're not switching back and forth between others. That's nice. So you don't, if you just want to test locally against SQL Server, you don't have to install SQL Server Developer Edition, you don't have to install SQL Express, necessarily have that running. You can just do this and have full blown SQL Server running only when you need it, then turn it off when you're done. Right. So Docker container is also available for Windows as well. So you can do the same scenario on the Windows as well. Yeah. Cool. That's pretty cool. Technology. I'm in love as well. So that's the initial setup and we are fully ready. So now we can really go into the MS SQL extension capability. So as you saw, I already did the demo preparation for you to show the how app is working. So let's clean up and start from scratch so that you can see the whole end-to-end developer activity using VS Code. So what I'm doing is that on the editor, I opened up the clean up the SQL. I'm typing in SQL. These are snippets. So for most commonly used actions like drop database, create database, you don't have to remember all those syntax and stuff. You can just use SQL drop database here. Then it produces the snippet templates for you and you can type in product catalog. This is the name of the database and it just completes your template for dropping the database. This one will fail because we've been already using the database, and if there is a connection happening, then the dropping database fails. It has to be like a single user mode or there's no connection like that. So I added the command here. You just need to comment it. The main reason that I put it as a command is that it's dangerous. If you run it and drop accidentally your database, then it's bad thing happened. So to prevent it, I just intentionally put this alter database statement that changes your database to single user mode as a command. So I think one more time before you run it. So now I'm running it. On VS Code, the audience can be like the real VS Code, the developers, but there could be some people who's coming from SQL side. First time using VS Code because of MS SQL. So in VS Code, always the starting point is a control shift P to open up the command palette or f1 key. I prefer to use f1 key. So if I click f1 key and type in SQL, then it shows all the commands that the MS SQL extension provides. Going a little more detail, if you take a look at it, we wanted to increase the productivity in a way that which is a natural to the developers. So for VS Code, you just what is natural is using keyboard and using shortcuts, right? So that was the design. So f1 and SQL, then if you take a look at correctly, just typing two more words, it always selects exact command that you need. So we put the effort to design at this level to increase the productivity of the developer every single inch. So that's basically what we are doing. So let's go and then MS SQL Connect. Because there is no connection or connection definition before whatsoever, it starts with empty connection profile list, and it has a create connection profile.  So it asks you question, what is server name? It's a local host and that is name, it's optional, I can just to go then it will select the default. Your name, I'm using this to say for now, type in the password. Now we ask you to save the password. Now for Mac, we save the password in the keychain. So we don't leave it in the clear text in any of your file if you choose to put that route and it's a secure. So for Windows, we use a secret store in Windows version. So that is what we do. So if you go yes and the profile name, let's just make it as a Docker. Okay, that will create it. So I will show you one more thing. SQL Connect, if you go to SQL Manage Connection Profile, there is a multiple sub tasks that can give you more the actions to manage your connection profile. One is the edit. One thing is, as you saw in the wizard, we only asked you four questions, server name, database name, username and password. But in the SQL Server Connection, Connection String can have many more stuff like what is the connection timeout, what is the security setting like an encrypt on or not, or the trust server certificate or not. So for those kind of stuff, you can just directly go to the edit menu in the connection profile management, and we added all those suggestions list for all the connection property strings. Even for the seasoned SQL developer, they may not remember all the connection profile and then know exactly what it does. So to help them, we added those one. So if you go to like an encrypt, then it puts the default value. So just the value for the encrypt property, and those are kind of a feature that we do. This one is saved in the user settings. It's only visible to you. Let's say if you have like a 50 connection strings, but you have to work on Mac, sometimes you have to connect from your other Windows desktop PC or Linux. What you can do is that just copy and paste it there. You don't have to go the create connection profile wizard 50 times whenever you switch it. So that's kind of a detail that we did design and implement for this one. So I just don't save it and continue. Okay. Now SQL EX, execute query, execute query, and delete the database. So let's double-check it. SQL use, SQL use, it's a use database command that first shows you what are the databases in your server. And if you want, you can switch the connection. So good. So we have cleaned up our demo setup. I'm just closing it. The first step is always, you have to create a database. And then in the database, we have to create the tables to procedures that your application need. So I opened up setup.sql and they're doing the same thing. So you connect because we have created our connection profile, now you can see that Docker shows up there. And since then, then you can just click that connection profile that will just make a connection to your servers. Okay. And now let's execute it. By the way, instead of using shortcut, I'm using this f1 at the command line, the command palette because it's a demo. I have a muscle memory, I just quickly pressed the shortcut. But if I do that, then nobody can see what's happening there, right? Magically, suddenly it's executing and all that kind of stuff. So that's one thing that I want to say, and by clicking it, it runs it. One thing that you can notice is that this is a message pane and there is a timestamp. And total execution time. Whenever we execute the tc call statement to SQL Server, what is important is the laps time and then time when it was started so that we can always measure the performance of the query. And to help, if there is any issue, then by clicking the line number, you see that in the editor, we highlight the corresponding batch block, right? So you can always navigate between the query results and editor in this way and you don't get lost, right? So now, let me show you SQL use database one more time. And now you see that product catalog database is created, right? So let's make a connection. So its connection is also successful. And the second one that I'm going to do is that the setting up the temporal table and stuff in the newly created database, right? So if I make a connection again, now you can see that. We only created, yeah. You have to keep connecting? It doesn't maintain the connection? It is editor based. So one thing that we are doing is that connection is editor session based. We actually thought about which one is more preferable, like maintaining global session for entire VS code. So whenever there's a new editor session opens up, we just inherit the same connection versus keep that the scope to editor based. Only one thing in SQL service is that you can open up many editor sessions with a different context. Let's say one editor you have a drop database that we just executed or delete from table statement. And you can think you're connected to your local test database. But accidentally it can happen that you're actually connected to your production. You run it, right? So those are kind of danger. So that's the way that we thought. And as an initial start, we made it as an editor session. And the connection session is kind of the same level. But we have a plan backlog item. If a user wants to go with the global session, we want to have a customizable option that you can set it. So instead of doing that, please inherit the connection from the global session. So that is one of the backlog items. So those are the suggestions and feedback we want to get. And MScool extension is fully open source. So you can come to the GitHub MScool extension project page. And you can see all the issues. You can see all our plans and suggestions and then even both what you want or that you can do. That's basically what we want to ask our users. So one thing that I want to tell you is that we only created Docker connection profile. But if you take a look at now, it is two, right? What's happening here is that whenever you make the connection to a database, we keep most recently used the connection history. And put it automatically in your list. That's cool. So you don't have to create new connection profile from product catalog, right? The original it was just default, we didn't specify database. But second one, we automatically added the connection to product catalog database. So that is the key feature that we added to make things much easier. So it's more like just one click, enter one click, enter kind of an operation in that perspective. So we made a connection here. So product catalog and I'm running, they call EX, that runs it. Okay, so basically this one created the SQL Server Database and they put all the data in the system history information in our database so that my application can use it again. So that's basically what developers would do, open query or write query and execute it and that's one. So going into, I'm sorry, I'm putting it here. So let's simulate what people do as a developer. So these are like my test script. I want to verify that the SQL statements and so procedure in my application is calling against my product catalog database is actually good in shape. So I have a test script. When you write the test script if you look at it, likewise this is a mess. Sorry, DBO, not connected. Okay, so there is a few seconds of delay to pull out the schema information. Now it is working, right? So whenever you connect the first time, there's a little bit of time to pull down the schema information to populate this suggestion list in IntelliSense. So now you can complete your query using IntelliSense. And then you can run your query. So now, when you saw the create database and the setup temporal SQL, you only saw messages, right? Because it was all DDL execution, there was no result set. Now when you actually run your business logic using SQL statement, query statement, then there are data that comes out, right? And I executed multiple select statements, so there are multiple ones. And one thing that is fun is that it's more than eight records. And you want to work on the result set. Then you can click this when it maximizes it, right? And you can work on it and reduce it. If you want to look at the message, you can even collapse and then open or collapse the message that you don't need. You can save those results. Yes, exactly. So let's go to company here. I'll just maximize it. I save all. Now you see two comments, save as CSV, save as JSON. Okay. And this one icon does the same thing. So save as JSON icon, if you click it. I name it company data.json. Yes. Very nice. And it produces JSON file or CSS file that you need. Okay, so this one completes the basic demo of what you can do is visual studio code for just the core features like writing, executing, and the view the result, and of course the save result. I will switch to, let's say, Windows 10, oh, it was on hold. I'm going to show you something more interesting. What's coming? Okay. Very soon. So probably when we publish this session, maybe the new upcoming feature may have been already released. So I don't know. So this is what's new in the extension? Yes, extension in the VS Code. And we are going to release in a week or two. So it'll be available. I switch it into our Windows. Now you can believe that it runs on multi-OS, right? All right, and let's do it. I made the demo script so that I can remember. So what I'm going to do here is that I'll get the query, and the result from a query from the company. And I want to add, simulate my apps, the logic that insert one more company data in the database. So that I can actually see what is the exact code that I need to write and if it works correctly, that I can simulate it in VS Code with MSQL extension. So I'm executing query. So we have three records here, right? And I will save all as JSON. So company, I'm just doing it again on Windows. Okay, now it is a three records. Okay, close it. Sorry, take that finish in. And what I'm going to do is that add this more. So I made it as a name, VS Toolbox, address, all that. So I go here, and this is my new JSON data here, test data code that I can just check in into my app project. So that's good. And then just to clean up the table, so that we can see the difference very easily. Okay, so there's no data. Now, I will show you one interesting thing. You're going to add that, you're going to add that as JSON instead of doing a traditional insert statement. Exactly, and I don't remember. I don't remember. So you're telling me I don't have to remember, I don't have to retype all the field names and I can just take this JSON piece. Slap it into the database. I don't believe it. I'll show you. But one thing is that I don't even remember exact syntax. So what I did was that, you see channel nine inserts from OpenJSON. It's a user-defined snippet. Okay. I copy the code from a sample documentation and pasted it here and created my own snippet. What you can do is that just to go to your preference, and there's a user snippets. It's a VS Code feature. VS Code has so many awesome features, one of them is a user snippets, and you can just select the SQL type. Then this page gets opened. What you need to do is that just put description, prefix is what will show up in your suggestion list. Your body is basically your syntax with just a quotation mark. That's it. I'll quote Simon. Then it will automatically show up in your editor as a snippet that you've seen. Now, it's not done. So one thing that we need to do is that declare the name. It's based on my snippet. There is a JSON data, which is a variable in the snippet template. I want to name it as a company as a variable name. I did that, then it changes all variable template to ad company. This is the where I want to put the JSON data in JSON format. But before that, insert it into company and then I have to put column list. This is another variable in my template. I will show you quickly here. There's a column list, there's a variable. But I don't know what you can do. What are the list columns that you have? Now, you have to pick that definition. Beautiful, isn't it? Wow. SSMS, SSDT didn't even have this feature. Now, it's not all. So I got to tell you that's one of the coolest things I've seen all year in this show. I'm telling you, that is top 10 coolest things we've shown on this show. Great. Well done. Thank you. So now, company order completion. Name, I don't even have to type all the stuff. Now, if you invented something that would copy them in automatically without me having to type, I'd put it number one on the list. I'm just going to settle for top 10. That's good. Suggest it. Great, isn't it? It's so easy. I didn't even know the syntax, but I could finish it. You don't have to go into the SQL Explorer, call it up, expand, expand, expand, look, right in line. Fantastic. The last one is width. This is specific to the JSON format. You need to provide the list with type. It's here. I just copy and paste it. Then I can just remove these guys. So this one, remove this one. Last one, we can just delete all at a time. Change all occurrence. Call that as a Visual Studio Code feature. You have to take that null out or do you leave that? Oh, thank you. You just debunked my code, right? If there is an issue, there is an error squiggly showing up. It just tells you all the way, oh, you have an issue. So that's how you can actually notice. Wait a second, Eric, you have a code issue. So you just did the code review, and let's go to company to JSON. What I do, control, just to select all, copy, go here, control V to copy, right? Then let me write, and then I will select to show you actually was executed, all right? That's so nice. Yes, this is very nice. Our engineering team has done this brilliant job, and I really want to thank them, and it's great. Just for fun, one more thing. I have application, one of the recommendation from SQL is that when you build your application, instead of writing query in your application directly, create a stop seizure for layered protection and then management, and use it. So if you want to debug and know what's inside of so procedure, Jobon built this application, so I don't even know what's inside, right? And it happens every day. Now, go to that finish, right? Right in the editor directly, you can do pick definition or go to, you just print it out in another editor, and you can debug it here. Fantastic. This is the new feature of coming up in a couple of weeks. Great. That's great. I will do one more demo before we wrap up this session. One is called the progressive rendering. I will explain it this way. Performance matters. It has to be fast, right? When in the tools side, when we talk about the performance, it's about response time and throughput time for query execution. So throughput time can be like two hours. If you have really simple query with a large data, it can take two hours. Response time means whenever there is the first row or first set of results is ready to be rendered, then it should be visible to users. That's response time, right? And SQL Server Engine has the same thing. So I will show you the difference between what we have and what we are going to release. So I'm going back to the Mac one, which is running the released version as of today in the VS Code Marketplace. So I'm going to execute it. So it's executing. What I did was that the wait for delay in each query statement so that they kind of simulate the long running query, right? And throughput time is over 12 seconds. So you have to wait entire time before you get that. Right. Now, take a look at the upcoming one. So I'm executing it. See, as soon as the result is coming out, we are rendering it. So Ben in our team has been working on this feature, and he's in the stage two. He's playing. So stage three is coming out. That means right now it is per result set. The result set is ready then we print out. In stage three, he will do row by row. Row by row. Right. Exactly. So that's another fantastic feature that we are releasing. Okay. So if you're doing row by row, how do you draw that on the screen? Do you have to continuously redraw the screen? You get these couple rows, then this row, then that row. Is that the way it's going to work? We need a band to answer the question. Okay. As a PM, it's a magic. Okay. What are you interested to see? All right. Something to look forward to. Sure. All right. So that's my demo. Cool. Fantastic. Give me one more second. A magical extension is open source. Yeah. It's open source. We don't even use any of the internal system to box tracking anything. We all use the GitHub repository project, VS Code-MSSQL. Okay. If you go there, you can see full transparency of seeing all the issues. Even our internal discussion, it's not internal. Everybody, every developer is on our team now, right? Because you can join us, and then you can see all that one. We also have a daily build, and we also have like a project plans. So even without watching this session, you can actually see what's coming in two weeks. So basically, that's an extension one, and everything I explained today is all here. We'll put up the links for all those new show notes. Yes, please. Don't forget, aka.ms, SQL Dev. If you're a SQL developer, this is the page to go. Very cool. Thanks so much. Okay. Very, very cool stuff. Hope you enjoyed that, and we will see you next time on Visual Studio Toolbox.