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
Once upon a time in the buoyant city of Techtonia, there were two competing departments that happened to be in a perpetual state of conflict: the Development Department, led by the innovative engineer, Smith, and the Operations Department, headed by the squeamish tech wizard, Ethan. Chapter 1: The Great Divide Smith and Ethan […]
Continue Reading
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
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
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 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
Box is a feature-rich cloud storage and collaboration platform. Box facilitates working on the same document among different users. Users can add comments, assign tasks, and quickly share their document with their colleagues. Box offers various security features including data encryption, access control, 2-factor authentication. You can also access your Box account using an […]
Continue Reading
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
.NET Core is a well-known and robust open-source framework for developing software applications of nearly all kinds. It offers a vast, but well-organized ecosystem of libraries and tools to help developers streamline and ease out their development process. In this context, several popular .NET libraries have gained significant traction among developers – offering a […]
Continue Reading
As an owner of an expanding business, you likely have many files to store, manage, and share. With growing data, traditional methods like local hard drives or USBs can become cumbersome. These storage solutions are also prone to hardware failure and security breaches, which can be disastrous for your business. The good news is […]
Continue Reading