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.