Connecting 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 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 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 ReadingKilling All Users in a SQL Server Database
Saw this SQL Login Killer Script on SQL Server Central (yes I know it’s old, but it’s still good) … Handy when you need to kill everyone off in order […]
Continue ReadingSQL Server 2005 Database Tuning Advisor
I’m currently working on a property tax consulting startup, and I was noticing that some queries were running slowly. I’m familiar with database indexing, but I wanted to see what […]
Continue ReadingSQL Server 2005 Backups from the Command Line
I was looking into ways to easily back up my local SQL Server database from the command line, and copy the resulting backup to my fileserver. That way I could […]
Continue ReadingLogging queries in MySQL
I was struggling for a while with how to get a profile of the queries being sent to MySQL. All my searches suggested running the debug version of MySQL, but […]
Continue Reading
