SQL Server - Database Growth Estimation Excel

• Related Articles

• SQL Server - Testing database connections

  One of the past challenges with troubleshooting SQL database connections has been with having a tool to connect to the SQL database - determining if the port is available on the target server and the service is running. Starting in Windows 10, this ...

• SQL Server - Changing Database Location / Server

  When changing database location / server you will need to update the following files and tables. In the Opendata file structure: database.properties - contains database connection info - Located: C:\Program ...

• SQL Server - Adding Templates to Bulk Upload Menu

  The steps to add a Device Template to the bulk upload menu on OpendataEE are: 1) Move the completed template into the appropriate directory. The default root device template directory is: C:\Program ...

• SQL Server - Fixing Remote Edit Button

  If the Remote Edit button sends you to an error page or the wrong Device Gateway here is how to fix it. Run the following query to generate a complete picture of the tables used to generate the remote edit URLs. select d.name,d.device_id, ...

• SQL Server - Manual Device Deletion

  If you need to remove a device from the dashboard and it is not possible to use the Delete button on the Administration > Devices page, you can do it through SQL Management Studio. Marking a Device as Deleted In Management Studio run the following ...