How to Save Files in SQL Server

In this episode we're putting files into SQL Server for storage and then retrieving them so we can use them later. File storage can sometimes be a challenge and it is often a better solution to store files in a database as opposed to alternate solutions that put them in a file directory with links stored as text in a database. Some environment just aren't conducive to file storage and in these environments, SQL Server varbinary field storage is really great. Let's check it out.
Block spammers from harassing your Remote Desktop, filling your Windows security logs with failed RDP attempts, and burning up your bandwidth with my BZ RDP Cloaker:
buy.billzone.c...
Check out my easy time entry system for your business:
system.billzon...
Join me on Patreon!
/ mackenziedataengineering
Check out some tech (and support my channel!):
www.amazon.ca/...
Want the code from this video?
mackenziemacken...
Interested in transforming your career or finding your next gig?
system.billzon...
Want my team to do a project for you? Let's get to it!
system.billzon...
Contact form you can find at www.mackenziema...
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksyne...
Got a RUclips Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy....
#dataengineering #visualbasic #sqlserver

[@iljak2914]

Thanks for great Video! One question: which language you are using for coding in visual studio: this is Visual Basic or this is ASP Language? Sorry, I am new in visual studio, thanks and regards

[@seanmackenziedataengineering]

This is just pure Visual Basic. It should be installed by default with Visual Studio - if not, just add the option that includes Windows Desktop development and I believe that will include .Net Framework and VB.

[@richp2894]

Great vid as always Sean. Any chance of explaining how this is different from 'BLOB' storage (it is different, right???) for the benefit of us noobies? This is such a foreign concept coming from years of Access db development! -Thanks.

[@seanmackenziedataengineering]

You bet! BLOB storage and the varbinary datatype in SQL Server both deal with storing binary data, but they serve different purposes and have distinct use cases. BLOB (Binary Large Object) storage, typically used in cloud services like Azure, is designed to store vast amounts of unstructured data, such as images, videos, and backups, providing scalability and ease of access over the internet. On the other hand, the varbinary datatype in SQL Server is used for storing binary data within a database table, allowing for easier integration with relational data but is limited by the maximum row size of SQL Server. While both can store similar types of data, BLOB storage is ideal for large, unstructured data requiring cloud accessibility, whereas varbinary is suited for structured data scenarios within a SQL Server database. The use-cases differ but it is all about storage, how fast you can do a lookup and retrieve data (varbinary) vs. ease of storage, integration, and maintenance (a lookup with a file system or blob etc).