In the first part of this series, we learned SSMS productivity tips & tricks. Including drag column names, object explorer details. Furthermore, I demonstrated vertical scroll mode, BooksOnline shortcut & multiple batch execution. Surely all these productivity tips you should have tried to improve your work efficiency. Continue Reading

Countless developers are using SQL Server Management Studio (SSMS) to develop & design databases at work. Without any benefit of the doubt – SSMS IDE bundles with several amazing features and tools for developers. Alas, few of us really know valuable features and hidden tips and tricks within SSMS. Definitely, learning these SSMS productivity tips and tricks can save time and help to work more skilfully. Continue Reading

APPLY operators (CROSS APPLY & OUTER APPLY) brings a lot to programming in SQL Server. Different use cases can be implemented using APPLY operators. One of the most used UNPIVOT data operators can also be implemented with the CROSS APPLY operator. This tech-recipe post demonstrates how to UNPIVOT data using CROSS APPLY in SQL Server. Continue Reading

Arguably one of Macbook’s most-loved features, MagSafe is now available for iPhones. Learn how to charge your iPhone using the MagSafe Charger.
Continue Reading

With a quick tap on your iPhone’s screen, you can trigger your device to turn on its screen and allow you to check your notifications, use your torch, or get access to your camera. Learn how to use Tap to Wake on the iPhone.

For the longest time, waking up your iPhone requires you to press on the Home or Power button. Now, you don’t have to press the mentioned buttons if you want to wake your iPhone’s screen. After having it on a few iPhone users’ wish lists, Apple now allows it to turn on the screen just by tapping on it. If you’d like to learn how to use turn on your iPhone’s screen with a quick tap, then check out the next sections. Continue Reading

Slicers provide an interactive way to filter the data with list and buttons. It shows which filters have applied and a list of possible values in a presentable manner. Using the existing dropdown filter which lacks showing all the possible values on the sheet for presentation. Strongly recommended the feature Slicers when presenting data analysis to customers and stakeholders with an interactive dashboard. Continue Reading

Just as every destruction breeds creativity, so has the COVID-19 pandemic these days. As devastating as its continuous effects are, it has also provided the masses ample time. Time to finish books one started but never got to read till the end. To take care of household fixtures one barely got to notice due to a 9 to 5 job. But mostly, the lockdown due to the pandemic has led many to start learning new skills. Luckily, once the pandemic is completely over, companies will be hiring just as rigorously. So, check out the following 5 great tech skills to learn during the lockdown and improve your chances of getting hiring post-COVID or to polish your already-existing work portfolio.

Continue Reading

If you associated words like work and/tiring with Zoom, reconsider. Your time on Zoom can be made fun and exciting, too. For right after you’re done with a meeting with, let’s say, work colleagues, you can ring up your friends and play games on Zoom. Due to its high quality and functionality, it’s peoples’ top choice for a happy hour app. The more, the merrier! There are so many types of games to choose from. Want some starters? Keep on reading to find out some of the best games to play on Zoom to make lockdown more fun.

Continue Reading

Are you jealous of your iPad-user friends who can FaceTime and browse their Instagram feeds at the same time? Now, you don’t have to. You can now FaceTime while using other apps on iPhone. If you think that’s interesting, then read on.
Continue Reading

Clearing space in your device is vital, but can be tedious at times. In fact, you’d be surprised to know how much junk files are eating space in your device. When it comes to WhatsApp, media files－GIFs, audios, documents, images,etc.－are stored in your device’s media library, where you can see them every time. This is unlike media files from other apps, which are neatly tucked away in some faraway folder in your device. Want to clear all the WhatsApp clutter instantly? Keep on reading to find out how to free up WhatsApp storage space with storage manager (updated) without deleting important chats.

Continue Reading

COVID-19 poses a new problem for iPhone users – how to unlock an iPhone while wearing a face mask. If you find it a hassle to take off your mask or input your iPhone’s unlock code, then you may want to check on this article. This article will help you unlock your iPhone without removing your face mask or inputting the unlock code.
Continue Reading

SQLCMD is a command-line utility to connect and execute SQL queries from the command prompt. Using SQLCMD we can only connect to SQL Server instances. Importantly we can run ad-hoc as well as interactive script plus automating SQL scripts execution. This utility is pre-installed with SQL Server installation. Instead of relying on SSMS for quick tasks, we can use SQLCMD utility to execute SQL queries through ad-hoc statements or .SQL files. Continue Reading

Google Drive isn’t just an excellent repository for documents. It’s also equally great to safely store video content.

If you’re wondering how to upload your videos to google drive, there’s a couple of ways to do this. We’ll discuss these in this tutorial. Moreover, once you’ve uploaded a video to Google drive, you can also view and edit it just like you can view and edit your Google drive documents. However, you need to assign proper permissions for this.

This article will mainly focus on adding videos to Google drive for future accessibility. Continue Reading

During these COVID-19 days, the trend of Zoom meetings and conferences is not slowing down any time soon…but so is the case with Google Meets. Professionals, large conglomerates, home-based tutors, everyone alike is using it, all the same, to meet virtually. It’s just as simple and convenient－perhaps more so－than setting up a Zoom meeting. Keep on reading to find out everything you need to know about how to schedule a Google Meet, invite guests to join, set timings, time zones, dates, add additional notes for guests and more. The steps are for the desktop version; it contains more features.

Continue Reading

SQLCMD is a command-line utility to connect and execute SQL queries from the command prompt. Using SQLCMD we can only connect to SQL Server instances. Importantly we can run ad-hoc as well as interactive script plus automating SQL scripts execution. This utility is pre-installed with SQL Server installation. Instead of relying on SSMS for quick tasks, we can use SQLCMD utility to execute SQL queries through ad-hoc statements or .SQL files. Continue Reading