Explaining Explainable AI (2022-11-12 DBW)

Database Weekly for November 12, 2022 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  Practical IOT A lot of the IoT devices that make the news are consumer ones, many of which can feel silly and trivial to many of us. How many of us find a lot of value in [toasters](, [cat litter boxes](, or [deodorant](? Even light bulbs feel slightly silly to me as I don't know I've every been concerned about switching a light that I couldn't get to physically in my house. Then again, I don't try to set up [holiday light displays](. In the last few years, however, I've seen some interesting talks on how more business or government IOT devices have really changed a number of businesses. The ones I've found that give me hope for a better future are often local government initiatives where the investments and changes are in gathering data from sensors and using those to service citizens. This week I ran across an article about how the [city of Phoenix, AZ in the US is using IoT to improve livability](. If you have never been to Phoenix, it's in the desert, and it gets hot. So hot that you can burn your feet walking around barefoot. Sometimes it's not enough to literally cook an egg on a paved surface. One experiment they ran used sensors to measure how different surfaces held heat, and they used the results to try and manufacture tarmac materials that would lower the temperatures. Still hot, but less dangerously so. They have also implemented drones for us in search and rescue as well as fire operations. This is the type of device that can literally save lives and prevent costly damages. The use of technology and IoT is something that has the potential to bring about better service, often in ways that weren't possible in the past. I like that there are people using innovative ideas and products to improve the world. Hopefully we see more of this in the future as more people realize the power of data and the availability of it from new types of sensors and devices. Steve Jones - SSC Editor [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 Enterprise is here....](  [Introducing the MySQL UPDATE statement]( In the previous two articles in this series, you learned about SELECT and INSERT, two important data manipulation language (DML) statements in MySQL. In this article, I focus on the UPDATE statement, another valuable DML statement in MySQL. AI/Machine Learning/Cognitive Services [Explaining Explainable AI]( From Dataversity As more industries leverage artificial intelligence to support vertical-specific operations, many without experience in managing a virtual agent may soon do so. Just last year, for example, investment in... [Where will AI go next?]( From Technology Review Feed - Tech Review Top Stories To receive The Algorithm newsletter in your inbox every Monday, sign up here. Welcome to the Algorithm! This year we’ve seen a dizzying number of breakthroughs in generative AI, from... Administration of SQL Server [Getting Error 666 when creating non-clustered index- Msg 666, Level 16, State 2, Line 25]( From Azure Database Support Blog Issue A backend compatibility issue was encountere... [What are SQL Server Index Fragmentation and Index Fill Factor?]( From Purple Frog Systems What is index fragmentation and how does it occur? It is important to know that SQL Server data is stored in data pages, with each page holding 8KB of... [SQL Server For Beginners: An Overview Of Clustered And Nonclustered Indexes]( From Erik Darling Data +OK Azure Databricks, Spark and Snowflake [Exploring Hive Tables with Spark SQL]( From MSSQL Tips In this article, we will look at how to use an Azu... [Cloning in Snowflake]( From SQLServerCentral Blogs Cloning is a powerful feature within snowflake (al... Azure SQL [ODBC drivers for Azure SQL]( From SQLShack Introduction In previous articles, we saw how to connect with ODBC to SQL Server using the ODBC Data Source Administrator in Windows. This time, we will connect to Azure... [Azure SQL Hyperscale Named replica audit files "There are no audit files for the selected criteria"]( From Azure Database Support Blog When you enable Auditing on Azure SQL, you can select a storage account as destination. One interesting option to consume these audit logs is to use "Merge Audit Files" option... Azure Synapse (SQL Data Warehouse and Data Lake) [Synapse Spark Delta Time Travel]( While working with a customer, they had a requirement to restore modified files to a specific point in time. They had built their architecture on top of a Data lake. Career, Employment, and Certifications [6 ITOps Skills That Will Never Be Automated]( From IT Pro - Microsoft Windows Information, Solutions, Tools While automation has transformed the way IT operat... [Deciding to Submit to Conferences–#NewStarNovember]( From SQLServerCentral Blogs I wrote about getting started last week, with invitations from others. I think the first time I actually made my own submission was to the Indy Tech Fest in... The... Community Interests [Thursday is #sqlkilt Day]( From SQLServerCentral Blogs At the PASS Data Community Summit, Thursday is the... Computing in the Cloud (Azure, Google, AWS) [Getting started with MySQL on AWS: Costs, Setup, and Deployment options]( From SQLShack This article will show the basics of hosting MySQL... [Effective Cloud Migration Requires a Flexible Organization]( From IT Pro - Microsoft Windows Information, Solutions, Tools Here are three suggestions to help organizations f... [Cloud Operations Gain Momentum as Hyperscalers Dominate]( From IT Pro - Microsoft Windows Information, Solutions, Tools Technical issues are hindering organizations' cloud operations, according to Forrester Research's recent "Top 10 Trends in Cloud" report. Conferences, Classes, Events, and Webinars [Sign up to PASS Data Community Summit 2022]( There's still time to register for Summit and unlock access to over 300 sessions. Join peers and industry leaders in the data community homecoming. Register now. [Expert-led PASS Data Community Summit Pre-cons]( Spaces are still available for this month's PASS Data Community Summit pre-conference sessions - but they’re booking up fast! Choose from 18 deep-dive full day pre-cons, featuring some of the best minds in the data industry, covering everything from technical processes to personal growth. Register now. [Join a community like no other at Summit]( There's only a couple of days until PASS Data Community Summit takes place, and there's still time to register for an in-person or online pass, and unlock access to over 300 world-class sessions. Join liked-minded attendees at the year's largest hybrid data platform conference. Register now. [40% off Learning Common Table Expressions in SQL Server]( From Steve Stedman Learning Common Table Expressions is one of my favorite classes, with over 8 years of prep time for this course, including presentations at live conferences, writing a book on... [Join Azure SQL Managed Instance Product Group at PASS Summit 2022]( From Azure SQL Join Azure SQL Managed Instance Product Group team at PASS Data Community Summit 2022. This year we are bringing 14 sessions in total with 1 full day workshop, 4 live sessions (where one... DMO/SMO/Powershell [5 Ways to install PowerShell 7 on Windows]( From Sid 500 PoSh PowerShell 7 is the successor to PowerShell 5.1. It’s fast, reliable and it is cross-platform. Without a doubt, PowerShell 7 is the future. You can install PowerShell 7 on... DocumentDB/Key-Value/Graph/other NoSQL Databases [Not Every Database Is the Same: Graph vs. Relational]( From Dataversity According to IDC, the amount of digital data created over the next five years will be greater than twice the amount of data created since the advent of digital storage. Mirroring this sentiment, Statista... ETL/SSIS/Azure Data Factory/Biml [Data Integrity: The Last Mile Problem of Data Observability]( From Dataversity Data quality issues have been a long-standing challenge for data-driven organizations. Even with significant investments, the trustworthiness of data in most organizations is questionable at best. Gartner reports that... [Data Manipulation with Word and Excel]( From SQLServerCentral Blogs Recently I had to go through some training that asked me to evaluate some text. I needed to tally some data up, and decided Word and Excel were quick... The... Hardware [Microsoft Surface Laptop 5 (15-inch) Review: No Better Blues]( From Tom's Hardware US Microsoft’s Surface Laptop 5 ditches AMD for an ... [Solidigm's 61 TB SSD Hopes to Vanquish HDDs]( From Tom's Hardware US Storage specialist Solidigm's roadmap features a high-capacity SSD treat for those looking to accelerate their storage subsystems, and hastens the death-knell for HDDs in all but the most specific... [Thermalright AXP120-X67 SFF Cooler Review: Small, but Capable]( From Tom's Hardware US We tested Thermalright’s AXP120-X67 and were surprised to find it can handle Intel’s i9-13900K in most scenarios, despite it’s small size. [Intel Core i7-13700K Review: Core i9 Gaming at i7 Pricing]( From Tom's Hardware US We put Intel's new 13th-Generation Raptor Lake Cor... [Samsung 8th Gen V-NAND Pushes PCIe 5.0 SSDs Past 12 GBps]( From Tom's Hardware US Samsung now mass produces 8th Gen V-NAND: 1Tb 3D T... MDX/DAX [Introducing horizontal fusion in DAX]( From SQLBI Horizontal fusion is a new optimization technique available in DAX to reduce the number of storage engine queries. In this video, we introduce this optimization with some examples. Oracle/PostgreSQL/MySQL/other RDBMS [Optimizing MySQL: The Basics of Query Optimization]( From Simple Talk In this blog, we will walk you through the basics ... [Adventures in PostgreSQL Backups]( For PGSQL Phriday #002, Andreas Scherbaum asked us to consider PostgreSQL backups, how we do them, any recommendations we have, and whether pg_dump is a backup tool. [VALIDATING BACKUPS: PGSQL PHRIDAY #002]( It’s time again for the another PGSQL Phriday, this time, the question has been asked: How do you do PostgreSQL backups? Honesty up front. [PGSQL Phriday # 002: Postgresql Backup and Restore]( Pat Wright talks about the importance of thinking through your backup process. Performance Tuning SQL Server [SQL Server For Beginners: Basic Index Design Patterns]( From Erik Darling Data +OK [Querying a single table can use multiple indexes]( From Sunday morning T Can SQL Server piece together two different indexes in a single-table query, rather than just giving up and scanning a suboptimal clustered index? The short answer is: yes, in... [SQL Server For Beginners: How Indexes Impact Modifications]( From Erik Darling Data +OK PowerPivot/PowerQuery/PowerBI [Configure Incremental Refresh for Non-Query Folding Sources in Power BI Desktop]( From MSSQL Tips Learn how to implement an incremental refresh for ... [Performance Tuning Table Visuals With Filters Applied In Power BI]( From Chris Webb's BI Blog Power BI table visuals with a visual-level filter ... [Normalized Rank Ribbon Size Chart in Power BI]( From Havens Consulting Learn how to upgrade your ribbon charts to prioritize the rank between categories. We'll use a bit of DAX magic mixed with some Calculation Group wizardry to achieve this... [River Murray Floods 2022 Data/Power BI Report]( From Excelerator BI  [Data Masking and Unmasking Strategy for Power BI Report Testers and Business Users]( From MSSQL Tips In this article, we look at how to use different user types to display or hide data in a Power BI report based on SQL Server login credentials. [Understanding The “Unable to save the changes since the new dataset of size” Error In Power BI]( From Chris Webb's BI Blog If your Power BI dataset is too large you may run into errors when you refresh. Product Upgrades and Releases [SQL Server 2022 Query Performance Tuning]( From SQLServerCentral Blogs If you’re interested in getting a digital copy, ... [Public preview: Azure SQL Database offline migrations in Azure SQL Migration extension]( From Azure Updates Assess, get right-sized Azure recommendations for Azure migration targets, and migrate databases offline from on-premises SQL Server to Azure SQL Database. [A New AWS Region Opens in Switzerland]( From AWS News Blog I am pleased to announce today the opening of our 28th AWS Region: Europe (Zurich), also known by its API name: eu-central-2. An AWS Region allows you to deploy... [Azure Machine Learning—Public preview updates for November 2022]( From Azure Updates New public preview features include reading Delta Lakes in fewer steps, debugging and monitoring training jobs, and performing data wrangling. [Azure Machine Learning—Generally availability updates for November 2022]( From Azure Updates New GA features include the ability to automate auto-shutdown/auto-start schedules, configure and customize a compute instance, seamlessly build NLP/vision models, and assess AI systems. [Public preview: Intra-account container copy for Azure Cosmos DB]( From Azure Updates Intra-account container copy helps you create offline copies of containers within Azure Cosmos DB SQL API and Cassandra API accounts. [General availability: Azure Automation supports Availability zones]( From Azure Updates Azure Automation now supports Availability zones to provide improved resiliency and reliability to the service, runbooks and other automation assets. [Connection Security Improvements in SqlPackage 161]( From Azure SQL In version 161 of SqlPackage and DacFx some default connection settings have changed to improve the default security of database connections. In this article we will focus on these changes... [General availability: Virtual Machine software reservations]( From Azure Updates You can now save on Virtual Machine software from third-party publishers by purchasing software reservations. [Azure Multi-Factor Authentication Server will be deprecated 30 September 2024]( From Azure Updates Deprecation notice: transition from Azure MFA Serv... [Power BI Model Documenter v2.1.0]( From Data – Marc It is long overdue, but time for a new updated version for the Power BI Model Documenter external tool! The latest release lasts from the first week of 2022... R Language [Which Gender is associated with this Name? R to the R-escue!]( From Learning Machines When addressing somebody unknown to you with an un... [Accessing Google Trends]( Google Trends is a website by Google that analyzes the popularity of top search queries in Google Search across various regions and languages SQL Server Security and Auditing [Using Granular Permissions with Dynamic Data Masking in SQL Server]( From MSSQL Tips Learn about the new dynamic data masking features in SQL Server 2022 to control data masking based on user permissions. Security News and Issues [Amazon, Microsoft Cloud Leaks Highlight Lingering Misconfiguration Issues]( From Dark Reading: Dark Reading News Analysis Cloud storage databases, often deployed as "rogue ... [Why Security Logging Is Key to Ransomware Response]( From IT Pro - Microsoft Windows Information, Solutions, Tools Security logging can help organizations recover from ransomware attacks – and even negotiate with attackers. Software Development [T-SQL Tuesday #156 – Production-Grade Code]( From Callihan Data What quality makes code production-grade? That’s the question posed by Tom Zika in this month’s edition of T-SQL Tuesday. I don’t believe there’s a “right” answer to this question... [What is production grade code? : T-SQL Tuesday #156]( From SQLStudies It’s that time of the month again! It’s T-SQL Tuesday and this month Tom Zika (blog|twitter) is hosting. Tom would ... Continue reading T-SQL and Query Languages [Improving AT TIME ZONE Performance]( From Erik Darling Data +OK [T-SQL Tuesday #156 : Production Code]( From SQLBlog.org For T-SQL Tuesday #156, I talk about the qualities I expect in T-SQL code before I consider it "production quality." [T-SQL Tuesday 156 – Think twice about your comments]( From Kevin Chant Reading Time: 3 minutes For this months T-SQL Tuesday contribution I want to explain why you should think twice about your comments when writing code. Because you never... [T-SQL Tuesday #156 – On Production Code]( From AndyLeonard.blog() This month’s T-SQL Tuesday is hosted by Tom Zika. Tom’s topic is a good one: “Which quality makes code production grade?” I can hear data minds thinking, “It depends.”... [T-SQL Tuesday #156 – Production Grade Code]( From Deb the DBA Happy T-SQL Tuesday, everyone! I’ve missed the past couple of ones but I’m happy to jump back in. This month, Tom Zika (t | b) asks us to talk... [Moving dates to a weekending date]( From SQLServerCentral Blogs In publishing, and Im sure many other industries, ... [The Basics of Deleting Data from a SQL Server Table]( From Simple Talk Over time data in SQL Server tables needs to be modified. There are two major different aspects of modifying data: updating and deleting. In my last article “Updating SQL... [Fun With KQL – Arg_Max and Arg_Min]( From Arcane Code Introduction A very common need in query languages is the ability to extract the maximum and minimum values in a column of data. The Kusto Query Language provides this capability... [SQL Subtract dates]( From SQLShack In this article, we will show how to subtract dates using SQL Server. This article will be a learn-by-example article with a problem and a solution. But first, I... Tech News [Microsoft, GitHub, OpenAI Hit with Code Copyright Lawsuit]( From IT Pro - Microsoft Windows Information, Solutions, Tools Plaintiffs are asking for at least $9 billion in d... [Twitter Auditors Missed Security Lapses Whistleblower Later Called ‘Egregious’]( From IT Pro - Microsoft Windows Information, Solutions, Tools The 2021 external audit concluded that Twitter had appropriate safeguards. Months later, Twitter's cybersecurity chief had left and alleged the company's practices were marred by “egregious deficiencies.” [City of Phoenix Uses IoT to Improve Livability, Sustainability]( From IT Pro - Microsoft Windows Information, Solutions, Tools At IoT World Austin 2022, city officials showcased... The Lighter Side [McDonald's McCrispy Gaming Chair Has a Fry Holder and Sandwich Warmer]( From Tom's Hardware US McDonald's UK is giving away a gaming chair that holds your fries and dip and warms your McCrispy Chicken Sandwich. Tools for Dev (SSMS, ADS, VS, etc.) [Setting up my new workstation with some Chocolatey goodness.]( From SQLStudies   [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. 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -