Podcasts about pass summit

Bob Ward is a Principal Architect for the Microsoft Azure Data team, which owns the development for Microsoft SQL Edge to Cloud. Bob has worked for Microsoft for 30-plus years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2022, including Azure SQL. Bob is a well-known speaker on SQL Server, Azure SQL, AI, and Microsoft Fabric, often presenting talks on new releases, internals, and specialized topics at events such as SQLBits, Microsoft Build, Microsoft Ignite, PASS Summit, DevIntersection, and VS Live. You can also learn Azure SQL from him on the popular series aka.ms/azuresql4beginners. You can follow him at @bobwardms or linkedin.com/in/bobwardms. Bob is the author of the books Pro SQL Server on Linux, SQL Server 2019 Revealed, Azure SQL Revealed, and SQL Server 2022 Revealed, available from Apress Media.   Topics of Discussion: [4:22] Bob's long history with Microsoft and the evolution of SQL Server. [6:41] What are the big use cases that SQL Server can now do? [7:38] Beyond RDBMS framework. [9:34] Building innovation off an already trusted brand. [9:50] What's the vision of AI on SQL Server? [10:51] It's all about smarter searching. [14:26] AI assistance features in SQL Server, such as the SQL Copilot and natural language to SQL query generation. [16:02] Hybrid searching. [19:41] Challenges and opportunities in AI Integration. [20:43] Content moderation is now being added to the loop. [22:39] The categories of different models. [23:16] The potential for industry-specific models to enhance AI capabilities in fields like insurance underwriting. [28:19] Knowing which model to use. [33:17] The trend towards industry-specific training of AI models to better suit specific business needs. [34:07] The current vision for SQL Server. [35:22] Innovating in the cloud. [38:30] The potential for SQL Server to handle AI workloads on small form factors, such as edge devices and standalone boards.   Mentioned in this Episode: Clear Measure Way Architect Forum Software Engineer Forum Programming with Palermo — New Video Podcast! Email us at programming@palermo.net. Clear Measure, Inc. (Sponsor) .NET DevOps for Azure: A Developer's Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon! Jeffrey Palermo's Twitter — Follow to stay informed about future events! Ep 162 with Bob Ward Bob on LinkedIn Azure SQL Revealed: The Next-Generation Cloud Database with AI and Microsoft Fabric SQL-AI-Samples Samples Intelligent Applications with Azure SQL Database LangChain   Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

Erik Darling makes your database faster in exchange for money. He is a DBA, developer, and architect with a track record of tackling even the most challenging technical issues. He runs a SQL Server Consulting and Coaching practice. In addition to his consulting services, he is also passionate about blogging, training, and contributing to open-source projects that help with SQL Server troubleshooting. He's given many public speaking engagements on the topic at conferences and events around the world, like PASS Summit and SQLBits.   Topics of Discussion: [2:57] Eric's journey into SQL Server and database performance tuning. [4:25] Challenges faced in early SQL Server work and evolving technical debt. [7:47] The standard problems with databases over time. [11:14] How technical debt shows up in SQL Server databases. [15:20] How abstraction layers like ORMs contribute to technical debt. [22:38] Performance issues as a result of technical debt in databases. [25:19] Key advice on database schema design to improve performance. [30:46] Key differences between Azure SQL DB and managed instances. [37:23] Staffing challenges and solutions for managing SQL Server environments.   Mentioned in this Episode: Clear Measure Way Architect Forum Software Engineer Forum Programming with Palermo — New Video Podcast! Email us at programming@palermo.net. Clear Measure, Inc. (Sponsor) .NET DevOps for Azure: A Developer's Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon! Jeffrey Palermo's Twitter — Follow to stay informed about future events! Darling Data Darling Data on X Erik Darling Darling Data on LinkedIn Darling Data on TikTok   Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

This past November, Eugene and I attended the 2023 PASS Data Community Summit (aka PASS Summit) in Seattle, while Kevin headed down to Orlando for the Microsoft Live! 360 event in Orlando. Having no remote option this year was fine for us, as it was great to reconnect with our friends and colleagues in the data community, as well as get updates live and in-person from Microsoft on all the new features rolling out. The focus of both conferences was eerily similar and in this episode we discuss our experiences along with a picture of what 2024 will look like. Azure services continue to be a focus and Fabric is included in that space; however, I was surprised at the number of Postgres sessions. In fact, PostGres got a whopping 30 minutes out the 90-minute Microsoft keynote. AI continued to be peppered in the conversation and Kevin gives us his take on where some of this is going. As a side reference, if you are interested in learning more about large language models, check out this video by Andrej Karpathy. The show notes for today's episode can be found at Episode 271: PASS Summit 2023 Wrap-Up. Have fun on the SQL Trail!

In this episode, the trio try to condense the news from PASS Summit and Microsoft Ignite to a 30-ish minute long conversation. Hosted on Acast. See acast.com/privacy for more information.

In this episode Warner is joined by Marcelo Adade to discuss the latest announcements from the PASS Data Summit and Microsoft Ignite! These include the general availability of Microsoft Fabric, new GenAI capabilities, new cloud integrations, new AI models, new AI SDKs and more!

Andy is speaking at PASS Summit in Seattle and Frank is speaking at the Red Hat Government Symposium in Washtington, DC.Two hosts. Two Coasts. One Podcast!

I was lucky enough to attend the very first PASS Summit in 1999. It was a brand new event, and while not overly large, it was busy and crowded in the basement of a Chicago Loop hotel. I had the chance to meet Kalen Delaney there and ask her a question. That was the highlight of the trip, but I also learned a lot about SQL Server 6.5 and 7 there, spending all the time I could in sessions and hanging out after each one listening to the questions others asked the speakers. Since then, I have been lucky enough to go to most of the Summits. The event has changed a bit, and I look forward to going to see friends each year and re-connect with them. I've also loved meeting new people, often those I've corresponded with online. Each event has been memorable and exhausting at the same time. It's a busy week, and I can sometimes feel overwhelmed. However, it's always felt like it was worth the trip. Read the rest of Looking Forward to the PASS Data Community Summit 2023

Chillie Chats With Nate Vallier About Yukon Sled Dog & White Pass Summit Excursion is today's main feature on Tuesday Travel and Cruise Industry News, February 28, 2023. This excursion will be available to guests on Cruises For Solos With Chillie - Alaska 2023 which sails August 30 on Sapphire Princess. There are still some solo openings and several couples accomodations. Also today, MSC Raises Beverage Prices; Carnival Brings Back Behind The Fun Ship Tours; Two Mega Ships Will Sail From Miami; 3 Year Cruise Opens Bookings; 32 Year Old Crew Member Dies In Chile; and much more today LIVE at 8 AM EST. To access video feed, CLICK HERE #scootaround #chilliechats ##yukonsleddogexcursion #sapphireprincess Thanks for visiting my channel. For information on the hosted Alaska solo group, https://bit.ly/3XSeLWw . Deadline for deposit for special pricing is March 1. NYTimes The Daily, the flagship NYT podcast with a massive audience. "Vacationing In The Time Of Covid" https://nyti.ms/3QuRwOS NYTimes First Person Podcast " His Ship Finally Came In, but Should He Be on It? " https://nyti.ms/3zRJo4j To access the Travel and Cruise Industry News podcast; https://cms.megaphone.fm/channel/travelcruisenews or go to https://accessadventure.net/ Save On Airfare https://bit.ly/3h6lXLf To subscribe: http://bit.ly/chi-fal As always, I appreciate super chats or any other donation to support my channel. For your convenience, please visit: https://paypal.me/chillie9264?locale.x=en_US Chillie's Cruise Schedule: https://accessadventure.net/chillies-trip-calendar/ For your special needs, contact me or Scootaround, https://www.scootaround.com/mobility-rentals, 1.888.441.7575. Use SRN 11137. Special Needs Cruising: https://youtu.be/DWR5kNM2x_g Check out my streaming partner: https://streamyard.com?pal=4889083533852672 YouTube: https://www.youtube.com/ChilliesCruises Facebook: https://www.facebook.com/chillie.falls Twitter: https://twitter.com/ChillieFalls Instagram: https://www.instagram.com/chilliefalls/ TikTok: https://www.tiktok.com/@chilliescruises Business Email: chilliefalls@gmail.com Accessible Travel Blog: https://accessadventure.net/ Chillie Chats With Sue Bryant, London Times Cruise Editor About Emerald Azzurra https://youtu.be/_bnrkqPf2gE Chillie Chats with Sylvia Longmire, Ambassador for Scootaround and WHILL Powerchairs https://youtu.be/VovRJ5Fh1I8 Chillie Chats With Disability Advocate Kristy Durso About Flying With A Wheelchair https://youtu.be/ZQVVPPpCLyc Chillie Chats With Special Guest Kevin Martin, 30 And A Wake Up https://youtube.com/live/wa-AX8CAzYI Chillie Chats With Kelly Narowski, Disability Rights Advocate and Avid Traveler https://youtu.be/NFB7LhkJ7go and https://youtu.be/LxbC5UW-Lsk Casino Loyalty Programs with Sue Sherer https://youtu.be/p0SsewJC_cE Learn more about your ad choices. Visit megaphone.fm/adchoices

Andy is currently in Seattle attending the PASS Summit and I will be headed to AWS re:Invent this year!

The PASS Summit has been an annual event for a lot of my career. I attended the first one in 1999 and most of the rest through the years. After last year's virtual Summit, I was concerned that we wouldn't have an annual event where the most, brightest, and friendliest data platform people came together. Redgate purchased the assets out of the PASS bankruptcy and has committed to future Summits. This year's Summit is virtual, and more importantly... It's free, and you can register today Read the rest of A New Community Summit

SQL Server object disks on Windows Server can be expanded at any time with no issues, but Linux doesn't quite work like that by default. In a situation where you run out of space, you're out of luck, unless you know some secrets about Linux. The mysterious Linux Logical Volume Manager must be used before you put anything on the disks to properly set up the disks so you can expand them in a pinch in the future. In this episode with David Klee, we're going to walk through how to use this service to set up your object volumes the right way from the beginning and show you how to expand the disks with no outage. Break out your pocket protectors and come learn with someone who was compiling Linux kernels while in elementary school! [00:37] About David Klee[01:18] Challenge overview[02:14] Linux Logical Volume Manager [03:00] Demo: Logical Volume Manager Setup[09:22] Who should this set up[10:05] Getting started Resources:$2 Million Reasons to Start with TuningDavid Klee's websiteHeraflux Data Platform ConsultantsSQLlibrium Training About David Klee:David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies and SQLibrium Education. His areas of expertise are cloud, virtualization, performance tuning, and business continuity. David speaks at a number of national and regional technology-related events, including the PASS Summit, VMware VMworld, SQLBits, SQL Saturday events, and many SQL Server User Groups. About MVPs:Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram

SQL Server object disks on Windows Server can be expanded at any time with no issues, but Linux doesn't quite work like that by default. In a situation where you run out of space, you're out of luck, unless you know some secrets about Linux. The mysterious Linux Logical Volume Manager must be used before you put anything on the disks to properly set up the disks so you can expand them in a pinch in the future. In this episode with David Klee, we're going to walk through how to use this service to set up your object volumes the right way from the beginning and show you how to expand the disks with no outage. Break out your pocket protectors and come learn with someone who was compiling Linux kernels while in elementary school! [00:37] About David Klee[01:18] Challenge overview[02:14] Linux Logical Volume Manager [03:00] Demo: Logical Volume Manager Setup[09:22] Who should this set up[10:05] Getting started Resources:$2 Million Reasons to Start with TuningDavid Klee's websiteHeraflux Data Platform ConsultantsSQLlibrium Training About David Klee:David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies and SQLibrium Education. His areas of expertise are cloud, virtualization, performance tuning, and business continuity. David speaks at a number of national and regional technology-related events, including the PASS Summit, VMware VMworld, SQLBits, SQL Saturday events, and many SQL Server User Groups. About MVPs:Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram

Geeks on Screens with Coffee Episode 56 - SQL Bob Look who I bumped into at the water cooler/tea room/corridor? It's only Bob Pusateri (@SQLBob ) I must dash, the kettle has almost boiled. Youtube : https://youtu.be/tZSDsDTwEVk Love you! Bio: Bob Pusateri is a Microsoft Certified Master and Microsoft Data Platform MVP with over fifteen years of experience working with database systems. His areas of expertise are performance tuning, cloud architecture, and VLDBs (Very Large Databases). When not in front of a computer, Bob loves enjoying the outdoors with his young family. You can read his blog at bobpusateri.com, and reach him on Twitter at @SQLBob. Bob frequently speaks at technology-related events, including the PASS Summit, SQL Saturday events, PASS virtual chapter webinars, and SQL Server User Groups.

Geeks on Screens with Coffee Episode 50 - Frog man with Wings... Look who I bumped into at the water cooler/tea room/corridor? It's only Alex Whittles (@PurpleFrogAlex ) Get ready for Alex - the gift that keeps giving.... Bio: Alex 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 in Business Intelligence, is a chartered engineer, and a member of Mensa. Community leadership includes being on the SQL Bits 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, SQL Bits, SQL Saturdays, 24 HOP and the PASS Summit. I must dash, the kettle has almost boiled. Love you!

Geeks on Screens with Coffee Episode 46 - Big DAATTAA Clusters vs SQL Pooooooowl Look who I bumped into at the water cooler/tea room/corridor? It's only Bob Ward (@BobWardMS ) i thought I would get Bob Ward on to talk about SQL Server Big Data Clusters, is it going to put me out of a job? Bio: Bob Ward is a Principal Architect for the Microsoft Azure Data SQL Server team, which owns the development for all SQL Server versions. Bob has worked for Microsoft for 26+ years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2019 including Azure. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, and performance at events such as PASS Summit, SQLBits, SQLIntersection, Microsoft Inspire, and Microsoft Ignite. You can follow him at @bobwardms or linkedin.com/in/bobwardms. Bob is the author of the books Pro SQL Server on Linux and SQL Server 2019 Revealed available from Apress Media. I must dash, the kettle has almost boiled. Love you!

Guy and Eitan discuss lots of interesting recent news, and also about various technical topics in SQL Server. Relevant links: News about PASS and SQL Saturday: What’s next for PASS Summit this fall? Ideas forum The SQL Saturday Foundation Board of Directors The new Azure Data Community webpage from Microsoft PASS Summit 2020 session recordings PASS Pro Educational Series at Red Gate University Data Saturday #1 Recordings Available on YouTube Around the Clock with Azure SQL and Azure Data Factory Microsoft Ignite 2021 Book of News Azure retiring a lot of services on February 29, 2024 Azure Tips and Tricks: 5 Things you didn't know about Azure SQL Database SQL Server Automatic Tuning SQL Server Transaction Log And High Availability Solutions - Pros and Cons and more | Destin Joy Classic GUI issue or how to fix MAX Server memory too low | Vitaly Bruk

Geeks on Screens with Coffee Episode 45 - Mental Health and maybe Azure Data Studio Look who I bumped into at the water cooler/tea room/corridor? It's only Julie Koesmarno (@MsSQLGirl) Julie Koesmarno is a Principal Program Manager at Microsoft, for the SQL Tools and Experiences team. She has worked in Data Management, Data Warehouse and Big Data Analytics solutions both on-premises and cloud over the past decade. She's currently working on Azure Data Studio improvements for modern data professionals. She is a regular speaker for user groups and conferences such as SQL Saturdays, PASS Summit and SQL Bits. She is a co-author of SQL Server 2017 Machine Learning Services with R. I must dash, the kettle has almost boiled. Love you!

גיא ואיתן מדברים על אירועים מעניינים שהיו לאחרונה ואירועים עתידיים בזמן הקרוב, על איך לחסוך כסף בענן, ועוד נושאים מעניינים. קישורים רלוונטיים: Past and upcoming Data Platform Meetup sessions: Ask Us Anything: Database Performance Tuning and Optimization (February 21st) Ask Us Anything: Database Performance Tuning and Optimization (April 4th) Azure Data Fundamentals: Manage Non-Relational Data Stores In Azure (April 5th) Why Database Maintenance is so Important? (April 12th) Transferring and Manipulating Data between Azure SQL Databases (May 5th) News about PASS and SQL Saturday: What's next for PASS Summit this fall? Ideas forum The SQL Saturday Foundation Board of Directors The new Azure Data Community webpage from Microsoft PASS Summit 2020 session recordings PASS Pro Educational Series at Red Gate University Data Saturday #1 Recordings Available on YouTube Getting insights into the utilization of SQL Server licenses on Azure to optimize cost Powershell script to find unattached resources in Azure רוצים שנבדוק את הסביבה שלכם בענן ונמצא הזדמנויות לחיסכון? צרו איתנו קשר How to Reduce Your Database Costs Announcing Power BI Premium Per User general availability and autoscale preview for Gen2 קבוצת המומחים של מדירה בטלגרם אינדקסים שכדאי ליצור בתוך SSISDB אינדקסים שכדאי ליצור בתוך MSDB שימוש בכרטיס מאיץ גרפי מתוך SQL Server  

Alberto Ferrari is a Business Intelligence consultant. He is also a speaker in international conferences like European PASS Conference and PASS Summit.

Zum Freitag dem 13. gibt es gehacktes. Hat der Ben wirklich den PASS Summit gehackt? Hat Tillmann Hackerfreunde in der dotnet-Community? Warum trägt Frank eine Hockeymaske und klingt die Musik die Tobi hört wie ein Unfall in einer Hächselmaschine? Es wird blutig.

In this episode we talk with Tracy Boggiano and William Durkin about Query Store, Open Query Store, and the fun of writing books. We also introduce a new feature that Andrew abuses and encourages the guests to abuse as well. GUESTS Tracy Boggiano Blog: http://databasesuperhero.com/ Twitter: https://twitter.com/TracyBoggiano William Durkin Blog: https://datamasterminds.io/blog/ Twitter: https://twitter.com/sql_williamd LINKS FROM THE SHOW Mixed Extents T-Shirts: https://www.bonfire.com/store/eightkb/ Posts from Tracy: https://tracyboggiano.com/archive/2018/06/query-store-error-state/ https://tracyboggiano.com/archive/2018/06/query-store-usage-and-adaptive-plan-tuning-usage/ Tracy at PASS Summit: https://www.pass.org/summit/2020/Learn/Session-Details/sid/104557 Tracy's Book: https://www.amazon.com/Query-Store-SQL-Server-2019/dp/1484250036 Links from William: Company: https://datamasterminds.io/ Open Query Store: https://www.openquerystore.com/ Data Grillen: https://datagrillen.com/ William's Books: https://www.amazon.com/William-Durkin/e/B073722MP7 Intro sound from Freesound: https://freesound.org/people/Kleber_KGF/sounds/354019/

In this episode we talk with Tracy Boggiano and William Durkin about Query Store, Open Query Store, and the fun of writing books. We also introduce a new feature that Andrew abuses and encourages the guests to abuse as well. GUESTS Tracy Boggiano Blog: http://databasesuperhero.com/ Twitter: https://twitter.com/TracyBoggiano William Durkin Blog: https://datamasterminds.io/blog/ Twitter: https://twitter.com/sql_williamd LINKS FROM THE SHOW Mixed Extents T-Shirts: https://www.bonfire.com/store/eightkb/ Posts from Tracy: https://tracyboggiano.com/archive/2018/06/query-store-error-state/ https://tracyboggiano.com/archive/2018/06/query-store-usage-and-adaptive-plan-tuning-usage/ Tracy at PASS Summit: https://www.pass.org/summit/2020/Learn/Session-Details/sid/104557 Tracy's Book: https://www.amazon.com/Query-Store-SQL-Server-2019/dp/1484250036 Links from William: Company: https://datamasterminds.io/ Open Query Store: https://www.openquerystore.com/ Data Grillen: https://datagrillen.com/ William's Books: https://www.amazon.com/William-Durkin/e/B073722MP7 Intro sound from Freesound: https://freesound.org/people/Kleber_KGF/sounds/354019/

Guy and Eitan discuss PASS Virtual Summit 2020, what we should expect, whether it's worth the price tag or not, and discuss the future of the PASS organization. Relevant links: https://www.pass.org/summit/2020/  Imagine All the People | Guy Glantser SELECT TOP (3) Pre-Conference Sessions | Guy Glantser Why I’m Not Speaking at PASS Summit and You Shouldn’t Either | Joey D'Antoni https://sqlsaturday.com/ https://pass.org/ https://meetup.com/ https://sessionize.com/ https://sqlfriday.net/ https://groupby.org/ https://dataweekender.com/ https://tsqltuesday.com/ https://curatedsql.com/ Eitan Blumin is a Data Platform MVP!

הצטרפו לגיא ואיתן בתוכנית הראשונה מזה הרבה זמן בה אנחנו סוף סוף מארחים מישהו נוסף בתוכנית: עדי כהן, הידוע גם בתור "המזגן", יש לו הרבה מה לספר וגם ללמד על נסיונו עם מערכות קריטיות בקידמת הטכנולוגיה. הפרופיל של עדי בלינקד-אין: https://www.linkedin.com/in/adi-cohn-8299811a קישורים נוספים: Data Platform Meetup - Israel SE7EN Deadly Sins of Database Design | Ami Levin  Data Weekender #TheSQL - 17th Oct 2020 PASS Summit 2020

Within Azure SQL maintenance tasks such as backups and integrity checks are handled for you, and while you may be able to get away with automatic updates keeping your statistics up-to-date, sometimes it's not enough. Proactively managing statistics in Azure SQL requires some extra steps, and in this Data Exposed episode with Erin Stellato, we'll step through how you can schedule and automate regular updates to statistics. [01:15] Overview of statistics[02:00] Schedule & automate updates to statistics demo[07:02] Runbooks Resources:SQL Server Maintenance SolutionSQL Server Index and Statistics MaintenanceAbout Erin Stellato:Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.About MVPs:Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram

Zunächst tauschen wir uns über das, was zum diesjährigen PASS Summit bisher bekannt gegeben wurde aus um dann auf das Thema Whiteboards / Surface Hub zu kommen. Und wie sollte es anders sein, nach der Stunde muss der Weissman an die Tafel und hundert Mal schreiben "Ich darf den Frank nicht wegen des Druckers dissen".

Ein Blick hinter die Kulissen der PASS - Oliver erklärt den Zusammenhang zwischen PASS Global und PASS Deutschland. Ben erklärt, warum es sich lohnt, auch am virtuellen PASS Summit teilzunehmen und Tillmann vernetzt Bienen.

Chris and Chris return with an active-passive approach to all things High Availability; they talk Log Shipping, Replication, Clustering, Mirroring and Availability Groups. In the news we hear the latest Microsoft announcement along with our regular Data Breach round-up. Reminiscing about his time at PASS Summit in Seattle, Chris has an Un-win whilst enjoying a can of Pike IPA. So, grab yourself a beer and tune in - cheers!

Andy walks around the PASS Sumitt 2019 expo floor and bumps into his favorite editor to brainstorm some new book ideas. This is part of our on going coverage of PASS 2019 Summit. Let us know in the comments how we’re doing and what you’d like to see. Live video version of this Data Point is at https://www.facebook.com/DataDrivenTV/videos/3136932926333654/ (https://www.facebook.com/DataDrivenTV/videos/3136932926333654/) Watch all our live videos at  https://www.facebook.com/DataDrivenTV (https://www.facebook.com/DataDrivenTV)  . Like us on Facebook to be notified of when we go live.  

In this Data Point, Andy talks to us outside of a Waffle House in Raleigh about announcements from Ignite and his upcoming trip to the PASS Summit.   Transcript (experimental) Hey all this is Andy an this is the beginning. Well, not really. It’s kind of in the middle of my trip to PASS Summit, 2019 looking forward to getting out to Seattle, catching up with old friends, making new friends. And we’re in my Redgate shirt today friend of Redgate Awesome company. Love you guys looking forward to seeing you all too. And I am in Raleigh. I am at Waffle House. No one who knows me will be surprised by that. And. I’m going to grab a quick bite to eat catch the first flight. And I’ve gotta connect and of course, every now and then I Get Lucky and get a direct flight from RDU to Seattle but exciting news out of ignite yesterday. If you didn’t get a chance to watch those keynotes. You can watch him on YouTube. They’re all over such a an the crew dropped a bunch of announcements about new cool tech coming out very impressed. I was very impressed by a lot of what I saw there. SQL Azure SQL, DW has been rebranded that was a big one. Just looking at this whole approach where they seem to be using the technology that they built to stack new technology on Top of it absolutely love that approach. This is the little individual units of technology are like design patterns and seeing them put those design patterns together in these little chunks together. I liken it to Legos. And they built the you know the bottom layers already and now they’re building on Top of that it’s pretty cool stuff. And you know, there’s a lot of marketing mix in their marketing is not a bad thing, but from a technology standpoint if it does any of what they said it does it still pretty good leap forward an I’m sure that it does it probably does more than they mentioned so as I head out this morning to breakfast. I hope all of you are having a great day. If you can’t make it just passed summit. There’s past TV and they’ll be showing the key notes from the past summit, you can watch the ignite. Keynotes as well, and it’s going to be a neat week, Anna in technology, so you’ll be good.

In this show: MySQL, Vertica, Azure Data Explorer and Matan 24 Hours of PASS: Summit Preview 2019 PASS Summit 2019: Session Schedule The Data Bias in Song Contests How SQL Server Compares Strings with Trailing Spaces Using Azure Data Explorer and Fastly to Improve Taboola Customer Experiences Kusto in Taboola – Azure Data Explorer

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.

How did Chris Webb start working with SSAS? What is the future of SSAS On-Premise? How often the Direct Query has chance to being used in Power BI? What was the story of the beginnings of Chris' consultancy company?Check these things and much more in this episode. Chris Webb is independent consultant specialising in Analysis Services, MDX, Power Pivot, DAX, Power Query and Power BI in general. He has been blogging about Microsoft BI for over 10 years, and racked up over 1000 posts on his blog! Also he speaks at a number of conferences including SQLBits, the PASS Summit, the PASS BA Conference, SQL Saturdays and user groups.The author of "Power Query for Power BI and Excel", a co-author of few other books and also he co-authored the white paper "Planning a Power BI Enterprise Deployment" for Microsoft.This talk has taken place during Data Relay (formerly SQL Relay) conference in Birmingham (UK), on 10th October 2018 (Wednesday).Interviewers: Kamil Nowinski.

How did Chris Webb start working with SSAS? What is the future of SSAS On-Premise? How often the Direct Query has chance to being used in Power BI? What was the story of the beginnings of Chris' consultancy company?Check these things and much more in this episode. Chris Webb is independent consultant specialising in Analysis Services, MDX, Power Pivot, DAX, Power Query and Power BI in general. He has been blogging about Microsoft BI for over 10 years, and racked up over 1000 posts on his blog! Also he speaks at a number of conferences including SQLBits, the PASS Summit, the PASS BA Conference, SQL Saturdays and user groups.The author of "Power Query for Power BI and Excel", a co-author of few other books and also he co-authored the white paper "Planning a Power BI Enterprise Deployment" for Microsoft.This talk has taken place during Data Relay (formerly SQL Relay) conference in Birmingham (UK), on 10th October 2018 (Wednesday).Interviewers: Kamil Nowinski.

This is episode 75 recorded on November 9th, 2018 where John & Jason talk about the news coming out of PASS Summit and break down the introduction of Dataflows. For show notes please visit www.bifocal.show

Episode 55 of Knee-deep in tech was recorded at the PASS Summit in Seattle. Here Alexander interviewed two amazing people from the #SQLFamily. First up was Eugene Meidinger (@SQLGene) where we talked about Power BI, and second was Angela D. Tidwell (@AngelaTidwell) where we talked talked about data science.We'll be doing webinars in the not-so-distant future, and we'd love for you to tell us what you want the webcast to be about!As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just tweet Alexander (@arcticdba) or Simon (@bindertech)! See acast.com/privacy for privacy and opt-out information.

