Data Recovery

2 Effective Solutions to Solve Errors when Copying Formulas

Most of the time, we will use Excel to do some calculating. During the process, we will certainly use the formulas in Excel to help speed up the process. Thus, we have the ways to solve errors when copying cells with formulas. The formula in Excel shows its powerful capabilities. But in some cases, we need to use the results produced by those formulas in other worksheets. If we don’t know which number is the result of calculation, we will meet with some troubles. If we simply copy it and...

Read more »

2 Ways to Move or Swap Columns or Rows in Excel

In an Excel file, sometimes you may input some information to the wrong cells. Hence you should change the position. Therefore, today we have the Excel tips of moving or swapping columns or rows in a worksheet. Sometimes in an Excel file, you need to input a lot of information into it. But things are not always perfect, and Excel files are no exception. There is a possibility that you need to switch information of different columns or rows. And for instance, here you can see a worksheet of...

Read more »

SQL Server Profiler – A Primer

In this article we introduce you to the SQL Server Profile feature which can be used to run a trace Microsoft recently launched its much awaited SQL Server 2016 and one of the most talked about feature it encompasses is the SQL Server Profiler. For those of you, who are not aware of what this feature is all about, let us acquaint you that it is actually an interface created to help the user manage and create traces for better analysis and replay of traced results. In other words, an SQL...

Read more »