Browse by Tags

All Tags » SQL (RSS)

SQL 2008 CLR Triggers, use a .NET class library in SQL using WPF by albertpascual

Since SQL 2005 you can add .NET dlls into the SQL Assemblies, therefore get called on triggers and event from SQL to do something. Those should be simple utilities as the installation is still quite painful. Now when you are trying to use WCF or WPF dlls...
Filed under: , ,

How to use the SQL 2008 Geometry. by albertpascual

Playing a little with SQL 2008 geometry I thought to post the queries that insert point, lines and polygons for the world to copy and paste if you like INSERT INTO [Test].[dbo].[GeometryTest]           ...
Filed under:

Moving Community Server to the Cloud by albertpascual

Next pet project is to move my blog on Community Server to the Cloud. I spend too long making sure my database size does not go over 500 MB, the size limit on my hoster. So once every 3 months I have to do some clean up of the database: DELETE FROM cs_statistics_Site...
More Posts