Storing Images and BLOB files in SQL Server
This article explores the data types and methods used for storing BLOBs (Binary Large Objects), such as images and sounds, inside SQL Server.
2008-01-24
4,577 reads
Additional Articles
The Data Stewardship Approach to Data Governance: Chapter 2
Data governance is NOT a methodology. Data governance is about authority and discipline over the management of data but not THE method in which the data is governed.
2008-01-24
1,323 reads
Controlling Information as a Strategic Enterprise Resource
Information governance is defined by Larry English as the act or process of leading, directing, controlling and assuring that information is managed effectively as an enterprise resource. (PDF download)
2008-01-23
1,140 reads
Featured Blog: SQL Server 2008: Spatial indexes
Paul Randal talks about the new spatial data types and their indexes.
2008-01-23
2,907 reads
Measure TSQL Statement Performance
Every developer needs to ensure that each TSQL statement is optimized. This article will give you a few different ideas on how to identify slow running queries and provide you with some tips on monitor your query performance while you make iterative changes to each query to try and improve performance.
2008-01-22
4,005 reads
Building Reliable, Asynchronous Database Applications Using Service Broker
Microsoft SQL Server 2005 Service Broker is a new platform for building distributed asynchronous database applications. Including an asynchronous, reliable messaging feature in the SQL Server database makes it possible to build a variety of database applications that were difficult, if not impossible, to build before.
2008-01-21
2,109 reads
New datetime datatypes in SQL Server 2008
Older versions of SQL Server had only one datatype to store both the date and time values. In SQL Server 2008, Microsoft introduces a set of new datatypes that store date and time individually, and both date and time together.
2008-01-21
3,175 reads
SQL Server 2005 Best Practices Analyzer (January 2008) -- Now Available!
An upgrade to the Best Practices Analyzer from Microsoft is now available. Here's a blog post from the SQL CAT team.
2008-01-21
3,617 reads
Accessing Data from a Mobile Application
Data access is an important aspect of developing applications with the Microsoft® .NET Compact Framework for Windows Mobile® devices. By using the existing architecture to send and receive data between your mobile application and your application server, you can pass data with either DataSets, custom objects, or scalar values.
2008-01-18
3,781 reads
CS TechCast 7: Super Sized SQL
A weekly show from a few SQL Server MVPs that looks at a variety of technology items. This episode concentrates on SQL server.
2008-01-18
1,542 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers