Podcasts about ssis

The podcast episode delves into the critical importance of evidence-based mental health solutions, particularly emphasizing the role of single session interventions (SSIs) as a viable alternative to traditional therapy models. Jessica articulates the pressing need for employers and organizations to scrutinize the effectiveness of mental health resources, advocating for investments grounded in empirical evidence to ensure optimal outcomes for individuals seeking support. By highlighting the stark reality that a significant proportion of adults and youth do not receive adequate mental health care, the discussion underscores the necessity of accessible, scalable solutions that can bridge existing gaps in the mental health system. The conversation also explores the versatility of SSIs, which can be tailored to various contexts, including primary care and digital platforms, thereby enhancing their reach and efficacy. Additionally, the episode touches upon the emerging role of technology and cross-sector collaboration in shaping the future landscape of mental health interventions, suggesting that strategic partnerships could lead to innovative pathways for addressing mental health challenges effectively.Takeaways: Employers need to critically evaluate mental health resource investments to ensure evidence-backed effectiveness for employee wellness. The high prevalence of untreated mental health issues among youth and adults necessitates scalable, accessible interventions. Single Session Interventions (SSIs) emphasize making the most of brief encounters to foster hope and actionable steps toward mental health improvement. Technology plays a crucial role in mental health solutions, but must be paired with regulatory frameworks to ensure safety and efficacy. Cross-sector collaboration is essential for developing comprehensive mental health strategies that effectively address the needs of diverse populations. Awareness and education in workplace mental health can empower managers and employees alike to foster supportive environments. Links and Resources:Jessica Schleider, PhD on LinkedInChanging WorkScott Shute on LinkedInNicholas Whitaker on LinkedInAimee Serene on LinkedInThanks so much for joining us this week. Want to subscribe to Changing Work? Have some feedback you'd like to share? Connect with us on Spotify, Apple Podcasts, and YouTube to leave us a review!

International educators, are you ready for the day when you go “unglobal”?We gazed into our crystal ball again with our all-star panel of Amy Hunt, David Ross, and Rob Howe, this time to learn how to transition out of international education.David Ross is a retired international educator. He began teaching in California, then moved to Malaysia with his family to teach at ISKL.  He then took a sabbatical with his family to bike across Europe and ended up in Vietnam. He taught for nine years at SSIS. He enjoys SCUBA diving, playing in a band, pickleball, and cooking. He has also been a proactive investor and proponent of financial literacy.Rob Howe is a business professional. He began his career in the technology industry. After a 1.5-year sabbatical, he met his wife, an international teacher, and decided to become one. His first position was in Indonesia. He then returned to the US, started a new career in sustainability consulting, and adopted two children from India. In 2014, he returned overseas. Posts included Lebanon, Zimbabwe, and Vietnam. Amy Hunt teaches Psychology and Science of Mind at Nueva School in San Francisco. After a year in outdoor education, Amy left the US to teach in Ethiopia, where she met her husband, Lee Fertig. They later moved to Brazil, then back to the US, followed by stints in Spain, Brazil, and Belgium before returning to the US in 2020. A curious risk-taker, Amy is also a yoga therapist. She reads a lot, loves murder shows, pickleball, taking hikes and cold plunges.Our Guiding Question was, “What are some of your takeaways after transitioning out of international teaching?”Panelists shared their experiences moving out of international education to return to the US. Here are a few topics covered: Leaving your “tribe” and finding a new oneCharacter strengths/skills of international educators that help with transitionThe RAFT approach to transitions> Reconciliation | Affirmation | Farewells | Think Destination (see link below for details)Letting go of perks of international teachingUnpacking Affordable Care health insurancePersonal finance Children transitioning to the USA "2-year" transition processResources Mentioned:The poem IthacaPERMAH Pivot PlanThe Edgar Suit (Men in Black)RAFT ideaShow was recorded on January 15, 2025 Categories: Parenting | School Life | Transitions | FinancesRemember to access our Educators Going Global website for more information or to subscribe to our newsletter!Email us with comments or suggestions at educatorsgoingglobal@gmail.com Follow us on LinkedIn, Facebook, Instagram or YouTube.Listen on your favorite podcast app: connect from our share page.Music: YouTube. (2022). Acoustic Guitar | Folk | No copyright | 2022❤️. YouTube. Retrieved October 11, 2022, from https://www.youtube.com/watch?v=YOEmg_6i7jA.

In this livestream, Frank and Andy discuss the timeless nature of backend enterprise tech, that, much like a Christmas special from decades ago, is still very much celebrated.Moments00:00 Exploring SSIS future in a festive episode.08:28 Data engineering evolved from business intelligence systems.10:57 Social networks project before Facebook's popularity.19:19 SSIS training informed data engineering concepts teaching.24:56 Bill Gates moved project to immature Microsoft tooling.29:10 Data engineering possible in 2024 using T-SQL.35:23 Huge cloud companies surpass previous brick-and-mortar giants.40:10 Old technologies endure; misconceptions about their age.46:03 Evaluate change benefits: technical ease, business growth.52:30 Cloud departure interests rise, SSIS assistance sought.55:47 Big government agency utilizing diverse cloud platforms.01:00:59 Security is crucial; clients' preferences vary.01:08:56 Certification issues hinder software updates and compliance.01:10:02 People stick with older systems for reasons.01:15:15 Proper GPU driver drastically improved loading time.01:22:16 Repost increased engagement and communication with author.01:25:45 Data scientists should learn SQL for simplicity.01:31:06 Obsolete systems cause issues without quotes.

Are you ready to dive into the details that make a difference? Join us for an exciting First Case Vendor Spotlight™ with Jenna Lindsay, Clinical Application Specialist, and Vinod Menon, Product Development Specialist, at Solventum (formerly 3M Health Care). We're unpacking everything you need to know about surgical skin prep and its crucial role in helping prevent surgical site infections (SSIs). Tune in to understand the clinical guidelines for patient skin antisepsis and learn how 3M™ SoluPrep™ S Sterile Antiseptic Solution chlorhexidine gluconate (2% w/v) and isopropyl alcohol (70% v/v) Patient Preoperative Skin Preparation stands out. From providing rapid, broad-spectrum antimicrobial protection1†, helping to enhance incise drape adhesion*, and visibility on a variety of skin tones3, this skin prep is a breakthrough solution. Plus, it provides a larger coverage area than the leading CHG and alcohol-based skin prep (26 mL applicator)3¶. At Solventum, fomerly 3M Health Care, we create breakthrough solutions for our customers' toughest challenges by pioneering game-changing innovations at the intersection of health, material, and data science to change patients' lives for the better — while enabling healthcare professionals to perform at their best. For more information about SoluPrep S Sterile Antiseptic Solution or to connect with a Solventum Representative visit SoluPrep S at go.solventum.com/SoluprepSFirstCase You can also follow Solventum on Facebook, Instagram, and Twitter. #operatingroom #skinprep #surgicalskinprep #skinantisepsis #surgery #perioperative #ornurse #scrubtech #surgeon  † Study was performed on healthy volunteers under simulated surgical conditions. * Compared to skin prepped with ChloraPrep® with 3M™ Ioban™ 2 Antimicrobial Incise Drapes in a simulated knee surgery model, 2019. ¶Compared to ChloraPrep®, 2021. 1. The clinical significance of in vitro data is unknown. 2. Olson L, Morse D, Paulson J, Bernatchez S. Evaluation of Incise Drape Lift Using 2% Gluconate/ 70% Isopropyl Alcohol Preoperative Skin Preparations in a Human Volunteer Knee Model. 2022;15:24-28. 3. Solventum internal data on file.

Get ready to learn a lot about international education as we interview three long-term veterans while sharing a few insights ourselves. David Ross is a retired 58-year-old international educator. He began teaching elementary school in Los Angeles, then moved to Kuala Lumpur, Malaysia, with his family to teach at ISKL for six years.  He then took a one-year sabbatical with his family to bike across Europe and ended up in Saigon, Vietnam. He taught grade four for nine years at SSIS and coached middle and high school men's volleyball. He enjoys SCUBA diving, free diving, playing in a band, pickleball, staying fit, and cooking. He has also been a proactive investor and proponent of financial literacy.Rob Howe is a 56-year-old business professional and international educator. He began his career in the technology industry. After a 1.5-year sabbatical from work, he met his wife, an international teacher, and decided to become one. His first opportunity was in Jakarta, Indonesia, for two years at NJIS. He then returned to the USA, started a new career in sustainability consulting, and adopted two children from India. In 2014, he returned to overseas teaching. Posts included Beirut, Lebanon, Harare, Zimbabwe, and Saigon, Vietnam at SSIS. He participated in the Sustainability Council at each school and is an avid hiker, biker, gardener, and explorer. Amy Hunt is currently teaching Psychology and Science of Mind at Nueva School in the San Francisco Bay Area. After earning an MAT and spending a year in outdoor education in 1987, Amy left the US at age 25 to teach IB English in Addis Ababa, where she met her husband, Lee Fertig. They moved together to Rio, where Amy also began teaching IB Theory of Knowledge. They moved to the U.S. for awhile and then went back overseas, for more beautiful experiences in Barcelona, São Paulo, and Brussels before returning to the US in 2020. A curious risk-taker and boundary-stretcher, Amy has taught many subjects and recently became a certified yoga therapist. She reads a lot, loves murder shows and pickleball, takes hikes and cold plunges, and tries to coax her three 20-something children to fly the nest. Our Guiding Question was, “What are some lessons learned from your careers as international educators?”Here are a few topics covered in this episode:  Personal and Professional: Big picture highlights and lowlightsStrategies to make the most of one's time overseas both personally and professionallyRaising Children Overseas: Tips to support them in and outside of schoolLiving in and outside the school bubbleDifferent life and career pathwaysThe show was recorded on October 16, 2024.Categories: Parenting | School Life | Transitions | Travel | Finances Remember to access our Educators Going Global website for more information or to subscribe to our newsletter!Email us with comments or suggestions at educatorsgoingglobal@gmail.com Follow us on LinkedIn, Facebook, Instagram or YouTube.Listen on your favorite podcast app: connect from our share page.Music: YouTube. (2022). Acoustic Guitar | Folk | No copyright | 2022❤️. YouTube. Retrieved October 11, 2022, from https://www.youtube.com/watch?v=YOEmg_6i7jA.

Theme: Our Year of All Round Blessing Genesis 1:28, Genesis 26:12, Deuteronomy 28:1-13

Can a single, brief session significantly improve your mental health? Join Dr. Juna and Benji Kaveladze, PhD., researcher at the Lab for Scalable Mental Health at ​​Northwestern University as they discuss the power of Single Session Interventions (SSI). Discover the potential of SSI in addressing loneliness, anxiety, and depression. Benji shares insights from his research team headed by Dr. Jessica Schleider. Learn how brief, impactful interventions can offer long-term benefits. Learn about the accessibility of SSIs and how they could reshape the landscape of mental health care. 01:43 Introducing Benji Kavaladze 03:08 Challenges in Mental Health Accessibility 05:37 Understanding Single Session Interventions (SSI) 09:48 Effectiveness and Research on SSIs 15:10 The Lab for Scalable Mental Health 21:49 Future Directions and Uplift the Web Project 23:14 Practical Tips and Final Thoughts Subscribe to MindBodySpace for more content like this! Instagram:   / mindbody_space   LinkedIn:   / mindbodyspace-llc   Website: https://mindbodyspace.com/ Youtube:    / @fallasleepeasy   More about MindBodySpace and monthly memberships for students K-12 and adults, coming up at https://mindbodyspace.com/ #MentalHealth #SingleSessionInterventions #SSI #Wellness #MindBodyConnection #MentalWellbeing #Loneliness #MindBodySpace --- Support this podcast: https://podcasters.spotify.com/pod/show/mindbodyspace/support

In this episode, we delve into Frank's new role at Red Hat, where he's pioneering advancements with Rel AI, an innovative tool for training large language models. Andy shares his latest adventures in Microsoft Fabric training, reflecting on the rapid pace of tech evolution. Along with tech talk, they touch on personal milestones, such as parenting and life's significant changes. So, grab your favorite drink, sit back, and join us for an insightful conversation filled with tech trends, personal stories, and a touch of nostalgia. It's an episode you won't want to miss!Show Notes04:08 Limited college course options, but important financially.09:16 Fabric data factory training, following SSIS, Azure.10:08 Teams doing diverse work to improve services.13:14 Adoption drama resulted in life-changing impact.16:50 Functionality in Office 365 for family use.21:56 Data-driven podcast episode ends with call-to-action.

Get ready to scrub up and join the fight against surgical site infections (SSIs) in this must-listen episode of "On Pathogens & PPE!" Host Jill Holdsworth and co-host Patrick Gordon are joined by special guests Jhmeid Billingslea and Jeri Culbertson to explore the risk factors, prevention strategies, and Sterile Processing's role in preventing SSIs. From preoperative prep and intraoperative prevention to post-op wound care and surveillance, these experts are here to help you cover all the bases to help keep your patients safe. Tune in and get ready to lead the charge against SSIs in your facility! Over the next 12 weeks (plus one bonus episode!), Jill and special guests around the industry will provide practical insights and strategies to enhance the collaboration between Sterile Processing and Infection Prevention Professionals. New episodes of On Pathogens & PPE will release each Wednesday on all Beyond Clean & Transmission Control channels. For the best listening experience, download the Beyond Clean mobile app on Apple (https://lnkd.in/g4pdJ3iS) and Android (https://lnkd.in/gipEeMjc) devices. This series is designed to empower you and your team to transform your department's approach to employee and patient safety. A special thanks to our Year 1 sponsor Healthmark, a Getinge company, for making this series possible! Discover Healthmark's innovative and cost-effective infection control solutions for your healthcare facility here: https://www.hmark.com/?pmc=BC-Readonpod If you have thoughts or feedback on this show, please email us at info@beyondclean.net *Disclaimer: The views provided by hosts and guests on this series do not represent any employer, company, or third party, and are solely that of the individuals themselves.

durée : 00:02:40 - Les premiers semis sous châssis

Ana On Air raconte comment elle est passée du gaming à ambassadrice d'Alpine. Elle revient sur son rôle dans la team e-sport de l'écurie.

Eesti jalgpallimeeskonna EM-valiksari ebaõnnestus, sest alagrupis jäädakse viimaseks. Neli järjestikust kaotust koguskooriga 0:15 tekitab paratamatult küsimuse peatreeneri Thomas Häberli ametisse sobivuse osas. Aga staadionil nõuti plakatitega mitte peatreeneri, vaid alaliidu presidendi Aivar Pohlaku lahkumist. Lisaks jalgpallihädale lahkab Spordireporter teisigi teemasid: korvpallurite säravad esitused Hispaanias, Lauluväljaku MK-etapp tuleb taas, Mark Lajali karjääri parim võit, välistreenerid Eesti pallimängudes – kui oskuslikult me neid tilgatumaks lüpsame, ÕSsisõnad ehk paralümpia või paraolümpia, ragbi MMi eripära, Netflixi spordidokumentaalide menu põhjus, Thomas Bach vastandlik pärand. Saatejuhid Joosep Susi ja Ott Järvela (Soccernet.ee).

Jacqueline Daley HBSc, MLT, CIC, CSPDS, FAPIC and Franklin Dexter, MD, PhD, FASA explain the importance of the triad of patient preparation in reducing surgical site infections (SSIs) and complications, explore the clinical evidence supporting the use of nasal decolonization, skin preparation, and incisional drapes in SSI prevention, explain the economic impact of SSIs and the cost effectiveness of implementing a bundled approach to patient preparation, and develop an action plan for implementing a comprehensive patient preparation bundle in your healthcare facility. 

When Power BI was released, I was working with customers to try and adopt DevOps for their database code. At that time, I thought the Microsoft developers had made an extremely poor decision with the PBIX format in that it wasn't well suited for version control. In 2011, when it was first released, we not only had decades of knowledge about version control and the power of DevOps, but we'd also been living with the extremely poor format of code in Integration Services packages (among other data tools), that were poorly suited for understanding in version control systems. Power BI has grown, and with the Fabric announcements, there are integrations with git for your workspace. There is also a Power BI Developer mode that saves your project in a folder structure rather than one file, which is better. I'm not sure it's great, especially if it doesn't enforce text in a way that ensures a developer can easily see changes between settings and understand them. I can certainly diff the XML in two SSIS packages, but that doesn't mean that it's easy to understand what has changed. Read the rest of Power BI and Git

The lovely Jessica Schleider, PhD of Stonybrook University (soon to be Northwestern!) joins the podcast to discuss her latest paper in the International Journal of Eating Disorders that focuses on data from Project Body Neutrality. Results are promising and indicative of the effectiveness of brief, accessible interventions in reducing mental health problems, including disordered eating, body dissatisfaction, and depression. Join us to learn all about single-session interventions (SSIs), body neutrality, scalable mental health, and next steps for Dr. Schleider's lab! Paper Discussed in the Episode:1. Smith et al., 2023: Project Body Neutrality: Piloting a digital single-session intervention for adolescent body image and depression. Int J Eat Disord. 2023 May 2. doe: 10.1002/eat.23976.See More from the Schleider Lab: https://www.schleiderlab.org Contact Picture Blurrfect:Twitter: @BlurrfectInstagram: @picture_blurrfectE-mail: naomi.charalambakis90@gmail.com

Can a single counseling session make a lasting impact on patients? Dr. Jessica Schleider weighs in on when single session interventions (SSIs) are or aren't useful, how to know if your SSIs led to real change, and ideas for integrating SSIs with traditional, ongoing counseling practices.  Resources/Suggested Reading Schleider & Weisz, 2017, meta-analysis: https://dash.harvard.edu/bitstream/handle/1/41292903/54465763.pdf?sequence=1 Written transcript: https://doi.org/10.24839/psych5.06  Calls to Action Listen or follow PsychEverywhere: https://www.psichi.org/page/podcast Tell a friend or colleague about the show. Follow PsychEverywhere on Twitter: https://twitter.com/PsiChiPodcast Leave a review on Apple Podcasts or wherever you listen to podcasts  

The demand for effective data analytics within organizations continues to grow – how do you build your analytics team? While at SQLBits in Wales, panelists Maria Zakourdaev, Falek Miah, and Anupama Natarajan discussed their experiences with building teams - from recruiting to training, up-skilling, and retention. The discussion spans the different roles, including architects and data modelers, that help to provide the data sets analysts need. Do you train from within, hire into the role, or use consultants? There are many choices for growing your data analytics team!Links:SQLBitsRecorded March 18, 2023

EP#66 Willis Nana : Data Ingenieur En savoir plus sur moi : https://espresso-jobs.com/conseils-carriere/les-geeks-du-web-willis-nana/ "Creates simple solutions to complex problems" - Mes Skills Data Engineering

Surgical site infection (SSI) is the most common complication resulting from cesarean section. Despite advances in infection control, SSIs remain a significant post-op burden, to the patient first, and to the healthcare system second. Negative pressure wound therapy devices (NPWT) are a potential solution to post C-section. wound infections/complications. Do these devices prevent incisional wound complications after C-section? In this episode, will dive into the data and review the specific CDC criteria for diagnosing surgical site infections.

Welcome to HAI School – A Febrile Bundle on Healthcare-Associated Infections! Join Drs. Jeremy Steinbruck and Nick Gilpin for episode #3, which will cover surgical site infections (SSIs). Stay tuned for the last episode of the series next week and the prior episodes of CLABSI and CAUTI. The series runs from episodes 60-63!Episodes | Consult Notes | Subscribe | Twitter | Merch | febrilepodcast@gmail.com

The dreaded Surgical Site Complications! Join Drs. Ashlie Nadler, Jordan Nantais and Graham Skelhorne-Gross from our Emergency General Surgery Team as they discuss surgical site complications and prevention techniques. Paper 1: Arnold et. al. (2019) Not a Routine Case, Why Expect the Routine Outcome? Quantifying the Infectious Burden of Emergency General Surgery Using the NSQIP. American Surgeon  - NSQIP database 2005-2016 (>800,000 patients) including open/laparoscopic cholecystectomies, ventral hernia repairs, and partial colectomies  - Comparing outcomes in emergent vs elective cases - Primary outcome: aggregate of SSIs which includes wound disruption, superficial SSI, deep SSI, and organ space SSI  - Results: -- ↑SSI in the emergency group (5.3% vs 3.6%)  -- When controlling for multiple variables, emergency surgery associated with more SSIs (OR 1.15).   Paper 2: Lakhani et. al. (2022) Prophylactic negative pressure wound dressings reduces wound complications following emergency laparotomies: A systematic review and meta-analysis. Surgery  - NPWD remove excess fluid from subcutaneous space, ↓ collections/contaminants, promote angiogenesis, fibroblast infiltration   - Literature review 2005-2022 (NPWD, laparotomy, SSI)  - 1199 patients included (566 NPWD, 633 standard dressings)  - Results: -- NPWD ↓ wound infection (OR 0.43) and wound breakdown (OR 0.36)  -- No change in LOS, readmission Please visit https://behindtheknife.org to access other high-yield surgical education podcasts, videos and more.   If you liked this episode, check out other Emergency General Surgery episodes here: https://behindtheknife.org/podcast-category/emergency-general-surgery/ 

As the risks and issues surrounding the deployment of access management and customer identity systems increase, there is one solution proving to be popular, which is a self-sovereign identity system (SSIs). These self-sovereign identity systems include an approach toward creating a digital identity that allows individuals the ability to verify themselves by controlling information. What Is Self-Sovereign Identity (SSI)? Self-Sovereign Identity (SSI) is an approach that is user-centric toward digital identity by giving people and businesses complete control over their data. Therefore, SSI allows anyone to share their data easily and prove their identity reliably (i.e., everything about them, including who they are) without needing to sacrifice privacy or security. In simple terms, SSI gives you the chance to “bring your own identity,” which is true for any information potentially that informs your core identity, for instance, your age, name, and address, to your work records, education, bank account, insurance and health data, and financial information. Also, you can use SSI for modeling people's digital identities and for IoT and organizations as well. In the end, SSI has promised a digital world where interactions will be worry-free and effortless. It's the next step in the evolution of identity management, which creates a new paradigm where digital identities aren't locked or fragmented in silos that are controlled by someone else, but will be at your disposal to share privately and securely. Why Use Self-Sovereign Identity? In the past couple of decades, we have witnessed the digitization process that has unfolded on a global scale and involves numerous industries. Even though the start of this process was gradual, it accelerated when smartphones emerged as that placed the digital worlds at your fingertips, and it was even more drastic when the COVID-19 pandemic gripped the world, as it forced everyone to move toward digital interactions from in-person ones. However, it's not a secret that there wasn't an identity layer built when the internet came into existence, and as the world continues to grow digitally, we must confront the insurmountable issues that come with it. You can say that digitization has come with its price, such as: Limited control over data: Only a handful of companies hold the power, which effectively lock in users and control data. Privacy issues: As users aren't controlling their data, there has been a rise in privacy scandals and diminished trust in data aggregators. Compliance issues: Data must be stored and managed centrally by online service providers, which means they are open to penalties and regulatory scrutiny. Security issues: The standard method to secure access to user data and services, especially authentication that was password-based can't be relied upon and that has caused several data breaches on a larger scale. Identity theft and Fraud: As there are limited identification and authentication tools that can be relied upon, there has been a rise in identity theft and other types of fraud. Online marketplaces and service providers have been struggling to ensure that transactions are trustworthy. Cumbersome user experience: There are several authentication methods that users are forced to use, including different passwords, and the online identification processes are lengthy. These problems can be solved by SSI as users will have more control over their data, and they can share that data securely, privately, seamlessly, and whenever they want. The potential for generating value is immense as individuals, governments, and businesses can all benefit from it. Benefits for People SSI offers several great benefits to people, which ensure that they will be able to take advantage of having their data in their own hands. Here are some of the benefits that SSI gives to people: User experience: SSI ensures that people can share their data effortlessly with others. The standard method for sharing da...

Ülvi Aslanov I "Code Academy" tədris müəssisəsinin təsisçisi və direktoru I "Danışır Biznes" #78

Today we are looking back on how the BI Architecture has changed - the tools of old (SSIS, Analysis Services) vs the "business" tools (dataflows, data marts). Is the #PowerBI stack (not including Azure) BETTER than it was? Thanks to Marcus Wegener for the inspiration https://lnkd.in/gp64TiKC Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit on the PowerBI.tips Podcast Page. Visit PowerBI.tips: https://powerbi.tips/ Watch the episodes live every Tuesday and Thursday morning at 730am CST on YouTube: https://www.youtube.com/powerbitips Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ Follow Mike: https://www.linkedin.com/in/michaelcarlo/ Follow Seth: https://www.linkedin.com/in/seth-bauer/ Follow Tommy: https://www.linkedin.com/in/tommypuglia/

The mid-2000s saw a strong move toward quality in surgical procedures, with the emergence of the Surgical Care Improvement Project (SCIP), various initiatives to reduce surgical site infections (SSIs) and the National Surgical Quality Improvement Program (NSQIP) developed by the American College of Surgeons (ACS). Yet, the passing years have revealed the need to get actionable data around surgery care and outcomes for improvement efforts to succeed. Actionable data is critical to drive optimal quality and financial performance. Also needed is to provide surgeons with a system in place that fosters improvement. In this episode, we continue our discussion on these and other ways to improve surgical quality.   Guest speaker: Rick May, MD Senior Principal Clinical Quality Improvement Vizient Orthopedic Surgeon   Moderator: Tomas Villanueva, DO, MBA, FACPE, SFHM Principal Clinical Operations and Quality Vizient   Show Notes: [00:28] Surgery and the hospital's financial success [01:14] Payers and surgical costs [02:07] Surgical quality and national scorecards [02:45] Surgery impacts many metrics [03:23] Surgeon compensation for quality [04:20] Need to have system in place that fosters surgical quality [04:56] The rise of ambulatory surgery and the effect on quality [06:33] The ROI for improving surgical care [08:00] The future of surgical improvement [09:05] Start now. Don't wait.   Links | Resources: To contact Modern Practice: modernpracticepodcast@vizientinc.com Dr. May's contact email: rick.may@vizientinc.com ACS National Surgical Quality Improvement Program (NSQIP) Click Here Developing a Surgical Quality Improvement Program for Resource-Limited Settings (JAMA Surgery) Click Here Vizient Operations and Quality Click Here   Subscribe Today! Apple Podcasts Amazon Podcasts Android Google Podcasts Spotify Stitcher RSS Feed  

Sõda õhus on tundmatuseni muutunud: taevas lendavad raskelt avastatavad tapjadroonid ja külvavad hukatust. Milline on droonisõja tulevik? Kas purilennukitel on kohta nüüdisaegses lahingulogistikas? Miks just Vene MIG hävitajad on Ukraina oludesse sobivamad, kui muude riikide ultramoodsad lennumasinad? Neist asjust räägivad lennundusekspert Peep Lauk ja saatejuht Marek Strandberg.

In this podcast, Dr. Romina Pena asks Dr Steven Wexner various questions on General Complications in Colorectal Surgery. They discuss anastomotic leaks, a difficult problem. Dr. Wexner explains his 4 strategies for mitigating this complication. Also, with the ongoing development of technologies, the doctors talk about their expectations for the future, and how it will affect them on a daily basis, for example, in avoiding multiple crossing staple lines. Another complication discussed is Surgical Site Infections (SSI). Protocols for prevention were discussed in a previous podcast with Dr Antonio de Lacy - therefore, in this one, Dr Wexner how there still are still SSIs, despite all all the knowledge and prevention in the field. They also talk about how bowel preparation might change due to the microbiome. The final complication discussed bleeding. Dr Pena asks Dr Wexner sks about his thoughts on the future, specifically, how new technology such as Artificial Intelligence could prevent bleeding. Finally, she asks him about other methods for clean treatment when facing this stressful complication.

Daglige københavnske nyheder udvalgt fra Berlingske, Information, Jyllands-Posten og Politiken

“What we've got to do is look at what is the impact of having a wound infection, or a surgical site infection, on the patient, on the doctor and the healthcare professionals, as well as the economic burden within the NHS.”As somebody who has become highly knowledgeable on these what these impacts of a surgical site infection (SSI) are, it is why Giles Bond-Smith is so passionate around improving the processes and attention paid to it within the NHS.The Emergency General/HPB surgeon at Oxford University Hospitals NHS Trust joined host Matt Roberts on NHE's Finger on the Pulse podcast discussing some of the challenges commonly faced around this type of infection prevention, but also the opportunities to innovate as well.“We should be doing everything possible to look at how we can mitigate surgical site infections for our patients.“Typically, as surgeons, we don't really pay much attention to our wounds, but the patients do. How does a patient judge whether an operation went well or not? They look down at their wound; they see how big it was.“If the wound is less in size than the wound is in their mind, they think we've done well. If the wound heals beautiful, people show it and say the operation went very well.“Whereas, if someone's had a complete wound dehiscence due to infection, they feel the operation was a disaster. Now, it might not have been, but that's how the patient perceives it, and we've got to take this more seriously.”But how do we tackle surgical site infections and ensure the wounds can heal neatly, safely and quickly for the patient?One of the ways, as Giles explains during the podcast episode, is to look at some of the really simple but innovative technology out there – such as the antibacterial Ethicon PLUS sutures he and his team uses – as ways to improve patient outcomes without having to drastically alter the way in which these surgeries are performed.Much of the success instead can come from small, incremental gains in the procedures, awareness and tools being utilised by surgeons.Listen to Ep 24. of NHE's Finger on the Pulse podcast with Giles Bond-Smith 

durée : 00:03:13 - Le mag auto de France Bleu Touraine - Quoi de neuf dans votre auto ? Notre expert va évoquer l'actualité de Porsche, une marque qui s'électrifie de plus en plus. Mais d'abord, il y a du neuf chez Volkswagen qui développe le châssis du futur…

Prinu Gabriel, MS, SM(ASCP), CIC and Kathleen Kohut, MS, BSN, RN, CIC will describe the financial and clinical burden of surgical site infections (SSIs) and bloodstream infections (BSI), review strategies and best practices to reduce the risk of SSIs and BSIs in the perioperative period and the intensive care unit (ICU), describe guidelines and recommended practices that support the strategies to reduce the risk of SSIs and BSIs, and discuss how patient decolonization with nasal povidone iodine contributes to best practice for reducing risk for the patient within the perioperative and ICU environments. To view program information/faculty disclosures and claim your CE credit after the session, visit centerforhealingsolutions.com/podcasts.

Today we talk about Surgical Site Infections. A common and largely preventable post-operative complication that needs to be recognised early and managed appropriately. Good sterile surgical technique and appropriate prophylaxis are key to preventing SSIs.

Allen Gabriel, MD, FACS will review historical evidence of impact of complications; review the evolution of incision management; and examine the latest technology to reduce SSIs, cases, tips and pearls. To view program information/faculty disclosures and claim your CE credit after the session, visit centerforhealingsolutions.com/podcasts.

Franklin Dexter, MD, PhD, FASA will describe the financial and clinical burden of surgical site infections (SSIs); review data from the randomized clinical trial on the effect of improving basic preventive measures in the perioperative arena on staphylococcus aureus transmission and surgical site infections; and describe how to measure S. aureus transmission and to choose operating rooms and specialties for such monitoring. To view program information/faculty disclosures and claim your CE credit after the session, visit centerforhealingsolutions.com/podcasts.

Chris Seferlis joins us to discuss the recent CosmosDB / Jupiter issue, Microsoft investing in Databricks, and handling SSIS to Azure Data Factory...Comment on Twitter or LinkedIn on which area you would like to see a deep dive!For more information on Aspirant, visit www.aspirant.comFollow Chris's YouTube channel HERE!Chris on Twitter HERE!Produced by Michael AskinsFor more information on Aspirant, visit www.aspirant.comAspirant on LinkedIn and FacebookFollow Aspirant on Twitter

Ravi Karia, MD will describe the negative impact of surgical site infections; examine technologies and techniques that help reduce SSIs and seromas; tips and pearls for successful outcomes in lower extremity surgery; review recent evidence examining the importance of using negative pressure therapy for incision and surrounding tissue management; and discuss case examples of outcomes associated with negative pressure therapy in complex lower extremity cases. To view program information/faculty disclosures and claim your CE credit after the session, visit centerforhealingsolutions.com/podcasts.

