ABSOLUTE DATA EXCELLENCE

Ascent Technology Logo
Ascent Technology Logo

ABSOLUTE DATA EXCELLENCE

Ascent Technology Logo
VENDOR RELATIONSHIPS
FROM THE DESK OF THE MD
You Do Not Have a Data Estate. You Have Copies of One.

You Do Not Have a Data Estate. You Have Copies of One.

Every extract, warehouse load, import and vendor feed is another copy of the same data – stored again, secured differently, and billed monthly under a name nobody has given it yet.Key Takeaways The numbers disagree because the data was copied - When three reports from...

Data Sovereignty in South Africa Is Not an Address

The country is debating where its data should live. The organisations inside it are losing control of theirs one copy at a time – mostly to suppliers down the road.Key Takeaways Residency answers where. Sovereignty answers who - A data centre inside the border settles...

Four Microsoft Dates Before February. The Cost Is in the Calendar.

Four Microsoft dates between July and February decide what your estate will cost next year. None of them will say so on the invoice. The calendar is public – the question is who is reading yours.Key Takeaways Nothing will say price increase - Between July and...

You Do Not Have a Data Estate. You Have Copies of One.

Every extract, warehouse load, import and vendor feed is another copy of the same data – stored again, secured differently, and billed monthly under a name nobody has given it yet.Key Takeaways The numbers disagree because the data was copied - When three reports from...

Data Sovereignty in South Africa Is Not an Address

The country is debating where its data should live. The organisations inside it are losing control of theirs one copy at a time – mostly to suppliers down the road.Key Takeaways Residency answers where. Sovereignty answers who - A data centre inside the border settles...

Four Microsoft Dates Before February. The Cost Is in the Calendar.

Four Microsoft dates between July and February decide what your estate will cost next year. None of them will say so on the invoice. The calendar is public – the question is who is reading yours.Key Takeaways Nothing will say price increase - Between July and...

The Board Now Owns the Database

King V's Principle 10 has made the board accountable for an estate most boards have never seen. The paragraph in next year's report will not be the answer.Key Takeaways The word is accountable - Principle 10 does not ask the board to receive reports on data. It makes...

CAMPAIGNS
Azure by Credit Card vs CSP: Why Finance and IT Prefer CSP

Azure by Credit Card vs CSP: Why Finance and IT Prefer CSP

Still paying Microsoft for Azure by credit card? Discover why finance and IT leaders prefer the CSP model for predictable billing, built-in partner support, cost optimisation, and long-term value.Key Takeways Credit card billing creates risk - Failed or expired...

Prepare for SQL Server 2014 End of Support

On July 9, 2024, support for SQL Server 2014 ended. That means the end of regular security updates. Don't let your infrastructure and applications go unprotected. We're here to help you migrate to current versions for greater security, performance and innovation.We've...

Prepare for SQL Server 2012 End of Support

On July 12, 2022, support for SQL Server 2012 ended. That means the end of regular security updates. Don't let your infrastructure and applications go unprotected. We're here to help you migrate to current versions for greater security, performance and...

Azure by Credit Card vs CSP: Why Finance and IT Prefer CSP

Still paying Microsoft for Azure by credit card? Discover why finance and IT leaders prefer the CSP model for predictable billing, built-in partner support, cost optimisation, and long-term value.Key Takeways Credit card billing creates risk - Failed or expired...

Prepare for SQL Server 2014 End of Support

On July 9, 2024, support for SQL Server 2014 ended. That means the end of regular security updates. Don't let your infrastructure and applications go unprotected. We're here to help you migrate to current versions for greater security, performance and innovation.We've...

Prepare for Windows Server 2012 End of Support

On October 10, 2023, support for Windows Server 2012 and 2012 R2 ended. That means the end of regular security updates. Don't let your infrastructure and applications go unprotected. We're here to help you migrate to current versions for greater security, performance...

Prepare for SQL Server 2008 End of Support

On July 9, 2019, support for SQL Server 2008 and 2008 R2 will end. That means the end of regular security updates. Don't let your infrastructure and applications go unprotected. We're here to help you migrate to current versions for greater security, performance and...

NEWSFLASHES
SQL Server 2016 Support Has Ended – and the Rules Have Changed

SQL Server 2016 Support Has Ended – and the Rules Have Changed

Extended support for SQL Server 2016 ended on 14 July 2026. Without ESUs there are no more security updates – and this cycle, Microsoft has repriced the exit routes.The facts On 14 July 2026, SQL Server 2016 reached end of support. Mainstream support ended in July...

Season’s Greetings from the Ascent Technology Team

