.net .net framework 4.0 ado.net android appengine applescript astoria beos bi c c# c++ clojure cloud clr cocoa touch concurrency couchdb cql curl data services database django dlr dynamic ef entity framework erlang exchange server full-text functional gnome go google gpu groovy haiku hpc html indexes io iphone ironpython ironruby java javascript jquery jruby jvm linq lisp lucene mac math mirah mongodb monitoring natural language nlp node.js object oriented objective-c operating systems oracle orm parallel performance podcasts powershell prototype python rails refactoring remoting reporting services ruby scripting security simpledb solr sql 2008 sql server ssrs systems programming testing tools vala vb virtualization vs 2010 web services webdav windows xml

SQL 2008's MERGE statement (Tuesday, April 22, 2008) - One of the coolest new features of SQL Server 2008 (and there are many) is the MERGE statement. This construct has existed in oracle and DB2 for a while now but it's new to SQL Server. Effectively it allows you to merge two tables together, combining UPDATE, INSERTS and DELETEs into one nifty package. For the purposes of demonstration I'm going to provide a simple

SQL 2008 filtered indexes (Wednesday, June 11, 2008) - there are so many cool new features available in sql server 2008 that many a DBA are excited. as an index-tuning man i've been intrigued by filtered indexes which essentially allow you to slap a WHERE clause on an index making it small and focused on a strategic subset of the tables data. you know, the sort of thing that would have required an indexed view in the past. in

SQL 2008 and powershell (Sunday, January 25, 2009) - with the 2008 releases from microsoft powershell is really making its way into the mainstream. sql server 2008 ships with standard powershell as well as an add-in that provides an interesting degree of integration that will allow DBAs to write scripts that are far more generalized than T-SQL scripts. getting ready to play with it is pretty strait forward. all you

SQL 2008 FILESTREAM (Saturday, August 04, 2007) - this post was written during the early release candidates and the actual implementation has changed slightly. your mileage may vary with this post. over the years people have attempted to put large amounts of non relational data in SQL. images strike me as the most popular case. generally people either stored the data directly in SQL or stored it on the filesystem

SQL 2008's table valued parameters (Sunday, May 11, 2008) - One of my favorite new features available in SQL 2008 is table valued parameters. For years SQL developers have been dying for this abilty and have been throwing some miserable duct tape at the problem. Before sql 2005 it was common to see strings being passed into stored procedures and then parsed into temporary tables. This approach suffered several major disadvantages