Patty Dunbar


Technical Article

Full, diff and tlog backups based on recovery mode

    This a script which creates stored procedures that can be executed adhoc or set as sql agent jobs to check the recovery status and generate full, differential or transaction log backupf for each database if the database recovery status is set to full.  We have terabytes of data and set all production databases […]

You rated this post out of 5. Change rating

2003-06-06

927 reads

Technical Article

List all the associated tables for a view

I had recent request for a script to list all the views for a database along with the associated tables the columns depend on. It is a rather simple script but as I have not seen a similar one, I thought I would share it with my fellow dbas. It returns information about views specific […]

You rated this post out of 5. Change rating

2003-01-23

453 reads

Technical Article

Script to obtain datadictionary from a SQL2000 db

This script creates a stored procedure that, when executed, queries the system tables of any SQL2000 database to return a complete, ordered datadictionary. *Warning**This script only works on tables which have the description property filled out as my main purpose was to query the extended property description feature new to SQL2000. If you have not […]

You rated this post out of 5. Change rating

2001-08-27

3,117 reads

Blogs

Updating SSMS is Easy (w/ v21)

By

I’ve been using the SSMS preview for v21. This is the next evolution of...

Execute Fabric Data Pipeline from Azure Data Factory

By

In the blog post Call a Fabric REST API from Azure Data Factory I...

Master SQL Server Query Tuning in Just Two Days! Online Live Training – June 17 – 18, 2025

By

I’m excited to announce that on June 17 – 18, 2025, I’ll be running...

Read the latest Blogs

Forums

importing from PowerQuery... but with multiple powerqueries

By pietlinden

I finally got the PowerQuery source to "show" in SSIS (so I can see...

Third party backup softwares

By ashrukpm

Hi Team, Can you someone suggest a few good third part backup tools, with...

2022 SSIS PackageFormatVersion?

By TG

Recently I upgraded my ssis package from 2016 to 2022, but package format version...

Visit the forum

Question of the Day

The Monitor Server

What does the monitor server do in log shipping?

See possible answers