While Andy and Tim are living it on at the PASS Summit in Seattle, Frank was at the University of Virginia today running a hands-on-lab (https://github.com/Microsoft/computerscience/tree/master/Labs/Deep%20Learning/200%20-%20Machine%20Learning%20in%20Python)  showing off the basics of the data science process: ingestion, processing, analysis, and visualization. #2Hosts2Coasts

In dieser Folge sind unsere drei Protagonisten in ein Flugzeug geklettert und nach Seattle in die USA geflogen. Nicht alleine um den Podcast aufzuzeichnen sondern vor allem um am diesjährigen PASS Summit teilzunehmen. Im Rahmen des Podcasts werden viele der Neuerungen bei der Microsoft Data Platform, die auf dem PASS Summit vorgestellt, vorher aber schon auf der Ignite angekündigt wurden, besprochen. Außerdem haben wir in dieser Folge nicht einen sondern sogar zwei Gäste. Die Gäste sind "hot like Wasabi Mustard Sauce" - wir sprechen mit dem Power BI Dream Team Adam Saxton und Patrick LeBlanc über die Neuigkeiten in Power BI, insbesondere darüber, dass man nun auch Reporting Services Berichte im Power BI Service veröffentlichen kann. Natürlich kommen auch die Rubrik "Filme die nur Frank gesehen" hat nicht zu kurz, zumal auf dem Flug nach San Francisco Zeit für 5 (in Worten fünf!!!) Filme war.

Grant Fritchey is a Microsoft SQL Server MVP with over 20 years of experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0, back in 1995. He has developed in Visual Basic, Visual Basic .NET, C# and Java. He is the author of the books SQL Server Execution Plans (Simple-Talk), SQL Server Query Performance Tuning (Apress) and co-Author “Expert Performance Indexing”, “SQL Server MVP Deep Dives 2”, “Beginning SQL Server 2012 Administration” and “Pro SQL Server 2012 Practices”.Since 2009 he has been awarded as a Microsoft SQL Server MVP. In 2014 I was awarded as a Dunn & Bradstreet MVP. In 2011 I received the Tech10 Award in Rhode Island and joined Red Gate Software as a Product Evangelist in January.Grant volunteers at PASS, currently serving on the PASS Board of Directors as the President.This talk has taken place during PASS Summit in Seattle, WA, on 3rd November 2017 (Friday).Do you wanna know why Grant is so-called Scary DBA? How is he sharing his working time between Redgate and PASS and who has given him 6-weeks sabbatical? What is his approach to teaching, speaking and working? What does mean work-life balance for him?Check this out right now.

Grant Fritchey is a Microsoft SQL Server MVP with over 20 years of experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0, back in 1995. He has developed in Visual Basic, Visual Basic .NET, C# and Java. He is the author of the books SQL Server Execution Plans (Simple-Talk), SQL Server Query Performance Tuning (Apress) and co-Author “Expert Performance Indexing”, “SQL Server MVP Deep Dives 2”, “Beginning SQL Server 2012 Administration” and “Pro SQL Server 2012 Practices”.Since 2009 he has been awarded as a Microsoft SQL Server MVP. In 2014 I was awarded as a Dunn & Bradstreet MVP. In 2011 I received the Tech10 Award in Rhode Island and joined Red Gate Software as a Product Evangelist in January.Grant volunteers at PASS, currently serving on the PASS Board of Directors as the President.This talk has taken place during PASS Summit in Seattle, WA, on 3rd November 2017 (Friday).Do you wanna know why Grant is so-called Scary DBA? How is he sharing his working time between Redgate and PASS and who has given him 6-weeks sabbatical? What is his approach to teaching, speaking and working? What does mean work-life balance for him?Check this out right now.

In this episode, I had the pleasure of speaking with Chris Webb, a well respected independent consultant based in the UK. He specialises in Analysis Services, MDX, Power Pivot, DAX, Power Query and Power BI in general. He is a widely read blogger having authored more than a 1000 posts over the last 10 years. Chris regularly speaks at leading industry conferences and events including SQLBits, the PASS Summit, the PASS BA Conference, SQL Saturdays and user groups. His blog can be found at blog.crossjoin.co.uk.

Pedro Lopes is a Senior Program Manager in the Database Systems Group, based in Redmond, WA, USA. He over 15 years of industry experience. He is currently responsible for Program Management of database engine features for in-market versions of SQL Server, with special focus on the Relational Engine.He also works closely with several Tier 1 SQL Server customers, as well as partners in the field, to understand and gather information about product usage and feedback to drive improvements into the product. Prior to this role, he was a Premier Field Engineer based in Europe for several years.He has deep understanding and experience in various features of the product spanning several versions of SQL Server, starting with SQL Server 7 and up to and including SQL Server 2016.This talk has taken place during PASS Summit in Seattle, WA, on 3rd November 2017 (Friday).Why working for the Tiger Team is so fascinating? Why Pedro started to love the data? How to start to be a community leader? Is sharing knowledge an important thing? What does Pedro proud of the most?Check these answers out in this episode. 

Pedro Lopes is a Senior Program Manager in the Database Systems Group, based in Redmond, WA, USA. He over 15 years of industry experience. He is currently responsible for Program Management of database engine features for in-market versions of SQL Server, with special focus on the Relational Engine.He also works closely with several Tier 1 SQL Server customers, as well as partners in the field, to understand and gather information about product usage and feedback to drive improvements into the product. Prior to this role, he was a Premier Field Engineer based in Europe for several years.He has deep understanding and experience in various features of the product spanning several versions of SQL Server, starting with SQL Server 7 and up to and including SQL Server 2016.This talk has taken place during PASS Summit in Seattle, WA, on 3rd November 2017 (Friday).Why working for the Tiger Team is so fascinating? Why Pedro started to love the data? How to start to be a community leader? Is sharing knowledge an important thing? What does Pedro proud of the most?Check these answers out in this episode. 

Every few years, or every year now, we see a new version of SQL Server proclaimed as the best ever. A few weeks ago, I saw a number of people leaving hte MVP Summit, rating it as the best ever summit. At SQL Bits or the PASS Summit every year, there's no shortage of people posting about that event being the best conference. Is this a human view, that the latest one is often the best one ever if we enjoyed it? Perhaps we learn something and we're excited about the latest new SQL thing and so we're excited to proclaim it the best? Read the rest of The Best Ever

Michael has been doing data processing and query languages since the 1980s. Among other things he has been representing Microsoft on the XQuery and SQL design committees and has taken SQL Server beyond relational with XML, Geospatial and Semantic Search. Currently he is working on Big Data query languages such as SCOPE and U-SQL when he is not enjoying time with his family under water, on the ski slopes, or at autocross.This talk has taken place during PASS Summit in Seattle, WA, on 2nd November 2017 (Thursday).Do you ever wonder how many people work on the USQL or Azure Data Lake? What animals does Michael see from his window?Listen to this podcast to get to know what two career choices Michael had had when he finished PhD in Switzerland.

Michael has been doing data processing and query languages since the 1980s. Among other things he has been representing Microsoft on the XQuery and SQL design committees and has taken SQL Server beyond relational with XML, Geospatial and Semantic Search. Currently he is working on Big Data query languages such as SCOPE and U-SQL when he is not enjoying time with his family under water, on the ski slopes, or at autocross.This talk has taken place during PASS Summit in Seattle, WA, on 2nd November 2017 (Thursday).Do you ever wonder how many people work on the USQL or Azure Data Lake? What animals does Michael see from his window?Listen to this podcast to get to know what two career choices Michael had had when he finished PhD in Switzerland.

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.

Bob Ward is a Principal Architect for the Microsoft Data Group (Tiger Team) which owns the development and servicing for all SQL Server versions. Bob has worked for Microsoft for 24 years supporting and speaking on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2016. He has worked in customer support as a principal escalation engineer and Chief Technology Officer (CTO) interacting with some of the largest SQL Server deployments in the world. Bob is a well-known speaker on SQL Server often presenting talks on internals and troubleshooting at events such as SQL PASS Summit, SQLBits, SQLIntersection, and Microsoft Ignite. This talk has taken place during PASS Summit in Seattle, WA, on 2nd November 2017 (Thursday).Do you want to find out what is the next goal of Tiger Team for SQL Server? What was his first database he worked with and how SQL's world looked like before DMV appeared? What does Bob have to do with the city of Łódź and why he does like to return to Poland?Listen to this episode to find out all answers and more.

Bob Ward is a Principal Architect for the Microsoft Data Group (Tiger Team) which owns the development and servicing for all SQL Server versions. Bob has worked for Microsoft for 24 years supporting and speaking on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2016. He has worked in customer support as a principal escalation engineer and Chief Technology Officer (CTO) interacting with some of the largest SQL Server deployments in the world. Bob is a well-known speaker on SQL Server often presenting talks on internals and troubleshooting at events such as SQL PASS Summit, SQLBits, SQLIntersection, and Microsoft Ignite. This talk has taken place during PASS Summit in Seattle, WA, on 2nd November 2017 (Thursday).Do you want to find out what is the next goal of Tiger Team for SQL Server? What was his first database he worked with and how SQL's world looked like before DMV appeared? What does Bob have to do with the city of Łódź and why he does like to return to Poland?Listen to this episode to find out all answers and more.

After having attended PASS Summit and seeing all the new features coming it out, it can be very easy to overlook the basics--they are boring.  These features have been around forever.  This may be true, but they still play an important role and ignoring them won't help get you those fancy new features any time soon. In this episode, our topic is index maintenance, with an emphasis on what has changed or what might change.  Is the query store feature going to impact the way we maintain our indexes?  We invite one our favorite guests, Sean McCown back to talk with us and give some of his thoughts. The show notes from today's episode can be found at http://sqldatapartners.com/2017/11/24/index-maintenance. Have fun on the SQL Trail!

The third special episode was recorded at PASS Summit in Seattle and is comprised of two interviews. The first is Adam Saxton and Patrick LeBlanc of Guy in a Cube, and the second is with Cloud and Datacenter MVP Rob Sewell! We are now on iTunes! Much easier to subscribe 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) Show links:Guy in a cube youtube channel@sqldbawithbeard See acast.com/privacy for privacy and opt-out information.

