Keep each script version focused on a single change type (patches for fixes, minors for features, majors for breaking changes). Retain all prior versions and never modify an existing release; copy to ...
You can wrap an executable file around a PowerShell script (PS1) so that you can distribute the script as an .exe file rather than distributing a “raw” script file. This eliminates the need to explain ...
At some point, I noticed I was repeating the same routine every week. None of the stuff I was doing was difficult, but it was a collection of small chores that kept interrupting real work. I'd have to ...
--Enabling sp_execute_external_script to run R scripts in SQL Server 2016 and installing package in order to run the Script TelcoChurn-Main.sql and TelcoChurn-Operationalize.sql sucessfully.
CONSTRAINT fk_employee_works_on FOREIGN KEY (Essn) REFERENCES employee(Ssn), CONSTRAINT fk_project_works_on FOREIGN KEY (Pno) REFERENCES project(Pnumber) ...