Archive

Posts Tagged ‘SQL Server Management Studio’

SQL Server Management Studio v 17.7 is released

May 10, 2018 Leave a comment

SQL Server Management Studio v 17.7 is released and available for download from below links

New Install – https://go.microsoft.com/fwlink/?linkid=870039

Upgrade from previous v 17.x – https://go.microsoft.com/fwlink/?linkid=873128

There are lot of fixes and changes in this release, for more information, Please visit

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017#new-in-this-release

The main highlight feature of this release is support for Scheduling SSIS Packages deployed in SQL Azure and this will give a consistent experience for deploying and scheduling SSIS Package similar to on-premise SQL Server

Hope you find this information helpful !!!

Vulnerability Assessment using SQL Server Management Studio

April 9, 2018 Leave a comment

As part of SQL Server Management Studio v 17.4 release, Microsoft has released the Vulnerability Assessment tool, This is a very easy to use tool and helpful in identify the vulnerabilities at database level and tool also provides scripts and suggestions to re-mediate the vulnerabilities as well

In this article, we will see step by step how to run a vulnerability assessment, review the results and apply the remediation

Step 1: Please download and install SQL Server Management Studio v 17.4 or higher, Please refer to this link for details on download https://sqlxpertise.com/2017/12/11/sql-server-management-studio-v-17-4-is-released/

Step 2: After installing, Please run Management Studio and connect to target SQL Server on which you would like to run the assessment and select the database and right click on database name and click on Tasks and click on Vulnerability Assessment –> Scan for Vulnerabilities…

capture20180409120215159

Step 3: Please select the location where you would like to store the reports and click “Ok” to start the assessment

capture20180409120305266

Step 4: After assessment is completed, the report will be open as a new tab, The report will provide us the following details

a. How many security checks were completed ?

b. Number of Failed Checks and details

c. Number of Passed Checks and details

capture20180409120607579

Step 5: To review details of each failed check, Please select the failed check and see details on the bottom

capture20180409120633813

capture20180409120703593

capture20180409120716207

Depending on the check, the tool provides query to run the Rule and also script to remediate the issues as well

capture20180409120941664

After running the remediation scripts, we can re-run the assessment and verify the results, in below screenshot you can see that the High Risk vulnerability is resolved and also one of the Low risk vulnerability is resolved

capture20180409123120495

Step 6: If some of the checks are not applicable, Please use “Approve as Baseline” option

capture20180409123759719

If you want to revert the change, you can re-run the scan and go to Passed tab and select the check and “Clear Baseline

Step 7: To review previously run assessment results, Please select the database and right click and click on Tasks –> Vulnerability Assessment –> Open Existing Scan and select the folder and file where the scan was saved

capture20180409120815476

I hope you find this article useful !!!

SQL Server Management Studio v 17.6 is released

March 26, 2018 Leave a comment

SQL Server Management Studio v 17.6 is released and available for download from below links

New Install – https://go.microsoft.com/fwlink/?linkid=870039

Upgrade from previous v 17.x – https://go.microsoft.com/fwlink/?linkid=870041

There are lot of fixes and changes in this release, for more information, Please visit

https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-ssms

The main highlight feature of this release is support for Azure SQL Database Managed Instance

Hope you find this information helpful !!!

SQL Server Management Studio v 17.5 is released

February 16, 2018 Leave a comment

SQL Server Management Studio v 17.5 is released and available for download from below links

New Install – https://go.microsoft.com/fwlink/?linkid=867670

Upgrade from previous v 17.x – https://go.microsoft.com/fwlink/?linkid=867672

There are lot of fixes and changes in this release, for more information, Please visit

https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-ssms

The main highlight feature of this release is SQL Data Discovery and Classification, its now built-in as part of SSMS

capture20180216160446320

We will see how we can use this new feature in the next post.

Hope you find this information helpful !!!

Import Flat File Wizard–New Feature in SQL Server Management Studio v 17.3

October 10, 2017 Leave a comment

SQL Server Management Studio v 17.3 is released and available for download now, it packs lot of new features and updates

One of the most interesting features is “Import Flat File” Feature which can help novice to experienced users to load Flat file to SQL Server

capture20171010153301560

“Import Flat File” option is available at Database level under Tasks Context menu

capture20171010151258718

In this article, I am using FDA’ Orange Book Data product files for loading, as you can see this file is separated by ~

FDA Orange Book Data Files

capture20171010151446560

Please click “Next” to start the Import Flat File  process

capture20171010151620937

Please select the Input file, The tool is smart and it uses the File name as Target table name

capture20171010151714495

But if we prefer, we can change the Target table according to our needs or naming convention

capture20171010151751094

Click “Next” to proceed to “Preview Data” screen, In “Preview Data” screen we can see the sample records

capture20171010151752654

After previewing the data, Please click “Next” to proceed to “Modify Columns” screen, based on sampled rows, it automatically suggests the data types, but we can change the Data Type based on our input source specification, in this case, I have changed the “Applicant_Full_Name” to NVARCHAR(500) from NVARCHAR(100) and also we can specify Primary Key, which I have selected “Appl_No” and “Product_No” as Combined Primary Key

capture20171010152124723

After making required changes to Column definition, Please click to proceed, depending on the size of the data, the Import operation will run and complete

capture20171010152556076

You can click on the “Success” hyperlink in Result to view the Completed message, once reviewed, Please click “Close” to continue

capture20171010152600380

Now let us review the data imported, We can see the new table is created

capture20171010152614195

We are running a simple Select Query to see all records loaded, We can see 2499 rows are loaded

capture20171010152715115

This tools is really simple and easy to use, I believe you will find this article helpful

%d bloggers like this: