Friday, October 31, 2008
PDC 2008 - Key Note by Ray Ozzie
PDC 2008 - KeyNote presentation on Windows Azure by Ray Ozzie, Microsoft Chief Software Architect, and his Team.
US Economy Crash - Credit Crisis
The following 2 slideshows shows the clear picture of the US Credit Crisis. Worth seeing..
Wednesday, October 29, 2008
SNAP Summit - Yahoo! Launch Announcement
Yahoo!'s "Open Strategy" (Y!OS) provides developers, publishers and advertisers with unprecedented access to Yahoo!'s global audience and traffic. Cody Simms, will introduce you to Y!OS and the next generation of tools that help developers engage with Yahoo!'s massive audience like never before.
Tuesday, October 28, 2008
Microsoft Codename
What is Microsoft Codename?
List of Microsoft Codenames from Wiki
The latest Codenames are Oslo, Dublin.
Microsoft codenames are the codenames given by Microsoft to products it has in development, before these products are given the names by which they appear on store shelves. Many of these products (new versions of Windows in particular) are of major significance to the IT community, and so the terms are often widely used in discussions prior to the official release. Microsoft usually does not announce a final name until shortly before the product is publicly available.
List of Microsoft Codenames from Wiki
The latest Codenames are Oslo, Dublin.
MS SQL 2005 Best Practices Analyzer(BPA)
The tool Microsoft SQL 2005 Best Practices Analyzer(BPA), is used to scan and analyze the given SQL 2005 Service and give a complete report about the Issues/Suggestions based upon the Best Practices. The SQL 2005 Services including Database Services, Analysis Services and Integration Services can be analyzed using this tool. This is really a useful tool for SQL 2005 DBAs and Database Developers.
This tool can be downloaded here
This tool can be downloaded here
SSIS Tip - result binding by name is not supported for this connection type
In SSIS when I tried to bind the ADO.NET Result Set to a User Variable by the 'RecordSet Column Name', I got the error 'result binding by name is not supported for this connection type'. The I found that the 'Result Set - Result Name' should be changed to Index of the Column in the Result Set like 0, 1.
Monday, October 27, 2008
Microsoft Pre-release Software Visual Studio 2010 and .NET Framework 4.0 Community Technology Preview (CTP)
Microsoft has Pre-released the version of Visual Studio 2010 and .NET Framework 4.0 Community Technology Preview (CTP). It can be downloaded here
Ignite
Ignite is a community event sponsored by O'Reilly in the major cities across the Planet. It is 5 minutes speech of an individual on a Stage with 20 slides being rotated automatically in 15 seconds.
If you had five minutes on stage what would you say? What if you only got 20 slides and they rotated automatically after 15 seconds? Around the world geeks have been putting together Ignite nights to show their answers.
Ignite was started in Seattle in 2006 by Brady Forrest and Bre Pettis. Since then 100s of 5 minute talks have been given across the world. There are thriving Ignite communities in Seattle, Portland, Paris, and NYC.
This community site is sponsored by O'Reilly.
sIFR - Scalable Inman Flash Replacement
sIFR - Scalable Inman Flash Replacement is the Technology that allows to replace text elements on screen with Flash equivalents. It allows the screen elements to be styled in whatever font the designer chooses, without the user having it installed on their machine.
Know more here
Examples are here
Know more here
Examples are here
Sunday, October 26, 2008
Friday, October 24, 2008
XML Encoding for Special Characters
In MS SQL 2005, While parsing a XML document i got an error message 'illegal xml character'. Then i found that one of my XML data was containing a special character - รค within it. And i found that in this scenario, the XML Encoding tag in the header should be changed to "iso-8859-1" from the default "utf-8" (i.e)
<?xml version='1.0' encoding='utf-8'?>'
should be changed to
<?xml version="1.0" encoding="iso-8859-1"?>
MS SQL - Query to Get Columns Definition
To get the Column Definitions of a Given table in MS SQL, use this query:
I used this for generating a Bulk Insert statement for a XML Rowset in C#.
SELECT so.name ,
sc.name ,
st.name ,
sc.length ,
CASE
WHEN sc.status = 0x80
THEN 'Y'
ELSE 'N'
END AS IsIdent ,
ColOrder
FROM sysobjects so
INNER JOIN syscolumns sc
ON so.id= sc.id
INNER JOIN systypes st
ON sc.xtype = st.xusertype
WHERE so.Name = 'YourTableName'
ORDER BY ColOrder
I used this for generating a Bulk Insert statement for a XML Rowset in C#.
Wednesday, October 22, 2008
US Voter Location Info
Want to know Where to Vote for this Presidential Election? Click Here. Google has released a special Voting Location Info Page.
Tuesday, October 21, 2008
Zephyr - Test Management System
Zephyr is a new Web 2.0 Test Management System. It has many innovative features like Testing Desktops, Department/Project Dashboards, Defect Desktop, Metrics, Collaboration, Test Case Repository and so on. The UI is very slick and cool. I did a test drive of the Department Dashboard and Defect Desktop and I was amazed with the UI and the Design of the Form. No wonder it is created by a bunch of QA Engineers and Developers. It is free for 3 Users for 12 months period.
Know more here
Take a Test Drive Here.
Good Luck Zephyr!!!
Know more here
Take a Test Drive Here.
Good Luck Zephyr!!!
Best Practices for Form Design
Reporting Services - Display Hour in 24 Hour Format with AM/PM
Recently I had a Requirement in SSRS 2005 to display a Report for Hourly Aggregation. The Report should look something like this:
Hour | Total
1 AM | 120
2 AM | 200
.
.
.
12 AM | 644
1 PM | 730
2 PM | 880
.
.
12 AM | 1458
---------------
In the Report Dataset using my SQL Query I got the Results like this
Hour | Total
1 | 120
2 | 200
3 | 328
So I had to display the Hour in 24 Hour format with AM/PM. I tried with various combinations of FormatDateTime() and Format(). Finally I found the format string - = Format(Today().AddHours(Fields!Hour.Value), "hh tt")
Hour | Total
1 AM | 120
2 AM | 200
.
.
.
12 AM | 644
1 PM | 730
2 PM | 880
.
.
12 AM | 1458
---------------
In the Report Dataset using my SQL Query I got the Results like this
Hour | Total
1 | 120
2 | 200
3 | 328
So I had to display the Hour in 24 Hour format with AM/PM. I tried with various combinations of FormatDateTime() and Format(). Finally I found the format string - = Format(Today().AddHours(Fields!Hour.Value), "hh tt")
Visual Studio Tips and Tricks
Recently When I was going through MSDN Blogs, I found an interesting one from Stephen Walther, titled "Essential Visual Studio Tips & Tricks that Every Developer Should Know". I went through it and it had some good keyboard shortcuts. The one that attracted me was - Tip #3 – Never create properties by hand.
Thanks Stephen!
Thanks Stephen!
7 More Search Tools
I read from here "7 Search Tools You May Not Know … But Should"
There are 7 Search tools that are less popular.
Soovle
Kedrix
Fansnap
Fasteagle
Facesaerch
Tastekid
Compfight
Out of these, Soovle and
Kedrixare more useful.
There are 7 Search tools that are less popular.
Soovle
Kedrix
Fansnap
Fasteagle
Facesaerch
Tastekid
Compfight
Out of these, Soovle and
Kedrixare more useful.
Monday, October 20, 2008
Taffy DB
Taffy DB is a free and opensource JavaScript library that acts as thin data layer inside Web 2.0 and Ajax applications.
Think of it as a SQL database in your web browser. It has many cool features including a CRUD(Create, Read, Update and Delete) Support which is first of its kind.
Get Started here
Think of it as a SQL database in your web browser. It has many cool features including a CRUD(Create, Read, Update and Delete) Support which is first of its kind.
Get Started here
Lorem Ipsum
Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
Long back when I started to learn about Scriptaculous Javascript Library, in the Unit Test samples i saw a long text starting with 'Lorem Ipsum..'. I thought it might be some random sample text used there. But after some time I have seen this text in some other web site also. I didn't know much about this text. But In my Project when designing a Report, my Project Manager Rohit Khanna told that this Text is a Web Standard placeholder text used to demonstrate the graphic elements of a document or visual presentation, like font, layout etc.
Thanks Rohit!!!
I digged further and found these useful links:
Lorem Ipsum in Wiki
Lipsum.com
Sunday, October 19, 2008
The Javascript Programming Language
'The Javascript Programming Language' - a good presentation by Douglas Crockford covering the History to Advanced Features of Javascript. A good one.
Douglas Crockford presents "Web Forward"
Douglas Crockford presents "Web Forward" on October 9, 2008.
Friday, October 17, 2008
Designing For Ajax
Thursday, October 16, 2008
Web 3.0 = ?
Web 3.0 = (4C + P + VS), a Definition by Sramana Mitra on one of her Blogs.
She says
She is also conducting a RoundTable on Web 3.0 with RWW in DimDim. Know more here.
She says
"3C = Content, Commerce, Community | 4th C = Context | P = Personalization | VS = Vertical Search"
She is also conducting a RoundTable on Web 3.0 with RWW in DimDim. Know more here.
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
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
----------------------------------------
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.
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.
Thursday, October 9, 2008
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
Know More
Sunday, October 5, 2008
Interview Questions links
Some useful Interview Questions links from Shivprasad Koirala.
Project Management interview questions
Download Networking Interview Questions
Download Software Testing Interview Questions
Download Sql Server Interview Questions
Download C# and ASP .Net Projects
Download Java Interview Questions
Download Software Architecture Interview Questions
Download Excel Question and Answers
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.
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:
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."
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
Subscribe to:
Posts (Atom)