As the year draws to a close, we would like to express our appreciation to our clients, partners, and colleagues for the trust and collaboration that have defined the year. We wish you and your teams a restful festive season and a successful year ahead, and we look...

Ascent’s SQL Server 2025 Blog Post Series

Microsoft SQL Server 2025 marks an important shift in how organisations modernise, optimise, and protect their data platforms. As data estates become more hybrid, more intelligent, and more tightly governed, SQL Server 2025 is no longer just another upgrade cycle. It...

SQL Server 2016 Support Has Ended – and the Rules Have Changed

Extended support for SQL Server 2016 ended on 14 July 2026. Without ESUs there are no more security updates – and this cycle, Microsoft has repriced the exit routes.The facts On 14 July 2026, SQL Server 2016 reached end of support. Mainstream support ended in July...

Season’s Greetings from the Ascent Technology Team

As the year draws to a close, we would like to express our appreciation to our clients, partners, and colleagues for the trust and collaboration that have defined the year. We wish you and your teams a restful festive season and a successful year ahead, and we look...

Microsoft Tiered EA/MPSA Pricing Ends – Explore the CSP Advantage

Standardised pricing will replace Microsoft’s long-standing tiered discount model - prompting many organisations to review the CSP programme for its cost savings, licensing flexibility, and simplified management.Microsoft Tiered EA/MPSA Pricing Ends Microsoft will...

Season’s Greetings from the Ascent Technology Team

As we wrap up the year, we’d like to extend our sincere thanks to our clients, colleagues, and partners for your continued trust and support. We hope the festive season brings you the chance to slow down, recharge, and enjoy time with family and friends. Warm wishes...

CLIENT CASE STUDIES
DB Administration, Security and Compliance for First Distribution

DB Administration, Security and Compliance for First Distribution

First Distribution’s Database Administration, Security and Compliance needs lead it to trusted advisor, Ascent Technology. For any large organisation, Database Administration (DBA) is a vital part of maintaining their Data Platform Operations effectively. As it has...

Ascent Technology helps Bidfood SA migrate to Microsoft Azure

When Bidfood SA chose to modernise and migrate its data platform to Microsoft Azure, it turned to Ascent Technology for help. In a world that is digitally transforming, it is more vital than ever to an organisation’s success to utilise the latest platforms to drive...

Ascent Technology helps migrate Phumelela Gaming to Azure

A Windows Server and SQL Server consolidation, optimisation and migration to Microsoft Azure enables the company to reduce costs, modernise its data platform and boost its innovation capabilities. As an operator running two distinct betting businesses, Phumelela...

DB Administration, Security and Compliance for First Distribution

First Distribution’s Database Administration, Security and Compliance needs lead it to trusted advisor, Ascent Technology. For any large organisation, Database Administration (DBA) is a vital part of maintaining their Data Platform Operations effectively. As it has...

Ascent Technology helps Bidfood SA migrate to Microsoft Azure

When Bidfood SA chose to modernise and migrate its data platform to Microsoft Azure, it turned to Ascent Technology for help. In a world that is digitally transforming, it is more vital than ever to an organisation’s success to utilise the latest platforms to drive...

Ascent helps migrate Compatible Automotive to Azure

Microsoft Azure Data Platform Services not only boosts the company’s DR facilities, it also helps them deliver value-added services and innovative strategic solutions to its customers. In a digitising world, it comes as no surprise to learn that Compatible Automotive...

AWARDS AND ACCOLADES
Microsoft Data and Analytics Partner of the Year Finalist

Microsoft Data and Analytics Partner of the Year Finalist

Ascent Technology continues its strong showing in the Microsoft Partner of the Year awards, as a finalist in the Data and Analytics Partner of the Year award.Finalist Data and Analytics Partner of the Year "It is always gratifying to be recognised by Microsoft as one...

Microsoft Data and Analytics Partner of the Year Finalist

Ascent Technology continues its strong showing in the Microsoft Partner of the Year awards, as a finalist in the Data and Analytics Partner of the Year award.Finalist Data and Analytics Partner of the Year "It is always gratifying to be recognised by Microsoft as one...

Microsoft Data and Analytics Partner of the Year Finalist

Ascent Technology continues its strong showing in the Microsoft Partner of the Year awards, as a finalist in the Data and Analytics Partner of the Year award.Finalist Data and Analytics Partner of the Year "It is always gratifying to be recognised by Microsoft as one...

From the Desk of the MD

Every Agent is a Database User

The agents arriving in South African estates this year are not a new kind of risk. They are the oldest one – a login with more permission than anyone approved – running at machine speed.

