Tricks: Making Common Symbols Using Keyboard
♥ – Alt + 3○ – Alt + 9♫ – Alt + 14™ – Alt + 0153© – Alt + 0169® – Alt + 0174α – Alt + 224ß – Alt + 225π – Alt + 227Σ – Alt + 228µ – Alt + 230≡ – Alt + 240± – Alt + 241Σ – Alt […]
Continue Reading
Category: Tips-And-Tricks
Commonly Used Abbreviations
WiFi – Wireless FidelityWWW – World Wide WebHTTP – Hyper Text Transfer ProtocolGIF – Graphics Interchange FormatJPEG – Joint Photographic Experts GroupHTML – Hyper Text Markup LanguageURL – Uniform Resource Locator ISP – Internet Service ProviderGPS – Global Positioning SystemSQL – Structured Query LanguageSMS – Short Message ServicePDF – Portable Document FormatCCTV – Closed Circuit […]
Continue Reading
T-SQL Trick: Use Recursive CTE To Get Hierarchical Data
In a previous article we learnt how to use CTE (Common Table Expression) to render dates in a date range. In this example we’ll use somewhat advance technique to show a data in a heirarchical form. Using the regular T-SQL query this is almost impossible to achieve it without coding in a strored procedure […]
Continue Reading
T-SQL Trick: Use CTE to Render Dates In The Specified Date Range
Using a traditional programming language like C# or Python you can use “for” and “while” loop constructs to generate a sequence of numbers, dates, string values or anything else super-easily. But here we’ll learn how to generate date values in a specific range using Transact-SQL query. We’ll not use any SQL stored procedure. Let’s […]
Continue Reading
T-SQL Technique: Get Running Total Right From The Query
There are occasions when it is required to reveal running totals before rendering the grand total in a report. Usually calculating and providing running total is the job of a report designer software module. But if you’re using SQL Server database then Transact-SQL (a.k.a T-SQL) provides this facility right in the query. Let’s assume […]
Continue Reading
Control Your Windows Computer from Your Phone
There are occasions when you’re at a remote location, like during traveling, and you’re required to access your office or home computer, for instance to retrieve some important information from it. You may not have a laptop or a tablet at the moment but you’re likely to have a cell phone. Worry not! you […]
Continue Reading
Wifi Tips: Beware Of Potential Mistakes While Configuring Your Wifi
When it comes to Wi-Fi configuration and maintenance the Wi-Fi device manufacturers want to make your life a lot easier. That’s why they deliver routers and repeaters with numerous pre-configured parameters so that you don’t have to fumble through the configuration process while setting up your home network. But this auto-configuration – sort of […]
Continue Reading
How To Automatically Empty Recycle Bin From Windows 11
As soon as your Windows drive runs short of disk space, the Windows operating system starts to delete files that are probably no longer needed from the recycle bin and from your downloads folder. Still if you want to optimize your storage before running out of free space, you can change the configuration so […]
Continue Reading
MS Excel Techniques: Data Validation (Part 2)
MS Excel provides tons of dazzling data validation techniques in order to help you keep your data legitimate and refined. In the previous article we highlighted some basic validation formula with examples. To let you get a bit deeper dive into it, we’re going to explain a couple of more advanced validation features. You’ll […]
Continue Reading
MS Excel Techniques: Data Validation
MS Excel provides a myriad of built-in data validation rules based on custom formula that enables users to control and validate the data entered into cells, ensuring its accuracy, integrity and consistency. With Data Validation, users can define rules and constraints on cell values, helping to prevent errors and inconsistencies in their spreadsheets. This […]
Continue Reading