MasterDev C3: Prepare to be Blogged

The third installment of MasterDev (known as C3) is all about sharing your knowledge via an unique article,  formulated with the right words that draws the most attention/interest.

This challenge is an individual challenge, you will be responsible for your own destiny… Prepare to be Blogged!

Having a look beneath the Surface...

It has long been awaited... It felt about as long as some of us waited (and some are still waiting) for the fourth installment of The Matrix. Unlike The Matrix fans we all finally heard the deafening drum-roll as Microsoft finally released the long awaited Surface... However if you listened closely, you would have noticed that our fearless drummer held back a bit, because the true prodigy is yet to come...

Hey That's (not so) Private - Introduction to Internet Privacy

As of the year 2011, an estimated 65% of the world’s population are internet users. And although people are becoming more aware of internet security, how do you know that someone isn’t watching your browsing patterns? Can you be certain that your internet session is not being monitored by others on the net? Are you sure that your personal information is safe? Although, it may be argued that your browsing patterns and data aren’t worth much, this article will discuss some of the techniques people use to view your internet usage and what they may be able to do with that information. Then we will mention some ways to control your privacy on the net.

Did Someone Say SQL Can Do Mathematics?!

Did Someone Say SQL Can Do Mathematics?!

I thought it was strange at first, the idea of needing mathematics in database queries. I mean are we not just fetching and storing data? However, clearly there is a place and time to use special data manipulating functions. For this reason I am going to explain a few of them and give some examples so all the noobs out there (like me) have idea of what can be done.

MasterDev Challenge: 1

It has finally started, the competition you've all been waiting for: MasterDev! The first challenge was a huge success judging from the great feedback received. I'm truly excited for the others in the pipe-line. I've decided to write about the results for the first challenge.

SQL Index Fragmentation

SQL Indexing

Indexes are applied to tables to better performance in query execution, instead of the database engine searching through each and every row for the queried data, indexing provides an indexed subset of data that can be queried to get the required rows.

Customized setup and deploy Package’s with the Orca Database Editor

As DBA, I find comfort in the fact that almost everything in life is based on a relation model, so I decided to blog about using the Orca Database editor to design customized GUI’s for setup and deploy packages in Microsoft Visual Studio. Beware trying out this, could break the standard templates given by Microsoft and could make unwanted install’s , if you created unwanted installs try Microsoft FixIt  (find it on google).