MCTS SQL Server 2008 beta exam 71-432 taken

July 23, 2008 16:13 by Ryan Garaygay

I just got off from taking exam 71-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance - which will become 70-432 when it goes live and is the successor of 70-431 (for SQL 2005)and here are just a few thoughts More...

Digg It!DZone It!StumbleUponTechnoratiRedditDel.icio.usNewsVineFurlBlinkList

MCTS ASP.NET 3.5 Applications Passed

July 16, 2008 15:08 by Ryan Garaygay

Despite seeing my site being down due to "cannot connect to SQL server" error it was getting for some hours (courtesy of GoDaddy - again not recommended for production), I just received the good news today. I passed MCTS .NET Framework 3.5 - ASP.NET Applications More...

Digg It!DZone It!StumbleUponTechnoratiRedditDel.icio.usNewsVineFurlBlinkList

SubSonic and Club Starter Kit

July 14, 2008 07:53 by Ryan Garaygay

If you don't code generate your DAL or use OR/M or anything that would make you worry less about DataAccess like LINQtoSQL, Entity Framework, NHibernate, Castle ActiveRecord then you should definitely give SubSonic a shot.

On the side I'm currently working on a C# version of Extended Club Starter Kit Version 3 Beta 1 for one club that I was part of in college (and probably a few others) and one thing to note is that the project has opted to use SubSonic. It's an open source project developed by Rob Connery and a few other popular developers in the .NET. It simplifies generation of Data Access code and some utility functions common to development. And don't forget about the cool Scaffolding support. As I've heard this is one of the popular features of the Rails framework where pages are generated on the fly to serve as you're admin tool for add/edit operations against your database table. They could be considered your admin pages or at least help during development. Bottom line is, all these features will save your time (which is what SubSonic aims for). More...

Digg It!DZone It!StumbleUponTechnoratiRedditDel.icio.usNewsVineFurlBlinkList

Get Ancestor and Descendant IDs or info using SQL 2005 Common Table Expressions

July 12, 2008 03:53 by Ryan Garaygay

Need some recursive processing in TSQL (SQL Server 2005)?

Needed some TSQL code again to retrieve descendant and ancestor entries in a self-referencing table. I've done this a couple of times already and although I can write on top of my mind, sometimes you just want to make life easier and have a script you can just modify a bit to fit the new requirement. More...

Digg It!DZone It!StumbleUponTechnoratiRedditDel.icio.usNewsVineFurlBlinkList

Lost Internet Access due to ZoneAlarm and Microsoft Update KB951748

July 11, 2008 15:14 by Ryan Garaygay

I ran into this issue a while ago where I lost internet access connection after installing a windows update and turns out to be because of my ZoneAlarm installation. More...

Digg It!DZone It!StumbleUponTechnoratiRedditDel.icio.usNewsVineFurlBlinkList

LINQ to SQL and Visual C# Developer Express Data Source Connections

July 9, 2008 17:25 by Ryan Garaygay

While I was evaluating a couple of things including LINQ to SQL (or L2S to some) for a small website I tried to look into whether it was possible to have the LINQ to SQL classes on a separate project (eg. DAL) rather than the website itself. More...

Digg It!DZone It!StumbleUponTechnoratiRedditDel.icio.usNewsVineFurlBlinkList

Investing in a Quality Programming Chair

July 8, 2008 14:33 by Ryan Garaygay

Been quite busy lately work and off work (research ofcourse primarily in urlrewriting) but I couldn't help but notice and comment on a post from CodingHorror/Jeff Atwood on this topic More...

Digg It!DZone It!StumbleUponTechnoratiRedditDel.icio.usNewsVineFurlBlinkList