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.
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).
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
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.