Deaths in the Family

Database Weekly for December 18, 2021 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  Tell Your Loved Ones You Care The Data Platform community lost a couple of people this week. Euan Garden and Dean Vargas. These were good people. They're going to be sorely missed. While I wanted to say something profound about them, I don't think I can do them justice. They were both simply good. The kind of people you want to be around. The kind of people you want to emulate. I'm not sure what else I can add to that. Instead, I want to encourage you to cherish those around you that you care for. Let them know you care. It's sad, and more than a little horrifying, to say, but you might not get a second chance. Me, I'm off to give my wife another hug. She's been getting a lot of those this week. 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 [Reporting on Changes Made by Flyway Migration Scripts]( Phil Factor demonstrates some PowerShell tasks that will produce a high-level overview, or narrative, of the main differences in the metadata between two versions of a database, during Flyway Teams migrations. [A Database DevOps Workflow Using Redgate Deploy]( Tony Davis describes a typical database development cycle and deployment pipeline supported by Redgate Deploy. It allows branch-based database development, using disposable databases (clones) and version control tools, promotes continuous integration and testing of changes and automates the build and deployment processes so that they are repeatable, fast and reliable. [Did you know SQL Monitor supports Azure databases, too?]( SQL Monitor allows you to bring your whole estate into a single monitoring landscape that has a consistent interface, whether you have an all-Azure environment, or, more likely, a mixed database environment. Find out more, here! AI/Machine Learning/Cognitive Services [Using AI Insights in Power BI]( From MSSQL Tips In this article we look at how to use the Power BI... [Revisit Top AI, Machine Learning And Data Trends Of 2021]( From IT Pro - Microsoft Windows Information, Solutions, Tools In a year that felt far from normal, data manageme... Administration of SQL Server [Why Should You Patch SQL Server?]( From Glenn Berry Introduction As I look at SQL Server instances “... [How to create Linked server from SQL Server to Azure SQL Database]( From MS SQL Server Blog Here in this blog, we are going to demo how to c... [SQL Queries in SQL Server – a beginner’s guide]( From SQLShack Introduction Creating SQL Queries is a straightfor... [CTE to Find Dates in a Range]( From Steve Stedman Here is a quick CTE that can be used to generate a... [How SQL decides how much procedure cache and how much buffer cache to use.]( From DCAC There are two main types of cache which SQL Server... [Easy way to read XML execution plans.]( From DCAC A great way to easily read the XML execution plan ... [SQL Server GETDATE () function and its use cases]( From SQLShack This article will discuss an overview and use case... [Challenge: Find the slow down–answer]( From Ayende @ Rahien I asked about a slow piece of code and why it is so slow. The answer is pretty simple, I messed up, take a look at this piece of... [In Short: ACID]( From Ayende @ Rahien  Azure Databricks, Spark and Snowflake [Advent of 2021, Day 14 – Spark SQL query hints and executions]( From TomazTsql Series of Apache Spark posts: Dec 01: What is Apa... Azure SQL Managed Instance [SQL Managed Instances – Cross Instance?]( From SQLServerCentral Blogs There is a setting / feature in Managed Instance w... [Getting Started with Log Replay Service for Azure SQL Managed Instance]( From The SQL Herald (Joey D'Antoni) Recently, I’ve started on a project where we are migrating a customer to Azure SQL Managed Instance, which now supports a few different migration paths. You can simply backup... Career Growth and Certifications [How to Stand Out and Gain Followers on Social Media]( From AndyLeonard.blog() How’s that for click bait? Does Unsolicited Stuf... Community Interests [The Chili Shirt–Memories of Euan Garden]( From SQLServerCentral Blogs Early on in the history of SQL Server Central, we ... Computing in the Cloud (Azure, Google, AWS) [Linking a Virtual Machine with Azure Active Directory]( Microsoft has made it possible to integrate Azure Active Directory with Virtual Machines. In this post, Dennes Torres walks you through the steps to set it up. [Remote desktop access for AWS RDS SQL Server with Amazon RDS Custom]( From SQLShack This article will explore AWS RDS SQL Server with ... DMO/SMO/Powershell [Fun With PowerShell Classes – The Basics]( From Arcane Code Introduction In the last few posts we looked at th... [How to check SSL encryption is enabled on SQL Server with Powershell]( From SQLServer-DBA.Com An easy way to find if SQL Server has SSL enabled [Fun with PowerShell Module Layout]( From The lonely Administrator As I’ve been working on my new PowerShell projec... Data Mining / Data Analysis [Is it really better to give than to receive? Data science says yes]( From AllAnalytics Active gratitude is the feeling you get when a str... [Holiday fun: Data science things]( From AllAnalytics It's that time of year again where I get to blend ... [Best Data Mining Tools & Software]( From Past News - RSS Feeds Data mining tools are enjoying a dramatic increase... Database Design, Theory and Development [7 Factors to Consider When Deploying a Modern Data Estate]( From Dataversity The abilities of an organization towards capturing... [How to Assert Database State?]( From Enterprise Craftsmanship Today, we’ll discuss a question that relates to ... DevOps and Continuous Delivery (CI/CD) [Automation Pros and Cons for Remote Team Collaboration]( From IT Pro - Microsoft Windows Information, Solutions, Tools Automation can help hybrid workforces run smoothly... [2021 State of Continuous Delivery Report Highlights DevOps Challenges]( From IT Pro - Microsoft Windows Information, Solutions, Tools CD Foundation’s report reveals how ubiquitous De... ETL/SSIS/Azure Data Factory/Biml [Documenting an SSIS Lift and Shift Project]( From AndyLeonard.blog() I was honored to work on a cool SSIS lift and shif... [Connecting to HubSpot from Azure Synapse Analytics or Azure Data Factory]( From Cathrine Wilhelmsen In this post, I describe how to create a linked se... PostgreSQL [Azure Database for PostgreSQL – Hyperscale (Citus): New toolkit certifications generally available]( From Azure Updates New Toolkit certifications are now available on Azure Database for PostgreSQL – Hyperscale (Citus), a managed service running the open-source Postgres database on Azure. PowerPivot/PowerQuery/PowerBI [Avoid Parameter Error when refreshing a Power BI partition]( From Guy in a Cube Ever run into a Parameter error when trying to ref... [5 Power Apps Functions You Should Know]( From MSSQL Tips Learn about different functions you can use in Pow... [Dataverse + Power BI: What you didn’t even know you needed!]( From Guy in a Cube You've heard about Microsoft Dataverse but haven't... [Simulating Slow Data Sources In Power BI]( From Chris Webb's BI Blog As a postscript to my series on Power BI refresh timeouts (see part 1, part 2 and part 3) I thought it would be useful to document how I... Security News and Issues [Log4Shell: The Big Picture]( From Dark Reading: Dark Reading News Analysis A look at why this is such a tricky vulnerability and why the industry response has been good, but not great. [Cybersecurity: The long view]( From Technology Review Feed - Tech Review Top Stories Thank you for joining us on “The cloud hub: From... [Why Log4j Mitigation Is Fraught With Challenges]( From Dark Reading: Dark Reading News Analysis The Log4j flaw exists in a component that is not always easy to detect and is widely used beyond an organization's own networks and systems. [CDOs Can Lead Their Organizations in the Successful – and Ethical – Use of Data]( From Dataversity Data plays a central role in digital transformatio... [‘Tis the Season to Be Wary]( From Dataversity ‘Tis the season to be jolly. By now, those words... T-SQL [How to Create a FOR Loop in SQL Server]( From MSSQL Tips Learn different ways to create FOR Loops using T-S... [SQL JOIN Types with Examples]( From MSSQL Tips In this article we take a look at the different ty... Tech News [The Soviets turned the Volga River into a machine. Then the machine broke.]( From Technology Review Feed - Tech Review Top Stories You can find Dubna, a small town three hours away ... [A momentous year for Redgate Software]( From Simple Talk December is often a time of reflection, and this y... [How to Prevent Physical Security Nightmares in Edge Computing]( From IT Pro - Microsoft Windows Information, Solutions, Tools With edge computing, guaranteeing physical device ... [Looking Back at the Top Cloud Computing Trends in 2021]( From IT Pro - Microsoft Windows Information, Solutions, Tools One thing 2021 has shown us is the cloud market is... [The internet runs on free open-source software. Who pays to fix it?]( From Technology Review Feed - Tech Review Top Stories Right now, Volkan Yazici is working 22 hour days f... Tools for Dev (SSMS, ADS, VS, etc.) [Popular extensions available on Azure Data Studio]( From MSSQL Tips There are a number of extensions available for Azu... Virtualization and Containers/Kubernetes [Placement polices now generally available for Azure VMware Solution]( From Azure Updates Placement policies enable admins to specify constr...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -