memcached for caching query results (and other stuff) in memory
I was using Kayak today and noticed they had a link about their technology. One thing I noticed was that they use Ruby, which I’ve been reading about more lately, […]
Continue ReadingChange Stored Procedure Ownership in SQL Server
I was restoring a database backup on my new project when I noticed that some of the stored procedures where owned by a specific user instead of ‘dbo.’ That’s a […]
Continue ReadingShow sizes of all tables in SQL Server
In one of my projects, the client is concerned about the size of the database. He wants to save money on hosting, so I was going to poke around & […]
Continue ReadingMySQL Data Imports with C#
One of my current projects involves creating a data warehouse from multiple datafeeds. For cost reasons we’re going with MySQL Community Edition, but we’re sticking with ASP.NET, C#, and Windows on […]
Continue ReadingSQL Server 2005 Import and Export Wizard
The released version of SQL Server 2005 is missing the Import/Export Wizard that was available during beta. Now Microsoft wants you to practice using the Business Intelligence Development Studio to […]
Continue Reading
