If you absolutely must call a WCF service from inside your database, here’s how you do it…

When I was an operations DBA, this would probably fall into the category of “just because you can do something, doesn’t mean that you should”: Call a WCF Service from SQLCLR (by Niels Berglund) However, there are probably a couple of good scenarios where I might advocate for doing just this in future projects, especially…

3

Thanks, Brian! A couple minor nits to pick, though.

Brian, I’m glad y’all are doing videos like this for SQL School!! I realize that you probably recorded this last year; however, the details (specifically of download file selection on CodePlex) in that video about AdventureWorks for SQL Server 2008 have been out of date since October 2008. 😉 We shipped Samples Refresh 1 on…

1

SQL RSS code review coming up.

If you haven’t checked out this project, give it a look. We’re having an MVP code review in about a week. Forum discussion CodePlex project Please file your bugs and suggestions as work items on CodePlex. As always, if you’re interested in being a contributor to this project, let us know!

1

Samples forum consolidation.

Until today, all of the various SQL Server community and samples projects each had their own discussion board on CodePlex. In the interests of simplification that our customers have asked for in our samples experience, we’re consolidating all of those disparate discussion locations to one MSDN forum on the new forum platform. Microsoft SQL Server…

2

Sybase loves AdventureWorks2008?

A SQL Ranger friend of mine in the UK gave me the heads up to this yesterday. (Thanks, Ben!!) Apparently, back in December 2008, Sybase ported some of our samples to SQL Anywhere. Needless to say, I’ve got mixed feelings about Sybase porting AdventureWorks to their platform. Sort of like a cherry-cheese Danish: it’s a…

5

Now with more open and soon with more source!

Over the holidays, the SQL Server community & samples test team in China has been migrating all of our open product samples bugs out of our internal VSTS bug tracking database and into the VSTS database which backs the CodePlex TFS system. There are some non-bug work items which will be migrated (mostly related to…

1

AdventureWorks2010, anyone?

We’re doing planning work for SQL Server Kilimanjaro and the next SQL Server wave that follows it, which means product samples, community projects and AdventureWorks. Some people have suggested doing away with AdventureWorks in favor of something new, but I don’t see that happening… unless there is an enormous groundswell from the community on the…

4

Simplifying AdventureWorks setup

FYI, we’re actively working on improving the setup experience for the SQL Server 2008 sample databases (aka AdventureWorks). We’ve heard your feedback and we’re acting on it. Here are some of the salient points you’ll see for the Halloween update (Samples Refresh 1): Fewer selections to make to choose the appropriate download. All the AdventureWorks…

1

More AdventureWorks in the blogosphere…

Thanks for the plug, Stuart! Installing the AdventureWorks Sample Databases (Stuart Cox’s Tech Punch) We’re working on simplifying the setup experience for AdventureWorks in time for Halloween, but we appreciate the assist!

1

SQL Server Samples in the News and Print

The humorous old adage (which my friends in PR righteously deplore) is that "There’s no such thing as bad press, as long as they spell your name right." SQL Server 2008: First Impressions Desperately Seeking Samples SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach (Recipes: a Problem-Solution Approach) You be the judge. Which reminds me…

1