SQL Server security best practice

Security! This is the word comes in mind of every concerned person when it come...

Change the Collation Settings in MS SQL Server

This post will show you how to change the collation settings in MS SQL Server for specific database...

Resolve collation conflict

In this post I will show you how you can resolve collation conflict error...

Book: SQL Server 2008 High Availability

In this book I have tried to cover every single piece of information that might requires for installing and configuring SQL Server HA option like Clustering, Replication, Log Shipping and Database Mirroring...

Why to recompile Stored Procedure

Generally, we create views and stored procedures (proc here after) ...

Showing posts with label paper. Show all posts
Showing posts with label paper. Show all posts

2/05/2007

SQL Server : TO Blob or Not

Hi All,

In many community forums i participated i found many users ask a querstion on BLOB datatype. That is "Is it okay if i do store binary files / images / documents store in SQL Server Database?" . The answer is no.....it is always good to store the location of the Binary Files or Documents Or Images and let it handled by Front End application. Here is a wonderfull research paper published on Microsoft Site http://research.microsoft.com/research/pubs/view.aspx?msr_tr_id=MSR-TR-2006-45


Regards
Hemantgiri S. Goswami
Microsoft SQL Server MVP
"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans"

Disclaimer: This postings is provided "AS IS"