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
 

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

 
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.
Vendors/3rd Party Products

Running SQL Code Analysis during Flyway Migrations

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'.

Creating Database Build Artifacts when Running Flyway Migrations

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.

Tell us about how you monitor your databases

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.

AI/Machine Learning/Cognitive Services

Alexa, Make My Database Smart!

From Dataversity

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

Administration of SQL Server

Setting up Transparent Data Encryption (TDE)

From SQLServerCentral Blogs

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

SQL Server Replication and AlwaysOn Availability Groups

From DCAC

Using SQL Server Replication with AlwaysOn Availab...

SQL Date Format: How to Handle it the Smart Way

From SQL Server – {coding}Sight

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

Common Expression Tables – Introduction

From Steve Stedman

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...

Connecting a SQL Server client on Linux using Active Directory authentication

From Sunday morning T

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...

A little something for exploring placement of SQL Server Parallel Workers

From sql.sasquatch

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) ...

Building a SQL Server data dictionary

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

Azure DevOps

Automating Azure DevOps with Logic Apps

From Simple Talk

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

Community Interests

Everyone Run a SQL Saturday in 2021

From SQLServerCentral Blogs

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

What’s Redgate’s plan for PASS?

From Blog – Redgate Software

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

Computing in the Cloud (Azure, Google, AWS)

Hot to Develop an Effective Multicloud Backup Approach

From IT Pro - Microsoft Windows Information, Solutions, Tools

Organizations are reaping the benefits of taking a...

DMO/SMO/Powershell

The PowerShell Basics If Statement–#SQLNewBlogger

From SQLServerCentral Blogs

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...

Data Warehousing

Three Steps to Building a Successful Data Migration and Protection Strategy

From Dataversity

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

Database Design, Theory and Development

Why You Should Be Data-Focused – Not Data-Driven

From Dataversity

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

How to choose between SQL and NoSQL databases

From Simple Talk

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

Notebooks

T-SQL Tuesday #137: Using Jupyter Notebooks

From Mike Bronowski

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

Performance Tuning SQL Server

Number series generator challenge solutions – Part 4

From SQLPerformance.com

Itzik Ben-Gan continues collaborating with readers...

Inserted Scan

From SQL Server Fast

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,...

PowerPivot/PowerQuery/PowerBI

Star schema or single table in Power BI

From Sqlbi

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

SQL Server Security and Auditing

SQL Server Security – Fixed server and database roles

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

Security News and Issues

100 million more IoT devices are exposed—and they won’t be the last

From Ars Technica

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

NSA Discloses Vulnerabilities in Microsoft Exchange

From Schneier on Security

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

Software Development

A data transformation problem in SQL and Scala: Dovetailing declarative solutions Part II

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

Tech News

17th-century pirates might have stashed Middle Eastern coins in New England

From Ars Technica

Fans of the Uncharted game series might recognize ...

Dell Will Spin Off VMware, Unwind Part of Biggest Tech Deal

From IT Pro - Microsoft Windows Information, Solutions, Tools

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.

Rocket Report: SpaceX to build huge launch tower, Branson sells Virgin stock

From Ars Technica

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

Virtualization and Containers/Kubernetes

Popular software development tool Docker gets Apple M1 support

From Ars Technica

Another one of the most popular development tools ...

 
RSS FeedTwitter
This email has been sent to newsletter@newslettercollector.com. 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

 

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