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

Daily Coping Tip

Don’t compare how you feel inside to how others appear outside

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 10X Programmer

This editorial was originally published on 19 Sep 2016. It is being republished as Steve is on holiday.

Is there such a thing as a 10x programmer? It's an interesting idea, and one that is discussed from a few perspectives in this Q&A. There's some talk about how to define "x" as well as the idea that the environment and project might make a big difference in productivity. Certainly the baseline of the staff measured makes a difference. If most of your programmers aren't very productive, then a more talented developer might easily outperform the average by a factor of 10. Depending on how you measure productivity.

I wonder, though, is there a 10x DBA or database developer? What would that look like? If we examined the effectiveness of a DBA managing systems, I have seen DBAs that managed 10x the absolute number of databases and instances. Working inefficiently, connecting the individual systems to apply updates or check statuses could easily make you ten times less efficient then the DBA making use of scripting and the ability to apply changes across many systems, not to mention managing them for issues.

In terms of database development, if we have some programmers that can produce code using 10x less resources than others, I'd consider that a 10x programmer. Given the state of questions I see asked on SQLServerCentral and other sites, it definitely seems that there are plenty of developers being paid to produce poorly written T-SQL code. We don't have great definitions of how we can measure productivity, but there is plenty of code posted that can be dramatically optimized. It's the rare week that I don't see someone noting they've reduced the runtime of some code from hours to minutes. Isn't that 10x more productive?

Ultimately one of the amazing things about software is that we aren't bound to a particular structure once it's created and used. We can quickly, and easily, change the way the code is built so that it works differently, does more, runs efficiently, or really anything we want. Of course, testing that the code produces the desired effects and deploying that to different environments in a way that minimally impacts clients is a challenge, but a challenge many in our industry work on constantly, seeking improvement.

I think there are definitely 10x programmers, but that really depends on your situation and how you utilize the people working for you.

Steve Jones - SSC Editor

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

Redgate SQL Prompt
 
 Featured Contents

Incremental Data Loading using Azure Data Factory

Sucharita Das from SQLServerCentral

Introduction In my last article, Loading data in Azure Synapse Analytics using Azure Data Factory, I discussed the step-by-step process for loading data from an Azure storage account to Azure Synapse SQL through Azure Data Factory (ADF). ADF basics are covered in that article. In this article I will go through the process for the incremental […]

Why you Should Embed Monitoring Earlier in Your Database DevOps Cycle

Additional Articles from Redgate

With insights from a recent Gartner report, Redgate’s Jamie Wallis looks at the benefits of tracking, and acting on, key metrics early in the DevOps process and how they can apply equally to database monitoring. Read more.

Hands-On with Columnstore Indexes: Part 4 Query Patterns

Additional Articles from SimpleTalk

All queries run fast against columnstore indexes, right? In this article, Edward Pollack demonstrates some query patterns that don’t perform well and how to get around the issues.

From the SQL Server Central Blogs - Optimize for Unknown for Inline Table-Valued Functions

Koen Verbeeck from Koen Verbeeck

I had a curious performance issue today. An inline table-valued function (iTVF) was performing poorly for some parameter sets, and quite fast for other parameter values. In short, this...

From the SQL Server Central Blogs - Stop Letting Accessibility Be Optional In Your Power BI Reports

Meagan Longoria from Data Savvy

We don’t talk about inclusive design nearly enough in the Power BI community. I was trying to recall the last time I saw a demo report (from Microsoft or...

 

 Question of the Day

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

 

The Last Compile Time

I have a stored procedure, and I am trying to determine when it was last compiled for a plan. Where can I find this information?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by BTylerWhite)

Returning Python Dictionary Values

I have the following nested dictionary in Python 3:

people = {
    1: {
      'last_name': 'Dactyl',
      'first_name': 'Teri',
      'age': '27'
    },
    2: {
      'last_name': 'Erd',
      'first_name': 'Liz',
      'age': '22'
    }
  }

I need to retrieve Teri Dactyl's last_name. Which method can I use to return the value of this item?

Answer: people.get(1).get('last_name')

Explanation: We can use the get method to return values for keys in a dictionary. We need to call the get method twice in this scenario as our dictionary is nested. The initial get retrieves the values belonging to the 1 key. The second get retrieves the value of the "last_name" key. A safer way to accomplish this would be to use the optional default argument to return None in the event either key does not exist. This is explained in more detail in the StackOverflow question listed below. References:

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
DEA - What is the use of DEA tool in sql ?  how can we  install on sql ?
SQL 2017 MLS - cant add new python packages - Hi I'm new-ish to MLS and have been trying to add new python packages like  attrs  to the python but it hasn't been working. Our set up is SQL 2017 with CU14 on Win 2016. Python version is 3.5.2 The usual command I run is : "pip install attrs" ( without quotes ) and I […]
Index Fragmentation - I am looking into fragmentation in one of my databases and ran across these stats - should I be rebuilding these indexes? That's what it looks like, just want some ideas/confirmation to see if I'm on the right track.  
SQL Server 2016 - Administration
SQL Server 2016 seeding automatic stuck - Hi all, Problem help please, I have 2 servers in sql server 2016 and i have started seeding databases to the DR server within the GUI of AOG which is FCI  problem is that  one of my dbs which is 2 TB with take 1 month to finish. I need to stop this and continue […]
will this get replicated to secondary replica - Dear Experts, In Availability Group, if we move ndf file to another drive on primary, will this get replicated to secondary replica
SQL Server 2016 - Development and T-SQL
SQL Query - FULL JOIN multiple tables but return NULL results - Good day! Need help with my sql query code; first FULL JOIN "ILEtransfer" no NULL result but im getting NULL result once i add a FULL JOIN "ILEmsales" Thank you in advance! here's my sql query code; ;WITH Barcodes AS ( SELECT [BBI$Barcodes].[Item No_] ,[BBI$Barcodes].[Description] ,[BBI$Barcodes].[Variant Code] FROM [BBI$Barcodes] ), ILEtransfer AS ( SELECT [BBI$Item […]
Administration - SQL Server 2014
Server local connection provider has stopped listening - Hello, Once / twice a week I'm getting the following error. Server local connection provider has stopped listening on [ \\.\pipe\SQLLocal\MSSQLSERVER ] due to a failure. Error: 0xe8, state: 4. The server will automatically attempt to re-establish listening. where should I search for the source of the error? Is this error is due to the […]
Development - SQL Server 2014
Insert Trigger - Hi All, I have table A that has 2 columns(col 1,col2). I would like a create trigger that collects all duplicate inserts.For example ,when i insert new records that both col 1and col2 exists on Table A ,then insert that record into Table Audit as well. Here what came up with ,but logic is not […]
Number weeks from April to September for every year - I want to number weeks from April to September for every year, such that week 1 starts 1st of April and ends the following Saturday and week 2 starts first Sunday of April and ends the following Saturday and so on.... till the end of September. How do I do that using TSQL. Thanks in […]
SQL Server 2012 - T-SQL
slow query performance - Hi All, I have a SELECT query which is taking more 8 mins. Can you please help me in making the query run faster (if possible) . There is no blocking . Seeing PAGEIOLATCH_SH waittype for most time. The table is a clustered index table. There is no non-clustered idx on mule_batch_id column. Query: use […]
SQL Server 2019 - Administration
\'REMOTE ACCESS\' setting flipped back to 0 overnight ?? - Any reason why our SQL Server 2016 Standard edition instance would have flipped the 'REMOTE ACCESS' setting back off? Here's what happened: - I ran the following code AS IS on both SQL Servers: sp_configure 'show advanced options', 1; GO RECONFIGURE; GO EXEC sp_configure 'remote access'; -- Display current setting GO --EXEC SP_CONFIGURE 'remote access', […]
SQL Server 2019 - Development
SSIS 2019 - Conditional Expression for the value of a variable- fails evaluation - Hi All, Ran into an error trying to evaluate the following expression for a variable value: @[User::varBadRows] > 0 ? (DT_STR, 50, 1252) ("There are " + (DT_STR, 3, 1252) @[User::varBadRows] + " rows with a non-matching SPID value.") : NULL(DT_STR, 50, 1252) I'm using Visual Studio 2019 Pro and my target environment is SQL […]
The backup set holds a backup of a database other than the existing 'MyDB' - I'm trying to restore a database from our production server to my local machine using the following script but still get the error, 'The backup set holds a backup of a database other than the existing 'MyDB' database. USE [master] RESTORE DATABASE [MyDB] FROM DISK = 'C:\MyDB.bak' WITH REPLACE, MOVE 'MyDB' TO 'C:\MyDB.mdf', MOVE 'MyDB_log.ldf' […]
Find row closest to date - Just having trouble getting this to work as I hoped. Trying to extract entire row from one table with a date closest and before another date in the 1st table.  Sample table and 1st try below. Any help is appreciated Trying to get: 1,    2020-08-05,  2020-08-03,   25 2,    2020-08-04,  2020-08-03,   34 3,   2020-07-28,  […]
SQL Select with condition - Hi, In my sql table,  there is a column which have string of text : Column 2ABF   CD000000000012345000000000001156 3000000000003452000000000000356 I would like if the 1st character is 2 then  out put as ID               Code           Num1          Num2          Num3       Num4 2ABF        CD              123.45         11.56 if the 1st character is 3 then ID               Code           Num1          Num2          Num3       Num4 […]
 

 

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

 

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