SQL Server 2005 Remote Access Security
I went into this in my post about SQL Server remote connections, but basically, for each SQL Server instance running on your database server, you can enable remote access, control which […]
Continue ReadingConnecting Remotely to SQL Server Express
By default, remote connections are disabled for all versions of SQL Server 2005, including SQL Server 2005 Express. If you try to connect from a different machine, you’ll get an […]
Continue ReadingValidating Sizes of Uploaded Images in ASP.NET
I wanted to share a quick & easy way to validate uploaded images in ASP.NET. One of my projects has a feature allowing users to upload a logo. But I […]
Continue ReadingSQL Server 2005 Full Text Search on HTML documents
SQL Server has a decent full text search engine (IMO), but if you have HTML data in your database, it can be tricky searching on it. For example, if users […]
Continue ReadingSending multipart MIME emails using .NET 1.1
If this were an ordinary post I’d show you a bunch of code illustrating how to send multipart MIME emails using .NET. But yesterday I ran across DotNetOpenMail, an open-source […]
Continue ReadingSome issues running ASP.NET 1.1 on Windows 2003
Had a few issues running a 1.1 site on Windows 2003. Things I did to resolve the issues: Made sure v1.1 was selected in the ASP.NET tab in IIS Manager […]
Continue ReadingWeighted Columns in SQL Server 2005 Full Text Search
So I was having a little trouble getting full text search to work with the GUI in SQL Server Express with Advanced Services (formerly SQL Server 2005 Express SP1), so […]
Continue Reading
