Podcasts about SQL Server

Microsoft SQL Server Zero-Day Vulnerability Allows Attackers to Escalate Privileges

From bug-busting AI that's transforming Firefox to personal coding breakthroughs, the team breaks down how practical applications are cutting through skepticism and reshaping developer workflows. Plus, hear why lighter Patch Tuesdays are refreshing from time to time! Windows 11 Patch Tuesday's familiar list of updates: Network speed test, Camera tilt and pan controls, sysmon, RSAT improvements, Quick Machine Recovery improvements, WEBP support for desktop wallpaper, Emoji 16.0, etc. It's been a light year so far for Patch Tuesday features - that's a good thing New builds for Canary, Dev, and Beta late last week. Canary is nothing, Dev/Beta get Administrator Protection, Drag Tray refinements, File Explorer improvements, and fixes Android 16 QPR3 brings Desktop Mode to Android devices - and a hands-on with Pixel phones and tablets shows the way forward for Android-based laptops later this year Intel has new gaming processors for creators and gamers and they look excellent and are inexpensive AI and dev Copilot Cowork is literally Claude Cowork in Microsoft 365 - "Wave 3" for Microsoft 365 Copilot begins with a lot of agentic features, in private preview at first Google Docs, Sheets, Slides, and Drive get big Gemini updates for consumers and Workspace customers Mozilla partners with Anthropic to use AI to find bugs, and it's paying off nicely Visual Studio Code moves to a weekly update schedule The .NET 11 Preview 2 is here Xbox and gaming Microsoft starts talking up next Xbox console! It's called Project Helix and, yes, it will run Windows games New Xbox Mode is on the way Project Helix dev kits to game makers in 2027 Satya Nadella explains why he/Microsoft are "long" on gaming Gaming is a core identity for Microsoft alongside platforms, developers, and knowledge workers Tips and picks Tip of the week: Nostalgia with a purpose App pick of the week: Stardock Clairvoyance RunAs Radio this week: SQL Server in 2026 with Bob Ward Brown liquor pick of the week: Canadian Centennial Rye Whisky 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 audio and video feeds, a members-only Discord, and exclusive content. Join today: https://twit.tv/clubtwit Sponsors: helixsleep.com/windows cachefly.com/twit

From bug-busting AI that's transforming Firefox to personal coding breakthroughs, the team breaks down how practical applications are cutting through skepticism and reshaping developer workflows. Plus, hear why lighter Patch Tuesdays are refreshing from time to time! Windows 11 Patch Tuesday's familiar list of updates: Network speed test, Camera tilt and pan controls, sysmon, RSAT improvements, Quick Machine Recovery improvements, WEBP support for desktop wallpaper, Emoji 16.0, etc. It's been a light year so far for Patch Tuesday features - that's a good thing New builds for Canary, Dev, and Beta late last week. Canary is nothing, Dev/Beta get Administrator Protection, Drag Tray refinements, File Explorer improvements, and fixes Android 16 QPR3 brings Desktop Mode to Android devices - and a hands-on with Pixel phones and tablets shows the way forward for Android-based laptops later this year Intel has new gaming processors for creators and gamers and they look excellent and are inexpensive AI and dev Copilot Cowork is literally Claude Cowork in Microsoft 365 - "Wave 3" for Microsoft 365 Copilot begins with a lot of agentic features, in private preview at first Google Docs, Sheets, Slides, and Drive get big Gemini updates for consumers and Workspace customers Mozilla partners with Anthropic to use AI to find bugs, and it's paying off nicely Visual Studio Code moves to a weekly update schedule The .NET 11 Preview 2 is here Xbox and gaming Microsoft starts talking up next Xbox console! It's called Project Helix and, yes, it will run Windows games New Xbox Mode is on the way Project Helix dev kits to game makers in 2027 Satya Nadella explains why he/Microsoft are "long" on gaming Gaming is a core identity for Microsoft alongside platforms, developers, and knowledge workers Tips and picks Tip of the week: Nostalgia with a purpose App pick of the week: Stardock Clairvoyance RunAs Radio this week: SQL Server in 2026 with Bob Ward Brown liquor pick of the week: Canadian Centennial Rye Whisky 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 audio and video feeds, a members-only Discord, and exclusive content. Join today: https://twit.tv/clubtwit Sponsors: helixsleep.com/windows cachefly.com/twit

From bug-busting AI that's transforming Firefox to personal coding breakthroughs, the team breaks down how practical applications are cutting through skepticism and reshaping developer workflows. Plus, hear why lighter Patch Tuesdays are refreshing from time to time! Windows 11 Patch Tuesday's familiar list of updates: Network speed test, Camera tilt and pan controls, sysmon, RSAT improvements, Quick Machine Recovery improvements, WEBP support for desktop wallpaper, Emoji 16.0, etc. It's been a light year so far for Patch Tuesday features - that's a good thing New builds for Canary, Dev, and Beta late last week. Canary is nothing, Dev/Beta get Administrator Protection, Drag Tray refinements, File Explorer improvements, and fixes Android 16 QPR3 brings Desktop Mode to Android devices - and a hands-on with Pixel phones and tablets shows the way forward for Android-based laptops later this year Intel has new gaming processors for creators and gamers and they look excellent and are inexpensive AI and dev Copilot Cowork is literally Claude Cowork in Microsoft 365 - "Wave 3" for Microsoft 365 Copilot begins with a lot of agentic features, in private preview at first Google Docs, Sheets, Slides, and Drive get big Gemini updates for consumers and Workspace customers Mozilla partners with Anthropic to use AI to find bugs, and it's paying off nicely Visual Studio Code moves to a weekly update schedule The .NET 11 Preview 2 is here Xbox and gaming Microsoft starts talking up next Xbox console! It's called Project Helix and, yes, it will run Windows games New Xbox Mode is on the way Project Helix dev kits to game makers in 2027 Satya Nadella explains why he/Microsoft are "long" on gaming Gaming is a core identity for Microsoft alongside platforms, developers, and knowledge workers Tips and picks Tip of the week: Nostalgia with a purpose App pick of the week: Stardock Clairvoyance RunAs Radio this week: SQL Server in 2026 with Bob Ward Brown liquor pick of the week: Canadian Centennial Rye Whisky 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 audio and video feeds, a members-only Discord, and exclusive content. Join today: https://twit.tv/clubtwit Sponsors: helixsleep.com/windows cachefly.com/twit

From bug-busting AI that's transforming Firefox to personal coding breakthroughs, the team breaks down how practical applications are cutting through skepticism and reshaping developer workflows. Plus, hear why lighter Patch Tuesdays are refreshing from time to time! Windows 11 Patch Tuesday's familiar list of updates: Network speed test, Camera tilt and pan controls, sysmon, RSAT improvements, Quick Machine Recovery improvements, WEBP support for desktop wallpaper, Emoji 16.0, etc. It's been a light year so far for Patch Tuesday features - that's a good thing New builds for Canary, Dev, and Beta late last week. Canary is nothing, Dev/Beta get Administrator Protection, Drag Tray refinements, File Explorer improvements, and fixes Android 16 QPR3 brings Desktop Mode to Android devices - and a hands-on with Pixel phones and tablets shows the way forward for Android-based laptops later this year Intel has new gaming processors for creators and gamers and they look excellent and are inexpensive AI and dev Copilot Cowork is literally Claude Cowork in Microsoft 365 - "Wave 3" for Microsoft 365 Copilot begins with a lot of agentic features, in private preview at first Google Docs, Sheets, Slides, and Drive get big Gemini updates for consumers and Workspace customers Mozilla partners with Anthropic to use AI to find bugs, and it's paying off nicely Visual Studio Code moves to a weekly update schedule The .NET 11 Preview 2 is here Xbox and gaming Microsoft starts talking up next Xbox console! It's called Project Helix and, yes, it will run Windows games New Xbox Mode is on the way Project Helix dev kits to game makers in 2027 Satya Nadella explains why he/Microsoft are "long" on gaming Gaming is a core identity for Microsoft alongside platforms, developers, and knowledge workers Tips and picks Tip of the week: Nostalgia with a purpose App pick of the week: Stardock Clairvoyance RunAs Radio this week: SQL Server in 2026 with Bob Ward Brown liquor pick of the week: Canadian Centennial Rye Whisky 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 audio and video feeds, a members-only Discord, and exclusive content. Join today: https://twit.tv/clubtwit Sponsors: helixsleep.com/windows cachefly.com/twit

SQL Server 2025 is released - what's in it, and what happens next? Richard chats with Bob Ward about the huge array of announcements coming out of Ignite around SQL Server 2025, including AI-related features, new reliability and performance options, engine improvements, and more! The tooling for SQL Server also continues to evolve, including making Copilot available through SSMS and as part of the SQL extension to Visual Studio Code. And there's more to come - have a listen!LinksSQL Server 2025SQL Server 2025 UnveiledSSMS with Erin StellatoSQL Server Management StudioJSON Data in SQL ServerManaged Identity for SQL ServerSQL Server in Microsoft FabricMirroring SQL Server in FabricNext-Generation SQL Managed InstanceMSSQL Extension for Visual Studio CodeRecorded January 5, 2026

From bug-busting AI that's transforming Firefox to personal coding breakthroughs, the team breaks down how practical applications are cutting through skepticism and reshaping developer workflows. Plus, hear why lighter Patch Tuesdays are refreshing from time to time! Windows 11 Patch Tuesday's familiar list of updates: Network speed test, Camera tilt and pan controls, sysmon, RSAT improvements, Quick Machine Recovery improvements, WEBP support for desktop wallpaper, Emoji 16.0, etc. It's been a light year so far for Patch Tuesday features - that's a good thing New builds for Canary, Dev, and Beta late last week. Canary is nothing, Dev/Beta get Administrator Protection, Drag Tray refinements, File Explorer improvements, and fixes Android 16 QPR3 brings Desktop Mode to Android devices - and a hands-on with Pixel phones and tablets shows the way forward for Android-based laptops later this year Intel has new gaming processors for creators and gamers and they look excellent and are inexpensive AI and dev Copilot Cowork is literally Claude Cowork in Microsoft 365 - "Wave 3" for Microsoft 365 Copilot begins with a lot of agentic features, in private preview at first Google Docs, Sheets, Slides, and Drive get big Gemini updates for consumers and Workspace customers Mozilla partners with Anthropic to use AI to find bugs, and it's paying off nicely Visual Studio Code moves to a weekly update schedule The .NET 11 Preview 2 is here Xbox and gaming Microsoft starts talking up next Xbox console! It's called Project Helix and, yes, it will run Windows games New Xbox Mode is on the way Project Helix dev kits to game makers in 2027 Satya Nadella explains why he/Microsoft are "long" on gaming Gaming is a core identity for Microsoft alongside platforms, developers, and knowledge workers Tips and picks Tip of the week: Nostalgia with a purpose App pick of the week: Stardock Clairvoyance RunAs Radio this week: SQL Server in 2026 with Bob Ward Brown liquor pick of the week: Canadian Centennial Rye Whisky 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 audio and video feeds, a members-only Discord, and exclusive content. Join today: https://twit.tv/clubtwit Sponsors: helixsleep.com/windows cachefly.com/twit

Would you like to take your search in SQL Server to the next level? In this episode, check out how to use vector search, securely built into SQL Server 2025. #sqlserver2025 #sqlai Chapters 00:00 - Introduction 01:10 - Evolution of SQL 02:44 - Intelligent searching with SQL and AI 06:16 - Model definition 08:55 - Generate embeddings 13:19 - Vector index 15:25 - Vector Search 17:50 - Azure OpenAI 19:36 - Wrap up Recommended resources Announcement Sign-up Learn Docs Product page Connect Scott Hanselman | Twitter/X: @SHanselman Bob Ward | Twitter/X: @bobwardms Azure Friday | Twitter/X: @AzureFriday Azure | Twitter/X: @Azure

Would you like to take your search in SQL Server to the next level? In this episode, check out how to use vector search, securely built into SQL Server 2025. #sqlserver2025 #sqlai Chapters 00:00 - Introduction 01:10 - Evolution of SQL 02:44 - Intelligent searching with SQL and AI 06:16 - Model definition 08:55 - Generate embeddings 13:19 - Vector index 15:25 - Vector Search 17:50 - Azure OpenAI 19:36 - Wrap up Recommended resources Announcement Sign-up Learn Docs Product page Connect Scott Hanselman | Twitter/X: @SHanselman Bob Ward | Twitter/X: @bobwardms Azure Friday | Twitter/X: @AzureFriday Azure | Twitter/X: @Azure

In dieser Folge von Proiectum dreht sich alles um die Project Server Subscription Edition und die technische Grundlage, die Du für den Einsatz benötigst. Wir sprechen darüber, wie der SQL Server als zentrale Datenbank funktioniert, welche Rolle SharePoint Server für die Zusammenarbeit und das Dokumentenmanagement spielt und wie sich Project Server SE in diese Umgebung integriert. Du erfährst, welche Versionen erforderlich sind, wie die Komponenten zusammenspielen und worauf Du bei der Installation und Konfiguration achten solltest. Diese Episode gibt Dir einen klaren Überblick, damit Du die Infrastruktur für Project Server SE sicher und effizient aufbauen kannst.

Send a textThis episode sets the stage for Microsoft FABCON 2026 by spotlighting the people, perspectives, and practical guidance attendees can expect at Booth 545. Host Matt Volke is joined by Philip Rainsberger and Mark Shoesmith of Hitachi Solutions to discuss how organizations are approaching Microsoft Fabric today—what's driving adoption, where teams get stuck, and how to move from exploration to execution with confidence.Highlights:FABCON is where Microsoft Fabric conversations become practical—shifting from “what's possible” to “how do we implement and scale this responsibly?”Successful Fabric initiatives start with the business problem, not the technology, ensuring data and AI investments are tied to real outcomes.Hitachi Solutions' “thin slice” approach delivers production-ready wins early, avoiding proof-of-concept efforts that never make it to value.Common Fabric adoption paths include migrations from on‑prem SQL Server, SSIS, and Synapse Analytics into a unified Fabric architecture.Fabric is increasingly the analytics and AI foundation for Dynamics 365 customers, supporting both Finance & Operations and Customer Engagement workloads.FABCON attendees are encouraged to come prepared with their current data landscape, top Fabric goals, and key blockers to make booth conversations immediately actionable.global.hitachi-solutions.com

This is part of a few memories from the founders of SQL Server Central, celebrating 25 years of operation this month. We did photoshoots at Redgate many years ago. We had a bunch of props, including some phrases written down. We could create our own, but my handwriting is atrocious (likely why I never became an architect), but I ended up with this one: Read the rest of Doing Good at SQL Server Central

Welcome to Episode 421 of the Microsoft Cloud IT Pro Podcast. In this episode Ben sits down for a conversation with Frank Lesniak, the lead of the Microsoft 365 team at West Monroe. In this episode, they dive into the intricacies of mergers and divestitures within Microsoft 365 environments. They discuss the initial due diligence phase, planning and approach, building and configuring new environments, and the final migration and cutover phase. Frank shares insights on common challenges such as integration of different licensing models, the handling of workstations and applications, and the importance of security assessments. The episode provides a detailed look at the methodology and tools used by Frank’s team to streamline these complex processes. Your support makes this show possible! Please consider becoming a premium member for access to live shows and more. Check out our membership options. Show Notes Frank Lesniak on LinkedIn West Monroe Frank Lesniak Github Microsoft 365 tenant-to-tenant migrations Microsoft 365 inter-tenant collaboration Tenant life cycle considerations in multitenant solutions Frank Lesniak Frank Lesniak is a Sr. Cybersecurity & Enterprise Technology Architect at West Monroe with nearly 20 years of experience leading consulting engagements involving Microsoft infrastructure technology. His expertise spans modern cloud systems like Azure, Microsoft 365, and Entra ID to classic platforms like Windows Server, Active Directory, and SQL Server. His recent focus has been on Microsoft platform cybersecurity and automating technical processes using PowerShell. In his role, Frank establishes technical project methodologies, leads teams, automates associated processes, and creates internal software products at West Monroe and in the open-source community. About the sponsors Would you like to become the irreplaceable Microsoft 365 resource for your organization? Let us know!

SQL Server 2016 and 2017 are leaving Extended support in the not-too-distant future. Directions' analyst Andrew Snodgrass shares his preparation checklist in this episode with Mary Jo Foley.

SDU Show 94 features fellow Data Platform MVP Ben Weissman discussing vectors, REST-based calls, and AI in SQL Server 2025

AWS Morning Brief for the week of February 9th, with Corey Quinn. Links:Change the server-side encryption type of Amazon S3 objectsAnnouncing memory-optimized instance bundles for Amazon LightsailAmazon RDS now provides an enhanced console experience to connect to a databaseAWS Multi-party approval now requires one-time password verification for votingAWS Management Console now displays Account Name on the Navigation barStructured outputs now available in Amazon BedrockAmazon EC2 C8id, M8id, and R8id instances with up to 22.8 TB local NVMe storage are generally available AWS IAM Identity Center now supports multi-Region replication for AWS account access and application useTrigger AWS Lambda functions from Amazon RDS for SQL Server database eventsAmazon CloudFront now supports mTLS authentication to originsBevar Ukraine: Empowering Ukrainian refugees with AI-powered support on AWSSecurity Findings in SageMaker Python SDK

I remember getting a job at a startup in the Denver Tech Center. This was shortly after SQL Server 7 was released, with a marketing campaign that the platform was auto-tuning and wouldn't require a DBA. My colleague asked me if I wanted to learn Cold Fusion and have a longer career. I declined and stuck with this SQL Server thing, which has seemed to work out pretty well over the years. I was reminded of this when I saw a "Death of the DBA Again" post, this time from an Oracle DBA. There are plenty of links in there from Larry Ellison and Oracle about how some version of Oracle won't require a DBA. I've seen questions on Reddit (and elsewhere ) about this topic where people seem to think DBAs can be replaced. Or maybe they want them replaced. Read the rest of The DBA is Dead; Long Live the DBA

  Read the rest of When SQL Server Central Went Down

