Sharing, Tuning, Pivoting, and Fabric; All In O ne Handy Newsletter

Sharing the Work You Do

During one my yearly review, I got one particularly interesting piece of feedback. “You need to share the work you are doing and share with the company.” This is basically a matter of letting people know about the stuff we are putting out on Simple-Talk.com. It is something that is regularly done here, but to my introverted, slightly insecure brain, it is borderline terrifying. If I am honest, I had similar feedback from my previous company as well!

When I go to share a piece of content, I typically ask myself: “What is the worst that could happen?” Oh boy; my brain starts racing. I could have the wrong link, a word misspelled, spelled someone’s name wrong, or … Deep breath. Of course, I have done all these things a time or two, including spelling our CEO’s name wrong once in the last item I shared to my teammates.

While my anxiety level shot through the roof just thinking about all the possible things that could go wrong, there was a tiny voice in my head that said. “Hey, you know your work isn’t terrible, and if you made a mistake or two, better your friends find the errors instead of the world.” That rational voice seems to be a lot more well, rational than the other insecure noises I am fighting in my head.

Earlier this week I wrote an article about Redgate’s State of the Database Landscape Survey Results (which you can read right here, or just go check out the survey here, though I wouldn’t hate the click!). Gratuitously sharing that link with you here on the SQL Server Central and the Internet seems just fine for some reason, but telling my coworkers increases the ringing in my ears to a slightly higher frequency.

I shared it and it was okay. On to the next problem.

Take Care to Not Overdo It

My second biggest fear when I share my work with others is that I never want to feel like I am calling too much attention to myself. So, pointing out stuff that I did myself always feels awkward.

I prefer sharing the work that others have done or at least have contributed to. Highlighting those who helped achieve a task is a lot easier than highlighting my work. Luckily, most of my work is editing and posting the work of other writers. Highlighting their work is easy, and not so much my part in the process (no matter how large or how small, and boy does that amount of work vary at times).

Advice To Myself, and to You, but mostly Me

You do good work. I may not know you personally, but I am going to say that if you are reading this editorial and reached the end here, you care about what you do, and you do good work. Wtih as much humility as possible and avoiding anything that appears like bragging (or worse yet, humble bragging!), let the people you work with know that in whatever way is possible. Save the bragging for the people around you that enable you to achieve great things.

Louis Davidson (@drsql)

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

With Flyway, you can adopt a test-driven development strategy that will allow you to test and evaluate databases, and database objects, at every phase of the database development lifecycle. The further down the delivery pipeline that bugs appear, the more costly in time and resources they are to fix. This approach will allow you to catch many of them before the database change even gets committed to version control, making a continuous delivery process much easier to adopt and sustain.

How to perform a range of useful database tasks automatically during Flyway migrations, using a DOS callback script. We provide a demo script that will collect all the necessary information from Flyway, run the task and then save any file with the appropriate name. You can use it to automate tasks such creating backups or DACPACs or generating a build script, each time Flyway creates a new database version.

With Flyway, you can adopt a test-driven development strategy that will allow you to test and evaluate databases, and database objects, at every phase of the database development lifecycle....

Deepthi Goguri fills us in on where Query Store has gone as of SQL Server 2022: In this post, you are going to learn about…

Tom Collins answers a question: Question: I’m trying to delete a TempDB ndf file from the TempDB file definitions. It is no longer required ,but getting…

In this post, I’ll share a little more detail about the SQL Server portions of the migration, what we’ve done since, and how we’ve approached modernizing our environment while migrating to Azure. I’ll talk about a few key choices we made and trade-offs between simplicity and risk in case they are helpful as you face similar decisions.

Ed Pollack shares some great advice about how long to keep data around in your databases.

THE VIDEO THE SYNOPSIS In this video, we harden ou...

SQL Server's Buffer Cache: How to Calculate Dirty ...

We got the question if you could use Field Parameters with Direct Lake in Power BI. The answer is, yes? However,... Patrick tells more! Let report readers use field...

Kendra Little provides some guidance: Whether or not you use Azure SQL Managed Instance, you will likely be asked for an opinion on it eventually…

Learn more about the License-free HADR replica in Azure SQL DB in this episode of Data Exposed with Anna Hoffman and Rajesh Setlem. Watch on Data Exposed Resources: To learn more and...

The key findings from our industry survey reveal how the database landscape has become increasingly complex in recent years. As modern-day business demands and data needs evolve, data professionals and organizations are affected everywhere. Here are the changes coming in 2024 and beyond that you need to know about.

Nikki Kelly shares some thoughts on data governance: Data Governance – you have heard the term a million times and not once has it driven…

Gilbert Quevauvilliers takes us through a comparison: In this blog post I am going to compare Dataflow Gen2 vs Notebook in terms of how much…

Nikola Ilic, best known as Data Mozart, published a great article and video about how to make semantic model data available in Microsoft Fabric. This allows the data to...

Michael Olschimke and Dmytro Polishchuk continue a series: The last article in this blog series discussed the basic entity types in Data Vault 2.0: hubs,…

PostgreSQL continues to be all the rage in 2023, whether in “vanilla” form of the fully open-source distribution or a variant like Amazon RDS, Neon, Yugabyte, and others. If you’re interested in trying PostgreSQL but only have experience with another database like SQL Server, it can feel a bit daunting to get started.

MongoDB provides an efficient environment for stor...

PGConfEU2023 is over and a New Year has started. F...

Hugo Kornelis wraps up a mini-series on window functions: In part twenty-eight of the plansplaining series, I’ll wrap up the six-part mini-series on window functions. After covering the…

Andy Brownsword shares a tip: Deadlocks are an enduring feature of SQL Server. They’ve been a source of pain for many over the years and…

Vlad Drumea troubleshoots a pernicious wait type: In this post I’ll go over what the ASYNC_NETWORK_IO wait type is, when it occurs, and how you…

For this week’s Query Exercise, we’re going to start with an existing query that has performance problems from time to time, depending on how it’s used. This query’s goal...

Making Change SQL Server’s missing index requests (and, by extension, automatic index management) are about 70/30 when it comes to being useful, and useful is the low number. The...

I wrote this to share a series of scripts that help identify if workloads are appropriately separated on the SQL Server host. The main reason we look for this...

Chris Webb notes a change: One of the most important properties you can set in a Power BI DirectQuery semantic model is the “Maximum connections…

Meagan Longoria looks at contrast: Since conditional formatting was released for Power BI, I have seen countless examples of bar charts that have a gradient…

Dany Hoter performs some troubleshooting: A customer approached me and complained that a page in a PBI report was taking a very long time to…

Recently Azure Resource Graph was announced as a n...

The SQL NTILE() is a window function that allows you to break a table into a specified number of approximately equal groups, or . For each row in a grouping, the NTILE() function assigns a bucket number representing the group to which the row belong starting at one.

Chad Callihan violates Betteridge’s Law of Headlines: In case you missed it, the latest version of SQL Server Management Studio (19.3) was released on January 10th. It’s…

Sometimes you need a fast way to test your API cal...

This article looks at different ways to delete an ...