Wednesday, October 15, 2008

Blackbird Javascript

Blackbird - A Simple Javascript utility developed by G. Scott Olson, to 'log' the messages, instead of throwing as 'alert'. It can be very useful for debugging. The cool part is the images and the styles used to show the logger.

Tuesday, October 14, 2008

Javascript, The Good Parts

The presentation by Douglas Crockford about the Good Parts of Javascript. A good one from Yahoo Theatre.

Sunday, October 12, 2008

Zoho Mail

Zoho, a Chennai based Company, provides Office Suite similar to Google Docs and Spreadsheets. Last Friday Zoho has announced the Offline Support in its Zoho Mail. This internally uses Google Gears to make available of the emails. Zoho Mail is the First of its kind to support Offline access of emails.

Zoho Pitch




About Zoho Mail


At TechCrunch50

SQL Stored Procedure - Split

In SQL 2005, there is no built in function that Splits the given string based upon the given delimiter character (i.e) like Split function VB6. So I came up with the following SQL Function.

----------------------------------------

CREATE FUNCTION [dbo].[Split](@input nvarchar(4000), @delimiter char(1) )
RETURNS @results TABLE(SplittedString NVARCHAR(4000) )
AS



BEGIN
DECLARE @tempInput NVARCHAR(4000)
DECLARE @position INT
DECLARE @slice NVARCHAR(4000)


IF @input IS NULL RETURN

SELECT @tempInput = @input
SELECT @position = 1

WHILE @position != 0
BEGIN
SELECT @position = CHARINDEX(@delimiter, @tempInput)
IF @position > 0
SELECT @slice = LEFT(@tempInput, @position - 1)
ELSE
SELECT @slice = @tempInput

INSERT INTO @results(SplittedString) VALUES (@slice)

SELECT @tempInput = RIGHT(@tempInput, LEN(@tempInput) - @position)

IF LEN(@tempInput) = 0 BREAK
END

RETURN

END

Maintainable Javascript Videos

Here are the videos about 'Maintainable Javascript' presented by Chris Heilmann. Very useful for Javascript Development and Maintenance.


Chris Heilmann: Maintainable JavaScript, part 1 from Bachelor-ict.nl on Vimeo.



Christian Heilmann: Maintainable JavaScript, part 2 from Bachelor-ict.nl on Vimeo.

The Next Web Revolution

The next Era in Web, may be, Web 3.0? A good slide by Richard MacManus of ReadWriteWeb.

Wednesday, October 8, 2008

SSDS - SQL Server Data Services

SQL Server Data Services (SSDS) are highly scalable, on-demand data storage and query processing utility services. Built on robust SQL Server database and Windows Server technologies, these services provide high availability, security and support standards-based web interfaces for easy programming and quick provisioning.

Know More

Saturday, October 4, 2008

Practical Functional Javascript

Oliver Steele have created a samples application - Practical Functional Javascript where we can run the Javascript code directly. It is a very useful one to learn about the Javascript usage.


View SlideShare presentation or Upload your own. (tags: xhr ajax)

Describes how to use functional programming techniques with JavaScript, with specific examples around AJAX XHR requests. Presented at Ajax Experience 2008.


SlideShare Link

Gears++

Chris Prince of Google Developers is giving a good presentation of New Improvements in Google Gears on Google I/O 2008 Conference.


Get Ready for Visual Studio 2010

Microsoft has started to plan for Visual Studio 2010. When I was going through the MSDN Blogs, I found this 'Visual Studio 2010 and .NET Framework 4.0 Overview'. There are also some MSDN channel9 videos here. Good thing to know. Let us prepare ourselves for the next Tech cycle.

jQuery into ASP.NET

Microsoft has officially decided to ship, adopt and support jQuery with ASP.NET. As we know, jQuery is a good Javasript library for DOM querying and manipulation. With jQuery integrated, ASP.NET should be much more easier to access the HTML DOM.
Read more about this:

SSAS Links

Here are some useful links about SQL Server Analysis Services (SSAS) 

Friday, October 3, 2008

Google Corporate Executives

Want to know more about the Google Corporate Executives including Larry, Brin and Eric Schmidt? Click here

iReport

CNN is powering a website iReport in which a normal web user can submit a post as a NEWS. If you know any NEWS about any happening in the neighbourhood, you can easily publish this to the web in iReport.

"iReport.com is a user-generated site. That means the stories submitted by users are not edited, fact-checked or screened before they post. Only the stories marked "On CNN" have been vetted by CNN for use in CNN's global news coverage."

Javascript Libraries

View SlideShare presentation or Upload your own. (tags: libraries javascript)


Know more about the popular Javascript Libraries

SSRS - PDF Output Page Width

In my last assignment while working with SSRS we had an interesting issue. The issue is if a Report has large number of columns (about 60), when exported to PDF, it actually wraps up the columns which are beyond the normal Page width (8in). The same row of result will be wrapped into many pages depending on the number of columns and column width. This can be resolved by setting the Page Width property in the Report Properties to a high number (max 160in). 

SQL Stored Procedure - GetQueryStringValue

Recently, I had a requirement to create a SQL function to get the Query String value from a given Query String for a particular Query String Key. (e.g) Input QueryString = 'search=google&client=safari&data=xyz'
Input QS Key = 'client'
Output = 'safari'
So I came up with the following SQL function.





CREATE FUNCTION [dbo].[GetQueryStringValue]
(
@inputQS VARCHAR(400),
@QSKey VARCHAR(50)
)
RETURNS VARCHAR(100)
AS
BEGIN

DECLARE @positionStart INT
DECLARE @positionEnd INT


SET @positionStart = PATINDEX('%' + @qsKey + '%', @inputQS) 
IF @positionStart > 0
BEGIN
SET @positionStart = @positionStart + len(@qsKey) + 1 -- Get QSKey pos

SET @positionEnd = CHARINDEX('&', @inputQS,  @positionStart) -- Get the pos of next '&'
RETURN SUBSTRING(@inputQS, @positionStart, @positionEnd - @positionStart)
END
ELSE
RETURN ''
END


--------------------------
Usage : select dbo. GetQueryStringValue('search=google&client=safari&data=xyz', 'client')
output : safari

Wednesday, October 1, 2008

US Economy Crash - Reason

Do you want to know the Reason behind this whole US Economy Crash?
Read this article from Wiki - Financial Crisis
http://en.wikipedia.org/wiki/2007_subprime_mortgage_financial_crisis