Welcome to Sign in | Join | Help

mai 2009 - Posts

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 Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/05/29/lockres-collision-probability-magic-marker-16777215/  @jrowlandjones blogged about a dubious deadlock case. I recommend this article as is correct and presents Read More...
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 Read More...
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 Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/05/21/have-you-met-i%c2%bb%c2%bf-say-hello-to-my-bom/  I recently had to look at a problem where a programmer writing a tool to parse some XML produced by a service Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/05/18/stackoverflowcom-how-to-execute-well-on-a-good-idea/  Some time ago I started noticing on my google searches a newcomer: stackoverflow.com. At first I dismissed Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/05/16/readwrite-deadlock/  How does a simple SELECT deadlock with an UPDATE? Surprisingly, they can deadlock even on well tuned systems that does not do spurious Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/05/15/version-control-and-your-database/  I am still amazed when I walk into a development shop and I ask for their application database script and they offer Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/05/10/birds-of-a-feather-tweet-together/  @rusanu: I am on Twitter now. Yes, I am another victim of the totally connected social dragon. Since we’re on the Read More...
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 Read More...
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 Read More...
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. Read More...