Podcasts about SQL Server

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Ryan is an Advocate at Redgate focusing on PostgreSQL. Ryan has been working as a PostgreSQL advocate, developer, DBA, and product manager for over 20 years, primarily working with time-series data on PostgreSQL and the Microsoft Data Platform.   Ryan is a long-time DBA, starting with MySQL and Postgres in the late '90s. He spent more than 15 years working with SQL Server before returning to PostgreSQL full-time in 2018. He's at the top of his game when learning something new about the data platform or teaching others about the technology he loves.   Topics of Discussion: [4:10] What made Ryan a database guy? [6:11] CodeMash. [6:58] Discovering the potential of SQL Server. [12:02] The state of the database in 2025 and the things generalist developers should know. [15:27] The challenge of interfacing between database types. [19:57] Is Microsoft Fabric the future? [22:44] Postgres for .NET developers. [24:46] Nuances of migrating from SQL Server to Postgres. [26:01] Postgres resources for data professionals. [35:29] Postgres and its innovative edge. [38:30] What is a vector database? [39:45] The power of Postgres indexing.   Mentioned in this Episode: Clear Measure Way Architect Forum Software Engineer Forum Programming with Palermo — New Video Podcast! Email us at programming@palermo.net. Clear Measure, Inc. (Sponsor) .NET DevOps for Azure: A Developer's Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon! Jeffrey Palermo's Twitter — Follow to stay informed about future events! Ep 245 with Ryan Booz Figuring Out Fabric SQLGene Training Introduction to PostgreSQL for the data professional. Kindle Edition Postgres Playground pgEdge “Name Collision of the Year”   Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

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

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

גיא ואיתן מגמגמים בקצרה על SQL Server 2025 ופיצ'רים חדשים ומעניינים. וגם, שאלה מהפורום לגבי איטיות של דיסקים באז'ור עם תשובה מפתיעה, סקריפטים מגניבים של יניב אתרוגי, ועוד. קישורים רלוונטיים: Announcing SQL Server 2025 – SQLServerCentral What's New in SQL Server 2025 - Brent Ozar Unlimited® Optimized Locking - SQL Server | Microsoft Learn Buyer Beware: Azure SQL Managed Instance Storage is Regularly as Slow as 60 Seconds microsoft-dbas-club/High Availability/SynchronizeSQLServerObjects Contained Availability Groups in SQL Server 2022 - Eitan Blumin's blog microsoft-dbas-club/High Availability/BasicAGMonitor microsoft-dbas-club/Indexes/DataCompression microsoft-dbas-club/Security and Compliance/Windows Group Members.sql  

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

In this episode, Warner is joined by Microsoft MVP Luan Moreno, to discuss the latest announcements from the Microsoft Ignite 2024 conference. These include the latest updates for Microsoft Fabric, the new AI Foundry, AI Search updates, SQL Server 2025 and more!

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

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

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

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

  Read the rest of New SQL Server 2022 Functions

Increase scalability, optimize performance, and integrate advanced AI features with Azure Database for PostgreSQL Flexible Server. Scale up with SSD v2 for up to 4x more transactions per second and significantly lower latency. Scale out effortlessly with elastic clusters using Citus, distributing workloads across multiple servers at no extra cost. Optimize performance with Automatic Index Tuning, reducing server utilization and enhancing efficiency. Leverage advanced AI features like DiskANN, semantic reranking, and Graph RAG to build better AI apps. Charles Feddersen, Partner Director of Program Management for Postgres at Microsoft, joins Jeremy Chapman to show you how to build scalable, high-performance AI apps on Azure PostgreSQL Flexible Server today.  ► QUICK LINKS: 00:00 - Azure Database for Postgres Flexible Server 00:39 - Updates to PostGreSQL 01:50 - Faster storage with SSD v2 03:06 - Scale out workloads using elastic cluster 03:59 - Provision an elastic cluster 05:34 - Scale "in-place" 07:12 - Eliminate redundant indexes 07:44 - Optimize server parameters 09:52 - Improve AI apps with Postgres Flexible Server 11:40 - Code behind queries using PG Admin 12:31 - Scale workloads 13:36 - Wrap up ► Link References Get started at https://aka.ms/azurepostgresblog Access code at https://aka.ms/AzurePostgresAI ► Unfamiliar with Microsoft Mechanics? As Microsoft's official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft. • Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries • Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog • Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/podcast   ► Keep getting this insider knowledge, join us on social: • Follow us on Twitter: https://twitter.com/MSFTMechanics • Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/ • Enjoy us on Instagram: https://www.instagram.com/msftmechanics/  

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

