Write-Host || Cannot invoke this function because the current host does not implement it
Issue: While running powershell in SQL job step, I am getting below error: – A job step received an error at line 13 in a PowerShell script. The corresponding line is ‘Write-Host “ServerName: ” $comp’. Correct the script and reschedule the job. The error information returned by PowerShell is: ‘Cannot invoke this function because the … Continue reading
Error While running PowerShell code from SQL Agent job – “Path Does Not Exist”
Issue: When I am running code from PowerShell console its running fine but when I execute it through SQL agent job step, I am getting below error: – The job script encountered the following errors. These errors did not stop the script: A job step received an error at line 14 in a PowerShell script. … Continue reading
What’s new in SQL Server 2016 installation?
1) As MS is kept increasing number of option while installation. To reduce no. of click, if setup pass Rules it will automatically moves to Next window. 2) On Server Configuration page, MS specifically ask to GRANT PERFORM VOLUME MAINTENANCE TASK permission to service account. SQL Services needs this access to perform instant file initialization … Continue reading
Sequence – Long awaited feature
As per BOL (https://msdn.microsoft.com/en-us/library/ff878058(v=sql.110).aspx) : A sequence is a user-defined schema-bound object that generates a sequence of numeric values according to the specification with which the sequence was created. The sequence of numeric values is generated in an ascending or descending order at a defined interval and may cycle (repeat) as requested. Sequences, unlike identity … Continue reading
What is “SET STATISTICS TIME”?
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each statement. By default, this option is disabled. SET STATISTICS TIME ON; GO SELECT * FROM [HUMANRESOURCES].[EMPLOYEE] Output: – SQL Server parse and compile time: CPU time = 0 ms, elapsed time = 1 ms. (290 … Continue reading
