Experimenting with PostgreSQL in a Container (2020-10-06)

 SQLServerCentral Newsletter for October 6, 2020 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Experimenting with PostgreSQL in a Container]( - [SQL Server High CPU Query Use Monitoring with PowerShell]( - [From the SQL Server Central Blogs - Failing SQL Agent Jobs – Part 4]( - [From the SQL Server Central Blogs - Fixing the PoSh Hotkey in ADS]( Question of the Day - [Backing up to the same Azure File]( [Redgate University]( The Voice of the DBA  Daily Coping Tip Write down three things you appreciate about yourself 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. DevOps and Exhibits Last month I did a [webinar]( with the [ATARC group]( on DevOps and databases. I was on a panel with a few government employees talking about the COVID-19 pandemic and how this may have changed work inside the US government.  One of the panelists is a full stack developer for the Smithsonian. Ravyn Manuel talked a bit about her work in trying to build new exhibits for the African American History and Culture Museum, which will look to open up soon. Many of the exhibits in the museum were built to be interactive and touch capable. With the COVID-19 pandemic, they need to revisit their approach, finding ways to avoid having visitors touch shared surfaces.  There was [an article]( after the webinar that included a bit more information. The idea for the immediate future was to use a visitor's mobile device with QR codes or Augmented Reality apps that engage and excite people. It's a great challenge, and as Ravyn notes, it's an exciting time for DevOps and developers.  I think that's one of the things that DevOps is supposed to produce. Some experimentation, and along with it, the excitement that comes from meeting and conquering challenges. Rather than big projects, we try smaller things, and adapt as they work, or don't.  DevOps is helping many organizations reinvent how they do software development. Many of the techniques are the ones some of us have been using for years, but the focus on the term has helped lots of managers rethink their processes. I'd urge you to look at [DevOps ideas](, but be sure you include the database. It's an important part of the [DevOps process](.  Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums]( [Redgate SQL Prompt](   Featured Contents [Experimenting with PostgreSQL in a Container]( Steve Jones - SSC Editor from SQLServerCentral Learn how to get started using a container to run PostgreSQL, or really any other RDBMS, including a gotcha to watch out for. [SQL Server High CPU Query Use Monitoring with PowerShell]( Additional Articles from MSSQLTips.com In this part of the PowerShell monitoring tips we look at how to capture the top queries that are consuming the most CPU from all monitored instances. From the SQL Server Central Blogs - [Failing SQL Agent Jobs – Part 4]( gbargsley from GarryBargsley Here we are, another Tuesday!! It is time for our Fourth and final installment in the Failing SQL Agent Jobs series. This week, we will cover how to store... From the SQL Server Central Blogs - [Fixing the PoSh Hotkey in ADS]( Steve Jones - SSC Editor from The Voice of the DBA I installed the PowerShell (PoSh) extension in ADS recently. This is available in the extension pane, and once installed, you get the 4th icon on the right added to...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Backing up to the same Azure File I want to send a second copy of my SQL Server 2019 database backup to Azure Blog storage as an emergency. To make things easy, I specify the command as follows: BACKUP DATABASE AdventureWorks2016 TO URL = '; This works fine on day one, but I get an error on day two. What do I need to add to this command? 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) Linux Authentication What types of authentication can I use for my Windows clients when I have a SQL Server 2019 instance running on Ubuntu 16.04? Answer: SQL Auth and Windows AD Auth using Kerberos Explanation: SQL Server on Linux can support both SQL auth and Windows AD Auth. Ref: - Configure SQL Server on Ubuntu 16.04 to use Active Directory Authentication - - Tutorial: Use Active Directory authentication with SQL Server on Linux - [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 - Development [Pivot or CROSS APPLY this?]( - Hi SSC, I'm mentally stuck with this one. Essentially I want 2 rows with all the measures related to the Internal_No but I'm stuck figuring it out. Here's how far I got:  USE [Database] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ARCHIVE]( [Time_Inv] [datetime] NULL, [Rep_Date] [datetime] NULL, [SalesOrg] [varchar](50) […] SQL Server 2016 - Administration [IntelliSense no longer working]( - I recently got a new laptop at work and now IntelliSense is no longer working in SSMS 2016. It always worked fine before, so I'm assuming it's some kind of local configuration issue or something, not a server-related setting or access issue. I've tried all the usual stuff: making sure IntelliSense is enabled, refreshing the […] [Renaming SSRS reports programmatically]( - Hello experts, I used one of the RS scripting tools to export some reports from on SSRS server in order to import them on another server. The reports were exported with rdl names along the lines of -MyFolder-MyReport.rdl There are hundreds of reports. I ended up manually creating the folders and putting the reports into […] SQL Server 2016 - Development and T-SQL [Add a Time column and a Date column together?]( - Hi, Please can someone help with. I am trying to create a new column containing a combination of two existing columns. Column 1 is datetime and column 2 is smallint Example 2020-11-20 00:00:00.000      900 2020-11-21 00:00:00.000       1700 I want to create a new column which […] Administration - SQL Server 2014 [trigger on a Large 5 billion row table]( - Hello, So we have noticed our trigger that does insert from one table to another if there is an update or insert, so we noticed the timestamp GETDATE() has been from seconds to almost minutes apart, wondering if anyone noticed this when handling large tables, and if there is anyway how to get around it? […] SQL 2012 - General [How To get different feature values on one row separated stick if it multiple d]( - I work on SQL server 2012 I face issue : I can't get all different value Feature one one row result separated by sticky if it multiple difference if one different then no need stick. where c have value and x have value but both not equal each other so How can i do that […] SQL Server 2019 - Development [I passed the Microsoft Exam 98-364: Database Fundamentals]( - I recently passed Microsoft Exam 98-364: Database Fundamentals. As it turns out, I did better than I expected and passed the exam quite easily and scored a 98. This means that I am now MTA certified (Microsoft Technology Associate). I would like to thank everybody on this message board who helped me in learning TSQL, […] [How To Process JSON Columns, having '.' (dot) in Their Names?]( - I have a JSON file from Azure's DevOps I need to process. It seems to be straight forward on columns with one word, but how do I process those with dot between them, please? { "count": 56, @value" :[ {"id": 1, "workItemId: 1234, "fields": {"System.Id": {"newValue": 1234} "System.State": {"newValue": "New"}, {"id": 2, "workItemId: 1234, "fields": […] SQL Server 2008 - General ["Lock request time out period exceeded" for extended property]( - For extended property update query "Lock request time out period exceeded" Error comes. It is not solved even after 30 minutes , but solved after exe is closed. We are not using begin/commit transactions in our code but connection is global. Why lock on one particular table is not released(in our case extended property update […] SQL Server Newbies ['sa' impersonation]( -  To give a user the ability to execute a stored procedure (EXECUTE AS) I must first grant him the ability to impersonate the 'sa'. (that procedure creates new login and adds to role which a normal user can not execute) Am I right ? But when I give him the ability to impersonate 'sa' […] CLR Integration and Programming. [Issue with MSSQL 2017 CLR referencing IBM.MQ (amqmdnetstd.dll)]( - All, I've been going at this for a couple of days now and hoping someone out here has experienced this and knows how to solve it. I am migrating a SQL Server 2008 R2 database running on Windows Server '08 to a new SQL 2017 Enterprise installation running on Windows Server '16. In my current […] Analysis Services [DAX Approach to Inventory Problem?]( - I have data in AAS (Tabular) that looks like the following table. I need to create two calculated columns for the Date that the Inventory Changed and the Amount of the Inventory Change. I think and IF function can take care of me for the date of the inventory changed. However, I'm stumped regarding how […] Anything that is NOT about SQL! [DBA progress/career development/ path]( - Hi I am an post-grad and mssql server dba with around 5/6 years of experience and currently confused about my carrier progression and with all this cloud automation i am worried that dba (purely administrator role) might get diminished or disappear whole together so i am here for help I would like to know what […] [sql server laptops using AMD processor]( - Hi I have current dell laptop with intel processor .I has become old and wish to purchased new one .i wish to try one with amd processor .Which one would be good amd processor from there current generation ryzen 3/5/or 7 .I am not into gaming much .it mostly going to used for learning and […] SQLServerCentral.com Website Issues [Why is the topic I'm trying to start not posting?]( - I have a very challenging issue with integrating a CLR on a new MSSQL17 server i'm migrating to. I've written a very detailed topic regarding the issue seeking expert advise from the members here, but for some reason my topic never shows up. I was trying to post it in the SQL Server 2017 - […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -