Handy SQL code when dealing with 2 tables

When deleting data that exists in both tables.

DELETE FROM TABLE1 A
WHERE EXISTS(
SELECT 1 FROM TABLE2 B
WHERE A.KEY1=B.KEY2
AND A.KEY2=B.KEY2)

When updating a field from another table.

UPDATE C
SET C.UPDATEFIELD=D.UPDATEFIELD
FROM TABLE1 C INNER JOIN TABLE2 D ON C.KEY1=D.KEY1 WHERE C.KEY2=’PARAMETER’

Advertisements

Extracts from Google Adwords Help Forum

Google adwords can be confusing at time especially when you don’t know how many keywords or ads you should create, let alone what to do with keywords and ads that just don’t perform. Take a look at the default values

* 25 campaigns
* 2000 ad groups per campaign
* 2000 keywords per ad group
* 50 ads per ad group (any format)
* About 50,000 keywords per account

But sometimes less is more.

AdWordsPro Sarah, a Google Employee since 2008 gives some decent advice on what/when to delete.
“The historical performance of paused or deleted ads and keywords will continue to affect your account history. However, we still recommend deleting poorly performing ads and keywords to improve Quality Score. This will prevent the ads and keywords from performing poorly in the future and further affecting your account history. As the rest of your account accrues more performance history over time, the impact that the deleted ads and keywords have on your Quality Score will diminish”

Petebardo, a Top Contributor on the forum tells us to use between 3 and 5 ads. I prefer to use my top 2 but am always open to suggestions on how to improve my campaigns, especially when it comes from experts like these.
“You can have 50 ads per ad group. However, I recommend testing about 3 to 5 ads per ad group. Too many ads will not give you sufficient data, as impressions will be spread thin. Also, you may want to opt your campaign Ad Delivery settings into ‘Rotate’ instead of ‘Optimize’ so that you can get cleaner data.”

Whats a Badge, Whats a Hashtag?

Badge

Create a badge which normally look like your company logo. This badge will have your webpage link coded embedded into it. You can use it on your social media sites as your profile picture so when people click on it they are brought to your web page. Look at http://www.freshbadge.com for examples.

HashTags
If you are having an event it is a good idea to create a hashtag, this will help you follow who are tweeting about your event. Before you create a hashtag go to http://www.hashtags.org to ensure you create a distinct hashtag relevant to your event. A hashtag looks something like this #technology, #eventdublin2011.
Like Facebook, Twitter has such a large community hastags make it easier for people to find you message. I was surprised to hear that twitter didn’t invent hastags – have a look here http://tinyurl.com/6a2gm8s

IBMs Take on Cloud Computing

The IBM company are touring Ireland with their Road show called ‘Smarter Planet’/ One of the presenters at the road show is Wayne Leone. He is a Cloud lab service manager at IBM spoke first and the title of his presentation was’ Cloud Computing: Today and Tomorrow’. He gave a brief overview of cloud computing (CC) and explained that CC was not some new revolutionary in the internet usage but rather something that evolved over years. He explained that IBM were holding back on developing CC to see the mistakes their competitors were making, learning by them and then developing a strategy for selling CC using best practices. IBM will now sell you a secure CC systems that can be stand alone servers or virtual servers that IBM will host themselves. They have developed five different types of CC’s, the private cloud, the shared managed private cloud, the hosted private cloud, the shared cloud and finally the public cloud,. Wayne noted that IBM is focusing on two things, security and cost reduction. Since a normal servers Central processing Unit (CPU) hovers around 15% that means 85% of the time the CPU is ideal and being wasted. What CC can do is allocated the other 85% to other servers or rather set the 15% at as a baseline and increased as an when needed. This of course means cheaper costs and. The whole CC process becomes automated which means a reduction in costs, IBMs reckons is 80% less on labor and 90% less on hardware costs . If these savings are true than I believe lots of companies will be using their services.

Get Digital hosted by Techspectations

On the 22nd of October Techspectations hosted a digital marketing session in the Helix Theatre at Dublin City University.

Most people when you say ‘digital marketing’ they give you a look of confusion and this includes some PR consultants as well. Last week I got a crash course on digital marketing and picked up a lot of good hints.

Dr Theo Lynn from DCU who was one of the main driving forces behind this event opened up the session and during the day introduced various speakers.

First up was Matt Kellett and Ceo of Magnet Networks and Vice President North Dublin Chamber of Commerce. Matt told us about his personal experience with Digital Marketing. He estimated that 850euros spent on Google ad words returned revenue of 270,000Euros which was a great return on investment. The use of Facebook and Twitter contributed to around 450,000Euros of revenue, basically using word-of-mouth on the internet. His company, Magnet provides online TV and uses the north Dublin transatlantic fibre network which is report as close to the speed of light as possible; it is the fastest data highway between Europe and the Americas. It’s great to hear some positive business news.

After Matt we had Prof Ferdinand von Prondzynski from Robert Gordon University, Aberdeen. He is a renowned blogger and he took us on a journey on how he first starting using a computer to the present where thousands of people read his blog on a daily basis. He does not claim to be an IT pro but someone who avails of the technology to deliver a more professional service within academia. He believes you need to use social networking in order to attract new customer. You need to make them aware of you, you need to go out and find them rather than having them finds you.

