Empathetic Design, Decoding SQL Server Wait Resources, SQL Server 2022 Log Growth Strategy, and Much More

Database Weekly for May 20, 2023 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 Feed]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -