Identify the port that sql server is running on

Identify the port that SQL Server is running on:

DECLARE @tcp_port nvarchar(5)

EXEC xp_regread
@rootkey    =    ‘HKEY_LOCAL_MACHINE’,
@key        =    ‘SOFTWAREMICROSOFTMSSQLSERVERMSSQLSERVERSUPERSOCKETNETLIBTCP’,
@value_name    =    ‘TcpPort’,
@value        =    @tcp_port OUTPUT

select @tcp_port

Example DSL : Mite

This is an example dsl used to create database migration scripts in .Net.

Migrations are a common solution to the database upgrade problem used in the Ruby community.

The idea is that the migration file states the changes to the database so that they can be easily applied and rolled back.

This is far more flexible than a random set of scripts.

Various Rhino Projects

Ayende Raihen has started the following Rhino projects

  • Rhino-ESB – Enterprise Service Bus
  • Rhino-ETL – Extract Transform Load
  • Rhino-Licensing – Licensing
  • Rhino-Security – Security
  • Rhino-DSL – Domain Specific Language
  • Rhino-Queues – In memory minimal configuration message queue
  • Rhino-Mocks – Mocking framework
  • Rhino-PHT – Persistent Hash Table
  • Rhino-DHT – Distributed Hash Table

I have been looking at Rhino-ETL and Rhino-DSL lately and should have a look at the others.