Have you ever had a week without a Wednesday?  Me neither, so for this episode, we recap our experience at PASS Summit and talk about all the amazing compañeros we met and give some thoughts around our very first meetup.  It was so much fun to meet everyone and both Steve and I gave sessions, which was a great experience--and a first for me. One, we both realized after the fact is, we are not good at social media or taking pictures!  We apologize we don't have a bit more to share on that front, but hey--we do have faces for radio. The show notes from today's episode can be found at http://sqldatapartners.com/2017/11/15/episode-117-pass-summit-retrospective/. Have fun on the SQL Trail!

The twentyfifth episode is up! This one will have to be called the “PASS recap” as we for once didn’t come up with a quirky name! We talk PASS Summit, ATP for Windows Defender, new stuff in Intune and a new Windows insider build!We are now on iTunes! Much easier to subscribe 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) Show links:PASS Summit See acast.com/privacy for privacy and opt-out information.

Frank and Andy chat about the people and things Andy saw at this year’s PASS Summit and Frank talks about his appearance on another data science podcast. 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 Andys excellent PASS Summit 2017 Adventure ([0:58]) Frank responded well ([6:20]) Podcast Websites rock! (https://podcastwebsites.com/account/aff.php?aff=538) ([9:00]) Frank got it working ([11:50]) Azure Data Science VM (https://docs.microsoft.com/en-us/azure/machine-learning/data-science-virtual-machine/provision-vm) ([14:20]) “How much does that cost?” ([15:15]) “How big is that row?” ([17:15]) On delivering Microsoft demos… ([18:05]) I am Frank’s hero! ([20:30]) Biml in the PASS Summit 2017 Day 1 Keynote. ([20:50]) “Stealth Biml…” ([21:40]) The Biml Book (https://smile.amazon.com/Biml-Book-Intelligence-Warehouse-Automation/dp/1484231341) ([22:00]) Frank’s Book! (https://www.packtpub.com/web-development/microsoft-silverlight-4-business-application-development-beginner%E2%80%99s-guide) ([23:50]) Kevin Hazzard shout-out (http://datadriven.tv/kevin_hazzard/) ([26:00]) Kevin’s post about database designs (https://blog.sqlauthority.com/2015/08/20/sql-server-rewriting-database-history-notes-from-the-field-094/) Rimma Nehme on CosmosDB, Planet-Scale Applications, and Selling Door-to-Door (http://datadriven.tv/rimma-nehme-cosmosdb-planet-scale-applications-selling-door-door/) ([27:45]) “There are smart people presenting in other rooms.” ([31:45]) Eugene loves the show! (https://www.facebook.com/DataDrivenTV/videos/1828120980831615/) ([33:00]) …he’s definitely a data scientist.” ([34:00]) THE Frank La Vigne ([35:30]) The Data Driven Facebook page (https://www.facebook.com/DataDrivenTV/) ([36:00]) The now-famous Dunkin Donuts Incident (http://datadriven.tv/datapoint-finding-inspiration-dunkin-donuts-door-handles-4k-downloads/) ([36:45]) The Economist Facebook Live ([37:20]) The Data Podcast by Rajib Bahar (https://itunes.apple.com/us/podcast/data-podcast/id1247751397?mt=2) ([37:45]) Book reference: The Future of the Mind by Michio Kaku (https://www.audible.com/pd/Science-Technology/The-Future-of-the-Mind-Audiobook/B00HUBJ8NM/) ([39:30]) Does Andy really exist? ([41:41]) The Data Driven Book.com (http://thedatadrivenbook.com) ([44:30]) Frank spends quality time thinking on the beltway… ([47:15]) Pod-fade ([49:00]) On editing… ([50:00]) What does one call a wizard in training? ([53:00])

Andy bumps into a fellow Virginian at the annual PASS Summit and they talk BIML.

Andy is at the PASS Summit this week and bumps into some BIML people.

Andy is a the annual PASS Summit in Seattle and he bumps into Eugene.

I'll be attending and presenting at the SQL PASS Summit in Seattle Washington this year from Oct 31-Nov 3. In this week's episode, I share why I'm excited about going, and why I've purchased a seat for a pre-conference session. (Spoiler: pre-cons are awesome!) I also give my tips on how to get the MOST value out of a big conference like the PASS Summit.

We talk to Gail Shaw about data, in all its shapes and sizes. Gail is a 10 year Microsoft MVP, and has tamed many a database in her career and shares some great insights with us. Chantal, Kenneth & Len talk data with Gail Shaw. From Gail's first 8086 PC, dual majoring in physics & computer science and printed Oracle error codes we join Gail on her journey into the realm SQL Server and how she's conquered it. We get some advice for squeezing a little more performance out of your production database, which might be more obvious than you'd think! Ever wondered about SQL Server on Linux? Gail has some great insights as to why Microsoft might gone down that route. We all take stock of Microsoft's great recent contributions to the open-source, and the efforts to liberate their tools from their operating systems. We venture into the world of big data, cautiously, while clarifying some terms and distinguishing big data from just "a lot of data". Thinking of big data in terms of analytics help focus the discussions and breaks big data up into layers. The consequences of incorrect medical diagnostics even came up! Find and follow Gail online * https://twitter.com/SQLintheWild * http://sqlinthewild.co.za/ We mention some recorded talks by Gail. * https://sqlbits.com/Sessions/Event14/All_about_Indexes * https://www.youtube.com/watch?v=y_bl9dArtmA Here are some resources mentioned in the show: * Intel 8086 - https://en.wikipedia.org/wiki/Intel_8086 * Modula-2 - https://en.wikipedia.org/wiki/Modula-2 * Microsoft Access - https://en.wikipedia.org/wiki/Microsoft_Access * MSSQL Server on Linux in Docker - https://hub.docker.com/r/microsoft/mssql-server-linux/ * 3V's of Big Data - http://whatis.techtarget.com/definition/3Vs * Data lake - https://en.wikipedia.org/wiki/Data_lake * Python - http://python.org * R - https://www.r-project.org/ * The Iris dataset - http://scikit-learn.org/stable/auto_examples/datasets/plot_iris_dataset.html * PASS Summit - http://www.pass.org/ * Microsoft Cognitive Services - https://azure.microsoft.com/en-us/services/cognitive-services/ * Decision trees - https://en.wikipedia.org/wiki/Decision_tree * Boosted Decision Tree - https://msdn.microsoft.com/en-us/library/azure/dn905801.aspx * Predictive Analytics - https://en.wikipedia.org/wiki/Predictive_analytics * Prescriptive Analytics - https://en.wikipedia.org/wiki/Prescriptive_analytics * Cortana Intelligence - https://www.microsoft.com/en-us/cloud-platform/cortana-intelligence And finally our picks Gail: * Kaggle - https://www.kaggle.com/ * Microsoft Research - https://www.microsoft.com/en-us/research/ Len: * TensorFlow - https://www.tensorflow.org/ Chantal: * Boomerang for Gmail - http://www.boomeranggmail.com/ Kenneth: * Theory of Everything - https://toe.prx.org Thanks for listening! Stay in touch: * Website & newsletter - https://zadevchat.io * Socialize - https://twitter.com/zadevchat & http://facebook.com/ZADevChat/ * Suggestions and feedback - https://github.com/zadevchat/ping * Subscribe and rate in iTunes - http://bit.ly/zadevchat-itunes

In this episode, Frank and Andy talk with Rimma Nehma about CosmosDB, Planet-Scale applications, and how she got started in Data. Links Posts by Rimma Nehme (https://azure.microsoft.com/en-us/blog/author/rimman/) CosmosDB.com (http://cosmosdb.com) @rimmanehme (https://twitter.com/rimmanehme) @AzureCosmosDB (https://twitter.com/AzureCosmosDB) Sponsor: Enterprise Data & Analytics (http://entdna.com)  – We are here to help. Sponsor: Audible.com (http://audibletrial.com/datadriven) – Get a free audio book when you sign up for a free trial! Notable Quotes Submitting to the PASS Summit 2017 ([1:10]) Blues Brothers movie reference ([3:50]) Data needs to be Everywhere ([11:00]) Planet scale ([16:00]) Spiderman reference – from Rimma! ([17:30]) Is this science fiction? ([24:24]) Battle-tested. ([25:30]) Open-source software analytics ([27:30]) The CosmosDB simulator ([32:44]) A little startup inside Microsoft ([35:30]) Rimma found query optimization really, really boring. ([37:45]) On family… ([40:45]) CosmosDB is truly out of this world. ([48:00]) On reading… ([42:00]) Selling door-to-door ([44:45])

PASS Summit is next week, and in this show, we cover the sessions, the parties, the networking opportunities and the other goodies of the summit.

PASS Summit 2016 - the world’s largest conference for SQL Server and BI Professionals - is happening October 25th-28th in Seattle, WA. Join Jennifer Moser, Lara Rubbelke, Chantel Gipe, Buck Woody,Thomas LaRock and Chuck Heinzelman as they discuss what you can you expect to see at this year’s conference. From big announcements, keynote addresses, networking and career building opportunities – this is one event you don’t want to miss![2:49] Data Science. Is that still a thing? [4:03] If someone went to PASS Summit in the past, why should they go again?[6:50] What's going on at the SQL Clinic this year?[9:21] Is PASS Summit for Developers?[11:49] What's the one thing you want attendees to prepare for at PASS Summit 2016?[17:09] Besides bacon, why else should people attend?[18:54] Keynotes!! Who's speaking this year?Why Attend? Click here and learn more__________________________If you're interested in learning more about the products or solutions discussed in this episode, click on any of the below links for free, in-depth information:Websites & Blogs:Cloud Solutions HubBuilding Clouds blog Follow the conversation @MS_ITPro Become a Fan @ facebook.com/MicrosoftITPro Subscribe to our podcast via iTunes, Stitcher, or RSS

PASS Summit 2016 - the world’s largest conference for SQL Server and BI Professionals - is happening October 25th-28th in Seattle, WA. Join Jennifer Moser, Lara Rubbelke, Chantel Gipe, Buck Woody,Thomas LaRock and Chuck Heinzelman as they discuss what you can you expect to see at this year’s conference. From big announcements, keynote addresses, networking and career building opportunities – this is one event you don’t want to miss![2:49] Data Science. Is that still a thing? [4:03] If someone went to PASS Summit in the past, why should they go again?[6:50] What's going on at the SQL Clinic this year?[9:21] Is PASS Summit for Developers?[11:49] What's the one thing you want attendees to prepare for at PASS Summit 2016?[17:09] Besides bacon, why else should people attend?[18:54] Keynotes!! Who's speaking this year?Why Attend? Click here and learn more__________________________If you're interested in learning more about the products or solutions discussed in this episode, click on any of the below links for free, in-depth information:Websites & Blogs:Cloud Solutions HubBuilding Clouds blog Follow the conversation @MS_ITPro Become a Fan @ facebook.com/MicrosoftITPro Subscribe to our podcast via iTunes, Stitcher, or RSS

PASS Summit 2016 - the world’s largest conference for SQL Server and BI Professionals - is happening October 25th-28th in Seattle, WA. Join Jennifer Moser, Lara Rubbelke, Chantel Gipe, Buck Woody,Thomas LaRock and Chuck Heinzelman as they discuss what you can you expect to see at this year’s conference. From big announcements, keynote addresses, networking and career building opportunities – this is one event you don’t want to miss![2:49] Data Science. Is that still a thing? [4:03] If someone went to PASS Summit in the past, why should they go again?[6:50] What's going on at the SQL Clinic this year?[9:21] Is PASS Summit for Developers?[11:49] What's the one thing you want attendees to prepare for at PASS Summit 2016?[17:09] Besides bacon, why else should people attend?[18:54] Keynotes!! Who's speaking this year?Why Attend? Click here and learn more__________________________If you're interested in learning more about the products or solutions discussed in this episode, click on any of the below links for free, in-depth information:Websites & Blogs:Cloud Solutions HubBuilding Clouds blog Follow the conversation @MS_ITPro Become a Fan @ facebook.com/MicrosoftITPro Subscribe to our podcast via iTunes, Stitcher, or RSS

Guy is back from a one month trip in the United States, and we're back with another show of SQL Server Radio. In this show, we talk about a few of our upcoming speaking gigs (PASS Summit and SQL Server Days in Belgium), about File-Snapshot backups in SQL Server 2016, about triggers in DB2, SQL Server 2016 CU1, about where to spend your thinking time, and more.

We start to warm up the engines towards PASS Summit, which will take place in Seattle at the end of October. Before the summit, we will host a few speakers to talk about their sessions and share some of the stuff you can expect to hear. In this show, we have Bradley Ball (blog | twitter), Data Platform Management Lead at Pragmatic Works. Among other topics, we talk to Bradley about: What you can expect to hear in Bradley’s PASS Summit precon and session Data architecture What is Microsoft APS and what’s important when working with it How Azure SQL Datawarehouse took the APS idea a step further Message queuing Bradley’s military career Items mentioned in the show: Bradley’s PASS Summit session: Indexing Internals for Developers and DBAs Bradley’s PASS Summit precon: Optimize “All Data” with a Modern Data Warehouse Solution Jason Strate – sp_IndexAnalysis We also talk about some weird meanings of the acronym “APS”. About Bradley Bradley Ball is a SQL Server MVP with about 15 years of IT experience. Bradley spent 8 years working as a defense contractor for clients such as the U.S. Army and The Executive Office of the President of the United States. He is the data platform management lead with Pragmatic Works and a Microsoft VTSP. He has presented at SQLSaturday, SSUGs, SQLRally, DevConnections, SQLBits, SQL Live 360, and PASS Summit. Bradley can be found blogging at http://www.SQLBalls.com.

A few months ago we hosted Sean McCown for a talk about indexing tips and backup performance. On this show, we have Sean again. Sean reveals tons of backup tips and tricks while talking about his new free product, Minion Backup. Among other topics, we talk about: What are VLF’s and why it’s not good to have many of them When you SHOULD use shrink Why Sean doesn’t like Policy Based Management How to monitor backup progress Regular Expressions in SSMS And as always with our guests, we play Scattergories, and Sean tells a VERY interesting story about cluster configuration. Items mentioned in the show: Minion Backup Sean’s PASS Summit session – Monster Text Manipulation: Regular Expressions for the DBA Sean’s PASS Summit precon – The Enterprise Scripting Workshop   About Sean: Sean McCown is a Microsoft Certified Master in SQL Server 2008. He is also a SQL Server MVP with over 20 years experience in databases. Sean is also founder and co-owner of the renowned website MidnightDBA.com where he records free SQL Server training videos and co-hosts the popular webshow, DBAs@Midnight.

Two weeks have passed, and another show is here! We start by talking about scary DBA sentences We continue with PASS Summit 2015 and about the sessions we’ll deliver at the summit. We then talk about: T-SQL code patterns interesting scenarios with small but very active SQL Server tables jobs that will be replaced by machines Tempdb Contention and improvements in SQL Server 2016 The power of SQL for other data solutions like Couchbase and Azure Stream Analytics And more.. Items mentioned in the show: Kendra Little – Contest: Write the Scariest DBA Sentence PASS Summit 2015 Matan Yungman – The Data Loading Performance Presentation (from 24 Hours of PASS) Dwain Camps – High Performance T-SQL using Code Patterns Matan Yungman – Can a SQL Server Table be Too Small? Will Your Job Be Done By a Machine? The Azure Stream Analytics Query Language Couchbase N1QL

On this show, we host Niko Neugebauer, a.k.a “Mr Columnstore”!. On this very fun conversation, we talk to Niko about his various roles and activities, about the improvements Microsoft is making version after version, about SQL Server 2016, and of course, about Columnstore. Among other topics, we cover: What people need to know about Columnstore How to use Columnstore the right way Columnstore and In-Memory OLTP improvements in SQL Server 2016   About Niko Niko Neugebauer is a Software Designer, living in Portugal. In the recent years he’s being fascinated by data (big and small) and its analysis. Niko also likes to write about Clustered Columnstore Indexes and SQL Server. Niko founded and leads the Portuguese SQL Server User Group , and he’s the head of the organization committee for the SQLSaturday events in Portugal. He works as a BI Consultant for OH22, where he creates intelligent solutions for Business with a focus on Data Quality. Niko presents on the topics of Microsoft Data Platform around the world at SQLSaturdays, SQLBits, PASS Summit, User Groups and local events such as Microsoft BI Conference in Portugal. He loves the human-computer interaction, and adores design, but most of all – he enjoys making technology to make life easier, and people more connected with each other. LinkedIn: http://www.linkedin.com/in/webcaravela Twitter: http://twitter.com/NikoNeugebauer

It seems like ages ago, but we had a pretty busy month on March, with lots of conferences and great time. We start the show by summarizing March Madness, with the presentations, the people, the parties and the food. We then talk about: Things to take into account when upgrading to SQL Server 2014 and when installing a new server Windows Azure SQL Database backup options and new online features Cloud adoption considerations The top 10 presentations from PASS summit 2014 And more.. Items mentioned in the show: Guy shares the holiday spirit at SQLRally Nordic 2015 Top 10 sessions of PASS Summit 2014 Azure SQL Database Backup and Restore Aaron Bertrand – More Azure SQL Database Online Operations SQL Server 2014 Upgrade Technical Guide

PASS Summit 2014 is over, and wh’re here for a recap of what happened, what was announced, what we learned in the sessions we attended, and some thoughts on the direction Microsoft is heading. Among other topics, we talk about: The summit keynote and the Microsoft vision Parallelism The new Query Store feature The new Stretched Tables feature Improvements to Cluster Quorum Backup performance improvements Database corruption recovery techniques Interesting behavior of Sequence with Delayed Durability The various activities during the summit And more.. Items mentioned in the show: PASS Summit 2014 Day 1 Keynote PASS Summit 2014 Day 2 Keynote Adam Machanic – Manhandling Paralellism, 2014 Edition Paul Randal – Advanced Data Recovery Techniques Allan Hirt – Did You Vote Today? A DBA’s Guide to Cluster Quorum Guy Glantser – Working with Very Large Tables Like a Pro in SQL Server 2014

We’re currently at PASS Summit, and things are pretty busy here, so we didn’t manage to record a new show. Instead, we republish an episode which features interviews with 3 of the top experts in the industry: Brent Ozar, Denny Cherry and Adam Machanic. They were recorded a year ago at SQLRally Amsterdam for our Hebrew version (of course the interviews were conducted in English). The interviews cover a lot of topics. Among them are professional development, the future of DBA work, SQL Server 2014, storage, parallelism, virtualization and SQLCLR. If you missed it, it’s an opportunity to catch up. After we return home, we have a lot of exciting stuff to talk about on the next shows. Items mentioned in the show: Brent Ozar – Rock Stars, Normal People, and You Brent Ozar – Why Index Fragmentation Doesn’t Matter (Video) Denny Cherry’s Podcast – People Talking Tech Adam Machanic – Next-Level Parallel Plan Forcing: An Alternative to 8649 Adam Machanic – Query Tuning Mastery: The Art and Science of Manhandling Paralellism Adam Machcnic – Data, Faster: Microsoft SQL Server Performance Techniques with SQLCLR T-SQL Tuesday

We’ve been broadcasting for about a year in Hebrew. We love it a lot, and after we got some great feedback and encouragement, we decided to do it in English too. On the first show, we talk about Pass and the various activities it facilitates like Pass Summit, SQLSaturday, Local Chapters and Virtual Chapters. Later on, we talk about our favorite features from SQL Server 2014. Items mentioned in the show: Pass SQLSaturday Pass Professional Development Virtual Chapter Guy Glantser – The Pass Spirit Guy Glantser – How to Use Parameters Like a Pro and Boost Performance How to Listen: You can listen to the show using any podcast app on your Smartphone, whether you use iPhone, Android or Windows Phone. Just search for “SQL Server Radio” in the app (don’t get confused with the Hebrew edition). If the app can’t find it, you can add the feed manually using the following URL: http://www.sqlserverradio.com/feed/podcast/ A few recommended podcast apps are the built-in iPhone and Windows Phone apps, BeyondPod (for Android only) and Stitcher. You can also listen to the show on this website, or download the file and hear it on your car stereo, MP3 player or mobile phone.

Aaron Nelson on the PASS Summit

I'm feeling nostalgic for the good ole days of November 2009, so here's my 11/6/09 hit "SQL Pass Summit Postgame - What I learned at summer camp".