Technical Article

Quickly Reveal DB Recovery Model on all Databases.

I wrote this little tool out of the frustratingly slow process one must endure to find out what database Recovery Model your SQL 2000 databases are currently set to. This tool will quickly reveal whether your database Recovery model is set to either "Simple", "Full", or "Bulk-Logged." Who has time to manually pull up "Properties" […]

4 (1)

You rated this post out of 5. Change rating

2007-05-03 (first published: )

784 reads

Blogs

Calling a REST Endpoint from Azure SQL DB

By

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

Monday Monitor Tips – Adding Redgate Monitor Custom Metrics from SQLMonitorMetrics

By

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

Microsoft 365 Security and Compliance for Administrators, a Book Review

By

I was asked to review the following book by the publisher, and I must...

Read the latest Blogs

Forums

how can vs see SSIS under my regular user id but not my admin?

By stan

Hi, we run vs 2022.   I'm stumped how when i run VS as admin...

error in both ssis and ssms - something about losing connections - new error

By stan

hi for about 4 or 5 days now, i've been seeing various connections (to...

The Biggest Database Professional Challenges Today

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Biggest Database Professional Challenges...

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