Tuesday, May 06, 2008

Microsoft Product Code Names

Know Microsoft Product Code Names:

Current '''ProductCodeNames''' - Various Microsoft product codenames from over the years.

11/12/2007 4:33:10 AM - Zeus

CodeNames

Avalon

Windows Presentation Foundation, WPF is the presentation subsystem class libraries in Click to read this topic

5/8/2005 7:52:01 PM -

WinFX.

Aero

UI in Windows Vista

Aruba

Windows Media Platform for Blackcomb

Ajax

New Set of asynchonous technologies for web applications enabling richer user experiences

Blackcomb

Successor to Vista

Cairo

Base collection of technologies which largely evolved into the core technologies in 1.Vista.

Cider

VS Designer for Windows Presentation Foundation

Longhorn

Windows Vista

Monad

Longorn Command Shell. Msh is the new

Vienna

Office Live Communication Server 2005

Whidbey

Visual Studio .NET 2005

Orcas

Visual Studio 2008

Hawaii

Future version of Visual Studio (after the Orcas release).

Whitehorse

VS.NET 2005 Design Tool Suite

Click to read this topic

5/8/2005 7:52:01 PM -

WinFx

The set of next-generation managed APIs provided by Microsoft

Yukon

SQL Server 2005 scripting and automation environment for Windows

Acrylic

Microsoft Expression Graphic Designer. A new professional graphics software.

Sparkle

Microsoft Expression Interactive Designer.

Quartz

Microsoft Expression Web Designer.

Click to read this topic

12/19/2006 5:17:49 AM -

WinFS

Next-generation Unified Storage Sub-system for Windows.

Operating System Components / Versions

Avalon

Windows Presentation Foundation, WPF is the presentation subsystem class libraries in Click to read this topic

5/8/2005 7:52:01 PM -

WinFX.

Asteroid

Windows 2000 SP1

Aero

UI in Windows Vista

Bearpaw

Windows Terminal Services for Windows Server 2003

Blackcomb

Is the server version of Vista

Bobcat

Windows Server 2003 Small Business Edition

Cairo

Base collection of technologies which largely evolved into the core technologies in Vista.

Chicago

Windows 95

Daytona

Windows NT 3.5

Detroit

Windows 95 OSR 2

Freestyle

Windows XP Media Center Edition

Frosting

Windows 95 Plus!

Harmony

Windows XP Media Center Edition 2004

Impala

Windows NT4 Embedded

Indigo

Communications services used in Vista, also called WCF(Windows Communication Foundation)

Janus

Windows 3.1

Lonestar

Windows XP Tablet PC Edition 2005

Longhorn

Windows Vista

Mantis

Windows XP Embedded 5.1

Memphis

Windows 98

Mesquite

Batch Management tools for Windows NT/Windows 2000 Server

Millenium/Georgia

Windows ME

Mir

Internal Mercury release

NAS 3.0

Windows Storage Server 2003

Nashville

Internet Explorer 4, for Windows 95

Neptune

Cancelled successor to Windows 98

Newshell

Alpha shell update for Windows NT 3.x

Panther

Abandoned port of Windows NT, replaced by Chicago

Slalom

Windows Media Center for Vista

Sparta

Windows for Workgroups 3.1

Springboard

Backporting of Vista technologies to Windows XP Service Pack 2

6/29/2005 6:01:27 PM - RaiN

SP2

Snowball

Windows for Workgroups 3.11

Sundown

Windows XP 64-bit

SUR

Patch to Windows 3.51

Symphony

Windows XP Media Center Edition 2005

Whistler

Windows XP

Windows

Windows 1.0

Windows 286

Windows 2.0

Click to read this topic

5/8/2005 7:52:01 PM -

WinFx

The set of next-generation managed APIs provided by Microsoft

Server Products

SQL

Starfighter

SQL Server 6.0

Hydra

SQL Server 6.5

Sphinx

SQL Server 7.0

Plato

SQL Server 7.0 OLAP Services

Shiloh

SQL Server 2000

Liberty

SQL Server 2000 64-bit Edition

Rosetta

SQL Server 2000 Reporting Services

Aurum

SQL Server 2000, data mining toolkit

Yukon

SQL Server 2005

Katmai/Acadia

SQL Server 2008

Exchange

Osmium

Exchange Server 5.5

Platinum

Exchange Server 2002

Titanium

Exchange Server 2003

Kodiak

Abandoned successor to Exchange 2003.

Magma

Embedded Exchange

SharePoint Portal Server 2003 links

9/14/2004 12:10:55 AM - roberdan

SharePoint

Tahoe

Sharepoint Server 2001

Matrix

Sharepoint Portal Server v2

add a one or paragraph summary or description of what's discussed here; put yours after 'Summary:'

9/2/2004 3:33:27 PM - kevinh

BizTalk

Latinum

add a one or paragraph summary or description of what's discussed here; put yours after 'Summary:'

9/2/2004 3:33:27 PM - kevinh

BizTalk 2000

Bizet

add a one or paragraph summary or description of what's discussed here; put yours after 'Summary:'

9/2/2004 3:33:27 PM - kevinh

BizTalk 2002

Misc

Falcon

Message Queue Server (MSMQ)

Viper

Transaction Server 2.0

Hydra

Windows NT Terminal Services

Babylon

Host Integration Server

Cedar

COM Transaction Integrator for CICS and IMS (COMTI)

Wolfpack

Cluster Server

Vienna

Office Live Communication Server 2005

Hermes

System Management Server

Kahiltna

Commerce Server 2.0

Comet

ISA 2000

Mobile PC

Lonestar

Windows XP Tablet PC Edition 2005

Haiku

Post-2007 mobile PC hardware design

Mobile Platforms

Alder

Windows CE 2.1

Apolllo

Windows CE for Auto PC

Axe

Embedded Toolkit for Windows CE 2.0 and 2.1

Brich

Windows CE 2.11 and 2.12

Cedar

Windows CE 3.0

Chainsaw

Windows CE Platform Builder 3.0

Galileo

Windows CE for Handheld PC 2000

Goldeneye

Windows CE for AutoPC

Gryphon

Windows CE 2.0 for palm-sized PCs

Hai Ku

Multimedia Extension for Windows

Hermes

Windows CE for webphones

Jameson

Windows CE.NET Update

Jupiter

Windows CE for Handheld PC Pro 3.0 (or Macallan Windows CE.NET Corporate Edition??)

Laguna

Upcoming version of SQL Server, for Windows CE

McKendrick

Windows CE for Media2G0

Mercury

Windows CE for Hanheld PC

Merlin

Pocket PC 2002 (or Windows CE 2002??)

Mira

Windows CE for Smart Display Devices

Orion

Windows CE for Chinese Handheld PC

Ozone

Pocket PC 2003

Pegasus

Windows CE 1.0

Rapier

Windows CE for add a one or paragraph summary or description of what's discussed here; put yours after 'Summary:'

2/11/2007 4:22:22 AM - abhishek85gupta

PocketPC 2000

Stinger

Smartphone 2002 (or Windows CE for Smartphones 1.0??)

Starlite

.NET Compact Framework 1.0

Talisker

Windows CE .NET

Tazz

Microsoft Phone

Visine

Novell Netware Migration Tool

Venus

Windows CE for webTV

Wyvern

Windows CE for Color Palm PC

Miscellaneous

Trident

Dynamic HTML

Springboard

Microsoft's security excellence and review project, who's fruits were deployed via Office 2003 SP1, Windows XP SP1 and Windows Server 2003 SP1

Palladium

An on-again off-again secure runtime environment called Next Generation Secure Computing Base (NGSCB

AirStream

Services for wireless connections to Exchange

Avalanche

Internet-Information-Services 5.0

Argo

Query-Services for SQL-Server 2000

Aruba

Windows Media Platform for Blackcomb

Athena

Outlook Express

Athens

New prototype PC design (with HP)

Blackbird

MSN SDK

Blizzard

Business oriented Set of Services in .NET My Services

Basecamp

VPN dial-up networking update (PPTP) for win95

Calais

Smart-Card Technologies

Cascade

Windows Active-Directory

Cayman

NetMeeting 3.0 Version 3.01 4.4.3400

Chrome

ChromeEffects (GUI-Feature)

Cirrus

Access 1.0

Comet

Network-Tools for Windows 2000

Corona

Windows Media-Technologies 9.0

Coyote

Distributed Views for SQL-Server 2000

Darwin

Windows Installer 1.1 Version 1.1

Dart

Setup for Oracle, SQL-Server ODBC-driver

DaVinci

Database-Design & Query-Tools

Denali

Active Server Pages

Europa

New GUI for the MSN-Community

Fahrenheit

A defunct collaboration between Microsoft & SGI Graphics to combine Direct3D and OpenGL by creating a unified 3D API.

Falcon

Windows Messaging Queuing Server

Fusion

Technologies for DLL improvements

Gemini

Succesor GUI "Europa" for MSN-Community

Gibraltar

Internet-Information-Server 1.0 Version 3.0

Grizzly

Workflow-Designer for SQL-Server 2000

Hailstorm

XML Message Interface

Hailstorm

.NET My Services

HardeningPack

Internet Explorer Enhanced Security (Windows Server 2003)

Hydra

Windows NT Terminal Services

Idaho

Preliminary/alpha version of the next Windows-Longhorn

Jakarta

JAVA-Engine for Internet Explorer 3.0

Kagera (Kajera??)

OLE-DB Provider for ODBC-Data

Kahuna

Windows Live Mail

K2

Internet-Information-Server 4.0

Lightning

.NET Common Language Runtime (CLR)

Luna

Theme technology for Windows XP

Luxor

OLE-Provider-Services for Yukon

Magic Carpet

Passport-Technologien

Marvel

Microsoft Network (MSN)

Merlin

Microsoft® Internet Explorer for Dreamcast (cancelled circa 1999).

Mercury

DUN 1.2 update for Win95

Monad

Longorn Command Shell. Msh is the new scripting and automation environment for Windows

NGWS

(Next Generation Windows/Web Services) .Net

Normandy

Microsoft Commercial Internet System (MCIS)

Oprah

Netmeeting

Nile

OLE-DB

O'hare

Internet Explorer 1.00.

Plato

OLAP-Server

Project 42

(from Lightning) .NET Common Language Runtime (CLR)

Ren

Outlook

Quartz

Direct Show

Sideshow

Task Shelf of Longhorn (MS research)

Slate

Microsoft Management-Console (MMC)

Spark

Integration of Windows SharePoint Portal Server 2003 links

9/14/2004 12:10:55 AM - roberdan

SharePoint Services and CMS

Steelhead

Windows NT Routing & Remote-Access Services (RAS)

Tahiti

SharedView Beta2

Talisman

3D Graphic- und Multimedia Architecture

Tensor

OLE-DB Extensions for OLAP

Touchdown

Outlook 97 (Also mentioned:Public folders for MS Exchange)

Trident

Dynamic HTML (DHTML)

Tungsten

Microsoft Rights Management Services (RMS)

Whisper

Speech Recognition (speech-to-text)

Xenon

Xbox 360

Read Write and Search XML Document in ASP.NET

You often need to read, write or search some phrase in an XML document and you can use XmlDocument or any class among a lot present in .NET framework but what
if you wish to bind your business objects
the list of business objects to the XmlDocument.

You can use the code below to do this.

What you need to do for this is to keep the name of properties of your business objects same as the name of attributes are present in the XML file you wanna load.

This class make use of XmlReader and XmlWriter base classes provided by .NET framework.

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using System.Xml;
using System.Reflection;
using System.IO;

///
/// XMLDataHelper provides way to access nodes and bind them directly to custom objects.
/// Also Save XMLFragment at the end of the Xml File
///

public class XMLDataHelper : IDisposable
{
#region Variables

private static string _baseDirectory = AppDomain.CurrentDomain.BaseDirectory;
private static string _documentDirectory = _baseDirectory + "App_Data/";

protected string _query;
protected XmlReader xmlReader;
protected XmlWriter xmlWriter;
#endregion

#region constructors
public XMLDataHelper()
{
string xmlFile = ConfigurationManager.AppSettings["XmlFileName"].ToString();
xmlReader = XmlReader.Create(xmlFile);
}

public XMLDataHelper(string xmlFile)
{
xmlReader = XmlReader.Create(xmlFile);
}
public XMLDataHelper(string xmlFile, string xmlFileForWriter)
{
xmlReader = XmlReader.Create(xmlFile);
xmlWriter = XmlWriter.Create(xmlFileForWriter);

}
#endregion

#region Load Object
public T LoadObject(string nodeName, Dictionary attrFieldsLookUp) where T : new()
{
T obj = new T();
if (string.IsNullOrEmpty(nodeName))
{
throw new Exception("Node not specified.");
}
bool IsRequestedItem = true;
PropertyInfo[] objPropInfo = obj.GetType().GetProperties();
while (xmlReader.ReadToFollowing(nodeName))
{
if (xmlReader.NodeType == XmlNodeType.Element && xmlReader.NodeType != XmlNodeType.Document)
{
XmlReader nodeXmlReader = xmlReader.ReadSubtree();
while (nodeXmlReader.Read())
{
IsRequestedItem = false;
foreach (string key in attrFieldsLookUp.Keys)
{
if (attrFieldsLookUp[key.ToUpper()] == nodeXmlReader.GetAttribute(key))
{
IsRequestedItem = true;
}
else
{
IsRequestedItem = false;
break;
}
}
if (IsRequestedItem)
{
GetObjectFromReaderNode(ref obj, ref nodeXmlReader, ref objPropInfo, true, nodeName);
}
}
}
}
if (xmlReader.ReadState != ReadState.Closed)
{
xmlReader.Close();
}
return obj;
}
#endregion

#region GetObjectFromReaderNode
private void GetObjectFromReaderNode(ref T obj, ref XmlReader nodeXmlReader, ref PropertyInfo[] objPropInfo, bool AreElementsReq, string nodeName)
{
Dictionary xmlFileValues = new Dictionary();
while (nodeXmlReader.MoveToNextAttribute())
{
xmlFileValues.Add(nodeXmlReader.Name.ToUpper(), nodeXmlReader.Value);
}
foreach (PropertyInfo pi in objPropInfo)
{
if (pi.Name == "DEPTH")
{
pi.SetValue(obj, (object)(nodeXmlReader.Depth + 1), null);
}
else
{
string currAttrVal;
if (xmlFileValues.TryGetValue(pi.Name.ToUpper(), out currAttrVal))
{
if (pi.PropertyType == typeof(Boolean))
{
pi.SetValue(obj, Convert.ToBoolean(currAttrVal.ToLower()), null);
}
else
{
pi.SetValue(obj, (object)currAttrVal, null);
}
}
}
}
if (AreElementsReq)
{
bool firstOccur = true;
while (xmlReader.Read() && firstOccur)
{
if (xmlReader.NodeType == XmlNodeType.Element && xmlReader.NodeType != XmlNodeType.Document)
{
string elementName = nodeXmlReader.Name;
// To Stop Retrieving Inner Elements value
if (elementName == nodeName)
{
firstOccur = false;
}
string currElementVal;
foreach (PropertyInfo pi in objPropInfo)
{
if (pi.Name.ToUpper() == elementName.ToUpper())
{
pi.SetValue(obj, (object)nodeXmlReader.ReadElementString(), null);
}
}
}
}
}
}
#endregion

#region LoadList
public List LoadList(string nodeName, bool includeElement) where T : new()
{
T obj = new T();
List retList = new List();
if (string.IsNullOrEmpty(nodeName))
{
throw new Exception("Node not specified.");
}
bool IsRequestedItem = true;
PropertyInfo[] objPropInfo = obj.GetType().GetProperties();
while (xmlReader.Read())
{
if (xmlReader.NodeType == XmlNodeType.Element && xmlReader.NodeType != XmlNodeType.Document)
{
if (xmlReader.Name == nodeName)
{
obj = new T();
GetObjectFromReaderNode(ref obj, ref xmlReader, ref objPropInfo, includeElement, nodeName);
retList.Add(obj);
}
}
}
if (xmlReader.ReadState != ReadState.Closed)
{
xmlReader.Close();
}
return retList;
}
#endregion

#region SaveXmlFragment
// Summary:
// To Save XmlFragment at the end of the file
public void SaveXmlFragment(string rawXmlFragment, string rootItem)
{
try
{
using (xmlReader)
{
while (xmlReader.Read())
{
if (xmlReader.NodeType == XmlNodeType.Element && xmlReader.Name == rootItem)
{
xmlWriter.WriteStartElement(rootItem);
xmlWriter.WriteRaw(xmlReader.ReadInnerXml());
xmlWriter.WriteRaw(rawXmlFragment);
xmlWriter.WriteEndElement();
}
else if (xmlReader.NodeType == XmlNodeType.Comment || xmlReader.NodeType == XmlNodeType.Text || xmlReader.NodeType == XmlNodeType.Whitespace)
{

}
else
{
xmlWriter.WriteNode(xmlReader, true);
}
}
xmlWriter.Flush();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
xmlReader.Close();
xmlWriter.Close();
FileInfo fi = new FileInfo(_documentDirectory + "SiteData.xml");
File.Copy(_documentDirectory + "_tempSiteData.xml", fi.FullName, true);
}
}
#endregion

#region Search Document
// Summary:
// To Save XmlFragment at the end of the file
public SortedDictionary> SearchDocument(string searchText, string nodeName, string propertyNameToLookFor) where T : new()
{
List searchWords = new List();

string[] allWords = searchText.Split(' ');

for (int i = 0; i <>> retDictionary = new SortedDictionary>();

T obj = new T();

PropertyInfo[] piAll = obj.GetType().GetProperties();

List retList = this.LoadList(nodeName, true);

foreach (T item in retList)
{
string content = "";
int relevance = 0;
foreach (PropertyInfo pi in piAll)
{
if (pi.Name == propertyNameToLookFor)
{
content = Convert.ToString(pi.GetValue(item, null));
}
}
string[] contentSplitted = content.Split(' ');
foreach (string word in searchWords)
{
for (int i = 0; i <> relCorrList = new List();
relCorrList.Add(item);
retDictionary.Add(relevance, relCorrList);
}
else
{
retDictionary[relevance].Add(item);
}
}
}
return retDictionary;
}
#endregion

#region IDisposable Members
public void Dispose()
{
if (xmlReader.ReadState != ReadState.Closed)
{
xmlReader.Close();
xmlWriter.Close();
}
}

#endregion


}

if you are getting it difficult to understand or have some queries you can put a reply or mail me at
shashank.abes at gmail.com

Some Useful Sql Server Queries

Some Useful Sql Server Queries

Get Number Of Days in a Month:

SQL Query to get No of Days in a month:-

SELECT DAY(DATEADD(MONTH, 1, GETDATE()) - DAY(DATEADD(MONTH, 1, GETDATE())))

Reading XMl from Sql Server

DECLARE @FileName varchar(255)

DECLARE @ExecCmd VARCHAR(255)

DECLARE @y INT

DECLARE @x INT

DECLARE @FileContents VARCHAR(8000)

CREATE TABLE #tempXML(PK INT NOT NULL IDENTITY(1,1), ThisLine VARCHAR(255))

SET @FileName = Full Path To Xml \General.xml'

SET @ExecCmd = 'type ' + @FileName

SET @FileContents = ''

INSERT INTO #tempXML EXEC master.dbo.xp_cmdshell @ExecCmd

SELECT @y = count(*) from #tempXML

SET @x = 0

WHILE @x <> @y

BEGIN

SET @x = @x + 1

SELECT @FileContents = @FileContents + ThisLine from #tempXML WHERE PK = @x

END

SELECT @FileContents as FileContents

DROP TABLE #tempXML

Grouping Records in Sql Server 2005

declare @NO_OF_PARTITION int

set @NO_OF_PARTITION = 10

SELECT c.First_Name, c.Last_Name , C.DIVISION_ID

,NTILE(@NO_OF_PARTITION)

OVER(PARTITION BY DIVISION_ID ORDER BY DIVISION_ID ASC) AS 'GROUP_ID'

FROM EMPLOYEE C

WHERE division_id = 2

ORDER BY DIVISION_ID ASC

Replacement to IN and NOT IN from INTERSECT and EXCEPT

SELECT EMPLOYEE_ID FROM EMPLOYEE

INTERSECT

SELECT EMPLOYEE_ID FROM LEAVE_DETAILS

SELECT EMPLOYEE_ID FROM EMPLOYEE

EXCEPT

SELECT EMPLOYEE_ID FROM LEAVE_DETAILS

Using NTILE to tile (group) your records

SELECT c.First_Name, c.Last_Name , C.DIVISION_ID

,NTILE(2)

OVER(PARTITION BY DIVISION_ID ORDER BY DIVISION_ID ASC) AS 'GROUP_ID'

FROM EMPLOYEE C

WHERE EMPLOYEE_ID < 13

ORDER BY DIVISION_ID ASC

Get Serial No. with the query result (ROW_NUMBER function SQL Server 2005)

SELECT ROW_NUMBER() OVER (ORDER BY DIVISION_ID ASC) AS ROWID, * FROM EMPLOYEE

Using Pivot Keyword SQL Server 2005

CREATE TABLE dbo.SalesByQuarter
(
Y INT,
Q INT,
sales INT,
PRIMARY KEY (Y,Q)
)
GO

INSERT dbo.SalesByQuarter(Y,Q,Sales)
SELECT 2003, 2, 479000
UNION SELECT 2003, 3, 321000
UNION SELECT 2003, 4, 324000
UNION SELECT 2004, 1, 612000
UNION SELECT 2004, 2, 524000
UNION SELECT 2004, 3, 342000
UNION SELECT 2004, 4, 357000
UNION SELECT 2005, 1, 734000
GO

SELECT Y,
[1] AS Q1,
[2] AS Q2,
[3] AS Q3,
[4] AS Q4
FROM
(SELECT Y, Q, Sales
FROM SalesByQuarter) s
PIVOT
(
SUM(Sales)
FOR Q IN ([1],[2],[3],[4])
) p
ORDER BY [Y]
GO

DROP TABLE dbo.SalesByQuarter
GO