You Are An Inspiration

Hero, Champion, Inspiration. These are words that are bantered around about people regularly. Joe was a hero when he saved that puppy. Betty was the champion runner and won the race. Pat was an inspiration; they work so hard.

Hero and champion are universally understood as positive things. Inspiration is typically used as a positive, but is it? That is usually how it is used, but the definition is merely something that inspires. You can be inspired to do anything, and pretty much everything that is done was inspired by someone else. You have inspired others to do countless things whether you wanted to or not. The only question is: are you a positive inspiration?

Every move you make around other people affects them.

If you are writing code, you can inspire people around you by producing working code, writing effective documentation, writing thorough tests, and checking in your code when it is ready.

Designing a database? Making sure that the database works well with the data sizes needed, using proper standards, and meeting the requirements will inspire the next person to change the database similarly.

As a reader of this editorial on SQL Server Central, I will mostly mention technical things, but this extends to pretty much everything you do, technical and otherwise. How you treat others, clean up your workspace, etc, all will inspire others. Sometimes to be better, sometimes to be worse.

Who is watching? Everyone is. Kids and adults of all ages. People who look like you and people who look nothing like you. You are very much an inspiration to them all in some way, probably very small, but possibly life changing. Every day you get to make a choice. Be a good inspiration, or a not so good one.

Ideally, be a good inspiration.

Louis Davidson (@drsql)

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

If your organization is embarking on a cloud migration project, it can be a great opportunity to develop skills and qualities that will help unlock your leadership potential. In part one of the two-part series, industry experts share the skills to be gained, the unique career opportunities cloud migrations offer, and the best ways to get involved.

Is MongoDB in use within your organization? The Flyway development team are adding MongoDB support into Flyway and would like to better understand the current pain points. If you are able help, or are interested in finding out more, please participate in our 5-minute survey.

How to plan for an effective response to database problems, as part of a broader, 'tiered' monitoring strategy for production systems, where the process to resolve any known or routine problem is provided alongside the associated alert, and any urgent issues that can't be fixed, or threaten the quality of the service, are escalated promptly to the right team.

The main reason why database deployments fail is a lack of rigorous database testing, and the main reason this task is so often avoided, or delayed, is the difficulties of creating and managing all the required test data. This article will help you understand the steps to better test data management, as part of a database emigration strategy.

Tonie Huizer explores the Flyway Desktop CLI, also known as "flyway-dev", its capabilities, and how to use it to automate the process of capturing the schema changes made to a development database and then generating a migration script to use in subsequent deployments of those changes.

Camilo Reyes explores AWS step functions and show how they enable asynchronous processes without blocking. Apps, for example, are expected to show results within milliseconds. If a job takes longer than a few seconds, a nice approach is to run this asynchronously so it doesn’t block and force people to wait.

Initially, I thought I would have to use sqlcmd be...

SQL Server 2022 introduces a new feature to enable...

If your organization is embarking on a cloud migration project, it can be a great opportunity to develop skills and qualities that will help unlock your leadership potential. In part one of the two-part series, industry experts share the skills to be gained, the unique career opportunities cloud migrations offer, and the best ways to get involved.

Join Ryan Booz on November 28th for his webinar on monitoring PostgreSQL databases and how it's crucial to ensure the overall health and performance of your ecosystem. PostgreSQL provides a wealth of metrics, but which ones are most important to measure and how best should you do this? In this webinar, you will gain insights and strategies to help keep your database environment running smoothly and efficiently so you can avoid some of the most common bottlenecks.

Don’t worry if you missed Redgate’s live stream announcement at PASS Data Community Summit - you can join David Gummer, Chief Product Officer at Redgate, and Alex Yates, Senior Solutions Specialist at Redgate, live on the 29th of November and learn how test data management can benefit you in your role.

I’ve been to a lot of conferences, and one that ...

Beginner's Introduction to PowerShell Remoting ...

In this article, we will introduce Microsoft Fabric and how it relates to Power BI Premium Capacity we will turn to the mechanics of capacity utilization, and we will...

Agile development has grown in popularity in recent years due to its success in delivering software on time and on budget. If you’re looking for a way to make your software development process more flexible and responsive, Agile might be a good option for you.

Over the past months, I’ve been engaging with ma...

Andy Leonard kicks off a trial: Are you interested...

To quickly summarize where we are, we started test...

While there are many features within PostgreSQL that are really similar to those within SQL Server, there are some that are unique. One of these unique features is called VACUUM. In my head, I compare this with the tempdb in SQL Server. Not because they act in any way the same or serve similar purposes. VACUUM is a complex, deep, topic, so this article will only act as an introduction. Let’s get started.

This is part twenty-four of the plansplaining seri...

Suppose you have a reasonably large table with a clustered index and a number of non-clustered indexes. If your WHERE clause filters by multiple columns covered by those non-clustered...

Last week it was announced that Power BI datasets ...

Recently, I’ve gotten a couple of questions abou...

Source control is fundamental when dealing with projects and sharing code between multiple developers. Power BI present some challenges related to source control. But it’s finally providing us with...

We are happy to announce that Starting CU 10 release for SQL Server 2022 , SQL Server 2022 on RHEL 9 and Ubuntu 22.04 is now generally available (GA), meaning you...

As organizations increasingly rely on AI-developed...

Recently someone posted a question where they coul...

A client asked this question recently: How do I ch...

Learn how to write and use recursive CTEs in SQL S...

In this post, I'll cover a few methods you can use...

Let us learn How to Convert Month Number to Month Name. WE will see three methods in this blog post. First appeared on SQL SERVER – How to...

What's fascinating about the Fibonacci series is its ubiquitous presence in nature, from the arrangement of leaves on a stem to the shape of a hurricane. First appeared on SQL...

I talk about the evolution of my thinking on featu...

On social media, I asked folks, “Why haven’t y...

THE VIDEO THE SYNOPSIS This video serves as a coda...

Introduction On November 13, 2023, Microsoft relea...