Archive for February, 2012

Using SQL FileStream Types in your Databases

of the guide to SQL Server FileStream Types provided you with the steps necessary to enable SQL FileStream Types in your SQL Server instances.  In this Part 2 article I will explain how you setup a Database to use SQL FileStreams, how to create a Table with the FileStream Type attribute. And how to Insert and Select Filestream data…

Continue reading “Using SQL FileStream Types in your Databases” »

How to enable SQL FileStream Types

uploads in the traditional sense is all about uploading data files to the Server and keeping it there for downloading later on. If you are like me and have coded Web Applications with File uploading capabilities – then it’s most likely you have configured your Web application to accept and store these uploaded files in an ”upload’ folder on the server; while the relative path (or perhaps the full-path) to the file is stored as a field in the database.

This works fine… there are no major issues with this method at all.

In this article I will explain some alternative solutions to this method, and show how you can enable the use of SQL Server FileStreams in your applications…

Continue reading “How to enable SQL FileStream Types” »

How to avoid unnecessary MSDTC escalations

THE Microsoft Distributed Transaction Coordinator (MSDTC) is a pretty nifty tool in every Windows system. What this tool allows is that it enables applications to make use of Transactions (and all its glory) when communicating across distributed systems. MSDTC provides the same atomic properties of single a Transaction – but the overhead of maintaining Transactional atomicity across these distributed system is managed internally by the MSDTC.

But…There is always a ‘but’…

What if you are building a system that operates on one Server? Alot of small to medium sized applications would fall into this category. As an example: Consider one transactional system that spans across many Databases that lie on the same Database Server. Would you still need, or perhaps want, the MSDTC to handle your transactions?

In this article I will explain how certain situations may misuse MSDTC escalations, and how it is possible for you to avoid it…

Continue reading “How to avoid unnecessary MSDTC escalations” »

Copyright © Nullable Code. All rights reserved.