Just got word that my session for the PASS conference this Fall in Dallas was approved. The title is “15 must know points about SQL Server 2005 XML.” I'm hoping my DevelopMentor mentors Bob Beauchemin and Dan Sullivan will also be giving talks at the event.
Thanks to Microsoft's “Tech Expert” program, it looks like I'll be joining the fun at Tech Ed 2005!
I am very much looking forward to this event since last years TechEd was such a great watershed for me in terms of SQL Server 2005, Visual Studio 2005 and the like. It was also one of the first times I got to meet a lot of the members of the SQL Server Team from Microsoft face to face.
Do look for me to be hanging out in Cabanas and, of course, I'll be trying to post my session notes again.
And maybe I'll even find the Krispy Kremes this year.
Unless you've been living under a rock, by now you know that with the latest Community Technical Preview of SQL Server 2005, System.Data.SqlServer has been removed. No sense in crying over spilled milk, but you might find yourself facing a new compile error. Let's see if I can't help.
Suppose that in the past, you've written some code like this:
using System.Data.SqlServer;
public partial class example
{
[SqlFunction(IsDeterministic = false, IsPrecise = true)]
public static SqlByte SomeFuction(SqlDateTime SomeDate)
...
So, naturally, you remove that using since the namespace no longer exists, but now the compiler complains that it doesn't know what the SqlFunction attribute is and suggests that you are missing a namespace. But which one? Turns out that it isn't defined in System.Data.SqlClient, but rather, its been migrated to Microsoft.SqlServer.Server. You'll need to use that namespace and make sure that the attribute references that namespace directly. The corrected code should look something like this:
using Server=Microsoft.SqlServer.Server;
public partial class example
{
[Server.SqlFunction(IsDeterministic = false, IsPrecise = true)]
public static SqlByte SomeFuction(SqlDateTime SomeDate)
Ah, the joys of living the Beta Lifestyle...