Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

The Dangers of Dependencies

Many of us working with databases know the problems of a single point of failure. We build HA/DR technologies into a lot of systems precisely because many of us know if the database goes down, a lot of stuff goes down. Broken software is easier to fix and rollback, but a broken database can be a much bigger problems.

We also know an overloaded server doesn't handle a workload well, hence our quest for well-written SQL code, but we often lose that battle with developers.

In any case, as we move to a world where AI technology is used by many organizations, who often have a contract with a vendor to provide services, there is a potential issue. Imagine that you've setup workflows, maybe agentic loads and you depend on a company, say Anthropic, to provide those services. What if your organization gets banned?

That happened to a company (reported on Reddit). A user got a note from Anthropic, but his entire organization got banned. That's quite a dependency where a user in your company could cause an issue.

In some sense, that's like someone in your company sending an email that gets your organization's email blacklisted or has Google/Microsoft/etc. cutting off access. Imagine the disruption there?

Some of these companies providing AI services aren't that large, and aren't suited for the enterprise. Some of you are using vendors that might be contracting with these AI firms. Imagine your monitoring, DevOps, etc. vendor suddenly not working because they lost access to their AI services?

I'd like to assume this doesn't happen with the very large cloud vendors, but who knows. I'd like to think that not only enterprises, but even smaller companies don't lose access because of the actions of one person. Or if they do, there's any way way to get a response from customer service, but I also know that Google, Amazon, and Microsoft have made it harder to get an answer from a real person.

I didn't talk about this recently when presenting on local AI models, but I the future might be companies having more control over their AI tech, running them the same way we run servers in the cloud, in an IaaS, more responsible, but more controllable way.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 Featured Contents
SQLServerCentral Article

PASS Europe comes to Frankfurt

Steve Jones - SSC Editor from SQLServerCentral

PASS Europe comes to Frankfurt, Germany on June 10-11, 2026.

Stairway icons Database Deployments

Stairway to Reliable Database Deployments Level 2 - Defining the Deployment Contract

Massimo Preitano from SQLServerCentral

Level 2 formalizes the behavioral guarantees that a changeset must provide in order to be safely deployed and rolled back. It introduces the deployment contract, checkpoint semantics, and the structural scope of Create and Rollback scripts. Data changes are addressed through a dedicated Update mechanism, with clear boundaries and limitations. By the end of this level, a changeset becomes a predictable and well-defined unit that can be reasoned about independently of execution context.

External Article

SQL Server Table-Valued Parameter Join Issues in Stored Procedures

Additional Articles from MSSQLTips.com

Learn how table valued parameter joins in SQL Server stored procedures can negatively impact query performance.

Blog Post

From the SQL Server Central Blogs - Overview of Claude AI Models: Which One to Choose?

BLOB EATER from All About SQL

For those entering the AI space whether professionally or personally I wanted to give a quick overview on the different models on offer within the Claude family – when...

Blog Post

From the SQL Server Central Blogs - GenAI vs Dashboards: Not the Same (And Never Will Be)

James Serra from James Serra's Blog

There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric, and Fabric data agents become part of everyday conversations with customers: will GenAI replace reports...

Definitive Guide to DAX cover

The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel

Site Owners from SQLServerCentral

Now expanded and updated with modern best practices, this is the most complete guide to Microsoft’s DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization.

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Creating a JSON Document III

I have this data in a table called dbo.NFLTeams
TeamID  TeamName       City             YearEstablished
------  --------       ----             ---------------
1       Cowboys        Dallas           1960
2       Eagles         Philadelphia     1933
3       Packers        Green Bay        1919
4       Chiefs         Kansas City      1960
5       49ers          San Francisco    1946
6       Broncos        Denver           1960
7       Seahawks       Seattle          1976
8       Patriots       New England      1960
If I run this code, how many rows are returned?
SELECT TOP 2 
  json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

May the Fourth Be With You Fun

In honor of May the fourth and Star Wars (may the force be with you), finish this quote:

"Do, or do not.  ..."

Answer: There is no try

Explanation: Happy May Fourth! Ref:

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


Article Discussions by Author
SSC Spam - Comments posted to this topic are about the item SSC Spam
SQL Server 2022 - Development
BCA KCP Abdul Muis Telpon. 083135766741 - WhatsApp 083135766741 Gedung Graha Motor City, Jl. Abdul Muis No.24-26 Level I Suite 101, Petojo Sel., Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta 10160
BCA KCP Siantan Telp:Cs.083831618816 - WhatsApp:083831618816 Jl. Khatulistiwa No.16, Siantan Hilir, Kec. Pontianak Utara, Kota Pontianak, Kalimantan Barat 78242
BCA KCP Nusukan Telpon/wa:0821°8168°291 - BCA KCP Nusukan Telpon/wa:0821°8168°291.Jl. Kapten Piere Tendean No.79, Nusukan, Kec. Banjarsari, Kota Surakarta, Jawa Tengah 57135
BCA KCU BLOK A CIPETE Tlpn.0821•3111•185 - BCA KCU BLOK A CIPETE Tlpn.0821•3111•185 Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec. Cilandak, Kota Jakarta Selatan, Daerah Khusus Ibukota Jakarta 12410
BCA KCP Sawah Besar Telpon. 083135766741 - WhatsApp 083135766741 Jl. Sukarjo Wiryopranoto No.28 C, Kb. Klp., Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta 10120
BCA KCP Pare No.Telpon:083135765355 - Whatsapp:083135765355 Jl. Pb. Sudirman Jl. Raya Kediri - Pare No.2, Plongko, Pare, Kec. Pare, Kabupaten Kediri, Jawa Timur 64211
BCA KCP Pluit Mega Mal TLP/CS 08216977749 - Jl. Pluit Permai No.Raya 60, Pluit, Kecamatan Penjaringan, Jkt Utara, Daerah Khusus Ibukota Jakarta 14450
BCA KCP Sunda Mal Telp:Cs.08216977726 - Whatsapp:08216977726 Jl. Sunda No.50-54, Kb. Pisang, Kec. Sumur Bandung, Kota Bandung, Jawa Barat 40112
Cara membatalkan tiket pesawat Lion Air - Untuk membatalkan tiket Lion Air Anda bisa melalui WhatsApp resmi CS Lion Air di 62823-2461-4949, Atau hubungi Call Center Lion Air 0823-2461-4949 tersedia layanan 24jam Online.
BCA KCP Pejagalan Telpon. 083135766741 - WhatsApp 083135766741 Jl. Pejagalan I No.3, RT.10/RW.4, Pekojan, Kec. Tambora, Kota Jakarta Barat, Daerah Khusus Ibukota Jakarta 11240
BCA KCU KUNINGAN NO TELPON 087781685658 - Cyber 2, Gedung Menara Karya, WHATSAPP 087781685658 Jl. H. R. Rasuna Said Ground Floor, RT.7/RW.2, Kuningan, Kuningan Tim., Kecamatan Setiabudi, Kota Jakarta Selatan, Daerah Khusus Ibukota Jakarta 12950
BCA KCP Cempaka Putih Raya Telpon. 083135766741 - WhatsApp 083135766741 Jl. Cempaka Putih Raya No.118 B,C,D, Cemp. Putih Tim., Kec. Cemp. Putih, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta 10510
BCA KCU KUBU RAYA Telp:Cs.083831618816 - WhatsApp:083831618816 W979+XMQ, Jl. Arteri Supadio No.Kel, Sungai Raya, Kec. Sungai Raya, Kabupaten Kubu Raya, Kalimantan Barat 78391
BCA KCP Wates No.Telpon:083135765355 - Whatsapp:083135765355 Jl. Raya Tawang No.212, Tawang, Kec. Wates, Kabupaten Kediri, Jawa Timur 64174
 

 

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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

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