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
 

Play To Your Strengths

I really enjoy playing with radios [ed: we know, you won't shut up about it]. Something as simple as checking in to a local net (basically saying hi to a bunch of people on the radio) is fun. However, there's so much more to it. In the last few weeks I've been testing a new digital mode (M17), texting over the radio (andFlMsg), and sending lots of emails on the radio (Winlink). I've also been experimenting with mesh networks (LoRa).

Fact is, after 35+ years in IT, constantly learning new stuff, I kind of can't stop learning new stuff. I can't decide if it's a problem or a reward [ed: it's a problem for us because you can't keep quiet about it].

I do sometimes wish I'd taken a different turn though. I have some friends who have chosen to climb the corporate ladder rather than just stay technologists. Sometimes, not often at all, I get a little jealous when I see the great things they've accomplished. But, I long ago realized that I'm good at figuring out coding problems, data problems, problems on machines, but horrible at figuring out people problems. Overall, I'm pretty gleeful to just be a technologist [ed: a noisy one].

My thoughts for today are simple. Play to your strengths. Sure, work on your weaknesses, but play to your strengths. You'll do better and be happier. At least, that's been my experience.

What do you think?

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

Flyway Baselines and Consolidations

Phil Factor demonstrates why we occasionally need to 'baseline' a database, when automating database deployments with Flyway, and a simple way of reducing the number of migration files that are required for a build.

Getting Started with Flyway Desktop

Robert Sheldon helps you get started with Flyway Desktop by walking you through the process of creating a Flyway Desktop project for an existing database. It covers the basics of building a schema model, generating and running migration scripts, and saving changes to source control.

Working with Flyway and Entity Framework Code First: Automation

This article will demonstrate how to automate a hybrid database change management system that uses Entity Framework Code First for development and Flyway for deployments. We automatically convert C# migrations, produced by EF, to the Flyway format and then use Flyway command line to deploy the migrations and save the 'object-level state' of each new database version, so we can track exactly which objects changed, and how, between versions.

AI/Machine Learning/Cognitive Services

Balancing Act: The Value of Human Expertise in the Age of Generative AI

From Dataversity

Humans are considered the weakest link in the ente...

What the AI Adoption Surge Means for IT Skill Development

From IT Pro - Microsoft Windows Information, Solutions, Tools

The latest IBM Global AI Adoption Index suggests t...

Three Myths About Generative AI in the Workplace – and How You Can Bust Them

From Dataversity

In the past year or so, generative AI has received more media attention than any other type of technology. Up until this point, data science has been at the...

Administration of SQL Server

SQL Server Dynamic Data Masking in Practice

From MSSQL Tips

Learn how to use dynamic data masking in SQL Serve...

SQL Server Diagnostic Information Queries for January 2024

From Glenn Berry

Introduction These are my SQL Server Diagnostic In...

Step-by-step Installation of SQL Server 2022 on a Windows Server 2022 Failover Cluster - Part 2

From MSSQL Tips

This article covers all the steps to install SQL S...

Backup SQL Server Database with SQL Server Management Studio (SSMS)

From MSSQL Tips

In this tip, we walk through the steps of how to b...

SSMS 19.3 Is Available

From Glenn Berry

Introduction On January 10, 2024, Microsoft releas...

Cumulative Update #11 for SQL Server 2022 RTM

From MS SQL Server Blog

The 11th cumulative update release for SQL Server ...

Azure SQL

Lesson Learned #469:Implementing a Linked Server Alternative with Azure SQL Database and C#

From Azure Database Support Blog

In scenarios where direct Linked Server connection...

Optimized locking in Azure SQL Database

From Simple Talk

I don’t think I’ve ever had a great impression...

Lesson Learned #471: Why Can't I Expand the Database Table List from my Application?

From Azure Database Support Blog

In the dynamic world of database management, we en...

Lesson Learned #472:Why It's Important to Add the TCP Protocol When Connecting to Azure SQL Database

From Azure Database Support Blog

In certain service requests, our customers encount...

Lesson Learned #473:Harnessing the Synergy of Linked Server, Python, and sp_execute_external_script

From Azure Database Support Blog

In an era where data management transcends individ...

What's new in security for Azure SQL and SQL Server | Data Exposed

From Azure SQL

Check out this episode to learn the newest information on security for Azure SQL and SQL Server!   Watch on Data Exposed   View/share our latest episodes on Microsoft Learn and YouTube!

Azure SQL Managed Instance

Lesson Learned #470: Resolving 'EXECUTE Permission Denied' Error on sp_send_dbmail in Azure SQL MI

From Azure Database Support Blog

We worked on a service request that our customer e...

Cloud - AWS

Amazon ECS supports a native integration with Amazon EBS volumes for data-intensive workloads

From AWS News Blog

Today we are announcing that Amazon Elastic Contai...

Computing in the Cloud (Azure, Google, AWS)

Benefits of Managed Cloud Hosting in the Evolving Cloud Landscape 

From Dataversity

The business landscape has undergone a transformat...

How to Gain a Competitive Advantage with Cloud

From IT Pro - Microsoft Windows Information, Solutions, Tools

Here's how businesses can use the cloud to achieve a competitive advantage amid uncertainty.

DMO/SMO/Powershell

How To Create and Append a Text File in PowerShell

From IT Pro - Microsoft Windows Information, Solutions, Tools

PowerShell users can enhance their scripting skills by learning these techniques for creating and modifying text files.

Data Mining / Data Analysis

Reporting statistics for unobserved levels of categorical variables

From AllAnalytics

An unobserved category is one that does not appear...

Meet our inspiring keynote speakers at SAS Innovate 2024

From AllAnalytics

Where can you meet an iconic Silicon Valley report...

Blog posts from 2023 that deserve a second look

From AllAnalytics

In a previous article, I presented some of the mos...

Electrolyte water: helpful or just hype?

From AllAnalytics

Electrolyte drinks (think Gatorade and Powerade) h...

Four Perspectives on the Art of Data Analytics

From Dataversity

As data science professionals, we are often viewed as people who draw conclusions based only on data and minimize other factors. This perception usually becomes contentious when the insights and...

Database Design, Theory and Development

The Cool Kids Corner: Data Mesh and Enabling Your Data Story 

From Dataversity

Hello! I’m Mark Horseman, and welcome to The Coo...

Backing up the Teslamate Database

From SQLServerCentral Blogs

I was worried about some of my data, so I wanted t...

Eternal Data: Exploring Infinite Storage Concepts for the Digital Age

From Dataversity

The digital age in which we live demands consisten...

Optimizing cache resets for higher transaction output

From Ayende @ Rahien

One of the most frequent operations we make in RavenDB is getting a page pointer. That is the basis of pretty much everything that you can think of inside...

DevOps and Continuous Delivery (CI/CD)

Top 10 Stories About DevOps in 2023

From IT Pro - Microsoft Windows Information, Solutions, Tools

ITPro Today's most read stories about DevOps explo...

Provisioning Multi-Database Environments using Clones, Indirectly

From Product learning – Redgate Software

This article describes how we implemented lightwei...

Create tests by adding HTTP requests in Azure Load Testing

From Azure Updates

Azure Load Testing now supports creating load test...

ETL/SSIS/Azure Data Factory/Biml

Video: SQL Server Integration Services on Linux

From 36 Chambers – The Legendary Journeys

THE VIDEO THE SYNOPSIS In this video, we bang our ...

Hardware

CES 2024: Intel Briefly Shows Lunar Lake Chip; Next-Gen Mobile CPU Uses On-Package Memory

From AnAndTech

As part of the final segment of Intel’s "Intel C...

Using the Pure Storage PowerShellSDK2 - Part 4 - Classifying Workloads With FlashArray Tags

From SQLServerCentral Blogs

Welcome back to the fourth installment of our blog...

Internet of Things

IoT Data Governance: Taming the Deluge in Connected Environments

From Dataversity

The Internet of Things (IoT) has rapidly redefined...

MDX/DAX

Automating DAX Measure Formatting in Power BI with Tabular Editor

From Purple Frog Systems

Until coming across this piece of code, I often us...

(Livestream Replay) Introducing DAX Optimizer - with Marco Russo

From Havens Consulting

DESCRIPTION DAX Optimizer is a tool that perfo...

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

Fabric: Test-Driving the New Office 365 Outlook Data Factory Activity

From AndyLeonard.blog()

In my last post titled Fabric: Load Data from a CS...

Microsoft Fabric – Notebook session usage explained (And how to save CU’s or billed time)

From FourMoo

I was working on a blog post to determine which co...

Fabulous Stuff in Fabric – Part 3: Shortcuts

From SQLServerCentral Blogs

A while ago I had a little blog post series about�...

Oracle/PostgreSQL/MySQL/other RDBMS

A Beginners Guide To MySQL Replication Part 6: Security Considerations in MySQL Replication

Protecting and controlling access to your data against unauthorized person(s) is crucial in any organization. Unauthorized entry or modification of your data can lead to severe and sometimes irreversible damage.

Performance Tuning SQL Server

Plansplaining part 27 – LAG and LEAD

From SQL Server Fast

This is part twenty-seven of the plansplaining ser...

Free SQL Server Troubleshooting Stored Procedures

From Erik Darling Data

Giveaway I’ve been doing a lot of work on all of...

Indexing SQL Server Queries For Performance: Fixing Predicate Key Lookups

From Erik Darling Data

Make Things Fast Our very lofty goal as query tuners is to make the time from request to result shorter. Sometimes that requires a bit of sacrifice on the...

PowerPivot/PowerQuery/PowerBI

Visualising Power BI Import Mode Refresh Job Graphs

From Chris Webb's BI Blog

A few years ago a new pair of Profiler events was ...

Switching between different active physical relationships in a Power BI model

From SQLServerCentral Blogs

A couple of weeks ago, I encountered a DAX questio...

Professional Development

Mistakes: A Painful and Effective Way to Supercharge Your Growth

From Little Miss Data

How making and sharing mistakes can supercharge yo...

T-SQL Tuesday #170 – Learning the Hard Way

From Andy Broadsword

This month’s invitation from Reitse asks us to...

Announcing the 2024 Data Professional Salary Survey Results.

From Brent Ozar Unlimited

This is the 8th year now that we’ve been running...

T-SQL Tuesday #170 – Learning from Failure

From SQLServerCentral Blogs

So what did I learn? I think a better question is,...

A temper, soft skills, and almost losing a job : T-SQL Tuesday #170

From SQLStudies

It’s T-SQL Tuesday again! In fact, it’s the fi...

R Language

Aggregating by Month and Year in R

From Curated SQL

Steven Sanderson groups by month and year: Taming ...

Security News and Issues

Protecting your Cloud Assets

Organizations of all types and sizes are turning to the cloud for their application and data storage requirements. The cloud makes it possible for them to deploy their workloads more quickly and to scale them up and down as requirements change.

What Is IAM? A Guide to Identity and Access Management

From Petri IT Knowledgebase

Identity and Access Management (IAM), is a crucial...

Canada Will Use Letter Grades To Assess Companies’ Cyber Resilience

From IT Pro - Microsoft Windows Information, Solutions, Tools

Canada is partnering with SecurityScorecard to strengthen critical infrastructure cybersecurity.

Software Development

A Hidden Benefit of Implicit Joins: Join Elimination

From Java, SQL and jOOQ.

One of jOOQ’s key features so far has always bee...

Software optimisation: leveraging algorithms for optimized performance/search.

From Simple Talk

Software optimization refers to the process of improving the performance, efficiency, and resource utilization of a software application. It involves making changes to the code, algorithms, or system configurations...

How to Reduce Performance Debt in Software Development Without Falling Behind

From IT Pro - Microsoft Windows Information, Solutions, Tools

Here are the best strategies for reducing performance debt in software development, and when to implement them for maximum effectiveness.

T-SQL and Query Languages

Don’t use DISTINCT as a “join-fixer”

I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there only to serve as a “join-fixer,” and I can explain what that means using an example.

T-SQL Tuesday #170 – Learning from Abandoned Projects

From Callihan Data

Sometimes you have to abandon the game plan. A foo...

Tech News

The end of anonymity online in China

From Technology Review Feed - Tech Review Top Stories

This story first appeared in China Report, MIT Tec...

Some Duolingo Workers Were Fired in Favor of AI

From IT Pro - Microsoft Windows Information, Solutions, Tools

Former contract workers at the language app say they were cut as the company uses more AI tools to create lessons.

5 Software Development Trends to Watch in 2024

From IT Pro - Microsoft Windows Information, Solutions, Tools

In 2024, expect a retreat from cloud-native and outsourced development, as well as fewer developer jobs but more software security problems.

Tech's Job Cuts Give Little Hope for Return to Rapid Growth

From IT Pro - Microsoft Windows Information, Solutions, Tools

Tech layoffs may be back with Amazon, Twitch, Unity, and Duolingo job cuts.

The Download: enhanced geothermal systems, and promising climate tech

From Technology Review Feed - Tech Review Top Stories

This is today’s edition of The Download, our weekday newsletter that provides a daily dose of what’s going on in the world of technology. Enhanced geothermal systems: 10 Breakthrough Technologies 2024...

On IoT Devices and Software Liability

From Schneier on Security

New law journal article: Smart Device Manufacturer Liability and Redress for Third-Party Cyberattack Victims Abstract: Smart devices are used to facilitate cyberattacks against both their users and third parties. While users...

Testing Software

Azure Load Testing supports Web Driver Sampler plugin for Apache JMeter

From Azure Updates

With Azure Load Testing, you can now measure respo...

 
RSS FeedTwitter
This email has been sent to newsletter@newslettercollector.com. 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

 

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