Welcome to Sign in | Join | Help

august 2009 - Posts

When I downloaded SQL Server 2008 R2 CTP2 last week, I went right by (for now) the cool Gemini features and even Multi Server Management and went straight for the new SSRS Map Control. After explaining the SQL Server 2008 spatial data types, the spatial Read More...
And a CTP is available now . I first heard of the .NET Complex Event Processing engine at this year's TechEd. Until lately, all we had to go on was Torsten Grabs' TechEd presentation and a whitepaper that gave a fairly high-level overview of its Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/08/18/passing-parameters-to-a-background-procedure/  I have posted previously an example how to invoke a procedure asynchronously using service Broker activation. Read More...
I was looking for information on a new SQL injection attack when I stumbled upon this very useful blog: http://s3cwatch.wordpress.com/ . It's worth a look from time to time, to get an idea of what attacks are going on in the wild. Read More...
I realized today that while I have discussed earlier object permissions , I have not gone into the details of object ownership. I want to cover the following here: ownership of objects, how it can be changed, and the relatively new permission CONTROL Read More...
I'm always thought that what makes or breaks any ORM layer for use in any but the simplest of applications is the underlying SQL code that's generated. In fact, I'm a proponent of using stored procedures with any ORM for best performance. Read More...
Today I posted the code to a projcect I've been working on, a library that creates KML documents from SQL Server 2008 geography instances or queries. It's called SQLServerToKML and is available on CodePlex here . There's no releases as such Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/08/05/asynchronous-procedure-execution/  Recently an user on StackOverflow raised the question Execute a stored procedure from a windows form asynchronously and Read More...
Last week, Microsoft released the MapPoint 2009 Add-In for SQL Server 2008 Spatial. You can get it here . This add in allows you to add layers to the map from queries against SQL Server spatial geography columns. It's more of an entry level mapping Read More...