Geekdojo

T-SQL provides functions for determining the greatest and the lowest values in a column of data using the MAX() and MIN() aggregate functions respectively. The functions only work with one variable and may require the use of the GROUP BY clause if other...

The Damerau–Levenshtein distance or the “edit distance” between two strings can be used in SQL Server database applications to search for strings when you’ve reached the limit with the LIKE clause or the full-text indexing features. Used directly in T-SQL,...

I recently stumbled upon this cool online toy by Jonathan Feinberg from the IBM Research Visual Communication Lab. It is called WORDLE, uses JQuery and generates "word clouds" from a bunch of text or any URL with an RSS feed. It is a tagging engine and...

SQL Server allows us to decide whether query objects we create referencing tables can be tightly or loosely bound to the table structure. When you create a view or stored procedure you can specify the WITH SCHEMABINDING option to indicate that the view...

I have started blogging once again.... However, I have moved my blog to my own server and changed over to the WordPress bloging engine.  You can find my new blog @ http://ray.jez.net/...

go and get it off your MSDN....

In SQL Server 2005, if you create a view utilizing the TOP (100) PERCENT and ORDER BY clauses, you will not get back your results in the order specified. Example: USE AdventureWorksGOCREATE VIEW CustomersOrderedbyTerritoryASSELECT TOP(100) PERCENT *...

A substantial part of my development career was spent on the assembly line churning out code based on someone else specifications. There was always somebody else to handle the financial, administrative, marketing and sales aspects of  the whole manufacturing...

The rumors are true... I'm running for President : ;-) ...

Do you routinely open new folders directly, either because you created one on your desktop, through a shortcut, or by using the new context menu in Visual Studio to explore the folders in your solution?...

I just gave this new search engine a try.  It's called  Cuil (pronounce "Cool")  and its the invention of former Google engineer Anna Patterson. Here's a pic:    ...

Please update your readers! Ryan Rinaldi: .NET development served with a slice of sarcasm. (RSS)  ...

Here's the link to the beta, go and get it: Microsoft .NET Framework 3.5 Service pack 1 Beta...

Like last year, I'm heading out to the MVP Summit in Redmond.  Here's some information on the event: The upcoming summit, April 14-17, will feature a keynote from Microsoft CEO Steve Ballmer and closing by Chief Software Architect Ray Ozzie, in...

When I said I wouldn't post here anymore.The truth is that my men-talhealth website is still a good idea but I don't have enough material to post there consistently. Also, I like writing tech stuff - I now just have a different agenda to before.That in...

I really like Extension methods... especially when you combine them with other good language bits to really make a difficult problem a lot easier.  I think invoking on Windows Forms applications is one of those problems that is elegantly solved by...

I'd like to coin a new word, genericization, mostly because it's fun to say, but it's hard not to go back and try and correct that red squiggly line. Anyway, I didn't really want to talk about new words and automatic spell-checking. What I really want...

"The God who gave us life, gave us liberty at the same time;the hand of force may destroy, but cannot disjoin them."- Thomas Jefferson...

My company Neudesic will once again be hosting NuCon, a deep dive conference into .Net 3.5 and Visual Studio 2008 including LINQ, ADO.Net 3.5, Silverlight and TFS. Microsoft's new IO model (Infrastructure Optimization) will also be covered in one of the...

Here's an absolutely fascinating article, by Noreen Kendle, regarding the philosophy of data. This is a must read for anyone who has to deal with data from a data warehousing perspective. Ms. Kendle tackles the philosophy of data from an oft neglected,...

Technically, I guess, this counts, since I do read it.... 01. One book that changed your lifeChanged my life? That's a tall order...Mere Christianity 02. One book that you’ve read more than onceThere are too many, but I'll go with this: Lord of the Rings...

then you're not a programmer with relatives... (from the Daily WTF): Best of the Sidebar- Could You Explain Programming Please...

"It should be your care, therefore, and mine, to elevate theminds of our children and exalt their courage; to accelerate andanimate their industry and activity; to excite in them an habitualcontempt of meanness, abhorrence of injustice and inhumanity,...

Once again, Batman as he ought to be......

A - Got a chance to play with HALO 3 in the lobby. Wow. Makes me want to get a box. 1 - WCF is the communication platform for Microsoft for the next 10 years at least (right out of the Microsoft mouth) That means that Remoting, ASMX, etc. are all legacy...