We didn't know what to expect when we sat down with Greg Beaumont, Senior Business Intelligence Specialist at Microsoft specializing in serving Microsoft's Healthcare space customers' technical Power BI issues.  What we got was an insightful, delightful, and impactful conversation with a really cool and smart human! References in this Episode: The Game Azure Health Bot The Future Will Be Decentralized-Charles Hoskinson Spider Goats Episode Timeline: 3:10 - The magic of discovery with the Power Platform, It's all about the customers(and Greg has a LOT of customers!), and Greg's Data Origin Story 21:10 - The IT/Business Gap, Getting good BI and keeping data security is a tricky thing, The COVID Challenge hits Healthcare 43:00 - Power BI-Not just a data visualization tool, a very cool discussion on Genomics and using data to save lives, the importance of Data Modelling 59:10 - The Bitcoin Analogy, The VertiPaq Engine and when is Direct Query the answer 1:08:30 - We get a little personal with Greg, Azure/Power BI integration and Machine Learning, Cognitive Services and Sentiment Analysis Episode Transcript: Rob Collie (00:00:00): Hello, friends. Today's guest is Greg Beaumont from Microsoft. Like one of our previous guests, hopefully, Greg has one of those interface jobs. The place where the broader Microsoft Corporation meets its customers at a very detailed and on the ground level. On one hand, it's one of those impossible jobs. More than 100 customers in the healthcare space look to Greg as their primary point of contact for all things technical, around Power BI. That's a tall order, folks. And at the same time, it's one of those awesome jobs. It's not that dissimilar, really, from our job here at P3. Rob Collie (00:00:45): In a role that, first of all, you get broad exposure to a tremendous number of organizations and their problems, you learn a lot super, super quickly. When you're doing it right, your work day is just nonstop magic. The power platform is magic and not really because of the technology, but instead because of its impact on the people who use it, who interact with it, who benefit from it, whose lives are changed by it. And again, I can't stress this enough, software usually doesn't do this. And as we talked with him, Krissy and I just couldn't stop nodding, because we could hear it, he lives it, just like we do. And I hope that just leaps out of the audio for you like it did for us. Rob Collie (00:01:32): No surprises here, Greg didn't start his life as a data professional. He's our second guest on this show, whose original training was in biology. And so, some familiar themes come back again, that good data professionals come from a wide variety of backgrounds, that the hybrid tweeners between IT and business are really where the value is at today. And I love this about Greg, that we made a point of talking about how much easier it is today to break into the data profession than it's ever been and what an amazing thing that is to celebrate. Rob Collie (00:02:06): We talked about COVID and specifically its impacts on the industry. How that has served as a catalyst for many organizations to rethink their analytic strategy, the implications of remote work, data privacy and security. And of course, it wouldn't be an episode of Raw Data, if we didn't nerd out about at least one thing. So, we get a little bit into genomics and the idea of DNA and RNA as forms of biological computer code. And as you'd expect, and want, Greg is far from a one dimensional data professional, just such an interesting person, authentically human, a real pleasure to speak with, so let's get into it. Announcer (00:02:47): Ladies and gentlemen, could I have your attention, please. Rob Collie (00:02:51): This is the Raw Data by P3 adaptive podcast with your host, Rob Collie. Find out what the experts at P3 Adaptive can do for your business. Just go to p3adaptive.com. Raw Data by P3 Adaptive is data with the human element. Rob Collie (00:03:13): Welcome to the show, Greg Beaumont. How are you? Greg Beaumont (00:03:17): I'm doing well. How are you all? Rob Collie (00:03:19): I think we're doing pretty well. Greg Beaumont (00:03:19): Awesome. Rob Collie (00:03:20): Business is booming. Data has turned out to be relatively hot field, but I think it's probably got some legs to it. And the Microsoft platform also, well, it's just kind of kicking ass, isn't it? So, business wise, we couldn't be better. I think personally, we're doing well, too. We won't go into all that. What are you up to these days? What's your job title and what's an average day look for you? Greg Beaumont (00:03:39): So, I'm working in Microsoft and my title is Technical Specialist. And I'm a Business Intelligence Technical Specialist, so I focus almost exclusively on Power BI and where it integrates with other products within the Microsoft stack. Now, I'm in the Microsoft field, which is different from a number of guests you've had, who work at corporate and we're working on the product groups, which is that I'm there to help the customers. Greg Beaumont (00:04:01): And you hear a lot of different acronyms with these titles. So, my role is often called the TS. In the past, it was called a TSP. It's just a change in the title. Sometimes you might hear the title, CSA, Cloud Solution Architect. It's very similar to what I do, but a little bit different. But effectively from an overarching standpoint, our goal in the field as Technical Specialists is to engage with customers, so that they understand how and where to use our products, and to ensure that they have a good experience when they succeed. Rob Collie (00:04:29): Your job is literally where the Microsoft organism meets the customers. Greg Beaumont (00:04:34): Yep. Rob Collie (00:04:35): That's not the role I had. I was definitely on the corporate side, back in my days at Microsoft. I think the interaction between the field and corporate has gotten a lot stronger over the years. I think it's a bit more organic, that interplay, that it used to feel like crossing a chasm sort of thing. And I don't think that's really true anymore. Greg Beaumont (00:04:54): At a green, I think that's by design, too. So, with the more frequent release schedules and also kind of how things have changed under Satya, customer feedback drives the roadmap. So when these monthly updates come out, a lot of it is based off of customer demand and what customers are encountering and what they need. So, we're able to pivot and meet the needs of those customers much more quickly. Rob Collie (00:05:15): Yeah, you mentioned the changing acronyms, right? I mean like yes. My gosh, a thousand times yes. It's almost like a deliberate obfuscation strategy. It's like who's what? Why did we need to take the P off of TSP? I mean, I'm sure it was really important in some meeting somewhere, but it's just like, "Oh, yeah, it's really hard to keep track of." It's just a perpetually moving target. But at the same time, so many fundamentals don't change, right? The things that customers need and the things that Microsoft needs to provide. The fundamentals, of course, evolving, but they don't move nearly as fast as the acronym game. Greg Beaumont (00:05:52): Right. I think that acronym game is part of what makes it difficult your first year here, because people have a conversation and you don't know what they're talking about. Right? Rob Collie (00:06:00): Yeah, yeah, yeah. Greg Beaumont (00:06:00): And if they just spelled it out, it would make a lot more sense. Rob Collie (00:06:03): Krissy was talking to me today about, "Am I understanding what Foo means?" There's an internal Microsoft dialect, right? Krissy was like, "Is Foo like X? Is it like a placeholder for variable?" I'm like, "Yes, yes." She's like, "Okay. That's what I thought, but I just want to make sure." Krissy Dyess (00:06:18): That's why there's context clues in grade school really come into play when you're working with Microsoft organization, because you really got to take in all the information and kind of decipher it a bit. And those context clues help out. Greg, how long have you been in that particular role? Has it been your whole time at Microsoft or are have you been in different roles? Greg Beaumont (00:06:36): So, I should add, too, that I'm specifically in the healthcare org, and even within healthcare, we've now subspecialized into sub-verticals within healthcare. So, I work exclusively with healthcare providers, so people who are providing care to patients in a patient care setting. I do help out on a few other accounts, too, but that's my primary area of responsibility. Greg Beaumont (00:06:55): So, I started with Microsoft in 2016. I was actually hired into a regional office as what's called the traditional TSP role and it was data platform TSP. So, it was what used to be the SQL Server TS role. A few months later, the annual realign happened, I got moved over to Modern Workplace because they wanted to have an increased focus on Power BI, and I had some experience in that area. Plus, I was the new guy, so they put me into the experimental role. A year later, that's when they added the industry verticals and that's when I moved into what is kind of the final iteration of my current role. And the titles have changed a few times, but I've effectively been in this role working with healthcare customers for over four years now. Rob Collie (00:07:35): And so, like a double vertical specialization? Greg Beaumont (00:07:37): Yeah. Rob Collie (00:07:37): Healthcare providers, where there's a hierarchy here? Greg Beaumont (00:07:40): Yeah, yeah. Rob Collie (00:07:41): Those are the jaw dropping things for me is sometimes people in roles like yours, even after all that specialization, you end up with a jillion customers that you're theoretically responsible for. Double digits, triple digits, single digits in terms of how many customers you have to cover? Greg Beaumont (00:07:58): I'm triple digits. And that is one of the key differences from that CSA role that you'll see on the Azure team is they tend to be more focused on just a couple of customers and they get more engaged in kind of projects. And I will do that with customers, but it's just, it's a lot more to manage. Rob Collie (00:08:14): Yeah. What a challenging job. If you think about it, the minimum triple digit number is 100, right? So, let's just say, it's 100 for a moment. Well, you've got 52 weeks a year plus PTO, right? So, you're just like, "Okay." It is very, very difficult to juggle. That's a professional skill that is uncommon. I would say that's probably harder than the acronym game. Greg Beaumont (00:08:37): Yeah, there's been times I was on a vacation day and I got a call. I didn't recognize the number. I'm like, "Okay, I'm going to have to route this to somebody because I'm off today." And they're like, "Well, I'm the VP of so and so and we need to do this." And I'm like, "Okay, I got to go back inside and work now, because this is an important call." So, you have to be flexible and you're correct, that it makes it a challenge to have that work-life balance also, but the work is very rewarding, so it's worth it. Rob Collie (00:09:01): Yeah. It's something that vaguely I have a sense of this. I mean, transitioning from corporate Microsoft to, I mean, you can think of my role now as field. I'm much, much closer to the customers than I ever was at corporate. And yes, Brian Jones and I talked about it a little bit. And this is a bit of an artifact of the old release model that it was like every few years, you'd release a product, which isn't the case anymore. But that satisfying feeling of helping people, like even if you build something amazing back at Microsoft in the days that I was there, you were never really around for that victory lap. You would never get that feedback. It even never make it to you. Rob Collie (00:09:37): It was years later muted whereas one of the beautiful things about working closely with customers and our clients with Power BI, and actually the Microsoft platform as a whole, is just how quickly you can deliver these amazingly transformational like light up moments that go beyond just the professional. You can get this emotional, really strong validating emotional feeling of having helped. And that is difficult to get, I think even today, probably, even with their monthly release cycles, et cetera. By definition, you're just further removed from the "Wow" that happens out where the people are. Greg Beaumont (00:10:15): Yep. And I'm sure you all see that, too, with your business is that a lot of work often goes into figuring out what needs to be in these solutions and reports, but when you actually put it in the hands of leaders, and they realize the power of what it can provide for their business, in my case for their patients, for their doctors, for their nurses, it becomes real. They see it's actually possible and it's not just a PowerPoint deck. Rob Collie (00:10:38): And that sense of possibility, that sense of almost child-like wonder that comes back at those moments, you just wouldn't expect from the outside. I had a family member one time say, "Oh, Rob, I could never do what you do." Basically, it was just saying "How boring it must be, right?" It's so boring working with software, working with..." I'm like, "Are you kidding me? This is one of the places in life where you get to create and just an amazingly magical." It's really the only word that comes close to capturing it. You just wouldn't expect that, right? Again, from the outside like, "Oh, you work in data all day. Boring." Greg Beaumont (00:11:17): I'd add to that, that I'd compare it to maybe the satisfaction people get out of when they beat a game or a video game. That when you figure out how to do a solution and it works and you put in that time and that effort and that thought, there's that emotional reward, you get that I built something that that actually did what they wanted it to do. Rob Collie (00:11:35): Yeah. And after you beat the video game, not only did that happen, but other people's lives get better as a result of you beating this game. It's just like it's got all those dynamics, and then some. All these follow on effects. Greg Beaumont (00:11:46): It's like being an athlete and enjoying the sport that you compete in. Rob Collie (00:11:50): Yeah. We're never going to retire. We're going to be the athletes that hang on way too long. Greg Beaumont (00:11:56): Yep. Rob Collie (00:11:58): So, unfortunately, I think our careers can go longer than a professional athletes, so there's that. I can't even really walk up and down stairs anymore without pain, so. So what about before Microsoft? What were you up to beforehand and how did you end up in this line of work in the first place? Greg Beaumont (00:12:15): Sure. And I think that's actually something where listeners can get some value, because the way I got into this line of work, I think today, there's much more opportunity for people all over the world from different socioeconomic backgrounds to be able to break into this field without having to kind of go through the rites of passage that people used to. So, I was actually a Biology major from a small school. Came from a military family. I didn't have corporate contacts or great guidance counseling or anything like that. My first job right out of school was I said, "Oh, I got a Biology major. I got a job at a research institution." They're like, "Okay, you're going to be cleaning out the mouse cages." And it was sort of $10.50 an hour. Greg Beaumont (00:12:53): So, at that point, I said, "Okay, I got to start thinking about a different line of work here." So, I kind of bounced around a little bit. I wanted to get into IT, but if you wanted to learn something like SQL Server, you couldn't do it unless you had a job in IT. As an average person, you couldn't just go buy a SQL Server and put it in your home unless you had the amount of money that you needed to do that. Side projects with Access and Excel. Small businesses did things probably making less than minimum wage and side gigs, in addition to what I was doing for full-time work to pay the bills. Eventually caught on with a hospital where I was doing some interesting projects with data using Access and Excel. They wouldn't even give me access to Crystal Reports when we wanted to do some reporting. That was really where I kind of said , "Data is where I want to focus." Greg Beaumont (00:13:41): We did some projects around things like Radon Awareness, so people who would build a new house now, they're like, "Oh, I have to pay $1500 for that Radon machine down in the basement." But when you talk to a thoracic surgeon and their nursing team and you hear stories about people who are nonsmokers, perfectly healthy, who come in with tumors all over their lungs, you realize the value there and by looking at the data of where there's pockets of radon in the country reaching out to those people has value, right? I think it's that human element where you're actually doing something that makes a difference. So, that kind of opened my eyes. Greg Beaumont (00:14:14): I then after that job, I got on with a small consulting company. I was a Project Manager. It was my first exposure to Microsoft BI. It was actually ProClarity over SQL Server 2005 and we were working with data around HEDIS and Joint Commission healthcare performance measures for one of the VA offices. So, I was the PM and the Data Architect was building the SSIS packages, built out kind of skeleton of an analysis services cube. He asked me to lean in on the dashboarding side, and that's also where I started learning MDX because we were writing some MDX expressions to start doing some calculations that we were then exposing in ProClarity. And at that point, it was like, "This is magic." Greg Beaumont (00:14:57): From a used case perspective, what they were doing traditionally doing was they'd send somebody in from some auditing agency, who would look at, I think it was 30 to 60 patient records, for each metric and then they take a look at where all of the criteria hit for that metric, yes or no. And it would be pass/fail, how good is this institution doing of meeting this particular expectation. So, it would be things like, "Does a patient receive aspirin within a certain amount of time that they've been admitted if they have heart problems?" Something like that. With looking at it from a data perspective, you can look at the whole patient population, and then you could start slicing and dicing it by department, by time of day that they were admitted, by all of these different things. Greg Beaumont (00:15:38): And that's when I kind of said, "This is really cool, really interesting. I think there's a big future here." And I kind of decided to take that route. And from there, I got on with a Microsoft partner, where I stayed for about six years. And that's kind of where I was exposed to a lot of very smart, very gifted people. And I was able to kind of learn from them and then that led to eventually getting a job at Microsoft. But to make a long story short, today, you could go online and get Power BI Desktop for free. There's training resources all over the place, and you could skill up and get started and get a great job. I'd like to tell people take the amount of time you spend every night playing video games and watching television, take half that time and devote it to learning Power BI and you'll be amazed at how far you get in six to 12 months. Rob Collie (00:16:24): That's such good advice. I'm not really allowed to play a lot of video games, so I might need more time than that. But I had my time to do that years ago, learning DAX and everything. A couple of things really jumped out at me there. First of all, you're right, it was almost like a priesthood before. It was so hard to get your foot in the door. Look, you had to climb incrementally, multiple steps in that story to just get to the point where you were sitting next to the thing that was SSIS and MDX which, again, neither of those things had a particularly humane learning curve. Even when you got there, which was a climb, you get to that point and then they're like, "And here's your cliff. Your smooth cliff that you have to scale. If you wanted a piece of this technology," right? Rob Collie (00:17:11): You wanted to learn MDX, you had to get your hands on an SSAS server. The license for it. And then you had to have a machine you could install it on that was beefy enough to handle it. It's just, there's so many barriers to entry. And the data gene, I like to talk about, it does. It cuts across every demographic, as far as I can tell, damn near equally everywhere. Let's call it one in 20. It's probably a little less frequent than that. Let's call it 5% of the population is carrying the data gene and you've got to get exposure. And that's a lot easier to get that exposure today than it was even 10 years ago. Greg Beaumont (00:17:50): I'd completely agree with that. The people in this field tend to be the type of people who likes solving puzzles, who like building things that are complex and have different pieces, but who also enjoy the reward of getting it to work at the end. You've had several guests that have come on the show that come from nontraditional backgrounds. But I'm convinced that 20 years ago, there were a lot of people who would have been great data people, who just never got the opportunity to make it happen. Greg Beaumont (00:18:14): Whereas today, the opportunity is there and I think Microsoft has done a great job with their strategy of letting you learn and try Power BI. You can go download the dashboard in a day content for free and the PDF is pretty self-explanatory and if you've used excel in the past, you can walk through it and teach yourself the tool. I think the power of that from both the perspective of giving people opportunity and also building up a workforce for this field of work is amazing. Rob Collie (00:18:42): Yeah. I mean, all those people that were sort of in a sense like kind of left behind, years ago, they weren't given an avenue. A large number of them did get soaked up by Excel. If they're professionally still active today, there's this tremendous population of Excel people if they were joining the story today, they might be jumping into Power BI almost from the beginning, potentially. And of course, if they were doing that, they'd still be doing Excel. But there's still this huge reservoir of people who are still tomorrow, think about the number of people tomorrow, just tomorrow. Today, they're good at Excel and tomorrow, they will sort of, they'll have their first discovery moment with Power BI. The first moment of DAX or M or whatever, that's a large number of people tomorrow who are about to experience. It's almost like did you see the movie The Game? Greg Beaumont (00:19:36): I have not. Rob Collie (00:19:37): There's this moment early in the movie where Michael Douglas has just found out that his brother or something has bought them a pass to the game. And no one will tell him what it is. He meets this guy at a bar who says, "Oh, I'm so envious that you get to play for the first time." Also, this is really silly, but it's also like the ACDC song For Those About To Rock, We Salute You. For those about to DAX, we salute you, because that's going to happen tomorrow, right? Such a population every day that's lighting up and what an exciting thing to think about. Do you ever get down for any reason, just stop and think, "Oh, what about the 5000 people today who are discovering this stuff for the first time." That is a happy thing. Greg Beaumont (00:20:16): Yeah, I actually had a customer where one of their analysts who turned out to be just a Power BI Rockstar, he said, "I'd been spending 20 years of my life writing V-lookups, and creating giant Excel files. And now, everything I was trying to do is at my fingertips," right? And then within a year, he went from being a lifelong Excel expert to creating these amazing reports that got visibility within the organization and provided a ton of value. Rob Collie (00:20:42): And that same person you're talking about is also incredibly steeped in business decision-making. They've been getting a business training their whole career at the same time. And it's like suddenly, you have this amazingly capable business tech hybrid, that literally, it just like moved mountains. It's crazy. We've talked about that a lot on the show, obviously, the hybrids, just amazing. And a lot of these people have come to work for us. Rob Collie (00:21:09): That's the most common origin story for our consultants. It's not the only one. I mean, we do have some people who came from more traditional IT backgrounds, but they're also hybrids. They understand business incredibly well. And so, they never really quite fit in on the pure IT side, either. It's really kind of interesting. Greg Beaumont (00:21:26): Yeah, I think there's still a gap there between IT and business, even in kind of the way solutions get architected in the field. It's understanding what the business really wants out of the tool is often very different from how IT understands to build it. And I think that's where people like that provide that bridge, to make things that actually work and then provide the value that's needed. Rob Collie (00:21:47): There's such valuable ambassadors. It's just so obvious when IT is going to interact with a business unit to help them achieve some goal. It's so obvious that, of course, who you need to engage with IT. IT thinks, "We need to engage with the leaders of this business unit." They've got the secret weapon, these hybrid people that came up through the ranks with Excel. The word shadow IT is perfect. These people within the business, like they've been Excel people for their entire careers, they have an IT style job. Rob Collie (00:22:22): Almost all the challenges that IT complains about with working with business, you take these Excel people and sort of put them in a room where they feel safe. They'll tell you the same things. They're like, "I had exactly the same problems with my 'users,' the people that I build things for." And yeah, there's such a good translator. And if the communication flows between IT and business sort of through that portal, things go so much better. That's a habit. We're still in the process of developing as a world. Greg Beaumont (00:22:51): Yeah. And in healthcare that actually also provides some unique challenges. With regulation and personal health information, these Excel files have sensitive data in them, and you have to make sure it's protected and that the right people can see it. And how do you give them the power to use their skills to improve your organization, while also making sure that you keep everything safe. So, I think that's a hot topic these days. Rob Collie (00:23:15): Yeah. I mean, it's one of those like a requirement, even of the Hello World equivalent of anything is that you right off the bat have to have things like row level security and object level security in place and sometimes obfuscation. What are some of the... we don't want to get to shop talky, but it is a really fascinating topic, what are the handful of go-to techniques for managing sensitive healthcare information? How do you get good BI, while at the same time protecting identity and sensitivity. So often, you still need to be able to uniquely identify patients to tie them across different systems, can identify them as people. It's really, really, really tricky stuff. Greg Beaumont (00:24:02): And I think just to kind of stress the importance of this, you can actually go search for look up HIPAA wall of shame or HIPAA violation list. When this information gets shared with the wrong people, there's consequences and can result in financial fees and fines. And in addition to that, you lose the trust of people whose personal information may have been violated. So, I think a combination of you said things row level security and object level security as a start, you can also do data masking, but then there's issues of people export to Excel. What do they do with that data afterwards? Greg Beaumont (00:24:37): And then there's going to be tools like Microsoft Information Protection, where when you export sensitive information to Excel, it attaches an encrypted component. I'm not an MIT expert. I know how it works. I don't know the actual technology behind it. But it attaches an encrypted component where only people who are allowed to see that information can then open that file. So, you're protecting the information at the source and in transit, but you're still giving people the flexibility to go build a report or to potentially use data from different sources, but then have it be protected every step of the way. Greg Beaumont (00:25:11): So like you said, without getting too techie, there's ways to do it, but it's not just out of the box easy. There's steps you have to go through, talk to experts, get advice. Whether it's workshops or proof of concepts, there's different ways that customers can figure that out. Rob Collie (00:25:28): Yeah. So because of that sort of mandatory minimum level of sensitivity handling and information security, I would expect, now that we're talking about it, that IT sort of has to be a lot more involved by default in the healthcare space with the solutions than IT would necessarily be in other industries. Another way to say it, it's harder for the business to be 100% in charge of data modeling in healthcare than it is in other industries. Greg Beaumont (00:26:02): Yep. But you can have a hybrid model, which is where the business provides data that's already been vetted and protected and there might be other data that doesn't have any sensitive data in it, where it's game on, supply chain or something like that. But having these layers in between, the old way of doing things was just nobody gets access to it. Then there was kind of canned reporting where everybody gets burst in the reports that contain what they're allowed to see. But now, you can do things in transit, so that the end users can still use filters and build a new report and maybe even share it with other people. And know that whoever they're sharing with will only be able to see what they're allowed to see. It gets pretty complex, but it's definitely doable and the customers that are doing it are finding a lot of value in those capabilities. Rob Collie (00:26:48): That's fundamentally one of the advantages of having a data model. I was listening to a podcast with Jeffrey Wang from Microsoft and he was talking about it. And I thought this was a really crisp and concise summary, which is that the Microsoft Stack Power BI has a model-centric approach to the world whereas basically, all the competitors are report centric. And what does that mean? Why does that even make a difference? Well, when you build a model, you've essentially built all the reports in a way. You've enabled all of the reports. You can build many, many, many, many, many like an infinite number of different reports based on emerging and evolving business needs without having to go back to square one. Rob Collie (00:27:28): In a report-centric model, which is basically what the industry has almost always had, almost everywhere, outside of a few notable examples, Power BI being one of them. When a report centric model, every single change, I remember there being a statistic that was just jaw dropping. I forget what the actual numbers were, but it was something like the average number of business days it took to add a single column to a single existing report. It was like nine business days, when it should just be a click. And that's the difference. And so, preserving that benefit of this model centric approach, while at the same time, still making sure that everyone's playing within the right sandbox that you can't jump the fence and end up with something that's inappropriate. Very challenging, but doable. Greg Beaumont (00:28:15): Yep. That reminded me of an old joke we used to tell in consulting and this was back in the SharePoint Performance Point with Analysis Services days is there be a budget for a project, there'd be change requests along the ways, they discover issues with the data. And at the very end of the project, they rushed the visualization to market. And they're like after six months, with 10 people dedicated on this project, "Here's your line chart." Rob Collie (00:28:39): Yeah. I had a director of IT at a large insurance company one time, looking me in the eye and just brutally confess. Yeah, my team, we spent three months to put a dot on a chart. And that's not what you want. Greg Beaumont (00:28:59): Right, right. Rob Collie (00:29:01): That was unspoken. This was bad. To the extent that you're able to tell, what are some of the interesting things that you've seen in the healthcare space with this platform recently? Anything that we can talk about? Greg Beaumont (00:29:15): Yeah, so I think I'd start with how everything changed with COVID. Just because I think people would be interested in that topic and kind of how it changed everything. I actually had a customer yesterday at a large provider who said, "COVID was the catalyst for us to reconsider our investment in analytics, and that it spurred interest from even an executive level to put more money into analytics because of the things that happened." So obviously, when it hit everybody was, "What in the world is going on here?" Right? "Are we even going to have jobs? Is the whole world going to collapse or is this just going to be kind of fake news that comes and goes?" Everybody was unsure what was going on. Greg Beaumont (00:29:50): At the same time, the healthcare providers, a lot of them were moving people to work from home and these were organizations where they had very strict working conditions because of these data privacy and data security considerations, and all of a sudden, you're in a rush to move people home. So, some of my counterparts who do teams, they have some just amazing stories. They were up all night helping people set up ways to securely get their employees to a work-from-home type experience, so that they only had essential workers interacting with the patients, but then the office workers were able to effectively conduct business from home. Greg Beaumont (00:30:25): Additionally, there were use cases that were amazing. So, Microsoft has now what's called the Cloud for Health where we're effectively taking our technology and trying to make it more targeted towards healthcare customers and their specific needs, because we see the same types of use cases repeat from customer to customer. One of those use cases that came out of COVID was called Virtual Visits. And I actually know the team that built that solution, but because of patients who were on COVID, they didn't know how contagious it was. Greg Beaumont (00:30:56): There were people being put on ventilators, who weren't allowed to see their families and they were setting up a team's application, where people were actually able to talk to their family and see their family before they went under, right? There were chaplains who were reading people their last rites using video conferencing, and things like that. So, it was pretty heavy stuff, but I think from a healthcare perspective, it showed the value technology can provide. Greg Beaumont (00:31:21): And from our perspective in the field, it's like we're not just out there talking about bits and bytes. It kind of hit home that there's real people who are impacted by what we're doing and it adds another kind of layer of gravity, I'd call it, taking what you do seriously, right? I had another customer, they were doing some mapping initiatives with some of the COVID data because they wanted to provide maps for their employees of where the hotspots were. Greg Beaumont (00:31:46): And we were up till I think 11:00 at night one night working through a proof of concept. And they said, "Yeah, what's next is we also want to start mapping areas of social unrest." I said, "Wow, social unrest. Why are you worried about that?" And they said, "Well, we expect because of this lockdown, that eventually there's going to be rioting and issues in all different parts of the world." And at that time, I just kind of didn't really think about that, but then a lot of those things did happen. It was kind of just interesting to be working at night and hearing those stories, and then seeing how everything kind of unfolded. Greg Beaumont (00:32:18): Another example, look it up, there's an Azure COVID Health Bot out there and then there's some information on that, where you can ask questions and walk through your symptoms, and it will kind of give you some instructions on what to do. Another one that is even popular now is looking at employees who are returning to work. So, when people return to work find out vaccination status, "Are you able to come back to work? Are you essential? Are you nonessential?" I don't think a lot of customers were prepared to run through that scenario when it hit. Greg Beaumont (00:32:48): So, having these agile tools where you can go get your list of not only employees, but maybe partners that refer people to your network, because you might not have all the referring doctors in your system. So with Power BI, you can go get extracts, tie it all together and then build out a solution that helps you get those things done. I'd say it was eye opening. I think for customers and also for myself and my peers, that we're not just selling widgets. We're selling things that make a difference and have that human perspective to it. Rob Collie (00:33:20): Yeah, that does bring it home, doesn't it? That statement from an organization that COVID was the catalyst, evaluating and investing in their analytic strategy? Greg Beaumont (00:33:29): Yep. Rob Collie (00:33:30): Being in BI, being an analytics is one of the best ways to future proof one's career because at baseline, it's a healthy industry, there's always value to be created. But then when things get bad, for some reason, whatever crisis hits, it's actually more necessary than ever because when you've been in a groove when a an industry or an organization has been in an operational groove for a long time, any number of years, eventually, you just sort of start to intuitively figure it out. There's a roadmap that emerges slowly over time. Now, even that roadmap probably isn't as good as you think it is. If you really tested your assumptions, you'd find that some of them were flawed and analytics could have helped you be a lot more efficient even then. Rob Collie (00:34:14): But regardless, the perception is that we've got a groove, right? And then when the world completely changes overnight, all of your roadmaps, your travel roadmaps, none of them are valid anymore. And now, you need a replacement and you need it fast. And so, what happens is, is that analytics spending, BI spending, whatever you want to call it, or activity, actually increases during times of crisis. So, you got a healthy baseline business. It's an industry that's not withering and dying in good times, but it actually it's like a hedge against bad times. Rob Collie (00:34:47): When I saw that research years and years ago, when I was working at Microsoft Corporate, we just come out of the dot-com crack up, we'd seen that BI spending it across the IT industry was the only sector that went up during that time where everything else was falling. It's like, "Oh, okay." So, not only do I enjoy this stuff, but I really should never get out of it. It's like one of the best future proofing career moves you can make is the work in this field. And so, I mean, we've seen it, right? The early days of the COVID crisis, you're right when no one knew the range of possible outcomes going forward was incredibly wide. The low end and the high end were exponentially different from one another. Rob Collie (00:35:29): And so, we experienced in our business, sort of a gap in spring and early summer last year. We weren't really seeing a whole lot of new clients, people who are willing to forge a brand new relationship. Again, what happens when a crisis hits? You slam on the brakes. No unnecessary spending first of all. Let's get all the spending under control, because we don't know as a company what's going to happen in the industry, right? You see a lot of vendor spending freezes and of course, to other companies, we're a vendor, right? So, our existing clients, though, doubled down on how much they used us and how much they needed us. Rob Collie (00:36:08): And then later in the year, the new client business returned, and we actually ended up, our business was up last year, despite that Q2 interruption and sort of making new friends. And this year, holy cow like whatever was bottled up last year is coming back big time. And so, yeah. You never really want to be the ghoul that sort of morbidly goes, "Oh, crisis." From a business perspective, yeah, anything that changes, anything that disrupts the status quo tends to lead to an increased focus on the things that we do. Greg Beaumont (00:36:43): Yeah, I think something you said there, too, was when you don't know what's going to happen was when the business intelligence spending increased. I mean, the intelligence and business intelligence, it's not just a slogan. The purpose of these tools is to find out the things you don't know. So when there's uncertainty, that's when BI can provide that catalyst to sort of add some clarity to what you're actually dealing with. Rob Collie (00:37:06): Yeah, I've been using, even though I'm not a pilot, I've never learned to fly a plane or anything. I've been using an aviation metaphor lately, which is windshield is nice and clear. You might not be looking at the instruments on your cockpit very much, right? You know there's not a mountain in front of you, you can see how far away the ground is. And you could sort of intuit your way along, right? But then suddenly, whoosh clouds. And oh, boy, now, you really need those instruments, right? You need the dashboards, you need the altimeter, you need the radar. You need all that stuff so much more. Rob Collie (00:37:37): And so, and our business has kind of always been this. The reason I've been using this metaphor is really for us, it's like given how fast we operate, and I think you can appreciate this having come from a Microsoft partner consulting firm before Microsoft years ago, our business model, we move so fast with projects. We're not on that old model with the original budget and the change orders and all of that. That was all dysfunctional. Rob Collie (00:38:01): It was necessary, because of the way software worked back then, but it was absolutely dysfunctional. It's not the way that you get customer satisfaction. So, we've committed to the high velocity model. But that means seeing the future of our business financially two months in the future is very difficult relative to the old sort of glacial pace, right? If there's a mountain there, we're going to have months to turn around it. Krissy Dyess (00:38:26): To add a bit to your analogy there, Rob. I am married to a pilot and I have gone up in the small tiny airplane. And before the gadgets, there's actually the map. The paper map, right? So, you had the paper map, which my husband now would hand to me. And he'd tell me, "Okay, let me know the elevations of different areas to make sure we're high enough, we're not going to crash into the mountains." Krissy Dyess (00:38:47): What's happened is people just they got used to different ways that they were doing things. They were forced into these more modern ways. And I think even now, this wave of seeing this catalyst we can change and how are other people changing is also driving the people to seek help from others in terms of getting guidance, right? Because even though you've had the change, it doesn't necessarily mean that the changes that you made were 100% the right way and you can learn so much from others in the community and the people that are willing to help. Krissy Dyess (00:39:24): And I think that's one of the things too, that our company provides as a partner, we're able to kind of go alongside. We've seen what's works, what doesn't work, what are some of those pitfalls? What are those mountains approaching? And we're really able to help guide others that want to learn and become better. Rob Collie (00:39:42): Yeah. I mean, this is us getting just a little bit commercial, but you can forgive us, right? That high velocity model also exposes us to a much larger denominator. We see a lot at this business that accumulates. The example I've given before is and this is just a really specific techy, so much of this is qualitative, but there's a quantitative. It's sort of like a hard example of like, "Oh, yeah, that's right. This pattern that we need here for this food spoilage inventory problem is exactly the same as this tax accounting problem we solved over there, right?" As soon as you realize that you don't need to do all the figuring out development work, you just skip to the end. Rob Collie (00:40:22): And really, most of the stuff that Krissy was talking about, I think, is actually it's more of the softer stuff. It's more of the soft wisdom that accumulates over the course of exposure to so many different industries and so many different projects. That's actually really one of the reasons why people come to work here is they want that enrichment. Greg Beaumont (00:40:38): Yeah, that makes sense. Because you see all these different industries and you actually get exposed to customers that are the best in the business for that type of, whether it be a solution or whether it be a product or whether it be like a framework for doing analytics or something like that. So, you get that exposure and you also get to contribute. Rob Collie (00:40:55): Even just speaking for myself, in the early days of this business, when it was really still just me, I got exposure to so many business leaders. Business and IT leaders that, especially given the profile of the people who would take the risk back in 2013, you had to be some kind of exceptional to be leaning into this technology with your own personal and professional reputation eight years ago, right? It was brand new. So, imagine the profile of the people I was getting exposed to, right? Wow, I learned so much from those people in terms of leadership, in terms of business. They were learning data stuff from me, but at the same time, I was taking notes. Greg Beaumont (00:41:33): Everybody was reading your blog, too. I can't count the number of times I included a reference to one of your articles to help answer some questions. And it was the first time I was introduced to the Switch True DAX statement. And then I'd print that. Rob Collie (00:41:47): Which- Greg Beaumont (00:41:48): Sent that link to many people. "Don't do if statements, do this. Just read this article." Rob Collie (00:41:53): And even that was something that I'd saw someone else doing. And I was like, "Oh, my God, what is that?" My head exploded like, "Oh." Yeah, those were interesting days. I think on the Chandu podcast, I talked about how I was writing about this stuff almost violently, couldn't help it. It was just like so fast. Two articles a week. I was doing two a week for years. There was so much to talk about, so many new discoveries. It was just kind of pouring out in a way. Krissy Dyess (00:42:24): Greg, you came in to the role around 2016. And to me 2017 was really that big year with the monthly releases where Power BI just became this phenomenon, right? It just kept getting better and better in terms of capabilities and even the last couple years, all the attention around security has been huge, especially with the health and life science space. And last year, with this catalyst to shift mindsets into other patterns, working patterns using technology, do you feel like you've seen any kind of significant shifts just compared to last year or this year? Greg Beaumont (00:43:05): Yeah. And so something that burns my ears every time I hear it is when people call Power BI a data visualization tool. It does that and it does a great job. Rob Collie (00:43:11): I hate that. Greg Beaumont (00:43:12): But it's become much more than that. When it launched, it was a data visualization tool. But if you think about it at that time, they said, "Well, business users can't understand complex data models, so you have to do that in analysis services." Then they kind of ingested analysis services into Power BI and made it more of a SaaS product where you can scale it. There's Dataflows, the ETL tool, which is within Power BI, which is an iteration of Power Query, which has been around since the Excel days. So, now you have ETL. You have effectively from the old SQL Server world, you have the SSIS layer, you have the SSAS layer. With paginated reports, you have the SSRS layer. And you have all these different layers of the solution now within an easy to use SaaS product. Greg Beaumont (00:43:55): So this evolution has been happening, where it's gobbling up these other products that used to be something that only central IT could do. And now, we're putting that power by making it easier to use in the hands of those analysts who really know what they want from the data. Because if you think about it, the old process was is you go and you give the IT team your requirements, and they interpret how to take what you want, and translate it into computer code. Greg Beaumont (00:44:21): But now, we're giving those analysts the ability to take their requirements and go do it themselves. And there's still a very valid place for central IT because there's so many other things they can do, but it frees up their time to work on higher valued projects and I see that continuing with Power BI, right? But like we're adding AI, ML capabilities and data volumes keep increasing then capabilities I think will continue to expand it. Rob Collie (00:44:46): Greg, I used to really caused a storm when I would go to a conference that was full of BI professionals. And I would say that something like, "What percentage of the time of BI project, traditional BI project was actually spent typing the right code?" The code that stuck, right? And I would make the claim that it was less than 1%. So, it's like less than 1% of the time of a project, right? And everyone would just get so upset at me, right? But I just didn't understand why it was controversial. Rob Collie (00:45:19): Like you describe like yeah, we have these long requirements meetings in the old model. Interminably long, exhausting, and we'd write everything down. We'd come up with this gigantic requirements document that was flawed from the get-go. It was just so painful. It's like the communication cost was everything and the iteration and discovery, there wasn't enough time for that. And when I say that the new way of building these projects is sometimes literally 100 times faster than the old way. Like it sounds like hyperbole. Greg Beaumont (00:45:53): It's not. Yeah. Rob Collie (00:45:54): It can be that fast, but you're better off telling people, it's twice as fast because they'll believe you. If you tell them the truth, they'd go, "Nah, you're a snake oil salesman. Get out of here." Greg Beaumont (00:46:07): Yeah. And I think the speed of being able to develop, too, it's going to basically allow these tools to be able to do things that people didn't even dream of in the past. It's not just going to be traditional business use cases. I know in healthcare, something that's a hot topic is genomics, right? Genomics is incredibly complex then you go beyond Power BI and into Azure at that point, too and Cloud compute and things like that. Greg Beaumont (00:46:31): So, with Genomics, you think about your DNA, right? Your DNA is basically a long strand of computer code. It is base pairs of nucleic acids, adenine, thymine, and guanine, cytosine that effectively form ones and zeros in a really long string. Rob Collie (00:46:46): Did you know it effortlessly he named those base pairs? There's that biology background peeking back out. Greg Beaumont (00:46:52): I did have to go look it up before the meeting. I said, "Just in case this comes up, I need to make sure I pronounce them right," so. Rob Collie (00:46:59): Well, for those of us who listen to podcasts at 1.5x speed, that is going to sound super impressive, that string there. Greg Beaumont (00:47:05): Yeah. I should call out, too, though that I'm not a genomics expert, so some of what I'm saying here, I'm paraphrasing and repeating from people I've talked to who are experts, including physicians and researchers. So, this long string of code, if you sequence your entire genome, the file is about 100 gigabytes for one person, okay? At 100 gigabytes, you can consume that, but if you want to start comparing hundreds of people and thousands of people in different patient cohorts, all of a sudden, it gets to be a lot of information and it gets very complex. Greg Beaumont (00:47:35): If you think of that strand of DNA as being like a book with just two letters that alternate, there's going to be paragraphs and chapters and things like that, which do different things. So, one of the physicians I spoke to worked with Children's Cancer. Here's kind of where the use case comes in. So, you take something breast cancer where there's BRCA1 or BRCA2, BRCA1, BRCA2 genes where if you have it, there's a measurable increased probability that you'll get that type of cancer within a certain age range. There's a lot of other diseases and cancers, where it might be 30 genes. And depending on different combinations of those genes, it changes the risk of getting that specific type of cancer. Greg Beaumont (00:48:17): But this physician told me that there are specific children's cancers, where they know that if they have certain combinations of genes, that they have a very high probability of getting this cancer. And when the child actually feel sick and goes to the doctor, it's already spread and it's too late. So, if you can do this sequencing, basically run it through machine learning algorithms, so it will determine the probability, you could effectively catch it at stage zero. Because these cancers, it's something that could be related to growth hormones and as you're growing up, and as you become an adult, you're then no longer at risk of getting that childhood cancer. So, if they could identify it early and treated at stage zero, instead of stage 4, it sounds sci-fi, but the tools are there to do it. Greg Beaumont (00:49:01): It just never ceases to amaze me that you watch the news and they talk about self-driving cars and identifying when a banana is ripe, and things like that. But it's like, you know what? These same tools could be out there changing people's lives and making a measurable difference in the world. I think just especially post COVID, I'll expect to see a lot more investment in these areas. And also, interest because I think that might be one of the positives that comes out of this whole experience. Rob Collie (00:49:27): I do think that the sort of the worlds of Medicine and Computer Science are on a merging course. Let's not call it collision course. That sounds more dramatic. There is a merging going on. You're right DNA is biologically encoded instructions by an RNA. The mRNA vaccine is essentially injecting the source code that your body then compiles into antibodies. It's crazy and it's new. There's no two ways about it. Rob Collie (00:49:56): mRNA therapies, in general, which of course they were working on originally as anticancer and sort of just like, "Oh, well, we could use it for this, too." And there's all kinds of other things too, right? Gosh, when you go one level up from DNA or some point of abstraction, you get into protein folding. And whoa, is that... Greg Beaumont (00:50:15): Crazy, yeah. Rob Collie (00:50:16): ... computationally. We're all just waiting for quantum computers, I think. Greg Beaumont (00:50:20): Now, I'll have to call out that I'm making a joke here, so people don't take me seriously. But if you think about it, the nucleus in each of your cells contains an important model of that DNA, right? There isn't just a central repository that everything communicates with. You have a cache of that DNA in every cell in your body, except red blood cells, which perform a specific task. There may be more of the power automated the human body. But cheap attempt at a joke there, so. Rob Collie (00:50:44): Well, I like it, I like it. Let's go in with both feet. I've also read that one of the reasons why it's difficult to clone adult animals is because you start off with your original DNA, but then you're actually making firmware updates to certain sections of the DNA throughout your life. And so, those edits that are being made all the time are inappropriate for an embryo. Greg Beaumont (00:51:09): Yep. Rob Collie (00:51:10): And so, if you clone, you create an embryo, right? And now, it's got these weird adult things going on in it. That's why things kind of tend to go sideways. It can all come back to this notion of biological code and it's fascinating. A little terrifying, too, when you start to think of it that way. I've listened to some very scary podcasts about the potential for do-it-yourself bioweapon development. There was this explosion back, in what, in the '90s when the virus and worm writers discovered VVA. Remember that? We call them the script kiddies that would author these viruses that would spread throughout the computer systems of the world. And a lot of them, the people writing these things were not very sophisticated. They weren't world renowned hackers. Greg Beaumont (00:51:53): For every instance where you can use this technology to cure cancer, you're right that there's also the possibility of the Island of Dr. Moreau, right? You go look up CRISPR Technology, C-R-I-S-P-R, where they can start splicing together things from different places and making it viable. And 10 years ago, they had sheep that were producing spider webs in their milk and it's just, there's crazy stuff out there if you kind of dive into the dark depths of Biology. Now that we went down the rabbit hole, how do we correct course, right? Rob Collie (00:52:23): Well, we did go down a rabbit hole, but who cares? That's what we do. Greg Beaumont (00:52:26): Even you kind of step it back up to just kind of easy use cases in healthcare, so one of the ones that we use as a demo a lot came from a customer, and this was pre-COVID. But something as simple as hand washing, you don't think about it much. But when you're in the hospital, how many of those people are washing their hands appropriately when they care for you. And there's some white papers out there, which are showing that basically, there are measurable amounts of infections that happen in hospitals due to people not washing their hands appropriately. So, a lot of healthcare organizations will anonymously kind of observe people periodically to see who's doing a good job of washing their hands. Rob Collie (00:53:04): I was going to ask, how is this data collected? Greg Beaumont (00:53:06): This customer actually had nurses who were using a clipboard and they would write down their notes, fax it somewhere, and then somebody would enter it into Excel. So, there was this long process. And with another TS, who covers teams, we basically put a PLC together in a couple days, where they enter the information into a power app within teams, so they made their observation, entered it in. It did a write back straight to an Azure SQL Database at that time. Now, they might use the data verse. And then from Azure SQL DB, you can immediately report on it and Power BI. It even set up alerts, so that if somebody wasn't doing a good job, you could kind of take care of the situation, rather than wait for two days for the Excel report to get emailed out, and maybe lower the infection rates in the hospital. Greg Beaumont (00:53:53): So, it saved time from the workers who are writing things down and faxing things just from a sheer productivity perspective. But it also hopefully, I don't know if it will be measurable or not, but you'd have some anticipated increase in quality, because you're able to address issues faster. And that's the simplest thing ever, right? You can spend a billion dollars to come up with a new drug or you can just make sure are people washing their hands. Rob Collie (00:54:17): Both data collection and enforcement, they happen to be probably the same thing. There's like, "Oh, I'm being watched." The anonymity is gone. That's a fascinating story. Okay. What kinds of solutions are you seeing these days? What's happening out in the world that you think is worth talking to the audience about? Greg Beaumont (00:54:38): We're seeing this ability to execute better where the tools are easier to use, you can do things faster, but there's still challenges that I see frequently out there. So, I know something that you all are experts in its data modeling and understanding how to take a business problem and translate it into something that's going to perform well. So, not only do you get the logic right, but when somebody pushes a button they don't have to go to lunch and come back, they get a result quickly. That's still a challenge. And it's a challenge, because it's not always easy, right? I mean, it's the reason cubes were created in the first place was because when you have complex logic and you're going against a relational database, the query has to happen somewhere, but like that logic. Greg Beaumont (00:55:19): So take for example, if somebody wants to look at year over year percent change for a metric and they want to be able to slice it by department, maybe by disease group, maybe by weekend versus weekday, and then they want to see that trend over time. If you translate that into a SQL query, it gets really gnarly really fast. And that problem is still real. One of the trends I'm seeing in the industry is there's a big push to do everything in DirectQuery mode, because then you can kind of manage access, manage security, do all of those necessary security things in one place and have it exist in one place. Greg Beaumont (00:56:00): But when you're sending giant gnarly SQL queries back to relational databases, even if they're PDWs with multiple nodes, it gets very expensive from a compute perspective, and kind of when you scale out to large number of users, concurrency is still an issue. So that's something where you look at recently what Power BI has come out with aggregations and composite models. That's some of the technology that I think can mitigate some of those problems. And even if we think about something like Azure synapse, right? You can have your dedicated SQL pools then you can have a materialized view. A materialized view is effectively a cache of data within synapse, but then you can also have your caches in Power BI, and kind of layer everything together in a way that's going to take that logic and distribute it. Greg Beaumont (00:56:46): Does that make sense? Rob Collie (00:56:47): It does. I think this is still a current joke. The majority of cases where we've encountered people who think they want or need DirectQuery, the majority of them are actually perfect poster children case studies for when you should use cash and import mode. Right? It turns out the perceived need for DirectQuery, there is a real percentage of problems out there for which DirectQuery is the appropriate solution and it is the best solution. But it's the number of times people use it is a multiple of that real ideal number. Rob Collie (00:57:17): I think part of it is just familiarity. Still, I've long talked about how we're still experiencing as an industry the hangover from most data professionals being storage professionals. Everyone needed a database, just to make the wheels go round. The first use of data isn't BI. The first use of data is line of business applications. Every line of business application needed a database, right? So, we have minted millions of database professionals. this is also why I think partly why Power BI gets sort of erroneously pigeonholed as a visualization tools, because people are used to that. They're used to, we have a storage layer and reports layer, that's it, right? Rob Collie (00:57:56): Reporting services was Microsoft's runaway successful product in this space. Paginated reports is still around for good reason. And I think that if you're a long-term professional in this space with a long history, even if you're relatively young in the industry, but you've been working with other platforms, this storage layer plus visuals layer is just burned in your brain. And this idea of this like, "Why do you need to import the data? Why do you need a schedule? Why do you need all this stuff?" It's like as soon as people hear that they can skip it, and go to DirectQuery, they just run to

Surgical site infections (SSIs) are persistent and challenging, no more so than following the COVID-19 outbreak. Now that elective surgeries are ramping up again, it is more important than ever to prevent SSIs, and that is the focus for this episode in our series addressing HACs.   Guest speaker: Richard Beaver, B.S. Chem, MBB, CPHQ Senior Consulting Director Vizient   Moderator: Tomas Villanueva, DO, MBA, FACPE, SFHM Principal Clinical Operations and Quality Vizient   Show Notes: [00:36] The upsurge in sepsis [02:25] Limited SSI improvement in some cases [03:39] A combination of causes [04:50] Lack of compliance [05:59] Prophylactic antibiotics [08:35] Chlorhexidine [10:33] Accurate metrics and analysis for key drivers of improvement [11:35] 360-degree approach   Links | Resources: Rick Beaver's contact email: richard.beaver@vizientinc.com CMS Hospital-Acquired Condition (HAC) fact sheet Click here CMS Hospital-Acquired Condition (HAC) reduction program Click here Information on Vizient's Clinical Data Base (CDB) Click here AHRQ tools to reduce HACs Click here   Subscribe Today! Apple Podcasts Spotify Android Google Podcasts Stitcher RSS Feed  

The Power Query Magic YouTube version is available here... https://youtu.be/OKKAwlUIUW4 Reza Rad is a flamenco guitar playing Power BI community "stalwart". Look up the definition of the word "stalwart" and you'll find something like this "a dedicated, reliable, and hard-working supporter of an organization or team" .  This is Reza, he contributes to the Power BI community in so many ways I question when he has time to sleep! Reza was one of the first to blog about the early versions of Power BI, we touch on SSIS and discuss what a "Microsoft Regional Director" role involves - it's not what you'd think.   Links:   Website: Home - RADACAD Most Popular Article https://radacad.com/append-vs-merge-in-power-bi-and-power-query Favourite Articles: https://radacad.com/grouping-in-power-query-getting-the-last-item-in-each-group

"Həssas əhali qruplarından olan şəxslər üçün sığınacaq və sosial reabilitasiya müəssisəsi yarım il ərzində 193 nəfər şəxsə sosial xidmət göstərib".

AACAP President Gabrielle A. Carlson, MD, speaks with Assistant Professor in the Department of Psychology and Clinical Psychology PhD Program at Stony Brook University, Jessica L. Schleider, PhD,  about single-session interventions (SSIs) for youth mental health, the state of evidence around SSIs, and recent research findings.

Geeks on Screens with Coffee Episode 59 - BiML Queen Look who I bumped into at the water cooler/tea room/corridor? It's only Cathrine Wilhelmsen (@cathrinew ) Bio: Cathrine loves teaching and sharing knowledge. She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Warehousing, Data Integration, Analytics, and Reporting projects. Her core skills are Azure Data Factory, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she's active in the SQL Server community as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer. I must dash, the kettle has almost boiled. Love you! Youtube: https://youtu.be/F6fJDOb4xz8

Abstract of the talk… Are you a seasoned T-SQL developer, used to solve each and every challenge by writing plain old SQL? But, now you need to leverage data coming from semi-structured or unstructured sources? What if I tell you that you can get your mission accomplished by writing your favorite T-SQL syntax? In this session, you will learn what is a Serverless SQL pool within Azure Synapse Analytics, how it works behind the scenes, and how can you preserve your "T-SQL Ninja" status even when dealing with the data coming from CSV and Parquet files, or from NoSQL database. Bio… I'm making music from the data! PowerBI and SQLServer addict, MCT, Pluralsight Author, blogger, speaker...Interested in everything related to data - always eager to extract valuable info from raw data in the most effective way. Multi-year experience working with (predominantly) Microsoft Data Platform (SQL Server, SSAS, SSIS, SSRS, and Power BI). Father of 2 and true football (and Barca) fan!

Tövlədə bağlanılaraq saxlanılan Gədəbəyin İvanovka kəndinin sakini, 1934-cü il təvəllüdlü Səkinə Həsənova Sosial Xidmətlər Agentliyinin müvafiq müəssisəsinə yerləşdirilib.

Gədəbəy rayonunun Nova İvanovka kəndində ahıl qadının şiddət görməsi ilə bağlı Kəmalə Ağazadə tərəfindən paylaşılan görüntülər dərhal Sosial Xidmətlər Agentliyi tərəfindən nəzarətə götürülüb və araşdırılıb.

Richard C. Prielipp, MD, MBA, FCCM will explain the process for assessing the surgical patient for infection risk(s) during the preoperative phase; identify important strategies implemented in the preoperative phase to reduce risk of SSIs; describe preoperative patient education for preventing SSIs; and summarize the responsibilities of the preoperative team to implement surgical care strategies and reduce risk. To view program information/faculty disclosures and claim your CE credit after the session, visit centerforhealingsolutions.com/podcasts.

Kyle Mueller, MD and David M. Shapiro, MD, CHC, CHCQM, CHPRM, LHRM, CASC will recognize the clinical and economic burden of surgical site complications and surgical site infections (SSIs); review the importance of pre-, intra-, and postoperative management strategies & best practices to reduce the risk of SSIs; explain unintended perioperative hypothermia, and illustrate why prewarming is beneficial in the prevention of unintended perioperative hypothermia; examine the role of closed incision negative pressure wound therapy (ciNPT) for Incision and Surrounding Soft Tissue Management to help reduce the risk of surgical site complications, hospital readmissions & post-op follow-up appointments; and explore, via cases, best practices & technique tips to manage the surgical site and enhance post-operative recovery through the use of ciNPT. To view program information/faculty disclosures and claim your CE credit after the session, visit centerforhealingsolutions.com/podcasts.

Kasper de Jonge's areas of expertise are many-Business Intelligence, Power BI, DAX, PowerPivot, General BI, Datawarehouse, SSIS, Reporting Services, Analysis Services, SQL Server, and you can include a mean basketball crossover to that list! As Analytics Advisor and Principal Program Manager of Power BI, he knows a great deal about the problems that BI customers face daily.  He shares some of these experiences and his expertise, and we have some good laughs along the way as well! Check out Kasper's awesome blog Kasper on BI References In This Episode: Inglorious Bastards Italian Scene Episode Timeline: 2:45 - A basketball challenge in New Orleans, Kasper's MS history with Power Pivot and Power BI, and the culture change at Microsoft 15:45 - The culture shock in moving to the United States 28:50 - The death of Power BI V1, and some James Phillips stories 40:00 - Office VS the Freedom to Innovate, Excel/Power BI Integration, and how software development has evolved 51:15 - The Amazing Power BI Cat Team, and the processes that they use to solve problems 1:05:50 - Some bad Microsoft product names, DAX VS MDX, and the many different people that are in IT

We have been moving data for years with technologies like DTS and SSIS; however, these were very much designed for on-premises moves in mind. As more cloud services were being offered Microsoft needed a service to help customers using those services move data around. Azure Data Factory was born with the initial premise of moving data between cloud services; however, it has added the ability to connect with on-premises systems and continues to add a variety of connectors it can now natively support. In this episode, we chat with our friend Andy Leonard about Azure Data Factory, his experience working with the product team, and how customers can leverage the cloud to get business done faster.

How do we pull students into a lesson so they are genuinely curious and want to learn? Dr. Khan shares today that one way might be to include some socioscientific issues (SSI). Socioscientific issues are socially-relevant, real-world problems that are potentially controversial, are informed by science, but often have an ethical component. Dr. Kahn explains that using these issues in the classroom can have numerous educational benefits. When students see the learning material is applicable to their lives today, and not just because a teacher says they’ll need it in the future, they engage more and remember more. SSIs really pull information from several disciplines and force students out of the silos of the different school subjects. And finally, students get to practice skills such as listening to someone else’s perspective and respectfully responding. All of this and more in an episode you definitely don’t want to miss!

Today is all about surgical site infection prevention bundles! First we'll bring you the summaries of two important articles in the November 2020 American Journal of Infection Control (AJIC) examining the effectiveness of surgical site care bundles in preventing SSIs. Then, Dr. Mohamed Yassin and I share our thoughts and experiences with bundle implementation and effectiveness. Find out more - November 2020 Issue American Journal of Infection ControlListen to all the podcasts - Infection Prevention SpotlightMentioned in this episode: Interview with Dr. Susan Huang

This week we sat with Dr. Sherika Evans, Ed.D a fearless Principal and Leader of Suncoast School for Innovative Studies – SSIS located in Sarasota, FL. Dr. Evans and our show curator @THEVOICEOFJP sit and discuss, COVID-19, the effects on our education system, charter vs. public schools, how it feels to be a leader at this time, how she tackles every obstacle thrown her way, and much more. We know this conversation will bless someone and it's truly for EVERYONE! For more information on SSIS contact Dr. Evans at (941) 953-4433 or https://suncoastschool.org/ for enrollment information. Check out the THEVOICEOFJP.com for all drinks and businesses listed in this episode. --- This episode is sponsored by · Anchor: The easiest way to make a podcast. https://anchor.fm/app Support this podcast: https://anchor.fm/thevoiceofjp/support

Welcome to the SSIS, the Super Self (or Social) Isolation Special, in which Des, Adam and Lee convene on a magical place called the internet and open up the mailbag to discuss KISS bootlegs, the Solo Albums, "KISSed opportunities", and so much more. Worry not- Virtually all Covid talk is saved for the last few minutes of the episode, so if you just want some good old fashioned KST we won't be offended if you tap out a little early. The audio will be better next time, promise.

Gerard P. Slobogean, MD, MPH joins JAMA Network editors to discuss a trial protocol that describes 2 multicenter pragmatic cluster randomized crossover trials comparing the effectiveness of iodophor and chlorhexidine surgical skin preparation solutions at reducing surgical site infections (SSIs) and unplanned fracture-related reoperations. Read the article here: https://ja.ma/3etHtYr. JNO Live is a weekly broadcast featuring conversations about the latest research being published in JAMA Network Open. Follow us on Facebook, Twitter and YouTube for details on the next broadcast.

Hallo und herzlich willkommen zur ersten Folge des Please Talk Data To Me Podcasts im neuen Jahrzehnt. Irgendjemand hat das Kellerfenster im Aufnahmestudio aufgelassen und nun haben sich heimtückische T-SQL Ninjas eingeschlichen und den Podcast übernommen. Zum Glück können unsere Protagonisten auf die Erfahrungen vom Nakatomi Plaza aus dem letzten Jahr zurückgreifen und haben natürlich unglaublich viele 80er Jahre Actionfilme gesehen in denen Ninjas vorkommen - daher sollte es für sie ein Leichtes sein auch diese Bedrohung abzuwenden. Wie immer eröffnen sie mit dem Reisetagebuch und geben eine Vorschau auf das, was im ersten Halbjahr 2020 so ansteht. Danach berichtet Tillmann aus den Untiefen der deutschen Internetkonnektivität. Im Anschluss schafft es Tillmann Biml Ben von Windows Terminal zu überzeugen weil man da ja VBScript laufen lassen kann. Dann endlich betritt der T-SQL Ninja die Bühne und Tobi-San und Fred-San erklären was es mit dem Projekt auf sich hat. Danach gibt es Infos zu Microsoft Styleguides und zu SSIS, ein Produkt das nicht mal der Ninja erledigen kann. Nachdem sich die Talkrunde das Thema Erweiterungen für VS Code, insbesondere dem ARM Template Viewer und der Stream Analytics Extension vorgeknöpft und ordentlich vermöbelt haben versucht Tillmann die Ninjas durch ein schnell eingeschobenes Thema (Polumi und Terraform) zu verwirren. Eine weitere Finte führt Biml Ben aus indem er von seiner Lego-Sammlung berichtet. So leicht lassen sich echte Ninjas aber nicht täuschen und nehmen sich dann als Endboss einen Film vor den ganz bestimmt nicht nur Frank gesehen hat: Star Wars - The Rise of Skywalker. Nachdem auch dieses Thema mit viel Hilfe aus den achziger Jahren des letzten Jahrtausends windelweich geprügelt wurde verschwinden die Ninjas wieder in den Schatten der Dunkelheit und lassen uns und ein angefangenes Jahr 2020 zurück. Ich denke vom T-SQL Ninja werden wir noch hören. Abspann und Cliffhanger: wir sehen wie sich die Ninjas im Schatten High Fives geben...

