Sunday, March 7, 2021

Podcast: SQL Server For Developers

I recently had the pleasure of being featured on Azure DevOps Podcast.  The host, Jeffery Palermo, interviewed me about a topic I’m passionate about “SQL Server For Developers”.  These are features available within SQL Server that make some specific development tasks easy to implement.  Some of these features include:

File Streams: “Pointers” that allow you to store a BLOB within the SQL Server File Groups and maintain security over it, not storing it in a DB and bloating the table size.

Temporal Tables: Tables that automatically maintain historical changes to every record with a time span of those changes.

FileTables: Tables that duplicate a structure of a specific folder, giving developers the ability to quickly query the files one they’re dropped in the folder.

 

I discuss these topics and more on the podcast.  For the full podcast, please visit http://azuredevopspodcast.clear-measure.com/sam-nasr-on-sql-server-for-developers-episode-122#

No comments:

Post a Comment