لو خطر في بالك قبل كده ليه عندنا كل قواعد البيانات دي, و ليه فيه منهم انواع مختلفة DBMS, NOSQL و غيرهم, طيب الناس اللي بتشتغل على الحاجات دي ايه التحديات اللي بيواجهوها, و ايه التخصص ده و ايه المتطلبات بتاعته. Ahmed Ayad is a SQL Engineer by trade, a database guy by education and training, and data dude by passion. I am currently an Engineering Director of the Managed Storage and Workload Management team in Google #BigQuery, building the best large scale enterprise data warehouse on the planet. My team owns the core parts of BigQuery involved in managing user data, metadata catalog, streaming and batch ingestion, replication, resource management and placement, physical sharding, and structured lake analytics. Over the years we have: - Grew data under management by several orders of magnitude. - Grew BigQuery's global footprint to more than 20+ regions and counting. - Enabled the hyper scaling of data analytics for a Who's Who list of Fortune 500 users, both Enterprise and Cloud-native. I am passionate about building cool technologies at scale, and the effective teams that create them. Things I did in previous professional lives: - I have shipped components in SQL Server product since SQL Server 2008. Worked on the Performance Data Collector, Policy Based Management, AlwaysOn, The Utility Control Point, SQL Azure stack from the backend to the middle-tier and Portal, SQL Server Agent, SQL Server Optimizer, and SQL Server Management Tools. - Did Database research in the areas of Data Mining, Query Optimization, and Data Streaming.

Microsoft constantly releases new features and products in the data platform space. Many of us have seen the SQL Server product grow in new ways, some of which are very useful to us. As an example the changes from log shipping to clustering to Availability Groups has improved our HA/DR options as well as the capabilities available to us in different situations. With that in mind, I saw someone recently that wanted to deploy SQL Server on Kubernetes, which is something that could be a very interesting way of managing your different systems. However, this individual wanted to know when Microsoft would release their own supported solution with a Microsoft operator to manage the instance. There is guidance from Microsoft, but no official operator. Read the rest of Do You Want a Microsoft Solution?

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

Recently I was watching a presentation on how to scale performance in your SQL Server environment and one of the suggestions was setting up Availability Groups (AGs) and having read-intent connections that would query the secondary and not the primary. It's not a bad idea, and the SQL Native Client (and other drivers) support this and make it easy to implement. The pattern of using multiple connections in an application, one for reads and one for writes, has been suggested often. However, in practice, I've rarely seen this work. Apparently having a connection variable, named dbConn, for writes and a second one, named dbConnReadOnly, for reads is too complex for most developers or teams. Read the rest of Separate Reads

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

Today is the first day at the PASS Data Community Summit and I'm in Seattle where I'll get to open the conference and introduce the Microsoft keynote. I'm sure the keynote will be full of announcements on something, but what? I'm writing this a little over a week before the event, and I have no idea what Microsoft will do. Actually, by the time you read this I may have some ideas as there was a practice session yesterday, but I can't tell you anything. NDA, and really, by the time I got something organized, the keynote will be done. Read the rest of What's New for the Microsoft Data Platform

Scott Norberg joins Ken Johnson and Seth Law for an episode of Absolute AppSec all about SAST. Scott is an ASP.NET Security Consultant, Author, Researcher and Speaker. In addition to running his Opperis Technologies consultancy, Scott has recently begun working as lead application security architect at CDW. Before that he worked as Lead Application Security engineer at Gallagher and was a Senior Consultant with the AppSec team at Coalfire. He has been a web security specialist for nearly two decades, and holds several certifications, including Microsoft Certified Technology Specialist (MCTS), certifications for ASP.NET and SQL Server, and a Certified Information Systems Security Professional (CISSP) and CCSP certification. He also has an MBA from Indiana University. To find out more about Scott check out his website https://scottnorberg.com/ as well as his 2020 book Advanced ASP NET Core Security Vulnerabilities.

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

