Considerations for Updated Statistics (2023-01-07 DBW)

Database Weekly for January 7, 2023 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  The Cost of Employee Turnover Sometime during the first 3-4 months of the pandemic, after offices all over the world closed, I thought that a lot of businesses would try to hold on to existing employees and minimize turnover. I also thought many employees would be nervous about changing jobs amid all the uncertainty. That wasn't the case everywhere, and I was surprised at how much employee turnover occurred in many companies during 2020 and 2021. We had the Great Resignation, where talented employees (and some not-so-talented) found new employment with lots of remove flexibility. We typically have low turnover at Redgate, but more surprising to me was the number of people we've hired in the last two years. Our gains come from losses elsewhere. It seems a lot of companies have had a bit of turnover, more than they liked. The costs of replacing a staffer has climbed to an average of USD$57k, according to [a recent poll of hiring managers](. I'm sure this is a combination of the time and money spent on recruiters and interviews as well the lost productivity of having less people around. For many of us working in technology, we realize that losing good people is a problem. Often we lose undocumented knowledge about our systems, those shortcuts, checks, small tasks, not-so-obvious fixes, and more that make life easier. We can feel more stressed about additional work, or even the anticipated unknown challenges we might face. Moral, productivity, and motivation decrease, which creates a snowball effect. Everyone gets less done, which costs the organization more. Either lower revenue, more costs, or perhaps fewer services for those government or non-profit concerns. With large tech companies letting lots of talented people go, I wonder if we'll see more competition in the employment market. For quite a few years there have been fewer workers than there are jobs. Perhaps that changes a bit in the future, though I still think there are not nearly enough talented workers for the positions open. Good for talented workers as they may have more choices, but also good for less talented workers when companies feel pressure to hire anyone. Except, what I've seen in a lot of companies is that they don't want to hire anyone. Having a degree or cert isn't enough. Companies aren't going to hire you because you are Azure/AWS/etc. certified. They want tech skills and at least a few soft ones. That creates an even higher cost to fill positions, so maybe that USD$57k isn't a bad number. To me, what this really means is that organizations ought to look at poor management, both middle and upper, and replace those people. That's the problem in many places, one that isn't easily fixed. Poor culture, micromanagement, lack of support, little-to-no psychological safety, and more contribute to poor retention. Culture is important and building it is hard. While not everyone will have a great culture, many organizations can avoid a poor one by treating people fairly and ensuring management understands how to do that. If for no other reason than to avoid the high costs of replacing staff. 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 [Dealing with Mutually Dependent Databases in Flyway]( How to create and manage 'stub' objects, in Flyway migrations, in order to overcome build failures caused by circular, or mutual, dependencies between objects in different databases. The technique should be applicable to any RDBMS. [Dealing with Cross-Server Database Dependencies in Flyway Projects]( How to tackle database development in Flyway when databases make cross-server references. The technique uses synonyms to represent the remote objects, and local 'stub' objects to overcome the problems caused by 'missing references' when building the individual objects. [Introducing the MySQL common table expression]( This article is part of Robert Sheldon's continuing series on Learning MySQL. To see all 11 items in the series, click here. [Azure Function and User Assigned Managed Identities]( Let’s talk about authentication between Azure Functions and resources used by Azure Functions and conclude with many poorly documented secrets about how to use User Assigned Managed Identity. Administration of SQL Server [Considerations for Updated Statistics]( From Callihan Data Up-to-date statistics makes life easier for SQL Se... [Lesson Learned #265: Deadlock due to Non-Optimized Queries]( From Azure Database Support Blog Today, I worked on a performance case where our cu... [Lesson Learned #266: Avoiding duplicate statistics]( From Azure Database Support Blog Today, I worked on a service request that our cust... [SQL Server Errors 823, 824, or 825]( From Steve Stedman Errors 823, 834, and 825 are all related to I/O er... [Identify Unused Indexes across all Databases]( From SQLServerCentral Blogs I had a request regarding how to identify unused i... [Understanding SQL Server Hardware: Parallelism and CPU]( From Erik Darling Data +OK [Help! My tempdb is full and I can’t access SQL Server!]( From SQLServerCentral Blogs I got a call saying the database server is inacces... [Lesson Learned #268:Error occurred during the pre-login handshake-The semaphore timeout period]( From Azure Database Support Blog  Azure Databricks, Spark and Snowflake [Somehow I like Snowflake more and more]( From Sherpa of Data It’s no secret that I like Snowflake. When I say like, I mean that I like some of the different ways that I can find data within other data.... Azure SQL Managed Instance [Setting up Row Level Security (RLS) on an Azure SQL DB/SQL MI by utilizing Azure AD groups]( From Azure Database Support Blog Scenario: We have 2 Azure AD groups (RLS_11 & ... [How to move Azure SQL managed instance cross subscriptions]( From Azure Database Support Blog We have recently received a few service requests f... Career, Employment, and Certifications [Recommended certifications for Azure Databricks enthusiasts]( From Kevin Chant Reading Time: 3 minutes Since this is my first po... [Common DBA Interview Questions]( From Steve Stedman There are many different DBA (database administrat... [AZ-700 Designing and Implementing Microsoft Azure Networking Solutions]( From The SQL Herald (Joey D'Antoni) One of the fun parts of working for a small-ish Microsoft Partner is that you have to take a lot of exams. Some of which aren’t in your direct... [Announcing the 2023 Data Professional Salary Survey Results.]( From Brent Ozar Unlimited  Computing in the Cloud (Azure, Google, AWS) [Azure SQL VM: Azure Backup & restore for SQL Server on Azure Virtual Machines [Ep.10] | Data Exposed]( From Azure SQL In the next episode in the Azure SQL VM series, jo... DevOps and Continuous Delivery (CI/CD) [Database DevOps and Code management with PostgreSQL]( From Software and Booz For PGSQL Phriday #004, Hettie Dombrovskaya challe... HA/DR/Always On/Clustering [Clusters Do Not Replace a Proper Backup and Restore Strategy]( From SQLHA -- Allan Hirt Features are great until they aren't. Understand w... MDX/DAX [Why DAX Window Functions Are Important For Performance In Power BI DirectQuery Mode]( From Chris Webb's BI Blog DAX window functions can result in simpler, more e... [(Livestream Replay) [DAX] Window Functions & Tabular Editor 3 - with Daniel Otykier]( From Havens Consulting ABSTRACT The Power BI December 2022 update included some exciting new DAX functions, that are all the buzz recently. Let’s explore these new functions using Tabular Editor 3’s DAX... PowerPivot/PowerQuery/PowerBI [Introduction to Using URLs for Reports in Power BI!]( From Havens Consulting Video by: Reid HavensLearn how to add either dynam... [How to handle Aggregation tables with Averages in Power BI]( From Guy in a Cube Using Aggregation Tables in Power BI? Average calc... [Power Automate: Sending Emails As A Different User]( From SQLServerCentral Blogs A common frustration when sending emails from Powe... [Using Cognitive service for Translation in Power BI]( From RADACAD There is a possibility to call cognitive service f... [Power BI Licensing Ultimate Guide]( From RADACAD Licensing in Power BI comes with many options. Und... [Wait! Using a Power BI Date slicer, what are my dates when using between?]( From Guy in a Cube Struggling to get dates when using a between date ... [Normalize Repeated Data in Power BI reports and Charts with Power Query]( From MSSQL Tips Learn how to unpivot repeated data columns in a da... Product Reviews and Articles [Installing Flyway Community on Windows]( From SQLServerCentral Blogs One of the things I’ve been trying to do is dig ... Product Upgrades and Releases [SQL Server Diagnostic Information Queries for January 2023]( From Glenn Berry Introduction These are my SQL Server Diagnostic Information Queries for January 2023, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration... R Language [Little useless-useful R functions – Mandelbrot set]( From TomazTsql The Mandelbrot set is a set of complex numbers �... SQL Server News [Microsoft R Application Network retirement]( From MS SQL Server Blog  SQL Server Security and Auditing [Setting up TDE]( From SQLServerCentral Blogs Transparent Data Encryption (TDE) is one of the ea... Security News and Issues [CircleCI: Rotate Stored Secrets ASAP]( From Dark Reading: Dark Reading News Analysis DevOps platform warns customers of a "security inc... [Remote Vulnerabilities in Automobiles]( From Schneier on Security This group has found a ton of remote vulnerabilities in all sorts of automobiles. It’s enough to make you want to buy a car that is not Internet-connected. Unfortunately, that... Software Development [Can your application handle all BIGINT values?]( From Michael J. Swart In the past I’ve written about monitoring identi... T-SQL and Query Languages [Overview of the SQL Median function]( From SQLShack In this article, we will learn how to implement th... [How to Find Missing Rows in a Table]( From Brent Ozar Unlimited When someone says, “Find all the rows that have been deleted,” it’s a lot easier when the table has an Id/Identity column. Let’s take the Stack Overflow Users table:... Tech News [Amazon to Slash More Than 18,000 Jobs in Escalation of Cuts]( From IT Pro - Microsoft Windows Information, Solutions, Tools The cuts, which were previously thought to affect ... Tools for Dev (SSMS, ADS, VS, etc.) [Troubleshooting Azure Data Studio]( From Deb the DBA The TL;DR version of what you’re about to read i...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -