Geek Culture
Published in

Geek Culture

Save large binary data effectively into your SQL Server

In SQL Server many developers stores binary file data such as audio, video, or simple images. They have one in common, they will use the blob data (varbinary) to store those kinds of data. The problem with this is, that you are limited to 2GB at this. It also slows down the database performance or maybe of your complete database system.

Filestream to the rescue

--

--

--

A new tech publication by Start it up (https://medium.com/swlh).

Recommended from Medium

Initializing Ads on the Main Menu

Scaling Postgres at Affinity with Citus

OpenShift from Pilot to Production, Part 1: Connectivity and Network Policy in the Hybrid…

Installing Docker: Diving into Docker — Part 3

Decoupled Drupal Is a Great CMS for Ecosystem Projects

ELI5: uint256 in Solidity

DevOps is about Anti-fragility not only about OPS

FORM CUSTOM WORDING

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Sascha Peter Bajonczak

Sascha Peter Bajonczak

Father, Developer,IOT passionist and urban beekeper 🍯🐝

More from Medium

Locating gaps in enumerated rows using the SQL lag window function (MySQL edition)

Quick Git Helps — Basic Commands Refresher

ER Diagram to Create Database Schema Made Simple: What You Need to Know

MySQL WHERE Clause Equality Comparison Operator