Grant Fritchey has over thirty years of experience in IT, specializing in development and database administration. He works for Red Gate Software as a Product Advocate and writes articles for SQL Server Central and Simple-Talk. He is the author of “SQL Server Execution Plans” and “SQL Server Query Performance Tuning.” He also co-authored “Query Store for SQL Server 2019,” “Expert Performance Indexing,” “SQL Server MVP Deep Dives 2,” “Beginning SQL Server 2012 Administration,” and “Pro SQL Server 2012 Practices.”   He presents at conferences and user groups worldwide and is available for part-time, short-term consulting contracts.Since 2009, he has been recognized as a Microsoft SQL Server MVP. He has received the AWS Community Builder award for the past five years. In 2014, he was honored as a Dunn & Bradstreet MVP, and in 2011, he received the Tech10 Award in Rhode Island.   Topics of Discussion: [:35] Introduction of Grant Fritchey and his career in IT and database administration. [3:23] Grant's journey from software development to becoming a DBA. [5:13] The importance of database selection and how different types of databases serve different needs. [11:27] Grant's view on the addition of document support to major database platforms. [13:29] Database hygiene basics and the importance of regular backups and restore practices. [19:26] The business side of database recovery and balancing cost with recovery objectives (RPO/RTO). [25:03] Grant's recommendations for testing database restores. [28:08] Automation in DevOps and the importance of human training in recovery processes. [31:53] Managing data warehouses and recovery strategies for large databases. [35:12] Resources for developers without dedicated DBAs to ensure good database hygiene.   Mentioned in this Episode: Clear Measure Way Architect Forum Software Engineer Forum Programming with Palermo — New Video Podcast! Email us at programming@palermo.net. Clear Measure, Inc. (Sponsor) .NET DevOps for Azure: A Developer's Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon! Jeffrey Palermo's Twitter — Follow to stay informed about future events! SimpleTalk by Redgate ScaryDBA.com Grant Fritchey on X   Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

Guy and Eitan discuss some interesting news from Microsoft regarding SQL Server, and also about the right way to handle index fragmentation. Relevant links: Resources from Microsoft: Preview release of SDK-style SQL projects in Visual Studio 2022 - Microsoft Community Hub Native JSON support now in preview in Azure SQL Managed Instance - Microsoft Community Hub EAP for Vector Support Refresh - Introducing Vector type - Azure SQL Devs' Corner (microsoft.com) Calling external REST endpoints from Azure SQL Database | Microsoft Learn Index fragmentation: SQL Server Backup, Integrity Check, Index and Statistics Maintenance (hallengren.com) Should we do index maintenance on an Azure SQL Managed Instance or Azure SQL Database? (kendralittle.com) Stop Worrying About SQL Server Index Fragmentation (brentozar.com) Why SQL Server Index Fragmentation Isn't A Problem On Modern Storage Hardware – Darling Data (erikdarling.com) Index fragmentation scripts: microsoft-dbas-club/Indexes/Table and Index High Unused Space.sql at MadeiraData/microsoft-dbas-club Check Index Fragmentation Based on Page Fullness and Fill Factor Upcoming webinar at the Cloud Data Driven Meetup: Database DevOps for Leaders - Eitan Blumin, Thu, Oct 24, 2024, 12:00 PM | Meetup

Send me a Text Message hereFULL SHOW NOTES https://podcast.nz365guy.com/599  Ever wondered how a technologist with decades of experience balances a vibrant personal life and a transformative career? Our latest episode features Mark Slosberg, the mastermind behind Hanging Valley Enterprises. With a rich history in the tech world and 42 years of marriage, Mark shares his love for cooking in a kitchen tailored for two type-A chefs, his passion for smoking meats and fish, and his joy in hosting family pizza nights. Outside the kitchen, Mark and his wife are committed hikers and gardeners, transforming their property near Seattle into a low-maintenance haven filled with native plant species.Mark's professional journey is equally compelling. He recalls advocating for SQL Server 2008 at Chevron and spearheading the Microsoft practice at PwC, which significantly integrated Power BI and early PowerApps adoption. His story doesn't end there; after leaving PwC, Mark took on groundbreaking projects using PowerApps and Azure AI, including a successful application for a major seed distributor. His insights reveal how these tools have revolutionized business processes and data management, providing a unique perspective on the evolution of technology in consulting.In a detailed case study, Mark illustrates the power of custom solutions in business technology. He recounts developing a seed distribution app for an agriculture firm struggling with an outdated JD Edwards system. By prototyping with Power Apps and Power BI, Mark's team enhanced data access and streamlined sales operations. Furthermore, he shares a transformative experience with a billion-dollar firm, where leveraging SQL Server and standardizing data views turned around an underperforming Cognos implementation. Tune in to learn how integrating Power Apps with JD Edwards using APIs can revolutionize backend operations and ensure long-term system efficiency.Resources Mentioned First solution in the Microsoft AppSource online solution catalog - https://appsource.microsoft.com/en-us/product/dynamics-365/hangingvalleyenterprisesllc1645487787841.salesenable  90 Day Mentoring Challenge 10% off code use MBAP at checkout https://ako.nz365guy.comSupport the showIf you want to get in touch with me, you can message me here on Linkedin.Thanks for listening

