

<!DOCTYPE html>
<html lang="en">
	<head>
		<meta charset="utf-8">
		<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
		<title>Max Al Farakh Blog </title>

	<meta name="description" content="Personal blog by Max Al Farakh - co-founder of Jitbit Software, the company behind Jitbit Helpdesk and other awesome products " />


	<link rel="alternate" id="rssLink" type="application/rss+xml" title="Max Al Farakh Blog" href="https://www.jitbit.com/maxblog/rss/" />
		<meta name="robots" content="noodp">
		<link rel="shortcut icon" href="//www.jitbit.com/favicon.ico" />
		<link rel="icon" href="/favicon.ico" />
		<link rel="icon" type="image/png" href="/favicon.png" />
		<meta http-equiv="PRAGMA" content="NO-CACHE" />

		<meta name="viewport" content="width=device-width, initial-scale=1.0">

		<link rel="stylesheet" href="/assets/css/style.min.css?v=45" />

		<script>
			function LoadCssFile(cssPath) {
				var cb = function () {
					var l = document.createElement('link'); l.rel = 'stylesheet'; l.href = cssPath;
					var h = document.getElementsByTagName('head')[0]; h.appendChild(l);
				}
				var raf = window.requestAnimationFrame || window.mozRequestAnimationFrame || window.webkitRequestAnimationFrame || window.msRequestAnimationFrame;
				if (raf) raf(cb);
				else window.addEventListener('load', cb);
			}
			LoadCssFile('https://fonts.googleapis.com/css?family=Titillium+Web:400,600');

			
			window.q=[];window.$=function(f){q.push(f)}
		</script>

		
		<script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start':
		new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0],
		j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src=
		'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f);
		})(window,document,'script','dataLayer','GTM-TMN3CBH');</script>

		
	<style>h2,h3 { font-size:22px !important}</style>

	<link rel="canonical" href="/maxblog/" />

		<link rel="next" href="/maxblog/page/1/" />
	

		
		
	</head>
	<body>

	<div id="header" class="" >
		<div>
		<div class="container">
			<a href="/" id="logo">
				<img id="cloud" src="/assets/img/logoCloud.png"alt="Jitbit logo - makers of Jitbit Helpdesk" />
					JitBit

				<!--
				-->
			</a>
        
				<ul id="nav">
					
					<li id="productsLi">
						<a title="helpdesk pricing" href="#">Pricing</a>
						<div id="productsPopup">
							<ul>
								<li><a href="/hosted-helpdesk/purchase/">Hosted (recommended)</a></li>
								<li><a href="/helpdesk/purchase/">Download (for your server)</a></li>
							</ul>
						</div>
					</li>
					<li><a href="/company/">About</a></li>
				</ul>
			
		</div>
		</div>
	</div>

		






<div class="container">
	<h1>Max Al Farakh Blog</h1>
	<div class="row">
		<div class="span9 content"  id="news">
				<div class="article">
					<div class="date">Aug 28 2017</div>
					<h5><a href="/maxblog/24-how-to-generate-a-full-text-query-for-sql-server/">How to generate a full-text query for SQL Server</a></h5>
					<p>
						<p>Information on the full-text search on the Internet is pretty scarce. Unless you want to read 600 pages long book you are going to have a hard time. We&#39;ve been toying around with FTS in Jitbit Helpdesk for almost five years now. I wanted to share the code we use. </p>
