Power BI Auto Detect Relationship Failure (2024-03-08)

SQLServerCentral Newsletter for March 8, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Power BI Auto Detect Relationship Failure]( - [SSRS 2022 Install, Setup and Configuration]( - [From the SQL Server Central Blogs - SQLpassion Live Training about running SQL Server in Microsoft Azure]( - [From the SQL Server Central Blogs - 10 reasons why IT certifications are still important]( - [Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance]( Question of the Day - [A Big SmallDateTime]( The Voice of the DBA  Is This a Good DBA Job Description? I saw this on one of the syndicated SQL Server Central blogs: [Job Description of a DBA](. This is mostly a list of things, but it covers a lot of the general types of things that many of us expect a DBA to do. However, my question is whether you think this is a good description for a job opening. Would you ask someone to fill this list of things? Maybe a better question is whether you could use this to evaluate candidates, and how would you go about asking questions or gauging a fit based on this. Perhaps you should ask yourself how you evaluate others and if there is a good way to rate them against a list of daily tasks. To be fair, I know most job descriptions often include many "desires" along with "needs." That can be maddening to many job seekers, as they don't feel qualified. What I've found when building descriptions is that a wider variety of people provide input for what they would like in an employee than just the hiring manager. The hiring manager might weigh these items differently and accept someone who doesn't know replication well, even though replication is used if the candidate is skilled at query tuning. I would say expert, but how do you judge that? Most of us would probably settle for someone who can improve queries even just a little bit. When I interview people, I want to know a few things. One is can I get along with them, as well as the rest of the team. This isn't to discount technical skills, but we need to be a team. If we can't get along, and maybe more importantly, disagree civilly, it's hard to work together. We do need to bond, though that doesn't need to be over a drink or sporting event. However, we might need to share a meal, so I hope we can enjoy a conversation for an hour. The other thing is that I need to see some effort and desire to succeed. I don't need someone to be an expert, but I do need them to show an interest in helping our customers, whoever they are. Part of that is trying; part of that is getting to the end result. I see far too many people that don't try to solve problems or care that there is someone waiting on a solution. I also see too many people unwilling to try and improve the environment, whether that's a codebase or server configuration. They might be good at their jobs, but I like to associate with people who want to make the world better. People who think forward, who ask questions, who under-promise and over-deliver. I think the job description I linked above is a good one, fairly comprehensive in scope, but lacking in lots of details. The devil is often in the details, especially in how hard someone might work to complete these tasks, and if they would work to do so to meet their commitments, but also do so in a quality manner. And, of course, under pressure. Most of us know that things break, and when the thing is a database, a good DBA is invaluable in restoring service under pressure. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Power BI Auto Detect Relationship Failure]( farooqk.aziz from SQLServerCentral Power BI doesn't always detect relationships, and this article explains a bit about the problem. [External Article]( [SSRS 2022 Install, Setup and Configuration]( Additional Articles from MSSQLTips.com This article includes all of the steps you need to take to install and configure SQL Server Reporting Services 2022. [Blog Post]( From the SQL Server Central Blogs - [SQLpassion Live Training about running SQL Server in Microsoft Azure]( Klaus Aschenbrenner from Klaus Aschenbrenner From April 24 – 25, 2024 I will run a brand-new SQLpassion Live Training about Design, Deploy, and Optimize SQL Server on Microsoft Azure. Unlock the power of Microsoft... [Blog Post]( From the SQL Server Central Blogs - [10 reasons why IT certifications are still important]( KamilN78 from Azure Player Blog As someone who has spent over 20 years in the Software/Data Engineering area and has obtained numerous certifications, I can confidently say that certifications are still a valuable asset... [Practical Database Auditing for Microsoft SQL Server and Azure SQL]( [Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance]( Site Owners from SQLServerCentral Know how to track changes and key events in your SQL Server databases in support of application troubleshooting, regulatory compliance, and governance. This book shows how to use key features in SQL Server ,such as SQL Server Audit and Extended Events, to track schema changes, permission changes, and changes to your data. You’ll even learn how to track queries run against specific tables in a database. ss   Question of the Day Today's question (by Steve Jones - SSC Editor):  A Big SmallDateTime What is the maximum year for a smalldatetime datatype? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) Avoiding Exchange Operators Which type of query processing mode can operate on compressed data and avoid the exchange operator? Answer: Batch mode Explanation: Batch mode can operate on compressed data and avoid the exchange operator used in row mode. Ref: Query Processing Architecture - [ [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2016 - Administration [system_health configuration]( - I'm on SQL Server 2016 (SP2-CU11-GDR) (KB4535706) - 13.0.5622.0 (X64) Dec 15 2019 08:03:11 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 R2 Standard 6.3 (Build 9600: ) (Hypervisor) Is there a way to change the lock timeout in System_Health GUI? In the u_table.sql it looks like it's seto […] SQL Server 2012 - T-SQL [row changes per hour by TagID]( - I have a large table being written too every second with equipment (PLC) information. I need to figure out how much of this data is redundant using an hour window, so from 7am-8am how many different values did I capture per Tagid(Machine). I'm trying to figure out for floatvalue how many distinct values where recorded […] [row changes per hour by TagID]( - I have a large table being written too every second with equipment (PLC) information. I need to figure out how much of this data is redundant using an hour window, so from 7am-8am how many different values did I capture per Tagid(Machine). I'm trying to figure out for floatvalue how many distinct values where recorded […] SQL Server 2019 - Administration [Can CDC replicate data?]( - As far as I can tell all CDC does is capture and log data changes, can it also replicate like transactional replication? [Linked Server Connection Issue]( - Hi all, I have 2 SQL servers on different domains (lets call them SQL-A and SQL-B), network connected via IPSEC vpn. DNS is not yet set up between the two networks, so I have amended the hosts file on SQL-A. On the machine running SQL-A, I can use SSMS to connect to SQL-B successfully. I […] [High availability group synchronization]( - For high availability group, is there an option like transaction log shipping that I can choose the interval of time to synchronize the database. So for example ,  delay it to 30 minutes to synchronize. Thanks   SQL Server 2019 - Development [Sending messages on table rows updates/inserts/deletes to RabbitMQ from SQL Srvr]( - We have a requirement here. Whenever certain rows in a table are inserted, updated or deleted, we need to send messages to a message broker for further processing. Currently we are using triggers and SQL Server Service Broker for this purpose. But we want to use RabbitMQ for scalability and wider reach. Is there a […] [Indexing strategy very long text strings]( - Hey guys, Just looking to see if anyone has any bright ideas how to solve this problem. Background I have been handed down a project to report on files that have gone 'missing'.. Ignoring the fact that are using the wrong tools for the job... I have a process which effectively writes the resutlts of […] [Frustrated trying to get Cross DB Access by Signing SP with Certificate]( - Maybe it is lack of caffeine, but I cannot see why the following test code does not work. I keep getting: Msg 916, Level 14, State 2, Procedure dbo.TestTrunc, Line 7 [Batch Start Line 92] The server principal "XDBSignTest" is not able to access the database "db2" under the current security context. Can anyone see […] [SSIS Execute Package Fail in SSMS but Agent Job Succeeds]( - Hello, I created a SSIS package to transfer data from an XML file to a database in SQL Server instance A. It works perfectly in Visual Studio. Then the SSIS package was deployed to SQL Server instance B. When I set up a SQL agent job and run as a proxy user "svcSSIS", it works […] Integration Services [Not picking up a specific period]( - Please assist. I am trying to bring in Period 8 which i find myself in. Its available in the data. I just cant seem to bring it into the ETL. Source and SSIS is attached. Business Intelligence [How to merge first 3 rows when exporting to excel]( - Hi All, I have a report when I export to excel must auto merge first 3 rows for columns (A to N), when the user opens the report , instead of the user doing it manually, is this possible. Please see the below screen shot. After exporting I manually did merge and center and named […] [How to merge first 3 rows when exporting to excel]( - Hi All, I have a report when I export to excel must auto merge first 3 rows for columns (A to N), when the user opens the report , instead of the user doing it manually, is this possible. Please see the below screen shot. After exporting I manually did merge and center and named […] [How to merge first 3 rows when exporting to excel]( - Hi All, I have a report when I export to excel must auto merge first 3 rows for columns (A to N), when the user opens the report , instead of the user doing it manually, is this possible. Please see the below screen shot. After exporting I manually did merge and center and named […] SQL Server 2022 - Administration [SQL Server UCP]( - Hello everybody, I just read on the Microsoft homepage that SQL Server Utility Control Point is still available in SQL Server 2022 Entertrise Edition (. I couldn't find it in the SSMS what so ever.   [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. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -