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 [...]

Second Tutorial in LabVIEW series ( arabic version)

Written by mostafa najim on . Posted in Tips & Tricks, العربية

The second Tutorial in my LabVIEW series is done. part 1 http://www.youtube.com/watch?v=fdTkw-p2mws In this video i focused on : 1- applications of numeric functions 2-comparison function (equal) 3-boolean function (OR) . part 2  (please check the description is the second video) http://www.youtube.com/watch?v=31sc0GgSMgw In this video i focused on : 1- creating a mathematic equation 2-numeric inputs and outputs 3- case structure don't forget to subscribe for my channel Read more [...]

Launching a New Tutorial Series on LabVIEW in Arabic!

Written by mostafa najim on . Posted in Tips & Tricks, العربية

LabVIEW (short for Laboratory Virtual Instrument Engineering Workbench) is a system-design platform and development environment for a visual programming language from National Instruments. This is the first video of a LabVIEW tutorials series , targeting all those looking for the beginning point to start with graphical programming, and if you are having problems with English language don't worry because the videos are in Arabic . (P.S. : an English version will be published after the series 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: mcakins.com 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 [...]

5 Most Unbelievable Internet Addictions

Written by Ash on . Posted in Featured, Tips & Tricks

You can get addicted to anything — it doesn't have to be your typical drugs, alcohol, or cigarettes. As a matter of fact, you can get addicted to something as simple as TV, or even food. Many people are finding they have various internet addictions. Take a look at these 5 unbelievable internet addictions that you might be suffering from, too. The Internet Shopaholic Image via Flickr by mandiberg According to Orange Collar Media, people in the United States spent one-hundred eighty-six 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 [...]

Microsoft & Windows 8… Making the Future!

Written by Mostafa Dafer on . Posted in Tips & Tricks

In this Post we will Go through  some amazing &  important features that Microsoft is offering in its Windows 8 Products. Warning: If you are not willing to buy a new device or don't need to spend money to buy tech gadget stuff please don't read this post... hahaha just kidding. Let's Start: Friday, 26 October 2012 the whole world woke up eager & thirsty awaiting the release of Microsoft's new Products followed by the Windows that is described by the most Secure, Fastest, Fluid & Read more [...]

Nicekit Time Boss, Parental Control Software That We Can Trust!

Written by Mostafa Dafer on . Posted in Tips & Tricks

They say: times have changed; I say: people have changed as well... In less than a 100 years lots and lots of inventions strived to invade our homes... Televisions, computers, and lots of other devices, and while the television was the most to blame for social issues, computers and the internet where only identified as serious threats recently. As we always tend to solve our problems, several parental control and monitors emerged to save the day, but while software monitors and key-loggers flooded Read more [...]

How to Soar in the Cloud Without Crashing

Written by Ash on . Posted in Tips & Tricks

How to Soar in the Cloud Without Crashing Whether you've heard of cloud storage or not, you've more than likely used it. Whether you have an online email provider (such as Gmail, Hotmail, or Yahoo!) or have uploaded pictures to Flickr or Picasa, most of us have used some form of cloud storage. Here are some tips for using cloud storage. Decide What You Need Via BlueBugle.org The first thing you'll want to decide is exactly what you want out of cloud storage. It can vary from a backup of some Read more [...]

Sign APK Files Easily using CSigner, No More “Application not installed” errors!

Written by Mostafa Dafer on . Posted in Tips & Tricks

Update: A new version has been released click here to visit the new version post.   I've recently joined Android Developers and will be publishing CoolesTech app soon! 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. After doing lots of research that took me hours, Read more [...]

Android Ice Cream Sandwich 4.0.3 XSG (Arab Countries) Official Finally Released for Galaxy S2!

Written by Mostafa Dafer on . Posted in Featured, Tips & Tricks, Uncategorized

All Arab Galaxy S2 owners may now update their phones officially through Samsung Kies. Open up Samsung Kies. Then plug in your Samsung Galaxy S2 to Computer using the USB cable. Kies will automatically detect that an update is available. Just click Update. Or click Firmware upgrade if you miss out the pop up. Read all the instructions carefully. Then check I have read all of the above information. You may want to "Proceed without saving". Finally, click Start upgrade. Select backup Read more [...]

Like Us!

Subscribe to newsletter!

Enter Your Email: