Infographic Designer Visuals in Power BI (2022-07-25)

SQLServerCentral Newsletter for July 25, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Infographic Designer Visuals in Power BI]( - [Summarizing data using GROUP BY and HAVING clauses]( - [Query SQL Server with Python and Pandas]( - [From the SQL Server Central Blogs - T-SQL Tuesday #152 – The crazy login client]( - [From the SQL Server Central Blogs - New Database Job – The 90 Day Plan]( Question of the Day - [Developer Permissions]( The Voice of the DBA  Daily Coping Tip Take a few minutes outside to breathe and enjoy nature 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. AI Ethics I found [this article]( to be an interesting look at how we might add ethics to AI systems in one area. As the article points out, "... today there is no broadly accepted AI ethics framework, or means to enforce it. Clearly, ethical AI is a broad topic ...". Glad someone is thinking, or many people are, but sad that we aren't really moving in a direction that creates a better system for us humans to work under, or be bound by. To be fair, I do think this is a very difficult topic and hard for any large group of people to agree on what should be done. Network monitoring is a fairly narrow problem domain, at least compared to many others. The article notes there are places where AI can, and does help humans that work in computer networking. That being said, how does the AI handle ethical considerations. For example, can we ensure the AI handles data privacy appropriately. This could be in compliance with some regulation like GDPR. It could also be in a manner that doesn't disclose data inside a company to other systems or humans who shouldn't see the specifics of network traffic (like passwords, credit cards, or any sensitive information). There are also other considerations. While we see bias in AI systems trained on previous human behaviors, because humans are biased, will network AIs similarly have bias? Will they be less helpful for power users, who have a wide variety of traffic? Those are often privileged users, who might benefit the most from helpful monitoring. Will AIs discriminate against a user when another humans trains or influences it against them? A crude example might be a network admin that doesn't like women. They enforce more strict rules against women, and influence the AI to do the same. How will the AI, or others, detect this type of issue? Maybe the most difficult thing with AI is with corner cases. The ethical dilemmas that might not be easy to solve can confound an AI. Maybe the most ethical choice here is to seek other counsel or let other people help make a decision. To be fair, this is hard for humans to do as well, but for some reason we seem to trust computers less. At least some of us do. Ethics is a challenging issue. I find it to be difficult as a human, and my own inconsistency means I might react different at different times or in different places. How we translate that to AI systems, which are increasingly a part of our world, is going to be hard. I don't have answers, but I lean towards transparency, accountability from the humans in charge, and the ability to reverse (and apologize for), poor decisions. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Infographic Designer Visuals in Power BI]( Daniel Calbimonte from SQLServerCentral Learn how you can make your visuals more interesting with the Infographic Designer Visual. [External Article]( [Summarizing data using GROUP BY and HAVING clauses]( Additional Articles from SimpleTalk You can summarize data to get counts, averages, sums, and more using GROUP BY in T-SQL queries. Greg Larsen shows you how. [Technical Article]( [Query SQL Server with Python and Pandas]( Additional Articles from SQLServerCentral In this article, we examine how to read SQL Server data and parse it directly into a dataframe and perform operations on the data using Python and Pandas. [Blog Post]( From the SQL Server Central Blogs - [T-SQL Tuesday #152 – The crazy login client]( Diligentdba 46159 from Mala's Data Blog This month’s T-SQL Tuesday is hosted by Deborah Melkin(b|t), and she has an interesting topic. She wants us to write a rant on a scenario we encountered at a... [Blog Post]( From the SQL Server Central Blogs - [New Database Job – The 90 Day Plan]( Tracy Boggiano from Database Superhero’s Blog In my first post, I reference that by the end of your first 30 days you should have a 90-day plan of things to tackle at your job and...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Developer Permissions I have created a new database on a development server and added the user, JoeUser, as a user in this database. This user has no rights other than to connect to the database. I then execute this code: CREATE SCHEMA Dev GO GRANT CONTROL ON SCHEMA::Dev TO JoeUser GO GRANT CREATE TABLE TO JoeUser JoeUser then connects and runs this code: CREATE TABLE Dev.MyTable (myid INT) What can JoeUser run successfully on this table? 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) Quantums The time a worker can remain active in a scheduler is called the OS quantum. What is the maximum length of time for a quantum? Answer: 4ms Explanation: The maximum is 4ms. Not sure that matters to any of us, but it's an interesting trivia question. Ref: SQL Server task scheduling - [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 [limit parsing a XML -datafield from one server to the CMS using Powershell]( - Guys, I do need some help on a limit parsing a XML -datafield from one server to the CMS using Powershell --------------------------------------------------------------- I registered some servers in a folder in the CMS (SSMS). On each server there is a DBA-database holding the XML_REPORT table and a Stored-Procedure (which generates a XML-report). On the CMS itself […] SQL Server 2016 - Administration [TDE: Database Encryption key to be changed from 128 bit to 256 bit encryption]( - Hello, I was asked to apply TDE using 128-bit encryption initially. Later on, the new requirement governs to change that to 256-bit encryption. Without dropping the DB encryption key, can we change that from 128 bit to 256 bit encryption? Thanks Sourav [Query to remove all databases from AG]( - As part of DR we need to remove all the databases from different AG's , each AG is consists of 20+ databases , i need a query to generate script for removing all databases with respect to specific AG group , .  Thanks,. SQL Server 2016 - Development and T-SQL [pull data every 3 hrs]( - I'm trying to pull data every 3hrs between 2 dates. I need to just get one record for each machine every 3rd hour between two dates. I have this query which reports back midnight the day before thru today, but I'm looking for a single CREATE TABLE [dbo].[mach_data]( [dtstamp] [datetime] NOT NULL, [equipment_id] [varchar](6) NOT […] [Help Understanding A SQL Script]( - Hello Community, I am trying to implement a SQL Script from this link, and pasted below --================================================================================================= -- DESCRIPTION --================================================================================================= -- The purpose of this script is to create a set of database views in a database within your Synapse Analytics Serverless SQL Pool that will -- translate numeric codes for Option Sets, Status and […] Administration - SQL Server 2014 [Sudden rise in memory]( - Hi How i can check which process was run that Sql memory suddenly increased. Thanks Development - SQL Server 2014 [SSRS Rendering format Excel Change ?]( - I was wondering if anyone knew how I can change the Excel rendering format in the reportserverconfig file so the default cell format is text and not General. If not, is there any way to format my fields in the stored procedure so when I download to Excel it formats as text? Thanks SQL 2012 - General [Urgent help needed. MS SQL Server 2012]( - Hi, I've just got a call (6pm on a Friday!) from a customer who has had his line-of-business application provider sell him a solution which required SQL Server 2012 Standard, yet the supplier (joyfully) installed the evaluation version of SQL Server 2012 Enterprise. This has now ticked over and expired. My problem is that (a) […] [Merge Replication or Back up and Restore]( - Hello I have a database copied on two servers. Same name. I have tried a merge replication but it keeps failing on various objects. I have removed objects one by one and left with the bare minimum tables and still won't work. Users won't mind using one database as master and do all the updates […] SQL Server 2019 - Administration [Extending High Availability Group into Azure]( - Hi I've been asked to extend a HAG which is currently on premise to include an azure vm sql instance. currently i have a 3 node cluster, two nodes in on city with synchronous connect and auto failover and one in another city with asynchronous connect and manual failover. I want to add an azure […] SQL Server 2019 - Development [Parse SQL data]( - Below is the test data. What I am looking for is... I want to PARSE any value starting with PD- from the description column. Below is sample data. However, it could be possible the "Description" column could have n number PD id in the column, not restricted to any numbers. Any advice would be highly […] General Cloud Computing Questions [Client doesn’t want to run discovery agent, what are the options ?]( - Trying to assess client on-Prem servers for a cloud migration. We usually run a discovery tool that runs an agent to capture high level server info (OS/ Softwares/CPU etc…). I’m trying to think out of the box solutions. Maybe ask him to run his on script to capture all data or deep dive session to […] Integration Services [Replace function in SSIS Expression]( - hi, I have files that are coming in .txt files. Example MA.textfile1.txt ,MA.textfile2.TXT . I need to replace the file name after i process these files. I have a foreach loop to get the file names , and file system task to rename files. However i have set up variables within file system task, if […] Suggestions [Add a resolution flag that can be set by the OP]( - Something like the following. Thanks! Anything that is NOT about SQL! [Web site font colour/background colour and readability]( - Hi everyone I'm just interested in getting peoples about the readability of many web sites as far as the general words in sentences (not headings). Maybe it's my imagination, but it seems to me that there seems to be a tendency for there to be a lack of contrast these days between the font colour […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -