Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Redgate SQL Compare
The Voice of the DBA
 

Daily Coping Tip

Find a fun way to do an extra 15 minutes of activity

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.

Teams that Ship

These days there is pressure on many software development teams to ship software more often. With the growth of DevOps and the numerous stories about companies that ship software regularly, more and more management is putting pressure on their development teams to perform. This can be a challenge as the culture changes needed to alter the way we work are difficult to achieve.

I saw a post from an entrepenuer, Naval Ravikant, on building a team that will ship software. This is from someone at a startup, which often has different goals, challenges, and structure than more mature teams. Certainly I've seen the way we've built software at a few employers change, and even at Redgate, what we do know wouldn't be something that we'd have done as a small company with 10 people.

As I read the list, I can imagine why some of this advice is there. The need to push forward and get software working and in front of customers is strong. Sales, marketing, and the users of the application want to see things move forward, features added, bugs fixed, and a reason that someone will pay money for the software. This rapid pace requires some decentralization, some lack of control, and trust in your developers.

However, at some point this isn't the model that a more mature organization needs. While we do want doers and small teams at Redgate, we're also more mature. Allowing developers to work on whatever they want isn't in our best interest, and it could mean some products wouldn't get any attention. We also have somewhat large codebases, so a person per project isn't ideal. In fact, we often get code done in groups.

I think I might be more inclined to adapt some of these goals with a startup, and certainly in a PoC or early access/beta product. However, once clients are invested and paying, I think a little more coordination and collaboration is likely needed. Not a lot, but a little.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 Featured Contents

How To Avoid MERGE in SQL Server

Glen Cooper from SQLServerCentral

Introduction This article shows how to script a basic merge between two tables, without using MERGE. This can be handy when you're merging a pair of tables with hundreds of columns, since the script doesn't know anything about them. This technique introduces and populates some auditing columns (IS_DELETED, IS_INSERTED, IS_UPDATED, TRANSACTION_DATE) for each record, and runs fast. […]

Adding Reports Users to SQL Monitor

Additional Articles from Redgate

SQL Monitor 10.0.5 now supports a user role called "Reports user". A user added to this role, by an administrator, will be able to 'self-serve' SQL Monitor reports but won't be able to configure any other aspect of the monitoring service. Jeremiah Peschka explains how it works.

Considerations for Deploying Azure SQL Database Managed Instances

Additional Articles from Database Journal

While Microsoft provides a number of different deployment options for its Azure SQL Database offerings, one in particular warrants special attention from the standpoint of its infrastructure dependencies: Azure SQL Database Managed Instance.

From the SQL Server Central Blogs - Transforming JSON data with the help of Azure Data Factory - Part 3

Rayis Imayev from Data Adventures

(2020-Apr-06) Traditionally I would use data flows in Azure Data Factory (ADF) to flatten (transform) incoming JSON data for further processing. Recently I've found a very simple but very effective...

From the SQL Server Central Blogs - Disks performance in Azure

nelsonaloor from PracticalSQLDba

In our earliest post, we have discussed in detail about the factors that affect the disk performance and different types of disk offerings in the AWS platform. In this...

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

The Linestring

I run this code in SSMS 18.4. 
DECLARE @g geometry;  
SET @g = geometry::STGeomFromText('LINESTRING (100 100, 20 180, 180 180, 100 100)', 0);  
SELECT @g
If I click the Spatial Results tab, what shape is graphed?

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 Agent

I've installed SQL Server 2019 on my RHEL host. What do I need to do to get SQL Server Agent running on this system.

Answer: Enable it and use systemctl to start it

Explanation: SQL Server agent is installed with Linux versions greater than 2017 CU4. However, it is disabled by default. You need to enable it and then start it. Ref: Install SQL Server Agent on Linux - https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-sql-agent?view=sql-server-ver15

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
Enable RPC over SQL link - Hello, Is it possible to enable RPC over an SQL link? What i am attempting to do is this: select * from openquery("server1",'EXECUTE(''sp_serveroption ''''server2'''', ''''rpc out'''', ''''TRUE'''''') AT "server2";') I am a member of SYSADMINS group on the server, so it is not a permission issue I think. But i get the following error: "Server2 […]
SQL Server 2017 - Development
Issue with case statement - i have a table A where the data looks like ID        Name      Phone            CODE 15674     AUSN      +14412984775     HT 15674     MAN       +13857747488     JK 67866     AUSN      +74666378838     HT 98765     AUSN      +72366747848     HT Another table called B. where we join A and B based on ID column Table B data ID 15674 67866 98765 i am trying to […]
generate insert statement with data from table - Hi all, My need is to generate insert statement with data from table (using existing data from that table). For example, I got table sometable1 and it has columns id, name. The result should look somewhat like this: Insert Into sometable1 (id, name) values (1, 'sometext1'); Insert Into sometable1 (id, name) values (2, 'sometext2'); How […]
SQL Server 2016 - Administration
Unable to connect to default SQL instance using a custom TCP port - Server A has a default SQL instance running on TCP port 12345. Server A has the SQL browser service running. Server B (on the same subnet) can connect to Server A using SSMS with/without specifying the port number. If Named Pipes protocol is disabled on Server A, Server B can no longer connect without specifying […]
Always on Availability Groups - Can i configure a 2 Node AG Availability group in the same data(local site)  centre for High Availability  .
DB mail issue - We received error when testing the DBmail The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 ( ). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: #5.1.0 Address rejected.). how to solve this issue .
erreor in insert value from Get-DbaDbBackupHistory - Good morning all , I need to trace the history of all the backup sql of all my servers for this I use the command dbatools Get-DbaDbBackupHistory attached my powershell script $sqlservers ="DESKTOP-95KKMMH","DESKTOP-95KKMMH\production" $serveur="DESKTOP-95KKMMH" $database="msdb" foreach($sqlserver in $sqlservers) { $history=Get-DbaDbBackupHistory -SqlInstance $sqlserver $history | Select-Object -Property SqlInstance , Database,Type,TotalSize,DeviceType,Start,Duration,End | Write-SqlTableData -DatabaseName msdb -TableName History_backup […]
Administration - SQL Server 2014
Stored Procedure - Usage - Hi, I am running query using sys.dm_exec_procedure_stats  to get the stored procedure usage report and little confused that it shows latest time like today but Execution count is NULL so what i should understand? Is it Not using Stored Procedure at all since Last Sql server Restarted? How I should interpreting Last_Execution_Time and execution_count columns […]
fdhost.exe service does not relinquish memory - O/S - Windows NT 6.3 (9600) - Physical Machine 16GB of Physical Memory and 8 Processors SQL Server 2014 Standard Edition (64-bit) Version 12.0.6118.4 - Named Instance - Non Clustered The same service account is used on the following services: SQL Server, SQL Server Agent, SQL Full-text Filter Damon Launcher, SQL Server Integration Services 12.0 […]
SQL 2012 - General
Query Required this scenario - Hai, One company multiple employees working data entry operators.Employees working two different  shifts. First shift time 10AM to 6PM .Second shift time 8PM to 6AM . my requirement , date wise use wise  data entry count for both the shifts. i am facing problem second shits count. Because date changed in night 12'o clock.   […]
SQL Server 2012 - T-SQL
In varchar column add numbers and show strings - Below is the sample data create table temp (userid int , rid varchar(10), value varchar(100)) insert into temp(userid,rid,value) values(1,'D01','3'), (1,'D01','4'), (2,'C01','hey'), (2,'C01','1') expected output: 1,'D01','7' 2,'C01','hey' 2,'C01','1' I tried below code and it is throwing error select distinct userid,rid, case when ISNUMERIC(value) = 1 THEN SUM(cast(value as int)) over (partition by userId,rid order by userid) […]
SQL Server 2019 - Development
Getting the biggest spending customers for last 7 days - Hi all, Can anyone help with the below SQL. I'm trying to get the top 5 customers for the last 7 days. I've tried to do it as shown below but it doesn't like my ORDER BY statement in the sub select statement. Any way I can get around this? Thanks in advance. Paul. select […]
Integration Services
Expression builder problem - All, Can anyone advise the correct way to put this expression together? I've tried a few combinations but each results in an error when I press OK. I don't think it's relevant but it's the "arguments" expression for an execute process task. Thanks  
Exporting large amount of data out of AS400 - Good morning from my home office.  Hope all is well. I have successfully configured the ODBC connection using iSeries something or other and created the data source in SSIS and all of that is working great, including some transformations.  My job seems to fail when doing the load.  It is going to a SQL server […]
Article Discussions by Author
Stairway to U-SQL Level 16: The Azure Data Lake Catalog - Comments posted to this topic are about the item Stairway to U-SQL Level 16: The Azure Data Lake Catalog
 

 

RSS FeedTwitter

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

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -