Yukon
Yukon
Back in December I released a new version of SqlClrProject, it was followed
by an update in January. After the update I received some functionality requests
- being able to define the names of the parameters that are being created. Some
times, the names you want to give to your procedure/function parameters may not
be valid .NET param names, so in those cases it can be useful to be able to
explicitly define the names.
Anyway, I have implemented that by defining a new custom attribute -
SqlParamFacetAttribute - which derives from SqlFacetAttribute. As this new
attribute is a custom attribute it has to be deployed to SqlServer in its own
dll. The deployment task is doing that automatically during deployment if the
attribute dll is not here already.
Here follows for you who don't know what the SqlClrProject is the marketing
blurb:
The SqlClrProject is a project type for Visual Studio 2005 for creation and
deployment of assemblies to SQL Server 2005. It consists of templates for both
Visual C# (C#) and Visual Basic (VB) with skeleton code for creation of CLR
methods to be used as stored procedures, User Defined Functions (UDF's),
triggers, User Defined Types (UDT's) and User Defined Aggregates (UDA's). Some
of the features are:
- Ability to deploy the assembly to SQL Server and create the SQL Server
methods, all from inside the Visual Studio IDE.
- Automatic creation of T-SQL deployment scripts.
- Automatic creation of T-SQL DML scripts for testing of the created
objects.
- Ability to alter an assembly and only deploy newly added methods from the
assembly.
- Ability to create objects in a non default schema
"schemaname.objectname".
- Debug facilities from inside VS.
For you who have used the SQL Server Project project type from VS to do
this, you may wonder what the differences are. Things that the SqlClrProject
allows you to do, which the VS SQL Server project can't do:
- Automatic creation of T-SQL deployment scripts.
- Automatic creation of T-SQL DML scripts for testing of the created
objects.
- Ability to alter an assembly and only deploy newly added methods from the
assembly.
- Ability to create objects in a non default schema
"schemaname.objectname".
You can download it from here [0].
After download, unzip the zip file and read the instructions for installation in
the README.txt file.
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/SQlClrProject - Visual Studio Project Type for SQL Server 2005
The new RSS feed is here
I have the pleasure to introduce the SqlClrProject project type.
The SqlClrProject is a project type for Visual Studio 2005 for creation and
deployment of assemblies to SQL Server 2005. It consists of templates for both
Visual C# (C#) and Visual Basic (VB) with skeleton code for creation of CLR
methods to be used as stored procedures, User Defined Functions (UDF’s),
triggers, User Defined Types (UDT’s) and User Defined Aggregates (UDA’s). Some
of the features are:
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/SQlClrProject - Visual Studio Project Type for SQL Server 2005
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/Provide Tom and Euan with Feed back for PDC
The new RSS feed is here
As he states in his blog entry, I convinced (ok, I begged) Euan Garden to partner with me and Matt Nunn on the Data and Systems track at PDC. So, now the hard work begins of coming up with the track abstract, working through the multitude of sessions (some new and interesting topics you will not want to miss about data in general) and the long meetings (blue bags or black bags, long-sleeved shirts or short-sleeve. . . ).
What would you like to see in the Data and Systems track at PDC? Of course, SQL Server will be there but is there other things you are interested in?
I'll be at TechEd so if any of you are there, stop by the SQL Server cabana and say hi. We have some interesting things to announce at TechEd this year so be sure to keep looking for that news when it hits.
Tom
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/Provide Tom and Euan with Feed back for PDC
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/Deployment of assemblies to Sql Server 2005
The new RSS feed is here
As I have blogged about before, I am not terribly pleased with the deployment mechanism of assemblies to SQL Server 2005 from the "SQL Server Project" project-type in Visual Studio 2005, and I created
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/Deployment of assemblies to Sql Server 2005
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/PDC 2005
The new RSS feed is here
No, not Primary Domain Controller, but Professional Developers Conference. On the MSDN Events site there is an announcement for PDC 2005. It's being held September 13 -16 in Los Angeles. Hopefully it will be as good at the last.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/PDC 2005
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/New SQL Blogger
The new RSS feed is here
We have a new SQL Server blogger. I had the pleasure of having Christian Wade as a student a couple of weeks ago at a
SQL Server 2005 class.It
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/New SQL Blogger
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/SqlDependency
The new RSS feed is here
In the Whidbey release of ADO.NET is the SqlDependency class. This class allows the user to set up a callback which is called when the underlying data changes. Bob wrote about it here.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/SqlDependency
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/Attributes in SQL Server 2005 and Visual Studio 2005
The new RSS feed is here
Recently there has been some discussions about SQL Server attributes in the beta newsgroups for SQL Server 2005 and VS 2005. Having tried to answer them, I thought it might be a good idea to write a blog entry about it as well.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/Attributes in SQL Server 2005 and Visual Studio 2005
Just back from New York. New York was hot and humid, here in London it is cool and rainy - as usual :-). I have just caught up on mail and blogs - I had worse than p**s poor Internet connection in New York, even though I stayed in a really nice and fairly new hotel; The Alex.
Anyway, a couple of noteworthy stuff:
- Bob has a blog entry about SqlDefinition and SqlExecutionContext. If you are doing data access using CLR code from inside SQL Server 2005, you should really use these classes and not only the SqlCommand.
- More from Bob, this time about the SqlPipe object.
- Dino Viehland from Microsoft has woken up again after a hiatus from blogging and has written some really good posts about hosting of the CLR. Especially interesting in you are into the hosting of CLR in SQL Server 2005 (a pet subject of mine).
Have Fun!!
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/Fun(?) with UDT's and Sql Server Management Studio
The new RSS feed is here
The following is something that has come up on a couple of the SQL Server 2005 beta news groups.
So, you have created a UDT and deployed it into SQL Server 2005. You have created a table with a column of the UDT type, and inserted some data. You're now testing it from SQL Server Management Studio (SSMS), and the chances are pretty big that you're running a query something like this:
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/Fun(?) with UDT's and Sql Server Management Studio
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/SQL Server 2005 Debugging
The new RSS feed is here
There has been quite a few discussion on some of the beta newsgroups about how to debug CLR methods, running in SQL Server 2005 (S2k5) as stored procedures, functions, etc. (actually there are some questions about how to debug T-SQL code as well). I thought therefore that it'd be a good blog post, discussing debugging.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/SQL Server 2005 Debugging
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/SQL Server 2005 Installation
The new RSS feed is here
So the party has begun - SQL Server 2005 is released, as many out in the blog-sphere has already reported. And Whidbey (excuse me Visual studio 2005) Beta 1 is also released.
You may notice that the CLR versions of VS and SQL2K5 are different. VS is 40607.16 whereas SQL2K5 is .42. This can have consequences when installing the stuff. To be on the safe side, install SQL2K5 first followed by VS. That way the latest CLR (.42) will be installed, which SQL2K5 requires, and VS will play just nicely with this build. If you however already have installed VS, then SQL will complain about not having the right CLR version. If this is the case, un-install the CLR and then install SQL, followed by VS.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/SQL Server 2005 Installation
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/Another one bites the dust (ObjectSpaces)
The new RSS feed is here
ObjectSpaces are delayed again. This time it is supposed to ne merged with WinFS (whenever WinFS is released). Well, I can't say i was surprised, there has been rumours going on about it for quite a while. It's s bummer that one chapter in the book is dedicated to something that won't see the light of the day for quite a while yet. I guess that's the "joy" of writing about beta technologies.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/Another one bites the dust (ObjectSpaces)
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/New Revision of the MSBuild Tasks for Yukon
The new RSS feed is here
A week ago I wrote about the new and enhanced task dll for deployment of CLR assemblies to Yukon. Even though it was fairly functional at that time, there were a couple of things in it (or rather not in it) which I didn't like.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/New Revision of the MSBuild Tasks for Yukon
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/New and enhanced MSBuild Deployment task for Yukon
The new RSS feed is here
In an earlier post I wrote how I had created a custom MSBuild task to deploy CLR assemblies to Yukon. It turned it was more useful than I first had thought (with automatic deployment in VS.NET and all). First, I do not always use VS.NET (Emacs is a great editor), and secondly even when I use VS.NET the deployment feature is a bit shakey.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/New and enhanced MSBuild Deployment task for Yukon
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/Public Whidbey Beta in June
The new RSS feed is here
Kent S reported how there are plans for a public Whidbey beta in June. As Whidbey is fairly closeley coupled to Yukon (or rather vice versa), I wonder if we may see something for Yukon as well in that timeframe. I guess we have to wait and see (pray).
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/Public Whidbey Beta in June
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/Yukon Article
The new RSS feed is here
It's been fairly quiet on the Yukon front in terms of newspaper articles later. Well, here's one that talks about Yukon in realtion toLonghorn and WinFS. Doesn't say much new however.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/Yukon Article
I am totally confused what time zone I'm in. On Thursday I flew from London to Seattle and landed in Seattle Thursday evening. My bodyclock told me it was early Friday morning (like 2 am or so). On Friday morning I flew from Seattle to Vancouver, and from Vancouver to Seoul, Korea. The total travel time was around 15 hours, but I landed in Seoul Saturday evening. Right now it is Monday midday here in Seoul, but I have no clue what it is, I am totally confused 
.
Anyway, I'm here teaching Yukon and I have a blast. Yesterday I spent trying to recover and also walking around the nearby the hotel. I have never been to Korea before, so it is an adventure for me.
The reason I flew to Seattle first was because I should have talked at the PASS conference there, but due to personal reasons I couldn't attend. I still had my tickets from Seattle to Seoul, so it turned out it was cheaper to change my London to Seattle tickets than to get new tickets London to Seoul.
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/Noteworthy Stuff
The new RSS feed is here
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/Fun with Yukon, Whidbey and MSBuild
The new RSS feed is here
I mentioned in an earlier post how I was playing along with Whidbey, Yukon and Emacs, using MSBuild as my command-line compiler. Even though there will without a doubt be a task in MSBuild for deploying assemblies into Yukon, I thought it'd be a good idea to create one myself just to see how it works.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/Fun with Yukon, Whidbey and MSBuild
