Cardinality Estimation Feedback in SQL Server 2022 (2022-12-03 DBW)

Database Weekly for December 3, 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  Making the World Better Many of us that work in technology are blessed. We perform a job that requires creativity and intelligence. We don't have to work outside or engage in hard physical labor. We are well compensated, and we can do this job for many years. Certainly that's not true for everyone and there is plenty of stress, but compared to many construction trades, medical workers, and more, we have a good job. I believe in giving back to the world, both in time and money. Volunteering for causes that matter to you is a good way to spend some of your time. I hope everyone volunteers at some point in their life, and I also hope that you support those charitable causes that matter to you. This is the holiday season, with many celebrations across various cultures and religions. It is a time of the year that many of us donate a bit more, and I was reminded of that this week. Denny Cherry and Associates Consulting has published [a post where they will donate to a cause]( if you view the post. Their cause of the Elizabeth Glaser Pediatric AIDS Foundation. They also have a link where they will match your donation if you click through and donate yourself. This isn't a cause I normally think about, but I do think it's good to take extra care of children, so I donated myself. If you believe in this cause, then please think about adding your own funds. If you have other causes, local or otherwise, take a minute today and think about if and how you can support them this year. 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 [Cross-RDBMS Code Quality Reports in Flyway]( Before you commit your Flyway migration files, you may want to run some automated checks for style or 'code smells'. This article demonstrates how to run basic cross-RDBMS code quality checks using SQL Fluff. We analyze the results in PowerShell to produce reports and analytics on the number or types of issues found. [The Basics of Deleting Data from a SQL Server Table]( 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 Server Data” I discussed using the UPDATE statement to change data in existing rows of a SQL Server table. In this article I will be demonstrating how to use the DELETE statement to remove rows from a SQL Server Table. AI/Machine Learning/Cognitive Services [Advent of 2022, Day 1 – What is Azure Machine Learning?]( From TomazTsql Azure Machine Learning (or Azure Machine Learning Service and abbreviation AML) is Azure’s cloud service for creating, managing and productionalising machine learning projects. It is a collaborative tool for... [Biotech labs are using AI inspired by DALL-E to invent new drugs]( From Technology Review Feed - Tech Review Top Stories The explosion in text-to-image AI models like OpenAI’s DALL-E 2—programs trained to generate pictures of almost anything you ask for—has sent ripples through the creative industries, from fashion to... [Part 3: Natural Language Processing – Sentiment Analysis and Opinion Mining]( From Purple Frog Systems If you remember in part 2 we discussed what Key Wo... [Hugging Face Fine-tune for Multilingual Text Summarization (Japanese Example)]( From tsmatz In this post, I'll show you multilingual (Japanese... [A bot that watched 70,000 hours of Minecraft could unlock AI’s next big thing]( From Technology Review Feed - Tech Review Top Stories OpenAI has built the best Minecraft-playing bot ye... Administration of SQL Server [Cardinality Estimation Feedback in SQL Server 2022]( From Microsoft SQL Server Blog In SQL Server 2022, we have introduced a method of... [Error during enabling CDC on an Azure SQL DB- 'Msg 22830, Level 16, State 1, Line 274']( From Azure Database Support Blog Issue An issue was noticed recently while enabling... [Use RCSI to tackle most locking and blocking issues in SQL Server]( From Michael J. Swart What’s the best way to avoid most blocking issue... [Hyperconverged storage tuning tip for SQL Server]( From SQLServerCentral Blogs We all (should) know that running SQL Server in hy... [Data Migration Assistant]( From StraightPath Solutions SQL Blog It’s upgrade season. Here at Straight Path, we have more than a couple of clients in the process of upgrading their SQL Environments to a more modern version. With... Azure Databricks, Spark and Snowflake [Snowflake Classic UI vs Snowsight]( From SQLServerCentral Blogs This blog post is not about which User Interface i... Azure SQL Managed Instance [Move Azure SQL Managed Instance across the virtual networks]( From Azure SQL In this blog that is continuation of #sqlmiops series, we will present a feature for moving Azure SQL Managed Instance from one to another subnet located in a different... [Deploy and Configure Azure SQL Managed Instance]( From MSSQL Tips This article covers how to deploy, configure and test the managed instance version of Azure SQL Database using the General-Purpose edition. Career, Employment, and Certifications [Mentoring 2023 – want some help from me?]( From In Recovery... In 2015 I mentored 54 people for six months. In 2020 I mentored 37 people on-and-off for over a year. In 2023 I’ll be mentoring ?… Why do I... [IT Leadership Skills in the Virtual Workplace: Roadmap for Development]( From IT Pro - Microsoft Windows Information, Solutions, Tools IT managers will need to harness the power of team... [Tell My Story of Public Speaking]( From SQLServerCentral Blogs This month the fine folks behind New Stars of Data and the DataGrillen Newcomer Track bring us the Tell Your Story blog party. Where we The post Tell My Story... The... Community Interests [View a Blog Post, Make a Donation – 2022 Edition]( From DCAC As DCAC has done in prior years we are looking for your help with our donation program to the Elizabeth Glazer Pediatric AIDS Foundation. As today, December 1, 2022,... [The Curious Case of… community]( From In Recovery... (The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something... [Redgate 100 Spotlight: Community Heroes]( From Blog – Redgate Software Since the launch of The Redgate 100, we’ve been ... Computing in the Cloud (Azure, Google, AWS) [How to overcome obstacles in moving to the cloud]( From AllAnalytics As today’s analytics landscape evolves with impr... [New – Fully Managed Blue/Green Deployments in Amazon Aurora and Amazon RDS]( From AWS News Blog When updating databases, using a blue/green deployment technique is an appealing option for users to minimize risk and downtime. This method of making database updates requires two database environments—your... [New – Amazon RDS Optimized Reads and Optimized Writes]( From AWS News Blog Way back in 2009 I wrote Introducing Amazon RDS – The Amazon Relational Database Service and told you that: RDS makes it easier for you to set up, operate,... [New – A Fully Managed Schema Conversion in AWS Database Migration Service]( From AWS News Blog Since we launched AWS Database Migration Service (AWS DMS) in 2016, customers have securely migrated more than 800,000 databases to AWS with minimal downtime. AWS DMS supports migration between... [Top Announcements of AWS re:Invent 2022]( From AWS News Blog AWS VP and Chief Evangelist Jeff Barr, plus a select group of AWS Developer Advocate colleagues, have personally chosen their picks for some of the most impactful and exciting... Conferences, Classes, Events, and Webinars [New DevOps Process Improvement Course]( Copy: However chaotic or predictable your DevOps processes currently are, the new video learning pathway from the Redgate University will help you prioritize what to improve first, provide step-by-step guidance on how to implement those improvements, and show you ways to measure them. Start learning. [New Flyway Course on Redgate University]( Flyway Desktop is the newest way to automate database deployments. In this brand new course Kathi Kellenberger provides an overview of DevOps, including definitions, tools, and demos of some of the advanced features available in Flyway Desktop. Data Privacy, Compliance, and Governance [Protecting Customers and Your Business with Ethical Data Management]( From Dataversity Many companies have been criticized in recent years for mismanaging data. For example, a major social media conglomerate recently came under fire for reports that user data was accessible to employees,... Data Science [Simulate poker hands in SAS]( From AllAnalytics A SAS programmer was trying to simulate poker hands. He was having difficulty because the sampling scheme for simulating card games requires that you sample without replacement for each... ETL/SSIS/Azure Data Factory/Biml [How to Install Integration Services 2022⁹]( From SQLServerCentral Blogs The title of this blog post is a bit misleading, b... Hardware [There's Never Been a Better Time to Upgrade Your AMD CPU (Updated)]( From Tom's Hardware US This year's Black Friday CPU deals make this the b... MDX/DAX [ISSUBTOTAL – DAX Guide]( From Sqlbi ISSUBTOTAL: Returns TRUE if the current row contains a subtotal for a specified column and FALSE otherwise. Microsoft News [Microsoft Launches New Windows Update for Business Reports Service]( From Petri IT Knowledgebase Microsoft has recently announced the general availability of Windows Update... Oracle/PostgreSQL/MySQL/other RDBMS [Backing Up MySQL Part 6: Physical vs. Logical Backups]( From Simple Talk In this blog, we compare two of the most popular t... [Subqueries in MySQL]( From Simple Talk A subquery is a type of query that is embedded—or nested—into a data manipulation language (DML) statement. The data returned by the subquery is passed into the DML statement... [PostgreSQL Join overview with examples]( From SQLShack In this article, we will learn about different types of PostgreSQL joins with examples. Introduction Data is generally hosted in a variety of data management repositories, one of them... Performance Tuning SQL Server [SQL Server For Beginners: What To Do When Queries Are Slow]( From Erik Darling Data +OK PowerPivot/PowerQuery/PowerBI [What’s New with Microsoft’s Power Platform in November 2022]( From Petri IT Knowledgebase After a series of exciting Power Platform announcements from Ignite... [Developing Large Power BI Datasets – Part 2 – Partitioning]( From Paul Turley's SQL Server BI Blog Table partitioning has long been an important task... [Developing Large Power BI Datasets – Part 3 – Detail Tables]( From Paul Turley's SQL Server BI Blog Power BI is architected to consume data in a dimen... [Web.Contents, Text Concatenation And Dataset Refresh Errors In Power BI/Power Query]( From Chris Webb's BI Blog One of the most popular topics I’ve ever written about here is the dataset refresh errors you get with dynamic data sources and the Web.Contents function in Power BI... Security News and Issues [Is MFA the Vegetable of Cybersecurity?]( From Dark Reading: Dark Reading News Analysis Multifactor authentification is crucial for creati... [One Year After Log4Shell, Most Firms Are Still Exposed to Attack]( From IT Pro - Microsoft Windows Information, Solutions, Tools Though there have been fewer than expected publicly reported attacks involving the vulnerability, nearly three-quarters of organizations remain exposed to it. [Computer Repair Technicians Are Stealing Your Data]( From Schneier on Security Laptop technicians routinely violate the privacy of the people whose computers they repair: Researchers at University of Guelph in Ontario, Canada, recovered logs from laptops after receiving overnight repairs from... T-SQL and Query Languages [How to get a date and time from a SQL Server RowVersion value with T-SQL]( From MSSQL Tips Check out this article to help you figure out real dates and times when using a SQL Server RowVersion value. [Different SQL TimeStamp functions in SQL Server]( From SQLShack This article will show different SQL timestamp fun... [SQL Boolean Tutorial]( From SQLShack The SQL Boolean data type is not included in SQL Server. Other databases like Oracle and MySQL include the Boolean data type that accepts the values of TRUE, and... [SQL Server For Beginners: Introduction To Query Tuning]( From Erik Darling Data +OK [Fun With KQL – Percentiles]( From Arcane Code Fun With KQL - Percentiles Tech News [Announcing Amazon CodeCatalyst, a Unified Software Development Service (Preview)]( From AWS News Blog Today, we announced the preview release of Amazon CodeCatalyst. A unified software development and delivery service, Amazon CodeCatalyst enables software development teams to quickly and easily plan, develop, collaborate... [Latest Patch Tuesday Updates Cause Freezes, Reboots on Domain Controllers]( From Petri IT Knowledgebase Earlier this month, Microsoft rolled out a new set... Virtualization and Containers/Kubernetes [How to cluster SAP ASCS/SCS with SIOS DataKeeper on VMware ESXi Servers]( From SQLServerCentral Blogs This article describes the steps you take to prepare the VMware infrastructure for installing and configuring a high-availability SAP ASCS/SCS instance on a Windows failover cluster by using SIOS... The...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -