AndreasSchubert

I architect the invisible engines of progress - where data drives decisions, automation fuels momentum and intelligence scales with purpose.

My journey in tech began as a part-time network administrator at my university, where I gained hands-on experience managing systems and infrastructure. That early exposure led me into software development, and it was there that I discovered a lasting passion for databases - especially SQL Server.

Since 2003, I’ve worked independently as a SQL Server specialist, helping companies design, optimize, and maintain data platforms that support critical business operations. My expertise spans traditional on-premises environments as well as modern cloud ecosystems, including Azure, AWS, and hybrid architectures - allowing me to deliver scalable, secure, and future-ready solutions.

By 2007, my role had evolved from database-centric work to full-scale solution architecture. I’ve since designed and implemented complex systems across industries such as media & broadcast, finance, and goods production—where databases are just one component of a much larger, integrated landscape. Whether aligning infrastructure with business goals or orchestrating cross-functional workflows, I thrive on solving multifaceted challenges that demand both technical precision and strategic vision.

I hold multiple certifications that reflect both depth and breadth: Windows Server, SQL Server, PRINCE2, ITIL, and agile credentials as a certified Product Owner and Scrum Master. This combination enables me to operate effectively across development, operations, and leadership domains—bringing clarity, structure, and momentum to every engagement.

I’m also deeply involved in the AI space, evaluating how intelligent systems interact with enterprise data. A growing concern I’ve voiced is the tendency of organizations to grant database access to managed identities or principals without properly respecting the scope and intent of the requestor. This governance gap can lead to serious security and compliance risks, as I’ve outlined in a LinkedIn post.

And above all, I’m a huge fan of automation. I’ve written countless sophisticated PowerShell scripts to streamline complex workflows, eliminate manual effort, and ensure consistency across environments—because smart automation isn’t just efficient, it’s transformative.

All authors

It seems we can’t find what you’re looking for. Perhaps searching can help.

Blogs

Runing tSQLt Tests with Claude

By

Running tSQLt unit tests is great from Visual Studio but my development workflow...

Getting Your Data GenAI-Ready: The Next Stage of Data Maturity

By

I remember a meeting where a client’s CEO leaned in and asked me, “So,...

Learn Better: Pause to Review More

By

If you want to learn better, pause more in your learning to intentionally review.

Read the latest Blogs

Forums

Azure SQL DBA certification

By ashrukpm

Hello team Can anyone share popular azure SQL DBA certification exam code? and your...

Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Faster Data Engineering with Python...

Which Result II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Which Result II

Visit the forum

Question of the Day

Which Result II

I have this code in SQL Server 2022: 

CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
    ProductID INT,
    ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
    ProductID INT,
    ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
    exec('SELECT ProductName FROM product;')
END;
GO
exec etl.GettheProduct
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned?

See possible answers