Author Archive

Mostafa Dafer

Computer & Communication Eng. Stdnt. Founder & CEO of CoolesTech Knows Arabic; English, learning French, Chinese, and Japanese About me:

Delete Duplicate Rows from SQL Database Without a Primary Key

Written by Mostafa Dafer on . Posted in Tips & Tricks

Just wanted to share with you a simple trick for deleting a duplicate row in your SQL table when you haven't assigned a primary key. So you may be wondering how could this happen... Well, in most cases, it would happen when you are setting an Id to your item by hand instead of using Identity to automatically set the Id. This leads us to another question, which is why would we set the Id by hand? Now here comes several answers, the best is the case where we need to insert a new item to the table Read more [...]

Windows 8.1 Offline ISO Installer Leaked!

Written by Mostafa Dafer on . Posted in Tips & Tricks

Update 1: You can only use the offline image directly for clean install if you have a Windows 8.1 Key. Otherwise use this method to offline-update using your Windows 8 Key: To update to Windows 8.1 normally, you can go to the Windows 8 Store Then click/tap Update to Windows 8.1 If you face any errors like "Your apps were installed" or you can't find the "Update" tile, you can run cmd in elevated mode and type: Dism /Online /Cleanup-Image /RestoreHealth   To Read more [...]

Get 20GB of Free Cloud Storage!

Written by Mostafa Dafer on . Posted in Entertainment & News, Featured

Barracuda Networks have launched "Copy", the Cloud Service based in California and founded in 2002. Supported Platforms: Android, iOS, MacOS, Windows, Linux   Copy is available for mobile phones as well as computers. The synchronization is very easy as all options may be found in one place. Best of all, sharing folders is great feature; Copy assumes that you're with your friends at a restaurant and you must divide the bill equally, so if you have a 12GB shared folder with 4 Read more [...]

A Mind-Boggling Professional Robbery in Guangzhou, China!

Written by Mostafa Dafer on . Posted in Entertainment & News, Featured

There was this robbery in Guangzhou , the robber shouted to everyone: "All don't move, money belongs to the state, life belongs to you". Everyone in the bank laid down quietly. source: This is called "Mind Changing Concept --> Changing the conventional way of thinking". ------------------------------------------------- One lady lay on the table provocatively, the robber shouted at her "Please be civilised! This is a robbery and not a rape!" source: This Read more [...]

DNA Storage To Replace Blu-Ray!

Written by Mostafa Dafer on . Posted in Entertainment & News, Featured

We all love Sci-Fi movies, but have we thought that reality may surprise us even beyond imagination?! It's time for a real surprise! Why use low-capacity discs when the DNA can provide theoretically unlimited storage?!!! according to zdnet: It's not alive, and could be kept passively in a storage device for thousands of years. It's also capable of holding a lot of information. For example, one single cup of DNA could, in theory, store about 100 million hours of high-definition video. According Read more [...]

فيلم السلطان محمد الثاني (الفاتح) بجودة عالية

Written by Mostafa Dafer on . Posted in Entertainment & News, العربية

من منطلق اهتمامنا باحياء الثقافة الاسلامية وحرصنا على الافادة والتسلية من خلال مشاهدة افلام تذكّر بعظماء الأمة وبأسلوب شيّق وبسيط يناسب جميع الأعمار والأجيال...يسرّ موقع أن يقدّم لكم ولأول مرة: فيلم" محمد الفاتح" يعتبر السلطان محمد الفاتح من أعظم القادة في تاريخنا المجيد Read more [...]

كيفية تحديث جالكسي اس 2 و اس 3 الى جيلي بين، نسخة أصلية مسربة

Written by Mostafa Dafer on . Posted in العربية

تحديث: آسف، نسيت أن أذكر أن هذه النسخة هي نسخة أصلية مسربة من شركة سامسونج. تحديث 2: يجب اطفاء Samsung Kies قبل البدء بالخطوة رقم 7. سمعنا منذ شهرين عن نية Samsung تحديث هواتف Galaxy S2 و S3 الى الجيلي بين، وفي كل شهر كانت تؤجل الشركة موعد الاطلاق الى الشهر القادم، وبما انه تم اكتشاف ثغرة امنية Read more [...]

Add Snowing Effect to Your WordPress Blog, Let It Snow!

Written by Mostafa Dafer on . Posted in Tips & Tricks

Season's Greeetings! 🙂 As you can see it's snowing at CoolesTech! Why don't you add this effect to your blog! You may have noticed that there are plugins out there that can do this, but they are either ugly or deprecated. We have chosen "Let It Snow" plugin for it's wonderful look. However, after activating the plugin, a horizontal scrollbar splashes, appears and disappears causing a very ugly experience (jumpy horizontal scrollbar). After wasting some time searching the internet, Read more [...]

Android Ethical Hacking, could it get any easier?! Try it yourself with apk CSigner!

Written by Mostafa Dafer on . Posted in Tips & Tricks

UPDATE November 2015: Version (0.8.2) released, Compatible with Windows 10! UPDATE: A new version has been released (0.8.1)! Introduction: I’ve recently joined Android Developers and I have published CoolesTech RSS Feed Reader. All went fine until I had to self-sign my app (personal private key), and that’s what was like a nightmare (although it’s relatively easy); test keys worked like a charm when self-certificates failed… But Google does not allow test certificates as you may have noticed. I Read more [...]

أكبر لعبة أحجية الأشكال في العالم مؤلفة من 32,256 قطعة

Written by Mostafa Dafer on . Posted in العربية

من منا لا يعرف لعبة أحجية ترتيب الأشكال "Puzzle"؟ ها نحن اليوم نشهد أكبر وأصعب لعبة حتى يومنا بحجم 17 قدم طول و 6 اقدام عرض بحسب ترتيبات غينيس! اللعبة مؤلفة من 32,256 قطعة ملونة بـ 6 ألوان فقط بالإضافة الى الأبيض والاسود. تودون شرائها؟ تأتي اللعبة في علبة ثقيلة مزودة بعجلات! وتكلفتها $204.16 Read more [...]

iMusic, That’s What We Call “Wireless Music”!

Written by Mostafa Dafer on . Posted in Gadgets

Please visit the post to view this video Now that's different. On the go music fans (like me 😉 ) now have the chance to listen to their music wirelessly while hiding from the cold! Ideal for buses, trains, planes or simple walks outdoors, the iMusic Hat is the perfect accompaniment when on the move or standing in the cold waiting for a bus. The hat is powered through your music player/phone, so no batteries are required. Think we've found the ultimate wintergift 😉 Features: • Read more [...]

Like Us!

Subscribe to newsletter!

Enter Your Email: