This article addresses the newest features of SQL Server Management Studio 17. 3, particularly Import Flat File Wizard and XEvent Profiler, and how users can use them to increase their efficiency.
When it comes to managing nearly any SQL infrastructure, most DBA swear by SQL Server Management Studio (SSMS). In its effort to make this application more effective, Microsoft regularly updates with. The latest iteration, SSMS 17.3 supports all features of SQL Server starting from the 2008 edition to the latest 2017 version. Apart from all the bug fixes and enhancements, the latest SSMS comes primarily with two major features:
- Import Flat File Wizard
- XEvent Profiler
Import Flat File Wizard
This wizard allows users to streamline import experience of files (.txt, .csv) into an intelligent framework, which requires minimum specialized domain knowledge and user intervention.
Importing flat file to a database or a SQL table is a common task for all users. The existing Import wizard in SSMS offers a broader set of import configurations and capabilities for defining SQL Integration Service Packages. This is useful in many cases. However for performing a simple task like importing file to a table, it would work best with a streamlined experience.
There was a requirement for a technology or a tool, which can help simplify the user import experience, by reducing the required user configuration for importing flat file structures efficiently.
New Import Technology
To address the need for this new feature, we will be using an example. Through this example users can see the benefits of the new feature up close, by using the any identity pattern raw-structured data in their system, to perform this predictive file splitting, which will allow the wizard to understand and ‘learn’ the structure of flat file, including all the types, delimiters and column names present in the data file.
Steps to Transfer File using the New Import Feature
- Step 1: Select the flat file you want to insert in the table.
- Step 2: Right-click on the flat file and select ‘Import Flat File’.
- Step 3: Set the location where you want to import the file and also set the name of the Table.
- Step 4: Your flat file has been imported.
This simplifies the import process by limiting user requirement who only needs to provide a unique name and the input file name, and the rest is taken care by the wizard.
XEvent Profiler is an excellent way for customizing and launching SSMS features, which instantly displays the live target view for all extended events.
The existing extended event functionality in SSMS offers a flexible definition for views and sessions. However, it lacks the ‘Instant Quick View’ feature of SQL Profiler. XEvent Profiler is capable of generating that view, with a similar speed as a SQL Profiler. XEvent Profiler also provides a customization view, which can be used for sharing it with other users of SSMS using *.viewsettings file.
These two new features will add a lot of efficiency and speed at your workplace. We recommend our users to try these features now and we guarantee they will be using XEvent Profiler over SQL Server Profiler and they sure will be importing dozens of flat files to their tables without any hassle. Both these features are designed to limit user interference in no productive areas of the data transactions. SQL’s XEvent Profiler also makes it easier for the user to display events and share data on a live target view, which can help save a significant amount of time and energy at any organization.
Despite the latest advances, the SQL Server 2017 edition still remains vulnerable to data loss and hence companies should invest in a specialized sql server repair tool to deal with contingencies.
Victor Simon is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including access recovery and sql recovery software products. For more information visit https://www.datanumen.com/