Offline R Services installation and patching (2021-02-12)

 SQLServerCentral Newsletter for February 12, 2021 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Offline R Services installation and patching]( - [Connect to SQL Server]( - [Getting Started with Flyway and SQL Server]( - [From the SQL Server Central Blogs - Release Your Inner Synapse]( - [From the SQL Server Central Blogs - Published Azure Arc-Enabled Data Services Revealed]( Question of the Day - [Removing Untracked Files]( The Voice of the DBA  Daily Coping Tip Share what you’re feeling with someone you really trust I also have [a thread at SQLServerCentral]( dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from [The Action for Happiness Coping Calendar](. My items will be on [my blog](, feel free to share yours. The Pandemic Work Load The United Kingdom went into their third lockdown not too long ago, and this was a bit of a disruption for my employer, as most of our people are in the UK. While we've gotten used to being at home and working remote, this was a change. During a company update, our CEO reminded us to be reasonable to ourselves and to each other. He noted that the situation each of us might be dealing with could be vastly different than what others experience. The balancing act of work, family, and life, can be daunting for everyone. Including to each of us individually. We didn't define reasonable, but rather want employees and managers to be fair, moderate, and appropriate. The company doesn't know how much work each person can handle, or at any particular time, so we're asking everyone to be a little relaxed with the demands on ourselves each other. We still have sales goals, individual goals, and pressures to complete development. At the same time, if there is a need, we can adjust those things. In many companies I've been employed by, most managers were reasonable with me, but there were always some that were not. I'd like to think that Redgate does better than most, but we'll see. In any case, as we continue with the pandemic, I'm curious about your working schedule and whether you might be working more or less than you expected. Or than your co-workers expect. If you're juggling children or other family, this can be a challenge. We're nearly a year into this pandemic, and I still see no end in site for when we might return to the work environments of 2019, so I am curious today how your adjustment in this new year is proceeding. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Offline R Services installation and patching]( Evgeny Garaev from SQLServerCentral.com The R Services installation package is not included in the MS SQL Server installation package. When you install MS SQL Server with R Services the installer actually download the package from the Internet. [Connect to SQL Server]( Additional Articles from MSSQLTips.com In this article we look at the different ways to connect to various SQL Server services using tools like SSMS, BCP, SQLCMD, PowerShell and more. [Getting Started with Flyway and SQL Server]( Additional Articles from Redgate Phil Factor explains how to get started with Flyway, as simply as possible, using PowerShell. This article provides a practice set of database automation scripts that will build a SQL Server database, and then update it, running a series of migrations scripts that make some schema alterations, and load the database with test data. From the SQL Server Central Blogs - [Release Your Inner Synapse]( Chris Yates from The SQL Professor I don’t know about you, but as Microsoft has produced the Azure Synapse platform, I see a plethora of needs that could be fulfilled by it. Being in a... From the SQL Server Central Blogs - [Published Azure Arc-Enabled Data Services Revealed]( aen from Anthony Nocentino's Blog I’m super proud to announce that Ben E. Weissman and I have published Azure Arc-Enabled Data Services Revealed available now at Apress and your favorite online book sellers! Buy...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Removing Untracked Files I am working in a git repository on some code. I check out a branch and make some changes. I also add a few new files. I decide I haven't done a great job here, so I want to abandon my changes. I run this: git checkout . This removes the changes I've made. However, I wonder about the new files and folders I added that were untracked. How do I remove them? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) Tempdb Improvements in 2019 In SQL Server 2019, tempdb has which improvement to help with system table contention with latches? Answer: Use memory optimized tables for system tables Explanation: The ability to load tempdb system tables as in-memory optimized tables can eliminate latch contention. Ref: Tempdb in SQL Server 2019 - [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2017 - Administration [Can't import certificate]( - Hello, For a SCCM installation, we have been told we need to install a certificate. I am supposed to install it in configuration manager. I go to the certificate tab. However, I don't see an import. I've looked up the internet and see where I should be seeing an import button. I am an admin […] [Using SQL Configuration Manger 2019 on SQL 2017 instances.]( - I'm hoping this is a simple (obvious) question... I'm charged with implementing a solution for TLS encrypted connections to 3-node SQL Server 2017 Always-On AG. I was reading in the documentation that SQL Configuration Manager 2019 greatly simplifies deployment/management of certificates across the AG and that Configuration Manager 2019 can be used on earlier versions. […] SQL Server 2017 - Development [Convert International Character-String Date Formats]( - We are receiving some international text file(s) with date(s) (and other fields) in languages other than english (dez, déc, etc). Does anyone know of a method to try and convert dates into a us-english format? Here is what was tried at the moment: DECLARE @Date varchar(20), @Date1 VARCHAR(20), @Date2 VARCHAR(20) SET @Date = '25 déc […] [Stored Proc:Can I use a parameter of comma separated Id\'s within a WHERE clause?]( - I need to return records that contain one of several primary key Id's (these Id's are INT data types). The id's will be passed into the stored procedure via a varchar containing the id's separated by commas. I'd like to then use these Id's within my WHERE clause but I'm not sure how. Ex. DECLARE […] SQL Server 2016 - Administration [Query plans not getting cached]( - Just wanted to know what this could be  I have a simple query that takes 1 min for the initial run and then it takes less than 10 secs after the second run in test environment and I can see the query in the cached plans I run the same thing in prod it […] SQL Server 2016 - Development and T-SQL [Replacing String Between Two HTML Tags]( - Hi all, I could use some assistance with this one as I can't get anything working correctly for it at the moment. I'm having to move some HTML formatted data between two applications and they have a few differing quirks regarding how they handle HTML formatting. The specific quirk that is causing me issues is […] [Counting Daily Active Accounts per Category]( - Hello everyone, I am trying to get the number of daily active accounts per given category. I have the following table that contains accounts, their category, and when they moved into that category. ` ID   Category      Category_Date 11      1                       2021-01-05 12     3                      2021-01-05 11      2                      2021-01-18 12     2                      2021-01-19 14    5                     […] [Stored procedure performance issues]( - I've been tasked with improving the performance of a colleagues stored procedure, and could really do with some advice to ensure that I don't lead them down the wrong path. The stored procedure creates a temp clustered index based on values from a user table-value function output (input for this function is one of the […] SQL 2012 - General [How to replace OR statment on revision by another best practise and more perform]( - How to replace OR statement on revision by another best practise and more performance ?  I work on SQL server 2012 I face issue I need to use any thing alternative or best from using OR statement multiple time . so How to use any solution without Using OR statement on Revision with another […] SQL Server 2019 - Administration [TDE With Log shipping]( - Our environment is SQL Server 2019. I'm new to TDE and am having to learn it because of a vendor request, but I am having trouble finding a similar environment to ours as I Google. We have a vendor's healthcare application my company uses and the DB supporting the app is in a cloud environment […] [2019 SSRS Install problem]( - We're upgrading from 2012 to 2019 and I'm running into multiple issues with SSRS 2019. But let me start with the basic one. How do we install the dev version of this as a named instance? It installs as "SSRS" but I want to install it as our old instance name so we don't have […] SQL Server 2019 - Development [SQL Query - Get Start/End Date per Employment Period]( - Hi All, Need to get Start and End Date per eployment period, meaning an employee can be hired and rehired. I attached a sample data and desired output.  Thanks [It does not keep the data in the table being filled from a stored procedure]( - I would like to know why when consulting a table that is filled with a stored procedure and the last one is called with an openrowset, it does not return data. Example CREATE TABLE dbo.Test (Id INT, Nombre VARCHAR(10)) GO CREATE PROCEDURE ProcedureTest1 AS BEGIN INSERT INTO dbo.Test VALUES(1, 'Deblin') SELECT * FROM dbo.Test END […] [Why I have problem with adding IDENTITY in my table?]( - I want to create Table which name is ARTIKAL. Also I want to set Identity in ID column but every time when I run my code I get this. Here is the code CREATE TABLE [dbo].[ARTIKAL] ( ID int IDENTITY(1,1) NOT NULL, Naziv char(10) NOT NULL, Cena decimal (5,2) NOT NULL, Kolicina int NOT NULL, […] Reporting Services [Long running report- kill the session]( - There are few reports in our environment which run on read only replica, but they take over 3+hrs. We have decided that any report that runs for more than 2 hrs should be killed and rolledback. How do we identify that that report was killed (session was killed) due to this reason? Should I write […]   [RSS Feed]([Twitter]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -