Sam Nasr on SQL Server for Developers - Episode 122

Sam Nasr on SQL Server for Developers - Episode 122

In this episode, Jeffrey is excited to be joined by his guest, Sam Nasr! Sam is an IT Consultant and a Sr. Software Engineer with a deep focus on the Microsoft stack of technologies (.Net, SQL Server, Azure). In his role of 12+ years at NIS Technologies, Sam provides consulting services, training, and custom app development to help bring more value to business applications. He is also incredibly passionate about giving back to the community and speaks at many events, conferences, and user groups; writes articles; and is always keeping on top of new technologies. He also serves as a leader at the Cleveland C#/VB .NET user group.

Together, Jeffrey and Sam discuss the ins and outs of SQL Server for developers, highlight the current state-of-the-art practices, what it looks like in 2020 to build a SQL Server database, and the go-to resources you should be looking at.

Topics of Discussion:

[:38] Be sure to visit AzureDevOps.Show for past episodes and show notes.

[1:02] About The Azure DevOps Podcast and Jeffrey's offer to speak at virtual user groups.

[1:13] Clear Measure is hiring! Be sure to check out the link in the show notes.

[1:39] About today's guest, Sam Nasr!

[2:13] Jeffrey welcomes Sam to the podcast.

[2:19] Sam shares some career highlights and speaks about his current role.

[3:46] Sam shares his philosophy on teaching and learning.

[7:34] Sam's mindset around SQL Server for developers and a brief history of it.

[10:44] Sam elaborates on the ins and outs of building on SQL Server.

[14:20] Can you do file tables through Entity Framework?

[15:12] Sam explains another cool feature of SQL Server: temporal tables.

[17:00] A word from Azure DevOps Podcast's sponsor: Clear Measure.

[17:32] Are temporal tables suited for time-based analytical queries?

[19:42] What do you need to do to get the temporal features added on?

[20:46] Sam speaks about one of his favorite conferences: SQLSaturday!

[22:18] The current state-of-the-art practices that Sam is employing for building the database, testing the database, and deploying changes.

[24:12] What does it mean in 2020 to build a SQL Server database?

[26:34] There's a lot of choices to make when it comes to databases. Sam shares his insights on these choices, the NoSQL movement, and what developers should be looking at and considering.

[29:54] Jeffrey and Sam shares some final words on the benefits and ease-of-use of SQL Server.

[32:17] Jeffrey thanks Sam for joining the podcast and Sam shares some go-to resources to check out after the show!

Mentioned in this Episode:

Azure DevOps

Clear Measure (Sponsor)

.NET DevOps for Azure: A Developer's Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon!

bit.ly/dotnetdevopsebook — Click here to download the .NET DevOps for Azure ebook!

Jeffrey Palermo's Youtube

Jeffrey Palermo's Twitter Follow to stay informed about future events!

The Azure DevOps Podcast's Twitter: @AzureDevOpsShow

Sam Nasr's LinkedIn

Sam Nasr's GitHub

NIS Technologies

SQL Server

T-SQL

Entity Framework

SQL Azure

SQLSaturday

Entity Framework Code-First

MongoDB

Azure Cosmos DB

Meetup.com

Want to Learn More?

Visit AzureDevOps.Show for show notes and additional episodes.

Avsnitt(382)

Scott Hanselman: The Future of Software Engineering - Episode 382

Scott Hanselman: The Future of Software Engineering - Episode 382

Scott Hanselman is a teacher at heart. He speaks all over to whoever will listen. He's have written code that you, dear listener, has used. Scott has been blogging, coding, and podcasting a LONG time. He codes, writes, speaks, empowers, promotes, braids, learns and listens - usually not in that order. And he's a Vice President at Microsoft in his day job focusing on Developer Community. You can find him on YouTube, TikTok, Instagram, and Mastodon! His Hanselminutes podcast has surpassed 900 episodes, and his Azure Friday show, over 750 episodes. Connect with him at hanselman.com Mentioned in This Episode Episode 280  Scott Hanselman's TEDx Portland Talk Want to Learn More?  Visit AzureDevOps.Show for show notes and additional episodes.

29 Dec 38min

Glenn Condron: Aspire Strategy for .NET - Episode 381

Glenn Condron: Aspire Strategy for .NET - Episode 381

Glenn is a Principal Product Manager for the App Platform team within the Developer Division at Microsoft, focusing on .NET. Before joining Microsoft Glenn was a developer in Australia where he worked on software for various government departments.   Mentioned in this Episode X Account Episode 293 Episode 58  Github Microsoft Devblog  Building Cloud Native apps with .NET 8 Simplifying Cloud-Native Development with .NET 8 Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

22 Dec 52min

Jared Parsons: The Latest with C# - Episode 380

Jared Parsons: The Latest with C# - Episode 380

Jared Parsons is a Developer Manager for the .NET Tools team at Microsoft. He's also done extensive work on the C# Compiler Team. Everybody tuning in probably uses his code on a day-to-day basis! Jared started out at Microsoft over 20 years ago as a Developer; moved on to become a Senior Developer; then Principal Developer on Midori OS; and most recently, the Principal Developer on C# Compiler Team, and now a Developer Manager. He's spoken at many conferences, like Microsoft Build and others. Mentioned in this Episode Episode 287 Episode 53  Github - Rosyln  Github - Analyzers  Github - Csharplang  Jared's LinkedIn  Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

15 Dec 42min

Chris Wilke: Generated AI Stories - Episode 379

Chris Wilke: Generated AI Stories - Episode 379

Chris has 25 years experience as a seasoned SaaS and AI product leader known for practical, people-first strategies to harness value from Generative AI for operational excellence. Chris developed the AI Vantage framework—a strategic approach that emphasizes process-driven transformation to unlock immediate and long-term value from GenAI technologies. He works for Viewport as the Head of Technology and is a respected voice in the AI and product management space, frequently sharing insights through training, blogs, and speaking engagements. Chris holds certifications in SAFe Product Ownership and Pragmatic Marketing, and is an alumnus of Texas A&M University. Mentioned in this Episode Chris' Website Chris' X Account Chris' LinkedIn Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

8 Dec 38min

Alvin Ashcraft: Community Conferences - Episode 378

Alvin Ashcraft: Community Conferences - Episode 378

Alvin is a senior content developer at Microsoft, author, and longtime leader in the .NET developer community. With over 27 years of experience in software development, Alvin has been recognized as a Microsoft MVP for more than a decade, honored for his contributions to Windows development, Visual Studio, and the broader Microsoft ecosystem. He is currently writing docs for multiple Microsoft technologies. In 2021, Alvin wrote a book for Packt Publishing, Learn WinUI 3.0. This is the first book Alvin authored and has been the technical reviewer for eight other .NET-related titles from Packt. Alvin is a founding board member of the TechBash Foundation and organizer of the annual TechBash developer conference in Pocono Manor, PA. Alvin resides in Pennsylvania with his wife and three daughters.   Mentioned in this Episode: LinkedIn Website  Alvin's Book  Episode 214  Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

1 Dec 28min

Dan Clarke: Personal Productivity - Episode 377

Dan Clarke: Personal Productivity - Episode 377

Dan Clarke is a seasoned software consultant, Microsoft MVP, and founder of Everstack Ltd. Dan is widely known for his contributions to the .NET ecosystem and hosts the Unhandled Exception Podcast.  With a background in DevOps, Azure, and developer tooling, Dan brings a thoughtful, systems-level perspective to software craftsmanship. His work spans technical education, community leadership, and content creation—from blog posts and newsletters to YouTube tutorials and conference talks.  Dan resides in the UK and when he isn't programming, he enjoys daily weightlifting, playing the guitar, and a past life of skydiving and motorcycling. Mentioned in this Episode: Clear Measure Way Architect Forum Software Engineer Forum Dan Clarke Website  Dan's Podcast  Dan's Newsletter  Dan's Youtube Dan's Blog  Dan's Linkedin  Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

24 Nov 41min

Andrew Lock: Testing Frameworks - Episode 376

Andrew Lock: Testing Frameworks - Episode 376

Andrew Lock is a staff software engineer at Datadog and educator whose contributions to the .NET ecosystem have shaped how developers approach modern web applications.  Located in the UK, Andrew is a Microsoft MVP, Author of ASP.NET Core in Action, and has an active blog all about his experience working with .NET and ASP.NET Core.   Topics of Discussion: [2:56] Andrew talks about appreciating the joy of coding and the minutiae of figuring out the correct way to do things. [3:28] Andrew discusses the various testing frameworks available for .NET, including MS Test, NUnit, XUnit, and TUnit. He explains the history and evolution of these frameworks, noting that XUnit has become the de facto default version. [7:41] Andrew explains his interest in TUnit, a newer testing library that addresses some of the limitations of XUnit. [9:29] TUnit is designed to be fast, supporting parallel execution and native AOT for better performance. [12:16] Is there a way to radically speed up the execution of big test suites? [15:39] Andrew explains the importance of each type of test in providing confidence that the software works as intended. [21:26] Andrew notes that full system tests can provide strong confidence by exercising critical pathways in the application. [29:44] Andrew mentions that tools like Octopus Deploy can be used to automate smoke tests as part of the deployment process. [30:26] Advice to new developers regarding automated testing, and the importance of writing code that is easy to test, and thinking about testing when writing code.   Mentioned in this Episode: Clear Measure Way Architect Forum Software Engineer Forum Andrew Lock "Andrew Lock: Containers in .NET8 - Ep 281" "Andrew Lock: Web Applications in .NET6 - Ep 198" "Updates to Docker images in .NET8"   Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

17 Nov 32min

Ben Day: SlideSpeaker.AI - Episode 375

Ben Day: SlideSpeaker.AI - Episode 375

Ben Day is a seasoned software consultant and fractional CTO. With over two decades of experience, he brings a blend of hands-on coding expertise, strategic clarity, and people-focused coaching to help companies — from startups to Fortune 500s — deliver high-quality software faster and with less friction.   As the founder of Benjamin Day Consulting, Inc., Ben offers training, coaching, and architectural guidance rooted in Agile, Scrum, Azure DevOps, and GitHub best practices. He's a Microsoft MVP, a certified Professional Scrum Trainer for over 15 years, and a sought-after speaker who favors storytelling over slide decks.   Topics of Discussion: [2:30] The overlap between music and coding, with Ben explaining the empathy required in both fields. [4:22] Jeffrey mentions the Sunday Sounds app, which allows users to create custom instruments using AI prompts. [6:45] The process of creating Slide Speaker and how Slide Speaker takes screenshots of each moment in a PowerPoint presentation and generates MP4 files. [13:01] Technical details of SlideSpeaker. [16:18] Event-based scaling. [17:10] How SlideSpeaker can be used for internal training presentations and compliance-approved content. [26:06] The opportunity for even more voice models and the ability to create your own custom voice, accent, and tone. [28:11] Ben talks about creating videos that help absolute beginners grasp C#. [32:45] What's next for Ben and Slidespeaker?   Mentioned in this Episode: Clear Measure Way Architect Forum Software Engineer Forum Benjamin Day Consulting Benjamin Day LinkedIn Benjamin Day YouTube SlidespeakerAI     Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

10 Nov 36min

Populärt inom Politik & nyheter

svenska-fall
motiv
p3-krim
spar
aftonbladet-krim
rss-krimstad
rss-viva-fotboll
politiken
rss-krimreportrarna
blenda-2
flashback-forever
rss-sanning-konsekvens
fordomspodden
rss-frandfors-horna
rss-svalan-krim
grans
olyckan-inifran
svd-dagens-story
rss-vad-fan-hande
rss-flodet