Storing and searching for image files in SQL Server

by:
Roman Rehak

Learn about working with image files in SQL Server, including advice on using queries to locate them, in this expert answer.

Step 2 of 2:

By submitting your personal information, you agree to receive emails regarding relevant products and special offers from TechTarget and its partners. You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.

Safe Harbor

I would like to know how to store image files in SQL Server. Also, how would I match these image objects in SQL queries and find results?

For a complete answer, consult this expert advice that covers images on a SQL Server.

This was first published in October 2008

Dig deeper on SQL Server Backup and Recovery

All
News
Get Started
Evaluate
Manage
Problem Solve

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

E-Handbook

Pricing out the new Windows Azure SQL Database
E-Handbook

Developments in SQL Server BI point to focus on self-service, users

Related Q&A; from Roman Rehak, Contributor

Tips for tuning SQL Server 2005 to improve reporting performance

There are a few things you can do to tune SQL Server for improved reporting performance. Here are some generic and Reporting Services-specific ...continue reading

Licensing a standby server for SQL Server replication

Is a license needed for a standby server if it's used for SQL Server replication? Get that answer and a comparison of SQL Server log shipping to ...continue reading

Manipulate column names in a SQL Server table

Learn SQL Server commands to manipulate column names in a table and turn column names into variables or rename SQL columns.continue reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

Discover the steps needed to reach successful cloud BI

As company data and processes are moved to the cloud, it makes sense for organizations to begin using cloud BI and analytics ...

Location analytics helps shipping company map out business route

GIS data analyst Andy Cain always knew location analytics could help develop deep business insights. Now he has the opportunity ...

Cloud BI tools, hosted systems lower data analysis barriers

Cloud business intelligence platforms offer companies a faster, easier way to analyze data, thanks to reduced capital costs and ...

SearchDataCenter

Outsource IT support without losing control

Secure a highly available IT platform by ensuring you have the best data center support. Without precautions, you may suffer from...

The new face of scale-out storage

There are plenty of new approaches to address ever-growing data needs, including scale-out vs. scale-up designs, the shift ...

Process real-time data analytics options

Now is the time to process all that enterprise data. With the need for speed and agility, here are some options to process your ...

SearchDataManagement

It's back to the future for machine learning applications of big data

Machine learning techniques are far from new. What is new, however, is the number of parallelized data processing platforms ...

MapR Hadoop update plies data center waters; Azure learns new tricks

Hadoop vendor MapR's latest release puts the focus on database replication across data centers. Also, Microsoft has built a ...

Ferment accompanies new Hadoop ecosystem initiative

The Open Data Platform has arrived, but not all Hadoop vendors are on board. The initiative, aimed at boosting interoperability, ...

SearchAWS

AWS urged to follow Azure on cloud data privacy

As AWS expands into apps such as email, experts say it should strengthen its data privacy credentials by following the controls ...

AWS CloudFormation and OpsWorks -- Better together?

CloudFormation and OpsWorks seem similar but have different advantages and use cases. Which tool to choose depends on development...

AWS analytics buy sets stage for next wave of data processing

Processing data from sensors attached to mobile devices and other objects will become a hot commodity in the next three to five ...

SearchOracle

Oracle touts new switches, servers at Mobile World Congress 2015

Oracle highlighted several new systems and networking products, including the ES2-72 and ES2-64 switches, at the Mobile World ...

Oracle sues top campaign aides over Cover Oregon failure

Oracle and Oregon start another round of lawsuits about Cover Oregon, with Oracle alleging that Cover Oregon failed as a campaign...

New president brings global change management skills to OAUG

The 2015 OAUG president, Melissa English, found a love of education in teaching her peers. Now she brings global change ...

SearchContentManagement

The Clinton email brouhaha and information governance

Hillary Clinton's use of a personal email account raises information governance issues that need to be addressed.

Can SharePoint eDiscovery Center meet your company's legal needs?

SharePoint provides useful native e-discovery capabilities, but they might not be adequate for companies dealing with complex ...

Website upgrades lay groundwork for customer experience strategy

For companies trying to step into the modern era with Web presence, WCM software investments are only the first step.

SearchWindowsServer

Prepare for these five Windows administrator interview questions

Windows administrator interview candidates need careful preparation to stand out among a crowded field of professionals.

A look at Windows MultiPoint Services role

A Windows MultiPoint Server allows users to have their own sessions while connected to one machine. Here's where it helps, and ...

A first look at the Network Controller role

The Network Controller permits physical and virtual network infrastructure management, as well as configuring and managing ...

Dig deeper on SQL Server Backup and Recovery

E-Handbook

E-Handbook

Related Q&A; from Roman Rehak, Contributor

Have a question for an expert?

0 comments

E-Mail

Username / Password

Password

Forgot Password?

Your password has been sent to: