| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| 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’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. |
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. |
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 |
A third of workers say they spend as much time man... |
Proposed data center would demand 5x Wyoming's cur... |
OpenAI has introduced Study Mode for ChatGPT, a ne... |
AP survey shows most Americans treat AI chatbots l... |
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. |
AI-infused observability systems can transform overwhelming data into actionable insights that prevent downtime, reduce costs, and enable true cloud value. |
"AI solutions that are almost right, but not quite... |
Administration of SQL Server |
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… |
One of the most hassle-prone changes that can be m... |
Since we introduced sp_CheckBackup last year we’... |
Upgrading SQL Server is a mission-critical task fo... |
Let us be honest; most database upgrades feel like... |
Introduction SQL Server 2025 is a landmark re...
|
If you’re a DBA, sysadmin, IT manager, or Accide... |
Migrating SQL Server databases is a critical task ... |
Azure Databricks, Spark and Snowflake |
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. |
Snowflake Dashboards can do a lot more than just s... |
As a software Engineer, I would like to deploy my ... |
Career, Employment, and Certifications |
The better skilled we are communications, the more... |
AI and automation positions have surged to 6% of t... |
The future is already here and somehow, it keeps a... |
IT professionals reveal a growing shift back to de... |
Upskill, connect, and maximize your ROI at PASS Su... |
Jobs requiring AI skills pay nearly $18,000 more p... |
Here's a look at where technology executives will be spending their budgets in North America, Europe, and APAC next year. |
Let’s be honest; technical teams don’t thrive ... |
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. |
Migrating databases to the cloud can be complex, b... |
SQL Saturday Baton Rouge is a great event hosted o... |
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. |
Learn how seemingly innocent PowerShell database scripts can become dangerous security vulnerabilities when left unprotected against prompt injection attacks. |
Data Mining / Data Analysis |
If there are specific ways you want your data to b... |
Suppose you measure data weekly. According to the ... |
Data analysts use artificial intelligence (AI) for... |
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 |
If you are responsible for securing databases, SQL... |
DevOps and Continuous Delivery (CI/CD) |
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) |
The report outlines the evolution in data manageme... |
There are loads of default semantic models and rep... |
I talked with my daughter recently about an old ba... |
Learn how to use PRIMARY KEY indexes in MySQL - a ... |
Performance Tuning SQL Server |
When I’m tuning queries, the normal answer is to... |
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. Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love... |
Greetings! I work in Tantor Labs as a database... |
This blog post was originally authored by Prajakt... |
Ollama is an open-source project that simplifies r... |
PostgreSQL Person of the Week Interview with Polin... |
It's Sunday and I'm now sitting in the train from ... |
A case study on how Bilt reduced Postgres query ti... |
PowerPivot/PowerQuery/PowerBI |
The state of AI tools with Power BI, and how to us... |
Video by: Reid HavensEver wish your Power BI matri... |
This is the final part of my blog series for Power... |
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... |
Bluesky thread. Here’s the paper, from 1957. Not... |
How do you stop a distributed denial-of-service (D... |
Beware of coding agents that can access your comma... |
Proton VPN signups originating in the UK increased... |
"A deliberate, coordinated digital attack." |
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... |
End goal is the installation of a malicious TLS ro... |
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... |
We recently launched enhancements to the post and ... |
"Starlink went down across the entire front." |
John Glenn's Friendship 7 returns as SpaceX and Bl... |
Some of Firefly's programs are going quite well. O... |
A baby boy born over the weekend holds the new rec... |
"We are at the threshold of fulfilling the immense... |
"I thought best case was maybe 40 seconds of fligh... |
Roman concrete produces as much, if not more, CO2 ... |
Google has fixed the bug, which it says affected o... |
Google's failed appeal could open up the market fo... |
We hope downforce doesn't ruin the racing when it ... |
"I didn't expect that we would get to orbit." |
"I hope this blows your mind because it blows my m... |
Carlos G found some C++ that caused him psychic ha... |
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... |
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 |
This concise guide covers how to effectively creat... |
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... |
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... |
  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. |
|
|