How to Install SQL Server PowerShell 2017 Remotely to Your Servers

As part of upgrading our SQL Servers to 2017 CTP 2.1 we have a process that runs afterwards that uses Invoke-Sqlcmd cmdlet but with SQL Server 2017, SQL Server PowerShell 2017 is a separate install from the PowerShell Gallery.  So I wrote a process to that will install the SQL Server PowerShell remotely to the […]

Read More »

Uploading New R Library Packages

Somehow I have become the R DBA at my job which I don’t mind, I plan on taking Microsoft’s Professional Program on Data Science to be familiar with it.  But recently I’ve had to upload files to our R servers which the first time wasn’t too bad.  Copy these files to six different servers but […]

Read More »

Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 3

This entry is part 3 of 3 in the series Automation of PAL

This entry is part 3 of 3 in the series Automation of PALIn the final part of the process will be the process that creates all the reports and zips up the performance counter file on a central server.    The first part copies the PerfMon file from the each server to a central location.  […]

Read More »

Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 2

This entry is part 2 of 3 in the series Automation of PAL

This entry is part 2 of 3 in the series Automation of PALIn this part of the process we will setup a process to automatically stop the data collector or counter log on the remote server.  Then  rename the file with a time stamp if it is an older version of Windows.  Finally we will […]

Read More »

Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 1

This entry is part 1 of 3 in the series Automation of PAL

This entry is part 1 of 3 in the series Automation of PALI recently was re-exposed to the PAL (Performance Analysis of Logs) Tool available on CodePlex at a wonderful SQLskills class.  I had played with the tool in the past but at the time the server I had for setting things up and automtaing […]

Read More »