How to view documents using Visual Studio

View documents in Visual Studio with an amazing tool

Xpath Axes

A very useful trick for automation

Review: Spire.DataExport for .NET

A great tool for exporting data in .NET

How to install Arch Linux, step by step, for VMware Workstation (Part I)

First part of a installation tutorial for this beloved OS

How to setup a local repository in Ubuntu

The steps to have a local repo in Ubuntu

Thursday, September 7, 2017

Hotspot software to administer your Wi-Fi


Introduction

Do you have a restaurant, Hotel, Pub or any other public area with Wi-Fi ?
Do you need to control the Wi-Fi access for your users?

Now it is possible to do it with Antamedia Hotspot Software.


After testing several different applications for Wi-Fi Hotspot, now I can say that Antamedia Hotspot Software is the best.

Why?

Here you have some of the main features:
  • Very easy to install
  • Easy to learn and configure
  • Great performance
  • Support for customer surveys
  • Few hardware requirements
  • Integrated with TripAdvisor and Yelp
  • You have different login options
  • Integrated with Facebook, Twitter, LinkedIn, Google and VK. 
  • Cool themes
  • Paypal support
  • Automatic marketing emails
  • Easy to configure internet plans per location
  • Can be integrated with Oracle Suite PMS 
  • Cloud integration (Ruktus, DDWRT, etc)


You can use this software to create a gateway to provide internet to other devices and it is very easy to control the time that it is used, the bandwidth, URLs allowed, etc.


Installation

This software provides thousands of options to administer the HotSpot service and it is very easy to install.

It takes just a couple of minutes or less to install it. It does not require an expensive Server to install it. You can for example install HotSpot in a Server with 2 GHz processor.
It supports almost any Microsoft Windows edition including 32 and 64 bits (Windows 2003, 2008 and 2012, Windows XP, Windows 7, Windows 8 and Windows 10).


  



Install this software is fast and very intuitive. It does not require to be an IT expert in networking to have this software ready.

Getting started

Once it is installed, you have 3 roles configured (Administrator, Operator and Manager).
After installed, you need to configure the software. With other HotSpot applications, it is really hard to configure the network. In many cases, I rejected the software solution because it was really hard to learn and understand.

This is not the case with HotsPot Software because the configuration is simple and it offers the autoconfigure which is extremely useful to non-experienced administrators.  With HotSpot Software, you can easily configure the most important settings in few minutes with few clicks.


 

  
I really loved not only all the settings available, but also, how you can easily configure all of them.
You can easily configure DHCP and exclude IPs, block the IP or block by MAC address. It includes Speed Boost that allows to increase or decrease the internet speed according to a schedule configured. For example, you can configure an IP to navigate from 8 to 12 AM or only at night or only on weekend or working days.

 
  
It is also possible to create invoices for the internet used. The customer does not require additional software to use this Hotspot service. You can login with a login and password or using a code provided by the service.
  
Another interesting feature was the option to configure the way that the customer connects to HotSpot software. There are several options starting from a login page. You have 12 options inside the login page like an alphanumerical ticket, a login and password, the hotel room number, customer email, the room number plus the phone number, etc.
It is also possible to provide free access, but with different options like a shared keyword, free access by just accepting the terms of use or even by using social network accounts.

 



It is also possible to change the theme of the home page for the customer according to defined rules. For example, according the Wi-Fi location or the name of the location according to the days and hours.
 

    
The user can get the user information by setting surveys and it also includes several templates for surveys or if you prefer, you can create your own customized surveys. The user can review the surveys using date filters, account filters, location filters and these surveys can be linked to TripAdvisor.
Another interesting feature is that you can create free accounts, paid accounts, pre-paid accounts, recharge credit to accounts already created and these accounts can be linked to different plans. For example, you can limit the internet speed, time, navigation quotes, expiration dates, etc.

  

You can easily administer the time navigating or set a quota to limit the GB to navigate or enable or disable users:


It is also possible to create usage reports:



     
Conclusion
It is really hard to explain all the features that Hotspot Softwawre de Antamedia includes. It may require a book for it. However, I am sure that this software accomplishes most of the common requirements for IT administrators because HotSpot is easy to install.

The software is flexible, it offers a great number of features and configurations to customize according to your needs. That is why I am sure that it is one of the best HotSpot options (if it is not the best).



Wednesday, July 19, 2017

How to Outsource a Software Development Project

Software Development Outsourcing – How to Finish Your Project on Time and with No Bugs
Outsourcing has become a very great option for businesses from various industries. The outsourcing process is lucrative because it allows companies to get the job done with single payment, without the need to hire a person to remain on a payroll for longer periods of time. This lowers the financial costs for the company, enabling it to invest in better areas for faster growth.
This opportunity has made changes in the global market. Therefore, it is now a logical option that millions of companies pick every day. If you are interested in software development outsourcing, the following tips will help you run the process successfully, without missing deadlines.

A project management tool

Only a decade ago, online communication was quite challenging. There were quite a lot of methods of communication, but they were more aimed at consumers than businesses. But, as technology has evolved, a variety of project management tools have hit the market. If you are planning to outsource any type of task to a third party, using a project management tool is necessary.

These tools are practical because they offer the following benefits:
  • Clear instructions – All of the project instructions can be included in the project management tools. Additionally, it is possible to add documentation in the audio, video or text format, making the communication even better.
  • Task Management – Tasks can be easily created for easier project management.
  • Improved collaboration – Tools are specifically created for collaboration. The whole workflow is simply much easier to establish.
  • Project progress insight – At any time, you can easily see the state of the project’s progress, and whether it is going to be finished within the given deadline.

It is quite clear why a project management tool is necessary; it simply takes away any issues created by the fact that teams from different geographical locations are collaborating remotely. Therefore, if you are planning to outsource a software development project, make sure to rely on a project management tool.

Detailed documentation

During the outsourcing process, issues usually arise due to a lack of information. This is especially important for the software development outsourcing process. Make sure that the project is well detailed and completely explained.
The point is to determine exactly what you know from your project and what the end product should look like. Without detailed documentation, you are likely to keep bouncing back and forth when setting the deadline, and eventually receiving a product you are not satisfied with.
Therefore, before you start the collaboration, create a plan that is going to be clear.

Project segmentation and testing

If you are expecting to simply send documentation and follow the project progress without any interference, you are not going to receive the best, bug-free product. It is necessary to implement a project approach similar to SCRUM.
This will allow you to set up several milestones. Upon completion of each of the milestones, you can review and test the software product to determine its stability and consider if any additional features would make it more useful. This whole process should be repeated several times to ensure that the project is headed in the right direction.

Once the outsourced team has finished working on it, you are going to receive precisely what you were expecting that is a bug-free finished product within or before the given deadline.

Technology has come far enough that you can outsource a business process without any need to worry about communication. The thing that matters the most is how detailed your project plan is going to be. The more things are taken into consideration, the more likely it is that the project will be finished within a deadline. Follow the above-mentioned steps, and you can expect to receive a high-quality product from your outsourced team.

Author Bio:
catherine (2).jpg Catherine Park is a professional Content Writer and a blogger full of energy and positivism. She currently works on the BackOfficePro team, a business process outsourcing firm. She is an expert in writing exclusive content on business and technologies that are helpful for large enterprises, SMEs and business startups.

Follow her on Twitter & Facebook for upcoming articles!

Friday, July 7, 2017

How to create custom forms in SharePoint

Introduction

As a Web site administrator in SharePoint, I am always looking for new tools to help in the design and development of SharePoint forms because sometimes it is hard to customize your forms to provide a good user experience in SharePoint. That might imply much expenses and require a lot of time. That is why it is necessary to have a new tool to help us enrich the functionality of the SharePoint Forms.


KWizComForms is a plug-in that can be used to create customized, robust and advanced forms in minutes with a minimal knowledge in the SharePoint Forms design. There is also a SharePoint Online version of KWizCom Forms App for Office 365.



I will show you my experience with KWizCom Forms after doing some tests and let you know my point of view about it.
Getting Started
Let's take a look to a simple demo about this KWizCom Forms feature.
We will first show how to hide fields dynamically according to a user or user group.

First step

In this example, the field "Full name" will be hidden when a user or user group contains the string "Jose". To do this, you need to select the field to be hidden (Full name), assign a permission type (hide) and check the page types required:



It is necessary to create the condition specifying that if the user name contains the word Jose, the field full name will be hidden:


Second step
If you try to open the form with a user named Jose, the Full name field is hidden:


Third step
If you login with a user whose name is not Jose, the full name field is displayed:



This is a very useful feature, because we can configure fields according to the user groups and user names. For example, we can hide the salary to the marketing group, but have the field visible for the Financial group.

How to add error messages according to field values

Sometimes we need to display error messages according to specific values. In this example, if the sender bank is Montesori Bank and the delay days is greater than 90, we want an error message specifying that the delay cannot be higher than 90 days.

To do that, we will choose the Sender Bank field as the field to be validated (validate field) and we will also specify the error message:

The rule created is that if the Sender Bank is Montesori Bank and the Delay days is greater than 90, the error message should be displayed.


If we open the SharePoint form, if the name is Montesori, an error Message is displayed:
Dynamic default values
You can also specify dynamic values according specific user or user groups or according to specific field values. In the next example, we will create default values for the Sender Bank and C.I for the user named user:


The sender bank value by default, will be Mike Bank and the default value for the C.I. will be 10000001:


If we open the SharePoint form, the values are set by default according the user specifications:

 And that is not all. With KWizCom Forms you can also:
  • Use custom expressions
  • Work with Tabs
  • Import and export configurations
  • Support multiple languages
  • You can print and convert forms to PDF files
  • It is compatible with multiple browsers
  • It allows to create custom actions
  • You can create KPI
  • And more


  
Conclusion
In my experience, this tool is very powerful to create forms in SharePoint when you try to enter data using SharePoint list that allows to have a robust form with a complete set of validations and configurations with custom level of permissions, etc. To create all these rules and constraints without the tool you may need a team of developers with a lot of experience with SharePoint to create forms using InfoPath or other tool. This tool allows to have robust forms in a few minutes and does not require you to be an expert in forms. That saves a lot of resources, time and money to the companies. 




Wednesday, June 7, 2017

How to recover a corrupt SQL Server table if I do not have a backup?


Introduction

It is very common to lose some data and have a table or a database corrupted because of hardware problems, un unexpected server reboot, a virus, a worm, malware.

In my case, I had a table corrupt.

This time we will show how to recover data from a corrupted database. If we do not have a backup, it is sometimes hard to recover the data. We will show a simple way to do it, with a special software.

Getting started

I just run the following T-SQL sentence:

SELECT TOP 1000 [CustomerID]
      ,[NameStyle]
      ,[Title]
      ,[FirstName]
      ,[MiddleName]
      ,[LastName]
      ,[Suffix]
      ,[CompanyName]
      ,[SalesPerson]
      ,[EmailAddress]
      ,[Phone]
      ,[PasswordHash]
      ,[PasswordSalt]
      ,[rowguid]
      ,[ModifiedDate]
  FROM [AdventureWorks2012].[SalesLT].[Customer]

The error message received was the following:
Msg 824, Level 24, State 2, Line 2

SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xd3e289a2; actual: 0x90e7d9a6). It occurred during a read of page (1:469) in database ID 5 at offset 0x000000003aa000 in file 'C:\sql\AdventureWorksLT2012_Data.mdf'.  Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

My table was corrupted and I need to repair it.
This is because some sectors have errors. If we do not have a backup, is it is possible to repair the table?

This time we will show a nice and very intuitive tool to do it.

Stellar Phoenix SQL Database Repair


This software is a simple tool to Repair your database. You can download the software using the following link:


This software allows you to:

  • Repair corrupted data files.
  • You can also recover tables, views, keys, indexes, rules and defaults with this tool.
  • Recover deleted records.
  • You can search and recover data objects.
  • It supports SQL 2016 and lower versions.

Let's take a look to the tool.

First install it and then open it. This software has a 5 MB installer. It takes few minutes to have it ready.

Once installed, press the Select Database icon:




You will need to find the mdf file corrupted. In the error message in red displayed before, SQL Server told me that the file corrupted was this one:

C:\sql\AdventureWorksLT2012_Data.mdf

This software repairs mdf and ndf files. The mdf files and ndf files are the primary and secondary files where the database information is stored. Sometimes the databases have just the primary data file, but if it is a big database, it may have several data files to store the information. Select your data file:




 Once selected the data file, press the repair button:


The program will ask the SQL Server Version. As you can see it supports from SQL Server 7.0 (released in 1998) until SQL Server 2016!

You may need to register the software to save your repaired database:


If the database is repaired successfully, you will be able to run the query:


Conclusion
As you can see, it is very simple to work with Stellar Phoenix SQL Database Repair. You just need to select the files to repair and that is all, you will have your database back again.

This tool is simple to use, it takes few minutes to install, run and learn. I strongly recommend this software.

Wednesday, May 17, 2017

How to Recover Deleted Video from an USB drive


Introduction

When your device is full, you usually need to delete the old videos, images and sometimes, we delete by mistake important familiar or personal photos or videos.

Is there a way to recover the information from an USB drive?

Fortunately, yes. There is an advanced software named Flash Memory Recovery that you can download from the following site:

This software recognizes different manufacturers of cameras like Nikon, Canon, Agfa, Fuji, JVC, Kodak and many other manufacturers. You can also choose the option generic if your camera is not on the list.

The software is a Windows software and it is very simple and intuitive. For Mac, there is a
USB Flash Recovery for Mac.The installer has 7 MB and it is very simple to install (Just some few next, next and next).

You can easily recover videos, photos, music or other file types.

Requirements


  • This software is currently supported on Windows 10, 8, 7 and XP according to the web site. I also tested on my Windows Server 2012 and it worked fine.
  • The USB Flash Recovery installed.
  • An USB Drive with a Video.

Getting started
In this demo, I will show a video, delete it and show how to recover it using the tool. I am assuming that Flash Memory Recover is already installed.

Step 1

In the USB Drive, delete a video:

Step 2
Open 321Soft Flash Memory Recovery to recover the video:


Step 3
Specify the licence or run the demo version. The license costs 49.95 USD:


Step 4
 A welcome wizard with a description will be displayed:
Step 5
Next, choose the File Type and your device manufacturer. In this example, we will choose a Video to recover and the All Devices option in manufacturer, This software supports Sony, Nikon, Canon and many other manufacturers. You can recover images, music, videos or other file types:




Step 6
Select the drive with the video deleted. In this example the drive E:\, is the drive with the file that we want to recover:

Step 7
You can check the options and you can choose the destination folder by pressing the Change icon. In this example, the data recovered will be on the c:\backup folder:


Step 8
In this step, will scan the USB Drive and recover the information. The video name is not recovered, but the extension, duration and size is displayed. Select the file to recover.



Step 9
Finally, you will save the video that you will be able to see the video in the folder specified:




Conclusion
As you can see, Flash Memory Recovery is very simple to install and use. In this article, we learned how to recover a video from an USB Drive, but it is possible to recover many other file types from different types of flash memories.

Wednesday, April 12, 2017

Amazing developer tool for SQL Server


SQL Assistant is an incredible tool that can be used for several tasks in SQL Server and other databases like the following:

Generate sample data

My favorite feature is the possibility to create sample data. With this feature, it is possible to generate sample data. You can populate tables with sample data by right clicking and selecting the option SQL Assistant>Generate Test Data:



You can specify the number of rows of the sample data (in this sample 1000 rows) and then press the Generate button to generate the sample of data:


The software will give you the choice to store the project settings:

If you open the table, you will be able to see that 1000 rows were created:


This is extremely useful to make tests in our apps with several rows and test the performance with real amounts of data when we connect to databases.

Generate scripts to insert data

With SQL Assistant, you can generate a script to insert all the data. This is a fast way to export the data for the tables or to generate the insert code in a fast and easy way. To do that, in the context menu, go to SQL Assistant>Script Data:

Select the tables that you want to use to generate scripts:



You will be able to see the T-SQL scripts created with the insert data code. This is a very simple way to populate empty tables or export data:



Generate scripts to create tables, views and other objects.

The script DDL option is used to define objects. Generate the objects' code for tables, views and stored procedures:


You can select database objects that you want to create generating T-SQL scripts:


As you can see, the scripts are generated to create tables or other objects using few clicks:


Generate stored procedures
The option Generate SQL Code allows creating stored procedures based on the tables. Chose a table with data and select the option to test:

As you can see, the code is generated to delete, select and update the data when the generate button is pressed:

What you will have is 3 stored procedures to delete data from a table with a given primary key specified as a parameter. Another procedure will get the columns with a primary key specified and finally, the third procedure updates the data:

The stored procedures are very important to integrate the tables with the software applications. It keeps a safer code and it is harder to attack with sql injections to the database.

Export data to Excel (xls, xlsx, csv, xml, JSON, TBL.
Other important feature is the export data option. SQL Assistant can export the data to different formats like XLSX, XLS, CSV, JSON, TBL, XML:



If we export to Excel, we can see the tables with a format specified by default. It is possible to customize the format according to your preferences:



To export to different formats, it is necessary to have MS Excel installed.

Diagram creator

It is also possible to create diagrams of tables and views using the Create Database Model option:




You can select the tables that you want to include in the diagram:

Also, you can include the views:

It is also possible to import the stored procedures in the diagram:



To end the diagram wizard, we have the diagrams that can be customized according the customer preferences:

Unit tests
The unit tests allow to test the right functionality of the database objects. We will press the right button on a table and specify the option SQL Assistant>Unit Tests:




Unit test creates insert, select, update and delete code. It is necessary to edit the code to run it:


Other features
  • There are several other features like the Data load where you can load data to test a heavy load, you can compare the objects of 2 databases, compare the data of 2 tables and more.
Conclusions

As you can see SQL Assistant is an incredible tool. This tool was tested here in SQL Server. However, this software can be used in MySQL, SAP, DB2, PostgreSQL, Amazon, Teradata, IBM Netezza, MS Access, SQLite and Oracle.

This software also includes intellisense features that helps a lot to write T-SQL code in an intellegent and efficient way.

I really recommend this software to help on daily tasks.