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 FeedTwitter
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

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -