I'm a PC

by Aboo Bolaky 2. November 2009 00:42

and Windows 7 was MY IDEA !!!


The AByss

Retrieving the DATA folder installation path from MS SQL Server using T/SQL

by aboo bolaky 10. October 2009 19:57

This would be useful for creating databases using SQL scripts. The SQL query below returns the installation path of the DATA folder for the installed SQL Server.

SQL Script


DECLARE @device_directory NVARCHAR(520)

SELECT @device_directory = 
	SUBSTRING(filename, 1, CHARINDEX(N'master.mdf', LOWER(filename)) - 1)
FROM master.dbo.sysaltfiles 
WHERE dbid = 1 AND fileid = 1

print @device_directory


C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\


The AByss | Tips & Tricks

Very Cool CSS Message Boxes for different message types

by Aboo Bolaky 31. July 2009 07:12

Janko Jovanovic has written a very nice article about ways to display different types of messages using CSS. The messages outlined are of the following types

  • Information messages
  • Success messages
  • Warning messages
  • Error messages
  • Validation messages


I believe what makes the article really stand out is the fact that he walks you through the css implementation as well. We're bound to display these types of messages on any web application we develop, so, please have a look at what he's achieved.


Freebies | The AByss | Tips & Tricks

Filter Duplicates in MS Excel 2007

by Aboo Bolaky 21. July 2009 06:41

Forget the flimsy conditional formulae you had to use in order to filter duplicates in Excel 2000-2003.

Excel 2007 makes it a lot easier.

You just need to highlight the column you want to remove duplicates from, navigate to the Styles Ribbon, then Conditional Formatting -> Highlight Cells Rules -> Duplicate Values. You then only need to choose which color to apply for duplicate cell values..

et voila !!!


The AByss | Tips & Tricks

What is your deepest fear?

by Aboo Bolaky 21. November 2008 06:34

Our deepest fear is not that we are inadequate.

Our deepest fear is that we are powerful beyond measure.

It is our light, not our dark that most frightens us.

Your playing small does not serve the world.

There is nothing enlightened about shrinking so that other people don't feel insecure around us.

We are all meant to shine as children do.

It's not just in some of us; it's in everyone.

And as we let our own lights shine,

We unconsiously give other people the courage to do the same.

As we are liberated from our own fear, our presence automatically liberates others.


Source: Coach Carter


The AByss

Search Engines - Can you live without them?

by Aboo Bolaky 7. October 2008 08:50

While I was having a look at search engines and data retrieval (things that I had left aside for a while now), it dawned on me that it’s just so awfully complicated to PROPERLY implement an enterprise-wide search mechanism from scratch, despite the vast amount of info about search engines over the web and the fact that SEO books are now flying all over the place (you can catch one here, here or even higher up.. here).

The emergence of new search engines (or, should I say, ‘revamped’ search engines like Ask, Yahoo Search and Windows Live Search ) has created new paradigms in search and information retrieval. This has subsequently led to new ways of retrieving data that go far beyond normal text-based search. Examples are searching embedded text within images[I use Evenote..Remember Everything] or even locating a place on a map (given the appropriate geocodes).

Conversely, some questions can be raised about the efficiency of existing search processes, some of which are:-

  • PageRanking Algorithms –Up to what level can they be manipulated /spoofed upon?
  • Meta tags – Are they really being used in the context of a search?
  • UrlRewriting – To what extent do you attach meaning to your Urls?
  • Do you always display the most important information at the top of your web page?

Thankfully, these issues are being addressed by some (quite often conflicting) SEO experts. That’s all from me for today. Keep watching this space on how I get on with my quest for the ultimate search solution.


The AByss

Annoying Large Icons in the Windows Vista Deskop - Decrease Icon Size

by Aboo Bolaky 4. October 2008 09:26

If you are tired with the big fat desktop icons that come along with Windows Vista, there's something to cheer you up. To decrease the size of the icons, simple click anywhere on your desktop.While pressing the CTRL key, use your wheel mouse to increase/decrease the size of the icons. The sweet thing here is that the sizes are persisted across restarts. Too bad for you if you do not have a wheel mouse..maybe it's about time to get one? Money mouth


OS | The AByss | Tips & Tricks

Tag cloud

Flash Player 9 required.

About Me

I wish I could write something here..
//TODO: ElaborateMe