The Voice of the Customer (2024-01-20 DBW)

Database Weekly for January 20, 2024 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  The Voice of the Customer This week I had the opportunity to join many of the U.S.-based Redgaters in Austin to talk about 2024 plans, hear from the product teams, and have some much-needed fellowship. One thing was particularly clear as I listened to various leaders and product managers – the customer drives everything we do. And I have to be honest, it was really encouraging to hear how much the work that our teams do is influenced by real customers, with real needs, trying to solve real problems. Maybe your company or team are having similar meetings and conversations,too. Although I certainly enjoyed hearing what the teams were planning to bring to our amazing line of Database DevOps applications, I actually enjoyed the second day of meetings more than hearing about product updates. (ok, it’s almost a tie, but still…) For day two, we had a separate room for each product team, and the rest of us went from room to room in groups. It was here that we got to talk about customer journeys, their specific pain points and challenges managing their database estates and development. The goal was to help newer employees, and even some veterans, listen better as we support our users. Too often, it’s easy to jump to assumptions about what will solve a specific need, which usually means that it can take longer to solve their problem. We were able to hear, firsthand, how the support teams and product teams guide a conversation to really draw out the underlying causes, not just the symptoms. Having been in the software business for more than 20 years, I usually think I've learned how to listen to users and knowing how to help steer them to a solution. But I learned, sitting in those rooms, that there’s always something that everyone on the team can do to improve in this area. I’m flying home today, excited to engage even more with our users and the community, so that I can continue to learn more. What about you? Do you have a forum and training opportunities to improve your listening skills, particularly with your users? Depending on your specific job, these may be internal users, one-off consulting clients, or millions of external users for your SaaS application. If not, what can you do to influence change in getting this type of feedback? If talking with customers is a regular part of your job, what tips do you have to help others improve? It’s the start of a new year. Take some time to listen and learn to the users and communities that you’re a part of. I promise it will be a valuable experience. Ryan Booz [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 [Testing Databases: What’s Required?]( An overview of the challenges of database testing and test data management, reviewing the different types of database test that need to run during development work, what sort of test data they require, and how to manage all the required data sets, during development, in a way that allows rapid cycles of parallel testing. [Better Database Development: The Role of Test Data Management]( Any organization that aims for reliable, online deployment of database changes needs a Test Data Management (TDM) strategy that allows developers to test the database early, thoroughly, and repeatedly, with the right test data. The benefits include more resilient database deployments, fewer bugs, and shorter lead time for changes. [Automated Provisioning of Multi-Database Environments in a Flyway Development]( This article describes how we implemented lightweight database provisioning, using clones, within an automated Flyway release process . It allows users to self-serve personal copies of a complex multi-database system, in a way that is transparent, supports flexible workflows and agile releases, but does not compromise data security nor add significant admin overhead. .NET Related Articles [Using Spark Connect from .NET]( From AgileSQL - Ed Elliot Introductory Ramble Spark Connect In July 2022, at the Data and AI summit, Apache Spark announced “Spark Connect,” which was a way of connecting to Apache Spark using the... AI/Machine Learning/Cognitive Services [I Actually Chatted with ChatGPT]( From O'Reilly Radar - Insight ChatGPT was released just over a year ago (at the ... Administration of SQL Server [The Problem with Automatic Plan Correction]( From Curated SQL Kendra Little lays it out: I’ve written a bit about SQL Server’s Automatic Plan Correction feature before– I have an hour long free course with demos on Automatic… [sp_QuickieStore: Find Your Worst Performing Queries During Working Hours]( From Erik Darling Data sp_QuickieStore: Find Your Worst Performing Queries During Working Hours Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love... Azure SQL [Cross-Database Sync in Azure SQL Database]( From Curated SQL Jose Manuel Jurado Diaz goes through a lot of work to replicate replication: This week, we addressed a service request from a customer who wanted… Backup and Recovery [How to use Cloudflare R2 for SQL Server backups]( From SQLSunday R2 is Cloudflare’s own implementation of AWS S3 storage, with some big benefits – one of them being no egress fees, which is great if you want to publish... Community Interests [T-SQL Tuesday 170 Roundup]( From Curated SQL Reitse Eskens writes up a roundup about abandoned projects: When I thought of this subject last year, I was really on the fence if it… DMO/SMO/Powershell [Handling Orphaned SQL Database Files across the Estate with DBATools... the Pie-eyed Piper.]( From SQL Rod This may be an edge case issue, it may not. Or so... Database Design, Theory and Development [The Importance of Retention]( From Simple Talk It is always an afterthought. New objects are created that start off small and current. New feature development takes over and the recently architected data structures become old news.... Editorial [What Counts for a DBA: Preparation]( While preparing for this career as an editor, my mind went to the joys of sitting at a computer editing documents. I expected this to include checking articles for technical accuracy, and proper English, formatting documents to meet the website standard, and posting the documents. I just knew that many of the firefighting skills I needed when doing administration and deployment duties would be gone. MDX/DAX [Using tuple syntax in DAX expressions]( From SQLBI This article describes the use of the tuple syntax in DAX expressions to simplify comparisons involving two or more columns. The DAX language has a tuple syntax commonly used... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [How to grant individual users access to create Fabric items/workloads]( From FourMoo I was recently working with a customer where I was... Oracle/PostgreSQL/MySQL/other RDBMS [Hash Aggregates and Hash Joins in Postgres]( From Curated SQL Muhammad Ali plays matchmaker: PostgreSQL employs various techniques for data joining and aggregation in its queries, among which the hash-based method stands out for its… PowerPivot/PowerQuery/PowerBI [SQL Endpoints and Lakehouse UI Differences and Access Secrets]( There are some differences and secrets between the UI of a SQL Endpoint and the UI of a Lakehouse. I believe the lakehouse UI was changed recently, otherwise you can blame me for being distracted to this level. Let’s analyze the differences and pending points between these UI’s. [Understanding Blocking And Waiting In Power BI Import Mode Refreshes]( From Chris Webb's BI Blog Following on from my previous post showing how you... [What is Power BI Direct Lake Mode in Microsoft Fabric?]( From MSSQL Tips In this tip, we explain how Direct Lake mode works... [Creative Thinking in Fabric & Power BI]( From PowerBI Tips In podcast #286 we take the time to review an older video of John Cleese giving a talk about the Creative Process in Management. We thought this would be... [Extracting Power BI Import Mode Job Graph Data To A Table]( From Chris Webb's BI Blog In my last post but one I showed how you could create a DGML file that contains detailed information on what happens during a Power BI Import mode refresh... R Language [Data Reading and Writing with arrow]( From Curated SQL Colin Gillespie performs two of the three R’s: Apache Arrow is a cross-language development platform for in-memory data. As it’s in-memory (as opposed to data stored… T-SQL and Query Languages [Exporting and Importing Data into SQL Server Using Files]( There are plenty of applications and tools available that allow for the movement of data in and out of SQL Server. Some tools are built by Microsoft, such as SSIS or Azure Data Factory. Others are created by third parties, such as Databricks or Snowflake. Still other available options make use of SQL Server features and rely on our own ability to write efficient code to get data from point A to point B. [NEXT VALUE FOR and ROWCOUNT]( From Curated SQL Jose Manuel Jurado Diaz diagnoses a problem: In the realm of SQL Server, certain combinations of commands and functions can lead to unexpected conflicts and… [The Power of Schema Binding]( From Curated SQL Guy Glantser explains what schema binding is and why it’s important: In SQL Server, when we use the “WITH SCHEMABINDING” clause in the definition of… [What Does ANSI_NULLS Do?]( From Callihan Data Have you ever seen ANSI_NULLS being set to ON or OFF in a script or stored procedure? I’ve seen or heard it mentioned a few times recently and thought... Tech News [Watch this robot cook shrimp and clean autonomously]( From Technology Review Feed - Tech Review Top Stories Sophisticated robots don’t have to cost a fortun... [How hot salt could transform nuclear power]( From Technology Review Feed - Tech Review Top Stories For more than a month in total, 12 metric tons of molten salt coursed through pipes at Kairos Power in Albuquerque, New Mexico. The company is developing a new... [Best Practice Tip #1: Beware of Best Practices]( From SQLServerCentral Blogs Best Practice Tip #1: Beware of Best Practices It may sound contractionary that the first item of a best practices list is to be wary of... The post Best Practice Tip... [Apple to Cut Blood Oxygen Feature from Newly-Sold Apple Watches in the U.S.]( From AnAndTech Following the latest legal defeat in Apple's ongoing patent infringement fight over blood oxygen sensors, the company is set to remove its blood oxygen measurement feature from its Watch... Testing Software [We’re Starting to Automate Testing for the First Responder Kit.]( From Brent Ozar Unlimited Brent says: It’s really funny how the world work...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -