SQL Server 2008 FILESTREAM Best Practices
In SQL Server 2008 one can store BLOBs (e.g. Images, video, Word, Excel, PDF, MP3, etc) in the NTFS file system rather than in a database file. This... more »
Tweet 0 CommentsSave Tags: database, reviews
SSIS Package Stats Collector version 2
A few weeks ago I published a blog entitled Collecting information about your SSIS packages which demonstrated a way that you could use T-SQL and... more »
Tweet 0 CommentsSave Tags: database, frameworks, tools
SQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices
The data compression feature in SQL Server 2008 helps compress the data inside a database, and it can help reduce the size of the database. Apart from... more »
Tweet 0 CommentsSave Tags: database, trends
Using Memcache With PHP
I want to just start this little post with that fact that I don’t know all the ins and outs of using Memcache but I have enough knowledge to just... more »
Sproc Executing Slow? It Might be This
So you have stored procedure and it’s having issues. When you run it, it returns really fast. When .NET runs it, its like a dog. The first thing you... more »
Amazon RDS, MySQL, Hmm?
When a name like Amazon gets into the business, everyone acts like everything is new and shiny again :) Why, I can remember like it was, well...... more »
Tweet 0 CommentsSave Tags: announcement, database
How (and why) Sillicon Alley Insider uses MongoDB
MongoDB is an open-source, non-relational database that combines three key qualities: scalable, schemaless, and queryable. It has native drivers for... more »
Tweet 0 CommentsSave Tags: database
FULL TEXT Searching In MySQL
I’ve been wanting to add a search feature to wp-click-track for a while now. After almost a year of writing 150 posts I have a lot of links; so many... more »
Tweet 0 CommentsSave Tags: database, php
