Identify the port that sql server is running on

~ chriseyre2000 ~ Leave a comment

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

~ chriseyre2000 ~ Leave a comment

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

~ chriseyre2000 ~ Leave a comment

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.

Rhino ETL Sample

~ chriseyre2000 ~ Leave a comment

Here is a quick sample that shows how to get rhino etl working.
It moves data from one database into another without any of the complex transforms.

Rhino.Etl.Cmd -c:database.config -f:CopyUser.boo -p CopyUser

=== database.config === Need to replace the [ with the expected angle brackets.

[configuration]
[connectionStrings]
[add name=”source” connectionString=”Data Source=DATABASE_SERVER1;Initial Catalog=databaseName;User=username;Password=password;” providerName=”System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″ /]
[add name=”target” connectionString=”Data Source=DATABASE_SERVER2;Initial Catalog=databaseName2;User=username;Password=password;” providerName=”System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″ /] [/connectionStrings]

[/configuration]

=== CopyUser.boo === Need to replace [TAB] with tabs

process CopyUser:
[TAB]input “source”, Command = “SELECT strUserID, strParamGroup, strName, strValue from tblParameter where strUserID = ‘FRED'”
[TAB]output “target”, Command = “””
INSERT INTO tblParameter (strUserID, strParamGroup, strName, strValue)
VALUES (‘JOE’, @strParamGroup, @strName, @strValue)
“””

Remember that boo is a tab sensitive.