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
 

Hack Your Brain

Now, let's be really clear up front, I don't mean getting a surgically implanted chip in your head, done on your kitchen table. Brain hacks are generally either, forming habits that are good for learning and concentration, changing how you do things to help enhance your brains function, eating differently in support of brain health, and, the hard, but easy, but hard, get enough sleep.

Personally, I do quite a few things to try to make this old noodle function better. For example, I carry a Field Notes notebook everywhere. Why? Because the act of writing engages portions of the brain that actually help to remember things. I write things down, so I'll have them later, but writing them down helps me remember them too. That's a brain hack.

Another one I've taken on involves technology ('cause of course it does). I've picked up a smart watch. I'm using it to track my activity on a daily basis. See, I do work out regularly (see my Chores editorial earlier this week), but other than my workouts, I can be a pretty sedentary person. But, in order to improve my heart health and my weight, I'm trying to be more active, walk more, move more, stretch, do stuff. Doesn't sound like a brain hack until you realize that enhanced blood flow to your body, also enhances blood flow to your brain, making it a more finely tuned machine. That is also a brain hack.

There are a bunch of others. Mindfulness and a positive outlook (yes, not always easily attained). Supplements (ooh, careful on this one). Dark chocolate (limited amounts). Fermented food for better gut health (direct links to mood and cognition). Mind mapping (never even tried this one). Pomodoro technique (I can't maintain it, but I'm going to be trying it again soon). Others.

In short, we can do things that make our brains work better. If you don't do any of these, the one I most recommend, get enough rest. Sleep is huge. However, I'd strongly suggest you try some of these out. Or, what are you doing to hack your own brain? Is there a must that I'm missing?

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 code analysis – These are a few of my favorite rules

Flyway’s code analysis is a powerful ally in keeping your database code tidy and secure, and making sure best practices are being followed. It analyzes your SQL files using built-in and customizable rules for catching anti-patterns before they wreak havoc in production. Here are a few of my favorite rules.

Flyway Autopilot – Let us be your guide

Have you heard of Flyway Autopilot? It’s a collection of pre-configured sample projects developed by our Solution Engineers to help you get started with Flyway. These projects allow you to quickly experience capturing database changes in version control and deploying those changes in a repeatable, reliable way.

Why Database Deployments Sometimes Go Bad

Phil Factor shares some of the common ways database deployments go wrong, and the testing strategies and sanity checks that will stop them happening to you.

AI/Machine Learning/Cognitive Services

AI at Work: 16% Pretend to Use It, 56% Pay Out-of-Pocket for Tools

From Past News - RSS Feeds

A third of workers say they spend as much time man...

AI in Wyoming may soon use more electricity than state’s human residents

From Ars Technica

Proposed data center would demand 5x Wyoming's cur...

ChatGPT’s New Study Mode Could Help Students Actually Learn, Curbing AI-Generated Homework

From Past News - RSS Feeds

OpenAI has introduced Study Mode for ChatGPT, a ne...

So far, only one-third of Americans have ever used AI for work

From Ars Technica

AP survey shows most Americans treat AI chatbots l...

AppGen: A Software Development Revolution That Won't Happen

From IT Pro - Microsoft Windows Information, Solutions, Tools

Here's why AI-powered application generation — AppGen — is just the latest in a long string of overhyped tech buzzwords that will fade in time.

Uncomplicate Cloud Management with AI-Led Observability

From IT Pro - Microsoft Windows Information, Solutions, Tools

AI-infused observability systems can transform overwhelming data into actionable insights that prevent downtime, reduce costs, and enable true cloud value.

Developer survey shows trust in AI coding tools is falling as usage rises

From Ars Technica

"AI solutions that are almost right, but not quite...

Administration of SQL Server

SQL Server 2025 : Zstandard Backup Compression

Whether you are a bank or a hot dog stand, creating backups is a boring but essential part of managing databases. Compressing backups – like other types of data compression – can save time and storage space, at the usually unavoidable cost of CPU. There has been little change in compression throughout SQL Server’s long history, but this year, in SQL Server 2025, there is an exciting change coming. But first…

How to Increase SQL Server Column Width Without IO (Input/Output) Overhead

From Simple Talk

One of the most hassle-prone changes that can be m...

Updates and improvements to sp_CheckBackup

From StraightPath Solutions SQL Blog

Since we introduced sp_CheckBackup last year we’...

Zero Downtime SQL Server Upgrade: Best Practices for Seamless Migration

From SQLServerCentral Blogs

Upgrading SQL Server is a mission-critical task fo...

SQL Server 2025: Not Just a Database; A Data Engine Reimagined

From SQLServerCentral Blogs

Let us be honest; most database upgrades feel like...

From AI to JSON: What’s New in SQL Server 2025 Data Types (With Scripts)

From SQLServerCentral Blogs

Introduction SQL Server 2025 is a landmark re...

SQL Server Maintenance Plans

From SQLServerCentral Blogs

If you’re a DBA, sysadmin, IT manager, or Accide...

SQL Server Migration Made Easy: A Complete Guide to Microsoft DMA and Its Successors

From SQLServerCentral Blogs

Migrating SQL Server databases is a critical task ...

Azure Databricks, Spark and Snowflake

Load Data into Snowflake Using Native Snowflake Connector for Python: From Small to Large Datasets

In this article, we’re diving deeper into the Snowflake toolbox by exploring the native Snowflake Connector for Python. While pandas offers simplicity and familiarity, the native connector provides a different set of capabilities focused on precision control and Snowflake-specific optimizations. This article explains when and how to use this more direct approach for everything from small CSV files to massive datasets that would overwhelm pandas.

Level Up Your Snowflake Dashboard: Filters Making Audits Less Sucky

From Sherpa of Data

Snowflake Dashboards can do a lot more than just s...

Azure DevOps

Build and Deploy Dockerize Python Application to Azure Container Instances (ACI) using Azure DevOps

From SQLServerCentral Blogs

As a software Engineer, I would like to deploy my ...

Career, Employment, and Certifications

Communications: Three Questions

From SQLServerCentral Blogs

The better skilled we are communications, the more...

AI and Automation Talent Demand Doubles as Tech Hiring Slows

From IT Pro - Microsoft Windows Information, Solutions, Tools

AI and automation positions have surged to 6% of t...

Enterprise tech trends SMBs can’t afford to ignore

From AllAnalytics

The future is already here and somehow, it keeps a...

The Great Cloud Reversal: Why IT Teams Are Moving Back to Dedicated Infrastructure

From IT Pro - Microsoft Windows Information, Solutions, Tools

IT professionals reveal a growing shift back to de...

Top 7 Professional Growth Sessions to Attend at PASS Summit 2025

From Blog – Redgate Software

Upskill, connect, and maximize your ROI at PASS Su...

Want to Earn $18K More? Learn an AI Skill

From Past News - RSS Feeds

Jobs requiring AI skills pay nearly $18,000 more p...

Where Technology Executives Will Be Investing in 2026

From IT Pro - Microsoft Windows Information, Solutions, Tools

Here's a look at where technology executives will be spending their budgets in North America, Europe, and APAC next year.

Empowering Technical Teams: Leading with Vision, Not Micromanagement

From SQLServerCentral Blogs

Let’s be honest; technical teams don’t thrive ...

Cloud - AWS

Amazon DocumentDB Serverless is now available

From AWS News Blog

Amazon DocumentDB Serverless automatically scales capacity up or down in fine-grained increments based on your application's demand, offering up to 90% cost savings compared to provisioning for peak capacity.

Cloud - Azure

Azure DMS Tutorial: Migrate Databases to Azure with Minimal Downtime

From SQLServerCentral Blogs

Migrating databases to the cloud can be complex, b...

Community Interests

SQL Saturday Baton Rouge 2025

From Data on Wheels (Steve Hughes)

SQL Saturday Baton Rouge is a great event hosted o...

Introduction to WordPress Plugin Development: Build Your First Plugin

From https://chrisadkin.io

In this guide, you'll learn the essentials of plugin development, set up a local environment using Studio by WordPress.com, and build a fully functional example plugin.

DMO/SMO/Powershell

Securing PowerShell: How to Stop Prompt Injection Attacks, Part 1

From IT Pro - Microsoft Windows Information, Solutions, Tools

Learn how seemingly innocent PowerShell database scripts can become dangerous security vulnerabilities when left unprotected against prompt injection attacks.

Data Mining / Data Analysis

Power BI Copilot, AI Instructions And Visualisation Guidelines

From Chris Webb's BI Blog

If there are specific ways you want your data to b...

How to position tick marks for months when you graph weekly data

From AllAnalytics

Suppose you measure data weekly. According to the ...

Is AI Making Data Analysts Less Intelligent?

From Dataversity

Data analysts use artificial intelligence (AI) for...

5 myths about synthetic data – and what’s actually true

From AllAnalytics

Synthetic data – algorithmically generated data that mimics real-world data – has emerged as a cornerstone in modern AI workflows. But its promise comes with persistent myths about its...

Database Design, Theory and Development

Resource: Security Auditing for Databases

From SQLServerCentral Blogs

If you are responsible for securing databases, SQL...

DevOps and Continuous Delivery (CI/CD)

Introduction to GitHub Actions Part 3: Self-hosted runners

Many organizations prefer to use self-hosted runners when GitHub-hosted do not meet their technical or security requirements. For example, a self-hosted runner can be added to Active Directory or Microsoft Entra ID. The downsides are increased costs and management time compared to GitHub-hosted runners. This article demonstrates how to use a Windows machine for a self-hosted runner, however, you could also use Linux or macOS.

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

Navigating Modern Data Architecture: DW, Lakehouse, and Lakebase Explained

From SQLServerCentral Blogs

The report outlines the evolution in data manageme...

Your Metrics, Your Rules: Extracting and Storing Fabric Admin and Capacity Metrics Data in Fabric

From Data – Marc

There are loads of default semantic models and rep...

Oracle/MySQL/other RDBMS

Semantic image search in RavenDB

From Ayende @ Rahien

I talked with my daughter recently about an old ba...

MySQL Index Overviews: PRIMARY KEY Indexes

From Simple Talk

Learn how to use PRIMARY KEY indexes in MySQL - a ...

Performance Tuning SQL Server

The Query Tuning Trick You Should Use More: Pagination

From Brent Ozar Unlimited

When I’m tuning queries, the normal answer is to...

How To Think Like A Batch (Mode) In SQL Server

From Erik Darling Data

How To Think Like A Batch (Mode) In SQL Server Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training....

It’s Time to Get Rid of the Cost Threshold for Parallelism Setting.

From Erik Darling Data

It’s Time to Get Rid of the Cost Threshold for Parallelism Setting. Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love...

PostgreSQL

Sergey Solovev: pg_dphyp: teach PostgreSQL to JOIN tables in a different way

From Planet Postgres

Greetings! I work in Tantor Labs as a database...

PostgreSQL Table partitions now supported in Flyway

From Blog – Redgate Software

This blog post was originally authored by Prajakt...

Dave Stokes: PostgreSQL, Ollama, and the DBeaver AI Assistant

From Planet Postgres

Ollama is an open-source project that simplifies r...

Andreas 'ads' Scherbaum: Polina Bungina

From Planet Postgres

PostgreSQL Person of the Week Interview with Polin...

Christoph Berg: The Debian Conference 2025 in Brest

From Planet Postgres

It's Sunday and I'm now sitting in the train from ...

Ming Ying: Case Study: Bilt Reduces Postgres Query Timeouts by 95% with ParadeDB

From Planet Postgres

A case study on how Bilt reduced Postgres query ti...

PowerPivot/PowerQuery/PowerBI

AI in Power BI: Time to pay attention

From Sqlbi

The state of AI tools with Power BI, and how to us...

Dynamic Matrix Columns in Power BI: Show/Hide Based on Row Hierarchy

From Havens Consulting

Video by: Reid HavensEver wish your Power BI matri...

Running a Power BI Performance load test using Visual Studio Code

From FourMoo

This is the final part of my blog series for Power...

Storytelling with Power BI Scatter Chart

From RADACAD

Column or Bar chart can be easily used for showing a single measure’s insight across a category. Mixed charts such as Line and Column chart can be used for...

Security News and Issues

That Time Tom Lehrer Pranked the NSA

From Schneier on Security

Bluesky thread. Here’s the paper, from 1957. Not...

How to Prevent and Stop a DDoS Attack on Your Website

From https://chrisadkin.io

How do you stop a distributed denial-of-service (D...

Flaw in Gemini CLI coding tool could allow hackers to run nasty commands

From Ars Technica

Beware of coding agents that can access your comma...

VPN use soars in UK after age-verification laws go into effect

From Ars Technica

Proton VPN signups originating in the UK increased...

St. Paul, MN, was hacked so badly that the National Guard has been deployed

From Ars Technica

"A deliberate, coordinated digital attack."

Cheating on Quantum Computing Benchmarks

From Schneier on Security

Peter Gutmann and Stephan Neuhaus have a new paper—I think it’s new, even though it has a March 2025 date—that makes the argument that we shouldn’t trust any of...

Microsoft catches Russian hackers targeting foreign embassies

From Ars Technica

End goal is the installation of a malicious TLS ro...

Spying on People Through Airportr Luggage Delivery Service

From Schneier on Security

Airportr is a service that allows passengers to have their luggage picked up, checked, and delivered to their destinations. As you might expect, it’s used by wealthy or...

Software Development

A New and Improved Code Editing Experience

From https://chrisadkin.io

We recently launched enhancements to the post and ...

Tech News

Starlink kept me connected to the Internet without fail—until Thursday

From Ars Technica

"Starlink went down across the entire front."

Smithsonian Air and Space opens halls for “milestone” and “future” artifacts

From Ars Technica

John Glenn's Friendship 7 returns as SpaceX and Bl...

The first company to complete a fully successful lunar landing is going public

From Ars Technica

Some of Firefly's programs are going quite well. O...

Exclusive: A record-breaking baby has been born from an embryo that’s over 30 years old

From Technology Review Feed - Tech Review Top Stories

A baby boy born over the weekend holds the new rec...

India safely launches a $1.5 billion satellite for NASA

From Ars Technica

"We are at the threshold of fulfilling the immense...

Australia’s first orbital-class rocket stalled seconds after liftoff

From Ars Technica

"I thought best case was maybe 40 seconds of fligh...

Making Roman concrete produces as much CO2 as modern concrete

From Ars Technica

Roman concrete produces as much, if not more, CO2 ...

Google tool misused to scrub tech CEO’s shady past from search

From Ars Technica

Google has fixed the bug, which it says affected o...

Google loses app store antitrust appeal, must make sweeping changes to Play Store

From Ars Technica

Google's failed appeal could open up the market fo...

Formula E cars keep getting faster and faster: What’s next for the sport?

From Ars Technica

We hope downforce doesn't ruin the racing when it ...

Rocket Report: NASA finally working on depots, Air Force tests new ICBM

From Ars Technica

"I didn't expect that we would get to orbit."

The military’s squad of satellite trackers is now routinely going on alert

From Ars Technica

"I hope this blows your mind because it blows my m...

The Lighter Side

CodeSOD: Going on a teDa

From Daily WTF

Carlos G found some C++ that caused him psychic ha...

CodeSOD: What a CAD

From Daily WTF

In my career, several times I've ended up being the pet programmer for a team of engineers and CNC operators, which frequently meant helping them do automation in their...

Error'd: Monkey Business

From Daily WTF

If monkeys aren't your bag, Manuel H. is down to clown. "If anyone wants to know the address of that circus - it's written right there. Too bad that it's only useful...

Virtualization and Containers/Kubernetes

Mastering Kubernetes Pods: Essential Guide for Administrators

From IT Pro - Microsoft Windows Information, Solutions, Tools

This concise guide covers how to effectively creat...

Accessing the Kubernetes API from SQL Server 2025

From DBA From The Cold

The sp_invoke_external_rest_endpoint stored procedure that’s available in 2025 allows for SQL Server to hit external rest endpoints…which opens up quite a few interesting options. I was thinking about this...

Deploying SQL Server to Kubernetes via SQL Server 2025

From DBA From The Cold

Following on from my previous post about hitting the Kubernetes API from SQL Server 2025 let’s go a little further and deploy SQL Server 2025 to Kubernetes from…SQL Server...

 
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

 

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