Eimear Faughnan talked to us about her company, Kantar media and they use of target group index in marketing. TFI can be used in ad intelligence and single source market research. Katar develop attitudinal statements with regard to certain group demographics and hence they claim to have enhanced understanding on what makes people buy.

Piaras Kelly describes himself as a PR agency and writes his own blog http://www.pkellypr.com/blog/index.php which has being running for around 5 years. To get your brand know you need to publish on the net and it may seem obvious but the more you publish the more your brand will be known. And of course, you and your brand need to be remarkable, what you say needs to be interesting or people will not listen. But please don’t dress up like that unnamed low cost airline boss.

Our next speaker was Eamon Clekin from TI Chiara Consulting who candidly admits he sounds and talks a little bit like Dara O’Briain was the definitely the highlight of the session. He talked about the need of digital marketing but also the need for traditional marketing; in the future there must be cohesion of the two channels rather than the current perceived perception of separation. Some facts (about Ireland) he threw out at us were very interesting like people now watch 10% more TV than 5 years ago and Google & Facebook can hit 80% of the population with a month.
He then spoke about the fundamentals of advertising; a brand is a contract between the customer and the business. In simpler terms if you buy a brand than you know what you are getting. If you are a marketer for a business than you must understand their brand, their business, their customer and how to communicate with said customer. If a business’s marketer cannot do that than the business needs a new marketer.

Lastly Chris Ciauri gave a quick rundown on Cloud computing (CC). I wrote about CC in another blog so wouldn’t bore you again. Chris did mention that in 2009 social media networking surpassed email for the first and also more people used Facebook search than Google search.

So not to sound to cliché about it, Web 2.0 and Enterprise 2.0 are definitely changing the way we communicate. Digital Media isn’t the end of traditional media but just an extra add-on.

DCU Business School put events like this on a regular basis; if you are a SME it would be worth your while attending one of these events as it will give you some great marketing ideas.

The Future of Cloud Computing

 

On Friday the 22nd, Dublin City University hosted by Techspectations ‘Get Digital 2010’. The days was filled with speakers, demonstrations and workshops, it was extremely interesting and fly by. One of the parts that interested me the most was the Cloud Computing workshop so here’s a little bit of it.

They say that Cloud Computing (CC) is the future but I after listening to Fiachra O’Corey and Cormac Keogh. From what I can tell CC is here now, it’s not the future but rather the present. Ironically I have being using CC for the last year and not even know it, I have being sharing documents on Google docs, they are living documents that get updated by me or my colleagues, we can access them anywhere a internet connection is and they don’t reside on any of our PC’s but on some big Server that Google owns.

Cormac Keogh is from Microsoft, he spoke about Micro soft Azure which is Microsoft platform for hosting CC. He did say that hosting wasn’t a good description of what Azure does but for now it will do for now. It you avail of a few options (services) with Azure. You can use it for infrastructure, it can hold your Virtual Machine (VM) with all your application on it but you still need to do maintenance on your applications, like when a new security patch is needed or an application bundle. You really need to be an IT pro if you want to use this service. You can also use it as a platform so that VM could be on just one computer or a hundred and the Microsoft bod would take care of the patching and maintenance. The last service mentioned was if you just wanted Azure to hold your software application, something like a website like Ebay or Amazon.

So why let another company like Microsoft service your software and applications. Well the first benefit that comes to mind is you don’t have to deal with buying servers and if they provide the system administrators so you don’t have to hire one and worry about 24/365 cover., let it be their headache now yours. If your business is manufacturing clothes, do you really want an IT department, maybe you do but if you don’t there’s now another option. As for the cost, well right now Azure is really for medium to large size business but that could change in the future.

Fiachra O’Corey is from Salesforce.com, I had heard about the company before but thought they just sold Customer Relations Managements (CRM) products. They have a cloud computing platform called Force.com. They really have made it easy to use and so if you forced me to choose between Azure of Force I would opt for Force. An incident that impressed me was that Fiachra’s web connection didn’t work on his laptop, ‘no problem’ he said as we can access Salesfoce from any computer that has web access. He logged onto another PC , carried on his presentation and was able to show us all the functionality and easy Salesfoce.com is too use on a PC he had never used. So no more need for preinstalled software on your PC or laptop, all you need is a web connection. Dell use salesforce.com now globally so if a large comp

Two Irish businesses also spoke to is, they use CC to their advance and are able to expand their business more easily.
John Dennehy the Managing director of HR locker explained issues in accessing their application in China due to local firewall protocols. HR locker within a day was able to move the application from Cork to Hong Kong with zero hassle thus avoiding the Chinese firewall issues. If HR Locker had built their application without CC, than they would have had to hire servers, a place to keep them, a system admin in a city half way around the world, can you imagine the hassle involved?
The other Irish company that spoke was Staff Balance. Ciaran McGowan the CEO of Staff Balance. They have created a tool that can track business performance and operational efficiencies.

Here are some handy websites
http://www.techspectations.org
http://www.salesforce.com/
http://www.microsoft.com/windowsazure/
http://www.hrlocker.com/
http://staffbalance.ie/