Quick DataPoint today to make you aware that Kent Bradshaw – a data scientist who works with me at Loading Medical Data with SSIS (https://andyleonard.blog/medical-data-webinar) Wednesday 17 Apr 2019 at [12:00] PM EDT.

Andy has been working on a way to test SSIS package execution in Windows containers using the SSIS Catalog. That’s a lot of moving parts, which made for a lot of blog posts. Watch the video from the Data Driven TV Facebook page (https://www.facebook.com/DataDrivenTV/) : Read the series at andyleonard.blog (https://andyleonard.blog) : Part 0 (https://andyleonard.blog/2018/12/ssis-docker-and-windows-containers-part-0-getting-started/) Part 1 (https://andyleonard.blog/2019/03/ssis-docker-and-windows-containers-part-1-why/) Part 2 (https://andyleonard.blog/2019/04/ssis-docker-and-windows-containers-part-2-executing-ssis-v0-1/) Part 3 (https://andyleonard.blog/2019/04/ssis-docker-and-windows-containers-part-3-adding-the-ssis-catalog/) Part 4 (https://andyleonard.blog/2019/04/ssis-docker-and-windows-containers-part-4-adding-an-ssis-catalog-attempt-2/) Part 5 (https://andyleonard.blog/2019/04/ssis-docker-and-windows-containers-part-5-deploying-to-the-ssis-catalog/) Part 6 (https://andyleonard.blog/2019/04/ssis-docker-and-windows-containers-part-6-executing-packages-in-an-ssis-catalog-in-a-container/) Enjoy! :{>

SQL Pub Quiz The Keynote How to Make Sure Your SSIS Packages Will Never Fail by Guy Glantser Benchmarking in the Cloud by Gianluca Sartori Common Troubleshooting Techniques for AGs and FCIs by Allan Hirt Failover Detection Utility – Availability Group Failover Analysis Made Easy What's New - Query Performance Insights by Pedro Lopes Top 5 Tips to Keep Always On AGs Humming and Users Happy by Matt Gordon The SQLBits Party Patterns and Best Practices in SSIS by Richard Munn Build Hybrid Data Platform with Azure SQL Database and SQL Server by Kevin Farlee SQL Leadership Q&A by Microsoft PowerShell Medley by Jonathan Allen Validate Your SQL Server Estate with Ease Using dbachecks by Rob Sewell Select Stars: A SQL DBAs Introduction to Azure Cosmos DB by Bob Pusateri

How many bicycles he has got at home and where was the destination of last year of a 400 km trip? Which tool among Azure is the closest to his soul? What exactly is hiding behind the term "Modern Data Warehouse"? When Azure Data Factory (Mapping) Data Flow will be publicly available? Also, we will try to answer the fundamental question: is the SSIS dead or alive? Find out the answers on these questions and much, much more.As Chief Cloud Architect with Adatis Consulting, Simon Whiteley has been working with the Microsoft BI Stack for a decade, starting off building traditional warehouses with SSIS and SSAS but bringing in alternative technologies where needed. Most recently, he has turned his head to the clouds, advocating new methods of getting insight to the right people. Whether it's automating file ingestion into Azure Data Lakes, applying massive compute via SQLDW & Data Lake Analytics, or simply shifting your current SSIS packages into the cloud, he can help. Big believer in the wider data community - Regularly present on cloud analytics architectures and runs the SQL Surrey PASS chapter & co-organises the London PASS Chapter. Simon is a strong advocate of the use of modern development practices in the SQL World. Data Geek, Cloud Herder, Speaker, Cyclist, Microsoft Data Platform MVP and general Tech-Nerd.This talk has taken place after London SQL Server User Group meeting in London (UK), CodeNode on 29th January 2019 (Tuesday). Interviewer: Kamil Nowinski.

How many bicycles he has got at home and where was the destination of last year of a 400 km trip? Which tool among Azure is the closest to his soul? What exactly is hiding behind the term "Modern Data Warehouse"? When Azure Data Factory (Mapping) Data Flow will be publicly available? Also, we will try to answer the fundamental question: is the SSIS dead or alive? Find out the answers on these questions and much, much more.As Chief Cloud Architect with Adatis Consulting, Simon Whiteley has been working with the Microsoft BI Stack for a decade, starting off building traditional warehouses with SSIS and SSAS but bringing in alternative technologies where needed. Most recently, he has turned his head to the clouds, advocating new methods of getting insight to the right people. Whether it's automating file ingestion into Azure Data Lakes, applying massive compute via SQLDW & Data Lake Analytics, or simply shifting your current SSIS packages into the cloud, he can help. Big believer in the wider data community - Regularly present on cloud analytics architectures and runs the SQL Surrey PASS chapter & co-organises the London PASS Chapter. Simon is a strong advocate of the use of modern development practices in the SQL World. Data Geek, Cloud Herder, Speaker, Cyclist, Microsoft Data Platform MVP and general Tech-Nerd.This talk has taken place after London SQL Server User Group meeting in London (UK), CodeNode on 29th January 2019 (Tuesday). Interviewer: Kamil Nowinski.

In this DataPoint, Andy reflect on software development, SSIS Catalog Compare, and his philosophies on testing software. Also, if you want to grab a cool SSIS t-shirt, get it from Amazon today for $19 (https://www.amazon.com/dp/B07L3MFRLZ?ref_=pe_2196150_146773810)  . You get some sweet geeky swag and your purchase helps fund the show.

"This article explores the causes of SSIs, such as modifiable and nonmodifiable patient factors and preoperative, intraoperative, and postoperative procedural factors, and discusses some of the specific recommended strategies related to the prevention of SSIs that perioperative nurses can initiate in their workplace." Volume 109, Issue 1 [https://aornjournal.onlinelibrary.wiley.com/doi/full/10.1002/aorn.12451]

Which unusual mean of transportation Alex use from time to time? Why monitoring of data quality does matter and what is the very efficient contrary of SCD in SSIS in BI loading process? Which skill is important if you want to jump into the IT market?Find out the answers on these questions and much, much more.Alex Whittles is the owner and principle consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK with multinational clients in a variety of sectors. He specialises in all aspects of dimensional data modelling, data warehousing, ETL and cubes using the SQL Server stack.Alex has an MSc (Master of Science) in Business Intelligence, is a chartered engineer, and a member of Mensa. Community leadership includes being on the SQLBits committee, Director of SQL Relay, founder and leader of the Birmingham Data Platform user group.Alex is also a regular speaker at many SQL Server events around the world including SQL Relay, SQLBits, SQL Saturdays, 24 HOP and the PASS Summit.This talk has taken place during Data Relay (formerly SQL Relay) conference in Reading (UK), on 11th October 2018 (Thursday). Interviewers: Kamil Nowinski.

Which unusual mean of transportation Alex use from time to time? Why monitoring of data quality does matter and what is the very efficient contrary of SCD in SSIS in BI loading process? Which skill is important if you want to jump into the IT market?Find out the answers on these questions and much, much more.Alex Whittles is the owner and principle consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK with multinational clients in a variety of sectors. He specialises in all aspects of dimensional data modelling, data warehousing, ETL and cubes using the SQL Server stack.Alex has an MSc (Master of Science) in Business Intelligence, is a chartered engineer, and a member of Mensa. Community leadership includes being on the SQLBits committee, Director of SQL Relay, founder and leader of the Birmingham Data Platform user group.Alex is also a regular speaker at many SQL Server events around the world including SQL Relay, SQLBits, SQL Saturdays, 24 HOP and the PASS Summit.This talk has taken place during Data Relay (formerly SQL Relay) conference in Reading (UK), on 11th October 2018 (Thursday). Interviewers: Kamil Nowinski.

In this keynote session from Azure Data Fest 2018 Reston, Data Driven’s very own Andy Leonard discusses and demonstrates migrating SSIS to Azure Data Factory Integration Runtime.

We love experimenting around here and examining the resulting data. After all, we are Data Driven: not just in name but also in spirit. In this webinar Andy recorded, he also streamed it live on our Facebook page (https://www.facebook.com/DataDrivenTV/) . We thought it was good enough to share with our larger audience here. Let us know what you think. Both Frank and Andy have been recording/streaming their live events and we’re curious to hear what you have to say about this innovation in how we podcast.

In this episode we finish up our conversation with Jason and Cathrine and talk about how they keep up with all the changes in data conversions.  The advent of Azure services is great, but can be tricky to navigate.  We also get to hear Jason's answers to the SQL Family questions. The show notes for today's episode can be found at http://sqldatapartners.com/2018/09/05/episode-145-is-ssis-still-relevant. Have fun on the SQL Trail!

In this show we answered a listener's question about the 32-bit vs. 64-bit nightmare that developers have to go through when trying to access Excel files from SSIS. And we also mentioned a script to roll forward transaction log backups. The next show is the 100 show!!! We are planning a big party! Stay tuned...

Moving data with SSIS is a forgone conclusion for most of us -- it is part of SQL Server, it has a interface we are somewhat familiar with, and connects to lots of common data sources like csv, excel, and of course SQL Server. Are our needs changing as our environments become more hybrid -- as we introduce cloud services? Are you still building packages the same way you were 10 years ago? Just as our data sources have grown, the capabilities needed to move data around have increased. This episode, with Jason Horner and Cathrine Wilhelmsen, challenges some of the thoughts around data movement and gives some things to think about as new tools are available to move data around. The show notes for today's episode can be found at http://sqldatapartners.com/2018/08/29/episode-144-is-ssis-still-relevant. Have fun on the SQL Trail!

(http://datadriven.tv/wp-content/uploads/2018/05/AcuriteWeatherStation.jpg) A few years ago, Andy collected local weather data from his farm near Farmville Virginia and posted it online. Why? To see if he could. Even though the old weather station ceased working years ago, he still uses the data in SSIS training courses he delivers. It was time for a new weather station, so Andy picked up this Acurite (https://www.acurite.com/environments/weather-stations.html) model. He plans to use it to conduct data science and data engineering experiments. Why? To see if he could. To get things started, Andy set up the Acurite software to append readings to a CSV file every 12 minutes. He then grabbed a copy of the AzCopy command-line utility (https://docs.microsoft.com/en-us/azure/storage/common/storage-use-azcopy)  Andy decided to run the Acurite software and AzCopy on a very old Windows 7 machine (with only 2GB RAM). Why? To see if he could. It works. Andy built a command line for AzCopy that performs a data transfer from the old Win7 machine to Azure Blob Storage. He then used Task Scheduler to fire the command line every 15 minutes… and you already know why. :{>

In this episode Greg is flying solo, sharing with you the latest VSTS news, like Sprint 132, TFS news, such as TFS 2018.2 RC1, Migration news and the April 23rd deadline, hints on batch undeleting Release Definitions, tips on SSIS with VSTS and much more.... For feedback contact radiotfs@outlook.com, call +1 425 233-8379 or visit http://www.radiotfs.com

In this episode Greg is flying solo, sharing with you the latest VSTS news, like Sprint 132, TFS news, such as TFS 2018.2 RC1, Migration news and the April 23rd deadline, hints on batch undeleting Release Definitions, tips on SSIS with VSTS and much more.... For feedback contact radiotfs@outlook.com, call +1 425 233-8379 or visit http://www.radiotfs.com

In this Deep Dive, Frank and Andy delve into the depths of Data Integration and SQL Server Integration Service.

How do you ETL? Richard chats with Tom Kerkhove about Azure Data Factory, now previewing V2 features. We've had Extract-Transform-Load workflows since databases were first invented, but the concept was really formalized back in the data warehouse days. With the cloud, there are more tools, more data sources and more compute to enhance your ETL experiences. Tom talks about how V2 of Data Factory adds SQL Server Integration Service functionality so that you can put your SSIS packages directly into Azure. Data Factory is tied in with Logic Apps, including supporting features like Azure Key Vault. This leads to a great conversation about data-centric vs. application-centric workflows. Your company is sure to have both!

Cathrine loves teaching and sharing knowledge. She works as a consultant, technical architect and developer, focusing on Data Warehouse and Business Intelligence projects. Her core skills are ETL, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she's active in the SQL Server and PASS communities as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.This talk has taken place during PASS Summit in Seattle, WA, on 2nd November 2017 (Thursday).Do you want to know how Cathrine has started her adventure in IT? How difficult is to be a woman in IT and how we can help in struggling with prejudices? Who is one of her personal guru? Finally, how is a correct Norwegian pronunciation of her surname? Listen to this podcast to get to know how Cathrine became her journey to IT and how tough can be for women in the IT.

Cathrine loves teaching and sharing knowledge. She works as a consultant, technical architect and developer, focusing on Data Warehouse and Business Intelligence projects. Her core skills are ETL, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she's active in the SQL Server and PASS communities as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.This talk has taken place during PASS Summit in Seattle, WA, on 2nd November 2017 (Thursday).Do you want to know how Cathrine has started her adventure in IT? How difficult is to be a woman in IT and how we can help in struggling with prejudices? Who is one of her personal guru? Finally, how is a correct Norwegian pronunciation of her surname? Listen to this podcast to get to know how Cathrine became her journey to IT and how tough can be for women in the IT.

Editor's Summary by Howard Bauchner, MD, Editor in Chief of JAMA, the Journal of the American Medical Association, for the December 26, 2017 issue

Frank and Andy ponder the meaning of data in the Data Age, treadmill desks, health data, and re-tooling your skills for AI and Machine Learning. Links: Sponsor: Audible.com (http://thedatadrivenbook.com) – Get a free audio book when you sign up for a free trial! Sponsor: Enterprise Data & Analytics (http://entdna.com) Notable Quotes Frank is working out ([0:45]) Book:  Brain Rules (https://www.amazon.com/Brain-Rules-Updated-Expanded-Principles/dp/098326337X) ([5:15]) Frank spoke at his first SQL Saturday! ([9:30]) Cathrine Wilhelmsen interviewed Buck Woody at MSIgnite ([16:30]) GPUs ([17:30]) SQL Server 2017 GA released ([22:00]) SSIS as a Service (not “Sassafras” but close) ([24:45]) Azure DataFest – Reston, Virginia – 12-13 Oct 2017 (https://www.eventbrite.com/e/azure-datafest-microsoft-azure-advanced-analytics-and-big-data-conference-reston-va-october-12-13-tickets-28683737832) ([26:50]) Some triskaidekaphobia ([28:15]) Frank has a new MSDN Magazine column! ([32:15]) Talking with the Farmville local podiatrist… ([34:15]) “Which exit?” ([24:22]) On becoming a data scientist… (http://datadriven.tv/kent-bradshaw-microsoft-data-science-professional-certification/) ([35:00]) Brittany Wegner (https://ideas.ted.com/brittany-wenger-cancer-research/) taught herself data . ([36:00]) www.FranksWorld.com (http://www.franksworld.com) ([38:00]) Ask YouTube star (https://www.youtube.com/channel/UCWN3xxRkmTPmbKwht9FuE5A) to join us on Data Driven! Teachable Machine (https://teachablemachine.withgoogle.com) – it’s magic. ([41:00]) Crazy talk… ([47:00]) It’s been about a year… ([48:20])

In this episode, Frank and Andy talk about the Ignite 2017 conference, quantum computing, great guests, and the effects of hurricanes on podcast production schedules. Oh yeah and the AI apocalypse. Maybe Elon Musk knows something we don’t (https://www.vanityfair.com/news/2017/03/elon-musk-billion-dollar-crusade-to-stop-ai-space-x) . Links Sponsor: Audible.com (http://thedatadrivenbook.com) – Get a free audio book when you sign up for a free trial! Sponsor: Enterprise Data & Analytics (http://entdna.com) Notable Quotes ClearDB strikes again… ([2:45]) Hurricane Irma knocked out last week’s show ([4:30]) Microsoft Ignite ([5:30]) Shoutout to Rimma Nehme (http://datadriven.tv/rimma-nehme-cosmosdb-planet-scale-applications-selling-door-door/) Shoutout to Buck Woody (http://datadriven.tv/buck_woody/) Alexa Dev Day ([7:30]) Frank’s WintellectNOW Data Science course: Data Science for Developers (https://www.wintellectnow.com/Videos/Watch?videoId=data-science-for-developers) ([9:00]) Shoutout to Julie Smith (http://datadriven.tv/julie-smith-escape-rooms-percussive-maintenance-data-science/) ([10:30]) Quantum Computing and Qubits ([11:30]) Television reference: Quantum Leap (http://www.imdb.com/title/tt0096684/) ([14:20]) Too much CI? ([20:30]) “Ask” is NAN (not a noun) ([21:30]) SSIS as a Service ([22:00]) The SSIS Data Flow Task and REST ([23:45]) Shoutout to Kevin Hazzard (http://datadriven.tv/kevin_hazzard/) The FedEx commercial (https://www.youtube.com/watch?v=zNCrMEOqHpc) ([24:15]) “All I see is data.” ([25:10]) “AI-first” ([26:55]) “Data Estate” ([27:55]) Curiosity Stream (https://app.curiositystream.com/) ([28:15]) Shoutout to Lynn Langit (http://datadriven.tv/lynn-langits-excellent-data-adventure/) “Paranoia is a skill.” ([31:55]) Universal Basic Income and the economics of automation ([32:30]) “The way out is not the way we got in…” ([40:50]) Velocity… ([46:00]) Titling this show ([47:35]) Praying for Puerto Rico ([48:30]) Data and Disasters (http://datadriven.tv/datapoint-data-disasters/) ([48:50]) Nassim Taleb’s next book ([49:30]) Antifragile (https://www.audible.com/pd/Science-Technology/Antifragile-Audiobook/B009PRJ6BS/) Unicorns Among Us (https://www.audible.com/pd/Science-Technology/Unicorns-Among-Us-Audiobook/B00NSXNRAG)

Andy ran into Tim Mitchell at SQL Saturday Atlanta and they chatted about SSIS, metadata, and the SSIS Catalog.

Andy Leonard is a Data Philosopher at Enterprise Data & Analytics, a Biml (Business Intelligence Markup Language) developer and BimlHero, SSIS architect, consultant, and trainer. He created and maintains the DILM (Data Integration Lifecycle Management) Suite that includes tools and utilities for managing SSIS in the enterprise. Andy is an avid blogger and has co-authored several books on SSIS, ETL, and database technology. Interviewer: Rajib Bahar Music: www.freesfx.co.uk

The fifteenth episode is up, a.k.a “the super-great” episode is up! We talk about the upcoming Power BI changes, new Microsoft hardware, licensing considerations with SSIS in Azure and testing patches or not. As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just tweet me (@arcticdba) or Simon (@bindertech)! See acast.com/privacy for privacy and opt-out information.

Show Notes: In the news this week, the 2017 federal budget is out and we go one-on-one with BIOTECanada’s Andrew Casey to find out if it delivers on the promise of an Innovation Agenda, the NRC and the Centre for the Commercialization of Antibodies and Biologics (CCAB) colloborate on an antibody development initiative, and Bellus Health divests itself of Thallion Pharmaceuticals. We have all this and more coming up on Biotechnology Focus Radio. Welcome to another episode of Biotechnology Focus Radio. I’m your host Shawn Lawrence, here to give you a rundown of the week’s top stories on the Canadian biotech scene. Story 1 Our first story this week takes us to Vancouver, where Qu Biologics Inc. reports it has identified immune factors (cytokines and growth factors) in the blood of patients with Crohn’s disease that may predict response to its Site Specific Immunomodulators (SSIs) therapy. According to the company, SSIs are a unique platform of immunotherapies designed to restore the body’s innate immune system. Their discovery was made following further analysis of Qu Biologics recently completed Phase 2 Study in Crohn’s disease. The company says that when combined with patients’ clinical profiles, these biomarkers seemed to coorelate with identifying patients likely to respond to SSI treatment. Dr. Hal Gunn, CEO of Qu Biologics, explained these findings could  mean that patients with Crohn’s disease may now be closer to having precision treatment for their condition for the first time.  In addition, Qu Biologics’ Phase 2 randomized placebo-controlled Crohn’s disease trial results demonstrated that specific blood immune markers associated with immune activation and mucosal healing increased with SSI treatment and SSI response/remission. The company says it plans to initiate a follow-on clinical trial in Crohn’s disease later in 2017 to confirm the value of these blood immune biomarkers in predicting and monitoring response to SSI therapy. Story 2 The National Research Council of Canada (NRC) and Toronto-based Centre for the Commercialization of Antibodies and Biologics (CCAB) are teaming up to advance new innovative therapies discovered out of the University of Toronto. Through this innovative collaboration between government, industry, and academia,  the NRC and the (CCAB) have over the past year already put in place over $1M in collaborative agreements to produce and test therapeutic antibodies discovered at the University. CCAB is a business development and commercialization engine whose mission is to translate UofT’s large portfolio of early stage biologics into high-value assets and products. To this purpose, CCAB has partnered with NRC to biomanufacture and test hundreds of antibodies. With this announcement, the collaboration continues to grow and now leverages NRC’s three programs in Human Health Therapeutics: 1. Biologics and Biomanufacturing: producing biologics, testing their ability to fight solid tumours, and determining their biomanufacturability; 2.  Therapeutics Beyond Brain Barriers: determining if specific antibodies are able to cross the blood-brain barrier, target and fight brain cancer; And 3. Vaccines and Immunotherapeutics: determining if specific antibodies are able to modulate the immune system so that it finds and destroys cancer cells.  As cancer treatment evolves rapidly toward more effective molecules, including single-domain and bi-specific antibodies, antibody-drug conjugates, and immunotherapies, these types of medicines, also called biologics, are able to specifically target cancer cells and in some cases, recruit the body’s immune system to help destroy them. The goal of the collaboration is to identify the most promising antibodies, and increase their value by generating data that effectively de-risks each asset. CCAB says its objective is to then licence lead antibody candidates to seed newly formed Canadian biotechnology companies.  These new Canadian start-ups will, in turn, advance these molecules toward clinical trials in patients.  With several biotechnology companies already participating and benefitting from these programs, the collaboration between CCAB and NRC is clearly set to catalyze the country’s biotech sector and generate promising new cancer treatments for Canadians. Alexion licenses Arbutus’ LNP delivery technology In business news, Alexion Pharmaceuticals has negotiated a license to use Vancouver-based Arbutus Biopharma’s lipid nanoparticle (LNP) delivery technology for one of its rare disease messenger RNA (mRNA) therapeutic candidates. As part of the deal, Arbutus will earn $7.5 million upfront from Alexion and potentially another $75 million in development, regulatory, and commercial milestones, plus single-digit sales royalties. Arbutus will also carry out technology development and provide manufacturing and regulatory support for the Alexion mRNA candidate. Arbutus Biopharma itself is currently focused on developing a cure for chronic hepatitis B virus (HBV) infection. Dr. Mark J. Murray, Arbutus’ President and CEO said this transaction with Alexion illustrates the value of his company’s LNP platform, which he believes has broad potential to deliver mRNA and gene editing therapeutics. He adds that Arbutus is receiving significant interest from companies that require access to the LNP platform to enable their own development programs BELLUS Health sells Thallion Pharmaceuticals subsidiary to Taro Pharmaceuticals BELLUS Health Inc. reports it has entered into a share purchase agreement with Taro Pharmaceuticals Inc. (Taro) for the sale of its wholly-owned subsidiary Thallion Pharmaceuticals Inc. as well as the rights to the drug candidate Shigamab™. According to Bellus, the asset, Shigamab™, is a monoclonal antibody therapy being developed for the treatment of Hemolytic Uremic Syndrome caused by Shiga toxin-producing E. coli (STEC) (sHUS), a rare disease which principally affects the kidneys and often leads to acute dialysis, and in certain cases chronic kidney disease and death, primarily in children. Pursuant to the sale, Taro is acquiring all issued and outstanding shares of Thallion for a potential total consideration of CA$2.7 million, consisting of an upfront payment of CA$2.3 million and a potential future payment of CA$0.4 million contingent upon the completion of a pre-established milestone event, expected to occur within 24 months of the closing of the transaction. Additionally, BELLUS Health will receive a portion of certain post-approval revenues related to the Shigamab™ program. Story 5 In our feature story this week, on March 21st, the federal Liberal government officially presented their second budget since coming to power. In our feature story this week, on March 21st, the federal Liberal government officially presented their second budget since coming to power. In the months leading up to its release, this budget was of course billed by the Feds as the Innovation Budget, and certainly at first glance there are a few initiatives where spurring innovation or forming an Innovation Agenda for Canada is its goal.  But has this Budget measured up to its promise? Has the government truly delivered with Budget 2017 an Innovation Agenda to hitch our wagons to? We have with us today, Andrew Casey, CEO and president of BIOTECanada, the national organization that represents health care, agricultural, food, and research groups involved in biotechnology to find out if government has hit the mark or missed it in terms of delivering on its innovation mandate. Hello Andrew and welcome to the show. 1. Going into Budget 2017, there were many surveys, consultations and open dialogue between Government and industry, on what we wanted to see from this Innovation Agenda budget. Straight to point, did Budget 2017 live up to its hype? For BIOTECanada, what was on your wishlist- what were you hoping to see in the budget? What were the asks on the wish list that were answered, and which asks weren’t? Let’s look deeper, in our analysis of the investment summary, the biggest program of interest seems to be the $950 million “super clusters” fund, that will be an open competition in 2017 across six innovation industries, with biotech of course being one these industries. Like with most such initiatives there is of course some worry that biotech as one of the six, may not get it proverbial portion of the pie, does BIOTECanada see it this way, or do they feel that our industry can benefit from this fund? 5. In terms of strengthening science in government, Budget 2017 proposes to establish a new chief science advisor for Canada, what should we expect to see from the creation of this new role? There was also $6 million earmarked for stem cell research, and organizations in that field like the Stem Cell Foundation and other stakeholders seemed satisfied in that commitment, but on a grander scale, does that really compare with other leading jurisdictions in the field? Are those funds enough to capitalize on Canada’s strengths in this field? What we found interesting as well in Budget 2017 was the proposal of a new procurement program, called Innovative Solutions Canada, modeled on the SBIR (Small Business Innovation Research Program) in the U.S. with $50 million to go into this program. For comparison sake, in Fiscal Year 2016, the NIH’s SBIR and STTR programs south of the border will invest over $870 million into health and life science companies, so how does our commitment stack up? Is it a good first step into this arena? Glancing at the investment summary, we also noticed that basic research programs, such as the Tri-Councils, were not mentioned. Why do you think that was? Finally, another industry ask is always around supporting venture capital and Budget 2017 proposes $400 million over the next three years for a new Venture Capital Catalyst Initiative. Is this separate from the $400 million Venture Capital Action Plan from year’s past? Were there any other examples where existing funding and credits were maintained or even expanded upon in Budget 2017. Well Andrew, thank you for joining us today on our show and for your breakdown of #BUDGET2017, it’s always a pleasure for us to talk with you and get your insights on key industry topics.  

Coming up on Biotechnology Focus Radio: The launch of a new Canadian Regenerative Medicine Alliance, Canada’s House of Commons passes the Genetic Discrimination Act Bill S-201, and a One-Two Punch that May Floor the Worst Infections by stopping antibiotic drug resistance. Welcome to another episode of Biotechnology Focus Radio. I’m your host Shawn Lawrence, here to give you a rundown of this week’s top stories on the Canadian biotech scene. Our first story this week takes us to Toronto, where Antibe Therapeutics Inc. reports it has signed an exclusive licensing and distribution agreement with a pharmaceutical company, Laboratories Acbel SA (Acbel), for its lead product ATB-346. ATB-346 is an anti-inflammatory drug, designed to spare the gastrointestinal tract of the ulcers and bleeding normally associated with NSAIDs. The agreement covers distribution in Greece, Romania, Serbia, Bulgaria, Albania, Algeria and Jordan. Antibe will receive an upfront, non-dilutive payment of $1.1 million, and is entitled to receive a 5 per cent royalty on net sales of ATB-346 in these countries. The agreement has a 30-year term with contemplated renewals thereafter. Acbel, through its affiliates and partners, is the largest seller of naproxen in this region, which represents approximately one per cent of the global market for nonsteroidal anti-inflammatory drugs (NSAIDs). The global market for NSAIDs is in excess of US$12 billion (Evaluate Pharma). In a recent Phase 2 clinical trial, ATB-346 was found to be highly effective in reducing the pain associated with osteoarthritis of the knee. Antibe says it will now initiate two larger Phase 2 double-blind trials: a placebo-controlled dose-ranging study to determine the go-to-market dose, and an active comparator trial to demonstrate superior GI safety. Antibe also has two other therapeutic candidates in development: ATB-352 and ATB-340. ATB-352 is a non-addictive analgesic for treating severe acute pain and ATB-340 is a GI-safe derivative of aspirin. Antibe intends to leverage data across its programs to secure licensing agreements whenever possible. In regulatory news Canada’s House of Commons has passed Bill S-201 (An Act to Prohibit and Prevent Genetic Discrimination in Canada), as it was presented, by the Standing Committee on Justice and Human Rights on Wednesday March 8, 2017. According to Bev Heim-Myers, chair of the Coalition for Genetic Fairness and CEO of the Huntington Society of Canada (HSC), while the Bill will still have to go to the Senate, all indications point to it being fully supported. Heim-Myers adds that Canada has finally caught up to other western jurisdictions in regards to protection of genetic information and Canadian legislation has caught up to science. Since the Genome Project was launched in the early 1990s, Canada had been the only G7 country that had not taken steps to prevent genetic discrimination. With this decision, this changes. Qu Biologics Inc., a biopharmaceutical company developing Site Specific Immunomodulators (SSIs) that aim to “reboot” the body’s innate immune system, has reported positive genetic analyses of their recently completed Phase 2 clinical studies in Crohn’s Disease (CD) and Ulcerative Colitis (UC). These findings suggest that, for the first time in the field of inflammatory bowel disease (IBD), personalized medicine and the application of genetic testing may identify patients highly likely to respond and go into remission with treatment. The analyses identified common IBD-related genotypes with a high likelihood of response to SSI, suggesting that genetic testing may identify a large subset of CD patients (representing approximately 60% of the CD population) with a greater than 80% likelihood of responding to QBECO treatment, the large majority of which achieved remission on SSI treatment. Dr. Hal Gunn, CEO of Qu Biologics, stated, “We are very excited about the possibility of identifying CD and UC patients highly likely to respond to SSI treatment, which would substantially de-risk future trials and be an important advance for patients who currently face the uncertainty of knowing whether current immunosuppressive IBD treatments, which can be associated with significant side effects, will work for them or not.” Dr. Shirin Kalyan, Qu’s Director of Scientific Innovation, added, “Unlike current IBD treatments that suppress immune function, we believe that SSIs, which restore innate immune function, treat the underlying cause of IBD. Consequently, unlike other treatments, we were able to identify IBD-related genotypes highly responsive to SSI therapy. It is exciting that the genotypes correlated with SSI response are highly relevant to SSIs’ mechanism of action.” Based on the promising results of Qu Biologics’ recently completed Phase 2 study in CD, a follow-on Phase 2 study in moderate to severe CD is planned to confirm these findings. Study initiation is anticipated in late 2017. If the genetic analysis results are confirmed in follow-on studies, Qu Biologics’ QBECO SSI has the potential to become first-line therapy for a majority of IBD patients. In funding news, the Federal Economic Development Agency for Southern Ontario (FedDev Ontario) is providing TechAlliance of Southwestern Ontario with up to $1.32 million to deliver on a new incubation program, called BURST, which will provide 30 innovative technology entrepreneurs in southwestern Ontario with mentoring and business guidance, seed funding, exposure to potential investors and access to a dedicated working space in Western University's Discovery Park. As entrepreneurs establish and grow their businesses with help from this program, it is expected that up to 45 new full-time jobs will be created. Building on London's history of innovation in health sciences, a unique partnership with the London Medical Network will also be established to help eligible medical technology companies receive funding. The announcement was made on behalf of the Honourable Navdeep Bains, Minister of Innovation, Science and Economic Development and Minister responsible for FedDev Ontario. In Hamilton, ON, McMaster University researchers say they have found a new way to treat the world’s worst infectious diseases, the superbugs that are resistant to all known antibiotics. The McMaster team published their findings in the journal Nature Microbiology last week. Eric Brown, senior author of the paper, a professor of biochemistry and biomedical science at McMaster’s Michael G. DeGroote School of Medicine and a scientist of the Michael G. DeGroote Institute for infectious Disease Research says his team looked for compounds that would mess with these antibiotic resistant bacteria, focusing on Gram-negative bacteria which are resistant to all antibiotics including last resort drugs, such as colistin, and lead to pneumonia, wound or surgical site and bloodstream infections, as well as meningitis in healthcare settings. Brown explains that Gram-negative bacteria have an intrinsically impenetrable outer shell that is a barrier to many otherwise effective antibiotics, and this makes these infections deadly, particularly in hospital settings. His team tested a collection of 1,440 off-patent drugs in search of one that might compromise that barrier in the superbugs. “These pathogens are really hard nuts to crack, but we found a molecule that shreds that shell and allows antibiotics to enter and be effective,” Brown said. The scientists discovered the antiprotozoal drug pentamidine disrupts the cell surface of Gram-negative bacteria, even the most resistant. The anti-fungal medication was particularly potent when used with antibiotics against multidrug resistant bacteria. Moreover, Pentamidine, when used with other antibiotics, was found to be particularly effective against two of the three pathogens which the WHO has identified as having the most critical priority for development of new antibiotics. Those were Acinetobacter baumannii and the enterobacteriaceae. The combo therapy also had some impact on the third most critical bacteria, Pseudomonas aeruginosa according to Brown. Brown continued saying These discoveries were found to be effective in the lab and in mice, but more work is needed to offset potential side effects and ensure human safety. Brown adds that his lab is continuing to test more compounds as well. “One of the things we want to pursue further is why this is working so well,” he said. The study was supported by grants from the Canadian Institutes of Health Research, the National Sciences and Engineering Research Council and Cystic Fibrosis Canada, among others. http://bit.ly/2m3hZq2   In our final story , a group of Canadian Stem Cell & Regenerative Medicine Leaders have announced that they are Joining Forces to Advance Canada’s Position in the Field, with the launch late last week of a new national group called the Regenerative Medicine Alliance of Canada. The founding members include: CCRM; The Centre for Drug Research and Development (CDRD); CellCan; Medicine by Design; Ontario Institute for Regenerative Medicine; ThéCell; Canadian Stem Cell Foundation, and Stem Cell Network. The goal of this new Regenerative Medicine Alliance of Canada or (RMAC) will be to advance Canada’s stem cell science and regenerative medicine sector by aligning national activity in the field. Its members say they plan to work collaboratively to share information and identify strategies that will benefit the growth of Canada’s regenerative medice expertise. The initial concept for this alliance was conceived by members of the regenerative medicine community during a workshop on the state of regenerative medicine in Canada. The workshop was held by the Council of Canadian Academies in 2016. Their newly released report notes the importance of strategic coordination amongst the stem cell and regenerative medicine community. Bolstering and aligning programs, training, policy and communication will also be central themes addressed by RMAC. According to the Alliance, With the global market for regenerative medicine iexpected to exceed US$49 billion by 2021, the need to keep Canada well positioned to compete by moving its innovative treatments and therapies out of the lab and into the clinic has never been greater. Countries around the world, including the U.S., Japan and the U.K., have already taken bold steps through investment and regulatory modernization to capture a significant piece of the market. RMAC will serve as a mechanism to support strategic activity across the regenerative medicine sector in Canada. The RMAC will act voluntary organization comprised of national, provincial and regional organizations. All members have mandates relevant to stem cell research and/or regenerative medicine. Well that wraps up another episode of the Biotechnology Focus Podcast. We hope you enjoyed it. Be sure to let us know what you think, and we’re also always looking for story ideas and suggestions for future shows, and of course we’d love to hear from you as well, simply reach out to us via twitter @biotechfocus, or by email at the following email address press@promotivemedia.ca. And

Although the SSIS Catalog DB is created with management studio, it does not behave like other databases. Our conversation in this episode revolves around the catalog, SSIS packages, and some of the complexities of migrating packages. Steve and I are excited to chat with our guest Andy Leonard about his thoughts on the catalog and how this feature provides some really interesting benefits for ETL architecture. The shownotes for today’s episode is found at http://sqldatapartners.com/2017/01/17/episode-79-ssis-catalog/ and have fun on the SQL trail.

For all of us working with data, we know that we work no only with SQL Server but the suite of tools around the SQL Server engine.  In this episode, we share some thoughts around SSIS administration, which is the most popular ETL tool in the Microsoft stack.  Just like the SQL Server engine, many times the defaults are taken and in this episode we give some thoughts around logging, package execution, and notification with our guest Ravi Kumar.  With the every expanding functionality of SSIS, Steve and I found this discussion insightful as we think about supporting an SSIS environment and ways we can educate package developers. The show notes for today's episode can be found at http://sqldatapartners.com/2016/10/15/ssis-administration/ Have fun on the SQL trail!

Why is ETL so hard?  All we want to do is move data from system A to system B.  Perhaps that is the problem, says my guest Rafael Salas, and more time should be given to thinking about the architecture of the system.  With our thoughts turned to SSIS, we discuss this idea in today's episode.  The show notes for today's episode can be found at http://sqldatapartners.com/2016/05/10/etl/ and I'll see you on the SQL trail!

As one of the newest Azure offerings, Azure Data Factory can at first thought be compared to SSIS.  I don't think we are quite there yet with the comparisons; however, I talk with MVP Reza Rad and discuss some of the similarities and differences between the two. A consultant now living in New Zealand, Reza has lots of experience with the data management and gives us the scoop on the initial offering of this new Azure tool.  I hope you enjoy the episode.  If you have some feedback or comments, feel free to reach out on Twitter--I am @CarlosLChacon   You can see the show notes at http://sqldatapartners.com/2015/12/08/azure-data-factory/

I learn stuff every day.  In this episode I tackle a new subject for me and one I am hearing a lot about--BIML.  BIML is a markup language you can use to build your SSIS packages.  I met up with Bill Fellows and Cathrine Wilhelmsen in Portland and they shared with me some insights on BIML, what they use if for, and some tips on getting started.  If you find your self doing more SSIS packages and haven't yet tackled BIML, this episode is for you! Check out the shownotes at http://sqldatapartners.com/2015/11/17/biml/

I read Sean's blog on his "SSIS architecture: Tips for package design" PDF, and also the finalists from the MidnightDBA SQL Server Musical Contest.

Today we make some announcements, and read three quick blogs from the girly MidnightDBA (just to clarify, that's Jen) about the SSIS package rename dialog box, and "When do you become 'Somebody'?"

SQL Server MVP Jamie Thomson discusses Integration Services and the lessons he's learned along the way. Jamie also discusses SSIS best practices and upgrade issues.

Richard and Greg talk to Matthew Roche about SQL Server Integration Services (SSIS). SSIS comes with SQL Server 2005 and 2008, replacing Data Transformation Services (DTS) from SQL Server 2000. Matthew digs into the dramatic improvements SSIS has over DTS and some of the best practices for using SSIS. Check out Matthew's blog at bi-polar23.blogspot.com.

SQL Server 08 - An Overview Intertech's Oxygen Blast Podcasts include coverage of Java, .NET, XML, and all that is software development.

This conversation with Kent Tegels starts with SSIS and goes from there, like most good .NET Rocks! shows.Support this podcast at — https://redcircle.com/net-rocks/donations