Niels SQL Server Blog

Rebooting the Blog

nielsb — Mon, 21 Aug 2006 12:42:00 GMT

My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/Rebooting the Blog
The new RSS feed is here

I’ve been blogging on and off (mosly off) for a couple of years now, and blogging has been trying to quit smoking - but the opposite: you keep it up (blogging) for a while but then you fall back into the old habits (not blogging).

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/Rebooting the Blog

The Devil Wears Skates ...

nielsb — Sat, 13 May 2006 18:22:00 GMT

My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/The Devil Wears Skates ...
The new RSS feed is here

..... the hell has frozen over. What am I on about?

I wrote in my earlier post today that I was checking out a new blog client, and that the reason for it would become clear in a future post - well this is it. I have trough out my whole computing life been a Microsoft/Windows guy through and through. I started way back in the Windows 1.0 days and I have been faithful ever since.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/The Devil Wears Skates ...

New Release of SqlClrProject

nielsb — Tue, 07 Feb 2006 17:23:00 GMT

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.

Updated Version of SqlClrProject

nielsb — Tue, 10 Jan 2006 07:15:00 GMT

My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/Updated Version of SqlClrProject
The new RSS feed is here

Back in December (26:th to be exact) I released a new version of the SqlClrProject and wrote about it here [0].

One drawback of the deployment functionality was that you could only deploy locally as the deployment process used the CREATE ASSEMBLY based on the location of the assembly; i.e. CREATE ASSEMBLY myasm FROM 'path_to_dll'.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/Updated Version of SqlClrProject

SQL Server Service Broker Admin Tool for SQL Server 2005 RTM

nielsb — Tue, 27 Dec 2005 18:53:00 GMT

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 Service Broker Admin Tool for SQL Server 2005 RTM
The new RSS feed is here

Back in July I released the (then) latest version of SsbAdmin. For you who don'r know what it is; it's a tool which allows you to graphically administer SQL Server Service Broker.

I have now uploaded a new version which is compiled against the released versions of SQL Server 2005 and .NET 2.0.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/SQL Server Service Broker Admin Tool for SQL Server 2005 RTM

New release of SqlClrProject

nielsb — Mon, 26 Dec 2005 13:04:00 GMT

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 release of SqlClrProject
The new RSS feed is here

I thought I better post before this year ends. :-)

Anyway, you may know that I have developed a MSBUILD task dll for deployment of SQLCLR assemblies. I also created some templates for use from with Visual Studio 2005, the SQLCLRProject.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/New release of SqlClrProject

Test from Blogjet

nielsb — Thu, 04 Aug 2005 15:58:00 GMT

My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/Test from Blogjet
The new RSS feed is here

This is just a test

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/Test from Blogjet

SQLCLR and CAS in SQL Server 2005

nielsb — Sat, 30 Jul 2005 05:32:00 GMT

My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/SQLCLR and CAS in SQL Server 2005
The new RSS feed is here

By now, you who have created .NET assemblies for execution in SQL Server 2005, know about the three permission sets used when cataloguing an assembly:

SAFE
EXTERNAL_ACCESS
UNSAFE

So, for example, if you need to access things outside of the database you assign the permission set EXTERNAL_ACCESS to the assembly. But what about when you do not want to allow an assembly to everything that is possible for that particular permission set? You do not want the assembly for example to be able to do File IO, but it should be allowed to do external data access.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/SQLCLR and CAS in SQL Server 2005

SQL Server Service Broker Examples

nielsb — Sun, 17 Jul 2005 12:25:00 GMT

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 Service Broker Examples
The new RSS feed is here

Recently there has been questions on some of the newsgroups about examples for SQL Server Service Broker. So, yesterday on a flight back to England I crofted up three different SQL Server projects as examples:

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/SQL Server Service Broker Examples

New Release of SQL Server Service Broker Admin tool

nielsb — Wed, 13 Jul 2005 14:29:00 GMT

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 Release of SQL Server Service Broker Admin tool
The new RSS feed is here

Back in May I released the, then, latest version of SSB Admin; an administration tool for SQL Server Service Broker. Since then I have been travelling a lot (Portugal, Spain, India – to mention a few places) and not have had time to do much work with it. However, there has been some development and today I have uploaded a new version of SSB Admin. Some new stuff:

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/New Release of SQL Server Service Broker Admin tool

SQL Server 2005 Service Broker Challenge is Over

nielsb — Fri, 24 Jun 2005 08:41:00 GMT

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 Service Broker Challenge is Over
The new RSS feed is here

Solution to BrokerChallenge 0:

It has been a week since I posted BrokerChallenge 0 and I am quite happy to see several people successfully cracked it. Still others gave it a shot but were not completely successful. So I decided to post the solution to the challenge. You can get the sample T-SQL script from here and modify it to suit your hostname, port and database name…

[Via Write Ahead Blog]

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/SQL Server 2005 Service Broker Challenge is Over

SQL Server Engine Blog

nielsb — Thu, 23 Jun 2005 04:46:00 GMT

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 Engine Blog
The new RSS feed is here

Welcome !:

Welcome to the SQL Server Engine Tips blog - hosted by the engine program management team. The purpose of the blog is to share guidelines, best practices, tips and answer questions related to implementing and deploying solutions using SQL Server. We will cover topics related to the SQL Server Engine including new features in SQL Server 2005. We would love to get your feedback and suggestions for topics through the comments section.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/SQL Server Engine Blog

SQlClrProject - Visual Studio Project Type for SQL Server 2005

nielsb — Tue, 21 Jun 2005 14:10:00 GMT

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

SQL Server 2005 Service Broker Stuff in June CTP

nielsb — Sun, 19 Jun 2005 08:02:00 GMT

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 Service Broker Stuff in June CTP
The new RSS feed is here

As Bob is doing, whenever a new build is released I tend to check out various stuff to see if it works as before. This however jumped up and bit me the other day.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/SQL Server 2005 Service Broker Stuff in June CTP

Back from Spain

nielsb — Sun, 19 Jun 2005 07:39:00 GMT

My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/Back from Spain
The new RSS feed is here

I got back from a SQL Server 2005 gig in Spain late last night. I won’t be home for long though, later today I’m off again, this time to London for a SQL Server class and then at the end of next week I’m flying off to India.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/Back from Spain