http://www.tektag.com/ Recent bookmarks posted to TekTag 60 http://www.tektag.com/bookmark.php?bid=188731 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... jd42 Mon, 14 Jun 2010 08:41:08 +0000 http://www.tektag.com/bookmark.php?bid=188751 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... jd42 Mon, 14 Jun 2010 08:41:08 +0000 http://www.tektag.com/bookmark.php?bid=188752 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,... jd42 Mon, 14 Jun 2010 08:41:08 +0000 http://www.tektag.com/bookmark.php?bid=188753 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... jd42 Mon, 14 Jun 2010 08:41:08 +0000 http://www.tektag.com/bookmark.php?bid=188757 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. jd42 Mon, 14 Jun 2010 08:41:08 +0000 http://www.tektag.com/bookmark.php?bid=188766 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. [... jd42 Mon, 14 Jun 2010 08:41:08 +0000 http://www.tektag.com/bookmark.php?bid=188771 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 [... jd42 Mon, 14 Jun 2010 08:41:08 +0000 http://www.tektag.com/bookmark.php?bid=188774 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. jd42 Mon, 14 Jun 2010 08:41:08 +0000 http://www.tektag.com/bookmark.php?bid=188775 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! jd42 Mon, 14 Jun 2010 08:41:08 +0000 http://www.tektag.com/bookmark.php?bid=188776 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. jd42 Mon, 14 Jun 2010 08:41:08 +0000 http://www.tektag.com/bookmark.php?bid=188778 In my previous article Scheduling Jobs in SQL Server Express we saw how to make simple job scheduling in SQL Server 2005 Express work. We limited the scheduling to one time or daily repeats. Sometimes this isn't enough. In this article we'll take a look at how to make a scheduling solution based on Service Broker worthy of the SQL Server Agent itself. we saw how to make simple job scheduling in SQL Server 2005 Express work. We limited the scheduling to one time or daily repeats. Sometimes this isn't enough. In this article we'll take a look at how to make a scheduling solution based on Service Broker worthy of the SQL Server Agent itself. jd42 Mon, 14 Jun 2010 08:41:08 +0000 http://www.tektag.com/bookmark.php?bid=188779 SQL Server 2008 Extended Events are the new low level, high performance eventing system in SQL Server. They use less system resources and provide better tracking of SQL Server performance than previous methods like Perfmon and SQL Trace/Profiler events. jd42 Mon, 14 Jun 2010 08:41:08 +0000 http://www.tektag.com/bookmark.php?bid=188471 Ruby is used extensively in Web applications thanks to Ruby on Rails. But you can also develop Windows applications using Ruby. Interestingly the Windows API support is part of the standard installation (only on Microsoft Windows installations) and it is quite easy to use it! In order to use Windows API, you need to import “Win32API” [... jd42 Mon, 26 Oct 2009 17:05:32 +0000 http://www.tektag.com/bookmark.php?bid=188472 Note: This is a weekly round up of interesting stuff found on ruby-talk mailing list. You can subscribe to this list here. 1. Steven wondered whether it is necessary to clean up the string created from native C code(rb_str_new2) and passed to rb_funcall. Matz replied, You don’t have to (and you shouldn’t) free string objects. 2. Mohsin asked [... jd42 Mon, 26 Oct 2009 17:05:32 +0000 http://www.tektag.com/bookmark.php?bid=188476 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. [... jd42 Mon, 26 Oct 2009 17:05:32 +0000