Owner: Web Technologies URL:http://www.webteks.blogspot.com Join Date: Wed, 28 Feb 2007 23:29:47 -0600 Rating:0 Site Description: search engine optimization, internet, web development, programming, asp.net, sql server, ajax, javascript, css Site statistics:Click here
Optimizing for the Correct Keywords 1970-01-01 00:59:59 To get listed correctly in the search engines each page of your site that you want listed needs to be optimized to the best of your ability. Since the keywords that you decide to target will be used throughout the optimization process choosing the right keywords is essential. If you choose the wrong keywords you will not be found in the search engines. If you are not found in the search engines how will anyone find your site?Since the keywords you choose to optimize your pages with are so important we have put together some tips to help you make sure that you make the right choices. You should utilize these tips when selecting keywords for each page that you plan to submit to the search engines.Think "specific keyword phrases" not "keywords". Why? Due to the extreme amount of competition for general terms in the search engines, if your keyword phrases are too general it is very unlikely you will rank well in the search engines. You stand a far better chance to rank well for specific ph Read more:Correct
, Keywords
SEO - Meta Tags 1970-01-01 00:59:59 Let's recap what needs to be done before you attempt to create meta keyword tags: * Choose the relevant keywords. * Write the site's content based on these keywords. * Create a title tag using the same keywords. * Create a meta description tag as a marketing sentence, also based on these keywords. Once you do the above things properly, putting together your meta keyword tag is a very simple procedure.I usually begin putting the keywords I used in the title of my page in the meta keyword tag. The first words in any tag are assumed to be given more weight, so these are most important. Then I go through each paragraph of text on the page and take any important phrases that might be used in the copy and paste them into the meta keyword tag. I usually separate the phrases with a comma and no space. This is simply a personal preference. Using no commas at all in this tag is basically the same thing, since most engines appear to treat commas as a space. After I get every importa Read more:Meta Tags
, SEO
Optimize Images on website with "alt" Attribute 1970-01-01 00:59:59 Any images on webpage can help listings too. Each image on webpage can include a keyword phrase that relates to the image. This text will also show up & help those that may have their images turned off when visiting the website
. This does not work for all engines, but it certainly does not hurt so we recommend you give it a try where you can.It looks like:<IMG SRC="myimage.gif" width="15" height="15" alt="describe here! this is submission service">Where it belongs:You can add the "alt" attribute to any image on your page.Tag limits:We do not recommend using more than a brief sentence or two to describe an image. Read more:Attribute
, Images
Planning Search Engine Optimization 1970-01-01 00:59:59 Here are several tips for building you website with search engine optimization in your mind:a) Every page on your site must have a unique title tag, meta keywords tag, and meta description tag according to page.b) Follow W3C recommendations for HTML document structure. Begin the body copy of your page with your keyword phrase, and repeat it as needed as the theme of the page throughout your copy. Feature your keyword phrase prominently by including it in headers and making it bold or italics.c) Use text navigation on your site, and use the keyword phrases you have selected as the links. If you cannot use text navigation, include a footer on every page using text links.d) Build a text site map, and link to it from every page of your site.e) Organize your navigation according to the importance of your keyword phrases. If you break your site into many pages, link to the most important pages from every page of your site, and link to the other pages from section header pages and the site ma Read more:Engine
, Optimization
, Search
Free AJAX Resources: Source Code, Tools, Libraries and Frameworks - II 2007-03-03 04:15:00 The Code Project -Free articles & source code of Atlas and AJAX
Ajax.NET - A free library for the Microsoft .NET Framework -Examples using the free Ajax.NET libraryW3Schools.com -An AJAX tutorial from the helpful people at W3Schools.18-Week Free AJAX Programming (with Passion!) Online Course -The first session of this free online AJAX course is already underway, but there are slides and various other resources available. This is a Java site so the AJAX course ultimately involves JavaServer Faces and AJAX integration.Creating a MySQL connection with PHP/AJAX -This is a short ajax tutorial on opening a connection to MySql using ajax.Getting Started with Ajax -This article at A List Apart is an excerpt from the book Web Design in a Nutshell and covers using ajax with innerHTML and Nodes to manipulate page content dynamically.SAJAX -SAJAX is an open source tool to make programming websites using the Ajax framework also known as XMLHTTPRequest or remote scripting as easy as possible. Sajax Read more:Libraries
, Resources
, Source
, Source Code
, Tools
Free AJAX Resources: Source Code, Tools, Libraries and Frameworks - I 2007-03-02 15:42:00 AJAX web applications, made famous by GMail and Google Maps, seem to be the flavour of the month in some circles. Using a combination of HTML/XHTML, XML, CSS, DOM scripting via JavaScript, and XMLHttpRequest (for exchanging data with a server asynchronously), AJAX allows you to do many interactive things with your website, making it appear almost like a native application running on your system. Incidentally, in case you were wondering, AJAX is an acronym for "Asynchronous JavaScript and XML".If you are looking for a tutorial on Ajax, you might want to try the following online articles from IBM: * Mastering Ajax, Part 1: Introduction to Ajax * Mastering Ajax, Part 2: Making asynchronous requests with JavaScript and Ajax * Mastering Ajax, Part 3: Advanced requests and Responses in Ajax Free AJAX Toolkits, Frameworks, Libraries
and Source
CodeGoogle Web Toolkit - Build AJAX applications in the Java language Google Web Toolkit helps you in developing AJAX web applications li Read more:AJAX
, Resources
, Source Code
, Tools
Putting AJAX to Web Development 2007-03-02 10:28:00 AJAX Definition- AJAX (Asynchronous JavaScript and XML) is a web development technique for creating interactive web based applications that can asynchronously interchange data between server and clientHow it works? When an application uses AJAX, a new layer is added to the communication model. In the classic web application, communication between the client (the browser) and the web server were performed directly, using HTTP requests.When the visitor requests a page, the server will send the full HTML and CSS code at once. After the visitor fills in a form and submits it, the server processes the information and rebuilds the page. It then sends the full page back to the client. And so on.When using AJAX, the page is loaded entirely only once, the first time it is requested. Besides the HTML and CSS code that make up the page, some JavaScript files are also downloaded: the AJAX engine. All requests for data to the sever will then be sent as JavaScript calls to this engine. The AJA Read more:AJAX
, Development
, Putting
, Web Development
New Release: .NET Framework 3.0 2007-03-05 12:26:00 The Microsoft .NET Framework
3.0 (formerly WinFX), is the new managed code programming model for Windows. It combines the power of the .NET Framework 2.0 with four new technologies: Windows Presentation Foundation (WPF), Windows Communication Foundation (WCF), Windows Workflow Foundation (WF), and Windows CardSpace (WCS, formerly "InfoCard"). Use the .NET Framework 3.0 today to build applications that have visually compelling user experiences, seamless communication across technology boundaries, the ability to support a wide range of business processes, and an easier way to manage your personal information online. Now the same great WinFX technology you know and love has a new name that identifies it for exactly what it is – the next version of Microsoft’s development framework. This change does not affect the release schedule of the .NET Framework 3.0 or the technologies included as a part of the package.The .NET Framework 3.0Windows Communication Foundation: This suite of .NET te Read more:Release
Free Java E-Books 2007-03-12 11:10:00 Introduction to Programming Using JavaIntroduction to Computer Science using JavaExploring JavaEssentials of the Java Programming Language - Part 1Essentials of the Java Programming Language - Part 2Enterprise JavaBeans Read more:Books
Download free e-books 2007-03-12 10:25:00 Click here to download free e-books of AJAXClick here to download free e-books of HDD, Java, Excel, 3D Studio Max, Flash, Website Design Guide, C++, HTML, CGI Click here - Free Computer Books, Tutorials & Lecture Notes Read more:Download
Download Free E-Books of PHP 2007-03-13 18:08:00 Developing PHP Applications for IBM Data ServersProgramming PHPA Programmer's Introduction to PHP 4.0PHP 5 Power ProgrammingPractical PHP Programming Read more:Books
, Download
Operating Systems: An Intoduction 2007-03-15 18:56:00 You will find a decent introduction material that should give them a good grasp on the subject of operating systems.Topics covered include:- key concepts, resources and sharing, resource management and spooling- single task- multi tasking and multi user- processes and threads- memory and storages, physical and virtual- networks, services and protocols- security, super users, firewall View / Download A Short Introduction to OperatingSystems
(pdf format) Read more:Intoduction
, Operating Systems
Latest on Microsoft - .NET Framework 3.5 2007-03-16 18:45:00 .NET Framework
3.5 makes first appearance in CTPThis week released the Visual Studio codename "Orcas" March 2007 CTP and this is the first time that features from .NET Framework 3.5 have been included. Brief on .NET Framework 3.5Many ISV's, enterprises and even Microsoft
product teams are successfully building on the new features WF, WCF, WPF and CardSpace in the .NET Framework 3.0. Microsoft plans to continue to invest in the .NET Framework developer platform and in support of existing users the .NET Framework 3.5 has no serious breaking changes so existing applications built for .NET Framework 2.0 or .NET Framework 3.0 will continue to execute. The .NET Framework 3.5 adds new features in several major technology areas.Integration of Language Integrated Query (LINQ) and data awareness Support for Web 2.0 AJAX style applications and services in ASP.NET and WCFFull tooling support for WF, WCF and WPF including the new workflow-enabled services technologyNew classes in the base class
CSS: an introduction 2007-03-18 16:50:00 CSS stands for Cascading Style Sheets, another programming specification. CSS uses rules called styles to determine visual presentation. The style rules are integrated with the content of the web page in several ways. In this book, we will deal with style rules that are embedded in the web page itself, as well as with style rules that are linked to or imported into a web page. You will learn to write the style rules and how to import, link, or embed them in the web pages you make. In HTML, styles can be written into the flow of the HTML, or inline, as well.CSS can also be integrated into web pages in other ways. Sometimes you have no control over these rules. Browsers allow users to set up certain CSS style rules, or user styles, according to their own preferences. The user preferences can override style rules you write. Further, all browsers come with built-in style rules. Generally the built-in styles can be overridden in your CSS style rules. Built-in browser display rules are refer
Cross Browser Compatibility 2007-03-20 18:36:00 There are literally hundreds of web browsers in use around the world. All of them implement the W3C document standards a little differently. Web designers must wrestle with these differences to make a web site work. This article discusses the effect those different implementations has on design.What is Cross
Browser Compatibility?: If a web page is completely cross-browser compatible, it will look more or less the same in all of the existing web browsers. The most commonly used browsers are Internet Explorer, Netscape Navigator, Firefox and Opera.Each one of these browser implements HTML, JavaScript and Cascading Style Sheets (CSS) a little differently. Some difference only create cosmetic difference others can break the webpage. The situation gets worse because each browser is free to implement “enhancements” to the W3C standard version of each of these formats.Then to compound matters even more the underlying operating systems also creates difference in how the computer displays
MySQL Security Overview 2007-03-26 14:04:00 When should you start to worry about MySQL
security? When you start to use the MySQL server over an Internet connection. Why? Because that is when your MySQL server is going to be the most vulnerable to all kinds of attacks, such as alterations and denial of service.The security issues that we will be discussing here will relate only to the MYSQL Server, but must be taken in the context of securing the entire server host against the above mentioned attacks and others.How does MYSQL Security Work?: MYSQL security is based on the Access Control List (or ACL) for all connections, queries and many other operations that a user can perform. What does this mean? Well, it basically means that different users will have varying levels of access to certain databases and tables and that they will be limited to performing only certain operations. For example, a user with full privileges to a database will be able to perform a range of operations such as SELECT, DELETE, UPDATE and INSERT, while a us Read more:Overview
General Information MySQL 2007-03-31 06:27:00 Internals and Portability:Written in C and C++.Uses GNU Automake (1.4), Autoconf (Version 2.52 or newer), and Libtool for portability.Works on many different platforms; APIs for C, C++, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl.Fully multi-threaded using kernel threads, this means it can easily use multiple CPUs if available.Very fast B-tree disk tables with index compression and thread-based memory allocation system.Very fast joins using an optimised one-sweep multi-join, can mix tables from different databases in the same query.In-memory hash tables which are used as temporary tables.SQL functions are implemented through a highly optimised class library and should be as fast as possible!Usually there isn't any memory allocation at all after query initialisation. Security:All password traffic is encrypted connecting to a server.A privilege and password system that is very flexible and allows host-based verification. Scalability and Limits:Handles large databases. Maximum size fo Read more:General
, MySQL
Overview of the SQL Server Security Model 2007-05-31 10:17:00 Security is a major concern for the modern age systems, network, and database administrators. It is natural for an administrator to worry about hackers and external attacks while implementing security. But there is more to it. It is essential to first implement security within the organization, to make sure the right people have access to the right data. Without these security measures in place, you might find someone destroying your valuable data, or selling your company's secrets to your competitors, or someone invading the privacy of others. Primarily, a security plan must identify which users in the organization can see which data and perform which activities in the database.The SQL
Server Security ModelTo be able to access data from a database, a user must pass through two stages of authentication: one at the SQL Server level and the other at the database level. These two stages are implemented using logins names and user accounts, respectively. A valid login is required to conne Read more:Overview
SQL Server - Dealing with Comma Delimited Strings 2007-06-18 23:19:00 Comma separated data can come in many forms. It can be input, a text string stored in a column, or a number of other situations. This article will deal with two different comma separated data situations.Displaying Multiple Records from a Single RecordIn this situation there is a column in a table that holds a series of values that are separated by a comma. For each record, the comma separated column needs to be parsed apart and returned as separate row. So the final output record set will contain multiple records for a given single record stored in a SQL
Server table.To demonstrate this I will run the following code:set nocount on -- Create Example1 Table and Populate with Data create table Example1 (Id int, TypeOfValues varchar(20), ColumnOfValues char(30)) CREATE UNIQUE CLUSTERED INDEX ID_ind ON Example1(Id) WITH IGNORE_DUP_KEY insert into Example1 values(1, 'Colors','Red,Green,Blue,Black,White') insert Read more:SQL Server
Row_Number() function in SQL Server 2005 2007-08-17 23:44:00 As we all know, SQL
Server 2005 has new features when compared to SQL Server
2000. One of the features that we are going to discuss in this article is the Row_Number
() function
. SQL Server Database administrators and developers have been longing for this function for a long time--now the wait is over.Traditionally developers and Database administrators used temporary tables and co-related sub-queries to generate calculated row numbers in a query. Now SQL Server 2005 provides a function, which replaces all of the additional resources we used to generate row numbers.Let us assume that we have the following database [EMPLOYEE TEST] and the following table [EMPLOYEE] in the database. You can use the below query to create the database, table and all the corresponding rows.USE [MASTER]GOIF EXISTS (SELECT NAME FROM SYS.DATABASES WHERE NAME = N'EMPLOYEE TEST')DROP DATABASE [EMPLOYEE TEST]GOCREATE DATABASE [EMPLOYEE TEST]GOUSE [EMPLOYEE TEST]GOIF EXISTS (SELECT * FROM SYS.OBJECTS W
Dynamic Crosstab (Using Pivot in SQL Server)- How it works 2007-09-12 04:04:00 This example assumes the following statement taken from the first example using the pubsdatabase. The statement to execute crosstab is:EXECUTE crosstab 'select title from titles inner join sales on (sales.title_id=titles.title_id) group by title','sum(qty)', 'stor_id', 'stores'@pivot is the name of the pivot column from the table named in @table. From the statement aboveit is stor_id. The following statement creates an empty table named ##pivot with one column namedpivot.EXEC ('SELECT ' + @pivot + ' AS pivot INTO ##pivot FROM ' + @table + ' WHERE 1=2')The next statement populates ##pivot with the unique values from the @pivot column (stor_id)in the table named in @table (stores).EXEC ('INSERT INTO ##pivot SELECT DISTINCT ' + @pivot + ' FROM ' + @table + ' WHERE '+ @pivot + ' Is Not Null')The result of the statement above puts the following values in the table ##pivot:638070667067713178968042The following statement initializes the variable @sql to a single blank sp Read more:Dynamic
, Pivot
, SQL
, SQL Server
SQL SERVER - 2005 - T-SQL Script to Attach and Detach Database 2007-11-10 05:35:00 Following script can be used to detach or attach database. If database is to be from one database to another database following script can be used detach from old server and attach to new server.Process to move database :--Step 1 : Detach Database
using following scriptUSE [master]GOEXEC master.dbo.sp_detach_db @dbname = N'MyDB',@keepfulltextindexfile=N'true'GO--Step 2 : Move Data files and Log files to new location--Step 3 : Attach Database using following scriptUSE [master]GOCREATE DATABASE [MyDB] ON( FILENAME = N'C:DataMyDB_Data.mdf' ),( FILENAME = N'C:DataMyDB_Log.ldf' )FOR ATTACHGOIF EXISTS ( SELECT nameFROM master.sys.databases sdWHERE name = N'MyDB'AND SUSER_SNAME(sd.owner_sid) = SUSER_SNAME() )EXEC [MyDB].dbo.sp_changedbowner @loginame=N'sa',@map=falseGO Read more:SQL
Deploying ASP.NET Applications 2007-11-21 22:45:00 Introduction Before looking at the different steps involved in setting up and deploying an ASP.NET Web application, it is important to understand the difference between Setup and Deployment. Setup is an application or process that allows you to package up your application into an easy-to-deploy format, which can then be used to install the application on the target server. Deployment is the process of taking the application and installing it in on another machine, usually by the use of a setup application.At one time or another, most computer users would have experienced the dark side of installing Windows programs. For example, when you install a new version of your application, the installation program copies the new version of your dlls in the system directory and makes all the necessary registry changes. This installation might potentially have an impact on other applications running on the machine, especially if an existing application was using the shared version of the installed Read more:Applications
, Deploying