Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Ad for State of Database Landscape survey
The Voice of the DBA
 

Done is Better than Good

Mary Spender is a musician in the UK who I follow and hope to see live one day. She works hard producing content about music, that business, and, of course, songs. Recently she had a little essay on Instagram where talked about creative time and focus. In it she referenced Elizabeth Gilbert saying "done is better than good."

My initial reaction was "that's right."

Then I thought about software, and poor queries impacting database performance, and thought, "No, that's not right." My next reaction was to think maybe it's "done is better than great". I do see plenty of engineers trying to build great software. Code that would impress their peers or their former professors. Or maybe their future self.

Then I thought, no, Elizabeth is right. If things don't get done, then what's the point?

At the same time, I think that "done" and "good" (or great) aren't mutually exclusive. We can get things done and make them great, which is something to strive for. We can get good things done.

Sometimes.

Sometimes we don't have that luxury of time, for various reasons. If I had to make a trade, I push for good (or quality) as much as possible if the delay isn't substantial. If it is, then done is likely the choice I'd make. I do try to return and refactor, improve, etc. to raise the quality over time, but I recognize that sometimes getting something done is important. Certainly, on the ranch, I need to fix things to get by, with the aim of doing a better job later. I have mixed success at returning to improve a patch with a better fix later, but so far, that's worked well. I'd say the same thing has happened while building software or managing systems, with enough success to be comfortable with my choices.

What about you? What choices have you had to make about being done over delivering something that's good?

Steve Jones - SSC Editor

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

Ad for State of Database Landscape survey
 
 Featured Contents
SQLServerCentral Article

Configuring the On-Premises Data Gateway: The Fabric Modern Data Platform

John Miner from SQLServerCentral

In this next article on the Fabric Modern Data Platform, we examine setting up an on-premises gateway.

External Article

SQL Declare Variable Code Examples

Additional Articles from MSSQLTips.com

This tutorial will discuss using variables with SQL DECLARE along with various examples.

Blog Post

From the SQL Server Central Blogs - Export a Power BI Report that cannot be Downloaded

Koen Verbeeck from Koen Verbeeck

Yes, you’re reading that right, we’re going to download a report that cannot be downloaded. Well, it cannot be downloaded from the user interface, that is. Suppose you have...

From the SQL Server Central Blogs - Query Intelligence in SQL Server 2025: What Developers Need to Know

Chris Yates from The SQL Professor

When Microsoft announced SQL Server 2025, I was curious about what would truly change the way developers and DBA’s interact with data. Over the years, we have seen incremental...

Murach's SQL Server 2022 for developers

Site Owners from SQLServerCentral

Murach's SQL Server 2022 for Developers is a comprehensive guide to database design and management. This computer book teaches essential SQL statements through clear examples and practical exercises. The book's unique paired-pages format makes learning database software concepts easier, while providing in-depth coverage of database management fundamentals. Ideal for both beginners and seasoned developers seeking to enhance their data management skills.

 

 Question of the Day

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

 

The Ending Substring

In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']'

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)

Getting The Database Name

I run this code to connect to SQL Server 2022 from the command line.

sqlcmd -S localhost -E

At the command line, I run these two commands:

SELECT ORIGINAL_DB_NAME()
GO

What is returned?

Answer: An empty string

Explanation: If not database is specified in the connection string, an empty string is returned. Ref: ORIGINAL_DB_NAME - https://learn.microsoft.com/en-us/sql/t-sql/functions/original-db-name-transact-sql?view=sql-server-ver17

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 2019 - Administration
Columnstore index question - Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but I haven’t been able to find clear answers—so I wanted to ask here. I have a table (a heap, with no nonclustered indexes either) that contains about 110 million records. There’s a job that runs once a week with this query(with […]
SQL Server 2019 - Development
Need to overload tempdb - Yes, you read that title correctly. I have a somewhat hilarious problem. We have some queries that are overloading tempdb which fills up the drive and brings everything to a halt. This is a reporting server, not OLTP, so we've been given permission from the application owner to kill all queries that fill up the […]
Suggestions
Email change does not work - I changed my email address in Edit Profile page, but it has no effect - I still receive emails to my old mailbox. Did I miss anything? Thanks  
Editorials
The case for "Understanding our business" training - Comments posted to this topic are about the item The case for "Understanding our business" training
Don't Create Workslop - Comments posted to this topic are about the item Don't Create Workslop
A Place where AI Technology Shines - Comments posted to this topic are about the item A Place where AI Technology Shines
Being Mindful of Design Time - Comments posted to this topic are about the item Being Mindful of Design Time
Article Discussions by Author
Specifying the Collation - Comments posted to this topic are about the item Specifying the Collation
SQL Server 2025 has arrived! - Comments posted to this topic are about the item SQL Server 2025 has arrived!
What is the original database name? - Comments posted to this topic are about the item What is the original database name?
The DBScan algorithm tutorial - Comments posted to this topic are about the item The DBScan algorithm tutorial
Getting the Object Code - Comments posted to this topic are about the item Getting the Object Code
T-SQL in SQL Server 2025: Concatenating Strings - Comments posted to this topic are about the item T-SQL in SQL Server 2025: Concatenating Strings
SQL Server 2022 - Administration
Alternate for xp_delete_file - alternate for xp_delete_file
SQL Server 2022 - Development
Select @ for different fields - I have a need where I need to pass a field name to a Stored Procedure then lookup information on it.  Any insight would be greatly appreciated! IE: Declare @Field char(50) Set @field = 'fpartno' Select @field from m2mdata01..inmastx
 

 

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

 

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