Improving SQL Server Database Backup Performance (2022-10-01 DBW)

Database Weekly for October 1, 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  How Important is Software? I have a [mechanical gaming keyboard](, not because I'm a gamer, but I did want to tactile, mechanical feel and I like the idea of lights on the keys. I've enjoyed the experience, but the software leaves something to be desired. I thought about my experience as I read this review of a more complex keyboard, with the title that notes [it's so pretty you can almost forgive the software](. The poor UI and the complexity of operations, not to mention the splitting of the remap functions being unnecessarily complex. That was my experience as the only thing I cared about was remapping the home and end keys to the places I was used to them being on Logitech devices. I have spent a few hours across the last year learning how to map keys, and then relearning when my profile is lost in an upgrade or hardware glitch. How much does software matter to customers? I'd argue it is becoming more and more critical all the time. The experience of using hardware, or really any device or service, is impacted by the software that drives it. [Software is eating the world](, and I think we need to understand that better software design and quality is needed. I find that the most talented hardware companies sometimes have the worst software. It's almost as if they assume their customers will be as talented as their hardware engineers and don't spent enough time understanding how to better design a user experience for their products. Keyboards, routers, motherboards, and more often use archaic, confusing methods to have customers configure or update the systems. I know UX is hard. This isn't even about graphics or visual appeal. In many cases, it's about just better understanding of how others view the process and what information they take from what appears on the screen. Over the years I've learned that this is not only hard, but also that it takes time and debate, just like features do. I enjoy these moments, and I like to think that I help my employer produce better software for our customers with my feedback. I urge developers to have others look at what they present on the screen, and spend time learning from users, both experienced and novice. We often forget how something appears to others when we look at it every day and rush through workflows as we test our latest code. It's easy to gloss over daily changes as minor when the sum of all changes can be a jarring experience for our users after an install or upgrade. UX is important, and it's worth putting effort into our software designs, our data models, even the metadata we expose to others. 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 SQL Monitor gives developers the information they need to develop faster and smarter]( Leading Danish pharmaceutical company, Orifarm, has a mission to be 'Number 1 in making healthcare a better deal'. Find out why they chose SQL Monitor to give their whole IT team, developers included, the real-time metrics they need to highlight development issues and resolve them before they became problems. AI/Machine Learning/Cognitive Services [How one vineyard is using AI to improve its winemaking]( From Technology Review Feed - Tech Review Top Stories This episode, we’re doing something a little bit... [How to Make the Jump to AI]( From Dataversity AI and machine learning models are being used to help companies stay competitive by discovering new revenue opportunities, improving risk management, detecting fraud, and streamlining business processes. But years ago,... [How DeepMind thinks it can make chatbots safer]( From Technology Review Feed - Tech Review Top Stories To receive The Algorithm in your inbox every Monday, sign up here. Welcome to the Algorithm! Some technologists hope that one day we will develop a superintelligent AI system that... Administration of SQL Server [SQL Server Database Object Properties using OBJECTPROPERTY Function]( From MSSQL Tips SQL Server objects have many different property attributes and in this article, we look at how to use the OBJECTPROPERTY() system function to return various data about objects. [Improving SQL Server Database Backup Performance]( From Glenn Berry Introduction Does making your SQL Server database ... [SQL Partition overview]( From SQLShack Introduction In SQL Server there are several kinds of SQL partitions. However, in general, we can say that a partition is a way to divide a table (sometimes a... Azure CosmosDB [Partition Key Best Practices in Cosmos DB]( From MSSQL Tips Learn how to correctly partition data in Azure Cos... Azure Databricks, Spark and Snowflake [Snowflake – Where is the explain/execution plan?]( From SQLServerCentral Blogs Whatever your database background is you will have... Azure SQL [Deleted Azure SQL Database with existing diagnostic settings]( From Azure Database Support Blog In this article, you will find the required steps ... [Azure SQL idle sessions are killed after about 30 minutes]( From Azure Database Support Blog When we connect to our Azure SQL Databases or Azur... Azure SQL Managed Instance [How to use Windows Auth with Azure SQL Managed Instance | Data Exposed]( From Azure SQL In this episode of Data Exposed with Anna Hoffman and Sravani Saluru, they'll discuss the benefits of the newly announced Windows Authentication for Azure AD principals now Generally Available... [Improve your SQL Managed Instance performance with new TempDB configurations]( From Azure SQL  [How to check if global virtual network peering is supported on the virtual cluster for SQL MI]( From Azure SQL In this blog post we are going to describe how to... [Azure SQL and Azure SQL Managed Instance - Backup retention polices Loading ...]( From Azure Database Support Blog We have been working recently on a case where Azure portal was not able to show Backup "Retention Policies" and it was showing all the time "Loading" message.   The source... Career, Employment, and Certifications [Why You Need Presentation Skills]( From Scary DBA (Grant Fritchey) And no, the answer is not because you want to be a Microsoft MVP. Multiple surveys have been published over the decades that list “fear of public speaking” as... [My career journey leading up to Microsoft]( From Dan English's BI Blog I thought I would do a short post outlining my car... [Weighing the Pros and Cons of Becoming a Full-Stack Developer]( From IT Pro - Microsoft Windows Information, Solutions, Tools Do the benefits of becoming a full-stack developer outweigh the drawbacks? Here are the pros and cons of full-stack development to help you decide. [A Guide to Azure Certification]( From Petri IT Knowledgebase As we’re currently going through times of econom... [ITPro Today's 2022 Salary Survey Report]( From IT Pro - Microsoft Windows Information, Solutions, Tools Our survey of IT professionals’ compensation, tr... Computing in the Cloud (Azure, Google, AWS) [Cyera Survey Finds One in Three Respondents Want to Minimize Cloud Data Risk]( From Dark Reading: Dark Reading News Analysis Multiple providers say 'cloud data sprawl' makes ... [Growing Cloud Complexity Causing Visibility Challenges for IT Teams]( From IT Pro - Microsoft Windows Information, Solutions, Tools CIOs say they need a more automated approach to managing their ever-increasing data if they are to produce meaningful analytics. [AWS Week In Review — September 26, 2022]( From AWS News Blog It looks like my travel schedule is coupled with this Week In Review series of blog posts. This week, I am traveling to Fort-de-France in the French Caribbean islands... [Top 10 Trends Transforming the Cloud, According to Forrester]( From IT Pro - Microsoft Windows Information, Solutions, Tools Hyperscalers offering composability and concerns about dependence on megavendors are among the trends molding the future of the cloud. Conferences, Classes, Events, and Webinars [Redgate Summit: The Database DevOps Transformation]( Digital transformation and data modernization are frequently cited as high-value strategic projects that are crucial to achieving competitive advantage. At the same time, delivery of code in agile and predictable ways has led to many businesses adopting DevOps practices. Throughout this event we will explore how Database DevOps can be the function that accelerates transformation projects. Join us On October 6th as we invite experts to share their insider tips and tricks. [Join the Redgate pre-con at PASS Data Community Summit]( Take on the challenge of deploying database changes every 30 minutes in Redgate's Summit pre-con 'The Journey from Manual Deployments to Database DevOps' on November 15. Hosted by Steve Jones, Grant Fritchey and Redgate DevOps experts, you'll start with a manual process and slowly implement changes that allow you to reap the benefits of automation. [Discover our top pick Redgate sessions at the PASS Data Community Summit 2022]( From Blog – Redgate Software As proud hosts of the PASS Data Community Summit, ... Data Privacy, Compliance, and Governance [Understanding Microsoft Purview Pricing]( From SQLServerCentral Blogs Ever since its official launch around October 2021, Microsoft Purview has been one of the more popular services in Azure, with a steady stream of new features expanding the... The... Data Science [3 advanced metrics to help you sustain a winning fantasy football team]( From AllAnalytics You’re down by 10 points in your NFL fantasy foo... [What is Type S error?]( From Statistical Odds & Ends The concept of Type S error in hypothesis testing ... [Standardising Data per Million Population]( From Excelerator BI  [What is the exaggeration ratio (expected Type M error)?]( From Statistical Odds & Ends In this previous post, we introduced the concept of Type S error in hypothesis testing, which is the probability of the effect size having the wrong sign, conditional on... Data Visualisation [Improving Customer Experience with Data Storytelling]( From Dataversity Each day, one in four health care customers beco... ETL/SSIS/Azure Data Factory/Biml [ODBC Drivers in SSIS]( From SQLShack Introduction In previous articles, we learn how to... HA/DR/Always On/Clustering [Add SQL databases in an existing availability group]( From SQLShack In this article, we will learn how to add a SQL da... Hardware [PC Airflow Guide: How to Set Up and Position Your Fans]( From Tom's Hardware US In this guide, we’ll teach you how to arrange th... [SK Hynix Shows Off 48GB and 96GB DDR5-6400 Memory Modules]( From Tom's Hardware US SK Hynix displays 48GB and 96GB DDR5-6400 RDIMMs f... [50GB/Sec with an X670E Motherboard!]( From Glenn Berry Introduction I recently bought an ASUS ROG Crossha... [Intel's Core i9-13900K Leads Single-Thread Performance Rankings]( From Tom's Hardware US Raptor shows its teeth: Core i9-13900K tops PassMa... MDX/DAX [How to use the Power BI DAX Debug Output when testing EvaluateAndLog]( From FourMoo I have seen a few great blog posts with regards to... [Introducing RANKX in DAX]( From Sqlbi RANKX is a simple function used to rank a value within a list of values. Its use is simple, but it can be a source of frustration for newbies.... [Introducing RANKX in DAX]( From Sqlbi RANKX is a simple function used to rank a value within a list of values. Its use is simple, but it can be a source of frustration for newbies. Microsoft News [Microsoft Looks to Enable Practical Zero-Trust Security With Windows 11]( From Dark Reading: Dark Reading News Analysis With the update, Microsoft adds features to allow ... PowerPivot/PowerQuery/PowerBI [Do you need Functions in Power Query?]( From Guy in a Cube You can do amazing things in Power Query! Maybe yo... [How to Calculate Compound Rate in Power BI]( From SQLServerCentral Blogs Recently I had an interesting use case where I had... [Implement Incremental Refresh for non-Query Folding sources in Power BI within a Datamart]( From MSSQL Tips In this article, I will demonstrate an approach to implementing incremental refresh on a data source that does not normally support Query Folding within the Power BI Service. [Power BI Visual Help Tooltips]( From Prologika (Teo Lachev's Weblog) Want to display visual-left hint to perplexed users that explains what your visual is supposed to reveal? Like me, you have missed the handy Power BI help tooltips feature... [How to Apply Clustering in a Scatter Plot to Visualize Segments in Power BI Desktop]( From MSSQL Tips Learn how to build scatter plots in Power BI and use the clustering option to automatically find clusters within the report data for easy visualization. [Is Your Corporate Network Hurting Power BI Report Performance?]( From Chris Webb's BI Blog Power BI report performance could be slow because your corporate network forces some traffic to http/1.1 Product Reviews and Articles [Q&A with Redgate’s CEO, Jakub Lamik]( From Blog – Redgate Software The role of the CTO in the past was to use technol... Product Upgrades and Releases [Azure SQL—Public preview updates for late September 2022]( From Azure Updates Public preview enhancements and updates released f... [Public preview: 128 vCore option for Azure SQL Database standard-series hardware]( From Azure Updates Scale up your computing power by 60% with a new 12... [SQL Server 2019 Cumulative Update #18]( From SQLBlog.org SQL Server 2019 Cumulative Update #18 is available... [Azure unmanaged disks will be retired on 30 September 2025]( From Azure Updates Migrate your data from Azure unmanaged disk storag... [Support for PostgreSQL version 11 in Azure Database PostgreSQL Single Server ends on 9 November 2024]( From Azure Updates Azure Database for PostgreSQL Single Server will e... R Language [Tips on Logging in R Packages]( From Curated SQL Jamie Owen continues a series on building a packag... SQL Server News [SQL Server 2022 Release Candidate 1 is now available]( From MS SQL Server Blog Continuing with our release cadence, we’re excited to announce the release of SQL Server 2022 Release Candidate 1. Since the first public preview in May 2022, anyone can download SQL Server... SQL Server Security and Auditing [Ledger - Automatic digest upload for SQL Server without Azure connectivity]( From MS SQL Server Blog Ledger is a new feature that offers the power of blockchain in Azure SQL Database and SQL Server 2022. We’re making the data in the SQL database verifiable using... Security News and Issues [Ransomware Attacks Continue Increasing: 20% of All Reported Attacks Occurred in the Last 12 Months - New Survey]( From Dark Reading: Dark Reading News Analysis Survey of over 2,000 IT pros revealed that a quart... [Leaking Screen Information on Zoom Calls through Reflections in Eyeglasses]( From Schneier on Security Okay, it’s an obscure threat. But people are res... [Malicious Apps With Millions of Downloads Found in Apple App Store, Google Play]( From Dark Reading: Dark Reading News Analysis The ongoing ad fraud campaign can be traced back t... [Leaking Passwords through the Spellchecker]( From Schneier on Security Sometimes browser spellcheckers leak passwords: When using major web browsers like Chrome and Edge, your form data is transmitted to Google and Microsoft, respectively, should enhanced spellcheck features be enabled. Depending... T-SQL and Query Languages [When are Non-Updating Updates Treated Like Regular Updates?]( From Michael J. Swart Takeaway: I look at different features to see whet... [How to Add a Column to a SQL Server Table]( From MSSQL Tips In this article, learn how to add a new column to an existing SQL Server table using the SSMS GUI or by using T-SQL to add the column. [Computing the modulus from very large numbers]( From Sunday morning T … and what of this all has to do with IBAN numbers. The modulus is the remainder of a division of two integers*. Suppose you divide 12 by 4,... [Fun With KQL – DateTime_Part]( From Arcane Code Fun With KQL - DateTime_Part [Rethinking SQL Explicit Transactions]( From MSSQL Tips This article looks at a simple example of using explicit transactions when modifying data in SQL Server tables. Tech News [Google Shutting Down Stadia Game Streaming Service]( From Tom's Hardware US Google is shutting down its Stadia game streaming ... [Understaffing a Major Concern for IT Pros: Report]( From IT Pro - Microsoft Windows Information, Solutions, Tools Half of the respondents to SolarWinds' survey of I... [How To Dual Boot Linux and Windows 11]( From Tom's Hardware US Windows and Linux co-existing on the same machine.... [Samsung Fails Consumers in Preventable Back-to-Back Data Breaches, According to Federal Lawsuit]( From Dark Reading: Dark Reading News Analysis Company unnecessarily collected consumers' personal data and failed to safeguard it, suit alleges, leading to two back-to-back data breaches. [September Patch Tuesday Updates Cause Group Policy Issues on Windows PCs]( From Petri IT Knowledgebase Microsoft has acknowledged a new issue with the recent Windows... The Lighter Side [Roccat Vulcan II Mini Review: So Pretty, Colorful, and Bright I can Almost Overlook the Software]( From Tom's Hardware US The Vulcan II Mini is all pretty lights, not enough (software) support. [Watch the moment NASA’s DART spacecraft crashed into an asteroid]( From Technology Review Feed - Tech Review Top Stories NASA is celebrating the success of humanity’s first test of a planetary defense system: crashing a spacecraft into an asteroid in order to change its orbit. NASA’s Double Asteroid... Tools for Dev (SSMS, ADS, VS, etc.) [SQL Server Community Tools: How I Log sp_WhoIsActive To A Table]( From Erik Darling Data Been There A lot of the code to do this is in the... [SQL Server Community Tools: How I Use sp_Blitz]( From Erik Darling Data Elder Gods For the last week of the series, I’m going to talk about the Blitz scripts. On top of using them for a hell of a long time, I’ve... Virtualization and Containers/Kubernetes [Using the Dedicated Administrator Connection with SQL Server in a Docker Container]( From The SQL Herald (Joey D'Antoni) I use a Mac (Intel, you can only run SQL Server on Edge on Apple chips) as my primary workstation. While I have a Windows VM locally, and several...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -