Yesterday I was mulling over the SQL Server tweets and read one by Michelle Ufford (aka SqlFool). She was answering another developer's questions about the use of Common Table Expression in which she asked if it was possible to have multiple CTEs in a single query. Yes and No. No in the sense that you cannot nest CTEs. That is, a CTE cannot be ...

When I first heard about Twitter, I thought, ''ooh, there's another great fad that will die out in a couple of weeks.''  I was mainly turned off because it just seemed like sending SMS messages to your entire address book.  Then when I attended PASS late last year, I came to grips with what it really is to me now: a simple and extremely ...

Chris Shaw posted a new SQL Quiz where he asks: ''What are the largest challenges that you have faced in your career and how did you overcome those?'' Denny Cherry (@mrdenny on twitter)tagged me so here is my story: The biggest problem I had was when a developer I worked with went on vacation, it was agreed upon by us and the client that ...

A few days ago via Twitter (http://www.twitter.com/, follow me as ktegels), Mr. Lowe (AKA Vendoran) asked ''SQL Express with Advanced services comes with SSRS, but does it come with the ability to create/edit rdl in VS?'' The short answer to that question is ''it depends.'' In most of the pay-for-license editions of Visual Studio you can use the ...