Friday 24 April 2009

OSQL Utility

The osql utility allows you to enter Transact-SQL statements, system procedures, and script files. You can create a batch file (.bat) containing the osql statements:

http://msdn.microsoft.com/en-us/library/aa214012(SQL.80).aspx

http://www.databasejournal.com/features/mssql/article.php/3403331/OSQL-Utility.htm

http://msdn.microsoft.com/en-us/library/aa213090(SQL.80).aspx





Wednesday 22 April 2009

Development Icons

Questions to help choosing an icon:
  • What do you want the icon for? Topic? e.g. book, health, food, world, charity, etc
  • Where do you want to place it? Any background image compatibility
  • What color range your icon should have?
Icons are used for:
  • Links e.g. a link to google
  • Buttons e.g. Checkout button on an ecommerce site
  • Titles e.g. page header
Where to find icons:

http://www.freeiconsweb.com/index.html





Sunday 19 April 2009

Technology Communities

Benefits:
Technology Communities are where you may be able to
  • Find articles and sources about technologies (e.g. C#, .NET...) which are written by community members.
  • Publish your own article
  • Find answers to many of your technical questions
  • Meet peers
  • Join events
  • Ask questions or discuss using their forums
.NET Communities
  • http://www.c-sharpcorner.com/
  • http://www.codeguru.com/
  • http://www.dotnet247.com/
  • http://www.maddotnet.com/
  • http://www.codeproject.com/
  • http://www.theserverside.net/
  • http://www.csharpfriends.com/
  • http://code.msdn.microsoft.com/
  • http://msdn.microsoft.com/en-us/community/default.aspx
  • http://www.asp.net/
  • http://aspalliance.com/
  • http://wcfcommunity.com/default.aspx
  • http://windowsclient.net/
  • http://www.dotnetkicks.com/
  • http://dotnetshoutout.com/
  • http://www.lostechies.com/
SQL Server Communities:
  • http://sqlcommunity.com/
  • http://www.sqlservercentral.com/
  • http://www.sqlserverfaq.com

Saturday 4 April 2009

Proof Of Concept

  • The aim of Proof of Concept is to evaluate and verify that a proposed solution / idea to an understood problem is feasible and viable.
  • POC is just a prototype and doesn't represent the deliverable so it's often developed quickly and without a lot of testing
When?
It's done at the beginning or maybe in the middle of developing a software.

Who?
It's provided by the developer or architect and presented for the client.

What involved?
  • Estimated development costs
  • Estimated maintenance costs
  • The proposed technical design
  • Technologies to be used
  • If the proposed solution is a website, POC would be a facade that illustrates the look and feel of the site with no functionality e.g. using html, photshop ...

Why bother?

  • To understand the requirements clearly before it's too late (arguably...)
  • To assess the design decisions early in the process
  • Client to be able to visualize early on the look-and-feel of the solution.
  • To reduce the risk of project failure by getting feedback early

Software Development Methodology

POC is highly important in Waterfall model where the software is not developed in an incremental way. Other methodologies such as Scrum and XP provide deliverables after the end of each iterations and over time incrementally.

Wireframe:


More reading: