In this short how-to tip, we will see how you can use a percentage formula in Excel. Example of Excel Spreadsheet Below, you can see an example of an Excel spreadsheet, that contains some sample values, based on which we will create a percentage formula. As you can see, the spreadsheet has 3 columns: Month/Year … Read more
In this article, you will learn step by step, how to create a Formula in a Microsoft Excel Spreadsheet. We will try to answer the above question, using a simple example. Our Sample Excel Spreadsheet To this end, let’s consider that we are working on the below Excel spreadsheet: As you can see … Read more
In this post, we will see how to easily create databases in SQL Server. To this end, we will see a relevant example along with a short video. Connecting to SQL Server with SQL Server Management Studio (SSMS) The first step, prior to creating the database, is to connect to SQL Server, in our … Read more
Introducing: Snippets Generator This software review is about SQLNetHub’s Snippets Generator. Snippets Generator is a productivity tool that can help you work faster and more efficient, when working with SQL Server Management Studio developing SQL scripts. Snippets Generator, via its intuitive Graphical User Interface (GUI), enables you to easily create SQL snippets which you … Read more
Hi friends, in this post, we will be discussing about, how you can remove a saved Skype for Business password in Windows. Why Removing a Saved Skype for Business Password? Removing a saved Skype for Business Password is a completely optional thing to do. There will might be scenarios, where you do not want … Read more
Hi friends, in this article, we will be discussing about T-SQL snippets in SSMS (SQL Server Management Studio). What is a T-SQL Snippet? In the Computer Programming world, a snippet is a piece of reusable source code that can be easily incorporated into larger sections of code. Similarly, in SQL Server, a T-SQL snippet … Read more
Hi friends, in this article, we will be discussing about the necessity and process of securing your SQL Server instances. SQL Server and Azure SQL Database are two of the most complete and powerful data platforms in the world. With SQL Server and Azure SQL Database you can store and organize structured, semi-structured and unstructured data and … Read more
This article discusses about installing .NET Framework 3.5 on Windows Server 2012 R2 by modifying the Windows Group Policy settings. When you try to install .NET Framework in Windows Server 2008/R2, Windows Server 2012/R2 or even in Windows 8/8.1/10 and you get errors and cannot install it, you can try the technique of the “Alternate … Read more
Hi friends! In this article, we will be discussing about, how you can use Dynamic Memory Allocation in Java, and see a relevant code example. What is Dynamic Memory Allocation in Java? In Java, Dynamic Memory Allocation, is the ability for a program, to obtain more memory space during it’s execution when needed (i.e. … Read more
Hi friends! In this article, we will talk about, how you can read a text file in Python. Also, we will see a relevant live demo. Reading Files in Python with the open() Function Python has the built-in function “open()“. As the name implies, using the open() function, you can open files in order … Read more