SqlServer2005: Move From TSQL To SQLCLR And Save Your Project
June 24, 2008
Many organisations have lots of business rules in TSQL stored procedures.
You’re right, that’s crazy but that’s what we see all the time, and our current project in Sydney, Australia using the Eagle PACE product is no different. Eagle PACE is an Opertaional Data Store for the financial services industry, in our case the Funds Management sector. At it’s heart is an enterprise database with a relational data model appropriate to the industry, and is surrounded by data feed mechanisms which in basic terms are a series of Stored Procedures.
Whilst a TSQL stored procedure is good for simple logic, eg stringing together a couple of selects and inserts, it is simply not up to the task of handling complex business rules and workflow.
I would say that a TSQL stored proc of more than 200 lines is just to complex to debug, enhance and test.
TSQL falls short in the following areas:
1) Code reuse.
There isn’t any.
No classes, no rowtypes, no inheritance of stored procs or functions.
No way to encapsulate functionality - the only way is, that’s right, you have to write another stored proc and have nested calls - yuk!
Absolutely awesome when you have 133 parameters to pass around.
[Dont laugh - we have this many parameters and more in the stored proc interfaces we have to maintain] Read more
My cool new box
June 18, 2008
I’ve recently upgraded my main box to this quad core 8G ram triple raid 0 hd bling beauty.
It features a 36cm side fan that pumps in heaps of air to keep temperatures to around 40C.
It’s suprisingly quiet too, as the video card and power supply are fanless.
But cool hardware is useless without an awesome operating system. My OS of choice is 64bit Debian GNU/Linux Lenny - it’s super easy to install, has the best package management out there [apt], and IMHO is the real developers’ Linux distribution [ok with the possible exception of Gentoo which is sooo awesome I must admit]. Windoze development I do in developer image vm’s powered by vmware and kvm. [Other posts on this blog will discuss developer vm's].
The screenshot shows my compiz-fusion 3D OpenGL desktop, with digital tv playing on the left and a Martika video playing on the right face of the 5-workspace cube. Also note the sharks and dolphins swimming in the center of the cube.
The solution to sibling rivalry!
June 15, 2008
This certainly isn’t the first time anyone has mounted a video camera to an RC car and taken it for a spin, but the new system from Fat Shark to do so is certainly the most comprehensive yet. A set of wireless VR goggles provide the display, and there’s a built-in accelerometer in the goggles to control the tilt and pan of the camera installed on the car. You can buy the system with the car, or purchase the components separately to hook onto a plane or for some other nefarious purpose. No word on price, but we would’ve traded our NES and two good tubs of Legos for a shot at this growing up. Somebody has to keep that up-to-no-good sister of ours and her dastardly playmates in check. Video is after the break.
Bluetooth Laser Virtual Keyboard
June 12, 2008
One of my favorite sites to browse around is http://www.thinkgeek.com . They have lots of cool stuff like wifi detecting t-shirts. As all geeks I like to have a computer at the breakfast bar while I eat my cereal but space is at a bit of a premium and kids love to use keyboards as cricket bats. I am going to try one of these bluetooth keyboards. A great way to impress the non-geek world out there at only $159 USD.
http://www.thinkgeek.com/gadgets/cellphone/8193/
goosh - Google shell command line
June 3, 2008
Real programmers use the command line.
Now Google has a command line interface in beta.
If you are comfortable on the command line, then this is for you.
