| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| Greener Grass Before I start the whining (whinging if you prefer), let me just say I have the greatest job in the world. I'm exceedingly lucky to have it. I'm grateful as can be. And someone else (looking at you Tim) can get it when they pry it from my dead cold fingers. With that out of the way.... Today is my second day this week working out of a hotel room. Many times on the road, the hotels have "Executive Lounges" which are decent places to go and get work done. However, not always. So you get stuck in the room. This particular one doesn't have a desk of any sort. There's a table (a bit too high) and a chair (a bit too low with a low back) that are not conducive to typing. A couple of weeks back I was stranded by Deutsche Bahn 2/3 of the way to my destination. Earlier this week a five hour layover (not a bad thing actually) turned into less than an hour because of weather. I've been stranded multiple times in different airports all around the world, calling hotels to get a last-minute room somewhere. Jet lag sucks. Hotel rooms are usually too hot, too cold, or alternate between the two. I actually find most of the beds to be comfortable enough, but oh my god the pillows. In short, travel can be extremely uncomfortable. I'm just sharing that so you know, sure, I have a fantastic job that I truly love, but it's not perfect. There are real challenges to it some days. The grass isn't always greener on the other side of the hill. Sometimes, it's just different grass. I say all this because I've had a couple of conversations recently with people who were looking to leave their jobs for another. Yet, when you drill down on what they're moving for, or to, you frequently find that they work for, let's say a bank, and they're interviewing at other banks. For the same position as the one they are currently in. I try to point out to them that... really, they're not looking at greener grass, just different grass. Maybe even not that different. If you are thinking of changing jobs, be sure that it's a real change. At the very least, the same position, but in a different industry will bring new challenges and some excitement. It should be a real change that drives you though, not just the appearance of greener grass. 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 |
Learn how Flyway's state-based deployments help teams coordinate database changes and automate deployments, reducing risk, without disrupting existing development workflows. This article explains how they work, where they fit best, and when it makes sense to move to a migration-based approach. |
IT and data teams in Financial Services must meet the more exacting demands for data integrity, compliance, performance, high availability and security that are expected in the sector. These demands require a dedicated, comprehensive, and scalable monitoring solution to help teams succeed in this high stakes environment. |
I’m excited to announce a new capability in Redgate Monitor Enterprise: the Sensitive Action Log. As infrastructure becomes more complex, it’s more critical than ever to maintain control over how your monitoring environment is configured and accessed. Whether you’re responding to internal compliance policies, preparing for audits, or simply tightening operational security, it’s key to understand who did what, when. |
AI/Machine Learning/Cognitive Services |
Experts urge action as AI accelerates workplace au... |
In a series of tests, Anthropic’s newly released... |
At the core of Flow is Veo 3, Google’s latest AI video generation model. While Veo 3’s capabilities are impressive, its realism comes with serious concerns. The post Google’s Veo... |
Expert analysis shows Anthropic's attempts to skip chatbot praise and avoid copyrighted content. |
In many organizations, AI exists as a secret weapon. It’s essentially locked away in a box, brought out to work on a limited use case, and then put back... |
Separating AI reality from hyped-up fiction isn’t always easy. That’s why we’ve created the AI Hype Index—a simple, at-a-glance summary of everything you need to know about the state... |
Nick Clegg described it as “implausible” to seek permission from every artist before using their work to train AI models given the vast scale of data used. The post This... |
Administration of SQL Server |
If you have SQL Server 2019 or SQL Server 2022 ins... |
Tired of inventory headaches? Stock shortages and ... |
With the release candidate of SQL Server 2025, whi... |
I’m working on an update to my Query Performance... |
In case you missed it, SQL Server Management Studi... |
The Two-Layer Model Explained “We added them to the database, but they still can’t connect.” Sound familiar? That’s the kind of confusion SQL Server’s two-layer security model creates when... |
We live in a world awash with vast amounts of data. Today’s modern enterprises generate and rely on vast amounts of data every single day, but data is only as valuable as its quality. Organizations across industries are increasingly aware of the critical role data quality plays in their success, especially within today’s intricate customer landscape. However, despite its significance, poor data quality persists as a common challenge, driven by fragmented systems and siloed data. |
AWS introduces specialized Model Context Protocol ... |
As the tech community we continue to have many opp... |
Amazon Aurora DSQL is the fastest serverless distributed SQL database with virtually unlimited scale, the highest availability, and zero infrastructure management for always available applications. You can remove the... |
Even before the Community Summit in Montreal, I wa... |
I'm sharing the slides and transcript from my talk about the PostgreSQL Europe Diversity Task Force at PostgreSQL Development Conference 2025. It's an extended version of the 5... |
Data Mining / Data Analysis |
A previous article discusses the Gini-Simpson diversity index and how to compute it in SAS. Suppose you have a sample that contains R classes. (Classes are also called groups... |
In the last post, we explored fundamental nutritional habits to manage inflammation, insulin resistance, gut health and stress resilience which can all impact perimenopause symptoms. Now, let’s build on... |
Database Design, Theory and Development |
Managing unstructured data can be both challenging and confusing. A few handy tips can make the task much faster and easier. |
Wondering which database to tackle first? I’ve got the lowdown on the top free choices for anyone new to SQL, and I’ll tell you exactly why they’re stellar for... The... |
DevOps and Continuous Delivery (CI/CD) |
Reading Time: 7 minutesIn this post I want to co... |
Here are the slides from my talk today at the Redg... |
Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
Let’s talk about some advanced features available both in Fabric Databases and Azure SQL. |
As a Power Query fan I’m naturally interested in... |
Blog Post Note / Disclaimer / Apology: This is a l... |
Reading Time: 4 minutesIn this post I want to cover the current state of Microsoft Fabric workloads. As per the below diagram that I created. In reality,... |
In this blog post I am going to explain how to query multiple Lakehouse tables into a data frame. The example I am going to use is when you... |
Oracle/PostgreSQL/MySQL/other RDBMS |
In its traditional, (and free) configuration, Orac... |
Relational databases provide a structured approach... |
When you first begin your journey into Oracle performance tuning, you quickly discover that you’re not just working with databases, |
It’s a tale as old as time. You want to read data. Your mate wants to write data. You’re stepping on each other’s toes, all the time. When we’re talking about relational data stores, one aspect that makes them what they are is the need to comply with the ACID properties... |
High Availability (HA) refers to a system design a... |
Warda Bibi upgrades a server: Upgrading to the lat... |
Introduction Much of the time taken processing... |
A quick note for PostgreSQL extension maintainers:... |
What’s Zig and Zig’s C/C++ compiler? In ca... |
Introduction If you’ve created web apps with... |
When building RavenDB 7.0, a major feature was Vec... |
PostgreSQL Person of the Week Interview with Dirk ... |
The new baseline feature in pgroll 0.13.0 makes it easy to start using pgroll on databases with existing schema and keep your schema histories clean. |
Tomorrow I’m going to be doing a Discord webinar about the deep optimizations we did in how RavenDB talks to the disk. We are talking about some of the biggest... |
One of my favorite new PostgreSQL 18 features which hasn’t had much attention yet is tracking session-level IO stats. It’s going to be really helpful for more quickly finding... |
PowerPivot/PowerQuery/PowerBI |
Sharing Power BI reports with external users is a common but often misunderstood scenario. While it may seem simple on the surface, doing it properly and securely involves many... |
Using SAS Viya Workbench for efficient setup and e... |
Exploring graphs is always a fun. Attaching the ed... |
Cloud-based artificial intelligence’s growth has... |
This is the second of four parts in this series. Part 1 can be found here. 4. The Architecture of MCP: Clients, Protocol, Servers, and Services How does MCP... |
Backdoor giving full administrative control can survive reboots and firmware updates. |
T-SQL and Query Languages |
So, you want to get your SQL skills razor-sharp wi... |
When I was perusing my LinkedIn feed the other day... |
THE VIDEO THE SYNOPSIS In this video, I show how we can use the APPLY operator to find records associated with a “parent” table. We look at getting the... |
Learn T-SQL With Erik: DISTINCT Isn’t Always Evil Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering... |
Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER BY ID ASC) AS RN FROM wp_posts WHERE post_parent = 94341; ) UPDATE p SET... The... |
Tight mouse controls and inventive weapons build o... |
Simulations show how effects of asteroid impact co... |
A new type of fuel cell that runs on sodium metal could one day help clean up sectors where it’s difficult to replace fossil fuels, like rail, regional aviation,... |
Trajectories, wind shear, temperature gradients, t... |
Tesla's robotaxis trial in Austin, Texas is slated to launch by the end of June, Elon Musk confirmed. Find out why this is a high-stakes move for the EV... |
Researchers are studying the long-term effects on ... |
Plan calls for three new reactors to reach criticality in about a year. |
3D-printing new parts for the A1 taught me a lot about plastic, and other things. |
Join us on the livestream at 3 pm EDT and ask questions about the future of space! |
20 years of observations have given us more knowledge about the icy giant. |
The Amazon/Stellantis STLA SmartCockpit was meant to arrive in 2024. |
Aurora's autonomous trucks are delivering freight in Texas with no human driver. The promise is big, but so are the safety concerns. The post Autonomous Trucks Breakthrough Doesn’t Halt All... |
Interesting story: USS Stein was underway when her... |
Our anonymous submitter, whom we'll call Craig, wo... |
  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. |
|
|