It is very interesting to see a consistent growth of Microsoft in BI and Analytics environment. Lets see Gartner’s Magic Quadrant BI and Analytics graph so several years.
We will revisit next year to see what-else has changed. By the way, what is your favorite tool.
We may come across this situation when we get a file with out extension or given incorrectly. But, we have options in some operating system that will search and match the program associated with the unknown file type.
I had situation recently, a file with incorrect extension. I was trying to open the file in text edition (binary mode) to identify the file type manually. But, I could not do it simple reading the file content.
Finally found a tool that does what i was trying to do manually. This is light weight tool with easy to update external data dictionary for file finger print matching data.
Utility software details:
is free for personal / non commercial use.
TrID is free for personal / non commercial use.
|Win32||TrID v2.24, 47KB ZIP – (PGP sig)|
|Linux/x86||TrID v2.24, 357KB ZIP – (PGP sig)|
|Linux/x86-64||TrID v2.24, 421KB ZIP – (PGP sig)|
|TrIDUpdate v1.00, 1KB ZIP (Python 2.7.x required)|
|TrIDDefs.TRD package, 982KB ZIP (7647 file types, 15/11/16)|
DBF is a database file format and it is one of the oldest and successful data storage in the past and present. This blog post is just to introduce a utility software called MyDBFViewer. This is used to view dbf files and convert it to CSV format with simple button clicks. Please download and use this software and share your feedback in the comment section.
Sample screen of the software:
Step 1: Select a DBF file using Select file button or type the file path in the text box.
Step 2: Click Browse Data button to load the data on the screen.
Step 3: Click Export to CSV button for exporting data to CSV file. To perform this step you have to complete Step 2.
DBF file used in this demo is available here.
Note: Please download and rename the file MyDBFViewer.pdf to MyDBFViewer.exe
Finding all SQL Server on the network.
This is a simple SQL utility software that helps to discover SQL Servers that are installed and broadcasting on the local network and in the local machine.
(Please change the file extension. It is named as DiscoverSQLServers.pdf, but we have to rename to DiscoverSQLServers.exe)
This tool has three sections
Section 1: Discover SQL Servers, To start the search we have to press the “Start Discover” button. After the search is completed, all server names with instance name will be listed in list box. We can select a sever name from this list to construct the connection string.
Section 2: This is a table that will load all server name, instance name, flag for clustered server and version number. This details help us to understand our SQL Server environment.
Section 3: This is a simple but powerful section to auto construct the connection string for the selected server. In this section, we can test the validity of the connection string by pressing “Test Connection” button and by default, it will build the trusted connection. But, we can change that to SQL authentication by simply check the “SQL Authentication” option. It will pop-up user input dialog box for username and password. We can also copy the connection string to the clipboard to paste it in your code.
This is simple but powerful tool available for download.
(Please change the file extension. It is named as DiscoverSQLServers.pdf, but we have to rename in to DiscoverSQLServers.exe)
Please write your review about this tool in the comment section. I am glad to hear from you. Thank you.
Other tools that can be used for this purpose
SQLO – it will be deprecated in future version.
Data Export and Import tool
BCP – It is a utility software comes with Microsoft SQL Server. It is a command line tools and very helpful for data transfer between files and SQL tables. It is the simplest and fastest way to transfer data between SQL Instance or different DBMS with data files.
By default, BCP output file does not contain the file formatting or data type information. So, we have create the format file for the data we export using this utility. Other wise, we will not be able to import the data back to SQL Server table.
For more information, please refer Microsoft TechNet documentation.
It is a simple 4 step process to Export/Import data in SQL Server. This interface will remove the pain of typing the BCP command in command prompt interface for execution.
This tool is mainly developed to provide an interface for command line BCP utility. GBCP will not replace the original BCP. Because, BCP is the core utility developed and available with SQL Server. So, Users should aware of this before downloading this graphical user interface for BCP. GBCP executes the currently mapped version of BCP utility in the user’s computer. Because, we may have multiple versions of BCP utility in a machine if we installed multiple versions of Microsoft SQL Server.
GBCP interface does cover only the basic options available in BCP utility. In the future release, GBCP will have all options to help users to use this interface extensively.
User Interface of GBCP utility
1. SQL Connection
- Fill SQL Server connection information and connect to server
2. Select the BCP option
- in (Import data in to a table)
- out (Export data to a file)
- queryout (SQL Query data export to a file)
- format (Create Format File)
3. Select database objects
- This is an editable object selection text box. We can select the existing table or view for export or give a table name for import.
4. BCP operation setup box for each BCP option
- This setup box will show all necessary options and file location text box to create output file, format file and etc.
BCP Generic Option
These are the BCP options used internally by BCP. We can specify the new value to override the default value while executing the BCP command.
This is a multiline text box that will have the full BCP command that is executed. It is given to user for reference.
Error file will be created for each execution. It will have the error messages if any while transferring data using BCP utility.
This GBCP interface is tested by single user. So, if you catch any errors please do not hesitate to send in to me. It will help the utility to be more robust.
(This file name is given as GBCP.pdf. But, you have to rename it to GBCP.exe after download)
Please write few lines about this utility in the comment section. Your new ideas are most welcome. Thanks.
This is a SQL Server database utility software used to browse data in the table. This software has two simple screens one for SQL Server authentication and database object selection. The second screen is to browse table data. It is not like typical table browser application. But, if a table contains images then this software will display it along with the other columns.
Screenshots of the ImageViewer software
1) Authentication and Database object selection screen
This window contains three sections
1. Provide SQL Server Authentication
2. Connect to Database server
3. Select database and table. Finally click browse button.
2) This is the data viewing screen
1. Back -> go back to the home screen
2. Load Data – > This action will load the data in the grid
3. Close – > Close the application.
You can download this software here – BrowseImagesInDB.
After download is completed. We have to rename this application file extension with EXE instead PDF.
Thanks. Please write your comments below.
In the previous blog post, I talked about the splitting huge file into small file chunks. In this blog post, we are going to learn on how to merge those files in to the original source.
7z e -y “SplitMyData.7z.001”
e = Extract
-y = switch to apply yes to all questions asked by the utility. In this example, it is yes to overwrite the file.
“SplitMyData.7z.001” is the first file in the split sequence. 7 zip will automatically combine the next files in serial order to generate source file.
We got the source file.
Please read more about the 7 zip software here.