Showing posts with label SQL Server 2014. Show all posts
Showing posts with label SQL Server 2014. Show all posts

Tuesday, May 10, 2016

How do you transfer databases between two SQL Servers?

You can do it in a couple of different ways but this post shows you how you may do using the Export/Import Wizard. In particular, the post shows you, step-by-step, Copying the pubs database on a developer's edition of SQL Server 2012 to a developer's edition of SQL Server 2014.





Follow this step-by-step Swaytorial.
http:/sway.com/5HClf1YMOeTAERG9

Friday, January 22, 2016

Is it possible to access a Microsoft Report Server in Microsoft Edge?

What I have found so far is that you cannot access the Report Server using the Microsoft Edge browser.

Microsoft Edge, or simply Edge is the default browser in Windows 10. It is not designed to start with elevated permissions.

When you try to access Reporting Services Server  in the default Edge browser on Windows 10 and you end up with access denied message. The message as says , /  does not have sufficient permissions. One could use another browser such as Firefox but Reporting Services server cannot be accessed even when the browser is launched with elevated permissions. Firefox did not have problems in accessing the Report Server in SSRS 2012.



The way out for this in using the IE 11 browser that comes with Windows 10.

Monday, January 18, 2016

What is SQL Server Utility?

It is an utility that helps comparing your SQL Server Performance to Policies and help identifying problems, if any.

SQL Server Utility also goes by the name SQL Server Utility Control Point and it collects configuration and performance information from managed instances of SQL Server every 15 minutes. This information is stored in the Utility Management Data Warehouse(UMDW) on the UCP with the file name sysutility_mdw. SQL Server performance is compared with the established policies and problems are flagged.

If you have multiple SQL Server Instances or data-tier applications consider creating a SQL Server Utility Control Point (UCP).