SEO with Twitter
Google loves Twitter…and other micro blogs.
My aim is to build a Twitter SEO community to trade twitter posts. Using different techniques – URLs in the posts, keywords in the URLs, URLs in the URLs…we can test which methods work best.
No black or gray SEO, but trading actual Twitters amongst friends to promote a project or client. Twitter should be as natural as possible without keyword stuffing. We can share results and build a process that will work on many social media sites and micro blogs.
SEO and Twitter: This is some cool stuff that really works. You can beat you head to register on a bunch of crappy directories (I’ll help you do that on the cheap, email me.) or you can get creative and establish a some easy to come by natural links. My experience with Twitter shows it is possible.
If you are SEO savvy, you need to try out different techniques with RSS, anchor text and URL placement to see what works best.
12 SEO
Tactics of SEO :
1. The Meta Keywords, Description and Robots tag — Google used description copy to market your site in its results, treat this as optimized sales copy. Make sure your sitemap.xml page is CONSTANTLY called up to the search engines
2. The Title Tag – The MOST important aspect of on-page SEO, just take our word for it.
3. The Body Text (focus on the body text in bold, for this denotes strong emphasis to the search engines)
4. The first sentence in the body text and the first words used per sentence are the most important ones for advanced on-page SEO necessities (Make it humanly readable and SE readable — The words used in the first sentence are most important due to the implementation of Google’s LSI algorithm)
5. The URL — The subdirectory folder and page of content should be SEO’d (i.e. http://domain.com/real-estate/real-estate-marketing-ideas.com would fetch a high ranking for a page dedicated to real estate marketing ideas – especially with many highly authoritative, relevant, deep in-bound links)
6. The H1 and H2 Texts are highly important – Why? They show the search engine the main subjects and Table of Contents for the content to be indexed. Make these keyword friendly and reflective of your page’s title tag.
7. Same Site Link Texts — The links connecting the pages of your site together must have your targeted keyword terms in them as well as all links throughout the site — even though it seems excessive, having variations to your targetted keywords would also help when linking out to other pages within your site.
8. Same-Site Link URLs — Not only should you be using your keywords to describe pages within your site, those URLs you link to must have SEO URLs ( eg: http://domain.com/your-keyword.html)
9. Outbound Link Text — Resources you link to must be SEO’d – If you are an internet marketing site and are linking to an email marketing company (email marketing software in this instance), you would use “Put your internet marketing on auto-pilot and use the best tool for internet marketers today – internet marketing email software. Then just use other variants to internet marketing.
10. IMG Alt Tags — Your images should be described via ALT Tags with the keywords you are optimizing for – If your image is hosted on your web-host, the file name of the images should also be SEO’d — If you have an image about polar bears have it be polar-bear.jpg in your images folder.
11. Keyword Density — 8% is excellent and doesn’t seem spammy, if you have a 500 word article, then 40 of those words should have variances of the search term you are targeting, if this seems excessive, lower the keyword density down to 5% and you will only need to add 25 variances/instances of your keyword. And that’s just a start… (Keyword prominence is big, but not worth a discussion).
12. Lastly and surprisingly, Your HTML comments should have your SEO terms in them (!!) — As a question to the relevancy this has to your ranking, I am unsure, but most of the large sites have html comments connected to their search terms. If you end up doing an analysis of your on-page content, you can find out if the high ranked sites for your keyword use HTML comments tagged to the keyword(s) being targeted.
Connection Strings SQL Server 2008
Standard Security
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Use serverName\instanceName as Data Source to connect to a specific SQL Server instance.
Are you using SQL Server 2008 Express? Don’t miss the server name syntax Servername\SQLEXPRESS where you substitute Servername with the name of the computer where the SQL Server Express installation resides.
Standard Security alternative syntax
This connection string produce the same result as the previous one. The reason to include it is to point out that some connection string keywords have many equivalents.
Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;
Trusted Connection
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
Trusted Connection alternative syntax
This connection string produce the same result as the previous one. The reason to include it is to point out that some connection string keywords have many equivalents.
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
Connecting to an SQL Server instance
The syntax of specifying the server instance in the value of the server key is the same for all connection strings for SQL Server.
Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True;
Trusted Connection from a CE device
Often a Windows CE device is not authenticated and logged in to a domain. To use SSPI or trusted connection / authentication from a CE device, use this connection string.
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;User ID=myDomain\myUsername;Password=myPassword;
SQL Command
Example of SqlCommand…
Is necessary to inform the connection and the command that you want to execute.
::[Visual Basic]
Public Function ReadFromDB(ByVal connectionString As String) as SqlDataReader
Dim commandText As String = “SELECT * FROM dbo.Table”
Dim connection As New SqlConnection(connectionString)
Dim command As New SqlCommand(commandText, connection)
connection.Open()
Dim reader As SqlDataReader = command.ExecuteReader()
connection.Close()
return reader
End Function
::[C#]
private static SqlDataReader ReadFromDB(string connectionString)
{
string commandText = “SELECT * FROM dbo.Table”;
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(commandText, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
connection.Close();
return reader;
}
SQL Connection
SQL Connection
The SqlConnection (.NET Framework) object provides connectivity to Microsoft SQL Server version 7.0 or later and supports a connection string format that is similar, but is not identical, to the OLE DB (ADO) connection string format.
The following code example demonstrates how to create and open a connection to a SQL Server (version 7.0 or later) database.
::[Visual Basic]
Dim Conn As SqlConnection = New SqlConnection(“Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind”)
Conn.Open()
::[C#]
SqlConnection Conn = new SqlConnection(“Data Source=localhost; Integrated Security=SSPI;Initial Catalog=northwind”);
Conn.Open();
It is nice that you always close the Connection after using it. This can be done with the Close or Dispose methods of the Connection object.
Everything has a beginning …
What’s up!
Starting my blog …
I’ll include some .Net tips, basically the victories of the bizarre problems that we developers spend …
