Coding with Typo: Structured Query Language (SQL) Part 1: What Is SQL?
Welcome to the first coding tutorial on SQL here on Null Byte. Typo:
Must Haves Search Results
News: Netflix to Block VPN & Proxy Users from Streaming Content in Other Territories
Netflix subscribers (or friends of subscribers) have been able to utilize a virtual private network (VPN) or proxy service to gain access to content in other countries. Unfortunately, the movie and TV streaming service announced today that it will soon block those services so that viewers will only have access to movies and shows that are licensed for the country they're currently in.
How To: Find Saved WiFi Passwords in Windows
Once you connect all of your devices to your Wi-Fi router at home, you'll never need that long, complicated Wi-Fi password ever again, right?
News: Kaspersky Offs Two Ransomware Strains
According to security firm Kaspersky Lab, CoinVault and Bitcryptor ransomware are officially dead.
How To: Use Split View Mode on Any iPad Model
If you own an iPad 2, a 3rd or 4th generation model, or original iPad mini, then you won't be able to utilize the new multitasking elements introduced in iOS 9. Although many iPads can use the Slide Over and Picture-in-Picture features, only the iPad Air 2, iPad mini 4, and iPad Pro have the ability to perform Split View.
How To: Activate Windows 10 with a Windows 7 or 8 Product Key
It sounded great on the surface when Microsoft announced that existing Windows 7 or 8 users would be able to upgrade to Windows 10 for free, but the execution so far has left a lot to be desired. Upgrading from an existing installation is relatively easy, but when you start with a clean install of Windows 10, you run into some problems.
How To: Turn Pandora Likes into a Spotify Playlist
Although I am a loyal premium Spotify subscriber, I still regularly use Pandora in hopes of stumbling across new artists and songs. If I'm fortunate enough to come across something I enjoy, it's easy to use the Like feature in Pandora to locate the song later.
How To: Shoot Retro-Style VHS Videos on Your Phone
Technology can move really fast. Just consider the format for which we consume videos and movies, which has transformed from film reels to VHS to DVD to Blu-ray to steaming with nothing physical at all. But for some odd reason—maybe because it strikes a nostalgic chord or it's just the new hipster trend—VHS is in again. Yes, shaky, grainy, low-quality videos with timestamps are cool again, and I dig it.
How To: Make Witches' Fingers for Halloween
This is a really tasty "scary" snack as it incorporates a lot of the flavours you'd usually put together (along with the almonds)
How To: Get Daily Weather Info Right from Your Windows 10 Calendar
The Calendar app that ships with Windows 10 has a nice little feature that will help make your days more productive by showing the current five-day weather forecast.
How To: Easily Find an Exploit in Exploit DB and Get It Compiled All from Your Terminal.
Hello everyone! Hope everyone having good day!! I wanted to share an easy way to locate an appropriate exploit from the EDB, get it compiled, and run it all from inside the terminal.
How To: Change the App Launched with the Shortcut Key on LG Devices
One of the biggest gripes I initially had with the LG G3 was the lack of options for the Shortcut keys, which are the volume keys that allow you to launch the camera or the QuickMemo+ app directly from the lock screen. I never use QuickMemo+, so having it as a shortcut was a complete waste of functionality.
How To: Connect a PS4 Controller to Your Mac for Improved Gameplay
I'm a PlayStation 4 owner, but also enjoy gaming on my Mac. Though it may not be as synonymous with computer gaming as a Windows system, it's still a great experience. But what makes it even better is ditching the keyboard and mouse for my PS4's DualShock controller.
How To: Make a Mini Grill Out of a Wire Hanger & Foil Pans
It is a beautiful, yet scorching day here in Los Angeles, and the only reason I would ever step outside from my air-conditioned castle would be to grill out by the pool. There's just one problem: backyards are few and far between here in The City of Angels.
How To: Matte Any Lipstick in Three Easy Steps
Let's face it ladies and make-up wearing gentlemen, cosmetics are freaking expensive. The only thing that is more expensive than makeup is super-trendy makeup, and nothing is trendier than matte lipstick.
How To: Run Two Apps Side by Side on Your iPad in iOS 9
After rumors and mockups and all sorts of speculated features, Apple has finally brought true multitasking to the iPad in iOS 9, with the long-rumored split screen feature (which is also in El Capitan) that lets you use two apps at once. This feature is actually two different ones called Split View and Slider Over, and they both work differently.
How To: Get the Public Beta Preview of Mac OS X 10.11 El Capitan
Apple announced the release of their newest Mac OS X version at this year's Worldwide Developer's Conference, and it's called "El Capitan." Like the majestic rock formation it's named after (located within Yosemite National Park), El Capitan promises to emphasize and expand on some of the great features we used on 10.10 Yosemite.
How To: Get Real-Time Effects That Describe the Weather Outside on Your Android's Wallpaper
Living in Southern California means I don't really have a need to check the weather all that often. But every now and then, I'm caught off guard by a particularly chilly or hot day—no one wants to be the only person walking around with a T-shirt and sandals on a rainy, 50-degree day.
How To: Get Crowd-Sourced Tech Support for Any App on Android
As with any software, Android apps can occasionally suffer from bugs. But finding the root cause of such issues can often be difficult, and reporting bugs is a cumbersome experience.
How To: Listen to YouTube Videos in the Background on Android (No Root Required)
When you think about it, YouTube may actually have one of the largest music collections on the planet. This is why, at $10 per month, Google's new YouTube Music Key subscription is a solid value for many users, especially with its inclusion of Google Play Music.
How To: Bored? Have Fun Chatting with a Bot About Anything & Everything on Android
We all have those moments where we're bored or lonely, and in those times, just having anyone to talk to would be awesome. But maybe your friends are all busy, or everyone you know is at work and nobody's responding to your text messages.
How To: Uninstall Apps from Your Apple Watch
Regardless of the size and metal-type you purchased, storage and space are limited on the Apple Watch, so stuffing it full of apps like you'd do on your iPhone may not be in your best interest. If you went app crazy when you first set up your Apple Watch, don't worry—it's easy to uninstall some of them. Just know that you can only delete third-party apps, which means stock apps like Photos or Workout are there to stay.
How To: Turn Your Apple Watch Gold (Without Spending $10,000)
With the first wave of Apple Watches being received today, you're probably busy setting yours up and playing with all its features.
How To: Set Up Two Different Facebook Accounts on One Android Device
Whether it's for handling your business's social media account or just for personal reasons, like trolling an ex-girlfriend's page (not that I've ever done that) or posting on behalf of your pup, there are instances where having two different Facebook accounts on one device is simply easier than switching back and forth.
How To: This Trick Makes Spaghetti Squash “Noodles” More Like Actual Pasta
Using spaghetti squash "noodles" for a healthy, low-carb meal seems like such a great idea, but as many of us know, turning this vegetable into a decent pasta facsimile usually has less-than-satisfying results. The usual method is to cut the squash lengthwise and roast, microwave, or steam it. Often, it comes out overcooked and underwhelming.
How To: Switch Apps Directly from the Keyboard on Any Android Device
With intelligent grammar check, accurate predictive text, swipe gestures, and plenty of themes, it makes sense that Ginger Keyboard has well over a million downloads on the Google Play Store, making it one of the more popular keyboards available for Android users.
How To: How to Make Crispy Chicken Wings in the Oven
Would you like to Have Crispy Chicken in the Oven? If so I will teach you how too.
How To: Turn Your Favorite Websites into Home Screen Shortcuts on Android
As one of the most frequently used Android browsers, making Chrome work faster and more efficiently is something we can surely all appreciate. And just like its computer-based counterpart, there are experimental flags for the mobile app that can speed browsing up significantly.
How To: Change the Default Save Location of Screenshots in Mac OS X for a Cleaner Desktop
While my desktop is usually neat and organized, it quickly fills up with screenshots each and every day. Usually, I end up putting them in a folder or just trash them, but why not make the entire process of taking and organizing screenshots easier by changing their default save location? With the help of Terminal, I'm going to show you how to change the default save location of screenshots to anywhere you want in Mac OS X.
How To: Restart an iPhone Without Using the Sleep/Wake Button
Apple's iPhone is one of the most popular, most expensive smartphones in the world, yet with a broken Home or Sleep/Wake button, it might as well be a doorstop. There are many different DIY ways to fixing a busted Home button, but the Sleep/Wake button (aka Power button) is a little more averse to DIY trickery.
News: Flash-Freeze Anything with the Anti-Griddle
Essentially, the Anti-Griddle does exactly what its name promises: it turns things almost instantaneously cold when you drop them on its "grilling" surface. Unlike home methods of flash freezing, its staggeringly low temperatures (-30°F/-34.4°C) allows ingredients that normally can't be frozen—like oil or alcohol—to turn into solids in the wink of an eye. As you might imagine, this allows chefs to play with textures and tastes in a way that was previously unimaginable.
How To: Dim the Light on Your PS4's DualShock Controller
It's late and dark, I'm playing Dying Light, and, admittedly, I'm a little creeped out. Working as a grown man's night-light, this is one instance where I actually appreciate the light bar on my PlayStation 4's DualShock controller. But outside of a few particular instances, I generally find it to be quite a nuisance.
How To: Get Back Lock Screen Widgets in Android Lollipop
Being fixated on all of the great additions to Android 5.0 Lollipop, it can be a little difficult to take notice in the features that went missing. For instance, lock screen widgets. It's speculated that the lack of practical use for lock screen widgets and the implementation of the revamped Lollipop lock screen may have lead to their departure, but some of us want them back!
CES 2015: The Swiss Army Knife of Sports Bottles Plays Music & Holds Your Phone, Cash, Keys, & More
If you're going exercising, either at the gym or outside, you're going to need a backpack, gym bag, or pockets to hold your water bottle, wallet, keys, smartphone, and anything else you've got on you.
CES 2015: ImmersiON-VRelia Can Turn Any Smartphone into a VR Headset
Samsung's Gear VR headset is a thing of beauty; unfortunately, it only works with the Samsung Galaxy Note 4. That's where ImmersiON-VRelia's Head-Mounted Displays come in to play. With four different HMD models, we got a hands-on look at "The Go," which is not only affordable (at $125), but also compatible with the majority of Android and iOS devices.
How To: Browse & Play Your Entire Music Library Directly from the Notification Center
Since Apple released iOS 8, many third-party apps have taken advantage of one of its more resourceful features: Notification Center widgets. These widgets have made it easier to interact with features and settings that would otherwise require launching an app itself, instead offering functionality through the native pull-down Notification Center.
How To: Quickly Paste Commonly Used Words or Phrases into Any Text Field on Your Mac
Your Mac's clipboard is great when you are just copying and pasting a phone number or address, but sometimes you end up having to re-copy the same thing over and over every day. To make those phrases a lot more easily accessible, the people over at Tiny Robot Software have released Pasteomatic. With this app, you will be able to use a hotkey to bring up a collection of your most commonly used text snippets and paste them into any text field or document.
Themeboard: Designer Themes for Your iPhone Packed into One Keyboard
Third-party keyboard support, introduced earlier this year by Apple with iOS 8, was initially pretty awesome. I loved playing around with all of the different options available in the iOS App Store, including SwiftKey, TouchPal, GIF Keyboard, and Swype.
How To: Select All Contacts with Just One Tap in Snapchat's Android App
While having a ton of friends on Snapchat does wonders to stroke my ego, sending content to all of them at once becomes a hassle when I have to go one by one, checking each contact individually.
How To: Make a Wooden iPhone Amplifier from Pallet Wood
This pallet wood project is a really cool pallet project as you can make it from just one pallet board, it's super easy to make, and it's virtually free. The extra sound that comes out is quite surprising. Having said that, don't expect it to sound like a fully fledged designated speaker or you'll be disappointed.