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...

PowerShell Get-Service

Since I have written a process that checks all of our SQL Services I have been researching other methods and might have found a quicker way using Get-Service but would require an addition step to pass the arguments accordingly on a server by server basis. Potentially...

PowerShell Change Service Startup

In the event you need to change the service startup from either “Manual”, “Automatic”, or “Disabled” on a remote server, PowerShell makes it extremely easy and here’s one of likely many ways you can do it. function...

PowerShell: Monitoring Servers

I’m relatively new to PowerShell. I’ve known about it and have dabbled with it here and there but as of lately I’ve been digging in a bit deeper. One of my projects was to build a homegrown monitoring system. Being a DBA it’s natural that I...

Deleting a duplicate record

Recently a friend of mine asked me about deleting a duplicate record from a table without deleting both records. Having been in a situation I drafted up a sample script and emailed it to him. DECLARE @tbl1 TABLE ( id int, color varchar(50) ) INSERT INTO @tbl1 (id,...