Unstuck (DBW 2024-09-28)

Database Weekly for September 28, 2024 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  Unstuck Have you ever been stuck in some area of your life? Maybe at work? That big project. Progressing in your career. The slow query that seems impossible to make faster. Learning new skills to switch careers. Maybe outside of work? The weekend home project that’s been going on for more than a few weekends… possibly a few years’ worth of weekends. Investing in a new hobby. Working to improve a strained relationship. I know I’ve been stuck (what feels like) countless times in my personal and professional life. In many ways, the last year has felt like one big quagmire of being stuck nearly any way I turn. But this week, through the unwavering help and support of friends, family, and coworkers, I was able to experience the joy of becoming unstuck at work and in life. And I have to say, it feels pretty amazing. Personally, I’ve been in a life stage that I never could have imagined would be possible before last year. It’s been a long, slow battle to fight for movement in relationships and circumstances. And finally, for the first time in more than a year, I was able to see movement in two specific ways that brought much needed encouragement. The road ahead is still filled with a lot of potholes and deep ruts, but momentum has begun to build again, and getting a few things unstuck will have made all the difference. Professionally, I’ve reached a milestone I never thought possible. Yesterday, Grant and I, along Louis Davidson and our top-notch boss, Kirsty, put the finishing touches on a special preview book about PostgreSQL fundamentals. For many years, I’ve wanted to contribute to a technical book, but it always seemed too big, and I would always get stuck just writing the proposal. But then the boss asked Grant and I to do it, and when you have seasoned pros like Grant and Louis at your side, suddenly I didn’t feel so stuck. And I have to say, it felt like a huge accomplishment as I give everything one last review yesterday before sending off the document to order a printed proof. (By the way, the initial preview edition will be available in limited quantities at PASS Summit in November, before the official first edition is made available to the public in early 2025. Come find us if you’re in Seattle to grab your copy! Better yet, register for our PostgreSQL Fundamentals pre-con on Tuesday and get your copy then!) Being stuck is no fun, and for me at least, it’s often too easy to focus on how I’m stuck and not on the path to becoming unstuck. Although I’ve known it for most of my life, getting unstuck almost always involves a caring community of family, close friends, and colleagues. If you need to see movement in something right now, lean into wherever that community is in your life. Not only will you see benefit, but they’ll be encouraged, too. Ryan Booz [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 [The Importance of Access Checks and Controls in Database Development]( This article illustrates the importance in any database development project of a 'multi-layered' approach to database access controls and security checks, based on the Principle of Least Privilege. It describes a security incident that was raised when databases related to a local development project were found to have been erroneously deployed to a remote test server. It explains the nature of the incident, what went wrong that allowed it to happen, and the measures that were put in place to prevent its recurrence. [Introducing Microsoft Keynote, Redgate Keynote, and a community star]( After meeting the stellar pre-con speakers and exploring the 5 learning pathways at #PASSDataSummit 2024, we’re excited to reveal the keynote lineup. Each day will kick off with inspiring keynotes from Microsoft, Redgate, and a special community-driven session led by industry experts. Don’t miss out on these insightful sessions designed to energize and empower you throughout PASS Summit 2024. [PASS Summit 2024: Session schedule now LIVE!]( Join over 170 global data experts offering more than 150 sessions designed for all skill levels. Explore the schedule to plan your days on-site, secure your ticket, and book your travel before prices increase. AI/Machine Learning/Cognitive Services [What Can You Do With Copilot In DAX Query View?]( From Chris Webb's BI Blog On my LinkedIn feed this morning I saw an amazing ... Administration of SQL Server [Rebuilding a SQL Server Database Transaction Log]( From SQL Undercover “Could you help me, we deleted the database’s ... [Managing Orphaned Users in SQL Server with sp_FindOrphanedUser]( From StraightPath Solutions SQL Blog Addressing orphaned users is an important piece of... [PSPO & Memory Grant Feedback (Video)]( From Deb the DBA I’m doing something new – instead of a full po... Azure SQL [A few ways to monitor performance for the geo replica of an Azure SQL Database]( From Azure Database Support Blog Azure SQL Database, one of the PaaS offerings on t... [Getting Started with Azure SQL Database – A Beginners Guide]( From John Morehouse Last Updated on September 24, 2024 by John Morehou... Cloud - AWS [Build a Background Processor with AWS Fargate and SQS]( From Simple Talk Asynchronous processing is a common pattern in mod... Conferences, Classes, Events, and Webinars [Session schedule is LIVE!]( Join over 170 global data experts offering more than 150 sessions designed for all skill levels. Explore the schedule to plan your days on-site, secure your ticket, and book your travel before prices increase. [Join Me And @Kendra_Little At @PASSDataSummit For 2 Days Of SQL Server Performance Tuning Precons!]( From Erik Darling Data Last Year Kendra and I both taught solo precons, a... DMO/SMO/Powershell [SQL Query Stats via Powershell]( From FLX SQL Sometimes, work tasks and questions that come up i... [PowerShell Screen Captures: How To Automate Screenshots in Your Scripts]( From IT Pro - Microsoft Windows Information, Solutions, Tools Learn to modify your PowerShell scripts to capture... Database Design, Theory and Development [Boosting Database Development Efficiency Using AI SQL Code Generators]( Database development has become more complex over the years due to the introduction of new data and storage formats by big data. This along with modern applications that often depend on multiple databases and APIs, plus newer data analytics and data science needs have raised the bar for database infrastructure skills. Fortunately, AI SQL code generators can automate many repetitive tasks and help you simplify database development processes that continually get more complex. ETL/SSIS/Azure Data Factory/Biml [Connecting SSIS Packages to Azure Storage]( From Andy Broadsword Migrating to the cloud can be disruptive to existi... General [Introducing Microsoft Keynote, Redgate Keynote, and a community star]( From PASS After meeting the stellar pre-con speakers and exploring the 5 learning pathways at #PASSDataSummit 2024, we’re excited to reveal the keynote lineup. Each day will kick off with inspiring keynotes from Microsoft, Redgate, and a special community-driven session led by industry experts. D MDX/DAX [Debugging DAX with DAX Query View]( From Simple Talk DAX Query View was created some time ago and it wa... [Creating custom visuals in Power BI with DAX]( From Sqlbi Create dynamic images in DAX measures to visualize... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Unleashing Data for OneLake with Mirroring in Microsoft Fabric]( From Guy in a Cube Learn how to replicate your database to Microsoft ... [How to view or track the progress of Notebook while it is running in Microsoft Fabric]( From FourMoo How to view or track the progress of Notebook whil... [Data engineering functions on large datasets in Microsoft Fabric]( From TomazTsql Data engineering and even simple data wrangling fu... Oracle/PostgreSQL/MySQL/other RDBMS [Creating Vector Indexes in Oracle]( From Curated SQL Brendan Tierney continues a series on vector storage: Building upon the previous posts, this post will explore how to create Vector Indexes and the different… PostgreSQL [Azure Database for PostgreSQL Backup and Restoration]( From Curated SQL Josephine Bush makes and restores a backup: I wanted to test a migration of Azure PostgreSQL from simple to flexible. I wanted a simple db… [Deepak Mahto: Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 7: pg_maintain Predefined Role for Maintenance.]( From Planet Postgres Welcome to Part 7 of our series exploring the exci... [Understanding PostgreSQL SUBSTRING function]( From SQLShack PostgreSQL is an open-source, object-oriented rela... PowerPivot/PowerQuery/PowerBI [Design Engaging Power BI Report Page Tooltips Effortlessly]( From Guy in a Cube We've talked about Tooltips before, but this time ... R Language [Simple Outlier Detection and Removal in R]( From Curated SQL Steven Sanderson looks for oddities: Outliers can significantly skew your data analysis results, leading to inaccurate conclusions. For R programmers, effectively identifying and removing outliers… T-SQL and Query Languages [Why Expressions Are Better Than Local Variables For Performance In SQL Server]( From Erik Darling Data Why Expressions Are Better Than Local Variables Fo... [Rewriting T-SQL Scalar UDFs So They’re Eligible For Automatic Inlining In SQL Server]( From Erik Darling Data Rewriting T-SQL Scalar UDFs So They’re Eligible ... [Additional Use for sp_statement_completed]( From Scary DBA (Grant Fritchey) Another discussion in Gothenburg (such a great gro... [TRY/CATCH Doesn’t Always Work.]( From Brent Ozar Unlimited If you’re using TRY/CATCH to do exception handli...  [RSS Feed]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -