The Case for Patching (2022-08-20 DBW)

Database Weekly for August 20, 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  The Case for Patching Recently I was testing a feature in SQL Server on 2017 and 2019. There was supposed to be an improvement across versions, but I didn't see it. Then I realized that I was on SQL Server 2019 CU 2 on my laptop, and [the current CU is 17](. I took a few minutes to download that and install it. I have often been a lagging patcher in production environments, often looking to stay a CU or two behind, depending on my workload. SQL Server has been a very security -table platform, so that's often worked well, though there are security updates at times. For those, I usually prioritize a patch getting applied. Windows (Linux, MacOS, etc.) tends to get patched more often than other software, especially by administrators. At least on desktops. Servers sometimes lag a bit, which can be a problem. I saw this week that [a lot of attacks in 2022 Q2 were for a vulnerability Microsoft patched in Sep 2021]( but hadn't gotten all their customers to apply the patch. That situation was a problem early in my career with many vulnerabilities, and it's still apparently an issue now. If you're wondering how big a deal patching can be, remember the Equifax hack? This occurred because [administrators hadn't patched a system](. Whether it's a host OS, a database platform, or some other software system, it's important that you keep somewhat current with patches. We never know when vulnerabilities will appear, and honestly, for most of us, we can't spend the time tracking every piece of software and the various vendor disclosures. We can, however, patch relatively quickly. While I don't expect that most, or even many, people will patch within a month, I do think that delaying six months is probably a bit long. That being said, I need to check a few of my servers and make sure my admins are keeping them up to date. 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 [Performance Testing Databases with Flyway and PowerShell]( Performance tests are central to the quality of the database changes we deliver because they ensure that any business process that accesses the database continues to return its results in an acceptable time. When Flyway creates a new version of the database, it is the ideal time to run these performance checks. [Running Unit and Integration Tests during Flyway Migrations]( In this article I'll give a practical example of developing a database, with Flyway, in such a way that it is automatically tested with whatever unit tests and integration tests you specify whenever you migrate the branch you're working on to the next version. If a test fails, you can work out why, undo the migration and then try again. AI/Machine Learning/Cognitive Services [AI vs. ML: Artificial Intelligence and Machine Learning Overview]( From Past News - RSS Feeds The idea that machines can replicate or even excee... [AI will reshape health care—we will determine if it’s for better or worse]( From Technology Review Feed - Tech Review Top Stories Thank you for joining us on “The cloud hub: From... Administration of SQL Server [Rebuild system databases for SQL Server on Linux and Windows]( From SQLShack This article explores the process for rebuilding s... [Distributed Replay: The Little Engine That Almost Could]( From Grant Fritchey Honestly, sincerely, no kidding, I love Distribute... [Attaching All SQL Server Data Files in a Single Directory]( From Curated SQL David Fowler migrated a bunch of databases: Have y... [Successful Backup Job on a Dropped Database]( From Callihan Data I’m a big fan of Ola Hallengren’s SQL Server maintenance scripts and would recommend that anyone working with SQL Server check them out. They have served me well over... [Managing memory-optimized file groups of SQL Database]( From SQLShack This article explains how to manage a memory-optimized filegroup of SQL Database. The memory-optimized filegroup contains the memory-optimized tables and table variables. I have written two articles that explain... Azure SQL [SQL Insider Series: Protect your sensitive data using Azure SQL DB | Data Exposed]( From Azure SQL  [How to Capture the Actual Execution Plan in Azure SQL Database]( From Azure Database Support Blog How to capture the actual execution plan of a query in Azure SQL Database This article provides you with steps about how to capture the actual execution plan of a... Azure SQL Managed Instance [How to migrate a database between two SQL Managed Instances in Azure]( In this post I’m going to show a very simple way to migrate a database between two SQL Server managed Instances in Azure. I’m not a big fan of bacpac files (although I work with it when necessary) so I’ll use a different approach here. Azure Synapse (SQL Data Warehouse and Data Lake) [Getting started with Azure Synapse Lake Database and Lake tables]( From SQLShack This article will get you started with Azure Synap... [Get started with SPARK in Azure Synapse Analytics]( From Guy in a Cube Using Spark in Azure Synapse Analytics opens up a lot of possibilities to work with your data. Venk joins us to get you started with setting it up and... Career, Employment, and Certifications [IT Job Market Still Strong, But Economic Headwinds Complicate Picture]( From IT Pro - Microsoft Windows Information, Solutions, Tools Despite talk of an impending recession and hiring ... [Your Turn: I’m Not Answering These 13 Office Hours Questions]( From Brent Ozar Unlimited Normally, after I do a round of Office Hours of going through the questions that got posted at I answer the highly upvoted ones and then clear the... [presenting takes practice]( From Storytelling with Data If you will be speaking to others about something that matters: take time to plan and practice. In a setting where you’ll be presenting something formally, prepare by mock-delivering... [Getting a Certification Versus Getting a Certification You Can Use]( From IT Pro - Microsoft Windows Information, Solutions, Tools Some tech certifications can actually work against you. Here are tips on pursuing the certifications that will help you advance your career. [The book that made me love goal-setting]( From SQLServerCentral Blogs Pete Wilkinson’s book “Unstoppable” finally made visualizations and goals make sense to me. Here's a review! The post The book that made me love goal-setting appeared first on Jen McCown. The post... Computing in the Cloud (Azure, Google, AWS) [Infra Cost Optimisation In The Cloud – Practical Design Steps For Architects and Developers]( In part 2 of this multi-part blog series, I am going to cover, as per the title 'Infrastructure', but that's a pretty wide remit. Stay tuned for further posts where I cover more progressive infrastructure topics, but in this post, I will cover two core building blocks that constitute the largest amounts of most cloud bills, compute and storage. [Shifting from cloud first to cloud everywhere in financial services]( From Technology Review Feed - Tech Review Top Stories Thank you for joining us on “The cloud hub: From... [How Grillo Built a Low-Cost Earthquake Early Warning System on AWS]( From AWS News Blog It is estimated that 50 percent of the injuries caused when a high magnitude earthquake affects an area are because of falls or falling hazards. This means that most... DMO/SMO/Powershell [PowerShell Scripts Need Tests Too!]( Most of you probably know that I’m a big fan of automated testing and especially testing during the development process. It significantly improves the design of the code by encouraging loose coupling and high cohesion. It also provides great documentation and increases the confidence of anyone who needs to change the code in the future (this includes future you)! [How to implement your PowerShell 7 Scripts in Task Scheduler]( So you’re already working with the latest PowerShell version and wondering how to automate your PowerShell 7 scripts with the task scheduler? Yes? Ok, then stay tuned I will show you two ways to include a PS7 script in the task scheduler. Let’s dive in. [Creating TAIL on Windows for Text Files]( From SQLServerCentral Blogs UPDATE: Article changed based on the comment from ... [Deleting Power BI datasets using Powershell]( From TomazTsql Sample Powershell script for deleting datasets in ... [How to Use PowerShell to Navigate the Windows Folder Structure]( From IT Pro - Microsoft Windows Information, Solutions, Tools Learn these PowerShell commands to move quickly ar... Data Privacy, Compliance, and Governance [A Root-Cause Framework for Trans-Atlantic Data Privacy]( From Dataversity When the United States and the European Commission... Data Science [General chi-square tests]( From Statistical Odds & Ends In this previous post, I wrote about the asymptoti... Data Visualisation [an accessible makeover]( From Storytelling with Data  ... Data Warehousing [Data Lakes Are Dead: Evolving Your Company’s Data Architecture]( From Dataversity You know you’re not getting the most out of your... [Not Your Kimball’s DW]( From Prologika (Teo Lachev's Weblog) BI practitioners, myself included, have been follo... Database Design, Theory and Development [Why MAX Data Types Are Usually A Bad Choice For SQL Server Columns]( From Erik Darling Data Easy Rider When you’re trying to figure out how to store string data, it often seems easiest to just choose an extra long — even MAX — data type to... ETL/SSIS/Azure Data Factory/Biml [Confidence and SSIS Catalog as Code]( From AndyLeonard.blog() That’s what we sell at Data Integration Lifecycl... [One Way to Add an Existing Data Factory to Github, Part 3]( From AndyLeonard.blog() This is part of a series of posts. This post focuses on using Azure Data Factory with a GitHub repository. One Way to Add an Existing Data Factory to... [One Way to Add an Existing Data Factory to Github, Part 2]( From AndyLeonard.blog() This is part of a series of posts. This post focuses on connecting an Azure Data Factory to a GitHub repository. One Way to Add an Existing Data Factory... [One Way to Add an Existing Data Factory to Github, Part 1]( From AndyLeonard.blog() This is part of a series of posts. This post focuses on creating a GitHub account and repository. One Way to Add an Existing Data Factory to Github, Part... Hardware [Samsung: 1TB DDR5 RAM in 2024, DDR5-7200 in 2025]( From Tom's Hardware US Samsung envisions 1TB DDR5 modules to arrive in 20... [Gigabyte Announces Aorus PCIe 5.0 SSD Up To 12.4 GBps]( From Tom's Hardware US Gigabyte unveils its client PCIe 5.0 x4 SSD with up to 12.4 GBps throughput. [Intel Raptor Lake Specs Allegedly Exposed: Up To 24 Cores, 32 Threads]( From Tom's Hardware US An almost fully fledged Raptor Lake CPU product table highlights the evolution to expect moving from Alder Lake. Some chips seem to fare better than others across the gen-to-gen... [7-Zip Benchmark: Intel Core i9-13900K 60% Faster Compared To 12900K]( From Tom's Hardware US A new 7-Zip benchmark result reveals a 60% perform... [Intel Launches NUC 12 Pro 'Wall Street Canyon' Mini PCs]( From Tom's Hardware US Intel finally unveils its business-oriented NUC 12 Pro 'Wall Street Canyon' compact PCs. MDX/DAX [Different filter behaviors in SUMMARIZECOLUMNS and CALCULATETABLE]( From Sqlbi We recently updated SUMMARIZECOLUMNS on DAX Guide ... [Computing sales made to customers before and after a period]( From Sqlbi How to manipulate the filter context to create a report with the sales made to a specific customer segment, before and after a selected month. Performance Tuning SQL Server [Lesson Learned #235: Finding how Indexed Views impact in my database update performance?]( From Azure Database Support Blog Today, we worked on a very interesting service req... PowerPivot/PowerQuery/PowerBI [Power BI Paginated Report – Perfect for Printing]( From RADACAD If you want to print a Power BI report and have a ... [Get creative with buttons in Power BI!]( From Guy in a Cube Want to know how to create a button in Power BI th... [Using Apps and App Workspaces in Power BI]( From Guy in a Cube In this video, I introduce you to Apps and App Wor... [Calling The Power BI Enhanced Refresh API From Power Automate, Part 2: Refreshing Specific Tables And Partitions]( From Chris Webb's BI Blog Refresh specific tables in your Power BI dataset u... [Computing sales to specific customers before and after a time period]( From Sqlbi This article shows how to manipulate the filter context to create a report with the sales made to a specific customer segment, before and after a selected month. Many... [Calculating Work Days for Power BI Reports using NETWORKDAYS Function]( From MSSQL Tips In this article, we look at calculating working days for Power BI reports using the new NETWORKDAYS function. [Power BI Live Embedding In PowerPoint]( From Excelerator BI I first blogged about this back in October 2021 when Microsoft announced live Power BI embedding was coming to PowerPoint. Believe it or not, the ability to embed Power... [Refresh and NO DATA in my Power BI visuals???]( From Guy in a Cube Have you published your Power BI report to the service, refresh the data, and the visuals go blank? Patrick may have an answer for you. Troubleshooting refresh scenarios ... Product Upgrades and Releases [GCP Releases]( From GCP Releases BigQuery Feature You can now set default values on... [August Database Health Monitor Version Release]( From Steve Stedman The August 2022 version release of Database Health... [New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo]( From SQLServerCentral Blogs I’ve added a new parameter to my permissions scr... [Windows Authentication for Azure AD principals for SQL Managed Instance is now Generally Available]( From Azure SQL We are happy to announce the General Availability of Windows Authentication for Azure AD principals for SQL Managed Instance. We released a public preview of this feature in April 2022,... [General availability: Network security groups support for private endpoints]( From Azure Updates Network security groups (NSGs) support for private endpoints is now generally available. [Public preview: Microsoft Azure Load Testing supports private endpoints testing]( From Azure Updates With Azure Load Testing, you can now run load tests against private endpoints - endpoints deployed in a virtual network, public endpoints with access restrictions (restricting client IP addresses,... [Generally available: Hierarchical forecasting for Azure Machine Learning]( From Azure Updates Hierarchical forecasting, now generally available, offers you the capability to produce consistent forecasts for all levels of your data. [Public preview: Azure Database for PostgreSQL]( From Azure Updates The latest PostgreSQL minor versions 14.5, 13.8, 12.12, and 11.17 are available for Azure Database for PostgreSQL – Hyperscale (Citus). [Generally available: Azure Monitor Logs data export supports application insights tables]( From Azure Updates Investigate alert incidences with Azure Monitor Logs connector scoped to the exact time range of alert. Python [Lesson Learned #234: Parallel vs Single Running a Bulk Insert with Python]( From Azure Database Support Blog Today, We've been working on a service request tha... R Language [Hurst Exponent using R code]( This post explains how to estimate the Hurst exponent which indicates characteristics of a time series : mean-reversion, random walk, and trending with long memory using S&P 500 index returns. [Little useless-useful R functions – Greedy Salesman]( From TomazTsql Travelling Salesman Problem is an NP-complete prob... Replication [Considerations on Bidirectional Transactional Replication]( From Azure Database Support Blog Considerations on Bidirectional Transactional Repl... SQL Server News [Query Store is enabled by default in SQL Server 2022]( From Microsoft SQL Server Blog In SQL Server 2022, Query Store is now enabled by ... [SQL Server 2022 CTP 2.1 Improvements To Parameter Sensitive Plan Optimization]( From Erik Darling Data Hop On Your Good Foot Several weeks back, I blogg... [SQL Server 2019 Cumulative Update 17]( From Glenn Berry On August 11, 2022, Microsoft released SQL Server 2019 Cumulative Update 17. This is Build 15.0.4249.2. By Microsoft’s count, there are 38 public fixes and improvements in this CU,... SQL Server Security and Auditing [SQL Server 2022 Server Level Role Updates]( From MSSQL Tips Learn about some of the new security changes in SQL Server 2022 and the differences in roles for ##MS_LoginManager## and securityadmin. Security News and Issues [Microsoft Adds Time-Based One-Time Passcode Support to Azure AD]( From Petri IT Knowledgebase Microsoft has released time-based one-time passcod... [Most Q2 Attacks Targeted Old Microsoft Vulnerabilities]( From Dark Reading: Dark Reading News Analysis The most heavily targeted flaw last quarter was a ... [Lessons From the Cybersecurity Trenches]( From Dark Reading: Dark Reading News Analysis Threat hunting not only serves the greater good by helping keep users safe, it rewards practitioners with the thrill of the hunt and solving of complex problems. Tap into... Software Development [The Eternal Optimism of the Spotless Repository]( There is a fleeting moment in every software project when it is absolutely perfect. It is the time between clicking “New” and “Save” in your code editor. In that brief interval, limitless potential and beauty. In every moment that follows, compromise and doubt (but working software, too!). T-SQL and Query Languages [Find Mismatched Data between SQL Server Tables using LEFT JOIN, EXCEPT, NOT IN and NOT EXISTS]( From MSSQL Tips In this tip we look at various ways to find mismat... [Fun With KQL – StartOf]( From Arcane Code Fun With KQL - StartOf Tech News [Tesla Brags About In-House Supercomputer, Now With 7,360 A100 GPUs]( From Tom's Hardware US Tesla is growing its Ampere GPU powered AI superco... [Leading Enterprise IT Vendors 2022]( From Past News - RSS Feeds Enterprise IT is a thriving market, remarkably so.... [Creating a HEAD utility for Windows 10]( From SQLServerCentral Blogs One of the things I did often in my first career j... [Hard Drive Quarterly Sales Volume Dropped 15% Due to Weakening Demand]( From Tom's Hardware US A new report has come in detailing a 15% drop in h... [How to Install Ubuntu on Windows Services for Linux]( From IT Pro - Microsoft Windows Information, Solutions, Tools Windows Services for Linux, which is available on Windows 10 and 11, lets users install popular Linux distributions. Here’s a quick guide for installing an Ubuntu instance. Tools for Dev (SSMS, ADS, VS, etc.) [Query Plan Viewer in Azure Data Studio]( From MSSQL Tips In this article, we look at the new features in Az... Virtualization and Containers/Kubernetes [Setting up SQL Server 2022 s3 Object Storage Integration using MinIO with Docker Compose]( From SQLServerCentral Blogs In this blog post, I’ve implemented two example ...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -