Microsoft Office Communications Server

Unable to access a Google product

1.Sign In Google+ and Reset you Passwod

Top Tax-Saving Investments

Multiple options. Contradictory advice. And a deadline that's approaching fast. Many taxpayers find themselves in this situation at the beginning of the year when they have to make tax-saving investments.

Are you also confused? Before you make a choice, go through our cover story to know which is the best option for you. We have ranked 10 of the most common investments under Section 80C on five basic parameters: returns, safety, flexibility, liquidity and taxability. Every investment has its pros and cons.

The PPF may not have a very high return, but its tax-free status, flexibility of investment and liquidity by way of loans and withdrawals, gives it the crown in our beauty pageant. Equity-linked saving schemes come in second because of their high returns, flexibility, liquidity and tax-free status. However, traditional insurance policies, an all-time favourite of Indian taxpayers, manage the ninth place because of the low returns they offer and their rigidity.

Some readers might be surprised that the much reviled Ulips are in the third place. The Ulip remains a mystery and its returns are seldom tracked. We checked Morningstar's data on Ulips and found that the returns have not been very good in the past 1-5 years. Even so, it can be a useful instrument for the smart investor who shifts his money between equity and debt without incurring any tax.

We have tried to separate the chaff from the grain by assigning a star rating to the various tax-saving options. Whether you are a novice or a seasoned investor, you will find it useful. It will help you cut through the clutter and choose the investment option that best suits your financial situation.

The PPF is our top choice as a tax saver in 2014. It scores well on almost all parameters. This small saving scheme has always been a favourite tax-saving tool, but the linking of its interest rate to the bond yield in the secondary market has made it even better. This ensures that the PPF returns are in line with the prevailing market rates.

This year, the PPF will earn 8.7 per cent, 25 basis points above the average benchmark yield in the previous fiscal year. The benchmark yield had shot up in July and has mostly remained above 8.5 per cent in the past six months. Although the yield is unlikely to sustain at the current levels, analysts don't expect it to fall below 8.25 per cent within the next 2-3 months. So it is reasonable to expect that the PPF rate would be hiked marginally in 2014-15.

The PPF offers investors a lot of flexibility. You can open an account in a post office branch or a bank. However, the commission payable to an agent for opening this account has been discontinued, so you will have to manage the paperwork yourself. The good news is that some private banks, such as ICICI Bank, allow online investments in the PPF accounts with them. There's flexibility even in the quantum and periodicity of investment.

The maximum investment of Rs 1 lakh in a year can be done as a lump sum or as instalments on any working day of the year. Just make sure you invest the minimum Rs 500 in your PPF account in a year, otherwise you will be slapped with a nominal, but irksome, penalty of Rs 50. Though the PPF account matures in 15 years, you can extend it in blocks of five years each. However, this facility is no longer available to HUFs.

The PPF also offers liquidity to the investor. If you need money, you can withdraw after the fifth year, but withdrawals cannot exceed 50 per cent of the balance at the end of the fourth year, or the immediate preceding year, whichever is lower. Also, only one withdrawal is allowed in a financial year.

You can also take a loan against the PPF, but it cannot exceed 25 per cent of the balance in the preceding year. The loan is charged at 2 per cent till 36 months, and 6 per cent for longer tenures. Till a loan is repaid, you can't take more. If you dip into your PPF account, be sure to put back the amount at the earliest. Withdrawing from long-term savings is not a good strategy if you do it frequently. It can dent your overall retirement planning.

The PPF is especially useful for risk-averse investors, self-employed professionals and those not covered by the Employees Provident Fund and other retiral benefits.

BRIGHT IDEA: Invest before the 5th of the month if you want your contribution to earn interest for that month as well.

Internet to make money

Make & sell your apps

With so many smartphones and tablets, app development can be a very lucrative business. You can learn about developing apps online — there are various tutorials available for free. That's the easy part — the hard part is coming up with an idea that 'clicks'. Once you make an app, submit it to the respective app store, set a price and choose whether you want to earn from inapp advertising. Your earnings, after deducting the appropriate fees, will be paid monthly.

Sell your photos Online

Numerous stock websites like www.shutterstock. com, www.shutterpoint.com and www. istockphoto.com host photographs submitted by members. Depending on the site's policy, you can earn between a 15 to 85% royalty on each sale. The better the quality of photos and the larger your online portfolio, the more you will sell. Usually, each photograph you want to upload will have to be 'selected' by them first — and they usually have strict requirements of what can or cannot go on sale.

Self publish books

If you love writing and want to get a book published, Amazon offers a free service called Kindle Direct Publishing. The service allows anyone to self publish books on the Kindle (electronic) bookstore and earn royalties from sales. There are two plans you can choose from — the 35% royalty works across any book sold in any country) while the 70% royalty plans works if you sell in a few select countries. Indian authors can choose to set prices specifically for the Indian bookstore and receive royalty payments in Indian currency as well.

Work online for money

The internet is full of bogus companies that promise to pay you for work but never will. For instance, all places that offer money to fill surveys or those that require payment up front are scammers. Two popular & reliable places to find work are www. odesk.com and www.elance.com.

Both have a similar system: set up a profile and take tests to prove your proficiency in certain areas. Once done, you'll be listed as a contractor/freelancer and people can hire you for an hourly rate. You can get paid more by working hard, getting better at what you do and getting good feedback (ratings) from your clients.

E-Tutoring

If you are fluent in any subject and have some tutoring experience, you can sign up on websites like www.2tion.net or www.tutorvista.com as an online tutor. The sites require you to create a tutor profile with details such as the subjects in which you are fluent, what classes/courses you want to teach, your experience level, preferred timings for tutions and the remuneration expected.

The YouTube Community has flagged

Your account has received one Community Guidelines warning strike, which will expire in six months. Additional violations may result in the temporary disabling of your ability to post content to YouTube and/or the permanent termination of your account.
For more information on YouTube's Community Guidelines and how they are enforced, please visit the help center.
Please note that deleting this video will not resolve the strike on your account. For more information about how to appeal a strike, please visit this page in the help center. 

Let's see I know nothing about youtube content laws but I'll give it a shot.
1) If you get another one after that period they'll reinstate the 6 month warning strike again but the first one already expired so it won't be held against you.
2) They'll most likely disable your posting abilities or terminate your account entirely as they said.
3) Yes it'll go back to normal
4) It says it'll expire in 6 months so I'm guessing if you're missing posting abilities such as custom thumbnails they'll be back after 6 months.
DO NOT ADVOCATE THEPIRATEBAY ON ANYTHING, IT'S A SENSITIVE ISSUE EVERYWHERE ESPECIALLY YOUTUBE 

New Chromebooks, a better Chrome OS

Microsoft attacked the Chrome OS platform recently in a series of video ads integrated with its anti-Google ‘Scroogled’ campaign. The move was significant, as it suggested that if Chromebooks weren’t already flying off store shelves, Microsoft was worried that they soon would be.

In the US and the UK, Chromebooks frequently top Amazon’s best sellers list for notebooks. In the last 12 months, we’ve seen new Chrome OS-powered laptops from HP, Lenovo, Dell and Acer. Google also launched the gorgeous but expensive Chromebook Pixel and Toshiba will reportedly unveil a new Chromebook in early 2014 .

Laptop and desktop PC sales are on the decline, but clearly Google sees an opportunity to reinvigorate the form factor with Chrome OS. The price-tag is certainly tempting for many users, but it needs to build on the platform and prove that it’s an adequate substitute for Windows, Mac and Linux. Furthermore, expect Google to release some significant updates for Chrome OS and a renewed push for Chrome Apps (formerly called Packaged Apps).

As the platform picks up steam, we’re bound to see new Chromebooks from many of the major PC manufacturers. A successor to the Chromebook Pixel? Unlikely, but never say never…

How much database space is required during Index rebuild?

1. How much temporary space is required to create or rebuild a index ?
2. Whether it matters if you are creating/rebuilding a unique or a non-unique index ?
3. Whether it matters if you are creating/rebuilding an index on a partitioned or a non-partitioned table ?
4. Whether it matters if the index is a narrow single column index or a wide index that encompasses all the columns in the table  ?
5. Whether it matters if the index has included columns ?
6. What is the effect on the amount of temporary space and performance if you want the maximum concurrency while creating/rebuilding an index ?
7. What is the effect on performance and concurrency if you want to use the least amount of temporary space ?

Let’s us understand this via practical example

These are the Table specifications, where we wanted to create a index

• Size of the table = 1159633 pages = 8.85 GB
• Number of rows in the table = 179743073
• Size of each row = 42 bytes
• Number of columns in the index = 3 => 10 bytes

Here are the Results

1. Size of the clustered index created = 1159650 pages = 8.85 GB
2. Size of the mapping index in the TEMPDB = 603848 pages = 4.6 GB (approximately 52% of the index size)
3. Space used in TEMPDB for the sort runs = 1293728 pages = 9.88 GB (approximately 112% of the index size)
4. Total space used in TEMPDB = 1897576 pages = 14.48 GB (approximately 164% of the index size)

What are the main differences between #temp tables and @table variables and which one is preferred ?

1. SQL Server can create column statistics on #temp tables
2. Indexes can be created on #temp tables
3. @table variables are stored in memory up to a certain threshold.

For many other question and more information on temporary table and variable.

Temporary tables are a useful tool in SQL Server provided to allow for short term use of data. These are like other User table where we can store data but only for temporary purpose. These temporary tables data, structure and related objects like Indexes keys etc are automatically gets drop by SQL Server, once the user get disconnect from the Server.

These temporary tables are like other tables in SQL Server where you can

• Add/drop constraints except foreign key
• You can perform DDL statements (Alter, Drop)
• Create clustered and non-clustered indexes
• Use identity columns
• Use it in transaction and it support transaction
• Perform any DML operations (SELECT, INSERT, UPDATE, DELETE)
• Create the table with same name using different session; make sure constraint name must be different in the table.

Temporary tables are similar to temporary Tables but with following restrictions

• You can not create non-cluster index and statistics on table variable but you can create it on temporary table.
• You can not use DDL statement on table variable but you can use it on temporary table.
• Table variable doesn’t support transaction whereas temporary table supports.

What are different Types of Join?

1. Cross Join A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table. The common example is when company wants to combine each product with a pricing table to analyze each product at each price.
2. Inner Join A join that displays only the rows that have a match in both joined tables is known as inner Join. This is the default type of join in the Query and View Designer.
3. Outer Join A join that includes rows even if they do not have related rows in the joined table is an Outer Join. You can create three different outer join to specify the unmatched rows to be included:
   1. Left Outer Join: In Left Outer Join all rows in the first-named table i.e. "left" table, which appears leftmost in the JOIN clause are included. Unmatched rows in the right table do not appear.
   2. Right Outer Join: In Right Outer Join all rows in the second-named table i.e. "right" table, which appears rightmost in the JOIN clause are included. Unmatched rows in the left table are not included.
   3. Full Outer Join: In Full Outer Join all rows in all joined tables are included, whether they are matched or not.
4. Self Join This is a particular case when one table joins to itself, with one or two aliases to avoid confusion. A self join can be of any type, as long as the joined tables are the same. A self join is rather unique in that it involves a relationship with only one table. The common example is when company has a hierarchal reporting structure whereby one member of staff reports to another. Self Join can be Outer Join or Inner Join.

What is Data-Warehousing?

1. Subject-oriented, meaning that the data in the database is organized so that all the data elements relating to the same real-world event or object are linked together;
2. Time-variant, meaning that the changes to the data in the database are tracked and recorded so that reports can be produced showing changes over time;
3. Non-volatile, meaning that data in the database is never over-written or deleted, once committed, the data is static, read-only, but retained for future reporting.
4. Integrated, meaning that the database contains data from most or all of an organization’s operational applications, and that this data is made consistent.

What is Magic Tables in SQL Server ?

The MAGIC tables are automatically created and dropped, in case you use TRIGGERS. SQL Server has two magic tables named, INSERTED and DELETED

These are mantained by SQL server for there Internal processing. When we use update insert or delete on tables these magic tables are used.These are not physical tables but are Internal tables.When ever we use insert statement is fired the Inserted table is populated with newly inserted Row and when ever delete statement is fired the Deleted table is populated with the delete

d row.But in case of update statement is fired both Inserted and Deleted table used for records the Original row before updation get store in Deleted table and new row Updated get store in Inserted table.

What is a self join? Explain it with an example.

Self join is just like any other join, except that two instances of the same table will be joined in the query. Here is an example: Employees table which contains rows for normal employees as well as managers. So, to find out the managers of all the employees, you need a self join.

CREATE TABLE emp

(

empid int,

mgrid int,

empname char(10)

)

INSERT emp SELECT 1,2,’Vyas’

INSERT emp SELECT 2,3,’Mohan’

INSERT emp SELECT 3,NULL,’Shobha’

INSERT emp SELECT 4,2,’Shridhar’

INSERT emp SELECT 5,2,’Sourabh’

SELECT t1.empname [Employee], t2.empname [Manager]

FROM emp t1, emp t2

WHERE t1.mgrid = t2.empid

Here is an advanced query using a LEFT OUTER JOIN that even returns the employees without managers (super bosses)

SELECT t1.empname [Employee], COALESCE(t2.empname, ‘No manager’) [Manager]

FROM emp t1

LEFT OUTER JOIN

emp t2

ON

t1.mgrid = t2.empid

What is OSQL utility ?

OSQL is command line tool which is used execute query and display the result same a query analyzer but everything is in command prompt.

In what sequence SQL statement are processed?

The clauses of the select are processed in the following sequence

1. FROM clause
2. WHERE clause
3. GROUP BY clause
4. HAVING clause
5. SELECT clause
6. ORDER BY clause
7. TOP clause

What is the Difference between COALESCE() & ISNULL() ?

ISNULL accepts only 2 parameters. The first parameter is checked for NULL value, if it is NULL then the second parameter is returned, otherwise it returns first parameter.

COALESCE accepts two or more parameters. One can apply 2 or as many parameters, but it returns only the first non NULL parameter,

What sp_MSforeachtable does ?

You can use sp_MSforeachtable undocumented stored procedure to rebuild all indexes in your database. Try to schedule it to execute during CPU idle time and slow production periods.

sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’)”

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

An extended stored procedure is a function within a DLL (written in a programming language like C, C++ using Open Data Services (ODS) API) that can be called from T-SQL, just the way we call normal stored procedures using theEXEC statement. See books online to learn how to create extended stored procedures and how to add them to SQL Server.

Yes, you can instantiate a COM (written in languages like VB, VC++) object from T-SQL by using sp_OACreatestored procedure.

Also see books online for sp_OAMethod, sp_OAGetProperty, sp_OASetProperty, sp_OADestroy.

What are the different type of normalization?

In database design , we start with one single table, with all possible columns. Lot of redundant data would be present since it’s a single table. The process of removing the redundant data, by splitting up the table in a well defined fashion is called normalization.
	1. First Normal Form (1NF)
	A relation is said to be in first normal form if and only if all underlying domains contain atomic values only. After 1NF , we can still have redundant data
	2. Second Normal Form (2NF)
	A relation is said to be in 2NF if and only if it is in 1NF and every non key attribute is fully dependent on the primary key. After 2NF , we can still have redundant data
	3. Third Normal Form (3NF)
	A relation is said to be in 3NF if and only if it is in 2NF and every non key attribute is non-transitively dependent on the primary key

How can I convert data in a Microsoft Access table into XML format?

The following applications can help you convert Access data into XML format: Access 2002, ADO 2.5, and SQLXML. Access 2002 (part of Microsoft Office XP) enables you to query or save a table in XML format. You might be able to automate this process. ADO 2.5 and later enables you to open the data into a recordset, then persist the recordset in XML format, as the following code shows
rs.Save "c:\rs.xml", adPersistXML You can use linked servers to add the Access database to your SQL Server 2000 database so you can run queries from within SQL Server to retrieve data. Then, through HTTP, you can use the SQLXML technology to extract the Access data in the XML format you want.

Could you please explain, how to use Cursors ?

1. Declare a CURSOR
2. OPEN a CURSOR
3. FETCH data in CURSOR
4. finally close CURSOR

DECLARE @AccountID INT
DECLARE @getAccountID CURSOR
SET @getAccountID = CURSOR FOR
SELECT Account_IDFROM AccountsOPEN @getAccountIDFETCH NEXTFROM @getAccountID INTO @AccountIDWHILE @@FETCH_STATUS = 0BEGIN
PRINT @AccountIDFETCH NEXTFROM @getAccountID INTO @AccountIDEND
CLOSE @getAccountIDDEALLOCATE @getAccountID

What is a Manifest?

An assembly manifest contains all the metadata needed to specify the assembly's version requirements and security identity, and all metadata needed to define the scope of the assembly and resolve references to resources and classes. The assembly manifest can be stored in either a PE (Portable Executable) file (an .exe or .dll) with Microsoft intermediate language (MSIL) code or in a standalone PE (Portable Executable) file that contains only assembly manifest information. The following table shows the information contained in the assembly manifest. The first four items the assembly name, version number, culture, and strong name information make up the assembly's identity. 
Assembly name: A text string specifying the assembly's name. 
Version number: A major and minor version number, and a revision and build number. The common language runtime uses these numbers to enforce version policy. 
Culture: Information on the culture or language the assembly supports. This information should be used only to designate an assembly as a satellite assembly containing culture- or language-specific information. (An assembly with culture information is automatically assumed to be a satellite assembly.) Strong name information: The public key from the publisher if the assembly has been given a strong name. List of all files in the assembly: 
A hash of each file contained in the assembly and a file name. Note that all files that make up the assembly must be in the same directory as the file containing the assembly manifest. 
Type reference information: Information used by the runtime to map a type reference to the file that contains its declaration and implementation. This is used for types that are exported from the assembly. 
Information on referenced assemblies: A list of other assemblies that are statically referenced by the assembly. Each reference includes the dependent assembly's name, assembly metadata (version, culture, operating system, and so on), and public key, if the assembly is strong named.

What is Lock Escalation?

Lock escalation is the process of converting a lot of low level locks (like row locks, page locks) into higher level locks (like table locks). Every lock is a memory structure too many locks would mean, more memory being occupied by locks. To prevent this from happening, SQL Server escalates the many fine-grain locks to fewer coarse-grain locks. Lock escalation threshold was definable in SQL Server 6.5, but from SQL Server 7.0 onwards it’s dynamically managed by SQL Server.

All About Internet Marketing

Let me first explain in short where we stand today. Internet marketing has become the most important tool and the most valuable part of an marketing plan of any prospering business today. This is true especially in the tourist and particularly in the scuba diving and accommodation industry. And that’s where we come in! We specialize since many years in promoting dive centers, resorts and hotels. Right now, at this very moment, thousands of potential customers are using the internet to search for scuba diving courses, diving equipment and new dive sites, they search for diving vacations, diving lessons and other scuba diving related keywords and phrases in other words, they search the very things YOU offer! Now, if your website is not on the first page of Google, it’s your loss! And this means that the time as come to move things forward and ask yourself some serious questions about your internet marketing strategies, and make sure you get the right answers! Here are the most important ones.

1. Search Engine Optimization (SEO)

The most imminent questions must be;

• Will your potential customers find YOU before they find your COMPETITORS?
• Are you on the first page of Google when you search for your product and services with the top key phrases?
• Do you know how many websites link back to your website; more than to your competitors?
• Is your site really search engine optimized in every possible way?

But not enough with these 4 important questions. If it where that easy, we would soon be out of a job! Once your website is optimized for search engines, you need to do a more things to gain top positions for your website. Therefore there will be a few more questions you must ask yourself here:

2. Selling and Following Up

• First of all; does your website sell your products and services, or do you only get an inquiry every then and when?
• Do you have quality content (text, images, video) on your website to attract visitors and keep them busy on your site for as long as possible?
• Does your website show an appealing description in the search results pages of Google so that people want to click on it?
• Do you have a good punchline on your website, letting you stand out and making you different from your competitors?
• Does your site have a great looking landing page where visitors are invited to contact you with only one easy click on a button?
• Does your landing page have a “Call to Action” button that literally screams “CLICK ME”?
• Is it from every page ‘one click’ easy to contact you through your website?
• Is your website easy to navigate, can all important pages be found and accessed easily?
• Do you still have a business email address ending with @hotmail.com or @yahoo.com or a gmail address instead of your domain name?
• Can visitors easily sign up for your newsletter and do you send regularly newsletters to your customers?

3. Syndication of your Website

Get it Out there! Once you got the above two points right, it’s time to syndicate your website and use social media marketing and social network marketing to bring your business up to speed;

• Is there a well visible place on your site, where visitors can sign up for your newsletter, so you can follow up with your offers?
• Are there social bookmarking and social media buttons or widgets on your web pages, so visitors can tell their friends about you and share your site on their Facebook profile?
• Do you have a business page on Facebook with leads visitors from Facebook to your website?
• Do you have a RSS feed like Google Feedburner installed on your website which syndicates your content in the modern internet?
• Are you using Onlywire or other social bookmarking services to distribute your content throughout the social networks?
• Are you pinging new content so it can be easily picked up by search engine bots as soon as you published it?
• Are you on Twitter and are you regularly tweeting?
• Do you write a press release about your diving business at least every three month?
• Are you using Google Maps to rank in local searches?

4. Tracking your Results

After you answered all the previous questions about internet marketing, SEO and your website with yes, you’re not yet exactly finished. Now that everything is set to perfectly work, we need to know what’s going on as soon as the first results run in which means it’s time for result tracking, so that your efforts will be rewarded and you can make corrections to your campaigns to make them even more successful. The questions you must ask here are as follows:

• First and utmost; is the Google tracking code installed throughout your website?
• Do you have additional and accurate statistics installed for your site?, to not only trust one source of result tracking
• Do you know where your visitors come from and what pages on your site they stayed on longest?
• Do you use Google AdWords to test your campaigns and landing pages?
• Have you got Free Live Chat installed on your website?
• And finally; can you see the return of interest (ROI) of your efforts in your online marketing campaigns?

Fact is, there are Five Places in the Internet where your business MUST be seen!

Today everyone uses Google, Youtube, Twitter and Facebook to search for whatever they desire, don’t you too? For dive centers, sailing charter, hotels and other accommodation businesses, there is fifth entity that you simply cannot overlook anymore; TripAdvisor! We like to call them the big five. Sure, there is Yahoo and Bing and thousands of social networks around the web, but all of them together will never be able to drive as many potential clients to your website as the big five will do, not when you’re in the tourist industry at least.. Once you have a great website and you are at the first page of Google, on a top spot of Youtube and have a well made Facebook page, all other search engines and many networks will pick your site up automatically or with far less extra effort.

How to get there

Now, if you have come that far in my article and you remain with one last question in your head saying: “How in the world am I going to do all this; I have a JOB!?” No worries, we can help! ONE Internet Marketing Co., Ltd. is very successful in internet marketing for dive centers, accommodation and sailing on the big five, for many years now. We are highly passionate about online marketing and we know almost every place on the internet that could sell or promote your dive center or dive school. We also achieve top rankings in Yahoo, Bing and other search engines, although we use many social networks such as Taucher.net Twitter, Blogspot and WordPress, to promote our clients services. Our main efforts will always go towards the big five, simply because the majority of the people will sooner or later search there too if they haven’t come there in the first place. Wherever they may search for scuba diving courses or their next diving holiday destination, as long as it is in the internet, they will sooner or later search on Google, Youtube, Facebook or TripAdvisor too.

Reaching beyond Internet Marketing – Complete Internet Marketing Solutions

We’re not just an internet marketing company, we are your personal full service online marketing partner – All in ONE for an affordable price! is our Motto. We live and breathe the internet and will explore every opportunity online to generate sales for your dive center. You will save time, stress & money by consolidating all your internet needs with one trusted company. ONE Internet Marketing is rapidly expanding the team of professionals who have years of experience in Internet Marketing & SEO, as well as in scuba diving on professional level!

About Internet Marketing Prices

Our prices are far lower than our competition, I can tell you that right away! The reason for this is rather simple. While we deliver the same quality work as a company in New York City, we choose to live on a place where expenses are lower than in the US or in Europe, while the technical backbone and the living standard remain the same. This does nothing but positively influence our work and our enthusiasm in the subject of diving. We are situated in Koh Tao and Koh Phangan, in Thailand and we are basically surrounded by dive centers and dive resorts. ONE Internet Marketing Co., Ltd. combines the knowledge of web marketing and scuba diving and is therefore your best choice for successful online marketing of your dive center.

We offer the following services:

• Complete Marketing and Keyword Research
• Graphic & Logo Design
• Web Design and Development
• Search Engine Optimization
• Search Engine Marketing
• Social Media Marketing
• Social Network Marketing
• Newsletter Marketing
• Social Bookmarking
• Content Creation
• Back Link Building
• Google AdWords Campaigns/PPC
• Facebook Pages that Rock!
• HTML to WordPress Conversion
• SSL Certification & Dedicated IPs
• Cheap Web Hosting
• Perfect Result Tracking

About Search Engine Optimization (SEO)

The most imminent questions must be;

• Will your potential customers find YOU before they find your COMPETITORS?
• Are you on the first page of Google when you search for your product and services with the top key phrases?
• Do you know how many websites link back to your website; more than to your competitors?
• Is your site really search engine optimized in every possible way?

But not enough with these 4 important questions. If it where that easy, we would soon be out of a job! Once your website is optimized for search engines, you need to do a more things to gain top positions for your website. Therefore there will be a few more questions you must ask yourself here:

Internet Marketing Tips

Basic On-Site SEO Tip:  Two months ago, we helped a real estate client by doing two things:  Adding Real Estate Schema to their property level listings and trained their in-house marketing assistant on basic SEO tactics.  The client is thrilled with the results, a definite increase in leads and traffic over previous years.

If your site is dynamic and ever changing keeping up on your basic on-page SEO can have a big impact, if you have someone in-house who is savvy with time to spare – call Mannix Marketing for a one-on-one training session, this combined with some expert SEO can have a big impact.

Print it Everwhere Internet Marketing Tip:  This is an oldie but a goody. Every time you get something reprinted, make sure that your website address gets listed on it. For example, if you’re a restaurant, print your address on your menus, brochures, business cards, signage, advertising, email signature, door, handouts, hats and t-shirts! Don’t forget receipts – almost everyone walks out with one! If you are a shopping site, make sure your invoices, shipping labels, boxes, envelopes, catalogs, everything has your address. If you have a bricks and mortar location, is your address on your advertising sign? Your door with your store hours?

Check for the Basics Tip:  Does your site contain all the basics? Hours, phone number and address… all pertinent contact information. Is it easy to navigate? Allow secure purchases? For the tourist industry, does it allow secure purchase of gift certificates? Invite comments? (You can learn a lot from a contact us page.) If you are a restaurant, do you have your menus, special events, directions, banquet menus online? Do you visually sell the restaurant? Allow online sign up for email specials? What about take out menus? An email sign up would be perfect for this if it is a big part of your business. Does the site list a dress code? How to make a reservation? And don’t forget added benefits for you: links to other area businesses, employment opportunities, printable employment applications. Good Internet marketing will impress your market audience and provide you with a website that does more than look pretty.
Keyword Research Tip:  The first step to any Internet marketing campaign is the keywords. How will potential customers find you in the search engines? Work with different keyword combinations to determine the keywords you want to be found under. Make sure you balance broader keyword combinations with more specific keyword combinations. The average person searching on the Internet may start with a broad query, but they quickly narrow it down as they see returned results and learn more about what they are searching for. For example, someone searching for digital cameras may start with “Digital Cameras”… after clicking a couple choices, they may then search on “Nikon digital cameras”… after clicking a couple more choices, they may search on Nikon Coolpix cameras, then narrow it even further to Nikon Coolpix 4800 Digital Camera. The more specific they become, the more likely they are to purchase.

My favorite way to find new keywords quickly is the Google Spacebar Keyword Research Tip: type in your keyword in Google then hit the spacebar, more keyword suggestions will come up, hit the spacebar and a letter like

SEO A - gives me suggestions for seo audit, seo analyzer, seo articles etc…  all sorts of ideas for what I might want to be found under.

Competitive Research Tip using Evernote:  A basic component of any marketing strategy is to know your competition. This is especially true in Internet marketing. Do an online search for the keywords you want to be found under. Who is your competition? What is their pricing structure? What keywords do they target? Honestly appraise their site against your own. Is their site better than yours? Why? What do they do better on their site that you may be able to improve upon on your site? Is their site more informative? Is it easier to navigate?Then …. do they have a newsletter you can sign up for?  – you can sign up for an evernote account, and sign up for the enewsletter with that email address, then every one of their enewsletters will be saved in your evernote account – this is great for research.  You can go back years and see what they promote at different times of year (heard this tip from LinkLove).

Write a Blog Tip:  Are you the “expert” in your industry? If so, share your knowledge on your site. Write feature articles for your website. Volunteer to write articles for others with the stipulation that they link back to your website and your business. This is a great way for you to not only improve traffic to your website, but improve brand recognition for your company.  Fresh content and quality content will improve traffic to your site.  Don’t forget to have Mannix Marketing help you set up your Google+ Authorship!
Tip:  Build Loyalty and Top of Mind Awareness through Email Campaings: Your customer base may know who you are, but do they think of you FIRST when they need your type of product? If not… keep your business in the minds of anyone who has been to your site or business through email marketing. Offer a sign-up on your site so they can be the first to find out about your new products. Offer “weekly tips”, or send out monthly coupons. Make sure you only send email to those you’ve requested it through your site. And, make sure the email has a BENEFIT for the customer… not just free publicity for you.
TRACK YOUR WEBSITE STATISTICS AND ANALYZE!!!

Most hosting packages come with stats. Google Analytics is also a great program, we like to set up both server side stats and Google Analytics.  Don’t just look at hits – look at unique visitors, referrers, exit and entry pages, time spent on site, and keyword combinations used to arrive at your site and goals.

Any site that can measure a conversion (a sign up, a purchase, an action) should truly analyze traffic patterns, keywords and pay per click programs with a good tool. Not sure how to track conversions, ask Mannix Marketing, we have lots of options for you!
HANDY RESOURCES FOR THE “DO IT YOURSELFER”

ASP.Net MVC Questions and Answers

1. Explain MVC (Model-View-Controller) in general?

Model-View-Controller (MVC) is an architectural software pattern that basically decouples various components of a web application. By using the MVC pattern, we can develop applications that are more flexible to changes without affecting the other components of our application.

• "Model",is basically domain data.
• "View" is the user interface to render the domain data.
• "Controller" translates user actions into appropriate operations performed on the model.

2. What is ASP.NET MVC?

ASP.NET MVC is a web development framework from Microsoft that is based on the Model-View-Controller (MVC) architectural design pattern. Microsoft has streamlined the development of MVC based applications using the ASP.NET MVC Framework.

3. What are the differences between ASP.NET MVC and ASP.NET WebForms?

ASP.NET Web Forms use the Page Controller Pattern for rendering layout, whereas ASP.NET MVC uses the Front Controller approach. In the case of the Page Controller Pattern, every page has its own Controller, in other words a code-behind file that processes the request. On the other hand, in ASP.NET MVC, a common Controller for all pages processes the requests.

Follow the link for the difference between the ASP.NET MVC and ASP.NET WebForms.

4. What are the Core features of ASP.NET MVC?

The core features of the ASP.NET MVC Framework are:

• Clear separation of application concerns (Presentation and Business Logic)
• An extensible and pluggable framework
• Extensive support for ASP.NET Routing
• Support for existing ASP.NET features

Follow for detailed understanding of above mentioned core features.

5. Can you please explain the request flow in the ASP.NET MVC framework?

The request flow for the ASP.NET MVC Framework is as follows.

The request hits the Controller coming from the client. The Controller plays its role and decides which model to use to serve the request, further passing that model to the View that then transforms the model and generates an appropriate response that is rendered to the client.

6. What is Routing in ASP.NET MVC?

In the case of a typical ASP.NET application, incoming requests are mapped to physical files such as an .aspx file. The ASP.NET MVC Framework uses friendly URLs that more easily describe the user's action but are not mapped to physical files.

The ASP.NET MVC Framework uses a routing engine that maps URLs to Controller classes. We can define routing rules for the engine, so that it can map incoming request URLs to the appropriate Controller. 

Practically, when a user types a URL in a browser window for an ASP.NET MVC application and presses the "go" button, the routing engine uses routing rules defined in the Global.asax file to parse the URL and determine the path of the corresponding Controller.

7. What is the difference among ViewData, ViewBag and TempData?

To pass data from a Controller to a View and in a subsequent request, The ASP.NET MVC Framework provides various options, in other words ViewData, ViewBag and TempData.

Both ViewBag and ViewData are used to to communicate between Controller and corresponding View. But this communication is only for the server call, it becomes null if the redirect occurs. So, in short, it's a mechanism to maintain state between Controller and corresponding View.

ViewData is a dictionary object while ViewBag is a dynamic property (a new C# 4.0 feature). Since viewData is a dictionary object it is accessible using strings as keys and also requires typecasting for complex types. On the other hand, ViewBag doesn't have typecasting and null checks.

TempData is also a dictionary object that persists for the life of a HTTP Request. So, Tempdata can be used to maintain data between redirects, in other words from one Controller to another Controller.

8. What are Action Methods in ASP.NET MVC?

As previously stated about request flows in the ASP.NET MVC Framework, a request coming from a client hits the Controller first. Actually the MVC application determines the corresponding Controller using routing rules defined in Global.asax. And Controllers have specific methods for each user actions. Each request coming to the Controller is for a specific Action Method. The following code example, "ShowBooks" is an example of an Action Method.

public ViewResult ShowBooks(int id)
{
    var computerBook = db.Books.Where(p => P.BookID == id).First(); 
    return View(computerBook);
}

9. Explain the role of Model in ASP.NET MVC?

One of the core features of ASP.NET MVC is that it separates the input and UI logic from business logic. The role of the Model in ASP.NET MVC is to contain all application logic including validation, business and data access logic except View. In other words input and Controller; in other words UI logic.

The Model is normally responsible for accessing data from some persistent medium such as a database and manipulates it.

10. What are Action Filters in ASP.NET MVC?

If we need to apply some specific logic before or after action methods then we use action filters. We can apply these action filters to a Controller or a specific Controller action. Action filters are basically custom classes that provide a way for adding pre-action or post-action behavior to Controller actions.

For example:

• An Authorize filter can be used to restrict access to a specific user or a role.
• An OutputCache filter can cache the output of a Controller action for a specific duration.

Tag: .NET Framework 3.5, ASP.NET MVC, ASP.net MVC 3,ASP.NET MVC Framework Asp.net mvc3asp.net mvc3 Razor Aspx page AuthenticateRequestCab Automation Software crud CRUD operation,Cshtml, Engine with Entity Framework 4.0,HttpHandlers, JQ grid with Jquery in asp.net mvc3, Razor,JSON ,Model View Control, model view controller,MVC 3 ,mvc application, MVC Design pattern, MVC3 routing ,Unity Framework ,View