This simple post highlights the top level updates on components in SQL Server Management Studio.
The latest release of SQL Server Management Studio v17 RC3 has updates on below section compare than the earlier version.
I have discussed Custom Reports in my earlier post, this post highlights the limitation of custom reports in SQL Server Management studio.
Microsoft provided few custom reports for R services. When I use those custom reports, SQL Server Management Studio has stopped working for all the reports.
Then I started to check the reports in visual studio. When I check the reports, it used some of the expressions which SQL Server Management not support.
Download the modified version of R Services Custom Reports.
It is very easy to create a custom report and use it inside SQL Server Management Studio.
As we know, we have standard reports from Microsoft to monitor the Server and Database information.
These reports are available for instance and database level, If you are not aware of this standard reports, please check it below to access those reports.
Steps to use custom report in SQL Server Management Studio.
Just created a Report as like below,
We need to adjust the data source properties to use inside SSMS. Modify the data source like below. Once modified the data source, save the report. We will take this rdl file and attach in SSMS.
Once added the report, open and see the information.
Now, you can refresh the report and see the real time information and even you can build a report to specific database for monitoring purpose.
We need to follow the below steps to connect the azure based SQL Server in SSMS
1. Add the client IP address in azure firewall
2. Use the azure SQL Server name with proper credentials.
The above steps should be carried out until SQL Server 2016 to access the SQL databases in SSMS.
If IP is not configured then SSMS will not allow to connect, it will through the below error message.
SQL Server 2016 CTP 3.3 has built in feature to add the IP in azure SQL Server firewall from SSMS itself.
Follow the below steps,
1. There is no IP configured in Azure SQL Server Firewall
2. Enter the server name and credentials and click connect. It will open a Azure account sign in window
3. Server will be connected and can access the databases. Client IP address added into firewall.