Welcome to Romanian SQL Server User Group Sign in | Join | Help

august 2009 - Posts

How's about a map on your SSRS report?

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...
Posted 21 august 2009 10:53 from Bob Beauchemin's Blog | (Comments Off)

Microsoft Complex Event Processing platform is called StreamInsight

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...
Posted 21 august 2009 08:45 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Passing Parameters to a Background Procedure

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...
Posted 18 august 2009 21:21 from rusanu.com | (Comments Off)

SQL Injection watch blog

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...
Posted 15 august 2009 00:34 from Laurentiu Cristofor's blog @microsoft.com | (Comments Off)

Basic SQL Server Security concepts: ownership, CONTROL, TAKE OWNERSHIP

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...
Posted 12 august 2009 01:39 from Laurentiu Cristofor's blog @microsoft.com | (Comments Off)

Upcoming improvements in EDM T-SQL code generation

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...
Posted 7 august 2009 11:53 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Make KML documents from SQL Server's geography data type

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...
Posted 7 august 2009 08:39 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Asynchronous procedure execution

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...
Posted 5 august 2009 11:26 from rusanu.com | (Comments Off)

MapPoint Add-In For SQL Server Spatial shipped

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...
Posted 3 august 2009 08:34 from Bob Beauchemin's Blog | (Comments Off)
Filed under: