Giant Stride

SQL Indexing and SQL Performance Part 3: Queries, indexes and the query optimizer

Which columns should you choose for indexing? To decide on the columns of an index you have to consider the most frequent queries running against your tables. You have to examine the WHERE and JOIN clauses (ORDER BY and GROUP BY also benefit from indexes), since SQL query optimizer will try to find the best [...]

A nice way to start on Linux

I bought the first edition of this book to introduce myself to the world of Linux. It is well structured and quite understandable for someone who is taking his first steps in the Linux O/S. Covers basic theory like file system structure, booting and shutting down to more advanced like routing, performance analysis, etc If [...]

How to create a WinPE USB Drive

Windows preinstallation environment (windows PE) is a bootable tool that provides a minimal set of operating system features for installation, troubleshooting, and recovery. In this post I am going to explain how you can setup a windows PE environment to boot from a USB drive in 5 simple steps: Download and install windows AIK from [...]