Design Faster Websites

From Y! Theater - "Nicole Sullivan : Design Faster Websites"

Nicole Sullivan: "Design Fast Websites" @ Yahoo! Video

SQL Tip: Query to get Physical file size of a DB

SQL Query to get the Physical file size of a given Database:

select Name, size, maxsize, growth from sys.sysfiles

SQL Tip: Query to get Table Statistics

SQL Query to get the Table(s) Statistics like RowCount, CreatedDate, Page Size etc., on a given Database:

SELECT s.Name SchemaName
, o.Name TableName
, coalesce(i.Name, 'HEAP') IndexName
, p.used_page_count * 8 UsedPageCountInKB
, p.reserved_page_count * 8 ReservedPageCountInKB
, p.row_count RowsCount
, t.create_date CreatedDate
, t.modify_date ModifiedDate
, t.max_column_id_used Columns
FROM sys.dm_db_partition_stats p
INNER JOIN sys.objects as o
ON o.object_id = p.object_id
INNER JOIN sys.schemas as s
ON s.schema_id = o.schema_id
INNER JOIN
sys.tables t ON t.object_id = o.object_id
LEFT OUTER JOIN sys.indexes as i
on i.object_id = p.object_id and i.index_id = p.index_id
WHERE o.type_desc = 'USER_TABLE'
and o.is_ms_shipped = 0
ORDER BY
p.row_count DESC

Introducing jQuery

Check out this SlideShare Presentation:

Extending jQuery

View SlideShare presentation or Upload your own. (tags: extending jquery)

Unobtrusive JavaScript with jQuery

Check out this SlideShare Presentation:

Unobtrusive JavaScript with jQuery

View SlideShare presentation or Upload your own. (tags: xtech08 xtech)

Javascript : The Good Parts - Part Six: Ajax Performance

From YUI Theater, Javascript : The Good Parts - Part Six: Ajax Performance

Douglas Crockford: "Ajax Performance" @ Yahoo! Video

Cooliris

Have you heard about Cooliris? It is Browser plugin which gives a 3D view of images and videos. The normal web pages with Media files can be viewed as 3D using this pugin. A Media RSS can be easily embedded with this Cooliris plugin to make it as a 3D Viewable.

In this below Embed, I have embedded the Flickr Feed for the Keyword 'Technology':

"Oracle in the Cloud" AWS Webinar

Check out this SlideShare Presentation:

"Oracle in the Cloud" AWS Webinar

View SlideShare presentation or Upload your own. (tags: amazon aws)

Top 10 Web Apps 0f 2008

The Top 10 Web Apps of 2008, published by RWW (ReadWriteWeb):

Top 10 Semantic Web Products of 2008
Top 10 International Products of 2008
Top 10 Consumer Web Apps of 2008
Top 10 RSS and Syndication Products of 2008
Top 10 Mobile Web Products of 2008
Top 10 Enterprise Web Products of 2008
Top 10 Real World Apps of 2008

REST, JSON, RSS + WCF

REST, JSON and RSS with WCF 3.5

View SlideShare presentation or Upload your own. (tags: wcf rest)

Enterprise IT Systems with REST

Check out this SlideShare Presentation:

Designing Enterprise IT Systems with REST - QCon San Francisco 2008

View SlideShare presentation or Upload your own. (tags: qcon enterprise)

REST and Web 2.0

Check out this SlideShare Presentation:

Have Some Rest Building Web2.0 Apps And Services

View SlideShare presentation or Upload your own. (tags: itdan application)

Microsoft Azure Services Platform

Azure Services Platform

View SlideShare presentation or Upload your own. (tags: architecture computing)

Cloud Computing

Cloud Computing is clearly explained in this slideshow.

A pool of highly scalable,abstracted infrastructur, capable of hosting end-customer applications, that is billed by consumption.

Cloud Computing in the Enterprise

View SlideShare presentation or Upload your own. (tags: services computing)

SaaS Technical-Business Overview

SaaS Technical-Business Overview

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

Software-as-a-Service (SaaS) - a Slideshow

ICT van de toekomst: Software as a service

View SlideShare presentation or Upload your own. (tags: owd2008 amazon)

YSlow 2.0

YSlow 2.0

View SlideShare presentation or Upload your own. (tags: beijing stoyan)

Beginning Object-Oriented JavaScript

Beginning Object-Oriented JavaScript

View SlideShare presentation or Upload your own. (tags: stoyan network)

Todd Kloots: Developing Accessible Widgets with ARIA (Accessible Rich Internet Applications)

From Y!Theater- Todd Kloots: Developing Accessible Widgets with ARIA (Accessible Rich Internet Applications)

Todd Kloots: "Developing Accessible Widgets with ARIA" @ Yahoo! Video

All About Google

Good facts about Google.

All about Google

View SlideShare presentation or Upload your own. (tags: google technology)

ASP.NET Tip: Maintain Session in ASHX Handler class

When using ASHX handler files if you want to maintain the SessionState, inherit the ASHX class from System.Web.SessionState.IRequiresSessionState. Otherwise, the Session object will be NULL in ASHX context.

Moonlight

Moonlight is an open source implementation of Microsoft Silverlight for Unix systems.

Download here
Check the Roadmap here

SSRS Tip - Create your Own Style Template

While creating a New Report, I was using the Default Table/Matrix Styles built in with SSRS. By default it has 'Slate', 'Forest'... But for some reason, I am not satisfied with the Colors in those Styles. So After creating a Report with those Style, I had to manually change the color,font etc. So I thought of making a Custom Style/Theme with my own choice of Color, Font, Size etc. So I researched and found that we can create our own Style/Theme and add it to the Built in ones.
These are the steps:
1. Goto : C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles\en
2. See the 'StyleTemplates.xml', which contains all the Style definitions in XML format. You will see the styletemplates 'Slate', 'Forest' etc.
3. Add your own StyleTemplate with your styles to the Root tag.
4. Create a New Report, you will see this new StyleTemplate in the 'Report Wizard - Choose the Table Style'.

The modified StyleTemplates.xml can be downloaded here:

In this example I created my own custom StyleTemplate (the following) and added it.


<StyleTemplate Name="LightTheme"> <Label>LightTheme</Label> <Styles> <Style Name="Title"> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <FontSize>12pt</FontSize> </Style> <Style Name="Page Group Level 1"> <FontFamily>Tahoma</FontFamily> <FontSize>10pt</FontSize> </Style> <Style Name="Page Group Level 2"> <FontFamily>Tahoma</FontFamily> <FontSize>9pt</FontSize> </Style> <Style Name="Page Group Level 3+"> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> </Style> <Style Name="Table"></Style> <Style Name="Matrix"></Style> <Style Name="Table Header"> <BackgroundColor>Gray</BackgroundColor> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> <Color>White</Color> <BorderStyle> <Default>Solid</Default> </BorderStyle> <BorderColor> <Default>DimGray</Default> </BorderColor> </Style> <Style Name="Group Level 1"> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> <BackgroundColor>DarkGray</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <BorderColor> <Default>DimGray</Default> </BorderColor> </Style> <Style Name="Group Level 1 Textbox"> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> <BackgroundColor>DarkGray</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <BorderColor> <Default>DimGray</Default> </BorderColor> </Style> <Style Name="Group Level 2"> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> <BackgroundColor>Gainsboro</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <BorderColor> <Default>LightGrey</Default> </BorderColor> </Style> <Style Name="Group Level 2 Textbox"> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> <BackgroundColor>Gainsboro</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <BorderColor> <Default>LightGrey</Default> </BorderColor> </Style> <Style Name="Group Level 3+"> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> <BackgroundColor>Gainsboro</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <BorderColor> <Default>LightGrey</Default> </BorderColor> </Style> <Style Name="Group Level 3+ Textbox"> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> <BackgroundColor>Gainsboro</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <BorderColor> <Default>LightGrey</Default> </BorderColor> </Style> <Style Name="Detail"> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> <BackgroundColor>Gainsboro</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <BorderColor> <Default>DimGray</Default> </BorderColor> <TextAlign>Right</TextAlign> </Style> </Styles> </StyleTemplate>

Extranet

Definition from WebSite Builder's Daily Quote:

An "extranet" is a private network that runs via the Internet. An extranet is configured to be accessible to some outside computers but not accessible to the general public. An example is when a company or organization allows customers, vendors or business partners to access a part
of its Intranet web site.

3 Winners of Credit Crisis Contest

The 3 Winners of Credit Crisis Contest on Slideshare.net:

The Financial Crisis: an Historical Perspective

View SlideShare presentation or Upload your own. (tags: contest mortgage)

The crisis 101 (US economy 2008) - put simple serie

View SlideShare presentation or Upload your own. (tags: consumer banks)

Cooking up an International Global Finance

View SlideShare presentation or Upload your own. (tags: finance global)

US Economic Outlook

A Good Presentation about the US Economy:

US Economic Outlook 2008-11+ (Updated)

View SlideShare presentation or Upload your own. (tags: us economic)

SQL Tip: SQL Statement to find Business Dates

SQL Statement to find Business Dates, posted by Pinal Dave here. I have added my own logic of finding the 'First Day of Previous Month'.

DECLARE @mydate DATETIME
SELECT @mydate = getdate()
SELECT CONVERT(VARCHAR(25), DATEADD(DD, -DAY(@mydate-1), DATEADD(MM, -1, @mydate)), 101) ,
'First Day of Previous Month'
UNION
SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@mydate)),@mydate),101) ,
'Last Day of Previous Month'
UNION
SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@mydate)-1),@mydate),101) AS Date_Value,
'First Day of Current Month' AS Date_Type
UNION
SELECT CONVERT(VARCHAR(25), DATEADD(DD, -7, @mydate), 101) AS Date_Value, 'Start Date of Previous Week' AS Date_Type
UNION
SELECT CONVERT(VARCHAR(25), DATEADD(DD, -1, @mydate), 101) AS Date_Value, 'End Date of Previous Week' AS Date_Type
UNION
SELECT CONVERT(VARCHAR(25),@mydate,101) AS Date_Value, 'Today' AS Date_Type
UNION
SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@mydate))),DATEADD(mm,1,@mydate)),101) ,
'Last Day of Current Month'
UNION
SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@mydate))-1),DATEADD(mm,1,@mydate)),101) ,
'First Day of Next Month'

Ajax Login panels

Some Good Ajax Login panel can be found in these links:

http://web-kreation.com/index.php/wordpress/showhide-login-panel-using-mooslide-mootools-1-2/

http://web-kreation.com/index.php/tutorials/nice-login-and-signup-panel-using-mootools-12/

Noupe - 13 Awesome Javascript CSS Menus

Noupe's 13 Awesome Javascript CSS Menus can be found here

Basic Economic Principles

Basic Economic Principles

Basic Economic Principles

View SlideShare presentation or Upload your own.

Practical Tips for Better UX

Practical Tips for Better UX:

Building for People: 5 Practical Tip for Greating Great UX

View SlideShare presentation or Upload your own. (tags: principles developer)

.NET Code Snippet: C# XML Serializer

An C# XML Serializer:

 using System;
using System.Data;
using System.Configuration;
using System.Xml;
using System.Xml.Serialization;
using System.Text;
using System.IO;

namespace Helper
{
    public static class XmlHelper
    {
        /// <summary>
        /// To convert a Byte Array of Unicode values (UTF-8 encoded) to a complete String.
        /// </summary>
        /// <param name="characters">Unicode Byte Array to be converted to String</param>
        /// <returns>String converted from Unicode Byte Array</returns>
        private static String UTF8ByteArrayToString(Byte[] characters)
        {
            UTF8Encoding encoding = new UTF8Encoding();
            String constructedString = encoding.GetString(characters);
            return (constructedString);
        }

        /// <summary>
        /// Converts the String to UTF8 Byte array and is used in De serialization
        /// </summary>
        /// <param name="pXmlString"></param>
        /// <returns></returns>
        private static Byte[] StringToUTF8ByteArray(String pXmlString)
        {
            UTF8Encoding encoding = new UTF8Encoding();
            Byte[] byteArray = encoding.GetBytes(pXmlString);
            return byteArray;
        }

        ///<summary>
        /// Method to convert a custom Object to XML string
        /// </summary>
        /// <param name="pObject">Object that is to be serialized to XML</param>
        /// <param name="objectType"></param>
        /// <returns>XML string</returns>
        public static String SerializeObject(Object pObject, Type objectType)
        {
            try
            {
                String XmlizedString = null;
                MemoryStream memoryStream = new MemoryStream();
                XmlWriterSettings settings = new XmlWriterSettings();
                settings.OmitXmlDeclaration = true;
                settings.Indent = true;
                XmlSerializerNamespaces namespaces = new XmlSerializerNamespaces();
                namespaces.Add(string.Empty, string.Empty);

                XmlSerializer xs = new XmlSerializer(objectType);
                XmlTextWriter xmlTextWriter = new XmlTextWriter(memoryStream, Encoding.UTF8);

                xs.Serialize(xmlTextWriter, pObject, namespaces);
                memoryStream = (MemoryStream)xmlTextWriter.BaseStream;
                XmlizedString = UTF8ByteArrayToString(memoryStream.ToArray());

                return XmlizedString;
            }
            catch (Exception e)
            {
                throw e;
            }
        }

      

        /// <summary>
        /// Method to reconstruct an Object from XML string
        /// </summary>
        /// <param name="pXmlizedString"></param>
        /// <param name="objectType"></param>
        /// <returns></returns>
        public static Object DeserializeObject(String pXmlizedString, Type objectType)
        {
            XmlSerializer xs = new XmlSerializer(objectType);
            MemoryStream memoryStream = new MemoryStream(StringToUTF8ByteArray(pXmlizedString));
            XmlTextWriter xmlTextWriter = new XmlTextWriter(memoryStream, Encoding.UTF8);

            return xs.Deserialize(memoryStream);
        }

    }
}

XSLT Tip: Omit input xml namespace

In XSLT whenever the Input XML has some 'xmlns' in its node, the normal XSLT path identifier will not work. So the XSLT should declare the input xml's 'xmlns' in itself with a prefix and then should be accessed. (e.g)

Input xml:

<ArrayOfCatalogItem>

  <CatalogItem>

    <ID xmlns="http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices">6ca7b76b-ed36-4128-9f84-e275fbf9</ID>

    <Name xmlns="http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices">Ad Serving</Name>

    <Path xmlns="http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices">/MIS/Report/Ad Serving</Path>    

  </CatalogItem>

</ArrayOfCatalogItem>

In XSLT, declare the xmlns in XSLT like this:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:rs="http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices" exclude-result-prefixes="rs" >

Note the word: xmlns:rs="http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices"

And to access the value of any node(here I use 'Name') use this:

<xsl:value-of select="rs:Name" disable-output-escaping="yes"/>

Note the word: "rs:Name"

ASP.NET Tip: Code to RenderControl()

Below is the code to Render a ASP.NET Server side Control.

using System.Text;
using System.IO;
using System.Web.UI;


public string RenderMyControl()
{
StringBuilder sb = new StringBuilder();
StringWriter tw = new StringWriter(sb);
HtmlTextWriter hw = new HtmlTextWriter(tw);
//Control ctrl;

ctrl.RenderControl(hw);
return sb.ToString();
}

Microsoft Expression Videos

Microsoft Expression Studio's How-to-Videos can be found here:

http://www.microsoft.com/video/en/us/categories/products/expression

FOSS.IN

FOSS.IN is one of the world’s largest Free and Open Source Software (FOSS) events, held annually in India. The event is highly focussed on FOSS development and contribution. Over the years, it has attracted thousands of participants, and the speaker roster reads like a “Who’s Who” of FOSS contributors from across the world.

Know more

Describe and Improve Business Model

Describe and Improve your Business Model

View SlideShare presentation or Upload your own. (tags: business model)

Web 2.0 Business Models

Web 2.0 Business Models

View SlideShare presentation or Upload your own. (tags: business models)

Evolution of Web 3.0

The Evolution of Web 3.0

View SlideShare presentation or Upload your own. (tags: iptv mobile)

Open Social State of the Union

Open Social State of the Union:

CrunchBase Information

OpenSocial Foundation

Information provided by CrunchBase

OpenSocial State of the Union - Get more Business Plans

.NET Tip: Unable to find manifest signing certificate in the certificate store

I downloaded a .NET project from Codeplex and When I tried to build it, I got the error 'Unable to find manifest signing certificate in the certificate store'. This is due to the property 'Sign the ClickOnce manifests' being used in the Project. I dont need that setting for my usage. So, The solution is:

Open the XX.csproj file in a text editor (notepad.exe) and remove the following tags from the XML.

<ManifestCertificateThumbprint>...</ManifestCertificateThumbprint>
<ManifestKeyFile>...</ManifestKeyFile>
<GenerateManifests>...</GenerateManifests>
<SignManifests>...</SignManifests>

More Business Intelligence using Excel 2007

More Business Intelligence using Excel 2007


Mike Arcuri - More business intelligence in Office 2007

SSRS Tip : Display Long Report in single page

I was wondering if there is a way to display a Long report output in a single page (i.e) If a report is of 50 pages in a normal view and I want to view it in a single page. And I found the way is:

1. On the layout tab, click the properties icon
2. choose report from the drop down list
3. expand the section interactive size
4. set the height to 0

Headup

Headup is a Firefox browser plugin that brings meaningful content to the browser.

Headup is your personal discovery agent to the Web. It’s an intelligent browser add-on that enriches your browsing experience by bringing meaningful content to you. headup works on Firefox and provides easy access to personally-relevant content from all over the web

Know more here.

Yahoo! Search BOSS

BOSS (Build your Own Search Service) is Yahoo!'s open search web services platform. Developers, Companies can create their own Search Solutions with this Yahoo! BOSS services as their Engine. BOSS returns the output either as XML or JSON.

Know more about BOSS here.

The Image from Yahoo! BOSS.

There are many websites that are already using BOSS:
hakia 

Me.dium Search 

SQL Server 2008 - Roadshow Presentations

SQL Server 2008 - Roadshow Presentations covered in New York. This covers the new features introduced in SQL 2008.

SSRS Tip : Matrix Report - Format/Style SubTotal fields

I had a matrix with column and row subtotals. I wanted to differentiate the SubTotal Row/data with a different Color. If I select the "Total" cell or the the subtotal row/column it will only format the Total labels, not the subtotaled data. The Cells of the Subtotaled data will also not be visible.

I struggled a bit and then found the solution:

In the "Total" textbox, there is a Green triangle. Right-click that triangle and see the Property of "Subtotal". This is where the Style(s) of SubTotal should be set.

Web 2.0 Summit Videos

Following are the Web 2.0 Summit Videos from TechWeb:

Mark Zuckerburg, Facebook



Ralph De La Vega, CEO, AT&T Mobility and Consumer Markets




Marc Benioff, SalesForce.com




Kevin Lynch, Adobe Systems Inc.,

Microsoft Source Code Analysis Utility : StyleCop

StyleCop is a Microsoft Utility used to make the C# Developer(s) to follow a set of consistent rules in the Source Code being developed.

StyleCop analyzes C# source code to enforce a set of style and consistency rules. It can be run from inside of Visual Studio or integrated into an MSBuild project.

StyleCop can be downloaded here.

There is a good article on How to Use StyleCop in CodeProject.

StyleCopCmd
The StyleCopCmd project provides both a command-line interface and custom NAnt task interface for Microsoft's StyleCop.

StyleCopCmd can be downloaded here.

Microsoft BizSpark

Microsoft BizSpark a new Program for Startups that provides Free software, support and visibility

BizSpark is an innovative new program that unites Startups with entrepreneurial and technology resources in a global community with a common goal of supporting and accelerating the success of a new generation of high-potential Startups

Dan'l Lewin, Corporate VP of Strategice and Emerging Business Team, Microsoft, announced this at the Web 2.0 Summit in SFO.


Starting up a company? Microsoft BizSpark can help

Microsoft PDC 2008 Panel : The Future of Programming Languages

This is an expert panel discussion on the Future of Programming Languages by Douglas Crockford, Gilad Bracha, Jeremy Siek,Anders Heijlsberg, Wolfram Schulte.

Microsoft PDC 2008 : Windows 7

A Good presentation on Windows 7 by Dan Polivy, Lead Program Manager, Microsoft.

Web 2.0 Summit - Yahoo! CEO Jerry Yang

Yahoo! CEO Jerry Yang's Speech in Web 2.0 Summit, SFO, CA.

Cloud Computing

A Good Definition/article on Cloud Computing Services. Follow this link:

http://www.davidchappell.com/CloudPlatforms--Chappell.pdf

Yahoo! BrowserPlus

