SQL table compare between 2 databases

SQL Server Data Tools for Visual Studio 2013 -Run as Administrator
TOOLS-->SQL Server-->New Data Comparison...
Click on New Connection..under Source Database
Select SQL Server Name and DB Name
Click on New Connection..under Target Database
Select SQL Server Name and DB Name
Click Next
Select Tables which you want to compare
Finish
You will see data difference b/w 2 DBs

CMD - Read folder file Name using cmd

Open CMD
go to directory
cd c:\myfolder
dir *.xml
dir /B *.xml >t.txt

You will get all file name

Sql Querry to find all active DB connection

SELECT DB_NAME(dbid) AS DBName,
COUNT(dbid) AS NumberOfConnections,
loginame
FROM    sys.sysprocesses
GROUP BY dbid, loginame
ORDER BY DB_NAME(dbid)

Microsoft Azure

https://mva.microsoft.com/colleges/azure-iaas-for-it-pros

Aras Innovator Disconnect all users from the database

Disconnect all users from the database

--Change the database connection string in the InnovatorServerConfig.xml from “<DB-Connection…” to <xDB-Connection” and restart the w3svc service(IIS).  This expires all sessions and prevents all new connections to the Aras Innovator database through the existing instance