Key Takeaways

  • An agent is a login – Strip away the vocabulary and an AI agent reaches your data the way everything else does: through a credential, with whatever permission that credential carries. The question is thirty years old. The thing asking it now acts at machine speed.
  • The registry is the easy part – The platforms will tell you which agents exist. What each may read, change or delete inside a database was decided by whoever granted the login – and in most estates that decision was never taken deliberately.
  • Non-human identities already outnumber you – Forty-five to one, one in twenty with full administrative rights, half of organisations unable to say who owns them. Agents arrive on top of service accounts nobody has reviewed.
  • The prompt is not a control – A production database and its backups were deleted in nine seconds this April because a token could; the agent’s instructions said it should not. Permission decided the outcome: there a platform token, in your estate the login on the database.
  • Four questions need no new platform – Which non-human identities reach each database and who owns them; what each can write, not only read; when each access expires; who reviews the log. A board can ask all four this quarter.
Microsoft Ignite opens in San Francisco on 17 November, and one subject runs through its security programme. Agents, Microsoft says, are “your newest insiders”; they “now act with real access to your identities, your data, and your cloud”, and “every adoption decision is a trust decision”. The sessions ask whether access controls are ready for agents at scale, and whether you can find those running on staff laptops.

The conversation about AI agent governance is the right one, and it is being held one layer too high. At the database an agent is not a new kind of thing. It is a login.

Whether it connects directly or through an application, it arrives at the engine as a login – its own, or the application’s, which is usually worse – and it is served exactly as a person at a keyboard would be, with whatever permission that login holds. The question has sat on a DBA’s desk for thirty years. What is new is the speed – and that most estates never answered it for the logins they already had.

Three Hundred and Seventy-Five

South Africa is not starting from a clean estate. The Information Regulator received 1,220 security-compromise notifications in the first five months of this financial year – roughly 240 a month, with more than 3,000 projected – and attributes them to weak passwords, human error and “inadequate security controls”. Sophos’s study of 135 South African organisations hit by ransomware found that in 85 percent of cases the attack and the organisation’s most serious identity compromise were the same event.

The credential is already how data leaves this country. An agent is another credential.

October gave the point a number. A pathology laboratory group disclosed an attack; the attacker claimed to have copied ten of what it said were roughly 375 databases, one admissions table alone holding more than 80 million records. The group’s own statement was measured and, I think, accurate: the figure counts records, not patients; no clinical results appear to have been taken; an application vulnerability has been fixed.

If the count is even roughly right, it is an ordinary one for an organisation of that size – which is the point.

How many boards could say which logins reach each of theirs?

Newest Insiders

Microsoft has already described what Ignite will put on stage. Its identity leadership wrote in October that an agent should start with no authority and receive only what the approved task needs, scoped and time-bound, with higher-impact actions held for a verified human. It does not inherit the permissions of the employee who sponsors it. Assume it can fail or be compromised, and build controls that do not depend on the model behaving.

The practitioner guidance Microsoft published in July is more specific. Treat every agent as a principal in its own right, with a dedicated identity rather than a shared secret or a reused service account. Separate what it may read from what it may write.

Prefer short-lived elevation to standing access, because “temporary access that lacks an expiry mechanism becomes permanent access in practice”. Log the agent, its scope and the person it acted for, because “logging only the LLM response creates an audit trail that looks present but is useless for forensics”.

Every one of those is a permissions sentence – a login, a role, a grant, an expiry, an audit. None of it is new to anyone who has run a database estate. In the estates I see, almost none of it has been done.

One preview of Ignite put the gap precisely: “an agent registry is the easy part; deciding what each agent is allowed to see is where the work sits”. That decision is taken where the data is, by whoever holds the keys to the engine – usually years ago, for something else.

Forty-Five to One

The Cloud Security Alliance collected the numbers in May. Non-human identities – service accounts, API keys, integration logins, and now agents – outnumber people forty-five to one in the average enterprise and 144 to one in cloud-native estates. One in twenty holds full administrative rights. Half of organisations cannot say who owns their AI or agent identities; 78 percent have no documented process for creating or retiring them. The paper’s own summary of the lifecycle problem: “The agent is gone; the credential is not.”

Agents are joining that population fast – active agents in Microsoft 365 are up fifteen-fold in a year, on Microsoft’s own telemetry – and Gartner expects 40 percent of enterprises to have demoted or decommissioned autonomous agents by 2027 because of governance gaps found only after a production incident. Found, that is, the way most permission problems are found.

Nine Seconds

The reference incident of the year is small, well documented and entirely about permission.

In April a start-up’s coding agent hit a credential mismatch in a staging environment and set about fixing it. It found an API token in an unrelated file, “guessed” – its own word afterwards – that deleting a storage volume would be scoped to staging, and called the delete endpoint. The volume held the production database and its backups. “It took 9 seconds,” the founder wrote. The token had been created to manage custom domains; the platform offered no way to narrow it, so it could do anything.

The agent’s instructions – the tool’s system prompt and the project’s own rules – said no destructive action without asking. It acted anyway, and admitted as much. The hosting provider’s chief executive put the other side with a candour I respect: “if you (or your agent) authenticate, and call delete, we will honor that request.” The data was restored within the hour once he stepped in, and the legacy endpoint the agent had called, which lacked the delayed-delete safeguard the provider’s newer ones carry, was patched within days.

The lesson had already been taught.

A prompt is a policy the model is asked to enforce. A permission is a policy the system enforces for you, every time, at any speed. When the two disagree, the permission wins – which is why governance has to live there.

There is more than one such place. The permission that matters sits wherever the data can be reached – the login on the database, the identity the application connects with, the platform token that can delete the volume underneath it all. The database is the last of these, and the one most estates have never reviewed.

I have seen the same shape for years without an agent anywhere near it. An application login created in 2014 as db_owner because the installer asked for it, still db_owner on the database that now holds every customer’s identity number. A scheduled job running as sysadmin because it always has, owned by a consultant who left in 2019. A service account whose password sits in a configuration file the whole company can read, used by three systems, one of them decommissioned.

Point an agent at that estate and you have not introduced a new risk. You have introduced a user who never sleeps to a privilege nobody has reviewed.

The right pattern exists and is not exotic. The best demonstration I read this year was a database administrator building an agent to diagnose a SQL Server estate: a login with view-server-state and read rights only, an allowlist every statement must pass before it reaches the engine, and one standing instruction – “You detect and report; you never remediate.”

“The model never touches the database.” Every control in that design is enforced outside the model – a login, an allowlist, a human in the path for anything that changes state. It is April’s lesson, built in from the start.

On Whose Behalf

A permission settles a second thing: accountability. Here the agent complicates matters.

When an agent acts under a person’s delegated access, the log shows the person. When it acts under a shared service account, the log shows the account. In neither case does anyone later know whether a human decided or software decided on their behalf – the distinction Microsoft’s own guidance insists the audit trail must preserve.

King V asks the board for human oversight and override of AI. POPIA is blunter: for processing it decides on, the responsible party is the organisation. Not the vendor, not the model, not the agent.

After an incident nobody asks what the software recommended. They ask who approved what it did – and at the database that answer is a grant with a name on it, or it is nothing.

Gartner’s four levels of agent autonomy – observe, advise, act with approval, act autonomously – map almost exactly onto database privilege: read only; read and propose; write with a human in the path; write freely. Most of the estates I have looked into grant the fourth level to things that needed the first. The fastest test is to list every login that is not a person and ask what each can delete.

Four Questions

None of this waits for a platform announcement. A board, or the committee it delegates to, can ask four questions this quarter and expect answers within a month.

Which identities that are not people can reach each database holding personal information, and who owns each one? The list will contain service accounts, integration logins, scheduled jobs and reporting connections before it contains a single agent, and the owner column will have gaps.

What can each of them change, not merely read? Anything that is not a person and holds sysadmin, db_owner or the equivalent needs a reason in writing, and most will not have one.

When does each access expire? Standing access with no end date is, in Microsoft’s phrase, permanent access in practice. Agents given task-bound credentials by design may end up better governed than the integrations installed a decade ago.

Who reviews the log, and does it record on whose behalf the action was taken? A log that shows only the account answers no question an incident will ask.

Ignite will bring registries, conditional access for agents, risk scores that move with behaviour, and sandboxes that keep the controls out of the model’s reach. Every one of those instruments assumes that, at the end of the chain, someone has set the permission on the database correctly. That someone is the customer, and the work does not wait for a keynote.

Agents are already in the data. The question in eighteen months is, for each one, what it was allowed to do – and whether that was the same as what it could.

The Last Word

I have spent my working life around database estates, and the pattern has not changed in thirty years: access is granted in a hurry and reviewed never. Agents will not change the pattern. They will run it at machine speed.

The organisations that treat every agent as the database user it is – a login with an owner, a scope, an expiry and a log – will adopt agents faster than the ones waiting for a platform to do it for them, because they will have an answer when the Regulator’s question arrives. Who had access, and who approved it.