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
 

Subscribing to a Great New Year

New Year’s Day is probably the most positive day of the year when people, in all manner of situations, think back to the previous rotation around the earth and decide what they will do better this time.

The problem with resolutions

On the one hand, it is a silly ritual; most of the time, we make proclamations that would require the “willpower of the warrior” to do even a tenth of what we proclaim. The fact that that quote came from Kung Fu Panda is purposeful. Why? Because in that series of movies, Po (the Kung Fu Panda himself), is not obviously fit to do any of the things he will accomplish. He is everything a ninja warrior needs not to be.

But he succeeds. Why? Because he is a cartoon character, and the script says it happens like that. However, when you decide to make such significant changes in your life, you may not succeed. To be honest, fully succeeding is practically impossible if you set meaningful and challenging goals for yourself.

I probably sound like I am contradicting myself, and I am. Purposefully. I don’t want to make this about making strict resolutions because we often treat those as little scripts for our lives, and the script always ends happily. “This year, I will lose 200 lbs!” then, a few weeks later, you realize food is good, you already have clothes that fit, exercise is hard, and forget this. (And you may not have said forget. I did!)

(And not to be all technical about it, but everyone loses at least 200 pounds a year; it is just that we typically gain it all back the next day. But I suppose a resolution not only to gain back 60% of what we lost through the year isn’t quite as poetic (or measurable).

Recasting resolutions as subscriptions

As you ponder any changes you are making in life, don’t think of them in specific terms like a script. Think of them more like subscriptions. In this day and age, we have subscriptions to more than just a fruit of the month. We subscribe to everything: TV, software, gyms, etc.- things you wanted and planned to use.

All those life changes are like that gym membership you made, where canceling costs more than finishing out the contract. Try it out, lift a few weights, and you may like it (after the pain goes away, of course). In addition, a subscription sometimes teaches you something you didn’t expect it to, like reading contracts before you sign them.

As technical people, one concept we all need to subscribe to is constantly learning new things. This editorial is part of the DBWeekly newsletter on SQL Server Central, so if you are reading it there, you already have one place to learn new things.

The most significant difference between a subscription and a resolution is how definitive they are. When you resolve to do something, the first failure is often the end of it. A subscription isn’t a promise; it is buying into some action, service, or concept and, in many ways, a reminder. I am regularly reminded that I seem to subscribe to too many services. I review them periodically and realize I either use them or at least I need to.

Going to be a good year… maybe

This year, I am going to subscribe to the idea of eating better, exercising more, and learning a lot more about computing. Will I fail? Often, and maybe horribly. But I will do my best not to cancel those subscriptions until renewal time, which is the same time next year.

 

Louis Davidson (@drsql)

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.
AI/Machine Learning/Cognitive Services

Beyond GPT-4: Exploring the Next Frontier in Language Models

From Dataversity

Language models, the engines driving modern artifi...

The Ebb and Flow of AI

From Brent Ozar Unlimited

It’s the end of the year. Everybody’s coasting...

Administration of SQL Server

Streamlining Email Alerts with Sub-addressing

From Andy Broadsword

Automated email alerts lead to information overloa...

Azure Databricks, Spark and Snowflake

Session, DataFrameWriter, and Table Configurations in Spark

From Curated SQL

Miles Cole makes a configuration change: With Spark and Delta Lake, just like with Hudi and Iceberg, there are several ways to enable or disable…

Computing in the Cloud (Azure, Google, AWS)

The Cost of Everything, Cloud Edition

From Curated SQL

Kevin Sookocheff noodles on a core concept: At AWS re:Invent 2023, Amazon CTO Werner Vogels delivered a talk on the laws of frugal architecture. While I initially filed…

DMO/SMO/Powershell

Writing Loops in Powershell

From Curated SQL

Adam Bertram is spinning in circles: One of PowerShell’s key features is its ability to loop through data collections, enabling you to execute a code…

Using PowerShell to call an IFTTT Webhook

From DCAC

Sometimes, you want/need to have PowerShell do an ...

How To Build a Disk Space Pie Chart in PowerShell

From IT Pro - Microsoft Windows Information, Solutions, Tools

This article ends our series about using PowerShel...

DevOps and Continuous Delivery (CI/CD)

Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real World Examples of CI CD

This article covers examples of how some larger companies have successfully implemented CI/CD practices to transform their development processes. Through these case studies, we will examine strategies employed by Netflix, Etsy, Google, Amazon, and Facebook, highlighting their unique approaches and the benefits they have achieved. These examples provide valuable insights into how CI/CD can be leveraged to address complex challenges and drive innovation in diverse software environments.

Two ways to perform CI/CD for SQL databases in Fabric using GitHub Actions

From Kevin Chant

Reading Time: 8 minutesIn this post I cover two ...

 
Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science)

Microsoft Fabric: Unlocking the Secrets to Mastering Shared Semantic Models – Part 1 – Core Concepts

From BI Insight

Managing and optimising shared semantic models in Microsoft Fabric, with a focus on securing access, is essential in today’s data-driven world. These models are the backbone of an organisation’s...

Performance Tuning SQL Server

The Benefits of Read Committed Snapshot Isolation

From Curated SQL

Haripriya Naidu gets optimistic: In this article, we are going to take a look at how write operations block read operations under default isolation level…

A Pair of NOLOCK Demos

From Curated SQL

Erik Darling has a new video: Two Of My Favorite NOLOCK Demos from Paul White and Aaron Bertrand Erik has covered transaction isolation levels lately…

A Little About Parameter Sensitive Plan Optimizations In SQL Server 2022

From Erik Darling Data

A Little About Parameter Sensitive Plan Optimizati...

A Little About LOCK_TIMEOUT In SQL Server

From Erik Darling Data

A Little About LOCK_TIMEOUT In SQL Server This wee...

PowerPivot/PowerQuery/PowerBI

Why Setting Sort By Column Is Important For Power BI Copilot

From Chris Webb's BI Blog

As a Power BI semantic model developer, one of the...

Metric Sets in Power BI

From Purple Frog Systems

Metric Sets in Power BI: Transforming Data Managem...

Filter and Parameter Passing from Power BI to Power Apps

From Curated SQL

Jon Voege runs into a problem: A simple comment Ap...

Learning Database Design and Power BI Performance

From SQLServerCentral Blogs

I spend my days working on and managing SQL Server...

R Language

Mathematical Transformations of Data in R

From Curated SQL

Steven Sanderson does the math: Data transformation is a fundamental technique in statistical analysis and data preprocessing. When working with R, understanding how to properly…

Software Development

Frappe’s Configuration vs Laravel’s Code-Centric Customisation

This article compares the Frappe and the Laravel frameworks, focusing on key technical differences in customization, database management, and API development. While Laravel’s popularity lies in its code-centric approach to web development, Frappe simplifies many aspects through configuration and low-code features, making it a suitable choice for rapid application development. This article will be broken into three parts which will explore “Configuration vs. code customization,” “database migrations,” and “API integration techniques,” providing practical insights on why to choose each framework.

The Lighter Side

Human versus autonomous car race ends before it begins

From Ars Technica

A2RL admits that this is a hard problem, and that'...

Isn't it ironic: Money isn't transactional

From Ayende @ Rahien

I write a transactional database for a living, and...

2024: The year AI drove everyone crazy

From Ars Technica

What do eating rocks, rat genitals, and Willy Wonka have in common? AI, of course.

Magnetic shape-shifting surface can move stuff without grasping it 

From Ars Technica

A “ferromagnetic elastomer” sheet can bulge and bend under magnetic influences.

 
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

 

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