May 2007 Entries
So you have the need to let the user upload documents of any type to your server, but you don't know how to implement it. Some people say store them in the DB, others hate that and store the files on the file system. Which way do you go? Well, that depends on the requirements and the way the application is designed. I really try to stay away from storing binary content on the DB, but sometimes it is the best approach. On my case I didn't want a user accessing the file in any other way than through the...
The ntext, text, and image datatypes of SQL Server are going away on future version of SQL Server (Last version of SQL Server at the time of writing is SQL Server 2005). They are being replaced by nvarchar(max), varchar(max), and varbinary(max). So if you're like me and just found out about it, start using the new types!
Happy Programming!
One of my old co-workers created http://www.AgnosticGadgeteer.com. Below is a quote from the website explaining the reason for the site.
"I created this site because I was tired of hearing all the different factions talk about their own supremacy. This site hopes to serve as a guide, help document, point out differences, and objectively discuss the different types of gadgets and widgets available today as well as their development techniques."
There you can find blogs, forums, and articles regarding gadgets for Windows, Google, Apple, and NetVibes.
Hope you like it!
If you're trying to connect to a named instance database on the network (that is not locally) then by default you will get the error specified on the title. You can solve this in 2 ways:
1. Enabling the TCP/IP protocol on the server machine and specifying a static port and then creating an alias on the client machine (that is your local/development machine) and pointing to the same port.
2. If you don't have SQL Server installed on your dev/local machine then you can start the SQL Server Browser service on the server and enable the TCP/IP protocol and that will...
I needed to create a full-text index on a column, but I was unable to do so because of the following error: "Creation of the full-text index is not avaiable. Database is not enabled to allow for full-text indexing." After many hours of searching I found that Full-Text indexing is on by default. Well, not my case. I also found other suggestions of enabling them through the user interface, but I just couldn't find the option. After searching for a while, I found the query for enabling the feature:
EXEC sp_fulltext_database 'enable'
Of course you need to have the desired DB selected or...