Select Page

R Services Will Not Start After Install

If you are here, then you have experienced the same issue with the R Service not wanting to start after installing it on an existing instance. You have seen that pesky message to the left. In this particular case our server was previously patched to (SQL Server 2016...

Getting friendly with MERGE

Here’s a simple example of how to use MERGE. I’ll do a follow up post on this later. SET NOCOUNT ON; /* TARGET TABLE */ DECLARE @Movies TABLE ( id INT IDENTITY(1,1) PRIMARY KEY CLUSTERED ,Title VARCHAR(20) ,Qty INT NOT NULL ,CreateDate DATETIME...

Get-WmiObject Performance

If you are new to PowerShell and have searched through the “google-verse” you’ll likely find millions of examples with most if not all filtering the results via “WHERE” cmdlet. One thing I noticed today while conducting research on...