About a month ago, I received a copy of "Beginning Spatial with SQL Server 2008" by Alastair Aitchison. I've become acquainted with Alastair through his frequent postings on the SQL Server Spatial forum (under the login Tanoshimi), where he's always been very helpful and patient with folks starting out with spatial data concepts and SQL […]
Bob Beauchemin
SQL Server Blog
Book review – Beginning Spatial with SQL Server 2008
Posted on: May 30, 2009 8:22 am
L2S and EF parameterization problem will be fixed in .NET 4.0 – completely
Posted on: May 26, 2009 10:56 am
For those of you who's blog readers don't always get updated (rather than brand new) blog entries, there's a happy ending to my last "fixed-almost" blog entry on EDM 4.0 and parameterization. I've heard that this has been fixed to generate VARCHAR(8000) parameters and also that the unparameterized version: var x = from a in ents.authors […]
L2S and EF parameterization problem fixed in .NET 4.0 – almost
Posted on: May 25, 2009 2:29 pm
One of the first things that I did after installing VS2010 beta this week was to check on a parameterization problem with string parameters, and Linq To SQL/ADO.NET Entity Framework generated code. In the original version, this L2S query: var x = from a in ents.authors where a.au_lname == "Smith" select new { […]
On SQL Server and .NET 4.0
Posted on: May 1, 2009 12:13 pm
I finally got around to install .NET 4.0 CTP today on a SQL Server box to test a long-held theory. Didn't quite work out the way I'd thought. When .NET support was introduced in SQL Server 2005, there was a lot of interest in how SQL Server and .NET Framework would approach the versioning story. […]
Talking about spatial data on RunAs Radio
Posted on: May 1, 2009 11:24 am
My interview with the folks at RunAs Radio is out. I'm discussing one of my favorite topics, spatial data and spatial in SQL Server 2008, with Richard and Greg. This wandered off into some interesting possible usages for this data. Catch it here.
Article about programming filestreams on MSDN
Posted on: May 1, 2009 11:20 am
My latest article on out. It's in the May issue of MSDN magazine, and can be found here. It this article I explore the internals of programming with the filestream feature of SQL Server 2008 and some best practices around when and how to use it. Hope you like it.
