I honestly enjoy writing editorials. Something pops into my tiny brain next to something else, and I'm off. However, today, as I started to write on the topic of learning, I suddenly felt like I had just written this same editorial. I go and look, sure enough, several of my recent editorials have been on learning. OK. Well, I'm clearly stuck in a rut. Let's talk, instead, about inspiration.

When we talk about inspiration, we have to break it down. There's the concept that inspires you, personal freedom is a big one for me. There's the person that inspires you, historically I've always had a soft spot for Teddy Roosevelt. However, by inspiration in this context, I mean, what drives us to make the choices we make. Deciding to write about learning vs writing about inspiration, that idea has to come from somewhere. Myself, I spend a lot of time thinking about learning, from the standpoint of the ignorant person who needs information, and from the standpoint of the informed person trying to share information. Learning and teaching are fundamental to my everyday job. This is why I've so frequently put learning into my editorials.

I generally get my inspiration from the things I do the most. Hence, references to history (reading an interesting, not sure I can say good, book on the Alamo, "Exodus From The Alamo"), ham radio (doing more with DMR), and travel (off to SQLBits this week), will pop up in the stuff I write quite a lot. I get inspiration for blog posts from the questions I get when I present and the ones I see here on SQL Server Central. I even get ideas sometimes from watching stupid stuff on TV. It all comes together, eventually, to inspire ideas.

My question to you today is probably pretty obvious by now: where does your inspiration come from? More specifically, I'm curious where your solution inspirations come from? How did you decide to try a CROSS APPLY instead of a JOIN on that query you're tuning? What made you look into AWS RDS as the host for the latest data project? Where are you finding your technical inspiration?

Grant Fritchey

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

The multi-million-dollar question for you and your business is... what is the real business value of frequent deployments? Part one of three in this series on the value of database DevOps.

I'll show how to use some pipeline-aware PowerShell functions to filter out and save the bits we want and pass the results along in a form that is useful to the next process in the pipeline.

SQL Monitor's Top procedures list makes it simple to find the procedures having the biggest impact on performance, allowing you to prioritize your tuning efforts, reduce risk and keep pace with the requirements of your growing database estate.

I often perform code reviews and thought it would be fun to frame this exercise: a completely fictitious stored procedure hits my desk, I’ll reject it of course, and enumerate the reasons why. The procedure might pass review in a lot of shops, but not in mine.

ReAct (Reason + Act) is a flexible LLM chain frame...

Microsoft announced yesterday several new features...

Organizations are seeking software engineers with both hard and soft skills — as salaries rise from 2020 levels, a new report finds.

Introduction These are my SQL Server Diagnostic In...

Learn the basics of creating VIEWs in SQL Server i...

Blocking in SQL Server can occur when….. one que...

When I was a DBA involved with the management of a...

Please take a look at the following blog post by @Joseph Pilov (and team) to get detailed explanations, causes, and user actions for the top 25 most common SQL Server Engine...

For most people that are reading this post, I’d ...

The Tab Coloring component of SQL Prompt’s SSMS Tab management could save you from accidentally doing something apocalyptic on a production server, ever again. The post SQL Prompt Safety Net...

Mistakes occasionally happen. Sometimes you accidentally close an SSMS query tab without saving it, before realizing it contained an essential bit of code. Occasionally, you make some ill-judged 'refinements'...

The basic differences between Synapse Serverless a...

Azure Synapse Analytics is not just “another ser...

In this Data Exposed episode with Anna Hoffman and Perry Skountrianos, we will discuss the new capability in SQL Server 2022 that introduces new cross platform T-SQL commands to...

Is your company hiring for a database position as ...

At AWS re:Invent 2022, we previewed AWS Applicatio...

This is a five-part series of articles examining f...

Amazon S3 is not a filesystem so there is no rename command to rename objects or files. However this is a well known workaround. Workaround Issue […] The post How...

The AWS Heroes are passionate AWS experts who are dedicated to sharing their in-depth knowledge within the community. They inspire, uplift, and motivate the global AWS community, and today,...

The cloud has changed cybersecurity. Here's why these changes make security more challenging.

From castles and dragons to swordfights and spells, this year’s SQL Bits will have it all. Make sure you don’t miss out on our great sessions, from Code Errors to Reliable Releases, to adding some PostgreSQL skills to your repertoire. And come say “hi” to us at the Redgate booth. Get 10% off registering with 10REDGATE

Microsoft has announced the release of version 5.0...

PowerShell is very forgiving of errors. For exampl...

I recently had a handful of CVS files that needed ...

This PowerShell script lets you scan your network ...

Analytics can get you answers from data. With an e...

  ...

I spoke with Jack Parmer, Product Strategy Advisor...

Artificial intelligence (AI) technologies like machine learning (ML) have changed how we handle and process data. However, AI adoption isn’t simple. Most companies utilize AI only for the tiniest...

(originally published August 2002) Note: "Then &am...

Has a manager or a stakeholder ever asked you for a single slide update on a tight timeline for an important meeting? This can be stressful and can impose...

Here's how data ingestion pipelines fit in the broader data management ecosystem.

The future of data is small. As organizations grapple with ever-increasing amounts of data, the limits of the big data movement are becoming clear. Over the last two decades, big...

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

Automation is playing a critical role in helping companies meet their sustainability goals, thanks to its ability to increase efficiency and speed to value.

Reading Time: 4 minutes In this post I want to cover how you can deploy a dacpac to a serverless SQL pool using GitHub Actions. Yes, you are reading...

This is a common problem if you are bringing data ...

Trevor Hunter from Kobo Rakuten is going to be speaking about Kobo’s usage of RavenDB in a webinar on next Wednesday.When I started at Kobo, we needed to look...

Your mission, if you chose to accept it, was to sh...

When an application grows the associated database grows automatically. It needs to be scaled to a larger machine or server and overall configuration needs to be increased to handle...

I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data from an events table (part 1 and part 2)....

On April 4, 2023 I will run an SQLpassion Live Tra...

In this article, we look at the SQL MERGE command ...

Tuning SQL Server Queries With Computed Columns, F...

In SQL Server 2022, a new feature called Intelligent Query Processing (IQP) makes use of machine learning to enhance query performance. Because of the automatic workload adjustment provided by... The...

Tuning SQL Server Queries With Filtered Indexes Demo Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering...

Microsoft has just announced the general availabil...

Learn how to build sunburst charts with Power BI i...

When a business considers the implementation of an analytics solution, it may be focused on choosing the easiest, most flexible solution to encourage its users to make analytics part...

Struggling with Power BI App permissions when usin...

Here's how to build a technically skilled workforc...

I missed T-SQL Tuesday last month. I got busy and ...

The jury is still out on whether or not the global economy is headed toward a recession, yet it's never too early to begin developing a contingency plan.

It was my great pleasure to present last week to t...

Welcome to Myths and Misconceptions Month, or “M...

In SQL Server, you can create logins using Windows local groups as a way to manage access to the database server. This means that you can add users to...

Companies are drowning in data. This is a swelling...

More than 4% of employees have put sensitive corpo...

The health, manufacturing, and energy sectors are ...

Endor Labs has outlined 10 risks of open source so...

If the proposed rule is approved, organizations wo...

AT&T is notifying customers of a Customer Prop...

Much like a hostage's proof-of-life video, the ran...

Learn various ways to get started with the SQL lan...

This article explains the different approaches use...

SQL Server is Microsoft’s premier data platform....

When you are writing T-SQL scripts to save away, f...

Certainly not to encourage people to stay on ancient versions if they don't have to, I took a crack at replicating TRY_PARSE on older versions.

When a startup called Retro Biosciences eased out ...

Women are trailblazing new ideas across industries...

Led by growth in Russia, more than 40% of global I...

This article is from The Spark, MIT Technology Review’s weekly climate newsletter. To receive it in your inbox every Wednesday, sign up here. If y’all have been around for a...

This article is from The Checkup, MIT Technology Review’s weekly biotech newsletter. To receive it in your inbox every Thursday, sign up here. I’ve spent the last few days...