Find DataBase Backup Modes
This is just a quick method to determine the backup mode of all databases on a server. No cursor involed.
2007-05-18 (first published: 2007-05-07)
413 reads
Find the database by table name
Here's the scenario: 1. You have been given a script to run.2. You do not know the database name.3. You know which server.Substitute the word "TABLENAME" with the table name in the script and run in query analyzer. This query will check every database on the server and return the name of the database with […]
2007-04-26 (first published: 2007-04-04)
460 reads
Blogs
Tales From The Field Weekly Wrap Up for the Week of 01-31-2023
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
Creating a Flyway Desktop Shadow Database in PostgreSQL
By Steve Jones
In order to generate migrations, we need to configure Flyway to use a shadow...
Daily Coping 6 Feb 2023
By Steve Jones
Today’s coping tip is to get back in contact with an old friend. This...
Forums
How do I learn C programming?
You must, first and foremost, be passionate about programming. There is a very good...
Future of SQL Server DBA Role
I would like to know what certifications or paths to choose in order to...
Extended Events shows each SQL command in one long line
Hi all, I created Extended Events session to capture sql_batch_completed for duration>5 sec sending...
Ask SSC