dqs-sql-server-2012

DQS - Data Quality Services in SQL Server 2012

TRINUG - Data SIG, July 2013 SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product. DQS enables you to build a knowledge base and use it to perform a variety of critical data quality tasks, including correction, enrichment, standardization, and de-duplication of your data.

July 20, 2013 · 1 min · tewari

Get Your Windows 8 Start Menu Back With Pokki

I like the new Windows 8 experience. Start screen with live tiles is awesome. But I have been missing the Start Menu when I am on the desktop. There are plenty of rumours that Microsoft will bring back the Start Menu in the next version of Windows - Windows Blue. Until then, you can use one of many third party utilities for that functionality - ClassicShell, Start8 and Pokki. I started using Pokki. And I love it. It feels like my world is whole again. Pokki is free. ...

May 24, 2013 · 1 min · tewari
refactoring-to-mvvm

Refactoring to MVVM (Windows 8)

Carolina Code Camp - 2013 You will learn how to structure your app’s code in a way that - improves maintainability - enables testability of your app’s UI behavior - reduces maintenance cost - enables cross-platform deployment

May 5, 2013 · 1 min · tewari

The Site44 Workflow

A light weight development workflow with real-time website deployment. I recently built a sample website to illustrate how clean, semantic html markup can be maintained when using Bootstrap’s grid system. The solution is to use a css pre-processor to incorporate Bootstrap’s LESS based mixins into your own .less files and push the Bootstrap instructions down into your stylesheets. There are two ways to “compile” .less stylesheets - use a stand-alone LESS compiler or use less.js. I found it very convenient to use less.js (note that it is not recommended in production deployment). As I started working on developing the sample code I found it a bit cumbersome to work with an entire web application project in Visual Studio, considering I was working with some really simple sample client-side html, css. As I craved for an alternative, I stumbled on to a development workflow that is incredibly simple and a lot of fun. I call it the Site44 workflow. Site44 turns your dropbox folders into websites. And it is awesome! Here is what you do - ...

February 6, 2013 · 2 min · tewari

Understanding and Using System.Transactions

These are some resources to help grasp System.Transactions functionality and use it effectively in your projects: Features Provided by System.Transactions to create transactional applications Implementing an Implicit Transaction using Transaction Scope MSDN Magazine Articles by John Papa: ADO.NET and System.Transactions Revisiting System.Transactions These are specific to TransactionScope(the way to go in most cases): Here is a practical example of Using TransactionScope to handle transactions in .net. This article in MSDN Magazine gets in depth with the way a TransactionScope like functionality can be implemented. Gives you a good understanding of what is happening under the hood when using TransactionScope in some Repository implementations in multi-threaded scenarios. This CodeProject article is another example of implementing a transactional repository. There are excellent tips here about configuring TransactionScope when using it with SQL Server. This is a good resource for understanding CommitableTransaction usage. And this one on the CodeProject has brilliant, in-depth and under-the-hood coverage - Truly Understanding .NET Transactions and WCF Implementation. ...

October 17, 2012 · 2 min · tewari

Protecting Your Api Keys

I am working on a Windows 8 app (details to follow in a subsequent post) and the code is published in a public repo on github. My app uses third-party APIs and after I committed the first cut to github, I realized that I had included my api keys in the code. The whole world had access to my keys. I did not want to publish the developer keys for those APIs to the entire world. ...

September 3, 2012 · 2 min · tewari

Favorite Excel Keyboard Shortcuts

I am a big fan of keyboard shortcuts. Here are some of my favorites keyboard shortcuts in Excel.

August 24, 2012 · 1 min · tewari

Solution to the fetch puzzle

Here is a brute force solution to the fetch problem - Basically, at each step there are three possibilities : 1. You can fill a bucket. 2. You can transfer water from one bucket to the other one. 3. You can dump out the water from a bucket. In this brute force solution, I try each one of these steps and then try all three again after each one of the previous steps. And on ...

January 4, 2012 · 2 min · tewari

Solve puzzle with code

Here is a quite common programming interview puzzle - You have two buckets. A 3 gallon bucket and a 5 gallon bucket. Buckets are not marked or graduated. You are to fetch 4 gallon of water in a single trip to the river. How will you do it? Obviousy, this question is asked by changing the capacities of the two buckets and the amount of water to be fetched. Your mission, should you choose to accept it, is to write a program to solve this puzzle in a generic way. Your program should take 3 inputs - capacities of the two buckets and the amount of water to be fetched. After solving the puzzle, your program must write out the solution step-by-step. You can use any programming language, any platform, any programming technique to write the program. Use whatever you like - C#, VB, C, C++, Java, Ruby, Python, F#, Boo, Javascript or any other language of your choice. Use design patterns, TDD, BDD, MVVM, Linq or whatever. Make it blazing fast, exploit multiple cores, use artificial intelligence. Go nuts! If you want to write the whole program in T-sql, powershell script or a batch script, go ahead. Heck ! you can even do it with regular expressions, if that your thing! ...

December 27, 2011 · 2 min · tewari

Windigo 1.1 Released

Windigo is a windows phone app to access your diigo account on windows phone 7. Create, edit and search diigo bookmarks. Slick, to-the-point interface. Browse and search public bookmarks of other diigo users. Tap on the bookmark for details, including tags. Tap on any tag to narrow your search. Trial version is available. Windigo 1.1 is out on the windows phone marketplace now. Highlights of this update : - Last SearchScope used is now persistent ...

December 5, 2011 · 1 min · tewari