<p>This is a result of many iterations over the years. The code we&#39;ve settled with is pretty basic and only covers two use cases, but I believe it&#39;s going to be enough for 95% of products out there.</p>

					<a href="/maxblog/24-how-to-generate-a-full-text-query-for-sql-server/">continued...</a>
				</p>
			</div>
				<div class="article">
					<div class="date">Oct 28 2016</div>
					<h5><a href="/maxblog/23-thinking-about-switching-from-mac-to-pc-here-is-my-story/">Thinking about switching from Mac to PC? Here is my story</a></h5>
					<p>
						<p>Many Mac users are thinking about switching to PC after the yesterday’s keynote. I made the switch a couple of months ago, and I want to tell you my thoughts.</p>

					<a href="/maxblog/23-thinking-about-switching-from-mac-to-pc-here-is-my-story/">continued...</a>
				</p>
			</div>
				<div class="article">
					<div class="date">Dec 29 2015</div>
					<h5><a href="/maxblog/21-errcertauthorityinvalid-on-android-and-iis/">ERR_CERT_AUTHORITY_INVALID on Android and IIS</a></h5>
					<p>
						<p>Recently one of our users complained that he couldn't access our site on his Android phone. </p>

					<a href="/maxblog/21-errcertauthorityinvalid-on-android-and-iis/">continued...</a>
				</p>
			</div>
				<div class="article">
					<div class="date">Jan 28 2015</div>
					<h5><a href="/maxblog/20-7-great-newsletters-for-startup-founders/">7 Great Newsletters for Startup Founders</a></h5>
					<p>
						<p>It takes a lot of time and effort to stay on top of the industry news. Tons of new articles are being published every day, but not all of them worth your attention. Let other people do the dirty work and find the most interesting and useful stuff for you – subscribe to a newsletter. Here are 7 curated weekly email newsletters that I love.</p>

					<a href="/maxblog/20-7-great-newsletters-for-startup-founders/">continued...</a>
				</p>
			</div>
				<div class="article">
					<div class="date">Jan 17 2015</div>
					<h5><a href="/maxblog/19-lessons-learned-after-running-an-nps-campaign/">Lessons Learned After running an NPS Campaign</a></h5>
					<p>
						<p>So, we've just finished running a <a rel="nofollow" href="http://en.wikipedia.org/wiki/Net_Promoter">Net Promoter Score (NPS)</a> survey for <a href="https://www.jitbit.com/helpdesk/">Jitbit Helpdesk</a>. NPS is a hot new thing in the startup world. Well, it's not entirely new – traditional marketers have been using it for 20 years, but, since startupers tend to despise traditional marketers and ignore everything they did for the last 50 years, we've learned about NPS just recently.</p>

					<a href="/maxblog/19-lessons-learned-after-running-an-nps-campaign/">continued...</a>
				</p>
			</div>
				<div class="article">
					<div class="date">Aug 15 2014</div>
					<h5><a href="/maxblog/18-detecting-outlook-autoreplyout-of-office-emails-and-x-auto-response-suppress-header/">Detecting Outlook autoreply/out-of-office emails and X-Auto-Response-Suppress header</a></h5>
					<p>
						<p>In our <a href="https://www.jitbit.com/hosted-helpdesk/">helpdesk app</a> we have a method called IsUselessEmail(). Its purpose is to filter through all incoming email and drop all bounces, autoreplies etc. This is a tough problem since we need to drop as much garbage as possible, but pass through any useful emails.</p>

					<a href="/maxblog/18-detecting-outlook-autoreplyout-of-office-emails-and-x-auto-response-suppress-header/">continued...</a>
				</p>
			</div>
				<div class="article">
					<div class="date">Aug 10 2014</div>
					<h5><a href="/maxblog/17-sql-server-how-to-convert-datetime-to-utc/">SQL Server: how to convert datetime to UTC</a></h5>
					<p>
						<p>Recently we needed to convert all dates in our database to UTC format. We've made a mistake not storing them in UTC from the beginning and it led to complicated issues. When you have to support various time zones, there is no other way but to store you dates in UTC.</p>

					<a href="/maxblog/17-sql-server-how-to-convert-datetime-to-utc/">continued...</a>
				</p>
			</div>
				<div class="article">
					<div class="date">May 9 2012</div>
					<h5><a href="/maxblog/8-feature-requests-are-not-necessarily-evil/">Feature requests are not (necessarily) evil</a></h5>
					<p>
						<p>We are not a big fans of 37Signals' approach of turning down every feature request by default at Jitbit. We actually love and appreciate our users feedback. Not a day goes by without a couple of feature requests for one of our apps and in many cases we're making a decision to implement them. </p>

					<a href="/maxblog/8-feature-requests-are-not-necessarily-evil/">continued...</a>
				</p>
			</div>
				<div class="article">
					<div class="date">Jan 27 2012</div>
					<h5><a href="/maxblog/7-easy-way-to-quit-smoking-unless-youre-dumb/">Easy way to quit smoking (unless you&#39;re dumb)</a></h5>
					<p>
						<p>I don’t remember myself as a non-smoker and I don’t remember how was it – to live without cigarettes. Now I’m 23, and I had been smoking since I was 15. That’s not a lifetime, but quite much for this age.</p>

					<a href="/maxblog/7-easy-way-to-quit-smoking-unless-youre-dumb/">continued...</a>
				</p>
			</div>
				<div class="article">
					<div class="date">Jan 25 2012</div>
					<h5><a href="/maxblog/6-reading-ipad-vs-kindle/">Reading: iPad vs. Kindle</a></h5>
					<p>
						<p>I&#8217;ve always wanted to buy a Kindle, mostly because, you know, all other geeks have it and really like it. At the same time, purchasing a Kindle while already having an iPad seemed like an overkill to me. Well, at least I thought so before reading <a href="http://37signals.com/svn/posts/3079-rekindle-my-love-of-reading" rel="nofollow">the latest DHH&#8217;s post on 37signals blog</a>:</p>
					<a href="/maxblog/6-reading-ipad-vs-kindle/">continued...</a>
				</p>
			</div>
		</div>
		<div class="span3">


<div class="well sidelinks" style="margin-top: 20px;">
	<ul class="nav nav-list">
			<li><a href="/maxblog/about/">About this blog</a></li>
					<li><a href="https://www.jitbit.com/maxblog/rss/"  title="RSS - Max Al Farakh Blog">Subscribe <img src="/assets/img/rss.png" alt="RSS - Max Al Farakh Blog" /></a></li>
	</ul>
</div>



		</div>
	</div>

	
	<a href="/maxblog/page/1/">older &gt;&gt;</a>

</div>



<div id="footer">
	<div class="container">
		<div class="row">
			<div class="span3">
				<h4>Jitbit Software</h4>
				<ul>
				<li><a href="/news/"><b>Blog</b></a></li>
				<li><a href="/company/">About</a></li>
				<li><a href="/company/#contact">Contact us</a></li>
				<li><a href="/support/">Support</a></li>
				</ul>
			</div>
			<div class="span3">
			<h4>
				Helpdesk products
			</h4>
			<ul>
				<li><a href="/">Help desk software</a></li>
				<li><a href="/helpdesk/purchase/">Pricing - self-hosted</a></li>
				<li><a href="/hosted-helpdesk/purchase/">Pricing - hosted</a></li>
				<li><a href="/hosted-helpdesk/">SaaS Helpdesk</a></li>
			</ul>
			</div>
			<div class="span3">
			<h4>
				Top features
			</h4>
			<ul>
				<li><a href="/helpdesk/helpdesk-features/">Helpdesk feature list</a></li>
				<li><a href="/hosted-helpdesk/single-sign-on/">Single sign-on</a></li>
				<li><a href="/helpdesk/helpdesk-api/">API</a></li>
				<li><a href="/helpdesk/zendesk-vs-jitbit/">Zendesk vs Jitbit vs Spiceworks</a></li>
			</ul>
			</div>
			<div class="span3">
				<h4>
					Search
				</h4>
				<form action="/search/" id="Form2">
					<input type="hidden" name="cx" value="partner-pub-1886487233116645:gxcjs2-2fl6" />
					<input type="hidden" name="cof" value="FORID:11" />
					<input type="hidden" name="ie" value="UTF-8" />
					<input name="q" type="text" maxlength="50" placeholder="Search..." />
				</form>
				<ul>
				<li><a href="/sitemap/">Sitemap</a></li>
				</ul>
			</div>
			</div>
			<div class="row copyright">
				<div class="span9">
					<a href="/"><img class="lazyimg" data-original="/assets/img/footerlogo.png" alt="jitbit" /></a>Copyright &copy; 2005-2018 Jitbit Software. 101 Rose Street South Lane, Edinburgh, UK.
					<a href="/privacy/">Privacy policy</a>
				</div>
			</div>
	</div>
</div>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js" defer onload="setTimeout(function(){$.each(q, function (index, f) { $(f) });}, 500)"></script>


<script src="/js/utils.js?v=4" defer></script>
<script src="/js/jquery.lazyload.js?v=1" defer onload="$('img.lazyimg').lazyload({threshold:300})"></script>

	<script type="text/javascript">
		var _kmq = _kmq || [];
		var _kmk = _kmk || '2fd0b1ed96de11f47ff921b1a22922fae171f83d';
		function _kms(u) {
			setTimeout(function () {
				var d = document, f = d.getElementsByTagName('script')[0],
				s = d.createElement('script');
				s.type = 'text/javascript'; s.async = true; s.src = u;
				f.parentNode.insertBefore(s, f);
			}, 500);
		}
		_kms('//i.kissmetrics.com/i.js');
		_kms('//scripts.kissmetrics.com/' + _kmk + '.2.js');
	</script>


	

	
	<noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-TMN3CBH" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>

	</body>
</html>
