Andy Warren

I started my SQL journey here at SQLServerCentral as one of the founders, helping to build a place to share and learn that continues to thrive under the editorial guidance of my friend Steve Jones. I've done a lot of volunteer work over the years ranging from our local SQL group (oPASS, SQLOrlando) to serving on the Board of Directors of PASS to designing and building the framework of SQLSaturday (which has gone on to produce more than 1000 locally managed events since we started in 2007). These days I manage a DBA team, but over the years I've been a trainer, consultant, contractor, and DBA. I'm rarely present on social media, the best way to contact me is here, LinkedIn, or via email.

SQLServerCentral Article

Executing Multiple Scripts in a Folder using the ScriptRunner Utility

Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.

You rated this post out of 5. Change rating

2001-06-14

10,210 reads

Blogs

AI and Data Engineering on the Edge: The Good, the Bad, and the Overhyped

By

Running AI and data pipelines on the edge instead of the cloud has gone...

UNION vs UNIONALL: #SQLNewBlogger

By

While writing another post I realized my UNION query didn’t work as one might...

Deciphering Data Architectures Is Now Available in Multiple Languages

By

Since the release of my book Deciphering Data Architectures: Choosing Between a Modern Data...

Read the latest Blogs

Forums

Replacing Maintenance tasks now using SSMS 22 - what to do with File operations

By terry999

Unfortunately I'm using SSMS 22. It didn't come with maintenance plans by default. I...

Secure Cached Plans

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Secure Cached Plans

Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Complex Data Processing with dbt...

Visit the forum

Question of the Day

Secure Cached Plans

The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?

See possible answers