Thom Pantazi

Deleting Child Data Based Upon Criteria in the Parent Table

New Author! Thom's first article discusses the difficulties you encounter when your database doesn't support cascading deletes (or you've opted not to use it) and you need to delete data in a child table based upon a value in the parent table. Not exactly your run of the mill delete query. Take a look and please rate/comment the article!

2003-06-24

5,258 reads

Blogs

Restoring Backups from Azure Blob with dbatools

By

Recently I needed to write a PowerShell script that could build a backup set...

Good to see you at Houston Tech Fest 2019!

By

It was awesome to see a great crowd at the triumphant return of Houston...

Using kubectl logs to read the SQL Server Error Log in Kubernetes

By

When working with SQL Server running containers the Error Log is written to standard...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Trying to create Nested SUM OVER Function for backwards running total.

By RocksteadyDev

Here is sample code from my running total, now I need to reverse it...

Copy or Move Shapshot Reports

By les.61

Hi We have snapshots on an old report that we would like to move...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The typo

See possible answers