Windows/Mac/Linux: Doit.im is a free, attractive, cross-platform task management application built on the principles of productivity guru David Allen's Getting Things Done. It syncs to the web, it's...

Google Docs has officially thrown open their data doors, allowing users to back up all their documents to whatever formats they choose and compressed into a ZIP file. It's serious peace of mind for...

Move your mouse over a taskbar application in Windows 7, or over the outline button in the lower-right corner, and previews show up in half a second. Customize that wait time, or disable it entirely,...

Sibling site Gizmodo has already reported a tip that representatives from the New York Times and other publishers have met with Apple to discuss content delivery for a new device. In a talk last week...

I'm conducting a survey of the readers on the site. If you have a few moments I'd appreciate it if you could fill it out. It's only nine questions and will take just a few minutes. I'm trying to learn more about what topics are interesting to SQLTeam readers.

When you are learning something new, the first thing you should check out is its history. When you go through the history, you get a better perspective. It is the same with Ruby language and hence let us get a quick dose of Ruby history. Ruby programming language is created by a Japanese programmer, Yukihiro Matsumoto. [...

Learning Ruby is easy if you already know a programming language. But there are some ruby language features which can cause headache for a programmer migrating from C++ or Java. In this post, I will look at 10 interesting language features that are unique to Ruby. 1. Objects everywhere! – In Ruby everything is an object [...

In SQL Server 2005 and earlier, it is not possible to pass a table variable as a parameter to a stored procedure. When multiple rows of data to SQL Server need to send multiple rows of data to SQL Server, developers either had to send one row at a time or come up with other workarounds to meet requirements. While a VB.Net developer recently informed me that there is a SQLBulkCopy object available in .Net to send multiple rows of data to SQL Server at once, the data still can not be passed to a stored proc.

Cascading Updates and Deletes, introduced with SQL Server 2000, were such an important, crucial feature that it is hard to imagine providing referential integrity without them. One of the new features in SQL Server 2005 that hasn't gotten a lot of press from what I've read is the new options for the ON DELETE and ON UPDATE clauses: SET NULL and SET DEFAULT. Let's take a look!

I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fill out any missing data, please post in the comments and I'll update the article.