Getting Started with Gremlin (2020-10-15)

 SQLServerCentral Newsletter for October 15, 2020 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Getting Started with Gremlin]( - [Bringing Data Catalog into your CI/CD pipeline]( - [Top 5 SSMS Time Saving Tips]( - [From the SQL Server Central Blogs - Recording Sessions for the Virtual Summit]( - [From the SQL Server Central Blogs - Setup Multi Subnet Virtual Router - Part 7]( Question of the Day - [Enabling Container Availability Groups]( The Voice of the DBA  Daily Coping Tip Look out for positive news and reasons to be cheerful today 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 Degradation of the Turing Test The [Turing Test]( from Alan Turing was proposed as a test of an intelligent system. Could a human determine if the other party in a conversation was a machine? This was an interesting way of imagining how powerful a computer might grow and the types of answers it might give to a human. Interestingly enough Turing didn't argue about the correctness of the answers, just that they appeared to be from a human.  In some sense, I wonder how many people would have been fooled by the GPT-3 bot on Reddit. It [posted comments for a week]( to a variety of threads. You can look through the posts by the "[thegentlemetre](" user, but this one caught my eye, and as I read it, I was surprised how much [this looks like things]( I've seen posted on the Internet.  Is this AI bot intelligent? I don't know, but I do think that the quality of comments and posts on all sorts of threads and articles seems to go down over the years. Maybe it's humans that are becoming worse at online communications rather than computers are getting smarter. Really, I think both things are happening.  AI/ML systems are getting better at mimicking what humans do, and I suspect that in many cases, especially in small samples, they can fool many people, perhaps most. That's disconcerting, especially as I already feel many people are a worse version of themselves online, without feedback and social cues directly available.  While I do think that AI systems can dramatically help us with mundane tasks and tedious work, I also think there can be problems if they become rigid in their actions, without allowing for some flexibility. Humans have discretion, and while they might not use it fairly, or even in ways that their organizations approve of, but they are flexible. Seeing these posts, I wonder if the AIs can learn to be flexible as well. I think they can be.  Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Getting Started with Gremlin]( sabyda from SQLServerCentral Apache TinkerPop is an open source graph computing framework. A graph computing network is a set of vertices and edges in the network. If we compare a graph database to traditional relational databases, we can assume that every row in a table of a relational database is equivalent to a vertex in graph network. Similarly, […] [Bringing Data Catalog into your CI/CD pipeline]( Additional Articles from Redgate As business rules shift and data structures change, organizations need to be able to maintain and update their data catalog. Discover how you can implement an automated solution using PowerShell and Redgate’s SQL Change Automation. [Top 5 SSMS Time Saving Tips]( Additional Articles from MSSQLTips.com In this article we look at how you can use SSMS to filter objects, debug, drag and drop object names, add custom reports and use of operators for emails. From the SQL Server Central Blogs - [Recording Sessions for the Virtual Summit]( Steve Jones - SSC Editor from The Voice of the DBA A week ago the SQL Bits conference took place in London, sort of. The event was virtual, but it was held during the London timezone, which makes sense as... From the SQL Server Central Blogs - [Setup Multi Subnet Virtual Router - Part 7]( Prakash Heda from SQLFeatures    Question of the Day Today's question (by Steve Jones - SSC Editor):  Enabling Container Availability Groups I am running a couple of Linux containers with SQL Server. How do I enable the Availability Group option? 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) Removing a dataframe column in R I have this simple dataframe in R: > mysales orderdate customerids orderqty orderprice linetotal 1 2019-09-23 1 10 10 100 2 2019-06-16 2 20 10 200 3 2019-03-09 3 30 9 270 I run this: mysales$linetotal <- NULL What is the result? Answer: The linetotal column is removed Explanation: This actually removes a column from the data frame. Ref: Adding and removing columns from a data frame - [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 [Set permisson user allow connect with application, don't allow connect with ssms]( - Hello, guys. I use .net to code, can i set permisson a sql user only can connect in connection string in .net code, and not allow that user login with ssms ? [Maint Plan Failing after 'sa' Disabled]( - I have 4 Maint Plans, 1 of which fails because 'sa' is disabled, but I don't see 'sa' specified in the plan. It rebuilds indexes, updates statistics, deletes old backups, then takes new backups. The other 3 Maint Plans just run DIFFS and T-Log backups. All 4 Scheduled Job Owners are a Windows account. On […] SQL Server 2016 - Administration [RING_BUFFER_RESOURCE_MONITOR - IndicatorsPool?]( - Hi all, i've been looking into an odd issue with possible plan cache memory starvation (SQL couldn't generate a query plan prior to timeout for unchanged procs that happily compliled previously) , and spotted quite frequent RESOURCE_MEMPHYSICAL_LOW events. IndicatorsProcess and IndicatorsSystem are both 0, but IndicatorsPool is 2, and I can't find any information around […] [Always On Availability Groups Issue]( - Hi, I see couple of below errors for 2 sql server instances i.e. primary and secondary. When I see the dashboard, it displayed the state as critical and after few minutes it turned green (I mean the databases we are online and synchronized). I do not see any databases on both the instances in recovery […] SQL Server 2016 - Development and T-SQL [A real challenge and I need suggestions on efficient ways to solve it]( - I have a need to determine the site of cancer given some complexities. Each cancer patient has up to 4 diagnosis codes with the first being the primary. I currently have a mapping table that is capable of mapping up to two values to a result value. Currently I only check the primary diagnosis to […] [Varchar to datetime]( - Hi, How can I convert SCHEDSTART varchar(25) '2020-06-07-12.30.00.00000'  to datetime '2020-06-07 12:30:00.000' SELECT convert(datetime,(left([SCHEDSTART],10) +' ' + left(Right([SCHEDSTART],14), 12) ), 127) didnt work. Any help ? Administration - SQL Server 2014 [PBM - result_detail column in syspolicy_policy_execution_history_details]( - Hello, we use PBM to monitor last full and last log backup. PBM created, nothing special so far. We created a stored procedure and a job querying syspolicy_policy_execution_history joining syspolicy_policy_execution_history_details to get the result of the PBM and send it as e-mail. So far so good. But we want to include the expected result in […] SQL Server 2012 - T-SQL [using parameter and not using parameter , the result is different]( - declare @YYMMDD DATETIME set @YYMMDD='2020-09-23 00:00:00.000' select CONVERT(VARCHAR(6), '2020-09-23 00:00:00.000', 112) , CONVERT(VARCHAR(6), @YYMMDD, 112) same value, when we use parameter to pass the value, and not using parameter, the result is not same, what is the reason ? thanks!      SQL Server 2019 - Administration [How does dns determine what ip to resolve to in an multisubnet AG?]( - When a SQL Listener is created on a Multi Subnet environment 2 x ip addresses are assigned. AG Name - SQLAG1 AG Listener Name - SQLAG1-LI 10.0.0.1 10.0.10.1 I have given the ip addresses above for example. In DNS there are 2 x entries for the SQLAG1-LI one for each of the IP addresses. A […] [SnapCenter Server Backup for SQL]( - Hello, do you have any experience with SnapCenter Server 4.3. Can we say that is a valid backup? can we use like a primary backup? I have some testing now, and I am afraid how is working with this web app. Thanks [I've lost the ability to connect to my SQL 2019 instance]( - On my home Windows 10 Professional desktop PC, I've got SQL Server 2019 Developer Edition installed. I thought I had mixed mode but am not so sure. A month or two ago I had problems with my Windows profile - it became corrupted. So, I disabled it and created a new Windows Profile. I thought […] SQL Server 2019 - Development [\'DBMS_DATA_MINING\' is not a recognized CURSOR option]( - Is DBMS_DATA_MINING available in SQL Server 2019? This is error: 'DBMS_DATA_MINING' is not a recognized CURSOR option Analysis Services [Where is the AdventureWorks 2008R2 Analysis Services project download?]( - I need the 2008R2 version because I want to climb the Stairway to MDX and in Level 1 it says: Consider working, therefore, with 2008R2, if at all possible: learning the basics of MDX is challenging enough for most that are new to it, without the additional distractions imposed by working with older releases. In […] Integration Services [SSIS Package that updates two databases on the same SQL Server instance]( - Hi, I have a large script that is querying and updating two databases on the same SQL Server instance (one client database and the MSDB). I'd like to publish this script in an SSIS package, but when I do so it complains that I don't have authorization to update the MSDB database. I have created […] [SSIS package error on remote database]( - hello everyone, so i have created a SSIS package that i want it to run on another server, so example below: Server A is running the SSIS package, and the destination is Server B, that i want it to run under a certain account, like either the network service or system service, which has the […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -