Happy New Year 2011

The beginning of the new year is a great time to start fresh and work toward the things that you want from life. Pretty much everyone sets goals and objectives for the new year whether privately in their head or publicly to their friends and family.


New Year is a time for celebration, countdown parties, champagne, dancing and fireworks. It’s probably the biggest celebration of the year seeing the last few hours of the old year slip away and the start of a bright new year 2011.

But as with everything that comes to an end, it’s also a time to reflect on the year past and make plans for the year ahead.

Hours of happy times with friends and family
Abundant time for relaxation
Prosperity
Plenty of love when you need it the most
Youthful excitement at life's simple pleasures

Nights of restful slumber (you know - don't worry be happy)
Everything you need
Wishing you love and light

Years and years of good health
Enjoyment and mirth
Angels to watch over you
Remembrances of a happy years!

Merry Christmas

Wishing you all A Merry Christmas …

May you have a wonderful festive season 

SQL - Index

UNIQUE 

 

Creates a unique index on a table or view. A unique index is one in which no two rows are permitted to have the same index key value. A clustered index on a view must be unique. The Database Engine does not allow creating a unique index on columns that already include duplicate values, whether or not IGNORE_DUP_KEY is set to ON. If this is tried, the Database Engine displays an error message. Duplicate values must be removed before a unique index can be created on the column or columns. Columns that are used in a unique index should be set to NOT NULL, because multiple null values are considered duplicates when a unique index is created. 

 

CLUSTERED 

 

Creates an index in which the logical order of the key values determines the physical order of the corresponding rows in a table. The bottom, or leaf, level of the clustered index contains the actual data rows of the table. A table or view is allowed one clustered index at a time. For more information, see Clustered Index Structures. 

 

A view with a unique clustered index is called an indexed view. Creating a unique clustered index on a view physically materializes the view. A unique clustered index must be created on a view before any other indexes can be defined on the same view. For more information, see Designing Indexed Views. 

Create the clustered index before creating any nonclustered indexes. Existing nonclustered indexes on tables are rebuilt when a clustered index is created. 

If CLUSTERED is not specified, a nonclustered index is created. 

 

NONCLUSTERED 

 

Creates an index that specifies the logical ordering of a table. With a nonclustered index, the physical order of the data rows is independent of their indexed order.

 

For More Deatil

The partner transaction manager has disabled its support for remote/network transactions

First verify the “Distribute Transaction Coordinator” Service is
running on both database server computer and client computers
1.      Go to “Administrative Tools > Services”
2.      Turn on the “Distribute Transaction Coordinator” Service if it is not running If it is running and client application is not on the same computer as
the database server, on the computer running database server
1.      Go to “Administrative Tools > Component Services”
2.      On the left navigation tree, go to “Component Services > Computers
> My Computer” (you may need to double click and wait as some nodes
need time to expand)
3.      Right click on “My Computer”, select “Properties”
4.      Select “MSDTC” tab
5.      Click “Security Configuration”
6.      Make sure you check “Network DTC Access”, “Allow Remote Client”,
“Allow Inbound/Outbound”, “Enable TIP” (Some option may not be
necessary, have a try to get your configuration)
7.      The service will restart
8.      BUT YOU MAY NEED TO REBOOT YOUR SERVER IF IT STILL DOESN’T WORK
(This is the thing drove me crazy before)
On your client computer use the same above procedure to open the
“Security Configuration” setting, make sure you check “Network DTC
Access”, “Allow Inbound/Outbound” option, restart service and computer
if necessary.
On you SQL server service manager, click “Service” dropdown, select
“Distribute Transaction Coordinator”, it should be also running on
your server computer.
Hope it helps,

Reference URL

http://msdn.microsoft.com/en-us/library/aa561924%28v=bts.20%29.aspx

ASP.NET IIS Registration Tool – Aspnet_regiis.exe

When multiple versions of the .NET Framework are executing side-by-side on a single computer, the ASP.NET ISAPI version mapped to an ASP.NET application determines which version of the common language runtime (CLR) is used for the application. The ASP.NET IIS Registration Tool (Aspnet_regiis.exe) allows an administrator or installation program to easily update the script maps for an ASP.NET application to point to the ASP.NET ISAPI version that is associated with the tool. The tool can also be used to display the status of all installed versions of ASP. NET, register the ASP.NET version that is coupled with the tool, create client-script directories, and perform other configuration operations.

Problem Situation
I have faced one problem while deploying the website.
Actually I need to deploy a website on my computer where all the ASP.Net Framework are installed like 2.0, 3.5 and 4.0
After that I have installed the IIS on computer properly and I have deployed my website
My website is not working because my all the framework are not registered with my IIS Server. This is because my frameworks are installed before the IIS installation that why it is not registered with IIS server
Then I have to registered framework with IIS Server with the help of ASP.NET IIS Registration Tool (Aspnet_regiis.exe)
Reference URL: http://msdn.microsoft.com/en-us/library/k6h9cz8h(v=vs.80).aspx

Port Forwarding Quick Reference

Nokia Siemens Residential Router 1600

Port forwarding Quick Reference

There are few very IMP URL for Port Forwarding

A.)
Please open –>  http://192.168.1.1/main.html
Go to Option NAT under Advanced
if you don’t find option NAT under Advanced Option the go to Option B.)

B.)
For Virtual server –> 192.168.1.1/scvrtsrv.cmd?action=view
For Port triggering –> 192.168.1.1/scprttrg.cmd?action=view
For DMZ –> 192.168.1.1/scdmz.html.

for more detail

Mobipocket Reader

Hello Friends,

I have tried the Utility Mobipocket Reader, it really helpful for me….  

That’s why I am sharing with you all …

Mobipocket Reader easiest way to build, organize, read and annotate your entire eBook library. Get the Mobipocket eBook Reader on your Windows PC - it's free - and build up your library of eBooks, RSS eNews and eDocs using the #1 online ebookstore.

I have tried this and it 's really very helpful for your reading 

 

 

 

 

 

 

 

 

 

For more detail click here

ASP.NET SQL Server Registration Tool – Aspnet_regsql.exe

This tool is a part of Microsoft .Net framework and like other tools this tool is also located in [drive:]\%windir%\Microsoft.NET\Framework\version folder on your Web server.The ASP.NET SQL Server Registration tool is used to create a Microsoft SQL Server database for use by the SQL Server providers in ASP.NET, or to add or remove options from an existing database. You can run Aspnet_regsql.exe without any command-line arguments to run a wizard that will walk you through specifying connection information for your SQL Server installation, and installing or removing the database elements for the membership, role management, profile, Web Parts personalization, and health monitoring features. You can also run Aspnet_regsql.exe as a command-line tool to specify database elements for individual features to add or remove, using the options listed in the table below.


See the Reference URL for Detail

List of datatypes in SQL Server

We are using very few data type in SQL Server like INT, varchar,datetime etc
But there are currently 37 datatype supported by SQL Server 2008

See the below scripts

• exec sp_datatype_info
• select * from sys.types 
• exec sp_datatype_info_90 
• exec sp_datatype_info_100

Differences Between XHTML And HTML

XHTML is not very different from the HTML 4.01 standard.

The Most Important Differences:

• XHTML elements must be properly nested
• XHTML elements must always be closed
• XHTML elements must be in lowercase
• XHTML documents must have one root element

For more detail Click here

Working with Visual Studio 2010 - Part 1

SQL Server 2011-Denali

SQL Server code-named “Denali”

Microsoft SQL Server code-named “Denali” empowers organizations to be more agile in today’s competitive market. Customers can efficiently deliver mission-critical solutions through a highly scalable and available platform. Industry-leading tools help developers quickly build innovative applications while data integration and management tools help deliver credible data reliably to the right users and new user experiences expand the reach of BI to enable meaningful insights. With SQL Server code-named “Denali” customers will benefit from the following added investments:

• Enhanced Mission-Critical Platform: an enhanced highly available and scalable platform.
• Developer and IT Productivity: new innovative productivity tools and features.
• Pervasive Insight: expanding the reach of BI to business users and end-to-end data integration and management.

You can download CTP1 right away right now and install on your machine.

Book Online of SQL Server 2011 “Denali” is available here.
Installation guide for SQL Server 2011 “Denali” available here.

Reference URL

SQL Server : Find File Location for All Database

Here is the quick script I use find file location for all the database in my server instance.


SELECT Name, FileName FROM sysdatabases


if you have any other way to find please share!!!  

SQL Live Monitor

Hello Friends,
 
I have tried the Utility SQL Live Monitor, it really helpful for me….
That’s why I am sharing with you all …

Features

This tool is designed to provide realtime performance data on SQL Server, as well as data capture for offline analysis. The tools features are:

• Realtime SQL and System performance data
• Colour coded alerts
• Capture data logging to CSV - sample interval configurable
• PAL Perfmon counter logged to .blg or .csv for offline analysis using PAL - sample interval configurable
• Detailed view of certain SQL Areas via DMVs
• List Top 20 Queries by CPU, IO and Execution Count
• View SQL Waits by category
• View SQL Scheduler and CPU worker threads
• Monitor Kernel Pools and System PTE's
• Supports SQL 2000,SQL 2005, SQL 2008
• Captures data from local and remote servers
• Captures data from default and named instances (stand alone & clustered)
• Supports both SQL and Windows Authetication
• Supports x86 and x64
• No installation required
• Application small in size with minimal overhead when running
• Run multiple instances on same PC

For More Detail Click here

Downloads 

Documentations

Deployment of a Website on IIS

Hello Friends
These are really good Articles for Deployment of a Website on IIS

See below URLs

http://www.codeproject.com/KB/aspnet/DeployingatIIS.aspx#j


http://learn.iis.net/page.aspx/762/create-a-web-site/

Web Client Software Factory - Complete Information

Web Client Software Factory : URLs

Web Client Software Factory 

WCSF Documentation Production

Download :  Web Client Software Factory - February 2008

Summary of Installation Steps

Getting Started with the Web Client Software Factory - February 2008

Download : Enterprise Library 3.1 - May 2007

Guidance Automation Extensions - February 2008 Release and here

Guidance Automation Extensions 2008 and Guidance Automation Toolkit 2008

Microsoft Guidance Automation Extensions 2010 and Guidance Automation Toolkit 2010 

Quick Start 

Others

 
      Blog : Web Client Software Factory Blog

System Information for Windows

SIW - System Information for Windows  "Everything you want to know about your computer"

 
SIW is an advanced System Information for Windows tool that gathers detailed information about your system properties and settings and displays it in an extremely comprehensible manner.
SIW can create a report file (CSV, HTML, TXT or XML), and is able to run in batch mode (for Computer Software and Hardware Inventory, Asset Inventory Tracking, Audit Software Licenses, Software License Compliance).


The system information is divided into few major categories:

• Software Inventory: Operating System, Installed Software and Hotfixes, Processes, Services, Users, Open Files, System Uptime, Installed Codecs, Software Licenses (Product Keys / Serial Numbers / CD Key), Passwords Recovery.
• Hardware Inventory: Motherboard, CPU, Sensors, BIOS, chipset, PCI/AGP, USB and ISA/PnP Devices, Memory, Video Card, Monitor, Disk Drives, CD/DVD Devices, SCSI Devices, S.M.A.R.T., Ports, Printers.
• Network Information: Network Cards, Network Shares, currently active Network Connections, Open Ports.
• Network Tools: MAC Address Changer, Neighborhood Scan, Ping, Trace, Statistics
• Miscellaneous Tools: Eureka! (Reveal lost passwords hidden behind asterisks), Monitor Test, Shutdown / Restart.
• Real-time monitors: CPU, Memory, Page File usage and Network Traffic.

Read more here 

Download here

Visual Studio Programmer Themes Gallery

Website that makes it easy to download VS color scheme


Check out here 

  

Download and Share Visual Studio Color Schemes

New website that makes it easy to download and share VS color scheme

http://studiostyl.es/ enables you to easily browse and download Visual Studio color schemes that others have already created.

You can apply the setting through – Tool -- > Import and Export Setting

Code Converters

Hands up who wants to hand convert C# to VB.NET (or back again)? No? Well, we've got just the tools for you. These will do it automatically and won't cost you a penny!

Refer the below URL

http://www.developerfusion.com/tools/

Recursive Directory Info

Imports System
Imports System.IO

Public Class MainClass

  Shared Sub Main()

    Dim nameOfDirectory As String = "C:\"
    Dim myDirectory As DirectoryInfo
    myDirectory = New DirectoryInfo(nameOfDirectory)
    WorkWithDirectory(myDirectory)

  End Sub

  Shared Public Sub WorkWithDirectory(ByVal aDir As DirectoryInfo)
    Dim nextDir As DirectoryInfo
    WorkWithFilesInDir(aDir)
    For Each nextDir In aDir.GetDirectories
      WorkWithDirectory(nextDir)
    Next
  End Sub

  Shared Public Sub WorkWithFilesInDir(ByVal aDir As DirectoryInfo)
    Dim aFile As FileInfo
    For Each aFile In aDir.GetFiles()
      Console.WriteLine(aFile.FullName)
    Next
  End Sub

  
End Class



Reference URL

C# Code : Connection strings for SQL Server 2008

using System.Data.SqlClient;

private void ValidationFile()

{

 string FilePath = "";

 using (SqlConnection myConnection = new SqlConnection("Data Source=servername;Initial Catalog=db_name;User ID=user;Password=pass;"))

                {

 using (SqlCommand myCommand = new SqlCommand("select scanned_document_id, master_id, file_path from scanned_documents", myConnection))

                            {

                                myCommand.CommandType = CommandType.Text;

                                myConnection.Open();

                                using (SqlDataReader myReader = myCommand.ExecuteReader())

                                      {

                                            if (myReader.HasRows)

                                                  {

                                                       while (myReader.Read())

                                                           {

                                                               FilePath = 

                                                               myReader.GetString(myReader.GetOrdinal("file_path"));                           

                                                            }

                                                    }

                                       }

                              }

                }

 }