| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
| Don't Panic And bring a towel. If you don't know what I'm talking about, you have homework. You know with that lead in I'm going to talk about AI. Sorry, can't help it. It's on my mind quite a lot. It's in the news, oh, a whole lot. The majority of those stories can be summed up in a single word: PANIC! While I know I'm just some rando on the internet and my opinion is worth every single penny you're paying for it (for those confused, it's zero, zero pennies), I have a few words to share beyond "Don't panic." First up, yeah, if you haven't been working with the LLMs and Agentic AI, you might not be aware of it, but, yes, these things are going to be disruptive. Potentially, massively disruptive. Every new technology that's truly ground breaking, and this very much qualifies, eliminates jobs and changes career paths. Every new technology also creates new jobs and different career paths. I know these two facts because a) I'm old and I've seen similar shows before, b) I read a lot of history, including the history of technology. We're still in the early days of this disruption. Anyone who says they know for certain how things are going to turn out is selling you something (and how much did you pay for this?). I'm not going to tell you that I know exactly how things are going to turn out here, but I know, for certain, there's going to be good with the bad. What? Where? Haven't a clue. If I did, I'd be charging you. Next, if you haven't been working with the LLMs and Agentic AI, dude, come on, it's time to start. One thing I can say about these things is that they mainly constitute yet another tool. This tool may be powerful. It may serve a whole slew of functions. However, it's just a tool. Like any tool, the likelihood of picking it up and putting it to work without any practice or knowledge of it is going to end in pain. Quick story about a hammer. I grew up around craftsmen. My uncles on my mom's side of the family all put tools in my hands at an early age. So, I learned how to use a hammer. I was helping a friend build some stuff. Another friend of his was also helping. Other friend was a big, buff, weight lifter dude. Huge. Me, I'm pretty weak in the upper body frankly. Yet, I was pounding in nails in 2-4 sharp hits of the hammer. Giant muscled guy was hitting them 15-20 times, hard as he could, bending a lot of them. Why? I knew how a hammer worked and he just didn't. AI = Hammer. It's inevitable. You're going to use them at some point. Learn how to use them well. It's just a tool. Finally, seriously, don't panic. Spit out the black pill. Yeah, there's a lot happening around technology right now and it's scary. Your job, as a technologist, is not to freak out. It's to learn, understand, and then appropriately apply. Further, sticking your head in the sand and hoping this all blows over 'cause it's a fad and a bubble, HALLUCINATIONS, ain't going to work well for you. Yes, there are simply metric tonnes of hype. Yes, it is a bubble (tulip or canal, we don't yet know). Yeah, they do make up the darndest things. However, it's a new tool that's going to be used for a long time. Best to learn how to use it. 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 |
Using live data outside production is one of the fastest ways to create compliance risk, because it quickly becomes harder to control who can access it, how it is handled, and how long it is kept. A Test Data Management (TDM) approach provides exactly the kind of controls SOC 2 auditors look for in this situation: an automated, traceable end-to-end process for protecting, provisioning, and removing customer data so it can be used safely in non-production environments. |
| AI/Machine Learning/Cognitive Services |
If AI ambition inside your bank is starting to col... |
OpenAI says AI could disrupt jobs, taxes, and soci... |
Farewell, Anthropocene, we hardly knew ye. ?? AI i... |
We evolved for a linear world. If you walk for an ... |
The current conversation about AI in software deve... |
Meta launches Muse Spark, a new multimodal AI mode... |
A funny thing happened on the way to writing our b... |
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. Is fake grass a bad idea? The AstroTurf wars are far from over. In 2001, Americans installed just... |
Meta commits an additional $21 billion to CoreWeav... |
| Administration of SQL Server |
First Normal Form (1NF) is the most widely known rule in database normalization. It requires that tables contain no repeating groups and that each column holds atomic values. But, in real-world database systems, developers often intentionally break this rule when modeling complex data. Let’s find out why. |
Introduction These are my SQL Server Diagnostic In... |
Ten years (and a couple jobs) ago, I wrote about n... |
Part 5 in a series on evolving SQL Server environm... |
The short answer: in the real world, only the firs... |
Having TOP (1) return multiple rows feels wrong?... |
That is a harder problem than it looks, and most m... |
Two weeks ago I covered the Resource Governor chan... |
Sometimes along comes a feature that seems so obvi... |
Free SQL Server Performance Monitoring Blocking and Deadlocking Summary In this video, I delve into the blocking and deadlock monitoring capabilities of FreeSQL Server Performance Monitoring, a tool I’ve... |
LinkedIn is doing that thing again. 'Is SQL Server... |
Free SQL Server Performance Monitoring System Heal... |
| Career, Employment, and Certifications |
In my previous article, I discussed how to prepare for Microsoft certification exams. In this article, I’m covering what you should do when actually taking the exams. |
I sat down with Aaron Levie at the O’Reilly AI C... |
Amazon S3 Files makes S3 buckets accessible as hig... |
Steve visits Microsoft Data Platform MVP and data consultant Matt Gordon near his home in Lexington, KY. They discuss his love of making databases go faster, AI, the pros and cons of MS Fabric, data quality, community involvement, and much more. Plus, learn all about Matt’s passion for motorsport and what he currently races on the track. |
I am delighted to host this month’s T-SQL Tuesda... |
| Computing in the Cloud (Azure, Google, AWS) |
Pat Wright details how to plan cloud migration with minimal downtime. Learn key cutover strategies, testing methods, and critical questions to avoid data loss and system failure. |
The Microsoft Secure Boot certificate expires in 2... |
| Data Mining / Data Analysis |
Every organization I talk to has the same problem ... |
Asset and liability management (ALM) is still a co... |
| Database Design, Theory and Development |
Refactoring a production database is rarely just a... |
| DevOps and Continuous Delivery (CI/CD) |
Learning any kind of theory is easy, but adapting ... |
Working in DevOps, I’ve seen FinOps do amazing t... |
| DocumentDB/Key-Value/Graph/other NoSQL Databases |
Learn what MongoBleed (CVE-2025-14847) is, how the vulnerability leaks MongoDB server memory, which versions are affected, and how to protect your database.… The post Everything you need to know about... |
| ETL/SSIS/Azure Data Factory/Biml |
I knew what I was doing. I wrote the lifecycle man... |
| Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
Back in September 2024 I wrote a blog post on how ... |
LIVESTREAM DATE/TIME ??April 17th, 2026 (9:30 AM -... |
Thanks to Boris Novikov, who pointed me in the PAX... |
Introduction Every so often, I talk to someone... |
Hi, it’s me, back again with another update to p... |
Thanks to my colleague Ozair, who sent me a JIRA t... |
A practical blueprint for secure, private, high-performance AI systems Edge AI is having its inevitable moment. Not because the cloud is going away, but because reality keeps interrupting... |
In my first post about pgcollection, I introduced the collection type to address the challenge of migrating Oracle associative arrays keyed by strings to PostgreSQL. For integer-keyed associative arrays,... |
Recently, we encountered a production incident where PostgreSQL 16.8 became unstable, preventing the application from establishing database connections. The same behavior was independently reproduced in a separate test environment,... |
On 5th of April 2026, Andrew Dunstan committed patch: Add pg_get_database_ddl() function Add a new SQL-callable function that returns the DDL statements needed to recreate a database. It... |
| PowerPivot/PowerQuery/PowerBI |
Video by: Reid HavensHere's something that trips u... |
How to highlight a row based solely on the maximum... |
I recently got back from several conferences DataT... |
In this article, you’ll learn about SPL’s core syntax elements, its primary data structure (the table), and how to perform common data operations. By the end, you’ll understand how to write effective SPL code and how it compares to equivalent operations in Python. |
This is news: A malicious supply chain compromise ... |
Compare esProc SPL and Python for data analysis. Discover how esProc simplifies grouping, filtering, and data processing compared to Pandas.… The post Data analysis in Python and esProc SPL compared... |
Organizational safeguards are now generally availa... |
Google says that it will fully transition to post-... |
According to a new law, the Hong Kong police can d... |
AI is rapidly changing how software is written, de... |
ProPublica has a scoop: In late 2024, the federal government’s cybersecurity evaluators rendered a troubling verdict on one of Microsoft’s biggest cloud computing offerings. The tech giant’s “lack of proper detailed... |
Google says Gemini does not train on Gmail data, o... |
Scientists trained rat neurons for real-time compu... |
Samsung is rolling out blood pressure monitoring t... |
Ukraine is using ground robots and drones to cut c... |
Flying robots from AITHON Robotics are transformin... |
China is training humanoid robots in dedicated “... |
Intel has joined Elon Musk’s Terafab chip projec... |
IHMC unveils Alex, a disaster-ready humanoid robot... |
  | 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. |
|
|