How to visualize Python charts in Power BI Part 2 (2022-09-12)

SQLServerCentral Newsletter for September 12, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [How to visualize Python charts in Power BI Part 2]( - [Convert Problematic Data in SQL Server]( - [[Video] Fragmentation Explained in 20 Minutes at SQLBits]( - [From the SQL Server Central Blogs - SQLpassion Live Training about SQL Server Availability Groups]( - [From the SQL Server Central Blogs - How to keep up with technology]( Question of the Day - [Regenerating the Master Key]( The Voice of the DBA  Daily Coping Tip Forgive yourself when things go wrong I also have [a thread at SQLServerCentral]( dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from [The Action for Happiness Coping Calendar](. My items will be on [my blog](, feel free to share yours. The Challenge of Early Tech Decisions When we design software or databases, we have to make decisions right now. If you work as I have in many environments, this means I'm often picking a tool, platform, version, technology, or something else without a complete set of information. In some cases, I'm actually writing code (SQL or C#/Java/etc.) without completely knowing the business problem I'm solving.what someone described, but as many of us know, those descriptions often prove to be lacking. Over time, we refine the code with feedback from users, which is why DevOps has become so popular. We write the best code we can, making small changes and improvements, and then quickly alter code if we haven't hit the mark. However, changing the code is one thing. Changing more fundamental technology choices is harder. There is an interesting post on [the disproportionate impact of your early tech decisions]( from one of the developers at Stripe. One of the examples is of the database platform. which was Mongo. The piece notes that once the database platform is chosen, most groups never switch platforms. I think that's been true in many places I've worked. The same thing for languages and cloud providers as well, as once a choice is made, rarely does a team, much less an organization, switch. Why is this? Is the cost of switching that high? I think it is. I've seen a few organizations want to migrate from a licensed relational platform to one that is free and OSS. However, the time it takes to rewrite code, the time to build new expertise, learn the tips and tricks for a new database (or other platform technology) is significant. A team can make no shortage of mistakes during this process. Is that worth the cost of licensing? Perhaps. Perhaps not. It's a hard thing to decide. In many cases, I'd argue that core changes to your technology stack ought to be considered, but understanding that no tech will solve all your problems, and you will make lots of mistakes in the process of changing. Does this mean you need to make a great decision when you start working on a project? In my mind, no. Make the decision to use what your team is most familiar with and then live with it. And be open to using targeted technology for specific needs. Lots of transient data in a busy workload? Add Redis to your database stack. If you need full text search, consider ElasticSearch. Maybe add a graph database (not SQL Server) if you need queries in this problem domain. Use what works, and learn to use it well. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [How to visualize Python charts in Power BI Part 2]( Daniel Calbimonte from SQLServerCentral This article continues looking at python code in Power BI to produce charts. [External Article]( [Convert Problematic Data in SQL Server]( Additional Articles from MSSQLTips.com In this article, we look at various ways to convert problematic data in SQL Server by using TRY_CAST, TRY_CONVERT, and TRY_PARSE. [External Article]( [[Video] Fragmentation Explained in 20 Minutes at SQLBits]( Additional Articles from Brent Ozar Unlimited Blog What does fragmentation mean? How does it happen? Can you fix it with fill factor? Should you rebuild your indexes to fix it? [Blog Post]( From the SQL Server Central Blogs - [SQLpassion Live Training about SQL Server Availability Groups]( Klaus Aschenbrenner from Klaus Aschenbrenner On September 29, 2022 I will run an SQLpassion Live Training about SQL Server Availability Groups. High Availability with previous versions of SQL Server was always complex: you had... [Blog Post]( From the SQL Server Central Blogs - [How to keep up with technology]( James Serra from James Serra's Blog (Side note: There is a “subscribe” button on the right side of my home page if you wish to receive my blogs updates via email as soon as they...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Regenerating the Master Key I have a database encrypted with TDE. I want to regenerate the database master key and use the new key to protect the certificate. What should I do? 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) Log File Viewer Which of these logs cannot be accessed from the Log File Viewer in SSMS? Answer: All of these can be accessed by the Log File Viewer Explanation: All of these can be accessed. The full list from Docs is: - Audit Collection - Data Collection - Database Mail - Job History - Maintenance Plans - Remote Maintenance Plans - SQL Server - SQL Server Agent - Windows NT (These are Windows events that can also be accessed from Event Viewer.) Ref: Log File Viewer - [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 2017 - Administration [MDF size increasing without table size increase]( - We have a database whose data file size was 1500 GB and used space within the file was around 900 GB on Friday. Today when I checked, the file has grown to 5200 GB and it is growing continuously. When I did the breakup of table sizes, its still 920 GB, which is expected. How […] SQL Server 2017 - Development [SQL Server Agent running an SSIS package, and is unable to detect a file path!]( - Scenario:  An SSIS package needs to read a flat file and insert it into the host SQL server DB table. Flat file:  Sits in a file folder in windows OS, on another server (file server) the flat file manager uses UNC VS IDE:   The solution works from within the IDE. Service Account: […] SQL Server 2016 - Administration [Node quarantined status not cleared]( - Hi, Two node AG cluster nodes . one of the node went to quarantined state due to we had network issues multiple times. Quarantined state remain same more than 14 hours. Node status green color up & running also cluster resource online and AG role also running. I tried below PowerShell commands Get-Cluster | Format-List […] SQL Server 2016 - Development and T-SQL [Query for abnormal differences / find ouliers]( - Hi , I am trying to build a query that will identify 'abnormal' differences in the values column between each successive date record available for each individual account. The table will have multiple accounts and I want to identify the abnormal differences. The difference threshold to be identified is an absolute value of 80. thanks […] SQL Server 2019 - Administration [how to remove schemabinding from all functions and view in one go.]( - I want to remove the schema binding from all my functions, then want to apply but in one go, how can it be done? 2) I have few cols with columns in my database where collations is specified, i want to remove them in one go,  how both things can be done with few […] [last time index was re-org or rebuilt?]( - i'm unable to find such script online. i found some that had last stats updated but it's not the same thing i'm looking for. any ideas/suggestions? thx [ACCELERATED_DATABASE_RECOVERY and increase in database size]( - Hello , I am looking please for your feedback on the activation of "ACCELERATED_DATABASE_RECOVERY" In SQL server 2019 Especially on the size of the database because I'm worried if I see this SQL Server 2019 - Bug? Databases Auto Growing Out of Control Thanks [SQL on Virtual Machine]( - Hello Fellow Database Enthusiasts, I am an old guy and virtual machines are new to me, normally on a SQL server installation that you are going to have several or more instances running, you would have separate partitions that the instances are installed on, is that necessary on a VM machine running Windows server 2019? […] SQL Server 2019 - Development [Problem : Passing a Variable is not working in Dynamic Query]( - Hi all, I am not able to pass the table name as a constant in Dynamic Query: The logic is to loop through a list of tables name stored in a table 'tbl_names' and produce an output of tbl_name, row count My code is a follows: /* Table tbl_names has 3 column (id, tbl_name varchar […] [Unable to add NOT NULL constraint (Msg 102, Level 15, State 1)]( - Beginner here and trying to solve a problem from which I cannot find any clear solutions. I am supposed to alter a table. I am supposed to add two constraints, these being the addition of a primary key and the addition of a foreign key (Some_ID). However, Some_ID is NULL and I am supposed to […] [Pivot columns to get 0 /1 flag columns]( - Hi, I have a dataset of employees with different "Paytypes" in a single column. I am trying to pivot the table on the Paytype column so that each paytype can be treated as a flag column, i,e, the only possible values in this column should be 1 or 0 Below is a sample code with […] SQL Azure - Administration [Backup Logs in Azure SQL Database]( - We have multiple Azure SQL databases. Not managed instances or Azure VM's. For our ISO auditing requirements, this is the requirement: Backup configurations for databases holding critical information, including the notification settings and an example backup alert. Providing the configuration is easy. What is not so easy is the "notification settings and an example backup […] Amazon AWS and other cloud vendors [AWS Managed Grafana authentication]( - Hello. I have built a small project where I call Lambda which parses some data from a website with Selenium and then stores the results to RDS (Postgres). I'd like to visualize this data. It is timeseries data, so I would need something where I can drill down to a certain date, month, year... So […] Reporting Services [world map and errors loading map for VS 2022]( - [Updated 9/6/22] What is the easiest way to get a world map into the map gallery so that I can embed into my report? Also, Using Visual Studio 2022. Any map I load from the map gallery (US only maps there), I get an error when previewing the report: "An attempt was made to load […] General [What should I have done with this?]( - I received this in the mail today. Any thoughts?   [RSS Feed]([Twitter]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -