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
 

Empathetic Design

An old sport saying goes like this “I could beat them with one arm tied behind my back.” Well, after six weeks with my arm in a sling, I am in awe of whoever tries that because everything is a lot harder. Like washing your hand and then drying it, becomes more of a challenge than it once was for many reasons. For example, paper towel holders that require two hands.

Let me tell you, someone calculated the tension on those towel holders to the strength of two hands pulling on that flimsy paper towel. A one-hand pull generally means you get a very tiny piece of paper towel. There is generally a wheel that will let you advance the paper, but only some machines remind you of that.

Oh, and don’t try to get lunch at a buffet alone one-handed unless you are in the mood to create comedy.

If being down an arm complicates one's life, try being down a leg. Navigating the real world using a wheelchair or scooter will give you a brief, yet eye-opening, taste of what their users go through. If my childhood dream of being an architect magically came true today, the facilities I would design would be vastly different than before these recent experiences.

Dealing with these temporary physical setbacks reminded me of how inaccessible the world can be at times. Recently I was editing Phil Factor’s recent editorial Xerox Stars For Accessibility, and I realized that a lot of these issues were probably due to a lack of empathy. When software designers test software, do they know what their basic users go through?

One immediate example comes to mind. At every car dealer service center I have visited, before they hand my keys back after a pre-paid, packaged service call, the person at the desks types so much that I honestly wonder if they are writing a sequel to War and Peace on company time.

Did the software writer ever have to sit down and do that job for a living? Probably not. What about for a day? And what if the person doing this job has any physical challenges, either temporary or permanent? Obviously, certain parts of what they were typing needs to be manually typed. A lot of problems with a vehicle need to be captured in the customer’s words. But not enough for one to have to stand there for 5 minutes being serenaded by the typing of a physical keyboard.

So, when building software, consider the range of possible users of that software in the coming years. Put yourself in their place. And then put people of all abilities in their position too. Not every ability deficit can be predicted or handled in every piece of software, but far more than we tend to handle, even in 2023.

Louis Davidson (@drsql)

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

Flyway and SSDT: Merging Work from a Branch

In an SSDT-Flyway hybrid development, the required database changes may be delivered as a DACPAC, but we get far more control over merge operations and deployments if they are done using Flyway migrations. This article demonstrates how to automate as much as possible of the work required to extract a Flyway-compatible migration script from a DACPAC.

AI/Machine Learning/Cognitive Services

5 Takeaways from IBM Think 2023: Generative AI to Hybrid Cloud

From Past News - RSS Feeds

Last week IBM held its annual Think event in Orlando, FL. The venue was near “Islands of Adventure,” which I felt was an interesting backdrop as corporate IT has...

Administration of SQL Server

Script to Decode SQL Server Locking and Blocking Wait Resources

From MSSQL Tips

This article provides SQL code to determine what f...

Changing log growth strategy in SQL Server 2022

From SQLBlog.org

I discuss my roller coaster of emotions since lear...

SQL SERVER 2022 – Parameter Sensitive Plan Optimization (PSPO)

From Journey to SQL Authority with Pinal Dave

SQL Server 2022 introduces an exciting new feature...

Restore One Backup From Many in a Device–#SQLNewBlogger

From SQLServerCentral Blogs

I wrote recently about finding multiple backups in a file. This post looks at how to restore one of those. The one you choose. Another post for me that... The...

Azure SQL

Plan your journey to Azure SQL with confidence

From Azure SQL

Overview Azure SQL offers both Platform-as-a-Servi...

Cloud - Azure

Public preview: Optimize your workloads for reliability using new workbook template in Azure Advisor

From Azure Updates

Evaluate the reliability posture of your workloads...

Azure Container Storage Now Available in Public Preview

From Petri IT Knowledgebase

Microsoft has announced the release of its Azure C...

Export capability (CETAS) for Data Virtualization in Azure SQL Managed Instance generally available

From Azure SQL

[Edit: CETAS demo video.]The familiar concept of D...

Community Interests

As AI Changes Jobs, Italy Is Trying To Help Workers Retrain

From IT Pro - Microsoft Windows Information, Solutions, Tools

As AI transforms jobs and workers fear for their future, Italy plans on putting some $10 million into improving the digital skills of people whose jobs are at high...

The Download: preserving digital lives, and more sensitive prostheses

From Technology Review Feed - Tech Review Top Stories

This is today’s edition of The Download, our weekday newsletter that provides a daily dose of what’s going on in the world of technology. Your digital life isn’t as permanent as...

Conferences, Classes, Events, and Webinars

PASS Data Community Summit 2023

Preparations for Summit 2023 are in full swing! Be the first to hear about the pre-cons and learning pathways, as well as future announcements and news. Join the mailing list!

PostgreSQL 101: The 10 key differences between SQL Server & PostgreSQL

Join us for the second webinar in our PostgreSQL 101 series. As a SQL Server developer or DBA, you have a broad skill set and have become accustomed to interacting with the larger #SQLFamily community. Now, by choice or necessity you've begun to explore PostgreSQL and things feel oddly familiar and foreign at the same time. Join Ryan Booze on May 25th to find out the things that often trip up SQL Server users when they first start exploring PostgreSQL.

Data Visualisation

"It's dreadful, right?"

From Storytelling with Data

People periodically tag me in social media or send...

Data Warehousing

Data Explainability: The Counterpart to Model Explainability

From Dataversity

Today, AI and ML are everywhere. Whether it’s ...

Hardware

New Tool Offers Life After Windows BSOD

From Tom's Hardware US

A BSOD isn't necessarily the end, as you can conti...

Microsoft News

M365 Changelog: Microsoft Teams – A new default home screen and an enhanced custom background feature for Teams Rooms on Windows

From Petri IT Knowledgebase

MC556772 – The latest version of Teams Rooms on ...

Oracle/PostgreSQL/MySQL/other RDBMS

Importing data into a MySQL database using LOAD DATA

Database and development teams often load data from plain text files into their MySQL databases. To help with the import process, MySQL provides the LOAD DATA statement, which reads rows from a text file and inserts them into the target table.

PowerPivot/PowerQuery/PowerBI

The Hidden Impact of Keys in Your Power BI Data Model

From Data – Marc

Another blog post based on recent client experienc...

Are you using your licenses correct? See where Azure Hybrid Benefits can help!

From Guy in a Cube

If you are moving your on-premises SQL Servers to ...

Multiple Relationships on the same Table in a Power BI Data Model

From MSSQL Tips

This article will cover how to create multiple relationships between the same tables in Power BI to build the data model you need.

What does Tooltip Auto-scale actually do in your Power BI Report?

From Guy in a Cube

Is your tooltip going off the page of your Power B...

SQL Server News

It’s Been 6 Months. SQL Server 2022 Still Isn’t Ready Yet. (Updated)

From Brent Ozar Unlimited

Six months ago today, Microsoft announced that SQL...

SQL Server on Linux

SLES 15 SP4 is now supported for SQL Server 2022 starting Cumulative Update 4

From MS SQL Server Blog

We are pleased to announce the support for SQL Ser...

Security News and Issues

Why Are IT Professionals Keeping Quiet About Data Breaches?

From IT Pro - Microsoft Windows Information, Solutions, Tools

A new study showed that nearly half of IT professi...

3 Ways Hackers Use ChatGPT to Cause Security Headaches

From Dark Reading: Dark Reading News Analysis

As ChatGPT adoption grows, the industry needs to proceed with caution. Here's why.

Microsoft is Caught Scanning Password-Protected Zip Files on SharePoint Online

From Petri IT Knowledgebase

Microsoft has been caught scanning for malware in ...

Security Risks of New .zip and .mov Domains

From Schneier on Security

Researchers are worried about Google’s .zip and .mov domains, because they are confusing. Mistaking a URL for a filename could be a security vulnerability.

T-SQL and Query Languages

Lesson Learned #351: Troubleshooting FullText issues

From Azure Database Support Blog

Today, we got a new service request where our cust...

What Does the NTILE Function Do?

From Callihan Data

Have you ever used the NTILE function? Or have you...

Many Uses of SQL CASE Expression in a JOIN Clause

From MSSQL Tips

In this article, we look at the many uses of the S...

Move your ledger history table to a different filegroup

From Azure SQL

This article will guide you through the steps to m...

Why Are There Gaps in the Identity Column in My SQL Database?

From Purple Frog Systems

All too often there are questions asked about miss...

How to find UDT on SQL Server columns?

From SQLServer-DBA.Com

How to find UDT in SQL Server?How to check user-de...

The Lighter Side

Leveling Up for Sales and Marketing

From SQLServerCentral Blogs

I’m heading to Austin today for Redgate’s inte...

Theory and Design

Why Good Data Management Matters Now More Than Ever

From Dataversity

In the early days of business analysis and underwriting, data was managed with simply a pen and paper and, of course, Excel spreadsheets. As technology has advanced, databases, warehouses,...

Tools for Dev (SSMS, ADS, VS, etc.)

What's new in SQL Server Data Tools (SSDT) | Data Exposed

From Azure SQL

The latest version of SQL Server Data Tools (SSDT) [Version 17.6 GA] was released in May 2023. In this episode of Data Exposed with Anna Hoffman and Subhojit Basak,...

 
RSS FeedTwitter
This email has been sent to {email}. 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

 

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