Tuesday, November 30, 2010

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

Sunday, November 28, 2010

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

Monday, November 22, 2010

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

Friday, November 12, 2010

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

Thursday, November 11, 2010

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

Wednesday, November 10, 2010

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

Thursday, November 4, 2010

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

Wednesday, November 3, 2010

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