The Word of the Week is Fabric

Trust!

The difference between a low trust society (few individuals within a trust circle outside your family and/or tribe) and a high trust society (general trust of individuals beyond immediate family/tribe associations) generally speaking can be measured as the difference between a low tech (low trust) and high tech (high trust) society. Yes, exceptions abound, but the general rule, largely, holds true.

Speaking of trust, our house is actually one full mile (that's 1.6km for those of you using real measurements, or 946.5 smoots) from our mail box. To say the box isn't visible is an understatement. Due to the hills, rocks & trees, I can barely get a radio signal all the way down there, let alone see it, or even set up some kind of wifi device down there. In short, we don't know when we've got mail (although, that's changing as technology does). However, until recently, this wasn't a big deal. I'd get the mail on the way to, or from, somewhere else. We have, or had, a pretty high-trust situation. However, in the last two weeks, the mail has been cleaned out, multiple times. So has our neighbors. We're now holding our mail (low trust) until we get a locking mailbox set up (even lower trust). I posted this recently on Facebook and had a few people respond that they recently had to do the same thing, in communities all over.

Are we starting to move from a high trust society to a low trust one? Personally, ever the optimist, I don't think so. I think society, as a whole, is as trustworthy as ever. However, a few bad apples can indeed spoil the bunch, as the saying goes. The real question for me is pretty simple, if we are in a migration to low trust, how will that impact technology? First up, innovation requires that we share beyond our family & tribe. To quote another aphorism, a rising tide & all that. However, beyond innovation, we're likely to hit issues with maintenance. Will we have to put guards on power distribution stations, lest those stinkers over the hill come and take it? As trust fails, it's not just simple stuff like that mail that gets impacted. Same thing for replacement parts for the water pumps, etc., etc.. The tail on our supply chains is far too long for the process to work when the only ones we can trust are our family and village. If the village over the hill is out to get us, one UPS truck hijacking could put us without water, lights, or food. You could even see, within organizations as trust breaks down, that the admin team has it in for the developers who really aren't enamored with QA who... You get the picture.

Being officially now an old man (I turned 60 a couple of months ago), I've seen a lot of changes over the decades. I'm here to tell you, especially if you're pessimistic, that in my 60 years, things have improved. Everything (well, except the amount of free time I have) has improved since I was a child. Everything. On all fronts. While our current, and recent, times may seem to be slipping a bit, I'm pretty sure it's an aberation. We'll find the postal thief (and I'm sure it's only one person), or they'll get in trouble somewhere else (because people who tend to steal & do bad things, tend to steal & bad things all over the place) and we'll be able to go back to trusting people... only with a locking mailbox. I suspect similar things will happen over the next couple of years all over with technology. A dip in trust will increase our security, and trust will come back.

What do you think, increasing, decreasing or staying the same on trust?

Grant Fritchey

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

This article describes a simple technique that will allow you to use Flyway securely, even in cases where more than just the login credentials need to be protected. It uses a PowerShell technique that converts an encrypted Flyway configuration file into an array of parameters that Flyway can read just as if you were typing them in.

Despite the leaps in capabilities that "generative" chatbots like OpenAI's ChatGPT, Microsoft's Bing and Google's Bard have demonstrated, they still have a major flaw: They make stuff up all...

IT operations teams should work with IT service teams, data scientists, and machine learning experts doing the heavy lifting on the build side.

GPT4 and ELMAR are both artificial intelligence tools that help companies perform a number of important tasks. But which one is best for your business’s purposes? GPT4 is the...

There are several common causes of database corrup...

Buffer pool scans causing slow operations on large...

In this article, we walk through the process used ...

It's been almost a year since I blogged about anyt...

Finding and resolving blocking queries is an essential part of database administration, as blocked queries can cause significant performance issues and slow down query execution. The Database Health Monitor...

On May 24, 2023, Microsoft released SQL Server Management Studio 19.1. The release notes are here, and they include this item: SSMS 18.X cold startup performance is a big...

In this article, we look at a C Sharp application you can easily create to keep track of how much space your largest SQL Servers and databases are using.

Configuring parallel index operations in SQL Server can significantly impact query performance and scalability. During my popular service, we discuss. First appeared on Configuring Parallel Index Operations in SQL Server

This article contains several SQL scripts a DBA can use to manage and monitor SQL Server for current activity, blocking, and performance metrics.

Learn how to use the Binance API and Python to loa...

Azure Cosmos DB's Serverless option is a great way to save money if your application expects intermittent and unpredictable traffic with long idle times. I use serverless...

Are you using GitHub for managing your Stream Analytics project and looking to leverage GitHub's powerful CI/CD pipeline? Follow this comprehensive guide and learn to set up a CI/CD...

Have you ever wanted to build a REST API or GraphQL interface to your Azure SQL Database? Join Anna Hoffman and Data Platform MVP Joey D’Antoni to learn about...

This edition of Week in Review marks the end of th...

Here are five best practices that organizations of...

Your first speakers in the lineup for PASS Data Community Summit 2023 have been announced! Check out the full details for this year's Pre-Cons and Learning Pathways, and find out why some of our speakers are particularly excited for what’s in store this year. And don't forget - register before June 7 for a 30% saving on the rate.

In the first two webinars, we've discussed why PostgreSQL has become such a force in recent years and some of the main differences for SQL Server users to know. In this follow-up webinar, find out how to take your first steps using PostgreSQL. Join Ryan Booz, PostgreSQL Advocate at Redgate, and discover: The freely available options to help you get started The essential tools you will need when using PostgreSQL Some learning resources to help you take the next steps

In this article, I will focus on Microsoft Defende...

Real-world data often exhibits extreme skewness. I...

Let’s say we are in . Consider the maximization ...

Did you know that over 300 people die daily from drug overdoses in the US? As a pharmacist, I have witnessed the harrowing effects of substance use disorder (SUD)...

A unified data model allows businesses to make bet...

THE VIDEO THE SYNOPSIS In this video, we will learn why Venn diagrams are not good for describing join behavior. From there, we’ll learn exactly what Venn diagrams describe...

Learn how to add functionality to generate QR Codes from data stored in a SQL Server database and a web-based application.

Unlocking the power of geospatial data can give organizations a competitive edge, from optimizing supply chain logistics and enhancing customer experience to mitigating fraud and improving public health outcomes....

Using the bare minimum of parts and CircuitPython ...

Sebastian Staacks is using a couple of Picos to dr...

Canatee is a teacher using two Raspberry Pis to po...

John Hammond takes a look at this Raspberry Pi Mal...

Joe Scotto is using a Raspberry Pi Pico to power h...

In order to push his Amiga 1200 to the limits, Cla...

Prusa has unveiled a new alpha-stage firmware for ...

We don't know yet when or if these Predator brande...

Video by: Reid HavensLearn how to add Dynamic Format Strings for individual [DAX] measures in Power BI! This technique doesn’t require calculation groups or Tabular Editor either, and can...

“May you live in interesting times” – Chines...

The Dataflow in Microsoft Fabric is an element for...

Microsoft Fabric is an end-to-end data analytics s...

Maybe you've heard the announcement of Microsoft F...

Bringing the Data Platform Workspace and the Power Platform workspace Together Over the last 18 months or so I’ve been watching and supporting the development of Microsoft’s new Software...

Reading Time: 7 minutes In this post I want to cover spreading your Power BI wings with Microsoft Fabric. Since I covered Microsoft Fabric from a SQL Server...

You've heard about all the great things with Microsoft Fabric, but you don't see it in the portal. You only see the Power BI items and no persona switcher....

Microsoft Fabric, an end-to-end Saas cloud-based analytics platform, has many workloads and objects. One of the Objects is called Data Warehouse, or in short, Warehouse. In this article, I’ll...

Azure Data Explorer Bindings for Azure Functions (Public Preview)

Zone Redundant Storage (ZRS) for Azure Disks is now available on Azure Premium SSD and Standard SSD in Brazil South, UK South, East US, East US 2, and South-Central...

Azure Files has increased the root directory handle limit per share from 2,000 to 10,000 for standard and premium file shares.

Yesterday at Microsoft Build, a significant announcement took place—the introduction of Microsoft Fabric, which is now available for public preview. Satya Nadella, the CEO of Microsoft, went as far... The...

The invitation this month for #PGSqlPhriday comes ...

The host for PGSQL Phriday #009 is Dian Fay, who h...

Welcome to the second blog of the “magic of parameters” series. In the first entry, I covered memory parameters, and in this article. In this article will talk about PostgreSQL configuration parameters which manage the (auto)vacuum and (auto)analyze background processes.

I want to address a pressing question to many data...

This is part of a series I began in 2018, document...

A Little About Improving Modification Query Perfor...

A Little About How Overindexing Can Hurt SQL Server Performance Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training....

Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and talked out new feature. In this post we'll just take a brief look at it,... The...

One question that we hear quite often is why we chose to capitalize the first three letters when abbreviating this feature sometimes, and at other times, we chose not...

I had the opportunity to engage in a captivating discussion surrounding on database performance, security, and scalability as a DBA. First appeared on Balancing Performance, Security, and Scalability as a...

Over the last few months, I have received a number...

Jason Cockington digs into the two modes: Over the...

Student questions: How to compute the sales amount...

In this article, learn how to control access levels to various data and parts of Power BI reports using row-level security as well as column and object-level security.

The concept of tact is simple. Telling people truths, often harsh truths, without making it seem harsh. Hopefully, it is clear that being truthful is one of the more...

IT professionals can advance their careers by learning Linux, a widely used and versatile operating system.

To support and retain the people who protect assets against bad actors, organizations should create a more defensible environment.

Note: "Then & Now" (t&n) is a new version ...

It’s neither hard nor expensive: Unlike password...

A Trojan SDK snuck past Google Play protections to...

Tightening access controls and security clearance ...

A hacking group called Dark Pink targeted government agencies in countries including Indonesia and Thailand, using sophisticated malware and phishing emails.

As an IT admin, preventing your users from using s...

A student of mine sent me a T-SQL challenge involv...

QUOTENAME can be used to make sure database objects are valid in your query. Most of the time, objects like table names only contain valid characters, so there’s nothing...

Hi there, newbie. Are you still using multiple INSERT statements to insert multiple rows in SQL Server? Let me tell you today that it’s a terrible idea. It gives...

Bjørn Karmann has created a Raspberry Pi camera t...

Recently I got a message that my Evernote subscription was going up. It’s been a $3 a month service, but moving to $4 for me. From USD$35 to USD$50... The...

AI company CEOs and researchers issued another dire warning about the existential harms posed by the fast-developing technology. Critics, however, argue that focusing on hypothetical risks detracts from immediate...

We spent some time building in Fractal Design's ne...

By 2025, the drug discovery market is expected to reach $71 billion. While recent growth in the market was largely influenced by the COVID-19 pandemic and the need for vaccinations,...

It’s a Friday morning in early May, and I’ve woken up to the sound of waves crashing against the rocks in a small bay on the coast of the...

Learn about selecting file managers for Linux operating systems.

When you download SQL Server Management Studio 19....

This article demonstrates a cross-RDBMS way of searching through a set of SQL migration files, in the right order, to get a narrative summary of what changes were made,...

A customer asked about how they could organize their migration scripts in different ways to manage them and worried about it being complex. I decided to test a few... The...

I was working for Xerox when the Xerox Star, precursor to all the computer systems in use today, was introduced. Before then, computer users just had command-line or character-based GUIs. The Xerox Star workstations were displayed for the first time for us insiders in a special room, like a secular chapel, guarded over by the priesthood of developers. We were amazed.