Yahoo has released a browser plugin - Yahoo! BrowserPlus. It can be downloaded here.

BrowserPlus is a technology for web browsers that allows developers to create rich web applications with desktop capabilities.

Lloyd Hilaiel talks about this Technology in this Video:

Web 2.0 Summit

Web 2.0 Summit is a Technical Event about Web 2.0 Technologies to be held in San Francisco, CA. It is a 3 day event from Nov. 5 - 7, 2008. It is conducted by O'Reilly and TechWeb. To know more click here.

The Video Coverage of Web 2.0 Summit is here:

Microsoft DevLabs : Small Basic

Small Basic is one of the innovative project in Microsoft DevLabs.

Small Basic is a simple and easy programming language with a friendly environment that provides a cool and fun way of learning programming. From making turtles animations to running a slide show on the desktop, Small Basic makes programming natural and effortless.

Yes it is a Programming Language.

50+ Examples/Tutorial on Ajax Techniques

NOUPE has published a good list of Ajax Techniques with Examples and Tutorials here. If you are in Ajax Development bookmark this as a Reference. Give it a Try.

SSIS Tip: Avoid "An OLE DB record is available...Hresult: 0x80040154.Class not registered"

 had a SSIS Package to read the data from MDB(Microsoft Access File) and UPSERT into my SQL 2005 tables. I used OLEDB Source as Source Connection Type. This worked fine when executed through BIDS. But when I scheduled this Package in SQL Server Jobs, it failed with the following exception:

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

Then I found that this error occurs in 64bit MS SQL 2005 Edition. There was a suggestion that this type of package should be executed using explicit command to use DTExec.EXE in the Job Type.

Steps:

1.Choose 'Operating System(CmdExec)' as the Job Step Type instead of the Regular 'SQL Server Integration Services Pakcage' type
2.Use the following command :
Command : "D:\Program Files\Microsoft SQL Server (x86)\90\DTS\Binn\DTExec.exe" /SQL "\MIS\IncrementalLoad"


Note: This file path should be your machine path of DTExec.exe

I did that and it worked for me.

SQL Tip: SQL to Get dates between given range

SQL statement to get the dates in between the given date range. for (e.g) to get the Dates between 1/1/2007 to Today:

DECLARE @MinDate DATETIME
DECLARE @MaxDate DATETIME

SET @MinDate = '2007-01-01'
SET @MaxDate = getdate()
;
With Dates(Date)
AS
(
Select @MinDate Date
UNION ALL
SELECT (Date+1) Date
FROM Dates
WHERE
Date < @MaxDate ) SELECT Date, Datename(Month, Date) Month, Year(Date) Year FROM Dates OPTION(MAXRECURSION 0)

PDC 2008 - Key Note by Ray Ozzie

PDC 2008 - KeyNote presentation on Windows Azure by Ray Ozzie, Microsoft Chief Software Architect, and his Team.

PDC 2008 - Framework Design Guidelines

Framework Design Guidelines, a Presentation from PDC 2008.

US Economy Crash - Credit Crisis

The following 2 slideshows shows the clear picture of the US Credit Crisis. Worth seeing..

Creditcrisis 30slides Final

View SlideShare presentation or Upload your own. (tags: capitalism mortgage)

The Credit Crisis - the US economy horror picture show

View SlideShare presentation or Upload your own. (tags: crisis credit)

Yahoo! Query Language

Jonathan Trevor giving a presentation on Y!QL

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.

PDC 2008 - .NET 4.0 Poster

Brad Abrams have posted the .NET 4.0 Poster released in PDC 2008. The PDF can be downloaded here.

Yahoo! Open Strategy

A Presentation by Neal Sample & Cody Simms on Yahoo! Open Strategy.

Y! Application Platform

A Presentation by Xavier Legros on the Y! Application Platform:

Microsoft Codename

What is Microsoft Codename?

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

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.

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

DUX - Designing User eXperience

DUX - Designing User eXperience

Are You An User Experience Designer

View SlideShare presentation or Upload your own. (tags: ux design)

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:

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#.

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.

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!!!

Best Practices for Form Design

'Best Practices for Form Design' - a Slide show by Luke Wroblewski.

Best Practices for Form Design

View SlideShare presentation or Upload your own. (tags: 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")

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!

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.

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