Theo Ekelmans

  • Interests: SQL, Hardware... especially if it comes in TBs, Anything written by Sir Terry Patchett, IOT, dabbeling in C#...... aaaand, ill stop here :)

Technical Article

Version independent spGetBackupDateFromFile

This is an version independent stored procedure to get the backup date from a backup file.

It's tested for SQL 2005, 2008(R2), 2012 and 2014.

Consider it a template to which you can add more output parameters from the headerinfo to meet your requirements.

You rated this post out of 5. Change rating

2016-04-21 (first published: )

350 reads


7 Best Online Advanced SQL Training Courses to Learn in 2024


The world runs on data, and SQL is the key to unlocking its secrets....

Calling a REST Endpoint from Azure SQL DB


External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas...

Monday Monitor Tips – Adding Redgate Monitor Custom Metrics from SQLMonitorMetrics


This post talks about adding custom metrics from the site automatically and how...

Read the latest Blogs


Issues adding and updating a column

By richardmgreen1

Hi all   I'm hoping someone will able to say "you're an idiot because....."...

Deadlocks with UPDATE statements using serializable transaction isolation level

By zoggling

We are seeing frequent deadlocks occurring due to a particular stored procedure that is...

Use Polybase with ODBC to create external table

By blom0344

I'm trying to use the installed Polybase service on an  SQL 2019 server to...

Visit the forum

Question of the Day

The Last DBCC Date

How can I easily get the last DBCC CheckDB date from T-SQL in SQL Server 2022?

See possible answers