This is a library of remote registry utilities for powershell.
Author: chriseyre2000
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.
Example DSL : Horn
This is a .net package management and installation tool.
This allows dependencies between projects to be explicitly stated (which makes installation much easier).
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.
Minor Flaw in VS2010
When you upgrade a solution to VS2010 it has the nasty trick of upgrading all test projects to .Net 4.0
This has the minor side effect of breaking builds in most older projects. The following links describe the problem and the manual workaround.
PerfectStorm Is Moving
Perfect Storm is moving from codeplex.com/PerfectStorm
to
https://bitbucket.org/chriseyre2000/perfectstorm/wiki/Home
please bear with me while the code is moved.
Simple State Machine
Here is a simple state machine project.
It has a dsl for it’s configuration.
Building a MMC Snapin in C#
Rhino ETL Sample
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.
Developer Rants 