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)