Archive for the ‘Tool’ Category

I had a HDD taken out of my NAS – it was the “My Book World Edition II (White Light)”. Although the HDD was fine but the NAS was loosing its connectivity capabilities day by day and eventually stopped working one day.

I successfully took the HDD  out by following the instructions in the below link:


Using varieties of free software from within Windows 10 I discovered that it was partitioned with Linux file format (Ext4 and RAW file formats). I have tried more software but I was not being able to see my folders and files but rather some other folders and files that I did not recognise (these were the files and folders used by the NAS).

After much looking further I stumbled upon http://www.reclaime.com/.

I tried the trial software and within a few clicks I could see all my files and folders. I was amazed to able to browse the folders and files that belonged to me. I was also really amazed at how easy it was to use the software.

I went ahead and bought the software. Although it was pricey (£190.93) it exactly did what it said on the tin.


Read Full Post »

-- This snippet lists all given the field vlaues so that they straight away be copied and put into a string.


-- i.e.  set @variable = 'a,b,c,d,e' -- the text inside the single quote is generated


-- Change the below sql in the singel quote to replace it with the required field and table name.


-- Delete or change the top 100 to the number of values you want it returned
-- Also remember to be inside the server and the database the table is in.
-- Go to the "MESSAGES" tab and copy the piece of text into the clipboard for later use.

declare @passed varchar(max)
set @passed = 'SELECT top 100 [place the field name here] from [place the table name here]'

Declare @fetch table
 id int identity,
 store varchar(max)

if left(ltrim(@passed), 6) = 'select'
 insert into @fetch
 exec (@passed)

select * from @fetch


declare @id int, -- Pointer
 @idMax int, -- Scroller
 @pipe varchar(max) -- Final string to return

select @id = 0, @idMax = max(id), @pipe = ''
from @fetch
while @id < @idMax -- whenever @id would be = @idMax; the loop would break
 set @id = @id + 1 -- Start Scrolling
 select @pipe = case when @id < @idMax then @pipe + store + ', '
 else @pipe + store end -- We dont want a comma at the end of the string
 from @fetch where id = @id -- tells which record to fetch

print @pipe

-- Please check the screen shot below:
-- I have used the below query:
-- SELECT name FROM dbo.sysobjects WHERE type = 'u'

I have also made an excel file that does a similar job but it is limited to the number of rows. Just copy and past the the fields values in the left most column and press ctrl + d

Click the link below to download it:

Link to download

Read Full Post »