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
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 ...
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/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
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
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
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
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
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
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
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
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
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/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
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
My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/Monad Beta 1 Released for Whidbey Beta 2
The new RSS feed is here
Wahoo!!!! Finally Monad is available for Whidbey Beta 2. For more info, see Lee’s post here.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/Monad Beta 1 Released for Whidbey Beta 2
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 Challange
The new RSS feed is here
[BrokerChallenge 0] SEND me a message:
Over the past week I have been planning to launch the first open to
public Service Broker. At the same time, my dev team was having a
discussion regarding how we can do something cool and interesting to
get the community involved in our product. So I decided to setup simple
services on my public Service Broker to let people tinker around with
it. This is the zeroth in a series of BrokerChalleges; zero since it
requires hardly any skill, just the motivation to play with cool
technology….
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/SQL Server 2005 Service Broker Challange
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 MSBUILD Tasks for Assembly Deployment to SQL Server 2005
The new RSS feed is here
I have updated my yukondeploy task application for the June CTP of SQL
Server. A couple of changes:
- ALTER ASSEMBLY is now fully implemented. In other words, you can change your
assembly, add methods etc. and instead of re-deploying the assembly you set the
Alterassembly property to true and the task will make sure that only new methods
etc are created. The SQL Server Project in Visual studio does not do this.
- In the documentation I have added instructions how to set up Visual Studio
so you can deploy assemblies etc. from inside of VS without having to shell out
to a command window.
For more info about what the task does, read the documentation in the docs
folder of the download. You can download it from here.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/New Release of MSBUILD Tasks for Assembly Deployment 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/Service Broker over Remote Instances
The new RSS feed is here
Lately there has been questions on some of the newsgroups and forums how
to set up SQL Server Service Broker to send messages between remote
instances. Quite a while back I created some scripts to accomplish
that, and I posted those scripts as answer to the questions.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/Service Broker over Remote Instances
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 Book
The new RSS feed is here
Who better to write a
book about SQL Server Service Broker than Mr. Service Broker himself, Roger Wolter. Roger is Group Program Manager at Microsoft for Service Broker, and what he doesn't know about SSB is not worth knowing. When the book is published, it'a a must read!
BTW, I first saw the blurb about the book on Rushi's blog. If you are into SSB you better subscribe to his blog.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/SQL Server 2005 Service Broker Book
