Welcome to MSDN Blogs Sign in | Join | Help

March 2005 - Posts

Interested in migrating from Oracle/DB2 to SQL Server - check out the beta...

9 years back I joined Microsoft to get ISVs to stop building Oracle solutions and to instead build SQL Server solutions. What would have helped my job immensely would have been a migration tool. Hey presto - 9 years on and we have such a tool. SQL Server
Posted by ericnel | 2 Comments
Filed under: ,

Debugging CLR Stored Procedures in SQL Server 2005 - don't forget the pdbs!

A year back I catalogued all my C# stored procedures into SQL Server 2005 by hand. A year on and I have become lazy - relying on the tight integration between VS.NET 2005 Beta 1 and SQL Server 2005 Beta 2 to simply publish the C# code into the database.
Posted by ericnel | 4 Comments
Filed under:

When to use SQL Server 2005 inbuilt Web Services?

SQL Server 2005 allows stored procedures and functions to be exposed as web services direct from the database without any need to be running IIS. To do this, SQL must be installed on Windows Server 2003 to take advantage of the kernel mode http.sys. (Hmmmmm
Posted by ericnel | 0 Comments
Filed under: ,

Simple example of System.Transaction code from ADO.NET 2.0 to SQL Server 2005

The namespace System.Transaction is new in the .NET Framework 2.0. It is the next step in the journey which took us from MTS to COM+ to Enterprise Services. It is a very simple, comprehensive way of working with transactions. At its heart it understands

Ever wanted more detail on how SQL Server 2005 hosts the CLR?

A new book just came across my desk "Customizing the Microsoft .NET Framework Common Language Runtime". This is a book that delves into details most of us will never need to know - but for some (e.g. certain types of ISVs) understanding in detail how

SQL Server 2005 Service Broker - simplest Hello World sample I could come up with!

Next week I am talking to a few of our early adopters about Service Broker - a great piece of technology that we introduce in SQL Server 2005 for asynchronous messaging. I like to start to learn a new technology by finding the simplest example that works.
Posted by ericnel | 0 Comments
Filed under: ,

February CTP of SQL Server 2005 is available for download - including Report Builder

Hi all, we have a shiny new CTP build of SQL Server 2005 available for download. And yes - it has Report Builder in it. Should be available to betaplace users and MSDN subscribers (not checked yet and time for home - but should be there!) - so nip over
Posted by ericnel | 0 Comments
Filed under: ,

Dog fooding SQL Server 2005 and VS.NET 2005

My work with SQL Server 2005 early adopters in the UK is broadly split into two - 50% of my time spent around technology and 50% of my time spent around program management. The latter should really take a lot less time - but one of the challenges we have

SQL Server 2005 Training available now in the UK

I just noticed one of our training partners which I hear good things about is offering SQL Server 2005 Training which is good news for the many folks active on Beta 2. http://www.parity.net/Training/Courses/Outline/Detail.asp?Course=MS2733 3 days on updating
Posted by ericnel | 0 Comments
Filed under: , ,
 
Page view tracker