When SQL Server 2008 shipped, Visual Studio 2008 SP1 and .NET 3.5 SP1 shipped a few days later. Visual Studio SP1 contains some neat enhancements that allow you to use SQL Server 2008 databases in Server Explorer and the related designers. There's support for SQL Server change tracking in the Sync Services designer. The EDM and LINQ […]
Bob Beauchemin
SQL Server Blog
Visual Studio 2008 SP1 and SQL Server 2008 SQLCLR features
Posted on: August 31, 2008 10:57 am
A GUI visualizer/editor for SQL Server 2008 Extended Events
Posted on: August 31, 2008 9:29 am
One of my favorite new features of SQL Server 2008 is extended events. I've written a bunch of blog entries on 'em (use the search, type in Extended Events). So a few days ago, I recieved an email from Jonathan Kehayias directing me to his new program on Codeplex, the SQL 2008 Extended Events Manager, […]
A helper function for ring-orientation in the SQL Server 2008 geography data type
Posted on: August 21, 2008 5:25 am
Folks have always had trouble with the fact that ring orientation is required with spatial instances if you're using SQL Server 2008's geography data type, but not with the geometry data type. For an explanation of the need for this, reference Isaac Kunen's blog entry here and Ed Katibah's blog entry (link in next paragraph). In Ed's […]
Semantic (possibly breaking) change in SQLCLR TVFs
Posted on: August 21, 2008 4:54 am
I came across the following interesting behavior while testing a SQLCLR table-valued function that did work in SQL Server 2005 SP2 but doesn't work at all in SQL Server 2008. It appears to be by design, because the error message (in 2008) clearly indicates what's wrong. But the code worked in SQL Server 2005 and […]
