Juixe Techknow

When working with a database, it’s is always handy to develop a series of scripts to backup, restore, create, move databases around. As of late, I’ve been working with SQL Server a lot so I’ve come to appreciate the sqlcmd utility.

You can run the sqlcmd utility from the command line and run a input sql script and capture the output in a file. The input sql script file can run any sql statement, such as creating a new databases, views, tables, or procedures. You can also restore and backup any given database or whatever else you require.

To run the sqlcmd utility and have it read a file, createTables.sql, you can run something like the following from your command line, of course if you have SQL Server Management Studio and sqlcmd installed.

sqlcmd -S localhost -d dbName -U user -P password -i createTables.sql -o output.out

Google announced that it was buying Motorola for a staggering $12.5 billion. This is the largest acquisition made by the online search and advertising giant to date. I was talking about this with a friend who said the following. “If I’m a typical Motorola employee I’m worried, if I’m HTC I’m pissed, if I’m Microsoft I’m making a bid for Nokia, if I’m Apple, I’m laughing it up.” I’m not entirely sure about my friend’s statement but I am positive that Google has changed it’s strategy and decided to fight fire with fire, patents with patents, lawyers with lawyers, and mind share with truck loads of hard cold cash.

Google went at great lengths on this deal, it not only paid top dollar for Motorola but it even created a special “Facts about Google’s acquisition of Motorola” SEO-rich webpage which includes choice quotes from Android partners and a message from Larry Page.

Larry, CEO of Google, wrote about the purchase…

Motorola has a history of over 80 years of innovation in communications technology and products, and in the development of intellectual property, which have helped drive the remarkable revolution in mobile computing we are all enjoying today.

The last Motorola phone I thought was ground breaking was the first generation RAZR. Since then I have not been impressed with their phone offering, including their Android versions. In the press release, Larry made several references of the StarTAC, which Motorola originally released in 1996.

To appease other Android partners and licensees, the press release stated that Motorola will e a independent business unit.

This acquisition will not change our commitment to run Android as an open platform. Motorola will remain a licensee of Android and Android will remain open. We will run Motorola as a separate business

For me, the key and most revealing sentence in the whole press release was the following.

Our acquisition of Motorola will increase competition by strengthening Google’s patent portfolio, which will enable us to better protect Android from anti-competitive threats from Microsoft, Apple and other companies.

What struck me about the above quote is how hard Google is spinning this. When competitors buy up patents, it’s anti-competitive but when Google itself pays top dollar for a turkey stuffed with patents it will “increase competition.”

It has been reported that Google is paying $40/share, over 50% on top of the price at the time of the announcement. The reason Google is paying this price is clearly for the over 14,000 granted patents and over 6,500 pending patents Motorola has acquired over time. These patents will add to patents Google has added to it’s patent portfolio.

In the era of Apple fanboys and opinionated Ruby on Rails developers, it might not be cool to use Microsoft tools and products. It seems that startup will tend to use Ruby over .NET, Google Docs instead of Microsoft Office, OS X or Ubuntu in lieu of Windows. I’ve never been dogmatic about the technology I use. I’m a pragmatic programmer and the fact of the matter is that a large number of computer users still rely on Microsoft products. In the financial industry, Excel spreadsheets are traded like baseball cards. Microsoft realizes that they are not the cool kids in the block, at least amongst Silicon Valley startups, and perhaps that is why the started the Microsoft BizSpark program.

I’ve been one to always chase my customers and users, not trends and fads. That is why, I’ve been a huge fan of Microsoft DreamSpark and Microsoft BizSpark. Microsoft BizSpark is a program that allows small startups have access to many of its products, frameworks, tools, and resources for free.

Microsoft BizSpark Software Download

Through BizSpark you can get access to applications such as Visual Studio 2010 Ultimate, Office for Mac 2011, Microsoft Windows 3.1 through Windows Vista, and much more for free. There is no need for your CTO to look for serial numbers for Windows Server 2008 on Google and warez sites. BizSpark gives you legit licenses to key Microsoft products.

I’m a huge fan of any company that supports startups and software developers in general. I can’t say enough nice things about Microsoft BizSpark, even if they paid me. And not, they didn’t pay me but I am a proud member. I only wish that the Microsoft BizSpark program also included hardware.

From time to time I just blast tweets about software development, project planning, team dynamics, or whatever else comes to mind. Here is a synopsis of recent tweets and rants. If you want to follow the conversation follow me at techknow and/or juixe.

Software Development

• Thread.sleep(28800000);
• You don’t need a PHD in PHP to be a great Web Developer.
• Not Another Expression Language. There should be one expression language to rule them all.
• I am not afraid of rolling up my sleeves and debugger.
• It’s a thin line between feature and bug.
• Code is a blunt instrument.
• We ain’t afraid of no code block.
• Web designers are modern day alchemists.
• If developers are a dime a dozen, then product idea people are a silver dollar a dozen.
• I don’t read romance novels or non-fiction before going to bed, I read programming language technical specifications.
• New Name For Rock Band: Death By SQL Injection
• Let there be code.
• Just code it.
• Code the future.
• Crack the code.
• Don’t be a code donkey.

Team Dynamics

• Are you a value creator, subtractor, divider, or multiplier?
• AWS failure is the perfect storm to the cloud.
• Stress is excess, we don’t need it in our lives.
• You can’t buy the scrappy mentality.
• Scale your thought process.
• The right time is right now.
• Strive to do what you do well better.
• People don’t scale and multi-task as well as computers do.
• Give a man a thought, and he will think for a day. Teach a man to think, and he will think for himself.
• You don’t want someone to reinvent the wheel, you need someone that makes it turn!
• Everyone has great ideas, what is needed is great execution of great ideas.

Product Placement

• Is Automattic, the company behind WordPress, working on an ad network? With millions of WP blogs out there, maybe it should.
• Jiffy Lube peeps are great at up selling you on add-on services.
• Forget HAL 3000, I’m afraid of my iPhone 3000. “I’m sorry Dave, but I’m afraid you can’t do that and I’ve notified the authorities.
• Google announcing that better ads are coming to GMail is like the power company announcing that a better billing system is coming.
• I feel like I get more snail mail spam than email spam. I wonder if GMail can also filter out my snail mail spam.
• If you add up all the zero-day holes in Adobe products, you get a lot of days spent patching and upgrading buggy software.

The Valley

• Welcome to the Blubble 2.0.
• The trouble with the blubble.
• I think we are in a #bubble when a website for listing free crap is valued at multiple millions of dollars.
• Don’t pivot while you pitch.
• How do you monetize the bubble?
• Ah, Silicon Valley, the land of vanity startups, founders with ADD, fan boi VCs, me-to products, one trick apps, companies on pivot mode…
• Bubbles are like snow flakes, there are no two alike, so we can conclude that this tech bubble I’d different from previous ones.

General Technologist

• If Arthur Miller were alive today he would have written a sequel to Death of a Salesman called Death of a Social Media Marketing Ninja.
• You know your service or product is successful if GOOG wants to buy you for a billion dollars, FB copies you, and if MSFT doesn’t get it.
• Any lawmaker who proposes any bill related to technology should be able to correctly setup a wifi router, Facebook privacy settings, …
• My iPhone knows too much about me. I think I want a dumb phone, instead of a scheming evil genius phone that is tracking my every move.
• If TinyUrl was a utilities company it would force upgrade everybody to use smart grid meter and charge us extra to use green friendly links.
• Twitter management seem to play musical chairs with titles. It seems like everyone at the company has had a turn at being CEO.
• There are different degrees of open in open platforms, from marketing buzzword open to data portability open.
• What I learned by reading Rework by 37signals: Emulate drug dealing celebrity chefs and up sale the by-products of what you do.

Google Buzz is more Safe for Work (SFW) than Facebook in the sense that it looks like a a typical GMail account and the URL to access it also resemble GMail’s URL. Employers don’t typically block personal email access but do block networking sites. Its so easy to switch between Google Buzz and GMail.

Gutenberg died broke, his problem was that when he invented the printing press he printed the Bible. Ben Bernanke learned that lesson and instead of printing religious tomes he prints cold hard cash.

Between easy and hard, you’ll see a lot less competition if you go for what is difficult and you’ll see a lot more adoption if you make easy what was once hard.

First they seized crack warez sites and I didn’t speak out because I wasn’t a cracker. Then they came for the torret sites and I didn’t speak out because I don’t pirate content. Then they came for offshore online gambling sites and I didn’t speak out because I don’t play poker. The they came for my blog and there was no one left to speak out for me.

Reading about the recent Dropbox security issue and I realized that I have more valuable and personal information in the cloud than in my home. I have family pictures, calendar events for contacts, tax documents, inner most personal writings and journal entries, and much more on Google Docs, Dropbox, Yahoo Mail, and whatever other cloud service I use. Yet police agencies do not require a warrant to access that information but they do to come into my home and conduct a search. The search warrant is now obsolete. Google and other online services has made the search warrant obsolete.

It was recently reported that the US State Department is developing a mobile phone panic button, probably in the form of an app, for pro-democracy activists in foreign countries to erase a phone’s contents when they have are detained by the secret police. At the same time, the US Department of Justice and California’s Supreme Court have upheld the right of police to search the contents of a detained person without being arrested or having a warrant. Police are using digital equipment that can read all of the data in a phone in minutes at the point that police has stopped someone. Welcome to the future of pre-crime proactive policing.

No one has time to read long rambling text. One of the great things about Twitter is that it has a 140 character limit, it forces people to be concise, precise, to the point. It is so much easier to follow someone twitter than someones blog. This is also true for corporate communication. Within a team, the best way to ask short question is through instant messages such as Skype. The one draw back to instant messaging systems is that people expect instant responses. But for quick yes or no questions this is the best approach. More detailed questions can be escalated to email. But always be short and precise in emails. Always stay on point when emailing someone. If you are making multiple points separate them to their own bullets or paragraphs. Don’t intermix different ideas in the same paragraph. Always outline and simplify key points to one line bullet points. When asking for something, be clear as to what you are requesting or asking and always outline what you have tried, research, or done prior to asking.

Effective communication is a skill. There are tools, habits, and best practices that can help maximize the results of your team communication efforts. One of my most effective tool in communicating is to keep to the Three Sentences practice. One way to successfully achieve reply within three sentences is to never answer the same question twice, to refer to existing documentation, wiki sites, and other resources.