The Top SQL Server Engine Errors (2023-03-04 DBW)

Database Weekly for March 4, 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 Top SQL Server Engine Errors For many of us, SQL Server just works. We might get some syntax errors if we mistype things, but for the most part, SQL Server runs smoothly in many environments. However, there are some common situations that do occur regularly, and I wonder if you can guess which errors often occur? I saw a blog this week from the SQL Server Support group where they covered the [top 25 errors that come in support calls](. Their goal was to see if they could document and help people better solve problems themselves and reduce the support load. Can you guess what the first error was? I'm assuming these are in descending order, but that's not clear. In any case, the top error was #18456, which I didn't recognize at first. Reading [the documentation page]( shows this is the "login failed for xxx" error, which is probably my most common error. Often because I can't type a password correctly, but also because of an inability to select the right instance or user name. There are other causes, and it's nice to see a long list of things people can check. The next error was [19407]( which is a cluster communication error. If that's the second most common error, then maybe clusters and AGs need a bit more resiliency or better setup guidance. [Third is an OS error]( with NTFS, which I've never run into. If you flip through the list, I wonder how many of these errors are common for you. Do they come up often? I know I've seen people post on [912]( which is an upgrade error and very annoying. I think some of the upgrade scripts for CUs aren't that well written and should have better error handling inside them. That would seem like an easy one to fix and reduce call volume. There are plenty of network errors, including the "[error occurred while establishing a connection](" one. That one is usually is a typo from me or a misconfiguration of an instance after installation. Lots of other errors seem network or backup related, which may not be common, but those are errors that likely cause people to call Microsoft Support. Maybe the most interesting one is [9002, log out of space](. While I know lots of people might not know how to manage space, I also see lots of accidental DBAs get caught here because they set up full backups and not log backups. Their databases are small, storage is cheap, and they encounter this a year or so after they've set things up. To me, this is really low-hanging fruit by making it really easy to have an automatic backup process added for each database. Just add tooling to help make this easier, or create a job when a new database is created. If this isn't needed, let it be disabled, but for those that are installing SQL Server for some COTS application, make this a easy. A lot of these errors are ones I'd never call support for, but I can imagine others not feeling that way. Plenty of these are errors I've never seen, but I'm glad the documentation is more than just a description of what happens. These updated pages give some possible causes and things that the user can do. That's something all of us would like in documentation when something goes wrong. 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 [How do your DevOps plans really measure up?]( If you’re championing a DevOps implementation in your organization, or wish to see where your current processes measure up against your peers, read on. [The 10 habits for highly successful compliant database DevOps]( Database DevOps has come of age. Now seen as a key technical practice which can contribute to the successful implementation of DevOps, it stops the database being a bottleneck and makes releases faster and easier. To implement it successfully, there are ten areas which teams should focus on. [Improving the Quality of your Database Monitoring]( Database monitoring should be as simple as possible, and yet still allow the users to drill into sufficient detail to be able to recommend a fix to the problem. The trick is to adopt a layered or 'tiered' approach. [PostgreSQL Basics: Object Ownership and Default Privileges]( Understanding how roles and privileges work in Postgres is key to understanding the next, and often more confusing part of security, object ownership. Although there are many privileges that can be assigned in Postgres, object ownership comes with a specific level of privilege that cannot be transferred to other roles. Understanding the implications of this is essential to the management of your database schema, and access to the objects it contains, over time. AI/Machine Learning/Cognitive Services [The inside story of how ChatGPT was built from the people who made it]( From Technology Review Feed - Tech Review Top Stories When OpenAI launched ChatGPT, with zero fanfare, in late November 2022, the San Francisco–based artificial-intelligence company had few expectations. Certainly, nobody inside OpenAI was prepared for a viral mega-hit.... [Raspberry Pi Brings ChatGPT AI to Clippy]( From Tom's Hardware US Microsoft Office's "beloved" mascot, Clippy receives an AI boost thanks to Raspberry Pi and ChatGPT Administration of SQL Server [Linked Server with Unique Identifier Issue]( From Purple Frog Systems There is currently an issue with Linked Servers wh... [Top 25 SQL Server Engine Errors Based on support case volumes Documented]( About 6 months ago we decided to look at what SQL Server engine error messages are most commonly generating support cases to Microsoft. The end goal was to update the documentation for those error messages to allow our customers to find answers for themselves before they have to call Microsoft for technical assistance. [Lesson Learned #336: Using STARTUP_STATE option in an extended event in Azure SQL Database]( From Azure Database Support Blog We got a service request that our customer reported that after a planned maintenance the extended event that they created Lesson Learned #1: Capturing a TSQL Command Timeout - Microsoft... [Handling Error 40619 while copying database using T-SQL]( From Azure Database Support Blog We got an error while copying a database from one server to another server or the same server using T-SQL command: create database testcopy2 as copy of testcopy(Service_Objective='S2')  Msg 40619, Level... [Lesson Learned #335: BACKUP WITH COPY_ONLY cannot be performed until after the next automatic BACKUP]( From Azure Database Support Blog Today, we worked on a service request that our customer got the following error message: BACKUP WITH COPY_ONLY cannot be performed until after the next automatic BACKUP LOG operation... [Drop All Redundant Indexes In Every Database All At Once]( From Eitan Blumin Learn how to identify and remove redundant indexes in SQL Server to improve database performance and save storage space. The post Drop All Redundant Indexes In Every Database All At... [SQL Server Corruption: What Can Get Corrupted]( From Steve Stedman In a Microsoft SQL Server database, several components can become corrupt, including: * Data pages: Data pages store the actual data in a SQL Server database. Corruption can occur... Azure Databricks, Spark and Snowflake [Snowflake Temporary Tables vs. Transient Tables]( From MSSQL Tips Learn about temporary tables and transient tables when using Snowflake along with their similarities and differences and when to use these types of tables. Azure DevOps [Thoughts about disabling classic pipelines in Azure DevOps]( From Kevin Chant Reading Time: 4 minutes In this post I want to sh... Azure SQL [Calling REST endpoints from T-SQL | Data Exposed: MVP Edition]( From Azure SQL A new Azure SQL DB feature in late 2022, sp_invoke_rest_endpoint lets you send data to REST API endpoints from within T-SQL. It sounds like a simple feature, but has... Azure Synapse (SQL Data Warehouse and Data Lake) [Azure Synapse Spark Notebook – Unit Testing]( In this blog post, we will cover how to test and create unit test cases for Spark jobs developed using Synapse Notebook. [Creating a custom disaster recovery plan for your Synapse workspace Part 1]( Many of our customers have been asking about creating a disaster recovery plan for their Synapse Workspace. In a new blog series, we will cover the basics of disaster recovery and business continuity, discussing available options and custom solutions. [Synapse Connectivity Series Part #3 - Synapse Managed VNET and Managed Private Endpoints]( In this article we are going to talk about Synapse Managed Virtual Network and Managed Private Endpoints. [Continuing on the Journey of Azure Synapse Analytics]( From SQLServerCentral Blogs Azure Synapse Analytics has always enamored me. With its analytics service capabilities bridging the gap between enterprise data warehousing and Big Data analytics, it provides the end users much... The... Career, Employment, and Certifications [Searching for Your Next Opportunity?]( From AndyLeonard.blog() A friend compiled these thoughts about searching for your Next Opportunity: Reading “How to Survive if You Were Part of the Tech Layoffs” Wired Magazine:  How to Survive if You... [10 Ways to Demonstrate Your Credibility via Your LinkedIn Profile]( From MSSQL Tips In this article, we look at various things you can... [Announcing the launch of: WITspiration]( From Deb the DBA I cannot begin to say how excited I am for this blog post because I finally get to tell you about something that’s been in the works for a... [30 Interview Questions for a Database Administrator and Developer]( From SQLServerCentral Blogs This blog post summarizes the type of technical questions I would ask candidates for a Microsoft SQL Server data platform administrator and database developer role.Hopefully this helps both candidates... The... [Preparing for TOGAF Certification]( From SQLServerCentral Blogs The Open Group Architecture Framework (TOGAF) is one of the most well-known architectural frameworks in our industry. TOGAF is a framework that helps organizations implement enterprise architecture as a... The... [A Corporate Wellness Day]( From SQLServerCentral Blogs Today is the corporate Wellness Day at Redgate. It’s a day off for almost everyone in the company, unless they have something that can’t get moved. A few support... The... Computing in the Cloud (Azure, Google, AWS) [General availability: Azure Virtual Network Manager]( From Azure Updates Azure Virtual Network Manager (AVNM) is now generally available. AVNM is a one-stop shop for managing the connectivity and security of your network resources at scale. [Reading AFAS REST API Data with Azure Logic Apps]( From SQLServerCentral Blogs Recently I had to read some REST API data using an Azure Logic App. The data itself comes from AFAS, a Dutch SaaS ERP company. In general, the process... The... Conferences, Classes, Events, and Webinars [Join Redgate at SQL Bits, March 15-18]( From castles and dragons to swordfights and spells, this year’s SQL Bits will have it all. Make sure you don’t miss out on our great sessions, from Code Errors to Reliable Releases, to adding some PostgreSQL skills to your repertoire. Get 10% off registering with 10REDGATE [Fun With KQL – New Pluralsight Course! Kusto Query Language: Scalar Operators]( From Arcane Code Fun With KQL - New Pluralsight Course! Kusto Query Language: Scalar Operators [Learn PowerShell in 30 Minutes a Day, Free, Starting Now.]( From Brent Ozar Unlimited The clock starts now! You’re a production database administrator responsible for the health, security, and uptime of many database servers. You’ve been pointing and clicking your way through SSMS... [SQL Saturday Atlanta 2023 Recap]( From Data on Wheels (Steve Hughes) This past weekend, I had the pleasure of attending and speaking at SQL Saturday Atlanta! If you’re in the area, I highly recommend connecting with the local user group... DMO/SMO/Powershell [How to Export PowerShell Command History To Make a Script]( From IT Pro - Microsoft Windows Information, Solutions, Tools It is easy to export your PowerShell command histo... Data Visualisation [stop, collaborate and listen (to your audience)]( From Storytelling with Data  ... ETL/SSIS/Azure Data Factory/Biml [SQL: Understanding Change Data Capture for Azure SQL Database – Part 1 – Why?]( From The Bit Bucket I often need to capture the changes from one database into another. The most common reason is that I'm wanting to bring changes from a transactional system across into... Excel [Excel, CSV and Leading Zeros]( From Purple Frog Systems Yes, even at Purple Frog Systems we use Excel! Excel is great for that quick and dirty analysis, but there is nothing worse than opening a CSV file directly... HA/DR/Always On/Clustering [SQL Server Wait Type: HADR_AR_CRITICAL_SECTION_ENTRY]( From Steve Stedman Wait statistics, in the context of SQL Server, ref... Performance Tuning SQL Server [Index Tuning Essentials: Query Worker Threads]( From Erik Darling Data Index Tuning Essentials: Query Worker Threads Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75%... [Index Tuning Essentials: Fixing Large Memory Grants]( From Erik Darling Data Index Tuning Essentials: Fixing Large Memory Grants Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a... [Index Tuning Essentials: The Problems With Table Spools Demo]( From Erik Darling Data Index Tuning Essentials: The Problems With Table S... [Index Tuning Essentials: Fixing Blocking]( From Erik Darling Data Index Tuning Essentials: Fixing Blocking Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount... PowerPivot/PowerQuery/PowerBI [Top 3 Best Practices for Power BI | Data Exposed]( From Azure SQL There are three best practices you should know whe... [The MAGIC of Microsoft Teams + Power BI]( From Guy in a Cube Are you using Power BI within Microsoft Teams? Dan... [(Livestream Replay) 5 Ways to Get Power BI Data into Excel! None are Copy Paste! - with Wyn Hopkins]( From Havens Consulting ABSTRACT The reality is folks need / want thei... [Different Power BI Export to table options and what they look like]( From FourMoo I was recently helping out a customer and they contacted me asking why was the export option not in the format that they expected. I had a look and... [What to know about the new accessible Power BI themes]( From SQLServerCentral Blogs In February 2023, Microsoft released some new Powe... [Removing Diacritics From Text In Power Query]( From Chris Webb's BI Blog Remove accents and other diacritics from text in Power Query by converting the text to a binary using the Greek code page and converting back Product Upgrades and Releases [Azure SQL—General availability updates for early March 2023]( From Azure Updates General availability enhancements and updates rele... [Intel Patches Stuttering Ethernet Issues, but It's Just a Workaround for Now]( From Tom's Hardware US Intel has released a patch for intermittent Ethernet disconnections plaguing its latest controllers. It is just an EEE disabling workaround for now. Python [Getting Started with Python for Apache Kafka]( It's becoming increasingly important for companies to be able to respond to the events that affect their business in real time. Apache Kafka® has become the de facto standard for meeting the need for real-time data processing. [Building a File Analysis Dataset with Python]( Last year I devised some ways of analyzing the history and structure of code in a visual way, but I didn’t document much of that to share with the community. This article explores the process I used to build a CSV file containing the path, extension, project, and line of code count in all source files in a project. R Language [Proximal operator for inner product in R^n]( From Statistical Odds & Ends Let be a lower semi-continuous convex function with being a convex set. The proximal operator for is defined by In this post, we derive the value of the proximal... [Quickly Generate Nested Time Series Models]( There are many approaches to modeling time series data in R. One of the types of data that we might come across is a nested time series. This means the data is grouped simply by one or more keys. There are many methods in which to accomplish this task. SQL Server News [SQL Server 2022: The Future of Data Management]( From SQLServerCentral Blogs SQL Server 2022 and its enhancement … Continue reading SQL Server 2022: The Future of Data Management → The post SQL Server 2022: The Future of Data Management appeared first on... SQL Server Security and Auditing [Lesson Learned #334: The login already has an account under a different user name]( From Azure Database Support Blog Today, we worked on a service request that our customer reported this error Msg 15063, Level 16, State 1, Line 1 The login already has an account under a different user... [Enable IT personnel to monitor SQL health and performance while reducing the insider risk]( From Azure SQL The article is published here on the Microsoft Sec... Security News and Issues [2 of the Worst Healthcare Data Breaches in US History Happened Last Year]( From Dark Reading: Dark Reading News Analysis  [Dumb Password Rules]( From Schneier on Security Examples of dumb password rules. There are some pr... [Fooling a Voice Authentication System with an AI-Generated Voice]( From Schneier on Security A reporter used an AI synthesis of his own voice to fool the voice authentication system for Lloyd’s Bank. T-SQL and Query Languages [Save Time Counting, Use IF EXISTS]( From Callihan Data When checking for the existence of a value or values in a table, typically, the whole table does not need to be read. The goal is to obtain more... [Can You Nest Transactions in SQL Server?]( From Brent Ozar Unlimited To find out, let’s set up a simple status log table: [crayon-63fe5bc01dfc5747959503/] And then let’s try a two-part transaction: [crayon-63fe5bc01dfc9552339811/] Right now, SQL Server shows that I have 2... Tech News [IT Acronyms: A Cheat Sheet for IT Pros]( From IT Pro - Microsoft Windows Information, Solutions, Tools This free cheat sheet not only lists the most important acronyms IT pros need to know, but it also provides a definition of each. [Austin, L.A., Seattle Most Tech-Oriented American Cities]( From IT Pro - Microsoft Windows Information, Solutions, Tools Here are the top 10 U.S. cities that are best prep... [Four ways the Supreme Court could reshape the web]( From Technology Review Feed - Tech Review Top Stories This article is from The Technocrat, MIT Technology Review’s weekly tech policy newsletter about power, politics, and Silicon Valley. To receive it in your inbox every Friday, sign up here.... The Lighter Side [Raspberry Pi Helps TRS-80 Model 102 Deploy Kubernetes]( From Tom's Hardware US The TRS-80 Model 102 is a classic computer from the mid-1980s and with the help of a Raspberry Pi and an ESP32 it is capable of much more exciting...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -