March 2008 - Posts

• How To Use COALESCE And NULLIF To Prevent Updating Columns When A Parameter IS NULL Or A Default Value

  A variation of this question popped up twice in the SQL programming newsgroup since yesterday, this means it is time for a blogpost. Let's say you have a proc like this CREATE PROC prUpdateTable @Salesman int = - 1 AS .......... If the user calls the Read More... Posted Friday, March 28, 2008 11:43 AM by Denis Gobo | 4 Comments Filed under: Tips and Tricks

• Technet Radio: A Look Inside SQLCAT (SQL Customer Advisory Team)

  Channel9 has a podcast with the SQLCAT team. On this episode of TechNet Radio, We learn more about SQL CAT – the SQL Customer Advisory Team. With Launch of SQL 2008 on the way, the SQL CAT team has been working hard preparing lists of best practices, Read More... Posted Tuesday, March 25, 2008 5:04 PM by Denis Gobo | 0 Comments Filed under: podcast

• SOT: I found a new 'worst query'

  Before you ask, SOT means Slightly Off Topic :-()) Take a look at Hi, I need help on simplyfying this Update query! I don't even want to count the nested SELECTS, The query is 688 lines long, somehow schadenfreude enters my mind. Read More... Posted Thursday, March 20, 2008 4:31 PM by Denis Gobo | 4 Comments Filed under: Sad but true

• 6th Annual Financial Services Developer Conference

  I went to the 6th Annual Financial Services Developer Conference today in New York City. This year’s focus was on High Performance Computing (HPC). I must say that I have enjoyed this conference a lot. It seems that SQL Server is very prevalent on the Read More... Posted Wednesday, March 12, 2008 10:11 PM by Denis Gobo | 0 Comments Filed under: SQL Server 2008

• Video: SQL Server Data Services and the Future of Data in the Cloud

  Channel 9 has a 45 minute video with Dave Campbell about SQL Server Data Services. maybe this video will answer some of the question you might have about SQL Server Data Services Watch it here: http://channel9.msdn.com/ShowPost.aspx?PostID=388698#38869 Read More... Posted Friday, March 07, 2008 12:30 PM by Denis Gobo | 1 Comments Filed under: SSDS, SQL Server Data Services