Let's Talk SQL Server Administration

Things We Are Missing

I read this great little blog post called "Trying to Notice What's Missing." It's not real long and it's worth your time. If you'd like a TLDR, the author points out how in-person meetings at conferences resulted in enhancements to open source software due to superior, in-person, communication.

Strictly on a personal level, I miss conferences. As much as I'm an introvert (and I actually am), I do enjoy meeting people. That is all, understandably, on hold. However, I'd like to step away from the personal.

Like the author of the post above, I'm curious how we'll be able to tell what was lost due to the lack of in-person communications. Sure, Zoom meetings, Teams, etc., allow for communication, above and beyond Slack or email. However, study after study shows that these online meetings are less effective than direct, in-person communications. People don't learn as well remotely as they do in person. It has to do with distractions, the medium itself, and just how we, jumped up monkeys that we are, best communicate. In-person, is superior.

We've just spent over a year with inferior communications within IT and development. I can't help but ask the same question as the other author. What did we miss? How will we spot what's missing? Have there been solutions, breakthroughs or bug fixes that have not been accomplished, but would have been? Are these simply delayed, or have we missed a few opportunities, permanently? What would the people who have been lost contributed?

I'm sorry to say, all I have here are questions. I don't know the answer to any of those questions. Not at all. However, I do find thinking about it to be interesting. As the Covid crisis slowly begins to recede in the rearview mirror, I'm left wondering, is there a way to measure what's just not there?

Grant Fritchey

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

A set of PowerShell automation script tasks for running database build and migrations tasks. This article describes the SQL code analysis task, which will check the syntax of the SQL code in your databases and your migration scripts for 'code smells'.

This article provides PowerShell automation scripts for running Flyway database migrations. These scripts use SQL Compare to automatically generate all the required database build artifacts in the version control system, for each Flyway deployment.

The 2021 State of Database Monitoring survey is now open, and we want to know how you’re currently tackling your server, instance, and database monitoring. By taking part, you’ll contribute to the sole industry-wide report on database monitoring, and provide insights into how SQL Server professionals manage their estates and what challenges they face. Plus, you’ll receive an advanced copy of the report and entry to a prize draw to win a $500 Amazon voucher.

Click to learn more about author Marco Riva. In re...

Transparent Data Encryption (TDE) is one of the ea...

Using SQL Server Replication with AlwaysOn Availab...

Total: 1 Average: 5 Thanks to the diversity of cul...

Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn everything needed to start...

or: How I learned to stop worrying, and love all-caps domain names. I’m a complete beginner at Linux, so I should preface this post with the fact that these...

CREATE OR ALTER PROCEDURE scheduler_px_worker__reportASBEGIN;WITH tasks AS (SELECT ot.scheduler_id, ot.session_id, ot.exec_context_idFROM sys.dm_os_tasks otJOIN sys.dm_exec_requests er ON ot.session_id = er.session_idAND ot.exec_context_id > 0)SELECT t.scheduler_id, os.parent_node_id, spid__exec_context_id = STRING_AGG(CONVERT(VARCHAR(4), t.session_id) ...

In this article, Edward Pollack explains the benefits of a SQL Server data dictionary and how to build one.

Azure Logic Apps can be used to automate steps lik...

With SQL Saturdays being rebooted, and the SQLSatu...

My blog post from February 1 explains that Redgate...

Organizations are reaping the benefits of taking a...

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a fairly simple construct, but I... The...

Click to learn more about author Steve Leeper. Tod...

Click here to learn more about Victor Dudemaine. A...

Organizations have many choices when it comes to d...

This month the #TSQL2SDAY invitation comes from St...

Itzik Ben-Gan continues collaborating with readers...

Introduction The Inserted Scan operator is only found in execution plans for code in triggers. It is used for queries that read data from the inserted pseudo-table. Its counterpart,...

Is it better to build a model as a regular star sc...

Security roles can simplify permissions in SQL Server. In this article, Greg Larsen explains fixed server and database roles.

Name:Wreck flaws in TCP/IP have global implication...

Amongst the 100+ vulnerabilities patch in this mon...

In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala.

Fans of the Uncharted game series might recognize ...

The spinoff will unwind, at least in part, a consolidation created five years ago in Dell’s $67 billion acquisition of VMware’s parent, EMC Corp.

"For us, it’s super important to have a launchpa...

Another one of the most popular development tools ...