Geeks With Blogs
Catherine Russell Architect, President of "Women In Information Technology" Group Tutorials
TinySQL - small and handy SQL script which can quickly generate consistent code snippet.
TinySQL is small and handy SQL script which can quickly generate consistent code snippet that you can paste in your project. It basically operates by reading schema of provided table and applying template to each column of table in order to generate code snippet. With TinySQL, you can create complete or specific portion of business class, business service, or data access layer. You can also generate repetitive code snippet like storing all DataReader columns into respective property of business object, ......

Posted On Tuesday, October 12, 2010 9:02 AM

Working with hierarchyid Data in SQL Server 2008 R2
Managing a Tree Using hierarchyid ---------------------------... Although a hierarchyid column does not necessarily represent a tree, an application can easily ensure that it does. When generating new values, do one of the following: Keep track of the last child number in the parent row. Compute the last child. Doing this efficiently requires a breadth-first index. Enforce uniqueness by creating a unique index on the column, perhaps as part of a clustering ......

Posted On Wednesday, September 22, 2010 1:41 PM

free upcoming Webcast is a part of Microsoft's Visual Studio 2010 Ecosystem Series
The Web, Cloud and SaaS models are changing the computing world forever, and us, the developers will have to adjust and serve this trend. One of the biggest challenges is moving software assets that were developed for desktop architecture to the new deployment models. Just imagine that you could Copy/Paste your .NET code into a development framework , do some minor adjustments into multi users environment, decide whether you want to retain your desktop user interface (it could be ported 1:1 ) or ......

Posted On Thursday, July 8, 2010 3:33 PM

Web Designer Wall

A wall of design ideas, web trends, and tutorials.
Tutorials, news, funky design techniques and everything in between.

Posted On Wednesday, July 7, 2010 5:06 PM

Rollback in Oracle and SQL Server
I have an Oracle background. It was interesting to see how rollback handled in Oracle and SQL Server. There is no begin trans in Oracle. What oracle does is it will store the data in a temporary area called the rollback segments. Untill your issue the commit command the records will be kept there. You can even rollback your update statement by issuing the rollback command. When you issue the commit command the records in the rollback segments are written to the redo log files. The same logic for ......

Posted On Tuesday, June 15, 2010 1:45 AM

Copyright © CatherineRussell | Powered by: