Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com
Hand-picked content to sharpen your professional edge
Editorial
 

Lies You Should Believe - Anything is possible

We have all heard the saying I based this week's editorial on. It has been credited to Benjamin Franklin and goes like this, “You can do anything you set your mind to”. This is such a powerful way of thinking when you are starting a task. “I can do it, no matter what anyone says.”

But of course, as technology people, we are pretty logical thinking people, so we know this is not even somewhat true. For example, if you set your mind to it, you cannot make yourself a ten-foot-tall automobile. For those of you not living with the Imperial system of measurement, this is 3.048 meters, or if you are really an interesting person: 0.00164579 nautical miles. No matter how you measure it or how hard you set your mind to it… you will never be an automobile. Even if you practice hard, it is not going to happen. And in a slightly less silly scenario, unless you have done a lot of medical training, you cannot do my next hip replacement, no matter how hard you set your mind to it.

The challenge is to put all the non-obvious doubts out of your mind and put your mind to the task. Just like when I said in the first entry in this series that you need to believe that there are no dumb ideas, the principle here is the same. Rationally you know that you can’t do just anything, but if you start with the fundamental idea that setting your mind to a task you can do what seems like the impossible; it will more often be true.

My real-world example

My biggest example is this blog and literally everything I have written the past 20 years. Before I started writing professionally, I had never written a paper of any considerable size. In college I strictly avoided all the classes where writing was involved unless it was a required class. Even then, to my recollection I had never written more than 5 pages on one subject, and I did not get great marks for that effort either.

So, my first writing task as a professional? Write a 607-page book on Database Design. I got myself into that mess by asking someone at WROX press if there was a book where I could learn more about the subject. I was certainly no expert then, and I don’t really consider myself an expert now as I do know a few of the experts in the field like Joe Celko. I just have learned the practical application and enough about why it matters to help others do the same.

I look back on that process as probably the first time I really did apply the “anything is possible” principle to my life. It was one of the most challenging things I have ever done, and was when I coined the phrase “it is awesome to have written a book.”

Yet, I kept doing it. This has always been curious to me, as I have continued to write for a living. If that experience was so bad, why did I keep doing it? Because I learned I could, and from there I learned how it was done, through research and great writing mentors in the form of a few editors I have worked with.

I am convinced this is also what makes DBAs indispensable

As a typical example, you are told there is a query that is running slow. Of course, we are ready and able to check the query plan, find the missing index, apply it and take the win. This is just easy hero standing stuff. But sometimes, you get a query that is 4 pages long, generated by a tool so you can’t easily alter it, and the query plan prints out in SQL Server Management Studio so small you would need a monitor the size of the moon to view it all.

Add in that usually this is one of those “augh, we need this now!” sort of things and not only do you have the self-doubt that you can handle this, you have plain old time anxiety that tends to cause even great sports figures to make mistakes because you are feeling the pressure of “what happens when I fail?”

Of course, most of the time you get to it, and you find the issue, and get it fixed. Of course, the problem with all of this is that sometimes, the reality is that you come to a place where it can’t be fixed, at least by you, and you need help. At these points it is imperative to not let the imposter lie creep into your head and make you lose your confidence. Even though you logically know you can’t do anything in the world, you need that kind of confidence to start doing something that feels out of your reach.

For your own good, failure must be treated positively either a lesson in what to do next, or a validation that you actually did everything possible.

What about you?

In your own career in data, how many times have you had that dread. “I can’t do this. It just isn’t possible.” I suspect that if your answer is “a few times”, you are probably referring to a few times a week, or even a day.

Do you have any examples you want to share in the comments where you just had to tell yourself you can do something that seemed impossible for you, and then you actually delivered? Did it change you in any way?

 

Louis Davidson (@drsql)

Join the debate, and respond to the editorial on the forums

 
 
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
AI/Machine Learning/Cognitive Services

Achieving Success in the New Era of AI-Driven Data Management

From IT Pro - Microsoft Windows Information, Solutions, Tools

AI is transforming data analytics by driving personalization, operational efficiency, and real-time insights while demanding robust governance to address data quality, ethical considerations, and regulatory compliance.

LLM Adventures: Microsoft Copilot Studio (The Good, The Bad, and The Ugly)

From Prologika (Teo Lachev's Weblog)

“A momentary lapse of reason That binds a life to a life You won’t regret, you will never forget There’ll be no sleep in here tonight” “The Slip”, Pink...

An Overview of the Naive Bayes Class of Algorithms

From Curated SQL

Harris Amjad takes us through a rather useful class of algorithms for classification: As AI and Machine Learning have increased in popularity, especially Large Language…

10% of Substack’s Largest Newsletters Depend on AI Technology

From Past News - RSS Feeds

Wired finds that nearly 10 percent of the biggest ...

Former Google CEO AI Warning: Global Catastrophe in 5 Years

From Past News - RSS Feeds

Concerned about AI warnings? Find out what the former CEO of Google has to say about artificial intelligence. Should you be worried? The post Former Google CEO AI Warning: Global...

Administration of SQL Server

Automatically Generate Restore Database SQL Server Scripts

From MSSQL Tips

How to automatically generate SQL Server RESTORE database commands for a set of databases based on the backup file contents.

A Mechanism for Change Management for DBAs

From Curated SQL

Terri Hurley shares one path: Back in the day when I received an email from a developer who requested a Production Change, I would copy…

Adding Test data to msdb.sysjobhistory

From SQLServerCentral Blogs

One of our internal people was looking to test some process in (I assume) Redgate Monitor and needed more job history than they had in msdb.sysjobhistory. They wanted to... The...

Cloud - AWS

AWS Weekly Roundup: 197 new launches, AI training partnership with Anthropic, and join AWS re:Invent virtually (Nov 25, 2024)

From AWS News Blog

Last week, I saw an astonishing number of new feat...

Data Storytelling and Visualisation

Building a Gantt Chart

From Curated SQL

Amy Esselman wants to know if you’re on time or have any slack: A Gantt chart is used to visually present tasks or events over…

Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science)

Two ways to perform CI/CD for SQL databases in Fabric using Azure DevOps

From Kevin Chant

Reading Time: 7 minutes In this post I want to co...

Modernize a Traditional SQL Server Architecture with Fabric

From MSSQL Tips

This article uncovers some of the benefits of mode...

Performance Tuning SQL Server

Performance Pains With NOT IN And NULLable Columns In SQL Server

From Erik Darling Data

Performance Pains With NOT IN And NULLable Columns...

Query Hash Value Changes

From Curated SQL

Kendra Little digs into a problem: This is the worst bug I’ve found in SQL Server to date. Previously, my top find was SQL Server Online…

SQL SERVER – Understanding WITH RECOMPILE in Stored Procedures

From Journey to SQL Authority with Pinal Dave

The culprit? Parameter sniffing. The solution? You...

An Advanced SQL Server Query Profiling Technique

From Erik Darling Data

An Advanced SQL Server Query Profiling Technique T...

SQL Server Performance Tuning in the Age of AI: An Expert’s Tale

From Journey to SQL Authority with Pinal Dave

My job? To figure out what went wrong and fix it. Let us talk about SQL Server Performance Tuning in the Age of AI. First appeared on SQL Server Performance...

When Profiling SQL Server Stored Procedures Goes Wrong

From Erik Darling Data

When Profiling SQL Server Stored Procedures Goes Wrong Thanks for reading! Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my...

PostgreSQL

Overlapping Ranges in Subsets in PostgreSQL

From Simple Talk

In Part I of this series, we explored overlap quer...

Finding Free Space in Azure Database for PostgreSQL

From Curated SQL

Josephine Bush needs some space: I wanted to figure out how big (or approximately how big) my dump file would be. In QA, I have…

The Challenge of Major Version Upgrades in PostgreSQL

From Curated SQL

Peter Eisentraut lays out the explanation: Upgrades between PostgreSQL major versions are famously annoying. You can’t just install the server binaries and restart, because the format of…

Andrei Lepikhov: Could GROUP-BY clause reordering improve performance?

From Planet Postgres

PostgreSQL users often employ analytical queries t...

Regina Obe: Some of my favorite PostgreSQLisms

From Planet Postgres

When I work with other relational databases I am reminded about how I can't use my favorite PostgreSQL hacks in them. I call these hacks PostgreSQLisms. A PostgreSQLism is...

PowerPivot/PowerQuery/PowerBI

Benchmarking Power BI import speed for local data sources

From SQLGene – Learning SQL Slowly

TL;DR – The fastest local format for importing data into Power BI is Parquet and then….MS Access? The chart above shows the number of seconds it took to load...

Power BI Writeback via Fabric SQL Database

From Curated SQL

Jon Voge gives us a use case for Fabric SQL Databases: Jon briefly describes two mechanisms people used and then how you can do this…

Contrasting Power BI and Power BI Report Server

From Curated SQL

Soheil Bakhshi makes me sad: Depending on your organisation’s preferences, data governance requirements, and the platforms you intend to use for report deployment you may…

Power BI Copilot: Where Are The CUs Consumed?

From Chris Webb's BI Blog

If you’ve looked into using Copilot with Power B...

Professional Development

Inclusive Engineering at Redgate

From Blog – Redgate Software

In mid 2024, one of Redgate’s coaches, Clare, pulled together a team to focus on improving inclusivity within Redgate’s Engineering organisation. This group was designed to work alongside the...

When is the perfect moment to build a data strategy in a company?

From SQLServerCentral Blogs

The post When is the perfect moment to build a dat...

SQL Server News

Microsoft Ignite Announcements Nov 2024

From SQLServerCentral Blogs

Announced at Microsoft Ignite last week were some new product features related to the data platform and AI. Check out the Major announcements and Book of News. Below are... The...

The Lighter Side

A New Word: Nachlophobia

From SQLServerCentral Blogs

nachlophobia – n. the fear that your deepest con...

Five Annoying Tech Things to Turn Off Right Now

From IT Pro - Microsoft Windows Information, Solutions, Tools

You can put a stop to Apple's bonkers AI summaries and the clickety sounds as you type on your phone.

The Atari 7800+ is a no-frills glimpse into a forgotten gaming era

From Ars Technica

Awkward controls and a lack of features make a device for Atari completists only.

Tools for Dev (SSMS, ADS, VS, etc.)

SSMS 21 First Impressions

From Callihan Data

Some exciting news recently as SQL Server Management Studio 21 is available in preview. Head over here to download it and experiment with the latest. I’ve worked with it...

 
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. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

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