Podcasts about SQL Server

No, it's not you. Windows Hello doesn't work in the dark anymore. For reasons. Say "Hello" to the Windows Hello controversy of the month! Windows AI agent in Settings and Recall export experience in Dev/Beta channels - plus the old clock is back, baby July Patch Tuesday preview: App defaults (EEA only), Share images with visual preview, and some fixes for Windows 11 (The first one is coming to Windows 10 too - tied to the DMA news from last week.) Commentary: What Apple gets right in macOS 26 (and otherwise) Surface One year with Surface Laptop 7 Microsoft issues its first firmware updates for Surface Pro 11 and Surface Laptop 7 in several months, sort of Microsoft 365 BBB complains about how Microsoft promotes Microsoft 365; Microsoft disagrees but will change the way it communicates about these features AI OpenAI, Microsoft, and... the nuclear option?? The Open AI Files provides an insider view of the company and finds it lacking Copilot Vision is GA in the United States - It's also free to try on mobile The Browser Company starts explaining Dia, finally Xbox and Games Microsoft announces (extends?) partnership with AMD on future Xbox hardware - a one minute video with plenty to parse Next-gen hardware Multi-year partnership with AMD on Xbox consoles and gaming handhelds Compatibility with existing game libraries Working closely with the Windows team, ensure Windows is the number one games platform Microsoft shares Xbox Ally details with devs, a hint at the coming Windows-based Xbox platform requirements? More Game Pass titles for June, including an old favorite Minecraft gets three great updates Steam will run natively on Apple Silicon soon. Unlike all the games. Tips and Picks Tip of the week: Don't give in App pick of the week: Camtasia online RunAs Radio this week: SQL Server 2025 with Bob Ward Brown liquor pick of the week: The Macallan 18 Sherry Oak Cask Hosts: Leo Laporte, Paul Thurrott, and Richard Campbell Download or subscribe to Windows Weekly at https://twit.tv/shows/windows-weekly Check out Paul's blog at thurrott.com The Windows Weekly theme music is courtesy of Carl Franklin. Join Club TWiT for Ad-Free Podcasts! Support what you love and get ad-free shows, a members-only Discord, and behind-the-scenes access. Join today: https://twit.tv/clubtwit Sponsor: uscloud.com

No, it's not you. Windows Hello doesn't work in the dark anymore. For reasons. Say "Hello" to the Windows Hello controversy of the month! Windows AI agent in Settings and Recall export experience in Dev/Beta channels - plus the old clock is back, baby July Patch Tuesday preview: App defaults (EEA only), Share images with visual preview, and some fixes for Windows 11 (The first one is coming to Windows 10 too - tied to the DMA news from last week.) Commentary: What Apple gets right in macOS 26 (and otherwise) Surface One year with Surface Laptop 7 Microsoft issues its first firmware updates for Surface Pro 11 and Surface Laptop 7 in several months, sort of Microsoft 365 BBB complains about how Microsoft promotes Microsoft 365; Microsoft disagrees but will change the way it communicates about these features AI OpenAI, Microsoft, and... the nuclear option?? The Open AI Files provides an insider view of the company and finds it lacking Copilot Vision is GA in the United States - It's also free to try on mobile The Browser Company starts explaining Dia, finally Xbox and Games Microsoft announces (extends?) partnership with AMD on future Xbox hardware - a one minute video with plenty to parse Next-gen hardware Multi-year partnership with AMD on Xbox consoles and gaming handhelds Compatibility with existing game libraries Working closely with the Windows team, ensure Windows is the number one games platform Microsoft shares Xbox Ally details with devs, a hint at the coming Windows-based Xbox platform requirements? More Game Pass titles for June, including an old favorite Minecraft gets three great updates Steam will run natively on Apple Silicon soon. Unlike all the games. Tips and Picks Tip of the week: Don't give in App pick of the week: Camtasia online RunAs Radio this week: SQL Server 2025 with Bob Ward Brown liquor pick of the week: The Macallan 18 Sherry Oak Cask Hosts: Leo Laporte, Paul Thurrott, and Richard Campbell Download or subscribe to Windows Weekly at https://twit.tv/shows/windows-weekly Check out Paul's blog at thurrott.com The Windows Weekly theme music is courtesy of Carl Franklin. Join Club TWiT for Ad-Free Podcasts! Support what you love and get ad-free shows, a members-only Discord, and behind-the-scenes access. Join today: https://twit.tv/clubtwit Sponsor: uscloud.com

No, it's not you. Windows Hello doesn't work in the dark anymore. For reasons. Say "Hello" to the Windows Hello controversy of the month! Windows AI agent in Settings and Recall export experience in Dev/Beta channels - plus the old clock is back, baby July Patch Tuesday preview: App defaults (EEA only), Share images with visual preview, and some fixes for Windows 11 (The first one is coming to Windows 10 too - tied to the DMA news from last week.) Commentary: What Apple gets right in macOS 26 (and otherwise) Surface One year with Surface Laptop 7 Microsoft issues its first firmware updates for Surface Pro 11 and Surface Laptop 7 in several months, sort of Microsoft 365 BBB complains about how Microsoft promotes Microsoft 365; Microsoft disagrees but will change the way it communicates about these features AI OpenAI, Microsoft, and... the nuclear option?? The Open AI Files provides an insider view of the company and finds it lacking Copilot Vision is GA in the United States - It's also free to try on mobile The Browser Company starts explaining Dia, finally Xbox and Games Microsoft announces (extends?) partnership with AMD on future Xbox hardware - a one minute video with plenty to parse Next-gen hardware Multi-year partnership with AMD on Xbox consoles and gaming handhelds Compatibility with existing game libraries Working closely with the Windows team, ensure Windows is the number one games platform Microsoft shares Xbox Ally details with devs, a hint at the coming Windows-based Xbox platform requirements? More Game Pass titles for June, including an old favorite Minecraft gets three great updates Steam will run natively on Apple Silicon soon. Unlike all the games. Tips and Picks Tip of the week: Don't give in App pick of the week: Camtasia online RunAs Radio this week: SQL Server 2025 with Bob Ward Brown liquor pick of the week: The Macallan 18 Sherry Oak Cask Hosts: Leo Laporte, Paul Thurrott, and Richard Campbell Download or subscribe to Windows Weekly at https://twit.tv/shows/windows-weekly Check out Paul's blog at thurrott.com The Windows Weekly theme music is courtesy of Carl Franklin. Join Club TWiT for Ad-Free Podcasts! Support what you love and get ad-free shows, a members-only Discord, and behind-the-scenes access. Join today: https://twit.tv/clubtwit Sponsor: uscloud.com

No, it's not you. Windows Hello doesn't work in the dark anymore. For reasons. Say "Hello" to the Windows Hello controversy of the month! Windows AI agent in Settings and Recall export experience in Dev/Beta channels - plus the old clock is back, baby July Patch Tuesday preview: App defaults (EEA only), Share images with visual preview, and some fixes for Windows 11 (The first one is coming to Windows 10 too - tied to the DMA news from last week.) Commentary: What Apple gets right in macOS 26 (and otherwise) Surface One year with Surface Laptop 7 Microsoft issues its first firmware updates for Surface Pro 11 and Surface Laptop 7 in several months, sort of Microsoft 365 BBB complains about how Microsoft promotes Microsoft 365; Microsoft disagrees but will change the way it communicates about these features AI OpenAI, Microsoft, and... the nuclear option?? The Open AI Files provides an insider view of the company and finds it lacking Copilot Vision is GA in the United States - It's also free to try on mobile The Browser Company starts explaining Dia, finally Xbox and Games Microsoft announces (extends?) partnership with AMD on future Xbox hardware - a one minute video with plenty to parse Next-gen hardware Multi-year partnership with AMD on Xbox consoles and gaming handhelds Compatibility with existing game libraries Working closely with the Windows team, ensure Windows is the number one games platform Microsoft shares Xbox Ally details with devs, a hint at the coming Windows-based Xbox platform requirements? More Game Pass titles for June, including an old favorite Minecraft gets three great updates Steam will run natively on Apple Silicon soon. Unlike all the games. Tips and Picks Tip of the week: Don't give in App pick of the week: Camtasia online RunAs Radio this week: SQL Server 2025 with Bob Ward Brown liquor pick of the week: The Macallan 18 Sherry Oak Cask Hosts: Leo Laporte, Paul Thurrott, and Richard Campbell Download or subscribe to Windows Weekly at https://twit.tv/shows/windows-weekly Check out Paul's blog at thurrott.com The Windows Weekly theme music is courtesy of Carl Franklin. Join Club TWiT for Ad-Free Podcasts! Support what you love and get ad-free shows, a members-only Discord, and behind-the-scenes access. Join today: https://twit.tv/clubtwit Sponsor: uscloud.com

Here comes SQL Server 2025! While at Build, Richard chatted with Bob Ward about releasing a preview version of SQL Server 2025. Bob discusses SQL Server 2025 as an AI-ready enterprise database with numerous capabilities specifically tailored to your organization's AI needs, including a new vector data type. This includes making REST API calls to Azure OpenAI, Ollama, or OpenAI. This is also the version of SQL Server designed to integrate with Microsoft Fabric through mirroring. There are many more features, even a new icon!LinksSQL Server 2025 AnnouncementJSON Data TypeOllamaRecorded May 20, 2025

No, it's not you. Windows Hello doesn't work in the dark anymore. For reasons. Say "Hello" to the Windows Hello controversy of the month! Windows AI agent in Settings and Recall export experience in Dev/Beta channels - plus the old clock is back, baby July Patch Tuesday preview: App defaults (EEA only), Share images with visual preview, and some fixes for Windows 11 (The first one is coming to Windows 10 too - tied to the DMA news from last week.) Commentary: What Apple gets right in macOS 26 (and otherwise) Surface One year with Surface Laptop 7 Microsoft issues its first firmware updates for Surface Pro 11 and Surface Laptop 7 in several months, sort of Microsoft 365 BBB complains about how Microsoft promotes Microsoft 365; Microsoft disagrees but will change the way it communicates about these features AI OpenAI, Microsoft, and... the nuclear option?? The Open AI Files provides an insider view of the company and finds it lacking Copilot Vision is GA in the United States - It's also free to try on mobile The Browser Company starts explaining Dia, finally Xbox and Games Microsoft announces (extends?) partnership with AMD on future Xbox hardware - a one minute video with plenty to parse Next-gen hardware Multi-year partnership with AMD on Xbox consoles and gaming handhelds Compatibility with existing game libraries Working closely with the Windows team, ensure Windows is the number one games platform Microsoft shares Xbox Ally details with devs, a hint at the coming Windows-based Xbox platform requirements? More Game Pass titles for June, including an old favorite Minecraft gets three great updates Steam will run natively on Apple Silicon soon. Unlike all the games. Tips and Picks Tip of the week: Don't give in App pick of the week: Camtasia online RunAs Radio this week: SQL Server 2025 with Bob Ward Brown liquor pick of the week: The Macallan 18 Sherry Oak Cask Hosts: Leo Laporte, Paul Thurrott, and Richard Campbell Download or subscribe to Windows Weekly at https://twit.tv/shows/windows-weekly Check out Paul's blog at thurrott.com The Windows Weekly theme music is courtesy of Carl Franklin. Join Club TWiT for Ad-Free Podcasts! Support what you love and get ad-free shows, a members-only Discord, and behind-the-scenes access. Join today: https://twit.tv/clubtwit Sponsor: uscloud.com

Are you looking forward to SQL Server 2025? Or perhaps you think this is just another release, or perhaps you are not looking for new features or capabilities in your environment. Maybe you don't care about new things, but are looking for enhancements to features introduced in 2017/2019/2022. There is certainly no shortage of things that can be improved from previous versions (cough graph *cough). I ran across an article on the five things that one person is looking forward to in SQL Server 2025. It's a good list, and the things included make me consider an upgrade. Certainly, any improvements in the performance area, especially with all the investments made in Intelligent Query Processing over the last few versions, are worth evaluating. They might help your workload, or they might not, but if they do, then upgrade. Read the rest of SQL Server 2025 Excitement

In part two of our Microsoft Build special, the trio continues exploring updates. They dig into the Azure AI Foundry Agent Service and local deployment options, and take a look at the new Digital Twin builder in Microsoft Fabric.SQL Server 2025 brings some notable features like native support for open formats and improvements vector functions, change event streaming and a new edition out there. Fabric mirroring also expands support to older SQL Server versions and PostgreSQL.And on the security side, Microsoft Purview gets smarter for AI scenarios, but it's the new Entra Agent ID that really stands out. Hosted on Acast. See acast.com/privacy for more information.

In this episode, Michael talks to Pieter Vanhove and Pratim Dasgupta about the new security changes in SQL Server 2025. The news includes updates on MCP, Private Link and Microsoft Build 2025 security sessions presented by Michael and Sarah.https://aka.ms/azsecpod

Many announcements and interesting releases came out this past month, so we got a lot to talk about in this episode! Relevant links: What's New in SQL Server 2025 - SQL Server | Microsoft Learn SQL Server 2025 - AI ready enterprise database from ground to cloud | Microsoft Community Hub Announcing Public Preview of DiskANN in SQL Server 2025 | Microsoft Community Hub SQL Server 2025: introducing optimized Halloween protection | Microsoft Community Hub SQL Server 2025: introducing tempdb space resource governance | Microsoft Community Hub Unlocking the Power of Regex in SQL Server - Azure SQL Devs' Corner Announcing the General Availability (GA) of JSON data type and JSON aggregates | Microsoft Community Hub Announcing the Public Preview of JSON index in SQL Server 2025 | Microsoft Community Hub ZSTD compression in SQL Server 2025 | Microsoft Community Hub MSSQL Extension for VS Code: GitHub Copilot Preview + UI GA MSSQL Extension for VS Code: Introducing Schema Compare (Preview) - Azure SQL Devs' Corner SQL Server Management Studio (SSMS) 21 is now generally available (GA) | Microsoft Community Hub Copilot in SSMS preview Recently released: Updates to the SqlPackage and the DacFx ecosystem | Microsoft Community Hub Visual Studio 2022 Release Notes | Microsoft Learn Free SQL Managed Instance offer is now generally available Avoid T-SQL anti-patterns with the free T-SQL analysis tool - Azure SQL Devs' Corner

Streamline your entire data workflow, from real-time change capture to querying across cloud and on-prem databases, without complex migrations or code changes using SQL Server 2025. This adds deep AI integration with built-in vector search and DiskANN optimizations, plus native support for large object JSON and new Change Event Streaming for live data updates. Join and analyze data faster with the Lakehouse shortcuts in Microsoft Fabric that unify multiple databases—across different SQL Server versions, clouds, and on-prem—into a single, logical schema without moving data. Build intelligent apps, automate workflows, and unlock rich insights with Copilot and the unified Microsoft data platform, including seamless Microsoft Fabric integration, all while leveraging your existing SQL skills and infrastructure. Bob Ward, lead SQL engineer, joins Jeremy Chapman to share how the latest SQL Server 2025 innovations simplify building complex, high-performance workloads with less effort. ► QUICK LINKS: 00:00 - Updates to SQL Server 2025 00:58 - Search and AI 03:55 - Native JSON Support 06:41 - Real-Time Change Event Streaming 08:40 - Optimized Locking for Better Concurrency 10:33 - Join SQL Server data with Fabric 13:53 - Wrap up ► Link References Start using SQL Server 2025 at https://aka.ms/GetSQLServer2025 ► Unfamiliar with Microsoft Mechanics? As Microsoft's official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft. • Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries • Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog • Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/podcast ► Keep getting this insider knowledge, join us on social: • Follow us on Twitter: https://twitter.com/MSFTMechanics • Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/ • Enjoy us on Instagram: https://www.instagram.com/msftmechanics/ • Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics  

The latest Rock release is here – what does it mean for your instance? How can you customize Rock responsibly while leveraging SQL Server best practices? Explore insights from our RX25 discussion and discover key community announcements. Hosted on Acast. See acast.com/privacy for more information.

Microsoft Build 2025 miał być świętem developerów, a wyszedł z tego marketingowy cyrk giełdowy. Łukasz i Szymon omawiają, jak Microsoft zamienił konferencję techniczną w AI hype show. Copilot ma być nowym Windows 8 - no cóż, historia lubi się powtarzać. Patoarchitekci próbują rozszyfrować Book of News napakowany buzzwordami o Agent-to-Agent Protocol i M365 Copilot tuning. AI Foundry dalej się wykłada z Customer Managed Keys po 11 miesiącach męczenia się z bugfixami. SQL Server 2025 wreszcie dostaje vector search, a SRE Agent podobno ma zastąpić cały outsourcing. Chcesz wiedzieć, dlaczego Coding Agent miał wpadkę w demo, a jeszcze większy popcorn można sobie szykować przy jego użyciu na błędach w repo .NET Runtime? Albo dlaczego Microsoft Ignite będzie jeszcze bardziej marketingowy niż Build? Słuchaj dalej. Szykuj się na solidną dawkę enterprise reality check z Patoarchitektami.     A teraz nie ma co się obijać!

Artie Intel and Micheline Learning report on Artificial Intelligence for The AI Report. Google DeepMind’s GNoME project used AI to revolutionize energy storage, battery technology, and superconductors.  GraphCast, an open-source AI model, can now predict the weather up to 10 days in advance with unprecedented accuracy. This message comes from Eve.  Eve is the first legal AI that you can partner with,  train,  and teach to handle every part of your case.  Visit eve.legal. DeepMind’s AlphaGeometry 2, trained with the Gemini model, solved 83% of geometry problems from the last 25 years of the International Mathematical Olympiad, rivaling human gold medalists and pushing the boundaries of AI reasoning. Microsoft’s Copilot X Enterprise integrates next-gen GPT-4 Turbo enhancements to automate complex tasks in Office 365, supporting text, images, and code in a seamless workflow. Meta’s LLaMA 3, with over a trillion parameters, is now open source, democratizing access to advanced language models and enabling a wave of innovation across research and business. China’s WuDao 3.0 and its new AI supercomputer are setting benchmarks in computer vision, natural language processing, and robotics, outperforming many Western systems. Microsoft’s SQL Server 2025 preview brings built-in AI capabilities directly into the database engine. Apple rolled out new AI features across iPhone, iPad, and Mac, enhancing user experience with smarter automation and improved on-device intelligence. Meta is investing up to $65 billion in AI this year, including a major new data center in Louisiana to support its Llama model and future AI initiatives. OpenAI launched the o3-mini, a new model optimized for reasoning and efficiency, available to both consumers and developers, meeting the growing demand for smaller, more efficient AI models. Anthropic, Stability AI, and Hugging Face are pushing the boundaries with generative models and developer tools, making advanced AI more accessible than ever. Specialized AI chips, like Google’s Willow, are enabling faster, more efficient AI computations. NotebookLM is helping researchers organize and analyze information faster than ever. Canva Magic Studio brings AI-powered graphic design to everyone, from pros to beginners. ElevenLabs and Murf are generating realistic AI voices for podcasts, audiobooks, and customer service. AdCreative is automating marketing campaigns with AI-driven insights and content generation. ChatGPT, Claude, DeepSeek, and Grok are leading the pack for chatbots and virtual assistants, helping with everything from brainstorming to customer service.  Video Generation: Platforms like Synthesia, Runway, and Filmora let users create high-quality videos in minutes, using avatars and AI-powered editing tools. Image Generation: GPT-4o and Midjourney are at the forefront, producing stunning visuals from simple text prompts. Notetakers: Tools like Fathom and Nyota are revolutionizing meeting productivity by transcribing and summarizing conversations in real time. Coding and App Builders: Bubble, Bolt, and Cursor enable rapid app development, even for those without a coding background. Music Generation: Suno and Udio are making waves by composing original music tracks on demand. Project management, scheduling, and customer service tools—Asana, ClickUp, Reclaim, and Tidio AI—all powered by advanced machine learning. Quantum AI ATLAS: Google’s Willow quantum AI chip is rewriting the rules of computation. This 105-bit chip solved a complex problem in five minutes—a task that would take a classical supercomputer 10 septillion years.  The AI Report

Guy talks about a recent migration project he was working on to move an on-prem SQL Server to AWS RDS. Eitan talks about a new AI-related feature in Azure SQL Databases. And we also discuss the new SNAPSHOT backup T-SQL command in SQL Server 2022. Relevant links: Importing and exporting SQL Server databases using native backup and restore - Amazon Relational Database Service Learn about Amazon RDS maintenance window | AWS re:Post LLM Structured Output from Azure SQL Explained - Azure SQL Devs' Corner Create a Transact-SQL snapshot backup - SQL Server | Microsoft Learn

Nikolay and Michael discuss ten dangerous Postgres related issues — ones that might be painful enough to get onto the CTO and even CEOs desk, and then what you can do proactively. The ten issues discussed are:Heavy lock contentionBloat control and index maintenance  Lightweight lock contentionTransaction ID wraparound4-byte integer PKs hitting the limitReplication limitsHard limitsData lossPoor HA choice (split brain)Corruption of various kindsSome previous episodes they mentioned that cover the issues in more detail: PgDog https://postgres.fm/episodes/pgdogPerformance cliffs https://postgres.fm/episodes/performance-cliffsZero-downtime migrations https://postgres.fm/episodes/zero-downtime-migrations Queues in Postgres https://postgres.fm/episodes/queues-in-postgresBloat https://postgres.fm/episodes/bloatIndex maintenance https://postgres.fm/episodes/index-maintenanceSubtransactions https://postgres.fm/episodes/subtransactionsFour million TPS https://postgres.fm/episodes/four-million-tpsTransaction ID wraparound https://postgres.fm/episodes/transaction-id-wraparoundpg_squeeze https://postgres.fm/episodes/pg_squeeze synchronous_commit https://postgres.fm/episodes/synchronous_commitManaged service support https://postgres.fm/episodes/managed-service-support And finally, some other things they mentioned: A great recent SQL Server-related podcast episode on tuning techniques https://kendralittle.com/2024/05/20/erik-darling-and-kendra-little-rate-sql-server-performance-tuning-techniques/Postgres Indexes, Partitioning and LWLock:LockManager Scalability (blog post by Jeremy Schneider) https://ardentperf.com/2024/03/03/postgres-indexes-partitioning-and-lwlocklockmanager-scalability/Do you vacuum everyday? (talk by Hannu Krosing) https://www.youtube.com/watch?v=JcRi8Z7rkPgpg_stat_wal https://pgpedia.info/p/pg_stat_wal.htmlThe benefit of lz4 and zstd for Postgres WAL compression (Small Datum blog, Mark Callaghan) https://smalldatum.blogspot.com/2022/05/the-benefit-of-lz4-and-zstd-for.htmlSplit-brain in case of network partition (CloudNativePG issue/discussion) https://github.com/cloudnative-pg/cloudnative-pg/discussions/7462 ~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith credit to:Jessie Draws for the elephant artwork

גיא ואיתן מדברים על ההרצאה שאיתן העביר לאחרונה בנושא משאבים חינמיים של הקהילה, בלוגרים ומרצים ששווה להכיר בתחום ה-SQL Server, ועוד. קישורים רלוונטים: The DBA's Essential Toolkit - Eitan Blumin Brent Ozar Unlimited - SQL Server Consulting and Training Itzik Ben-Gan T-SQL - Home SQL.KIWI - Page Free Space Aaron Bertrand – SQLBlog.org Ami Levin - YouTube sp_IndexCleanup | Darling Data

In a new season of the Oracle University Podcast, Lois Houston and Nikita Abraham dive into the world of Oracle GoldenGate 23ai, a cutting-edge software solution for data management. They are joined by Nick Wagner, a seasoned expert in database replication, who provides a comprehensive overview of this powerful tool.   Nick highlights GoldenGate's ability to ensure continuous operations by efficiently moving data between databases and platforms with minimal overhead. He emphasizes its role in enabling real-time analytics, enhancing data security, and reducing costs by offloading data to low-cost hardware. The discussion also covers GoldenGate's role in facilitating data sharing, improving operational efficiency, and reducing downtime during outages.   Oracle GoldenGate 23ai: Fundamentals: https://mylearn.oracle.com/ou/course/oracle-goldengate-23ai-fundamentals/145884/237273 Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn: https://www.linkedin.com/showcase/oracle-university/ X: https://x.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode. ---------------------------------------------------------------   Episode Transcript: 00:00 Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we'll bring you foundational training on the most popular Oracle technologies. Let's get started! 00:25 Nikita: Welcome to the Oracle University Podcast! I'm Nikita Abraham, Team Lead: Editorial Services with Oracle University, and with me is Lois Houston: Director of Innovation Programs. Lois: Hi everyone! Welcome to a new season of the podcast. This time, we're focusing on the fundamentals of Oracle GoldenGate. Oracle GoldenGate helps organizations manage and synchronize their data across diverse systems and databases in real time.  And with the new Oracle GoldenGate 23ai release, we'll uncover the latest innovations and features that empower businesses to make the most of their data. Nikita: Taking us through this is Nick Wagner, Senior Director of Product Management for Oracle GoldenGate. He's been doing database replication for about 25 years and has been focused on GoldenGate on and off for about 20 of those years.  01:18 Lois: In today's episode, we'll ask Nick to give us a general overview of the product, along with some use cases and benefits. Hi Nick! To start with, why do customers need GoldenGate? Nick: Well, it delivers continuous operations, being able to continuously move data from one database to another database or data platform in efficiently and a high-speed manner, and it does this with very low overhead. Almost all the GoldenGate environments use transaction logs to pull the data out of the system, so we're not creating any additional triggers or very little overhead on that source system. GoldenGate can also enable real-time analytics, being able to pull data from all these different databases and move them into your analytics system in real time can improve the value that those analytics systems provide. Being able to do real-time statistics and analysis of that data within those high-performance custom environments is really important. 02:13 Nikita: Does it offer any benefits in terms of cost?  Nick: GoldenGate can also lower IT costs. A lot of times people run these massive OLTP databases, and they are running reporting in those same systems. With GoldenGate, you can offload some of the data or all the data to a low-cost commodity hardware where you can then run the reports on that other system. So, this way, you can get back that performance on the OLTP system, while at the same time optimizing your reporting environment for those long running reports. You can improve efficiencies and reduce risks. Being able to reduce the amount of downtime during planned and unplanned outages can really make a big benefit to the overall operational efficiencies of your company.  02:54 Nikita: What about when it comes to data sharing and data security? Nick: You can also reduce barriers to data sharing. Being able to pull subsets of data, or just specific pieces of data out of a production database and move it to the team or to the group that needs that information in real time is very important. And it also protects the security of your data by only moving in the information that they need and not the entire database. It also provides extensibility and flexibility, being able to support multiple different replication topologies and architectures. 03:24 Lois: Can you tell us about some of the use cases of GoldenGate? Where does GoldenGate truly shine?  Nick: Some of the more traditional use cases of GoldenGate include use within the multicloud fabric. Within a multicloud fabric, this essentially means that GoldenGate can replicate data between on-premise environments, within cloud environments, or hybrid, cloud to on-premise, on-premise to cloud, or even within multiple clouds. So, you can move data from AWS to Azure to OCI. You can also move between the systems themselves, so you don't have to use the same database in all the different clouds. For example, if you wanted to move data from AWS Postgres into Oracle running in OCI, you can do that using Oracle GoldenGate. We also support maximum availability architectures. And so, there's a lot of different use cases here, but primarily geared around reducing your recovery point objective and recovery time objective. 04:20 Lois: Ah, reducing RPO and RTO. That must have a significant advantage for the customer, right? Nick: So, reducing your RPO and RTO allows you to take advantage of some of the benefits of GoldenGate, being able to do active-active replication, being able to set up GoldenGate for high availability, real-time failover, and it can augment your active Data Guard and Data Guard configuration. So, a lot of times GoldenGate is used within Oracle's maximum availability architecture platinum tier level of replication, which means that at that point you've got lots of different capabilities within the Oracle Database itself. But to help eke out that last little bit of high availability, you want to set up an active-active environment with GoldenGate to really get true zero RPO and RTO. GoldenGate can also be used for data offloading and data hubs. Being able to pull data from one or more source systems and move it into a data hub, or into a data warehouse for your operational reporting. This could also be your analytics environment too. 05:22 Nikita: Does GoldenGate support online migrations? Nick: In fact, a lot of companies actually get started in GoldenGate by doing a migration from one platform to another. Now, these don't even have to be something as complex as going from one database like a DB2 on-premise into an Oracle on OCI, it could even be simple migrations. A lot of times doing something like a major application or a major database version upgrade is going to take downtime on that production system. You can use GoldenGate to eliminate that downtime. So this could be going from Oracle 19c to Oracle 23ai, or going from application version 1.0 to application version 2.0, because GoldenGate can do the transformation between the different application schemas. You can use GoldenGate to migrate your database from on premise into the cloud with no downtime as well. We also support real-time analytic feeds, being able to go from multiple databases, not only those on premise, but being able to pull information from different SaaS applications inside of OCI and move it to your different analytic systems. And then, of course, we also have the ability to stream events and analytics within GoldenGate itself.  06:34 Lois: Let's move on to the various topologies supported by GoldenGate. I know GoldenGate supports many different platforms and can be used with just about any database. Nick: This first layer of topologies is what we usually consider relational database topologies. And so this would be moving data from Oracle to Oracle, Postgres to Oracle, Sybase to SQL Server, a lot of different types of databases. So the first architecture would be unidirectional. This is replicating from one source to one target. You can do this for reporting. If I wanted to offload some reports into another server, I can go ahead and do that using GoldenGate. I can replicate the entire database or just a subset of tables. I can also set up GoldenGate for bidirectional, and this is what I want to set up GoldenGate for something like high availability. So in the event that one of the servers crashes, I can almost immediately reconnect my users to the other system. And that almost immediately depends on the amount of latency that GoldenGate has at that time. So a typical latency is anywhere from 3 to 6 seconds. So after that primary system fails, I can reconnect my users to the other system in 3 to 6 seconds. And I can do that because as GoldenGate's applying data into that target database, that target system is already open for read and write activity. GoldenGate is just another user connecting in issuing DML operations, and so it makes that failover time very low. 07:59 Nikita: Ok…If you can get it down to 3 to 6 seconds, can you bring it down to zero? Like zero failover time?   Nick: That's the next topology, which is active-active. And in this scenario, all servers are read/write all at the same time and all available for user activity. And you can do multiple topologies with this as well. You can do a mesh architecture, which is where every server talks to every other server. This works really well for 2, 3, 4, maybe even 5 environments, but when you get beyond that, having every server communicate with every other server can get a little complex. And so at that point we start looking at doing what we call a hub and spoke architecture, where we have lots of different spokes. At the end of each spoke is a read/write database, and then those communicate with a hub. So any change that happens on one spoke gets sent into the hub, and then from the hub it gets sent out to all the other spokes. And through that architecture, it allows you to really scale up your environments. We have customers that are doing up to 150 spokes within that hub architecture. Within active-active replication as well, we can do conflict detection and resolution, which means that if two users modify the same row on two different systems, GoldenGate can actually determine that there was an issue with that and determine what user wins or which row change wins, which is extremely important when doing active-active replication. And this means that if one of those systems fails, there is no downtime when you switch your users to another active system because it's already available for activity and ready to go. 09:35 Lois: Wow, that's fantastic. Ok, tell us more about the topologies. Nick: GoldenGate can do other things like broadcast, sending data from one system to multiple systems, or many to one as far as consolidation. We can also do cascading replication, so when data moves from one environment that GoldenGate is replicating into another environment that GoldenGate is replicating. By default, we ignore all of our own transactions. But there's actually a toggle switch that you can flip that says, hey, GoldenGate, even though you wrote that data into that database, still push it on to the next system. And then of course, we can also do distribution of data, and this is more like moving data from a relational database into something like a Kafka topic or a JMS queue or into some messaging service. 10:24 Raise your game with the Oracle Cloud Applications skills challenge. Get free training on Oracle Fusion Cloud Applications, Oracle Modern Best Practice, and Oracle Cloud Success Navigator. Pass the free Oracle Fusion Cloud Foundations Associate exam to earn a Foundations Associate certification. Plus, there's a chance to win awards and prizes throughout the challenge! What are you waiting for? Join the challenge today by visiting visit oracle.com/education. 10:58 Nikita: Welcome back! Nick, does GoldenGate also have nonrelational capabilities?  Nick: We have a number of nonrelational replication events in topologies as well. This includes things like data lake ingestion and streaming ingestion, being able to move data and data objects from these different relational database platforms into data lakes and into these streaming systems where you can run analytics on them and run reports. We can also do cloud ingestion, being able to move data from these databases into different cloud environments. And this is not only just moving it into relational databases with those clouds, but also their data lakes and data fabrics. 11:38 Lois: You mentioned a messaging service earlier. Can you tell us more about that? Nick: Messaging replication is also possible. So we can actually capture from things like messaging systems like Kafka Connect and JMS, replicate that into a relational data, or simply stream it into another environment. We also support NoSQL replication, being able to capture from MongoDB and replicate it onto another MongoDB for high availability or disaster recovery, or simply into any other system. 12:06 Nikita: I see. And is there any integration with a customer's SaaS applications? Nick: GoldenGate also supports a number of different OCI SaaS applications. And so a lot of these different applications like Oracle Financials Fusion, Oracle Transportation Management, they all have GoldenGate built under the covers and can be enabled with a flag that you can actually have that data sent out to your other GoldenGate environment. So you can actually subscribe to changes that are happening in these other systems with very little overhead. And then of course, we have event processing and analytics, and this is the final topology or flexibility within GoldenGate itself. And this is being able to push data through data pipelines, doing data transformations. GoldenGate is not an ETL tool, but it can do row-level transformation and row-level filtering.  12:55 Lois: Are there integrations offered by Oracle GoldenGate in automation and artificial intelligence? Nick: We can do time series analysis and geofencing using the GoldenGate Stream Analytics product. It allows you to actually do real time analysis and time series analysis on data as it flows through the GoldenGate trails. And then that same product, the GoldenGate Stream Analytics, can then take the data and move it to predictive analytics, where you can run MML on it, or ONNX or other Spark-type technologies and do real-time analysis and AI on that information as it's flowing through.  13:29 Nikita: So, GoldenGate is extremely flexible. And given Oracle's focus on integrating AI into its product portfolio, what about GoldenGate? Does it offer any AI-related features, especially since the product name has “23ai” in it? Nick: With the advent of Oracle GoldenGate 23ai, it's one of the two products at this point that has the AI moniker at Oracle. Oracle Database 23ai also has it, and that means that we actually do stuff with AI. So the Oracle GoldenGate product can actually capture vectors from databases like MySQL HeatWave, Postgres using pgvector, which includes things like AlloyDB, Amazon RDS Postgres, Aurora Postgres. We can also replicate data into Elasticsearch and OpenSearch, or if the data is using vectors within OCI or the Oracle Database itself. So GoldenGate can be used for a number of things here. The first one is being able to migrate vectors into the Oracle Database. So if you're using something like Postgres, MySQL, and you want to migrate the vector information into the Oracle Database, you can. Now one thing to keep in mind here is a vector is oftentimes like a GPS coordinate. So if I need to know the GPS coordinates of Austin, Texas, I can put in a latitude and longitude and it will give me the GPS coordinates of a building within that city. But if I also need to know the altitude of that same building, well, that's going to be a different algorithm. And GoldenGate and replicating vectors is the same way. When you create a vector, it's essentially just creating a bunch of numbers under the screen, kind of like those same GPS coordinates. The dimension and the algorithm that you use to generate that vector can be different across different databases, but the actual meaning of that data will change. And so GoldenGate can replicate the vector data as long as the algorithm and the dimensions are the same. If the algorithm and the dimensions are not the same between the source and the target, then you'll actually want GoldenGate to replicate the base data that created that vector. And then once GoldenGate replicates the base data, it'll actually call the vector embedding technology to re-embed that data and produce that numerical formatting for you.  15:42 Lois: So, there are some nuances there… Nick: GoldenGate can also replicate and consolidate vector changes or even do the embedding API calls itself. This is really nice because it means that we can take changes from multiple systems and consolidate them into a single one. We can also do the reverse of that too. A lot of customers are still trying to find out which algorithms work best for them. How many dimensions? What's the optimal use? Well, you can now run those in different servers without impacting your actual AI system. Once you've identified which algorithm and dimension is going to be best for your data, you can then have GoldenGate replicate that into your production system and we'll start using that instead. So it's a nice way to switch algorithms without taking extensive downtime. 16:29 Nikita: What about in multicloud environments?  Nick: GoldenGate can also do multicloud and N-way active-active Oracle replication between vectors. So if there's vectors in Oracle databases, in multiple clouds, or multiple on-premise databases, GoldenGate can synchronize them all up. And of course we can also stream changes from vector information, including text as well into different search engines. And that's where the integration with Elasticsearch and OpenSearch comes in. And then we can use things like NVIDIA and Cohere to actually do the AI on that data.  17:01 Lois: Using GoldenGate with AI in the database unlocks so many possibilities. Thanks for that detailed introduction to Oracle GoldenGate 23ai and its capabilities, Nick.  Nikita: We've run out of time for today, but Nick will be back next week to talk about how GoldenGate has evolved over time and its latest features. And if you liked what you heard today, head over to mylearn.oracle.com and take a look at the Oracle GoldenGate 23ai Fundamentals course to learn more. Until next time, this is Nikita Abraham… Lois: And Lois Houston, signing off! 17:33 That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

I heard Brent Ozar recently talked a bit about the SQL Server platform and its future. He also mentioned that Fabric has distracted the data platform team and it isn't a great product. I tend to agree, and I see too many bugs, holes, and problems. However at the end of this short snippet, he talks about SQL Server with an interesting comment. Is SQL Server feature complete? Read the rest of Is SQL Server Feature Complete?

In this week's episode, we look at recent Microsoft Tech updates. By popular request, we're expanding the scope beyond just Azure to include Microsoft 365, Power Platform, and similar Microsoft platforms and capabilities. What's new? What's interesting? What's retiring?(00:00) - Intro and catching up.(03:45) - Show content starts.Show links- What's new in Microsoft Sentinel- What's new in Microsoft Defender for Cloud features- CDN Domain URL change for Agents in Pipelines - Azure DevOps Blog- ActiveX disabled now in Microsoft 365- I/O performance analysis in SQL Server on Azure VMs- AI agents for beginners- Azure Networking capabilities for Copilot in Azure Feedback - Give us feedback!

In this episode of the Azure Podcast, host Evan Basalik dives into the world of Azure ExpressRoute with special guest Duong Au. They discuss the benefits of ExpressRoute, its resiliency features, and the new validation tools available to ensure robust connectivity. Tune in to learn about the latest updates, practical applications, and how to optimize your network setup for maximum reliability. Media file: https://azpodcast.blob.core.windows.net/episodes/Episode517.mp3 YouTube: https://youtu.be/o_-NfWnYtxg Resources: Email to sign up for preview of the resiliency validation: exr-resiliency@microsoft.com Resiliency Validation: Azure ExpressRoute Gateway Resiliency Validation (preview) | Microsoft Learn   Resiliency Insights: Resiliency Insights for ExpressRoute virtual network gateway (preview) | Microsoft Learn   Other updates: SQL Server on Azure VM I/O Performance Analysis - Azure updates | Microsoft Azure   Enhancements to Carbon Optimization APIs - Azure updates | Microsoft Azure 

Jerry Nixon is a Principal Program Manager on the SQL Server team focused on the Data API builder. He's also a fanatic for #CSharp, #StarTrek, and Etymology. He also serves as a professor at Colorado Christian University.   Topics of Discussion: [3:34] Why Jerry describes his life as a pearl necklace. [5:15] Jerry recommends the book Never Eat Alone and the importance of community. [6:01] How engineers and parenting are aligned. [7:02] Jerry reflects on Microsoft's history of evangelism, the rise of “opinionated” frameworks, and how .NET Aspire revives a form of proven prescriptive guidance. [9:35] Prescriptive guidance. [12:03] The inevitable evolution of .NET Aspire and how it simplifies container-based development by handling orchestration behind the scenes. [16:56] Paying more attention and awareness to the developer community. [18:30] How GraphQL fits into the Data API Builder experience, giving developers flexibility without needing to write complex backends. [21:40] Jerry talks about community feedback on Data API Builder and how real-world use cases help prioritize features and fix gaps in tooling. [31:02] Jerry's perspective on building container-based solutions. [32:15] Data API Builder's community involvement and upcoming features. [36:15] Docker Desktop. [38:58] The architectural concept of Data API Builder. [44:42] C# coding conventions at Microsoft and the friendly battles over things like naming, underscores, and formatting styles across internal teams.   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 .Net Aspire and Data API builder with the Community Jerry on LinkedIn Jerry Nixon Github Colorado Christian University Data API builder for Azure Databases samples Common C# code conventions What is Data API Builder? Quickstart: Use Data API builder with SQL   Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

Guy and Eitan worry about the decline in SQL Server feature quality. But maybe there's something else behind it? Relevant links: Improving Azure SQL Database reliability with accelerated database recovery in tempdb | Microsoft Community Hub What the Decline of Sql Server Quality means for Developers and DBAs SLA for SQL Database | Azure AI will eliminate DBA Jobs faster than you think

גיא ואיתן מדברים על כמה פיצ'רים מעניינים של SQLServer, כמה סקריפטים מעניינים ושימושיים, מנסים להיזכר מה בא ביחד עם WINDOW Clause, ודנים על איך לעשות אינדקס רבילד און-ליין כאשר אי אפשר לעשות אותו און-ליין. קישורים רלוונטים: Managed Instance link overview - Azure SQL Managed Instance | Microsoft Learn Collect Database Files Information.sql at MadeiraData/microsoft-dbas-club WINDOW clause (Transact-SQL) - SQL Server | Microsoft Learn Online Index Operations without Enterprise Edition.sql at MadeiraData/microsoft-dbas-club Guidelines for online index operations - SQL Server | Microsoft Learn

RJJ Software's Software Development Service This episode of The Modern .NET Show is supported, in part, by RJJ Software's Podcasting Services, whether your company is looking to elevate its UK operations or reshape its US strategy, we can provide tailored solutions that exceed expectations. Show Notes "So I've been focused on the code to cloud journey, I like to call it, for the template. And two years ago, my goal was to provide a solution that could take you from code to cloud in 45 minutes or less. So I wanted it to be "file new project" to deploy a solution on Azure—because that's where my main focus is—within 45 minutes."— Jason Taylor Welcome friends to The Modern .NET Show; the premier .NET podcast, focusing entirely on the knowledge, tools, and frameworks that all .NET developers should have in their toolbox. We are the go-to podcast for .NET developers worldwide, and I am your host: Jamie "GaProgMan" Taylor. In this episode, Jason Taylor (no relation) joined us to talk about his journey from Classic ASP to .NET and Azure. He also discusses clean architecture's maintainability, and his open-source Clean Architecture Solution template for ASP .NET Core, along with strategies for learning new frameworks and dealing with complexity. "Right now the template supports PostgreSQL, SQLite, and SQL Server. If you want to support MySQL, it's relatively easy to do because there's already a Bicep module or a Terraform module that you can go in and use it. So I went from 45 minutes to now I can get things up and running in like, I don't know, two minutes of effort and 15 minutes of waiting around while I make my coffee"— Jason Taylor Along the way, we talk about some of the complexities involved with creating a template which supports multiple different frontend technologies and .NET Aspire (which was news to me when we recorded), all the while maintaining the goal of being the simplest approach for enterprise development with Clean Architecture. Anyway, without further ado, let's sit back, open up a terminal, type in `dotnet new podcast` and we'll dive into the core of Modern .NET. Supporting the Show If you find this episode useful in any way, please consider supporting the show by either leaving a review (check our review page for ways to do that), sharing the episode with a friend or colleague, buying the host a coffee, or considering becoming a Patron of the show. Full Show Notes The full show notes, including links to some of the things we discussed and a full transcription of this episode, can be found at: https://dotnetcore.show/season-7/from-code-to-cloud-in-15-minutes-jason-taylors-expert-insights-and-the-clean-architecture-template/ Jason's Links: Jason's Clean Architecture repo on GitHub Jason's Northwind Traders with Clean Architecture repo on Github Connect with Jason Jason's RapidBlazor repo on GitHub Other Links: C# DevKit for Visual Studio Code Code, Coffee, and Clever Debugging: Leslie Richardson's Microsoft Journey and the C# Dev Kit in Visual Studio Code with Leslie Richardson dotnet scaffold devcontainers .NET Aspire Azure Developer CLI GitHub CLI Obsidian Supporting the show: Leave a rating or review Buy the show a coffee Become a patron Getting in Touch: Via the contact page Joining the Discord Remember to rate and review the show on Apple Podcasts, Podchaser, or wherever you find your podcasts, this will help the show's audience grow. Or you can just share the show with a friend. And don't forget to reach out via our Contact page. We're very interested in your opinion of the show, so please get in touch. You can support the show by making a monthly donation on the show's Patreon page at: https://www.patreon.com/TheDotNetCorePodcast. Music created by Mono Memory Music, licensed to RJJ Software for use in The Modern .NET Show

A domain is a set of possible values (among other definitions). I use this word a lot in my work, often with a problem domain (the thing you're trying to solve) or the domain of possible values (like the US States and Territories list). That last one is interesting, as this is often the set of data we stick in some reference or lookup table to use in a form on a screen. There is a domain as part of the SQL specification, which I never knew about. I was reading an article from Joe Celko on the CREATE DOMAIN statement. This doesn't exist in SQL Server and T-SQL, but it has been a part of PostgreSQL for quite a few versions. The article talks about the definition of a domain from a few very experienced database design people. Read the rest of A Domain for Data

In this episode of the PowerShell Podcast, we reconnect with Jess Pomfret, a PowerShell and SQL Server powerhouse, LinkedIn Learning instructor, and community advocate. From her early days in England to becoming a respected speaker and consultant, Jess shares her journey into tech, her passion for automation, and the importance of mentorship, curiosity, and community. Key topics in this episode include: Jess's transition from footballer to DBA – How a soccer scholarship led her to a tech career in the U.S. The power of PowerShell and DBA Tools – How Jess leverages PowerShell to automate SQL Server tasks and save time. Finding a community in SQL and PowerShell – Jess reflects on how welcoming both communities are and the impact they've had on her career. Career growth through speaking and mentoring – Encouraging others to speak, contribute, and grow through conferences and collaboration. Working with Data Masterminds – The benefits of working in a high-level consulting team and tips for managing multiple clients and context switching. LinkedIn Learning and teaching at scale – Behind the scenes of her professional training content and what it's like filming for LinkedIn Learning. Jess also shares her favorite DBA Tools command, productivity tips for conferences, and the story behind her podcast Finding Data Friends, which highlights voices in the data world.   Bio and links: Jess Pomfret is a Data Platform Engineer and a Dual Microsoft MVP. She started working with SQL Server in 2011, and enjoys the problem-solving aspects of automating processes with PowerShell. She also enjoys contributing to dbatools and dbachecks, two open source PowerShell modules that aid DBAs with automating the management of SQL Server instances. She has also contributed to the SqlServerDsc module, adding several new resources to use when configuring your SQL Servers. She grew up in the South West of England and outside of her DBA life enjoys Crossfit, cycling and watching proper football.  Connect with Jess on LinkedIn: https://www.linkedin.com/in/jpomfret and Bluesky: https://bsky.app/profile/jpomfret.co.uk Watch Finding Data Friends on YouTube: https://www.youtube.com/@findingdatafriends/videos Check out her LinkedIn Learning courses: https://www.linkedin.com/learning/instructors/jess-pomfret Explore DBA Tools at dbatools.io Join PowerShell Wednesdays at 2 PM EST on https://discord.gg/pdq The PowerShell Podcast: https://pdq.com/the-powershell-podcast The PowerShell Podcast on YouTube: https://youtu.be/L4zABO526bM

Well, not really the end. I doubt anyone running SQL Server 2019 is going to stop (or upgrade) just because mainstream support ended. Actually, I wonder how many of you know that SQL Server 2019 passed out of mainstream support on Feb 28, 2025. I do think the 6 or 7 of you running Big Data Clusters likely knew this was the end of any support. I saw a report in the Register on this, which includes a survey of which versions are still running. This is from an IT asset firm and matches Brent Ozar's Population report. 44% of you are running SQL Server 2019, which is the largest percentage. Since there's an additional 32% of you running versions older than 2019, I'm sure that upgrading isn't a priority. Read the rest of The End of SQL Server 2019

This week, hosts Lois Houston and Nikita Abraham are shining a light on multicloud, a game-changing strategy involving the use of multiple cloud service providers. Joined by Senior Manager of CSS OU Cloud Delivery Samvit Mishra, they discuss why multicloud is becoming essential for businesses, offering freedom from vendor lock-in and the ability to cherry-pick the best services. They also talk about Oracle's pioneering role in multicloud and its partnerships with Microsoft Azure, Google Cloud, and Amazon Web Services.   Oracle Cloud Infrastructure Multicloud Architect Professional: https://mylearn.oracle.com/ou/course/oracle-cloud-infrastructure-multicloud-architect-professional-2025-/144474 Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn: https://www.linkedin.com/showcase/oracle-university/ X: https://x.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, and the OU Studio Team for helping us create this episode.   -----------------------------------------------------------------   Episode Transcript: 00:00 Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we'll bring you foundational training on the most popular Oracle technologies. Let's get started! 00:25 Lois: Hello and welcome to the Oracle University Podcast! I'm Lois Houston, Director of Innovation Programs with Oracle University, and with me today is Nikita Abraham, Team Lead: Editorial Services. Nikita: Hi everyone! Today, we're moving on to multicloud. In our next three episodes, we'll be discussing what multicloud is and why there's so much of a buzz around it. With us is Samvit Mishra, Senior Manager of CSS OU Cloud Delivery. Hi Samvit! Thanks for joining us today. 00:55 Samvit: Hi Niki! Hi Lois! Happy to be here. Lois: So Samvit, we know that Oracle has been an early adopter of multicloud and a pioneer in multicloud services. But for anyone who isn't familiar with what multicloud is, can you explain what it means? Samvit: Absolutely, Lois. Multicloud is a very simple, basic concept. It is the coordinated use of cloud services from more than one cloud service provider.  01:21 Nikita: But why would someone want to use more than one cloud service provider? Samvit: There are many reasons why a customer might want to leverage two or more cloud service providers. First, it addresses the very real concern of mitigating or avoiding vendor lock-in. By using multiple providers, companies can avoid being tied down to one vendor and maintain their flexibility. 01:45 Lois: That's like not putting all your eggs in one basket, so to speak. Samvit: Exactly. Another reason is that customers want the best of breed. What that means is basically leveraging or utilizing the best product from one cloud service provider and pairing it against the best product from another cloud service provider. Getting a solution out of the combined products…out of the coordinated use of those services.  02:14 Nikita: So, it sounds like multicloud is becoming the new normal. And as we were saying before, Oracle was a pioneer in this space. But why did we embrace multicloud so wholeheartedly? Samvit: We recognized that our customers were already moving in this direction. Independent studies from Flexera found that 89% of the subjects of the study used multicloud. And we conducted our own study and came to similar numbers. Over 90% of our customers use two or more cloud service providers.  HashiCorp, the big infrastructure as code company, came to similar numbers as well, 94%. They basically asked companies if multicloud helped them advance their business goals. And 94% said yes. And all this is very recent data.  03:04 Lois: Can you give us the backstory of Oracle's entry into the multicloud space? Samvit: Sure. So back in 2019, Oracle and Microsoft Azure joined forces and announced the interconnect service between Oracle Cloud Infrastructure and Microsoft Azure. The interconnect was between Oracle's FastConnect and Microsoft Azure's ExpressRoute. This was a big step, as it allowed for a direct connection between the two providers without needing a third-party. And now we have several of our data centers interconnected already. So, out of the 48 regions, 12 of them are already interconnected. And more are coming. And you can very easily configure the interconnect.  This interconnectivity guarantees low latency, high throughput, and predictable performance. And also, on the OCI side, there are no egress or ingress charges for your data.  There's also a product called Oracle Database@Azure, where Oracle and Microsoft deliver Oracle Database services in Microsoft Azure data centers.  04:12  Lois: That's exciting! And what are the benefits of this product? Samvit: The main advantage is the co-location. Being co-located with the Microsoft Azure data center offers you native integration between Azure and OCI resources. No manual configuration of a private interconnect between the two providers is needed. You're going to get microsecond latency between your applications and the Oracle Database.  The OCI-native Exadata Database Service is available on Oracle Database@Azure. This enables you to get the highest level of Oracle Database performance, scalability, security, and availability. And your tech support can be provided either from Microsoft or from Oracle.  05:03 Unlock the power of AI Vector Search with our new course and certification. Get more accurate search results, handle complex datasets easily, and supercharge your data-driven decisions. From now through May 15, 2025, we are waiving the certification exam fee (valued at $245). Visit mylearn.oracle.com to enroll. 05:30 Nikita: Welcome back. Samvit, there have been some new multicloud milestones from OCI, right? Can you tell us about them?  Samvit: That's right, Niki. I am thrilled to share the latest news on Oracle's multicloud partnerships. We now have agreements with Microsoft Azure, Google Cloud, and Amazon Web Services.  So, as we were discussing earlier, with Azure, we have the Oracle Interconnect for Azure and Oracle Database@Azure. Now, with Google Cloud, we have the Oracle Interconnect for Google Cloud. And it is very similar to the Oracle Interconnect for Azure. With Google Cloud, we have physically interconnected data centers and they provide a sub-2 millisecond latency private interconnection. So, you can come in and provision virtual circuits going from Oracle FastConnect to Google Cloud Interconnect.  And the best thing is that there are no egress or ingress charges for your data. The way it is structured is you have your Oracle Cloud Infrastructure on one side, with your virtual cloud network, your subnets, and your resources. And on the other side, you have your Google Cloud router with your virtual private cloud subnet and your resources interconnecting.  You initiate the connectivity on the Google Cloud side, retrieve the service key and provide that service key to Oracle Cloud Infrastructure, and complete the interconnection on the OCI side. So, for example, our US East Ashburn interconnect will match with us-east4 on the Google Cloud side.  07:08 Lois: Now, wasn't the other major announcement Oracle Database@Google Cloud? Tell us more about that, please. Samvit: With Oracle Database@Google Cloud, you can run your applications on Google Cloud and the database as well inside the Google Cloud platform. That's the Oracle Cloud Infrastructure database co-located in Google Cloud platform data centers. It allows you to run native integration between GCP and OCI resources with no manual configuration of private interconnect between these two cloud service providers.  That means no FastConnect, no Interconnect because, again, the database is located in the Google Cloud data center. And you're going to get microsecond latency and the OCI native Exadata Database Service. So, you're going to gain the highest level of Oracle Database performance, scalability, security, and availability.  08:04 Lois: And how is the tech support managed? Samvit: The technical support is a collaboration between Google Cloud and Oracle Cloud Infrastructure. That means you can either have the technical support provided to completion by Google Cloud or by Oracle. One of us will provide you with an end-to-end solution.  08:22 Nikita: During CloudWorld last year, we also announced Oracle Database@AWS, right?  Samvit: Yes, Niki. That's where Oracle and Amazon Web Services deliver the Oracle Database service on Oracle Cloud Infrastructure in your AWS data center. This will provide you with native integration between AWS and OCI resources, with no manual configuration of private interconnect between AWS and OCI. And you're getting microsecond latency with the OCI-native Exadata Database Service.  And again, as with Oracle Database@Google Cloud and Oracle Database@Azure, you're gaining the highest level of Oracle Database performance, scalability, security, and availability. And the technical support is provided by either AWS or Oracle all the way to completion. Now, Oracle Database@AWS is currently available in limited preview, with broader availability in the coming months as it expands to new regions to meet the needs of our customers.  09:28 Lois: That's great. Now, how does Oracle fare when it comes to pricing, especially compared to our major cloud competitors?  Samvit: Our pricing is pretty consistent. You'll see that in all cases across the world, we have the less expensive solution for you and the highest performance as well.  09:45 Nikita: Let's move on to some use cases, Samvit. How might a company use the multicloud setup? Samvit: Let's start with the split-stack architecture between Oracle Cloud Infrastructure and Microsoft Azure.  Like I was saying earlier, this partnership dates back to 2019. And basically, we eliminated the FastConnect partner from the middle. And this will provide you with high throughput, low latency, and very predictable performance, all of this on highly available links. These links are redundant, ensuring business continuity between OCI and Azure.  And you can have your database on the OCI side and your application on Microsoft Azure side or the other way around. You can have SQL Server on Azure and the application running on Oracle Cloud Infrastructure. And this is very easy to configure.  10:34 Lois: It really sounds like Oracle is at the forefront of the multicloud revolution. Thanks so much, Samvit, for shedding light on this exciting topic.  Samvit: It was my pleasure.  Nikita: That's a wrap for today. To learn more about what we discussed, head over to mylearn.oracle.com and search for the Oracle Cloud Infrastructure Multicloud Architect Professional course. In our next episode, we'll take a close look at Oracle Interconnect for Azure. Until then, this is Nikita Abraham… Lois: And Lois Houston, signing off! 11:05 That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

Tastovision, Trufflepig, Cisco, Windows, VSCode, OT, SQL Server, Android, Josh Marpet, and more on the Security Weekly News. Visit https://www.securityweekly.com/swn for all the latest episodes! Show Notes: https://securityweekly.com/swn-456

Tastovision, Trufflepig, Cisco, Windows, VSCode, OT, SQL Server, Android, Josh Marpet, and more on the Security Weekly News. Visit https://www.securityweekly.com/swn for all the latest episodes! Show Notes: https://securityweekly.com/swn-456

Tastovision, Trufflepig, Cisco, Windows, VSCode, OT, SQL Server, Android, Josh Marpet, and more on the Security Weekly News. Show Notes: https://securityweekly.com/swn-456

I don't know how many of you will be disappointed or impacted by this, but Azure Data Studio (ADS) is being retired, as of 6 Feb, 2024. It will be supported for a little over a year, until 28 Feb, 2026. On one hand I'm not surprised, and on the other, I'm a little shocked by this. I have written a number of articles on ADS, and shown how things work, as well as pointed out a number of things that don't work well in the product or its extensions. These pieces have gotten a number of reads, and people have commented on them, so I wonder if there are a lot of you that are upset by this. Is this going to change the way you work? I will say that it will lightly change my work, as I do use ADS to connect to PostgreSQL, but not so much for SQL Server. Read the rest of The End of Azure Data Studio

CannCon and Ashe in America are joined by special guest Phillip Davis for a deep dive into USAID's dark money network, election fraud revelations, and the deep state's desperate attempts to keep the truth buried. The investigation into USAID is exposing billions funneled into media, NGOs, and shady foreign elections, but that's just the beginning. Phillip Davis breaks down the latest findings in Georgia's election system, including shocking evidence of test ballots being used in real elections, vote manipulation through SQL Server access, and the total lack of security in Dominion machines. The conversation also unpacks the AG's so-called "investigation" into Mesa County, revealing that the entire probe was just a recycled set of talking points from an election lobbyist...not an actual forensic analysis. Meanwhile, Elon Musk's X is exposing the deep state at record speed, with Super Bowl-level bombshells rumored to drop. Could this be the biggest narrative shift yet? Corruption is crumbling, the fraud is undeniable, and the America First movement is taking back control.

Nikita Shamgunov is a native of Russia, coming to the US for grad school in 2005. Eventually he worked at Microsoft on the SQL Server product. A fun fact - Nikita quit business school on the first day, and decided to join Facebook and find his future co-founder. All of this worked out, and he and his co-founder built SingleStore, which is one of the highest valued companies at YC. Outside of tech, he was a semi-professional athlete in Ping Pong, achieving the status of Top 10 in Washington State back when he was at Microsoft.Nikita completed his "tour of duty" at SingleStore, and post that, he joined a venture fund. He pitched incubating an idea of his at the fund, which was rolling up all Postgres instances in the world. He started to engineer an approach, the team, and the architecture - and did so in some very unique, and deliberate ways.This is the creation story of Neon.SponsorsRapyd CloudSpeakeasyQA WolfSnapTradeLinkshttps://neon.tech/https://www.linkedin.com/in/nikitashamgunov/Our Sponsors:* Check out Kinsta: https://kinsta.com* Check out Vanta: https://vanta.com/CODESTORYSupport this podcast at — https://redcircle.com/code-story/donationsAdvertising Inquiries: https://redcircle.com/brandsPrivacy & Opt-Out: https://redcircle.com/privacy

Topic: Disaster Recovery for MS SQL Server Workloads in VMware Cloud Foundation The Importance of a Reliable Disaster Recovery Plan "Deji, disaster recovery (DR) planning is often overlooked until an actual disaster occurs. Why is it particularly crucial for MS SQL Server workloads, and what are the most common mistakes enterprises make when it comes to protecting mission-critical databases?" VMware Live Recovery (VLR): Transforming Disaster Recovery in VCF "Let's talk about VMware Live Recovery (VLR)—VMware's solution for disaster recovery within VMware Cloud Foundation (VCF). Can you explain what VLR does and how it ensures a reliable, repeatable, and simplified recovery process for enterprise-class SQL Server clusters?" How VLR Simplifies Disaster Recovery for MS SQL Server in VCF "SQL Server clusters are often complex to manage, especially during failover scenarios. How does VLR reduce that complexity and provide a more seamless disaster recovery experience for organizations using VCF?" Configuring VMware Live Recovery for MS SQL Server: Key Considerations "For organizations looking to implement VMware Live Recovery (VLR) for their SQL Server workloads, what are the key steps in configuring and deploying a robust disaster recovery plan? What factors should IT teams keep in mind during setup?" Best Practices for Disaster Recovery and Business Continuity "Even with powerful tools like VLR, having a well-designed DR plan is key. What are some of the best practices you recommend to ensure SQL Server workloads can be recovered quickly and efficiently? How can businesses improve their Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO)?" How VMware Cloud Foundation Enhances Disaster Recovery "VMware Cloud Foundation (VCF) unifies compute, storage, and networking, providing a seamless infrastructure for workloads. How does VCF enhance disaster recovery capabilities for SQL Server workloads, and how does it integrate with VMware Live Recovery?" Avoiding Common Pitfalls in Disaster Recovery Planning "From your experience, what are the most common pitfalls organizations face when implementing disaster recovery for SQL Server? How can IT teams proactively test and refine their DR strategies before disaster strikes?" 12:55 - 1:00: Closing Comments Final takeaways from Deji. Wrap-Up with the Barbecue Report: Deji shares his favorite barbecue dish or a memorable community BBQ moment.

SDU Show 92 features Data Platform MVP Joey D'Antoni discussing his experiences working across SQL Server and PostgreSQL

What about SQL Server in Microsoft Fabric? Richard chats with Anna Hoffman about the preview release of SQL 2025 in Microsoft Fabric and the power of having your data store where you are doing your analytics and machine learning! Anna talks about new applications being developed using AI technologies like large language models and that often those applications need a data store - so why not keep it with the application in a configuration ideally suited for that work? The conversation digs into the relationship between existing SQL data stores and Fabric, how interconnections can happen, and perhaps a future of motion between them - but for now, it's a preview, so take a look!LinksSQL Database in Microsoft FabricMicrosoft PurviewMicrosoft EntraAzure Private Link for Azure SQL DatabaseMicrosoft Copilot for Azure SQL Databasesp_invokeRecorded December 16, 2024

Ryan is an Advocate at Redgate focusing on PostgreSQL. Ryan has been working as a PostgreSQL advocate, developer, DBA, and product manager for over 20 years, primarily working with time-series data on PostgreSQL and the Microsoft Data Platform.   Ryan is a long-time DBA, starting with MySQL and Postgres in the late '90s. He spent more than 15 years working with SQL Server before returning to PostgreSQL full-time in 2018. He's at the top of his game when learning something new about the data platform or teaching others about the technology he loves.   Topics of Discussion: [4:10] What made Ryan a database guy? [6:11] CodeMash. [6:58] Discovering the potential of SQL Server. [12:02] The state of the database in 2025 and the things generalist developers should know. [15:27] The challenge of interfacing between database types. [19:57] Is Microsoft Fabric the future? [22:44] Postgres for .NET developers. [24:46] Nuances of migrating from SQL Server to Postgres. [26:01] Postgres resources for data professionals. [35:29] Postgres and its innovative edge. [38:30] What is a vector database? [39:45] The power of Postgres indexing.   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 245 with Ryan Booz Figuring Out Fabric SQLGene Training Introduction to PostgreSQL for the data professional. Kindle Edition Postgres Playground pgEdge “Name Collision of the Year”   Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

There are many, many choices for cloud database services these days. I would hope everyone is aware of the various IaaS options in public clouds with EC2, Azure VMs, GCP Compute Engine, and others. These are often the easiest way to move your workload, but you've really just moved a VM from one place to another (likely more expensive) place. For managed databases, there are lots of choices, but you might not be aware of your options. I ran across an article that discusses the various flavors of managed databases in the big three public clouds for SQL Server. In the piece, there is a section that talks about when a managed database makes sense. I like that it discloses the development on a managed service is expensive. Read the rest of The Managed Cloud Database Options

Guy and Eitan talk about SQL Server 2025 (well, they try to, at least), and its various interesting upcoming features. Relevant links: Announcing SQL Server 2025 – SQLServerCentral What's New in SQL Server 2025 - Brent Ozar Unlimited® Optimized Locking - SQL Server | Microsoft Learn SQLBits is Coming Back to London in June 2025! - Brent Ozar Unlimited®

When I was younger, I had a variety of jobs, but in most of the positions I had to work hard for stretches. Really hard, as in more than 8 hours a day or 40 hours a week. Often as I was starting a new position, it took some time for me to develop some understanding, some skill, and some muscle memory. In some jobs, especially in restaurants, I also had to build the physical skills to be on my feet for many hours. In technology, I've often found myself unsure of how to approach a new position, aware I had knowledge gaps about how things worked, and often, I was naïve or ignorant of some piece of technology my employer used. Even at jobs where I started as a developer or DBA on a known platform (ASP or SQL Server), I sometimes encountered some aspects of the technology that I hadn't used in the past (like clustering). Read the rest of Learning to Grind

There are lots of software development methodologies. This page lists a few, among them waterfall, agile, iterative, rapid, and more. What's been interesting to me is that the process of deciding what to code and then whether it works doesn't change much between different ways of building software. Instead, the cycle time between when we ask a client what to do and when we deliver it changes. The more agile/lean we are, the lower the cycle time. The more waterfall-ish, the larger the cycle time. I guess that analysis and breakdown of problems into work also changes, as the scope in modern DevOps styles of development is smaller (more contained) than in waterfall. Read the rest of Reducing the Cycle Time

I've been very pleased with the direction of SSMS the last few years. As it's been separated from SQL Server releases and gets updated more often, I think the changes from v17 though v20 have been improvements. There are still issues, but it's been better. Now we finally have SSMS moving to a modern shell with the v21 preview and I'm excited to see how this changes the future of our tooling. However, the PM for SSMS, Erin Stellato, posted a note on LinkedIn recently asking why people don't read documentation. She also asks what you want to see in 21, so respond if you think there are holes in the SSMS docs. I think this post came about because of many responses that came from people who clearly hadn't read some documentation. Read the rest of Doing a Little Research

Thanksgiving is tomorrow in the US and it is supposed to be a holiday when we give thanks for our blessings in life. My wife usually has everyone in our family tell what they are thankful for this year. I also see many people posting things they are grateful for during the month of December. Last month I was lucky enough to have dinner with Bob Ward and we were talking about some of the things we'd seen in travels, often some stressful times for ourselves or others. We've seen many people get upset or angry or have some other reaction. Both of us have some empathy for others, recognizing that we don't really know their history or experiences, and it doesn't make sense for us to get upset. If we knew those things,  we might better understand the reaction that someone displays to a situation. Read the rest of Have Grace

I was a bit of a math nerd in high school and college. Some of you might have been as well, but I took advanced math all through high school, culminating with AP Calculus as a senior with 11 other kids (of about 320). In college, I started with Calculus III freshman year and went on to take 7 more semesters of various high level maths. One of those classes included analyzing data with linear regression, which we did with hand calculators and formulae. At SQL Saturday Pittsburgh 2024, I watched a talk from Jeff Moden on linear regression. It was a trip down memory lane, with Jeff explaining how the process worked, the flaws, and how this technique could be used to do some predictions on data stored in SQL Server. It was a great session on the topic, but I liked that Jeff showed how you can use SQL Server to do various math calculations that might be useful to analyze data. I see applications sometimes programming various formulas, but I don't often see people doing this in database queries. Read the rest of Computer Algebra

  Read the rest of New SQL Server 2022 Functions

How do you test your database? While at NDC Porto, Richard chatted with Dan Mallott about building unit tests for transactional databases like SQL Server. Dan talks about using testing frameworks constructed for the purpose, like TSQL-T, to make it easier to test individual database elements, from stored procedures to column constraints. The conversation digs into the challenges around testing, tolerating the changes to the database, and tweaking how you write your T-SQL code to be more testable. But the power of getting database tests into your CI/CD pipeline is enormous - catch more problems in testing before they become problems in production!LinkstsqltDbFitRecorded October 17, 2024

What's happening with SQL Server Management Studio? Richard chats with Erin Stellato, now at Microsoft, about the big jump coming for SSMS. Erin talks about how folks felt SSMS was a bit neglected when the reality is that there was a push to catch up with its parent codebase in Visual Studio. However, the next version of SSMS makes that jump, which opens the door to some excellent extension models. The conversation dives into the role of the Copilots in SQL Server through SSMS - helping you understand databases, write queries, and diagnose problems - eventually!LinksSQL Server Management StudioAzure SQL DatabaseSQL Server Integration ServicesSQL Server Data ToolsSQL FormatterRecorded September 26, 2024

Today, we have a special treat for you as we welcome Candice Gillhooley, a dynamic force known for blending technical prowess with marketing brilliance. In this episode, we'll explore Candice's groundbreaking approach to "sentient marketing," dive into the interplay between AI and targeted audience communication, and discuss the importance of understanding behavioral data to craft unforgettable marketing experiences. So, sit back, relax, and get ready for an episode that's sure to spark new ideas and inspire innovation.Show NotesLinksBuy the book on Amazon: https://qrcodes.at/SentientMarketingBookhttps://sentientmarketingbook.com/Candace's LinkedIn Profile https://www.linkedin.com/in/candacegillhoolley/Moments00:00 Podcast explores data science, AI, engineering trends.05:05 Ancient harvest tradition, winter preparation, birthdays coinciding.06:46 Target audience insights through effective data utilization.13:17 Enjoys startup vibes, marketing tech innovations.15:36 Data-driven marketing is essential for organizational success.20:27 Martha Stewart's over-the-top American Express commercial.22:22 Impressed by her reinvention despite past challenges.26:31 Glimmers evoke deep, happy memories and connections.29:37 Advertising targets varied generations differently nowadays.32:32 Tech changes: fascinating generational shifts, CD nostalgia.36:11 SQL Server generations discussed at SQL Saturday.39:47 Marketing tech evolves rapidly; cloud frenzy over.41:52 Hybrid cloud trend emerged after market saturation.44:33 Enjoying feedback from Andy about my work.49:28 Personality divergence; traditionalism conflicts with change.50:48 Neurodiverse individuals face job dissatisfaction challenges.54:55 Discussed AI-driven marketing with Candice Gillhooley.