Database Weekly for October 29, 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
 Friendship and Your Career [PASS Data Community Summit]( is coming up like an out of control freight train. Another couple of weeks and it'll be here. I'm excited about it every year and I really hope to see you there. Please, consider this a personal invite to say hi if you see me around. I'm bringing all this up because I've been incredibly lucky in the friendships I built with people I met at Summit. I want to take a moment to talk about the importance of friendship in your career. On one level, you could say that we're all in competition for the same jobs. It's not something I believe, but there are those who do. Then, there's another idea. While, sure, there's a little competition locally, maybe a fight for a promotion or a cool project, there is way more work out there than those of us who are even remotely qualified can handle. What's more, with this constantly shifting technology landscape, even if today we're qualified, tomorrow we might not be. So, we're not in competition. In fact, the very best thing we can do for ourselves and our careers, and I'm talking pure selfishness here, is to make a few friends in the industry. Why? Because you can't learn it all. You can't. However, having a bunch of friends who also work in the industry, you've got resources for the stuff you don't know. Sure, you can post questions on the forums (I regularly haunt them, trying to help out) and you'll probably get an answer. Maybe use the #sqlhelp or #pghelp hashtags on Twitter to get a quick answer. But, a friend can give you an answer even quicker. Plus, be around for follow-up questions. Heck, even more important, they can be a shoulder to cry on, a mentor, a sounding board for ideas, all these things. Further, you can help them with all of the same. That's what friends do. As I say, I've made some incredible friendships through my years of involvement at the PASS Data Community Summit. I've also made a few at SQLSaturday, Techorama, DataMinds Connect, SQL Bits, and other events, all around the world. If you can't make it to Summit, make it to another event, even a local meetup. While there, talk to people (yeah, I know). Make some friends in this industry. It'll be good for you. It'll be good for them. It'll be good for all of us. I truly believe a rising tide lifts all boats. The more we connect with one another and share, the better off we all are. Grant Fritchey [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 [Backing up MySQL Part 1: mysqldump]( sql AI/Machine Learning/Cognitive Services [Machine learning could vastly speed up the search for new metals]( From Technology Review Feed - Tech Review Top Stories Machine learning could help develop new types of m... [Responsible AI has a burnout problem]( From Technology Review Feed - Tech Review Top Stories Margaret Mitchell had been working at Google for two years before she realized she needed a break. âI started having regular breakdowns,â says Mitchell, who founded and co-led the... Administration of SQL Server [Quickly Evaluate SQL Server Best Practices with Invoke-SqlAssessment]( From MSSQL Tips Learn how to use the PowerShell Invoke-SqlAssessme... [Memory Grant Feedback: Persistence and Percentile Grant]( From Microsoft SQL Server Blog Part of the SQL Server 2022 blog series. Memory grant feedback (MGF) is an existing feature in SQL Server, with two critical improvements available in SQL Server 2022: feedback persistence,... [SQL Server Registered Servers]( From SQLServerCentral Blogs Query multiple SQL Server instances at one time! Thanks for watching! Kevin3NF Follow @Dallas_DBAs The post SQL Server Registered Servers appeared first on DallasDBAs.com. The post SQL Server Registered Servers appeared... Azure Databricks, Spark and Snowflake [Snowflake DDL and DML Statements in Transactions compared to SQL Server - Part 2]( From MSSQL Tips In this article, we look at running DDL and DML st... [Snowflake â Search Optimisation Service]( From SQLServerCentral Blogs Rarely do I say I love a feature across any technologies I have come across, in the snowflake world this is right up there. I tend to find this... The... Azure SQL [The-connection-is-broken-and-recovery-is-not-possible-()-and-other-errors-4891-1326-2250-13800-21036]( From Azure Database Support Blog Issue: When trying to generate a snapshot, the job is failing with the error: Error 1- "The connection is broken and recovery is not possible. The connection is marked by the... [How to identify suitable SKUs for Azure SQL Database, Managed Instance (MI), or SQL Server on Azure VM]( From SQLShack The database migration from on-premises to Azure cloud can be complicated in choosing the best SKU for Azure SQL Database, Managed Instance (MI), or SQL Server on Azure VM....
Azure SQL Managed Instance [Lesson Learned #244: No such host is known connecting to Azure SQL Managed Instance Private Endpoint]( From Azure Database Support Blog Today, I worked on a service request where our cus... Community Interests [The SQL Server Central Casino Party #SeattleSummitMoments]( From SQLServerCentral Blogs Redgate started a new marketing thing and I like i... [Aha moments at PASS Data Community Summit]( From Blog â Redgate Software Anyone who has attended Summit will recount tales ... [Azure Data Community Newsletter Sept/Oct 2022]( From Azure SQL Connect with other members of the Azure Data Community on LinkedIn group.  Share how you got started speaking by joining the effort, #NewStarNovember  The organizers of New Stars of Data want... Computing in the Cloud (Azure, Google, AWS) [How to Migrate a SQL Server Database to the Google Cloud using Cloud SQL]( From MSSQL Tips In this article, we look at how to migrate a SQL S... [AWS Week in Review â October 24, 2022]( From AWS News Blog Last week, we announced plans to launch the AWS As... [Quickly Deploy SQL Server on Linux using AWS Launch Wizard]( From MSSQL Tips Learn how to quickly deploy a SQL Server on Linux (standalone) on Ubuntu (Linux) using AWS Launch Wizard. [Moving to Distributed Systems Can Ease the Path to Cloud Infrastructure]( From Dataversity Companies plan to increase their spending on cloud infrastructure but may be slowing down on taking a âcloud-firstâ approach. These are two of the conclusions outlined in the Enterprise... [Big 3 Public Cloud Providers Highlight Cost Control Capabilities]( From IT Pro - Microsoft Windows Information, Solutions, Tools Amazon, Microsoft, and Google all reported quarterly cloud earnings, emphasizing the ability of the cloud to reduce operating costs. Conferences, Classes, Events, and Webinars [Join a community like no other at Summit]( We're only we couple of weeks away until PASS Data Community Summit takes place, and there's still time to register for an in-person or online pass, and unlock access to over 300 world-class sessions. Join liked-minded attendees at the year's largest hybrid data platform conference. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE Register now [Expert-led PASS Data Community Summit Pre-cons]( Spaces are still available for next month's PASS Data Community Summit pre-conference sessions - but theyâre booking up fast! Choose from 18 deep-dive full day pre-cons, featuring some of the best minds in the data industry, covering everything from technical processes to personal growth. Register now. [Sign up to PASS Data Community Summit 2022]( There's still time to register for Summit and unlock access to over 300 sessions. Join peers and industry leaders in the data community homecoming. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE. Register now. DMO/SMO/Powershell [How to Use a PowerShell Foreach Loop]( From Petri IT Knowledgebase The PowerShell Foreach statement is useful when wo... Data Mining / Data Analysis [Please Consider Your Business Users When Selecting an Analytics and Data Search Tool]( From Dataversity Business users are business professionals who have... [Poker, risk and the game of life: An interview with Liv Boeree]( From AllAnalytics Liv Boeree answers our questions about the game of... [Talking mental health, analytics and whole person care with Mayim Bialik]( From AllAnalytics Question: This neuroscientist and SAS Explore host is known for appearing on "Blossom," "The Big Bang Theory" and "Jeopardy." Answer: Who is Mayim Bialik, Ph.D.? Today, instead of Bialik... Data Privacy, Compliance, and Governance [Strategies for Data Intelligence, Data Governance and Data Operations]( From Journey to SQL Authority with Pinal Dave Data intelligence and governance is at the heart o... Data Warehousing [Developing Agile Data Warehouse Architecture Using Automation]( From Dataversity In the past, designing and developing a robust data warehouse that satisfied the need for timely and effective business intelligence (BI) was an overwhelmingly difficult task, as it required significant time,... Database Design, Theory and Development [NOBODY UNDERSTANDS NORMALIZATION 2 (sms)]( From Database Debunkings Note: In "Setting Matters Straight" posts I debunk... [Build Confidence in Your Data with Ledger Databases and Tables | Data Exposed: MVP Edition]( From Azure SQL Youâve done all the work to build confidence in ... [Why Low-Code/No-Code App Development Has Inherent Security Risks]( From IT Pro - Microsoft Windows Information, Solutions, Tools The security risks of low-code/no-code are real an... DevOps and Continuous Delivery (CI/CD) [MLOps: Why Now for Open Source]( From Dataversity According to Gartner, a whopping 47% of machine l... [Overcome Cloud-Native App Development Challenges with CI/CD Best Practices]( From IT Pro - Microsoft Windows Information, Solutions, Tools Here are practical ways to improve cloud-native ap... [Maintaining a Utilities Schema in a Flyway Project]( From Product learning â Redgate Software Whatever development methodology you use, it is us... [GitLab Adds Governance, Software Supply Chain Enhancements]( From Dark Reading: Dark Reading News Analysis Developers will be able to scan for vulnerabilitie... DocumentDB/Key-Value/Graph/other NoSQL Databases [Introducing Amazon Neptune Serverless â A Fully Managed Graph Database that Adjusts Capacity for Your Workloads]( From AWS News Blog Amazon Neptune is a fully managed graph database service that makes it easy to build and run applications that work with highly connected datasets. With Neptune, you can use... Hardware [Raspberry Pi Powers DIY Headless M8 Synthesizer]( From Tom's Hardware US Maker Ricardo has built a custom synthesizer using... [PicoBerry is a Tiny Raspberry Pi Compute Module 4 Carrier Board]( From Tom's Hardware US A tiny Compute Module 4 carrier board has emerged,... [TikToker Improves CPU Cooling by Adding Salt to Thermal Paste]( From Tom's Hardware US An enthusiast with the handle @mryeester found tha... [vSphere 8 CPU Topology Device Assignment]( From frankdenneman.nl There seems to be some misunderstanding about the ... [TSMC Reportedly Halts Shipments to China's GPU Specialist, Biren]( From Tom's Hardware US Biren's first GPUs can challenge Nvidia's A100 GPU... [Collaboration and Communication Technology Sparks Enterprise Concern]( From IT Pro - Microsoft Windows Information, Solutions, Tools A survey by Theta Lake found that unmonitored comm... [FreeSync vs. G-Sync 2022: Which Variable Refresh Tech Is Best?]( From Tom's Hardware US We compare FreeSync versus G-Sync to find out whet... Oracle/PostgreSQL/MySQL/other RDBMS [Managing schema in Azure Database for PostgreSQL using pgAdmin]( From SQLShack In this article, we will learn how to use the feat... [Getting started with procedures in Azure Database for PostgreSQL]( From SQLShack In this article, we will learn how to work with pr... [Public preview: Read replicas for Azure Database for PostgreSQL Flexible Server]( From Azure Updates Read replicas are used to offload read workloads a... [Oracle optimizer Or Expansion Transformations]( From Simple Talk The previous instalment of this series examined ag... Performance Tuning SQL Server [SQL Server For Beginners: SQL Server Query Plans]( From Erik Darling Data SQL Server Query Plans Going Further If this i... [How to Analyze Query Plans in Azure Data Studio | Data Exposed]( From Azure SQL Azure Data Studio has introduced query plan viewer functionality within the core application â you no longer need to install an extension to view and analyze plans. In this... [Improve Performance and Management of Large Table by Converting to Partitioned View in SQL Server]( From MSSQL Tips In this article, we will walk through the steps of taking a very large SQL Server table and converting it to a partitioned view to help improve management and... PowerPivot/PowerQuery/PowerBI [Why Power BI totals might seem inaccurate]( From Sqlbi A common question is why Power BI totals are inacc... [Why Power BI totals might seem wrong]( From Sqlbi A common question is why Power BI totals are inacc... [Introducing the Measure Killer (External Tool) for Power BI!]( From Havens Consulting Learn about an up and coming external tool that ma... [Power BI Development Best Practices]( From RADACAD Regardless of the job function, you have with Powe... [Make Q&A more effective in Power BI]( From Guy in a Cube Most struggle with getting Q&A to be effective... [Does it matter where your Power BI reports are deployed?]( From Guy in a Cube Where to deploy your Power BI Report? My Workspace? Regular Workspace? What about Apps? Adam breaks it down to help you make the right choice and understand why it... Product Upgrades and Releases [Microsoft Introduces the On-Premises Unified Update Platform for Seamless Windows Updates]( From Petri IT Knowledgebase Microsoft has announced a public preview of the Un... Professional Development [On Experience]( From AndyLeonard.blog() The following images (from FreeCell) illustrate a ... [Getting Help Online]( From Scary DBA (Grant Fritchey) I spend a lot of time in the forums on various web... [how do I give unsolicited feedback to a colleague?]( From Storytelling with Data  ... R Language [Editing Camera Image Metadata with R]( From Curated SQL Neil Saunders has some trail cameras: The camera m... Security News and Issues [HR Departments Play a Key Role in Cybersecurity]( From Dark Reading: Dark Reading News Analysis A more secure organization starts with stronger al... [Threat Groups Repurpose Banking Trojans into Backdoors]( From IT Pro - Microsoft Windows Information, Solutions, Tools Ursnif, a one-time banking Trojan also known as Go... [Open Source Is Just the Tip of the Iceberg in Software Supply Chain Security]( From Dark Reading: Dark Reading News Analysis As more of the software stack consists of third-pa... [Why Retail Stores Are More Vulnerable Than Ever to Cybercrime]( From Dark Reading: Dark Reading News Analysis When we think about cybercrime and retail it is na... [The âAutonomous SOCâ Is a Pipe Dream]( From IT Pro - Microsoft Windows Information, Solutions, Tools The autonomous SOC will never be a reality because technology is simply not capable of human ingenuity. [Big Changes are Afoot: Expanding and Enhancing the Have I Been Pwned API]( From Troy Hunt Presently sponsored by: Varonis. Reduce your SaaS ... [Critical Vulnerability in Open SSL]( From Schneier on Security There are no details yet, but itâs really important that you patch Open SSL 3.x when the new version comes out on Tuesday. How bad is âCriticalâ? According to OpenSSL,... Software Development [Microsoft starts shipping its Windows on Arm device for developers: Windows Dev Kit 2023](RSSbaffb68) From All about Microsoft Blog RSS | ZDNet Microsoft's 'Project Volterra' $599 device for dev... T-SQL and Query Languages [The Rivalry Between SELECT INTO and INSERT INTO]( From Callihan Data Data can be inserted into one temp table from anot... [What can you do with a SELECT statement without a FROM clause?]( From SQLStudies Some people have shower thoughts, I have 1am thoug... [Using GENERATE_SERIES function to generate a series of Dates]( From Hasan Savran   GENERATE_SERIES function is introduced in SQ... [SQL LIKE Statement for Various Text Patterns]( From MSSQL Tips In this article, we look at how to use SQL LIKE statement to find various text patterns contained within a set of text along with many different examples of... Tech News [The US Navy wants swarms of thousands of small drones]( From Technology Review Feed - Tech Review Top Stories The US Navy is working on ways to build, deploy, a... [Accentureâs Greg Douglass on the Growth of the Chief Transformation Officer]( From Past News - RSS Feeds I spoke with Greg Douglass, Global Lead, Technolog... [Everything dies, including information]( From Technology Review Feed - Tech Review Top Stories Everything dies: people, machines, civilizations. ... [Raspberry Pi Drives Pharmacy Sign Demo Video]( From Tom's Hardware US This team uses a Raspberry Pi to power a custom de... [IT Leaders Dissatisfied, Looking for New Opportunities]( From IT Pro - Microsoft Windows Information, Solutions, Tools IT departments have been performing heroically since the pandemic, but even more could have been done if IT decision-makers had better support, a new report finds. [2023 Predictions: Cyber Asset Management to Future-Proof IT Infrastructure]( From Dataversity Now more than ever, business success relies on an agile cyber asset management strategy. Over the past year, inflation, supply chain delays, cybercrime, transitions to remote work, and the... [Will lab-grown meat reach our plates?]( From Technology Review Feed - Tech Review Top Stories This article is from The Checkup, MIT Technology Reviewâs weekly biotech newsletter. To receive it in your inbox every Thursday, sign up here. Would you eat lab-grown meat? Plenty... The Lighter Side [How scientists want to make you young again]( From Technology Review Feed - Tech Review Top Stories A little over 15 years ago, scientists at Kyoto Un... [How to see inside a tornado]( From Technology Review Feed - Tech Review Top Stories Tornadoes form in 10 seconds or less. So Howie Blu... [Ten to One founder aims to change peopleâs perception of rum]( From Technology Review Feed - Tech Review Top Stories When you think of rum, what comes to mind? A straw... Tools for Dev (SSMS, ADS, VS, etc.) [SSMS Performance Dashboard for Managed Instance shows different percent of CPU usage]( From Azure Database Support Blog Symptom: When using Performance Dashboard on Azu... Virtualization and Containers/Kubernetes [AWS Batch for Amazon Elastic Kubernetes Service]( From AWS News Blog Today Iâm pleased to announce AWS Batch for Amaz... [Top 10 Kubernetes Security Risks Every DevSecOps Pro Should Know]( From Dark Reading: Dark Reading News Analysis The mission to run any containerized application o...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -