Just in case anyone else needs the Teacher Dashboard 365 extract for Synergy SIS, I’m sharing it. Just make sure the students’ “displayName” in active directory is the students full name (Last, First) and their AD account “userPrincipalName” is their PermID@Office365Ending. Change…
SQLCMD Basics
Example Usage: sqlcmd -S ComputerName\InstanceName -i MyScript.sql -o MyOutput.csv -t 1000 -W -s "," -X1 sqlcmd -S localhost\sqlsrv2012 -d AdventureWorks2012 -i C:\DataFiles\EmployeeQuery.sql -o C:\DataFiles\Employees.csv -t 1000 -W -s "," -X1 sqlcmd -S localhost\sqlsrv2012 -d AdventureWorks2012 -Q "SELECT FirstName, LastName FROM…