Excel Tips
Excel shortcut to select an entire column
How to select an entire column of data with Excel, i.e. all the way down fron the top the end? To select the current column down to the last cell, you can use …
Month: January 2022
SQL Server Strings
Split text after character with SQL Server Substring
How to split a text after a particular character with SQL Server… like for example a file name: “file.txt” to separate the file name from its extension. Indeed, it is obvious that splitting …
Excel Tips
Disable the direct edit option in Excel
With Microsoft Excel, how to deactivate the direct modification option to edit spreadsheet cells? That is, the function of automatically modifying the content of a cell when it contains a formula? Indeed, by …
Useful SQL
Insert into from a select query in SQL Server
How to write an Insert into query from a Select with SQL Server? There are three solutions for running an INSERT INTO query with a SELECT in SQL Server. The first solution is …
SQL Server Database
Empty the SQL Server transaction log to fix error 9002
Microsoft SQL Server database is slow, or the available disk space is getting abnormally small? To solve this problem, it is sometimes enough to empty the SQL Server transaction log and reduce the …
Word tips
Insert a comment in Word margin
How to insert a comment in the margin with Word, that is, a visible remark? This Word tip applies to versions 2003, 2007, 2010, 2013 and also to the most recent Word versions. …
IT Concepts
EPM or Enterprise Performance Management definition
What is EPM or Enterprise Performance Management, also known as Performance Management? is a field of Business Performance Management or BPM. It considers the visibility of operations in a closed-loop model across all …