If you use SQL Server, you will eventually have to migrate that instance somewhere – to a new version, a new server, the cloud . . . somewhere. Or perhaps you'll find yourself migrating from another database into SQL Server. No matter which way you slice it, SQL Server migrations can be daunting, not to mention complex and time-consuming. While we know there are risks and many things that can go wrong, the "new" Microsoft continues to put time and effort towards making successful SQL Server migrations attainable for everyone. In this episode of the podcast, we chat with Tejas Shah and Sudhir Raparla, 2 of the Microsoft Project Managers responsible for SQL Server migration tooling. They share practical perspectives on approaching your SQL migration with confidence and the tools and enhancements that will help. During the conversation, Tejas and Sudhir also take us through the 5 migration steps they want you to consider as you undertake your SQL Server migration process. Even though we've migrated thousands of databases, I had to go back and peek at a couple of the new features the migration tooling team has added. One intriguing addition is the Azure SQL Pricing repository, which is part of the SQL Server Migration assistant and can help with determining costs based on industry standards, deployment recommendations, target sizing, and monthly savings based on your unique scenario. Let us know what you think! What SQL migration features have you come to trust and rely on? Did you get any good takeaways from today's podcast or have some questions? Leave us a comment and some love ❤️ on LinkedIn, X, Facebook, or Instagram. The show notes for today's episode can be found at Episode 279: SQL Server Migrations Demystified. Have fun on the SQL Trail!

What makes MotherDuck and DuckDB a game-changer for data analytics? Join us as we sit down with Jacob Matson, a renowned expert in SQL Server, dbt, and Excel, who recently became a developer advocate at MotherDuck. During this episode, Jacob shares his compelling journey to MotherDuck, driven by his frequent use of DuckDB for solving data challenges. We explore the unique attributes of DuckDB, comparing it to SQLite for analytics, and uncover its architectural benefits, such as utilizing multi-core machines for parallel query execution. Jacob also sheds light on how MotherDuck is pushing the envelope with their innovative concept of multiplayer analytics.Our discussion takes a deep dive into MotherDuck's innovative tenancy model and how it impacts database workloads, highlighting the use of DuckDB format in Wasm for enhanced data visualization. Jacob explains how this approach offers significant compression and faster query performance, making data visualization more interactive. We also touch on the potential and limitations of replacing traditional BI tools with Mosaic, and where MotherDuck stands in the modern data stack landscape, especially for organizations that don't require the scale of BigQuery or Snowflake. Plus, get a sneak peek into the upcoming Small Data Conference in San Francisco on September 23rd, where we'll explore how small data solutions can address significant problems without relying on big data. Don't miss this episode packed with insights on DuckDB and MotherDuck innovations!Small Data SF Signup  Discount Code: MATSON100What's New In Data is a data thought leadership series hosted by John Kutay who leads data and products at Striim. What's New In Data hosts industry practitioners to discuss latest trends, common patterns for real world data patterns, and analytics success stories.

David Neal, developer advocate and Asana content creator, discusses his talk, The Illustrated Guide to Node.js. David shares insights from his 10-year journey with Node.js, discussing its origins, use cases, and why it remains a vital tool for developers, giving insights into JavaScript's evolution and practical tips for navigating the Node.js ecosystem. Links https://reverentgeek.com https://twitter.com/reverentgeek https://techhub.social/@reverentgeek https://staging.bsky.app/profile/reverentgeek.com https://www.threads.net/@reverentgeek https://github.com/reverentgeek https://www.youtube.com/ReverentGeek https://www.linkedin.com/in/davidneal We want to hear from you! How did you find us? Did you see us on Twitter? In a newsletter? Or maybe we were recommended by a friend? Let us know by sending an email to our producer, Emily, at emily.kochanekketner@logrocket.com (mailto:emily.kochanekketner@logrocket.com), or tweet at us at PodRocketPod (https://twitter.com/PodRocketpod). Follow us. Get free stickers. Follow us on Apple Podcasts, fill out this form (https://podrocket.logrocket.com/get-podrocket-stickers), and we'll send you free PodRocket stickers! What does LogRocket do? LogRocket provides AI-first session replay and analytics that surfaces the UX and technical issues impacting user experiences. Start understand where your users are struggling by trying it for free at [LogRocket.com]. Try LogRocket for free today.(https://logrocket.com/signup/?pdr) Special Guest: David Neal.