In this episode of Manufacturing Hub, Vlad Romanov and Dave Griffith sit down with David for a practical, operator grounded conversation about industrial data, modernization, and what it actually takes to turn plant floor signals into business decisions. David has spent more than two decades in manufacturing across automotive, solar, and electric vehicles, and his story is a familiar one for a lot of us. He walked into a plant thinking he was there for a project, discovered PLCs in real time, and never left the factory world. From early days wiring up a SQL Server to pull line data instead of sending people out with stopwatches, to leading data and analytics and shaping MES and reporting strategy, this conversation stays focused on the messy middle where most factories live.A big theme here is that collecting data is not the same thing as creating information. As tooling has improved, connectivity, historians, SCADA, cloud storage, MQTT, and the modern ecosystem have made it easier to get signals out of machines. The hard part is deciding what matters, aligning stakeholders, and creating context that survives across teams and projects. David breaks down how real progress often starts with simple visibility, what is ruining your day, what is the biggest safety risk, what is the recurring quality miss, what is the downtime story you do not trust, then builds from there using workshops and iterative delivery instead of giant multi year “boil the ocean” programs.We also get into Unified Namespace, why it resonates with people who have been burned by tightly coupled ISA style integrations, and why change management is the hidden cost. If you are exploring UNS, this episode highlights the difference between drawing the box on a whiteboard and getting a whole organization to actually adopt consistent naming, context, and ownership. Then we finish with a grounded take on industrial AI. No hype, no doom. Just a realistic view of where AI helps today, where it breaks, and why context windows, documentation quality, and domain expertise still decide whether results are useful or dangerous.Timestamps00:00:00 Welcome and the month theme on technology modernization00:02:10 David's background from automotive and the Tesla Fremont NUMMI era to data leadership00:05:10 The moment data became “real” and why proactive visibility drives safety and outcomes00:07:10 How Kaizen and Toyota Production System style problem solving creates demand for data00:11:50 Why modern tooling makes collection easier and why budget and commitment still decide success00:16:10 Starting points that work in the real world and the simplest visibility model that scales00:18:20 Unified Namespace explained through decoupling, context, and why the first attempt often fails00:23:50 Who really uses the data, operators, quality, engineering, and the “next factory” teams00:29:10 Defining KPIs when nobody has answers and using workshops to force prioritization00:34:20 What rollouts actually take, machine states, data structures, controls changes, and iteration00:40:10 Industrial AI reality check, where it helps today and why it is not running your factory00:51:10 Predicting the next few years, consolidation, pricing, and better integration with agentsAbout the hostsVlad Romanov is an industrial automation and manufacturing leader with over a decade of plant floor experience across major manufacturers. He is the founder of Joltek, where he helps teams modernize operations through IT and OT architecture, integration, reliability focused execution, and practical upskilling that actually sticks. Joltek works with manufacturers who need real outcomes, not buzzwords, and the work spans controls, data, networking, and operational performance.Dave Griffith is the co host of Manufacturing Hub and works at the intersection of manufacturing operations, technology modernization, and practical delivery. He focuses on helping teams bridge the gap between “we want data” and “we can run this plant better next quarter.”About the guestDavid has 25 plus years of manufacturing experience spanning automotive, solar manufacturing, and EVs. He started in plant floor automation and conveyance projects, then moved deeper into industrial data, MES, and analytics leadership. His recent work includes leading data and analytics, defining KPI strategy, and building the layers required to turn raw plant signals into usable business information.Links from Joltekhttps://www.joltek.com/blog/mastering-unified-namespace-uns-a-guide-to-data-driven-manufacturing-transformationhttps://www.joltek.com/blog/ultimate-guide-mqtt-manufacturingSubscribe for more conversations on manufacturing modernization, industrial data architecture, MES realities, and what works on the plant floor when the budget, people, and legacy systems are all real.

There have been a lot of features added to the SQL Server platform over the years. Several of these features let us perform functions that are beyond what a database has traditionally been designed to handle. SQL Server has had the ability to send emails,  execute Python/R/etc. code, and in SQL Server 2025, we can call REST endpoints. Quite a few of these features (arguably) are more application-oriented than database-oriented. There's nothing inherently wrong with having a server perform some of these functions, and there have been some very creative implementations using these features. I recently ran into one of these examples from Amy Abel, where she shows how to use the new REST endpoint feature to call an AI LLM to generate and send emails from your database server. That's creative, and it's reminiscent of the numerous examples from various experts over the years who demonstrate how these features can be used to accomplish a task. Read the rest of Expensive CPUs

The oldest article we have on the site is Tame Those Strings! Part 4 - Numeric Conversions, by me. It's dated 2001-04-18, though I think that's a date we picked when we converted all the content from one database to another. The founders agreed sometime during Feb 2001 to jointly run SQL Server Central. Since we each owned the copyright of our articles from another site, we migrated several articles to build up our content library. This was back when Andy, Brian, and I all had full-time jobs and managed the site during breaks, nights, and weekends. That was 25 years ago. Twenty. Five. Years. Read the rest of 25 Years of SQL Server Central

In the premiere episode of Season 11, we welcome a panel of Moser's experts featuring Tony Wilhelm, Brett Canova, Melissa Steffenson, and Ari Moreland to explore the transition from SSRS to Power BI for SQL Server reporting and what it means for modern data analytics. We discuss the migration process, the benefits of Power BI, and how organizations can leverage advanced reporting to drive smarter decisions, as well as best practices, common challenges, and opportunities for businesses to unlock the full potential of their data.

I came across a post recently on the Microsoft Fabric blog about the evolution of SSIS 2025..I hadn't heard much about SSIS in SQL Server 2025, so I thought this might provide some info on the investments that Microsoft is still making in Integration Services. I've run into a few people in the past year who are still heavily invested in SSIS and run packages daily. SSIS seems to be a technology that isn't even close to dying for many organizations. The blog starts well, delving into the security investments with the change to the SqlClient and TLS 1.3, as well as supporting Strict Encryption. I don't know many people using this level of security, but it's good to have SSIS support stronger security. There is also an upgrade for SSIS packages targeting Fabric Data Warehouses if they modify their approach. Read the rest of An SSIS Upgrade

In this year's first episode of the new year, Guy and Eitan discuss the new Next-gen General Purpose tier of Azure SQL Managed Instance, which is now GA. They also discuss a few interesting customer stories, how they were resolved, and how they're not actually SQL Server's fault. Relevant links: Generally Available: Azure SQL Managed Instance Next-gen General Purpose | Microsoft Community Hub The Bitmap Index query plan operator SQL Server on VMware best practices guide How to Save Money on Your SQL Server Hardware

אז מה אומרים? פוסטגרס קצת יותר, ואסקיואל קצת פחות? גיא ואיתן פותחים את הנושא ומדברים על זה. מתי כן? מתי לא? מתי כדאי? וגם מדברים על כמה חידושים מעניינים ב-SQL Server, ועוד. קישורים רלוונטיים: Working with Amazon Aurora PostgreSQL - Amazon Aurora Announcing Azure HorizonDB | Microsoft Community Hub microsoft-dbas-club/Diagnostics/Sleeping Sessions with Old Open Transactions.sql Regular Expressions Functions (Transact-SQL) - SQL Server | Microsoft Learn Format Query Results as JSON with FOR JSON - SQL Server | Microsoft Learn Inside SQL Server Inconsistencies – Part 1: Fundamentals (Hebrew Edition) Inside SQL Server Inconsistencies – Part 2. Create and solve inconsistency in a DB (Hebrew edition) SQL Server Inconsistencies – Part 3. Fixing inconsistency on a clustered index (Hebrew edition)

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: Welcome to the Oracle University Podcast! I'm Lois Houston, Director of Communications and Adoption with Customer Success Services, and with me is Nikita Abraham, Team Lead: Editorial Services with Oracle University.   Nikita: Hi everyone! You're listening to our Best of 2025 series, where over the next few weeks, we're revisiting four of our most popular episodes of the year.      Lois: Today is #2 of 4, and we're throwing it back to an episode with Senior Manager of CSS OU Cloud Delivery Samvit Mishra. This episode was all about shining a light on multicloud, a game-changing strategy involving the use of multiple cloud service providers.     01:07 Nikita: That's right, Lois. Oracle has been an early adopter of multicloud and a pioneer in multicloud services. So, we began that conversation by asking Samvit to explain what multicloud is and why someone would need more than one cloud provider.  Samvit: Multicloud is a very simple, basic concept. It is the coordinated use of cloud services from more than one cloud service provider.  01:30 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:53 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:22 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:13 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:20 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:11 AI is being used in nearly every industry…healthcare, manufacturing, retail, customer service, transportation, agriculture, you name it! And it's only going to get more prevalent and transformational in the future. It's no wonder that AI skills are the most sought-after by employers. If you're ready to dive in to AI, check out the OCI AI Foundations training and certification that's available for free! It's the perfect starting point to build your AI knowledge. So, get going! Head on over to mylearn.oracle.com to find out more.  05:51 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:29 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 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:25 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:43 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:49 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.  10:06 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:55 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.  Lois: We hope you enjoyed that conversation. Join us next week for another throwback episode. Until then, this is Lois Houston...   Nikita: And Nikita Abraham, signing off!   11:26 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.

מתן יונגמן בא להתארח בפרק מיוחד זה כדי לספר על מערכת "ראפידו" שהוא בנה, המבצעת שיפור ביצועים אוטומטי בבסיסי הנתונים, ואולי לתת לנו קצת השראה מעניינת. קישורים רלוונטים: Matan Yungman | LinkedIn Matan Yungman (@MatanYungman) / X SQL Server 2025 is Now Generally Available | Microsoft Community Hub What's New in SQL Server 2025 - SQL Server | Microsoft Learn Intelligent Query Processing - SQL Server | Microsoft Learn

Over the years I've had no shortage of licensing questions for SQL Server. At times it's felt a little crazy. Look at the licensing guide. Choose EE or SE and the number of cores. Then check if you're using VMs. Oh, and consider the cloud, and which cloud you're running a workload on. It's simple right? It can seem confusing, and at times I've wished Microsoft would make it simpler. And perhaps even give us some add-ons, like adding some additional hardware capabilities (cough more RAM *cough) in SE. Read the rest of SQL Server Licensing is Simple

Audio version of video on YouTube. Microsoft Entra ID authentication for bots is now available in group scope Microsoft Ignite Book of News Introducing Microsoft Agent Factory Azure at Microsoft Ignite 2025: All the intelligent cloud news explained SQL Server 2025 now GA Subscribe to all my videos at: https://thoughtstuff.co.uk/video Podcast: https://thoughtstuff.co.uk/itunes, https://thoughtstuff.co.uk/spotify or https://thoughtstuff.co.uk/podcast Blog: https://blog.thoughtstuff.co.uk

SQL Server 2025 was released this week. The announcement came at Ignite and the PASS Data Community Summit with keynotes on Wednesday and Thursday, respectively. While there are some things to look forward to in the release (What's New) and some highlights from T-SQL Tuesday this week, it seems that this release wasn't a very exciting one. On one hand, I blame all the Microsoft Fabric focus, which seems to distract from the core product that powers the databases at many organizations.  The SQL Server blog from Microsoft has had relatively few posts this year, highlighting a few things. The Fabric blog gets more posts, which is something I've seen at Database Weekly as well. As I curate the content during my week, I find a lot more Fabric-focused content than SQL Server-specific posts. That contributes to a lack of excitement for a new version of SQL Server. Read the reset of An Unexciting Exciting Release

SDU Show 93 features data expert Simon Sabin discussing data-related development, AI tools, and the upcoming SQLBits conference

In this Technology Reseller News, Podcast, Doug Green interviews Don Boxley, CEO and Co-Founder of DH2i, for a deep dive into one of the biggest challenges facing IT teams today: the migration gap between legacy Windows-based SQL Server deployments and the containerized, Linux-driven future that modern applications increasingly require. DH2i, a long-time Microsoft and Red Hat partner, delivers high availability, secure communication, and cross-platform mobility for SQL Server, Oracle, and MySQL environments. Their flagship platform, DX Enterprise, enables customers to run the same production-grade SQL instance across Windows, Linux, and Kubernetes — and move between them with seamless failover. As Boxley explains, this eliminates the traditional roadblocks that keep enterprises locked into aging infrastructure. With SQL Server 2025 bringing new support for AI-driven applications, Microsoft tapped DH2i to deliver mission-critical HA capabilities for these next-generation workloads. The company also introduced a hands-on, step-by-step Minikube tutorial, allowing DBAs and MSPs to experiment safely with Kubernetes-based SQL deployments on their own PCs before ever touching production. “Most teams think they're stuck on Windows — they're not. With DX Enterprise, you can move SQL Server to Linux or containers without disruption, and your customers won't even know the difference,” Boxley notes. DH2i's developer edition is available as a free download, complete with 30-day support, giving IT teams a no-risk path to testing, learning, and modernizing their database infrastructure. Learn more at https://dh2i.com/. Software Mind Telco Days 2025: On-demand online conference Engaging Customers, Harnessing Data

The AWS Optimization and Licensing Assessment (OLA) program is a free optimization and licensing assessment that helps companies reduce Windows, SQL Server, and storage costs by 20-80%. In this episode, we break down how AWS OLA works, what companies are getting wrong with their licensing, and how to implement findings without disrupting operations. From discovering double-licensed SQL clusters to moving 700 terabytes of logs to the right storage tier, this assessment delivers actionable savings in just 2-3 weeks.

I ran across a thought-provoking post from Chrissy LeMaire asking if we should reconsider SQL Server HA. The post actually asks if you've considered not using it. The default from Chrissy, for most installations, is to use standalone SQL Servers. This isn't to say she's against HA solutions (FCIs or AGs), but that they often cause problems and might not be needed. It's an interesting position to consider. For a long time, I avoided SQL Server clusters as they were hard to setup with a lot of complexity, hardware requirements, etc., and didn't really provide enough benefits over using log shipping with a second server for me.  These days I have clients with mostly AGs, and they seem to run fine. That being said, Chrissy notes that after she left a job, a network outages caused a bunch of downtime. I could see there being downtime, as the old database mirroring (and the it-will-never-die replication) needed a working network. If you have network issues, you better know how to manage your HA technology's issues. Read the rest of Do You Really Need HA?

I wrote recently about some work with Redgate Clone, and one of the things I did was start up a blank container instance of SQL Server from the image named empty-sql-current. This image contains SQL Server 2019. Clearly, "current" was a poor choice. I see this often in various places, where someone will reference "current", "new", "latest", or some other term that denotes the most recent changes. If everyone reading the reference is doing so with knowledge of the past and at a time close to publication, this works fine. However, a year later, does this make sense? At the same time, I do like consistent names that might be used in scripts. If I always want developers pulling the latest item, I might use latest. However, if versions are important, than "latest" or "current" might not be the best choice. Much of the time, I tend to try and get a version or some other specific indicator in a name. Read the rest of Poor Name Choice

Dans cet épisode, Arnaud et Guillaume discutent des dernières évolutions dans le monde de la programmation, notamment les nouveautés de Java 25, JUnit 6, et Jackson 3. Ils abordent également les récents développements en IA, les problèmes rencontrés dans le cloud, et l'état actuel de React et du web. Dans cette conversation, les intervenants abordent divers sujets liés à la technologie, notamment les spécifications de Wasteme, l'utilisation des UUID dans les bases de données, l'approche RAG en intelligence artificielle, les outils MCP, et la création d'images avec Nano Banana. Ils discutent également des complexités du format YAML, des récents dramas dans la communauté Ruby, de l'importance d'une bonne documentation, des politiques de retour au bureau, et des avancées de Cloud Code. Enfin, ils évoquent l'initiative de cafés IA pour démystifier l'intelligence artificielle. Enregistré le 24 octobre 2025 Téléchargement de l'épisode LesCastCodeurs-Episode-331.mp3 ou en vidéo sur YouTube. News Langages GraalVM se détache du release train de Java https://blogs.oracle.com/java/post/detaching-graalvm-from-the-java-ecosystem-train Un article de Loic Mathieu sur Java 25 et ses nouvelles fonctionalités https://www.loicmathieu.fr/wordpress/informatique/java-25-whats-new/ Sortie de Groovy 5.0 ! https://groovy-lang.org/releasenotes/groovy-5.0.html Groovy 5: Évolution des versions précédentes, nouvelles fonctionnalités et simplification du code. Compatibilité JDK étendue: Full support JDK 11-25, fonctionnalités JDK 17-25 disponibles sur les JDK plus anciens. Extension majeure des méthodes: Plus de 350 méthodes améliorées, opérations sur tableaux jusqu'à 10x plus rapides, itérateurs paresseux. Améliorations des transformations AST: Nouveau @OperatorRename, génération automatique de @NamedParam pour @MapConstructor et copyWith. REPL (groovysh) modernisé: Basé sur JLine 3, support multi-plateforme, coloration syntaxique, historique et complétion. Meilleure interopérabilité Java: Pattern Matching pour instanceof, support JEP-512 (fichiers source compacts et méthodes main d'instance). Standards web modernes: Support Jakarta EE (par défaut) et Javax EE (héritage) pour la création de contenu web. Vérification de type améliorée: Contrôle des chaînes de format plus robuste que Java. Additions au langage: Génération d'itérateurs infinis, variables d'index dans les boucles, opérateur d'implication logique ==>. Améliorations diverses: Import automatique de java.time.**, var avec multi-assignation, groupes de capture nommés pour regex (=~), méthodes utilitaires de graphiques à barres ASCII. Changements impactants: Plusieurs modifications peuvent nécessiter une adaptation du code existant (visibilité, gestion des imports, comportement de certaines méthodes). **Exigences JDK*: Construction avec JDK17+, exécution avec JDK11+. Librairies Intégration de LangChain4j dans ADK pour Java, permettant aux développeurs d'utiliser n'importe quel LLM avec leurs agents ADK https://developers.googleblog.com/en/adk-for-java-opening-up-to-third-party-language-models-via-langchain4j-integration/ ADK pour Java 0.2.0 : Nouvelle version du kit de développement d'agents de Google. Intégration LangChain4j : Ouvre ADK à des modèles de langage tiers. Plus de choix de LLM : En plus de Gemini et Claude, accès aux modèles d'OpenAI, Anthropic, Mistral, etc. Modèles locaux supportés : Utilisation possible de modèles via Ollama ou Docker Model Runner. Améliorations des outils : Création d'outils à partir d'instances d'objets, meilleur support asynchrone et contrôle des boucles d'exécution. Logique et mémoire avancées : Ajout de callbacks en chaîne et de nouvelles options pour la gestion de la mémoire et le RAG (Retrieval-Augmented Generation). Build simplifié : Introduction d'un POM parent et du Maven Wrapper pour un processus de construction cohérent. JUnit 6 est sorti https://docs.junit.org/6.0.0/release-notes/ :sparkles: Java 17 and Kotlin 2.2 baseline :sunrise_over_mountains: JSpecify nullability annotations :airplane_departure: Integrated JFR support :suspension_railway: Kotlin suspend function support :octagonal_sign: Support for cancelling test execution :broom: Removal of deprecated APIs JGraphlet, une librairie Java sans dépendances pour créer des graphes de tâches à exécuter https://shaaf.dev/post/2025-08-25-think-in-graphs-not-just-chains-jgraphlet-for-taskpipelines/ JGraphlet: Bibliothèque Java légère (zéro-dépendance) pour construire des pipelines de tâches. Principes clés: Simplicité, basée sur un modèle d'exécution de graphe. Tâches: Chaque tâche a une entrée/sortie, peut être asynchrone (Task) ou synchrone (SyncTask). Pipeline: Un TaskPipeline construit et exécute le graphe, gère les I/O. Modèle Graph-First: Le flux de travail est un Graphe Orienté Acyclique (DAG). Définition des tâches comme des nœuds, des connexions comme des arêtes. Support naturel des motifs fan-out et fan-in. API simple: addTask("id", task), connect("fromId", "toId"). Fan-in: Une tâche recevant plusieurs entrées reçoit une Map (clés = IDs des tâches parentes). Exécution: pipeline.run(input) retourne un CompletableFuture (peut être bloquant via .join() ou asynchrone). Cycle de vie: TaskPipeline est AutoCloseable, garantissant la libération des ressources (try-with-resources). Contexte: PipelineContext pour partager des données/métadonnées thread-safe entre les tâches au sein d'une exécution. Mise en cache: Option de mise en cache pour les tâches afin d'éviter les re-calculs. Au tour de Microsoft de lancer son (Microsoft) Agent Framework, qui semble être une fusion / réécriture de AutoGen et de Semnatic Kernel https://x.com/pyautogen/status/1974148055701028930 Plus de détails dans le blog post : https://devblogs.microsoft.com/foundry/introducing-microsoft-agent-framework-the-open-source-engine-for-agentic-ai-apps/ SDK & runtime open-source pour systèmes multi-agents sophistiqués. Unifie Semantic Kernel et AutoGen. Piliers : Standards ouverts (MCP, A2A, OpenAPI) et interopérabilité. Passerelle recherche-production (patterns AutoGen pour l'entreprise). Extensible, modulaire, open-source, connecteurs intégrés. Prêt pour la production (observabilité, sécurité, durabilité, "human in the loop"). Relation SK/AutoGen : S'appuie sur eux, ne les remplace pas, simplifie la migration. Intégrations futures : Alignement avec Microsoft 365 Agents SDK et Azure AI Foundry Agent Service. Sortie de Jackson 3.0 (bientôt les Jackson Five !!!) https://cowtowncoder.medium.com/jackson-3-0-0-ga-released-1f669cda529a Jackson 3.0.0 a été publié le 3 octobre 2025. Objectif : base propre pour le développement à long terme, suppression de la dette technique, architecture simplifiée, amélioration de l'ergonomie. Principaux changements : Baseline Java 17 requise (vs Java 8 pour 2.x). Group ID Maven et package Java renommés en tools.jackson pour la coexistence avec Jackson 2.x. (Exception: jackson-annotations ne change pas). Suppression de toutes les fonctionnalités @Deprecated de Jackson 2.x et renommage de plusieurs entités/méthodes clés. Modification des paramètres de configuration par défaut (ex: FAIL_ON_UNKNOWN_PROPERTIES désactivé). ObjectMapper et TokenStreamFactory sont désormais immutables, la configuration se fait via des builders. Passage à des exceptions de base non vérifiées (JacksonException) pour plus de commodité. Intégration des "modules Java 8" (pour les noms de paramètres, Optional, java.time) directement dans l'ObjectMapper par défaut. Amélioration du modèle d'arbre JsonNode (plus de configurabilité, meilleure gestion des erreurs). Testcontainers Java 2.0 est sorti https://github.com/testcontainers/testcontainers-java/releases/tag/2.0.0 Removed JUnit 4 support -> ups Grails 7.0 est sortie, avec son arrivée à la fondation Apache https://grails.apache.org/blog/2025-10-18-introducing-grails-7.html Sortie d'Apache Grails 7.0.0 annoncée le 18 octobre 2025. Grails est devenu un projet de premier niveau (TLP) de l'Apache Software Foundation (ASF), graduant d'incubation. Mise à jour des dépendances vers Groovy 4.0.28, Spring Boot 3.5.6, Jakarta EE. Tout pour bien démarrer et développer des agents IA avec ADK pour Java https://glaforge.dev/talks/2025/10/22/building-ai-agents-with-adk-for-java/ Guillaume a partagé plein de resources sur le développement d'agents IA avec ADK pour Java Un article avec tous les pointeurs Un slide deck et l'enregistrement vidéo de la présentation faite lors de Devoxx Belgique Un codelab avec des instructions pour démarrer et créer ses premiers agents Plein d'autres samples pour s'inspirer et voir les possibilités offertes par le framework Et aussi un template de projet sur GitHub, avec un build Maven et un premier agent d'exemple Cloud Internet cassé, du moins la partie hébergée par AWS #hugops https://www.theregister.com/2025/10/20/aws_outage_amazon_brain_drain_corey_quinn/ Panne majeure d'AWS (région US-EAST-1) : problème DNS affectant DynamoDB, service fondamental, causant des défaillances en cascade de nombreux services internet. Réponse lente : 75 minutes pour identifier la cause profonde; la page de statut affichait initialement "tout va bien". Cause sous-jacente principale : "fuite des cerveaux" (départ d'ingénieurs AWS seniors). Perte de connaissances institutionnelles : des décennies d'expertise critique sur les systèmes AWS et les modes de défaillance historiques parties avec ces départs. Prédictions confirmées : un ancien d'AWS avait anticipé une augmentation des pannes majeures en 2024. Preuves de la perte de talents : Plus de 27 000 licenciements chez Amazon (2022-2025). Taux élevé de "départs regrettés" (69-81%). Mécontentement lié à la politique de "Return to Office" et au manque de reconnaissance de l'expertise. Conséquences : les nouvelles équipes, plus réduites, manquent de l'expérience nécessaire pour prévenir les pannes ou réduire les temps de récupération. Perspective : Le marché pourrait pardonner cette fois, mais le problème persistera, rendant les futurs incidents plus probables. Web React a gagné "par défaut" https://www.lorenstew.art/blog/react-won-by-default/ React domine par défaut, non par mérite technique, étouffant ainsi l'innovation front-end. Choix par réflexe ("tout le monde connaît React"), freinant l'évaluation d'alternatives potentiellement supérieures. Fondations techniques de React (V-DOM, complexité des Hooks, Server Components) vues comme des contraintes actuelles. Des frameworks innovants (Svelte pour la compilation, Solid pour la réactivité fine, Qwik pour la "resumability") offrent des modèles plus performants mais sont sous-adoptés. La monoculture de React génère une dette technique (runtime, réconciliation) et centre les compétences sur le framework plutôt que sur les fondamentaux web. L'API React est complexe, augmentant la charge cognitive et les risques de bugs, contrairement aux alternatives plus simples. L'effet de réseau crée une "prison": offres d'emploi spécifiques, inertie institutionnelle, leaders choisissant l'option "sûre". Nécessité de choisir les frameworks selon les contraintes du projet et le mérite technique, non par inertie. Les arguments courants (maturité de l'écosystème, recrutement, bibliothèques, stabilité) sont remis en question; une dépendance excessive peut devenir un fardeau. La monoculture ralentit l'évolution du web et détourne les talents, nuisant à la diversité essentielle pour un écosystème sain et innovant. Promouvoir la diversité des frameworks pour un écosystème plus résilient et innovant. WebAssembly 3 est sortie https://webassembly.org/news/2025-09-17-wasm-3.0/ Data et Intelligence Artificielle UUIDv4 ou UUIDv7 pour vos clés primaires ? Ça dépend… surtout pour les bases de données super distribuées ! https://medium.com/google-cloud/understanding-uuidv7-and-its-impact-on-cloud-spanner-b8d1a776b9f7 UUIDv4 : identifiants entièrement aléatoires. Cause des problèmes de performance dans les bases de données relationnelles (ex: PostgreSQL, MySQL, SQL Server) utilisant des index B-Tree. Inserts aléatoires réduisent l'efficacité du cache, entraînent des divisions de pages et la fragmentation. UUIDv7 : nouveau standard conçu pour résoudre ces problèmes. Intègre un horodatage (48 bits) en préfixe de l'identifiant, le rendant ordonné temporellement et "k-sortable". Améliore la performance dans les bases B-Tree en favorisant les inserts séquentiels, la localité du cache et réduisant la fragmentation. Problème de UUIDv7 pour certaines bases de données distribuées et scalables horizontalement comme Spanner : La nature séquentielle d'UUIDv7 (via l'horodatage) crée des "hotspots d'écriture" (points chauds) dans Spanner. Spanner distribue les données en "splits" (partitions) basées sur les plages de clés. Les clés séquentielles concentrent les écritures sur un seul "split". Ceci empêche Spanner de distribuer la charge et de scaler les écritures, créant un goulot d'étranglement ("anti-pattern"). Quand ce n'est PAS un problème pour Spanner : Si le taux d'écriture total est inférieur à environ 3 500 écritures/seconde pour un seul "split". Le hotspot est "bénin" à cette échelle et n'entraîne pas de dégradation de performance. Solutions pour Spanner : Principe clé : S'assurer que la première partie de la clé primaire est NON séquentielle pour distribuer les écritures. UUIDv7 peut être utilisé, mais pas comme préfixe. Nouvelle conception ("greenfield") : ▪︎ Utiliser une clé primaire non-séquentielle (ex: UUIDv4 simple). Pour les requêtes basées sur le temps, créer un index secondaire sur la colonne d'horodatage, mais le SHARDER (ex: shardId) pour éviter les hotspots sur l'index lui-même. Migration (garder UUIDv7) : ▪︎ Ajouter un préfixe de sharding : Introduire une colonne `shard` calculée (ex: `MOD(ABS(FARM_FINGERPRINT(order_id_v7)), N)`) et l'utiliser comme PREMIER élément d'une clé primaire composite (`PRIMARY KEY (shard, order_id_v7)`). Réordonner les colonnes (si clé primaire composite existante) : Si la clé primaire est déjà composite (ex: (order_id_v7, tenant_id)), réordonner en (tenant_id, order_id_v7). Cela aide si tenant_id a une cardinalité élevée et distribue bien. (Un tenant_id très actif pourrait toujours nécessiter un préfixe de sharding supplémentaire). RAG en prod, comment améliorer la pertinence des résultats https://blog.abdellatif.io/production-rag-processing-5m-documents Démarrage rapide avec Langchain + Llamaindex: prototype fonctionnel, mais résultats de production jugés "subpar" par les utilisateurs. Ce qui a amélioré la performance (par ROI): Génération de requêtes: LLM crée des requêtes sémantiques et mots-clés multiples basées sur le fil de discussion pour une meilleure couverture. Reranking: La technique la plus efficace, modifie grandement le classement des fragments (chunks). Stratégie de découpage (Chunking): Nécessite beaucoup d'efforts, compréhension des données, création de fragments logiques sans coupures. Métadonnées à l'LLM: L'injection de métadonnées (titre, auteur) améliore le contexte et les réponses. Routage de requêtes: Détecte et traite les questions non-RAG (ex: résumer, qui a écrit) via API/LLM distinct. Outillage Créer un serveur MCP (mode HTTP Streamable) avec Micronaut et quelques éléments de comparaison avec Quarkus https://glaforge.dev/posts/2025/09/16/creating-a-streamable-http-mcp-server-with-micronaut/ Micronaut propose désormais un support officiel pour le protocole MCP. Exemple : un serveur MCP pour les phases lunaires (similaire à une version Quarkus pour la comparaison). Définition des outils MCP via les annotations @Tool et @ToolArg. Point fort : Micronaut gère automatiquement la validation des entrées (ex: @NotBlank, @Pattern), éliminant la gestion manuelle des erreurs. Génération automatique de schémas JSON détaillés pour les structures d'entrée/sortie grâce à @JsonSchema. Nécessite une configuration pour exposer les schémas JSON générés comme ressources statiques. Dépendances clés : micronaut-mcp-server-java-sdk et les modules json-schema. Testé avec l'inspecteur MCP et intégration avec l'outil Gemini CLI. Micronaut offre une gestion élégante des entrées/sorties structurées grâce à son support JSON Schema riche. Un agent IA créatif : comment utiliser le modèle Nano Banana pour générer et éditer des images (en Java, avec ADK) https://glaforge.dev/posts/2025/09/22/creative-ai-agents-with-adk-and-nano-banana/ Modèles de langage (LLM) deviennent multimodaux : traitent diverses entrées (texte, images, vidéo, audio). Nano Banana (gemini-2.5-flash-image-preview) : modèle Gemini, génère et édite des images, pas seulement du texte. ADK (Agent Development Kit pour Java) : pour configurer des agents IA créatifs utilisant ce type de modèle. Application : Base pour des workflows créatifs complexes (ex: agent de marketing, enchaînement d'agents pour génération d'assets). Un vieil article (6 mois) qui illustre les problèmes du format de fichier YAML https://ruudvanasseldonk.com/2023/01/11/the-yaml-document-from-hell YAML est extrêmement complexe malgré son objectif de convivialité humaine. Spécification volumineuse et versionnée (YAML 1.1, 1.2 diffèrent significativement). Comportements imprévisibles et "pièges" (footguns) courants : Nombres sexagésimaux (ex: 22:22 parsé comme 1342 en YAML 1.1). Tags (!.git) pouvant mener à des erreurs ou à l'exécution de code arbitraire. "Problème de la Norvège" : no interprété comme false en YAML 1.1. Clés non-chaînes de caractères (on peut devenir une clé booléenne True). Nombres accidentels si non-guillemets (ex: 10.23 comme flottant). La coloration syntaxique n'est pas fiable pour détecter ces subtilités. Le templating de documents YAML est une mauvaise idée, source d'erreurs et complexe à gérer. Alternatives suggérées : TOML : Similaire à YAML mais plus sûr (chaînes toujours entre guillemets), permet les commentaires. JSON avec commentaires (utilisé par VS Code), mais moins répandu. Utiliser un sous-ensemble simple de YAML (difficile à faire respecter). Générer du JSON à partir de langages de programmation plus puissants : ▪︎ Nix : Excellent pour l'abstraction et la réutilisation de configuration. Python : Facilite la création de JSON avec commentaires et logique. Gros binz dans la communauté Ruby, avec l'influence de grosses boîtes, et des pratiques un peu douteuses https://joel.drapper.me/p/rubygems-takeover/ Méthodologies Les qualités d'une bonne documentation https://leerob.com/docs Rapidité Chargement très rapide des pages (préférer statique). Optimisation des images, polices et scripts. Recherche ultra-rapide (chargement et affichage des résultats). Lisibilité Concise, éviter le jargon technique. Optimisée pour le survol (gras, italique, listes, titres, images). Expérience utilisateur simple au départ, complexité progressive. Multiples exemples de code (copier/coller). Utilité Documenter les solutions de contournement (workarounds). Faciliter le feedback des lecteurs. Vérification automatisée des liens morts. Matériel d'apprentissage avec un curriculum structuré. Guides de migration pour les changements majeurs. Compatible IA Trafic majoritairement via les crawlers IA. Préférer cURL aux "clics", les prompts aux tutoriels. Barre latérale "Demander à l'IA" référençant la documentation. Prêt pour les agents Faciliter le copier/coller de contenu en Markdown pour les chatbots. Possibilité de visualiser les pages en Markdown (ex: via l'URL). Fichier llms.txt comme répertoire de fichiers Markdown. Finition soignée Zones de clic généreuses (boutons, barres latérales). Barres latérales conservant leur position de défilement et état déplié. Bons états actifs/survol. Images OG dynamiques. Titres/sections lienables avec ancres stables. Références et liens croisés entre guides, API, exemples. Balises méta/canoniques pour un affichage propre dans les moteurs de recherche. Localisée Pas de /en par défaut dans l'URL. Routage côté serveur pour la langue. Localisation des chaînes statiques et du contenu. Responsive Excellents menus mobiles / support Safari iOS. Info-bulles sur desktop, popovers sur mobile. Accessible Lien "ignorer la navigation" vers le contenu principal. Toutes les images avec des balises alt. Respect des paramètres système de mouvement réduit. Universelle Livrer la documentation "en tant que code" (JSDoc, package). Livrer via des plateformes comme Context7, ou dans node_modules. Fichiers de règles (ex: AGENTS.md) avec le produit. Évaluations et modèles spécifiques recommandés pour le produit. Loi, société et organisation Microsoft va imposer une politique de Return To Office https://www.businessinsider.com/microsoft-execs-explain-rto-mandate-in-internal-meeting-2025-9 Microsoft impose 3 jours de présence au bureau par semaine à partir de février 2026, débutant par la région de Seattle Le CEO Satya Nadella explique que le télétravail a affaibli les liens sociaux nécessaires à l'innovation Les dirigeants citent des données internes montrant que les employés présents au bureau "prospèrent" davantage L'équipe IA de Microsoft doit être présente 4 jours par semaine, règles plus strictes pour cette division stratégique Les employés peuvent demander des exceptions jusqu'au 19 septembre 2025 pour trajets complexes ou absence d'équipe locale Amy Coleman (RH) affirme que la collaboration en personne améliore l'énergie et les résultats, surtout à l'ère de l'IA La politique s'appliquera progressivement aux 228 000 employés dans le monde après les États-Unis Les réactions sont mitigées, certains employés critiquent la perte d'autonomie et les bureaux inadéquats Microsoft rattrape ses concurrents tech qui ont déjà imposé des retours au bureau plus stricts Cette décision intervient après 15 000 licenciements en 2025, créant des tensions avec les employés Comment Claude Code est né ? (l'histoire de sa création) https://newsletter.pragmaticengineer.com/p/how-claude-code-is-built Claude Code : outil de développement "AI-first" créé par Boris Cherny, Sid Bidasaria et Cat Wu. Performance impressionnante : 500M$ de revenus annuels, utilisation multipliée par 10 en 3 mois. Adoption interne massive : Plus de 80% des ingénieurs d'Anthropic l'utilisent quotidiennement, y compris les data scientists. Augmentation de productivité : 67% d'augmentation des Pull Requests (PR) par ingénieur malgré le doublement de l'équipe. Origine : Commande CLI simple évoluant vers un outil accédant au système de fichiers, exploitant le "product overhang" du modèle Claude. Raison du lancement public : Apprendre sur la sécurité et les capacités des modèles d'IA. Pile technologique "on distribution" : TypeScript, React (avec Ink), Yoga, Bun. Choisie car le modèle Claude est déjà très performant avec ces technologies. "Claude Code écrit 90% de son propre code" : Le modèle prend en charge la majeure partie du développement. Architecture légère : Simple "shell" autour du modèle Claude, minimisant la logique métier et le code (suppression constante de code superflu). Exécution locale : Privilégiée pour sa simplicité, sans virtualisation. Sécurité : Système de permissions granulaire demandant confirmation avant chaque action potentiellement dangereuse (ex: suppression de fichiers). Développement rapide : Jusqu'à 100 releases internes/jour, 1 release externe/jour. 5 Pull Requests/ingénieur/jour. Prototypage ultra-rapide (ex: 20+ prototypes d'une fonctionnalité en quelques heures) grâce aux agents IA. Innovation UI/UX : Redéfinit l'expérience du terminal grâce à l'interaction LLM, avec des fonctionnalités comme les sous-agents, les styles de sortie configurables, et un mode "Learning". Le 1er Café IA publique a Paris https://www.linkedin.com/pulse/my-first-caf%25C3%25A9-ia-paris-room-full-curiosity-an[…]o-goncalves-r9ble/?trackingId=%2FPHKdAimR4ah6Ep0Qbg94w%3D%3D Conférences La liste des conférences provenant de Developers Conferences Agenda/List par Aurélie Vache et contributeurs : 30-31 octobre 2025 : Agile Tour Bordeaux 2025 - Bordeaux (France) 30-31 octobre 2025 : Agile Tour Nantais 2025 - Nantes (France) 30 octobre 2025-2 novembre 2025 : PyConFR 2025 - Lyon (France) 4-7 novembre 2025 : NewCrafts 2025 - Paris (France) 5-6 novembre 2025 : Tech Show Paris - Paris (France) 5-6 novembre 2025 : Red Hat Summit: Connect Paris 2025 - Paris (France) 6 novembre 2025 : dotAI 2025 - Paris (France) 6 novembre 2025 : Agile Tour Aix-Marseille 2025 - Gardanne (France) 7 novembre 2025 : BDX I/O - Bordeaux (France) 12-14 novembre 2025 : Devoxx Morocco - Marrakech (Morocco) 13 novembre 2025 : DevFest Toulouse - Toulouse (France) 15-16 novembre 2025 : Capitole du Libre - Toulouse (France) 19 novembre 2025 : SREday Paris 2025 Q4 - Paris (France) 19-21 novembre 2025 : Agile Grenoble - Grenoble (France) 20 novembre 2025 : OVHcloud Summit - Paris (France) 21 novembre 2025 : DevFest Paris 2025 - Paris (France) 24 novembre 2025 : Forward Data & AI Conference - Paris (France) 27 novembre 2025 : DevFest Strasbourg 2025 - Strasbourg (France) 28 novembre 2025 : DevFest Lyon - Lyon (France) 1-2 décembre 2025 : Tech Rocks Summit 2025 - Paris (France) 4-5 décembre 2025 : Agile Tour Rennes - Rennes (France) 5 décembre 2025 : DevFest Dijon 2025 - Dijon (France) 9-11 décembre 2025 : APIdays Paris - Paris (France) 9-11 décembre 2025 : Green IO Paris - Paris (France) 10-11 décembre 2025 : Devops REX - Paris (France) 10-11 décembre 2025 : Open Source Experience - Paris (France) 11 décembre 2025 : Normandie.ai 2025 - Rouen (France) 14-17 janvier 2026 : SnowCamp 2026 - Grenoble (France) 29-31 janvier 2026 : Epitech Summit 2026 - Paris - Paris (France) 2-5 février 2026 : Epitech Summit 2026 - Moulins - Moulins (France) 2-6 février 2026 : Web Days Convention - Aix-en-Provence (France) 3 février 2026 : Cloud Native Days France 2026 - Paris (France) 3-4 février 2026 : Epitech Summit 2026 - Lille - Lille (France) 3-4 février 2026 : Epitech Summit 2026 - Mulhouse - Mulhouse (France) 3-4 février 2026 : Epitech Summit 2026 - Nancy - Nancy (France) 3-4 février 2026 : Epitech Summit 2026 - Nantes - Nantes (France) 3-4 février 2026 : Epitech Summit 2026 - Marseille - Marseille (France) 3-4 février 2026 : Epitech Summit 2026 - Rennes - Rennes (France) 3-4 février 2026 : Epitech Summit 2026 - Montpellier - Montpellier (France) 3-4 février 2026 : Epitech Summit 2026 - Strasbourg - Strasbourg (France) 3-4 février 2026 : Epitech Summit 2026 - Toulouse - Toulouse (France) 4-5 février 2026 : Epitech Summit 2026 - Bordeaux - Bordeaux (France) 4-5 février 2026 : Epitech Summit 2026 - Lyon - Lyon (France) 4-6 février 2026 : Epitech Summit 2026 - Nice - Nice (France) 12-13 février 2026 : Touraine Tech #26 - Tours (France) 26-27 mars 2026 : SymfonyLive Paris 2026 - Paris (France) 31 mars 2026 : ParisTestConf - Paris (France) 16-17 avril 2026 : MiXiT 2026 - Lyon (France) 22-24 avril 2026 : Devoxx France 2026 - Paris (France) 23-25 avril 2026 : Devoxx Greece - Athens (Greece) 6-7 mai 2026 : Devoxx UK 2026 - London (UK) 22 mai 2026 : AFUP Day 2026 Lille - Lille (France) 22 mai 2026 : AFUP Day 2026 Paris - Paris (France) 22 mai 2026 : AFUP Day 2026 Bordeaux - Bordeaux (France) 22 mai 2026 : AFUP Day 2026 Lyon - Lyon (France) 17 juin 2026 : Devoxx Poland - Krakow (Poland) 4 septembre 2026 : JUG Summer Camp 2026 - La Rochelle (France) 17-18 septembre 2026 : API Platform Conference 2026 - Lille (France) 5-9 octobre 2026 : Devoxx Belgium - Antwerp (Belgium) Nous contacter Pour réagir à cet épisode, venez discuter sur le groupe Google https://groups.google.com/group/lescastcodeurs Contactez-nous via X/twitter https://twitter.com/lescastcodeurs ou Bluesky https://bsky.app/profile/lescastcodeurs.com Faire un crowdcast ou une crowdquestion Soutenez Les Cast Codeurs sur Patreon https://www.patreon.com/LesCastCodeurs Tous les épisodes et toutes les infos sur https://lescastcodeurs.com/

The FCC plans to roll back cybersecurity mandates that followed Salt Typhoon. The alleged cybercriminal MrICQ has been extradited to the U.S. Ransomware negotiators are accused of conducting ransomware attacks. Ernst & Young accidentally exposed a 4-terabyte SQL Server backup. A hacker claims responsibility for last week's University of Pennsylvania breach. The UK chronicles cyberattacks on Britain's drinking water suppliers. Monday business brief. Our guest is Caleb Tolin, host of Rubrik's Data Security Decoded podcast. Hackers massage the truth.  Remember to leave us a 5-star rating and review in your favorite podcast app. Miss an episode? Sign-up for our daily intelligence roundup, Daily Briefing, and you'll never miss a beat. And be sure to follow CyberWire Daily on LinkedIn. CyberWire Guest Today we are joined by Caleb Tolin, host of Rubrik's Data Security Decoded podcast, as he is introducing himself and his show joining the N2K CyberWire network. You can catch new episodes of Data Security Decoded the first and third Tuesdays of each month on your favorite podcast app. Selected Reading FCC plans vote to remove cyber regulations installed after theft of Trump info from telecoms (The Record) Alleged Jabber Zeus Coder ‘MrICQ' in U.S. Custody (Krebs on Security) Chicago firm that resolves ransomware attacks had rogue workers carrying out their own hacks, FBI says (Chicago Sun Times) Ernst & Young cloud misconfiguration leaks 4TB SQL Server backup on Microsoft Azure (Beyond Machines) Penn hacker claims to have stolen 1.2 million donor records in data breach (Bleeping Computer) Hackers are attacking Britain's drinking water suppliers (The Record) JumpCloud acquires Breez. Chainguard secures $280 million in growth financing. Sublime Security closes $150 million Series C round. (N2K Pro) Hackers steal data, extort $350,000 from massage parlor clients (Korea JoongAng Daily) Share your feedback. What do you think about CyberWire Daily? Please take a few minutes to share your thoughts with us by completing our brief listener survey. Thank you for helping us continue to improve our show. Want to hear your company in the show? N2K CyberWire helps you reach the industry's most influential leaders and operators, while building visibility, authority, and connectivity across the cybersecurity community. Learn more at sponsor.thecyberwire.com. The CyberWire is a production of N2K Networks, your source for strategic workforce intelligence. © N2K Networks, Inc. Learn more about your ad choices. Visit megaphone.fm/adchoices

How can the new AI tools help DBAs? Richard chats with Grant Fritchey about his experiences using various types of LLMs to help with his work as a DBA. Grant discusses having an LLM open as a side window to pass questions by, such as ideas for tuning, query optimization, scripts, and so on. Not all LLMs are the same - it's worth experimenting with different tools! The conversation delves into the long-term picture of AI supporting the DBA role, enabling more work to be accomplished in less time. Some of the work that used to be complex or tedious has become easier, but the need for people to assess outcomes remains essential.LinksPostgreSQLPerplexityCopilot for SQL Server Management StudiodbverseGitHub Copilot in VS CodeRecorded September 29, 2025

  Lee Brownhill is a Principal Cloud DBA at Cloud Rede with deep expertise in SQL Server performance tuning and automation. With years of experience across Azure and AWS, Lee helps clients optimize their cloud data platforms.   His journey began in IT support, quickly evolving into a passion for SQL Server that led him through roles as a Production and Developer DBA. Now, he's a trusted consultant, known for making systems run faster and smarter.   Lee is a Redgate Community Ambassador, a regular at SQLBits and Data Relay, and once spent a transformative week learning from T-SQL legend Itzik Ben-Gan. Whether on-prem or in the cloud, Lee's mission is simple: make SQL Server shine.   Topics of Discussion: [2:33] Lee shares his career journey, starting in general IT support and transitioning to a role involving Microsoft Dynamics NAV, which introduced him to SQL Server. [5:48] Jeffrey discusses the challenges faced by young programmers who work with databases but lack deep experience. [7:05] Lee highlights common anti-patterns in SQL Server. [8:04] The concept of “row by agonizing row.”  [8:46] Lee shares his thought process when addressing performance problems in SQL Server. [9:12] Categorizing issues based on their severity and urgency using a tried-and-true checklist. [10:36] Taking a step back to look at the issue holistically before diving into specific details. [16:04] An optimal database structure and segmentation in 2025, and the importance of normalization to avoid redundant data and ensure data integrity. [20:00] The different ways to host SQL Server in Azure and the benefits of each. [23:02] Metrics for determining if an Azure SQL instance is over- or under-provisioned. [25:02] The value of Azure's costing tools in helping to optimize resource usage and reduce costs. [26:07] The work of site reliability engineers who use KQL to analyze logs and identify issues. [30:09] Lee's blog is a repository of technical topics, including SQL Server, performance tuning, and unit testing. [32:10] SQL Server 2025 features and the importance of learning and understanding new technologies.   Mentioned in this Episode: Clear Measure Way Architect Forum Software Engineer Forum Lee Brownhill's Blog Lee Brownhill LinkedIn     Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.  

We let a dice roll decide today's topic, and the winner ended up being: Computed Columns with PERSISTED and Indexed Expressions. We give our thoughts about it, best practices, pit falls, and tips. Relevant links: SQL Server 2025 Preview RC1: Now Supporting Red Hat Enterprise Linux (RHEL) 10 | Microsoft Community Hub Specify computed columns in a table - SQL Server | Microsoft Learn Indexes on computed columns - SQL Server | Microsoft Learn

The Pure Report welcomes Anthony Nocentino, Sr. Principal Field Solution Architect, to delve into the future of databases and data management. This episode looks at the explosive growth of relational databases and the impact of SQL Server 2025, Oracle 23ai, and AI-driven demands. We explore how Pure Storage is not just keeping pace with database growth but actively simplifying management, scaling, and protection, moving beyond foundational support to offer operational freedom for DBAs and infrastructure teams. Anthony tackles the pressing challenges faced by database environments today, including fragmented storage infrastructure, manual provisioning, and the complexities of compliance, disaster recovery, and hybrid cloud strategies. Anthony sheds light on how these issues contribute to real-world burnout among DBAs and infra team members. The discussion will also cover the evolving roles of these professionals as they increasingly become platform performance engineers, cloud strategists, and data ops troubleshooters in a world of multiple database engines and unpredictable resource needs driven by AI workloads. Hear about how Pure's vision for the Enterprise Data Cloud connects to database operations, including key announcements from our Accelerate Vegas and NYC events. We dive into how Pure Fusion with workflow templates and Pure1 offers intelligent, AI-powered workload and resource management, automated policy-based provisioning, and a unified single control plane across on-prem, cloud, and hybrid environments. The episode also explores the implications for enterprise-ready storage with the FlashArray platform family, showcasing how products like FA//XL, FA//X, FA//C, and FA//ST simplify workload expansion and provide significant performance benefits. Finally, we'll get Anthony's "Hot Takes" on critical DBA tasks, dream fixes for database environments, and common myths he'd like to debunk, all while looking forward to Pure's presence at Oracle AI World.

"I think the biggest trap to potentially fall into is, "Hey, it's moving so fast, so much is changing. Let's just wait it out." Completely the wrong approach. You just gotta get started." Nick Eayrs from Databricks "As tech people within the shipping industry, how do we explain, how do we make it accessible to all our users? So that's where we came up with the idea of a data supermarket, with in mind really the target of enabling self-service for our business. So by giving the analogy of a supermarket, it was much easier at the beginning to explain our business." - Simon Fassot from Hafnia Fresh out of the studio, Nick Eayrs, Vice President of Field Engineering for Asia Pacific and Japan at Databricks, and Simon Fassot, General Manager and Head of Global Data and Analytics at Hafnia, join us to explore how data intelligence is transforming enterprise AI across diverse industries in Asia. Nick explained the fundamental distinction between general intelligence and data intelligence - emphasizing how enterprises gain competitive advantage by training AI on their proprietary data rather than public knowledge. Nick showcased customer success stories including Standard Chartered Bank and TechComBank and shared his perspectives on how senior executives can take advantage of AI by moving fast rather than wait and see. Last but not least, Nick offered what great would look like for Databricks in Asia Pacific and Japan in serving their customers. Adding the lens of the customer, Simon shared Hafnia's transformation from legacy SQL Server systems to a unified Databricks architecture serving their global shipping operations and elaborated on how the company is breaking down silos with their data supermarket and "Marvis" AI copilot for maritime operations based on retrieval augmented generation. This is Part 1 from Databricks Data + AI Event Singapore.  Episode Highlights: [00:00] QOTD by Nick Eayrs and Simon Fassot [00:49] Introduction: Nick Eayrs from Databricks [03:32] Customer obsession means deeply understanding their business context [05:22] Data intelligence versus artificial general intelligence explanation begins [06:42] AI trained on your data creates competitive advantage [08:17] Only 15% of companies have correct AI infrastructure ready [11:17] Don't wait for AI perfection, just get started now [12:30] Agent Bricks simplify AI development using natural language [13:49] Standard Chartered Bank cybersecurity use case with SIEM [16:22] TechCom Bank in Vietnam customer brain with 12,000 customer attributes [18:32] Shared responsibility model for ethical AI deployment [25:24] Asia Pacific psychology focuses on future, not past [26:28] Most important question: How do you get started? [30:18] What does great look like for Databricks? [33:16] Introduction: Simon Fassot from Hafnia [35:18] How Hafnia transformed to full cloud architecture centralizes data through Databricks [36:28] Self-service access needed for 300 onshore, 4000 vessel employees [37:00] Three user types: operations, business intelligence, domain experts and Use Cases for Hafnia [41:32] Unity catalog controls data quality for AI cases [42:21] Two-phase Gen AI: ingest unstructured, then consume data [44:25] How to implement Generative AI: One bad AI answer loses all user trust [45:31] How reports in Hafnia use RAG embedded in workflows [46:47] Data supermarket analogy simplifies self-service for business [48:39] Marvis AI personalizes Gen AI within company context [49:46] Neo4j partnership adds graph capabilities to ecosystem [53:33] DNA Port platform unifies scattered dashboards and applications [54:22] Databricks enables focus on business value over operations Profiles: Nick Eayrs, Vice President of Field Engineering, Asia Pacific & Japan at Databricks LinkedIn: https://www.linkedin.com/in/nick-eayrs/ Simon Fassot, General Manager and Head of Global Data and Analytics at Hafnia LinkedIn: https://www.linkedin.com/in/simon-fassot-68b95135/ Podcast Information: Bernard Leong hosts and produces the show. The proper credits for the intro and end music are "Energetic Sports Drive." G. Thomas Craig mixed and edited the episode in both video and audio format. Here are the links to watch or listen to our podcast. Analyse Asia Main Site: https://analyse.asia Analyse Asia Spotify: https://open.spotify.com/show/1kkRwzRZa4JCICr2vm0vGl Analyse Asia Apple Podcasts: https://podcasts.apple.com/us/podcast/analyse-asia-with-bernard-leong/id914868245 Analyse Asia LinkedIn: https://www.linkedin.com/company/analyse-asia/ Analyse Asia X (formerly known as Twitter): https://twitter.com/analyseasia Sign Up for Our This Week in Asia Newsletter: https://www.analyse.asia/#/portal/signup Subscribe Newsletter on LinkedIn https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7149559878934540288

Many of you reading this likely have an Availability Group (AG) set up on at least one database in your organization. Maybe not most, but many of you as this has proven to be a technology that many people like for HA/DR, upgrades, and probably other uses. As the technology has evolved from it's SQL Server 2012 debut, it has improved in many ways. This might be one of the few features that has received regular attention from the developers in Redmond across multiple versions. That's not to imply this is a foolproof or bug-free feature. Numerous people have had issues with the various types of AGs. From setup to performance to scale, I've seen many people post questions and search for answers on how to get their system running smoothly and reduce any late-night calls. Read the rest of Pushing the Limits of AGs

Guy and Eitan discuss several interesting announcements and updates from Microsoft related to SQL Server and VS Code. And also Eitan talks about a weird issue he encountered involving page latch time-outs during DBCC CHECK command. Please fill out the SQL Server on Linux adoption survey here! Thank you! Relevant links: Higher log rate for business critical service tier in Azure SQL MI | Microsoft Community Hub What's New in MSSQL Extension for VS Code v1.35 Accelerating SQL Server 2025 momentum: Announcing the first release candidate - Microsoft SQL Server Blog Error 845 Time-out occurred while waiting for buffer latch type 4 during DBCC CHECK - Eitan Blumin's blog

I saw a post from Brent that Microsoft had changed the default memory guidance. At first glance I read this as they'd changed the default values, which would be interesting. However, this is a guideline, set to 75%. I also saw a few thoughts from Randolph West on LinkedIn, and quite a few comments. The comments were interesting in a few ways. It is easy to look at 75% and say that won't work for this server that's on my mind right now because I keep getting woken up. That might be true. However, the 75% number isn't a hard requirement. It's a guideline, a recommendation to ensure you have enough memory for the OS, but you're trying to use most for SQL Server. Feel free to adjust it if you feel the need. Read the rest of Guidelines and Requirements

Tony Cardella is a seasoned software engineer based in Houston, Texas. With a robust background in enterprise development, Tony brings deep expertise in the .NET Framework (C#), Python, and cloud platforms including Microsoft Azure and Amazon Web Services. His technical repertoire spans both relational databases — such as SQL Server, MySQL, and PostgreSQL — and NoSQL solutions like Azure Cosmos DB.   Tony is a strong advocate for developer productivity tools, frequently leveraging JetBrains products including ReSharper, DataGrip, PyCharm, and Rider, as well as Visual Studio. Outside the world of code, Tony is equally passionate about strength training, whether he's lifting weights himself or coaching others in the discipline.   Topics of Discussion: [1:34] Tony shares his career journey, starting with a consulting company that reached out to him while he was job hunting. [3:17] NCrunch is an automated testing tool that runs unit tests continuously, focusing on impacted tests. [5:08] Challenges and benefits of NCrunch, and why would we need to use it? [7:44] Tony shares his approach to unit testing, focusing on covering 80% of the code with minimal effort and addressing the remaining 20% as needed. [8:51] The importance of not over-investing in unit tests that may not provide significant value. [11:47] Tony explains how Ncrunch provides code coverage metrics and visual indicators of covered and uncovered code. [12:59] The tool's ability to show exactly where unit tests are failing, without needing to dive into stack traces. [13:51] Distributed processing and integration tests. [27:44] The challenges of running integration tests with external dependencies, such as databases. [29:18] Exploratory testing and code quality. [32:34] Tony emphasizes the value of unit tests in codifying tribal knowledge and ensuring code quality.   Mentioned in this Episode: Clear Measure Way Architect Forum Software Engineer Forum Tony Cardella Lightning Talks! The Code Gorilla Survey: Fixing Bugs Stealing Time from Development NCrunch   Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

SQL Server 2025 is out in preview form. CTP 2.0 is available for you to test, and there are quite a few changes that have been added to the platform. Some of these are already in the cloud, but this is your chance to test them in your environment. This is version 17.x, though I don't know we've really had 17 versions to work with. In any case, there have been a lot of versions in my career. I've connected to and worked on all of these: 4.2, 6.0, 6.5, 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019, 2022. No 2025 yet (other than install and a few basic queries), but that's coming. Read the rest of Your Favorite Improvement

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